Overview

Dataset statistics

Number of variables9
Number of observations150
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.3 KiB
Average record size in memory76.9 B

Variable types

Numeric4
Categorical4
DateTime1

Alerts

UPPER_CTGRY_NM has constant value ""Constant
LWPRT_CTGRY_NM has constant value ""Constant
REPRSNT_KWRD_NM is highly overall correlated with SEQ_NO and 1 other fieldsHigh correlation
SRCHWRD_NM is highly overall correlated with SEQ_NO and 1 other fieldsHigh correlation
SEQ_NO is highly overall correlated with REPRSNT_KWRD_NM and 1 other fieldsHigh correlation
MOBILE_SCCNT_VALUE is highly overall correlated with PC_SCCNT_VALUE and 1 other fieldsHigh correlation
PC_SCCNT_VALUE is highly overall correlated with MOBILE_SCCNT_VALUE and 1 other fieldsHigh correlation
SCCNT_SM_VALUE is highly overall correlated with MOBILE_SCCNT_VALUE and 1 other fieldsHigh correlation
SEQ_NO has unique valuesUnique

Reproduction

Analysis started2023-12-10 10:10:31.041766
Analysis finished2023-12-10 10:10:34.763020
Duration3.72 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

SEQ_NO
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct150
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean759282.15
Minimum666208
Maximum856297
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.4 KiB
2023-12-10T19:10:34.890719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum666208
5-th percentile680168.45
Q1733871.25
median763277.5
Q3776335.75
95-th percentile856289.55
Maximum856297
Range190089
Interquartile range (IQR)42464.5

Descriptive statistics

Standard deviation53847.816
Coefficient of variation (CV)0.070919375
Kurtosis-0.34841617
Mean759282.15
Median Absolute Deviation (MAD)29392
Skewness0.25590039
Sum1.1389232 × 108
Variance2.8995872 × 109
MonotonicityNot monotonic
2023-12-10T19:10:35.143115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
680168 1
 
0.7%
774414 1
 
0.7%
776340 1
 
0.7%
733881 1
 
0.7%
856287 1
 
0.7%
856288 1
 
0.7%
763274 1
 
0.7%
776341 1
 
0.7%
774415 1
 
0.7%
733882 1
 
0.7%
Other values (140) 140
93.3%
ValueCountFrequency (%)
666208 1
0.7%
666209 1
0.7%
666210 1
0.7%
666211 1
0.7%
666212 1
0.7%
666213 1
0.7%
666214 1
0.7%
680168 1
0.7%
680169 1
0.7%
680170 1
0.7%
ValueCountFrequency (%)
856297 1
0.7%
856296 1
0.7%
856295 1
0.7%
856294 1
0.7%
856293 1
0.7%
856292 1
0.7%
856291 1
0.7%
856290 1
0.7%
856289 1
0.7%
856288 1
0.7%

UPPER_CTGRY_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
문화시설
150 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row문화시설
2nd row문화시설
3rd row문화시설
4th row문화시설
5th row문화시설

Common Values

ValueCountFrequency (%)
문화시설 150
100.0%

Length

2023-12-10T19:10:35.376384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:10:35.532939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
문화시설 150
100.0%

LWPRT_CTGRY_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
도서
150 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row도서
2nd row도서
3rd row도서
4th row도서
5th row도서

Common Values

ValueCountFrequency (%)
도서 150
100.0%

Length

2023-12-10T19:10:35.726935image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:10:35.890236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
도서 150
100.0%

REPRSNT_KWRD_NM
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
노원정보도서관
30 
강북문화정보도서관
30 
동탄복합문화센터도서관
30 
춘천시립도서관
30 
마포중앙도서관
30 

Length

Max length11
Median length7
Mean length8.2
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row노원정보도서관
2nd row강북문화정보도서관
3rd row동탄복합문화센터도서관
4th row춘천시립도서관
5th row마포중앙도서관

Common Values

ValueCountFrequency (%)
노원정보도서관 30
20.0%
강북문화정보도서관 30
20.0%
동탄복합문화센터도서관 30
20.0%
춘천시립도서관 30
20.0%
마포중앙도서관 30
20.0%

Length

2023-12-10T19:10:36.249616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:10:36.517626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
노원정보도서관 30
20.0%
강북문화정보도서관 30
20.0%
동탄복합문화센터도서관 30
20.0%
춘천시립도서관 30
20.0%
마포중앙도서관 30
20.0%

SRCHWRD_NM
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
노원정보도서관
30 
강북문화정보도서관
30 
동탄복합문화센터도서관
30 
춘천시립도서관
30 
마포중앙도서관
30 

Length

Max length11
Median length7
Mean length8.2
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row노원정보도서관
2nd row강북문화정보도서관
3rd row동탄복합문화센터도서관
4th row춘천시립도서관
5th row마포중앙도서관

Common Values

ValueCountFrequency (%)
노원정보도서관 30
20.0%
강북문화정보도서관 30
20.0%
동탄복합문화센터도서관 30
20.0%
춘천시립도서관 30
20.0%
마포중앙도서관 30
20.0%

Length

2023-12-10T19:10:36.785630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:10:37.006883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
노원정보도서관 30
20.0%
강북문화정보도서관 30
20.0%
동탄복합문화센터도서관 30
20.0%
춘천시립도서관 30
20.0%
마포중앙도서관 30
20.0%

MOBILE_SCCNT_VALUE
Real number (ℝ)

HIGH CORRELATION 

Distinct118
Distinct (%)78.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean310.81333
Minimum88
Maximum512
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.4 KiB
2023-12-10T19:10:37.255138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum88
5-th percentile191.8
Q1252.75
median310.5
Q3357.75
95-th percentile462.75
Maximum512
Range424
Interquartile range (IQR)105

Descriptive statistics

Standard deviation80.150646
Coefficient of variation (CV)0.2578739
Kurtosis-0.027192197
Mean310.81333
Median Absolute Deviation (MAD)52
Skewness0.17930488
Sum46622
Variance6424.126
MonotonicityNot monotonic
2023-12-10T19:10:37.504872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
305 3
 
2.0%
377 3
 
2.0%
356 3
 
2.0%
243 2
 
1.3%
282 2
 
1.3%
263 2
 
1.3%
259 2
 
1.3%
234 2
 
1.3%
334 2
 
1.3%
235 2
 
1.3%
Other values (108) 127
84.7%
ValueCountFrequency (%)
88 1
0.7%
146 1
0.7%
153 1
0.7%
163 1
0.7%
167 1
0.7%
176 1
0.7%
179 1
0.7%
190 1
0.7%
194 1
0.7%
195 2
1.3%
ValueCountFrequency (%)
512 1
0.7%
503 1
0.7%
493 1
0.7%
479 1
0.7%
475 1
0.7%
471 1
0.7%
469 1
0.7%
465 1
0.7%
460 1
0.7%
451 1
0.7%

PC_SCCNT_VALUE
Real number (ℝ)

HIGH CORRELATION 

Distinct79
Distinct (%)52.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean80.66
Minimum29
Maximum184
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.4 KiB
2023-12-10T19:10:37.768723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum29
5-th percentile36
Q154.5
median83
Q3102
95-th percentile125.65
Maximum184
Range155
Interquartile range (IQR)47.5

Descriptive statistics

Standard deviation30.961078
Coefficient of variation (CV)0.38384673
Kurtosis0.41614049
Mean80.66
Median Absolute Deviation (MAD)22
Skewness0.531636
Sum12099
Variance958.58832
MonotonicityNot monotonic
2023-12-10T19:10:38.026010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 6
 
4.0%
105 5
 
3.3%
50 4
 
2.7%
86 4
 
2.7%
62 4
 
2.7%
63 4
 
2.7%
91 3
 
2.0%
85 3
 
2.0%
83 3
 
2.0%
109 3
 
2.0%
Other values (69) 111
74.0%
ValueCountFrequency (%)
29 1
 
0.7%
30 2
1.3%
31 1
 
0.7%
34 2
1.3%
35 1
 
0.7%
36 3
2.0%
37 1
 
0.7%
38 2
1.3%
39 1
 
0.7%
41 1
 
0.7%
ValueCountFrequency (%)
184 1
0.7%
173 2
1.3%
156 1
0.7%
139 1
0.7%
138 1
0.7%
131 1
0.7%
127 1
0.7%
124 1
0.7%
123 2
1.3%
120 1
0.7%

SCCNT_SM_VALUE
Real number (ℝ)

HIGH CORRELATION 

Distinct120
Distinct (%)80.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean391.47333
Minimum117
Maximum685
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.4 KiB
2023-12-10T19:10:38.270419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum117
5-th percentile236.35
Q1329
median382.5
Q3439.75
95-th percentile576.85
Maximum685
Range568
Interquartile range (IQR)110.75

Descriptive statistics

Standard deviation101.39323
Coefficient of variation (CV)0.25900417
Kurtosis0.43910464
Mean391.47333
Median Absolute Deviation (MAD)56
Skewness0.35347843
Sum58721
Variance10280.587
MonotonicityNot monotonic
2023-12-10T19:10:38.573683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
373 3
 
2.0%
358 3
 
2.0%
329 3
 
2.0%
372 3
 
2.0%
313 2
 
1.3%
421 2
 
1.3%
279 2
 
1.3%
352 2
 
1.3%
362 2
 
1.3%
407 2
 
1.3%
Other values (110) 126
84.0%
ValueCountFrequency (%)
117 1
0.7%
183 1
0.7%
193 1
0.7%
198 1
0.7%
204 1
0.7%
220 1
0.7%
224 1
0.7%
235 1
0.7%
238 2
1.3%
244 1
0.7%
ValueCountFrequency (%)
685 1
0.7%
677 1
0.7%
652 1
0.7%
616 1
0.7%
594 1
0.7%
586 1
0.7%
585 1
0.7%
580 1
0.7%
573 1
0.7%
571 1
0.7%

SCCNT_DE
Date

Distinct30
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
Minimum2021-01-01 00:00:00
Maximum2021-01-31 00:00:00
2023-12-10T19:10:38.850303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:39.077839image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)

Interactions

2023-12-10T19:10:33.706118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:31.506818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:32.329565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:32.965816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:33.842071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:31.675478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:32.494067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:33.167023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:33.992201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:31.840843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:32.649634image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:33.370493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:34.142299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:32.085118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:32.813897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:33.540762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T19:10:39.242840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SEQ_NOREPRSNT_KWRD_NMSRCHWRD_NMMOBILE_SCCNT_VALUEPC_SCCNT_VALUESCCNT_SM_VALUESCCNT_DE
SEQ_NO1.0000.9290.9290.4380.2440.5150.205
REPRSNT_KWRD_NM0.9291.0001.0000.3880.4450.6180.000
SRCHWRD_NM0.9291.0001.0000.3880.4450.6180.000
MOBILE_SCCNT_VALUE0.4380.3880.3881.0000.7110.9690.438
PC_SCCNT_VALUE0.2440.4450.4450.7111.0000.8620.583
SCCNT_SM_VALUE0.5150.6180.6180.9690.8621.0000.353
SCCNT_DE0.2050.0000.0000.4380.5830.3531.000
2023-12-10T19:10:39.497687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
REPRSNT_KWRD_NMSRCHWRD_NM
REPRSNT_KWRD_NM1.0001.000
SRCHWRD_NM1.0001.000
2023-12-10T19:10:40.286472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SEQ_NOMOBILE_SCCNT_VALUEPC_SCCNT_VALUESCCNT_SM_VALUEREPRSNT_KWRD_NMSRCHWRD_NM
SEQ_NO1.0000.3590.0080.2920.6280.628
MOBILE_SCCNT_VALUE0.3591.0000.5090.9620.1670.167
PC_SCCNT_VALUE0.0080.5091.0000.7020.1850.185
SCCNT_SM_VALUE0.2920.9620.7021.0000.2970.297
REPRSNT_KWRD_NM0.6280.1670.1850.2971.0001.000
SRCHWRD_NM0.6280.1670.1850.2971.0001.000

Missing values

2023-12-10T19:10:34.341114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:10:34.673072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

SEQ_NOUPPER_CTGRY_NMLWPRT_CTGRY_NMREPRSNT_KWRD_NMSRCHWRD_NMMOBILE_SCCNT_VALUEPC_SCCNT_VALUESCCNT_SM_VALUESCCNT_DE
0680168문화시설도서노원정보도서관노원정보도서관153512042021-01-01
1666208문화시설도서강북문화정보도서관강북문화정보도서관163301932021-01-01
2685495문화시설도서동탄복합문화센터도서관동탄복합문화센터도서관225342592021-01-01
3723993문화시설도서춘천시립도서관춘천시립도서관195432382021-01-01
4686400문화시설도서마포중앙도서관마포중앙도서관88291172021-01-01
5666209문화시설도서강북문화정보도서관강북문화정보도서관240462862021-01-02
6686401문화시설도서마포중앙도서관마포중앙도서관176442202021-01-02
7685496문화시설도서동탄복합문화센터도서관동탄복합문화센터도서관436845202021-01-02
8723994문화시설도서춘천시립도서관춘천시립도서관338383762021-01-02
9680169문화시설도서노원정보도서관노원정보도서관244813252021-01-02
SEQ_NOUPPER_CTGRY_NMLWPRT_CTGRY_NMREPRSNT_KWRD_NMSRCHWRD_NMMOBILE_SCCNT_VALUEPC_SCCNT_VALUESCCNT_SM_VALUESCCNT_DE
140776349문화시설도서마포중앙도서관마포중앙도서관425644892021-01-30
141763282문화시설도서노원정보도서관노원정보도서관320633832021-01-30
142774423문화시설도서동탄복합문화센터도서관동탄복합문화센터도서관318383562021-01-30
143856296문화시설도서춘천시립도서관춘천시립도서관370464162021-01-30
144733890문화시설도서강북문화정보도서관강북문화정보도서관234452792021-01-30
145774424문화시설도서동탄복합문화센터도서관동탄복합문화센터도서관304363402021-01-31
146856297문화시설도서춘천시립도서관춘천시립도서관356413972021-01-31
147776350문화시설도서마포중앙도서관마포중앙도서관341604012021-01-31
148763283문화시설도서노원정보도서관노원정보도서관342844262021-01-31
149733891문화시설도서강북문화정보도서관강북문화정보도서관237362732021-01-31