Overview

Dataset statistics

Number of variables9
Number of observations248
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory18.8 KiB
Average record size in memory77.5 B

Variable types

Numeric5
Categorical4

Alerts

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

Reproduction

Analysis started2023-12-10 09:39:41.251994
Analysis finished2023-12-10 09:39:47.127734
Duration5.88 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

SEQ_NO
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct248
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean156114.62
Minimum117893
Maximum241636
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2023-12-10T18:39:47.238534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum117893
5-th percentile117905.35
Q1130505.5
median135382
Q3159532.5
95-th percentile241623.65
Maximum241636
Range123743
Interquartile range (IQR)29027

Descriptive statistics

Standard deviation46564.759
Coefficient of variation (CV)0.29827288
Kurtosis-0.6530967
Mean156114.62
Median Absolute Deviation (MAD)8880
Skewness1.0947876
Sum38716427
Variance2.1682768 × 109
MonotonicityNot monotonic
2023-12-10T18:39:47.501523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
241606 1
 
0.4%
136246 1
 
0.4%
118484 1
 
0.4%
135672 1
 
0.4%
135673 1
 
0.4%
136245 1
 
0.4%
135101 1
 
0.4%
134529 1
 
0.4%
118485 1
 
0.4%
241626 1
 
0.4%
Other values (238) 238
96.0%
ValueCountFrequency (%)
117893 1
0.4%
117894 1
0.4%
117895 1
0.4%
117896 1
0.4%
117897 1
0.4%
117898 1
0.4%
117899 1
0.4%
117900 1
0.4%
117901 1
0.4%
117902 1
0.4%
ValueCountFrequency (%)
241636 1
0.4%
241635 1
0.4%
241634 1
0.4%
241633 1
0.4%
241632 1
0.4%
241631 1
0.4%
241630 1
0.4%
241629 1
0.4%
241628 1
0.4%
241627 1
0.4%

SRCHWRD_NM
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
K2등산화
62 
등산스틱
62 
바람막이
62 
아이젠
31 
충전식손난로
31 

Length

Max length6
Median length5.5
Mean length4.375
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row아이젠
2nd rowK2등산화
3rd row등산스틱
4th rowK2등산화
5th row바람막이

Common Values

ValueCountFrequency (%)
K2등산화 62
25.0%
등산스틱 62
25.0%
바람막이 62
25.0%
아이젠 31
12.5%
충전식손난로 31
12.5%

Length

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

Common Values (Plot)

2023-12-10T18:39:47.937118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
k2등산화 62
25.0%
등산스틱 62
25.0%
바람막이 62
25.0%
아이젠 31
12.5%
충전식손난로 31
12.5%

UPPER_CTGRY_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
등산
248 

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 (%)
등산 248
100.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:48.284397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
등산 248
100.0%

LWPRT_CTGRY_NM
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
등산장비
93 
등산
93 
등산화
31 
등산의류
31 

Length

Max length4
Median length3.5
Mean length3.125
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row등산장비
2nd row등산화
3rd row등산
4th row등산
5th row등산

Common Values

ValueCountFrequency (%)
등산장비 93
37.5%
등산 93
37.5%
등산화 31
 
12.5%
등산의류 31
 
12.5%

Length

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

Common Values (Plot)

2023-12-10T18:39:48.703727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
등산장비 93
37.5%
등산 93
37.5%
등산화 31
 
12.5%
등산의류 31
 
12.5%

SRCHWRD_TY_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
인기검색어
248 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row인기검색어
2nd row인기검색어
3rd row인기검색어
4th row인기검색어
5th row인기검색어

Common Values

ValueCountFrequency (%)
인기검색어 248
100.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:49.022686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인기검색어 248
100.0%

MOBILE_SCCNT_VALUE
Real number (ℝ)

HIGH CORRELATION 

Distinct132
Distinct (%)53.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean311.08871
Minimum40
Maximum3615
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2023-12-10T18:39:49.202388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum40
5-th percentile105
Q1180.5
median252
Q3319
95-th percentile692.9
Maximum3615
Range3575
Interquartile range (IQR)138.5

Descriptive statistics

Standard deviation358.57556
Coefficient of variation (CV)1.1526473
Kurtosis46.987853
Mean311.08871
Median Absolute Deviation (MAD)70
Skewness6.1769245
Sum77150
Variance128576.43
MonotonicityNot monotonic
2023-12-10T18:39:49.442894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
178 5
 
2.0%
317 5
 
2.0%
276 4
 
1.6%
263 4
 
1.6%
265 4
 
1.6%
185 4
 
1.6%
198 4
 
1.6%
234 4
 
1.6%
267 4
 
1.6%
351 4
 
1.6%
Other values (122) 206
83.1%
ValueCountFrequency (%)
40 1
0.4%
44 2
0.8%
47 1
0.4%
64 1
0.4%
68 1
0.4%
75 1
0.4%
78 1
0.4%
80 1
0.4%
98 2
0.8%
103 1
0.4%
ValueCountFrequency (%)
3615 1
0.4%
3155 1
0.4%
1979 1
0.4%
1708 1
0.4%
1267 1
0.4%
1265 1
0.4%
1186 1
0.4%
1137 1
0.4%
1021 1
0.4%
808 1
0.4%

PC_SCCNT_VALUE
Real number (ℝ)

HIGH CORRELATION 

Distinct149
Distinct (%)60.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1564.5444
Minimum280
Maximum13290
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2023-12-10T18:39:49.705088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum280
5-th percentile774.9
Q11036
median1277
Q31673
95-th percentile3465.6
Maximum13290
Range13010
Interquartile range (IQR)637

Descriptive statistics

Standard deviation1272.7337
Coefficient of variation (CV)0.81348523
Kurtosis42.137359
Mean1564.5444
Median Absolute Deviation (MAD)311
Skewness5.5585134
Sum388007
Variance1619851.1
MonotonicityNot monotonic
2023-12-10T18:39:49.950725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1181 4
 
1.6%
1220 4
 
1.6%
966 4
 
1.6%
877 3
 
1.2%
1103 3
 
1.2%
1202 3
 
1.2%
1782 2
 
0.8%
1056 2
 
0.8%
1106 2
 
0.8%
1378 2
 
0.8%
Other values (139) 219
88.3%
ValueCountFrequency (%)
280 1
0.4%
282 1
0.4%
283 1
0.4%
296 1
0.4%
303 1
0.4%
314 1
0.4%
361 1
0.4%
375 1
0.4%
392 1
0.4%
483 1
0.4%
ValueCountFrequency (%)
13290 1
0.4%
11157 1
0.4%
5772 1
0.4%
5669 1
0.4%
4921 1
0.4%
4791 1
0.4%
4748 1
0.4%
4514 1
0.4%
3989 1
0.4%
3880 1
0.4%

SCCNT_SM_VALUE
Real number (ℝ)

HIGH CORRELATION 

Distinct152
Distinct (%)61.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1875.6331
Minimum326
Maximum16905
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2023-12-10T18:39:50.147494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum326
5-th percentile904
Q11251
median1563
Q31968
95-th percentile3994.7
Maximum16905
Range16579
Interquartile range (IQR)717

Descriptive statistics

Standard deviation1605.7277
Coefficient of variation (CV)0.85609906
Kurtosis45.805608
Mean1875.6331
Median Absolute Deviation (MAD)342
Skewness5.8935354
Sum465157
Variance2578361.4
MonotonicityNot monotonic
2023-12-10T18:39:50.337035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1666 4
 
1.6%
1170 4
 
1.6%
1566 3
 
1.2%
1251 2
 
0.8%
1534 2
 
0.8%
1669 2
 
0.8%
1505 2
 
0.8%
1204 2
 
0.8%
1492 2
 
0.8%
1337 2
 
0.8%
Other values (142) 223
89.9%
ValueCountFrequency (%)
326 1
0.4%
343 1
0.4%
347 1
0.4%
348 1
0.4%
358 1
0.4%
392 1
0.4%
415 1
0.4%
425 1
0.4%
495 1
0.4%
602 1
0.4%
ValueCountFrequency (%)
16905 1
0.4%
14312 1
0.4%
7648 1
0.4%
7480 1
0.4%
6058 1
0.4%
5313 1
0.4%
5254 1
0.4%
5236 1
0.4%
5147 1
0.4%
5047 1
0.4%

SCCNT_DE
Real number (ℝ)

Distinct31
Distinct (%)12.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20210116
Minimum20210101
Maximum20210131
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2023-12-10T18:39:50.547580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20210101
5-th percentile20210102
Q120210108
median20210116
Q320210124
95-th percentile20210130
Maximum20210131
Range30
Interquartile range (IQR)16

Descriptive statistics

Standard deviation8.9623594
Coefficient of variation (CV)4.4345908 × 10-7
Kurtosis-1.2025113
Mean20210116
Median Absolute Deviation (MAD)8
Skewness0
Sum5.0121088 × 109
Variance80.323887
MonotonicityIncreasing
2023-12-10T18:39:50.780717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%)
20210101 8
 
3.2%
20210102 8
 
3.2%
20210131 8
 
3.2%
20210130 8
 
3.2%
20210129 8
 
3.2%
20210128 8
 
3.2%
20210127 8
 
3.2%
20210126 8
 
3.2%
20210125 8
 
3.2%
20210124 8
 
3.2%
Other values (21) 168
67.7%
ValueCountFrequency (%)
20210101 8
3.2%
20210102 8
3.2%
20210103 8
3.2%
20210104 8
3.2%
20210105 8
3.2%
20210106 8
3.2%
20210107 8
3.2%
20210108 8
3.2%
20210109 8
3.2%
20210110 8
3.2%
ValueCountFrequency (%)
20210131 8
3.2%
20210130 8
3.2%
20210129 8
3.2%
20210128 8
3.2%
20210127 8
3.2%
20210126 8
3.2%
20210125 8
3.2%
20210124 8
3.2%
20210123 8
3.2%
20210122 8
3.2%

Interactions

2023-12-10T18:39:46.075894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:41.853737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:42.698906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:43.752703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:44.857368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:46.229247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:42.016472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:42.903570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:44.009415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:45.081654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:46.380024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:42.178782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:43.169656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:44.184530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:45.586102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:46.511622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:42.344305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:43.380379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:44.426700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:45.759851image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:46.659216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:42.496391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:43.567799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:44.638825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:45.922704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T18:39:50.950885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SEQ_NOSRCHWRD_NMLWPRT_CTGRY_NMMOBILE_SCCNT_VALUEPC_SCCNT_VALUESCCNT_SM_VALUESCCNT_DE
SEQ_NO1.0001.0000.6740.4860.4090.4100.000
SRCHWRD_NM1.0001.0000.7200.4450.3610.3850.000
LWPRT_CTGRY_NM0.6740.7201.0000.3880.1870.1780.000
MOBILE_SCCNT_VALUE0.4860.4450.3881.0000.9080.9070.098
PC_SCCNT_VALUE0.4090.3610.1870.9081.0000.9970.293
SCCNT_SM_VALUE0.4100.3850.1780.9070.9971.0000.181
SCCNT_DE0.0000.0000.0000.0980.2930.1811.000
2023-12-10T18:39:51.133850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SRCHWRD_NMLWPRT_CTGRY_NM
SRCHWRD_NM1.0000.658
LWPRT_CTGRY_NM0.6581.000
2023-12-10T18:39:51.264056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SEQ_NOMOBILE_SCCNT_VALUEPC_SCCNT_VALUESCCNT_SM_VALUESCCNT_DESRCHWRD_NMLWPRT_CTGRY_NM
SEQ_NO1.0000.042-0.006-0.0080.1250.9960.701
MOBILE_SCCNT_VALUE0.0421.0000.4730.590-0.0670.2910.180
PC_SCCNT_VALUE-0.0060.4731.0000.985-0.1090.2380.125
SCCNT_SM_VALUE-0.0080.5900.9851.000-0.0930.2560.119
SCCNT_DE0.125-0.067-0.109-0.0931.0000.0000.000
SRCHWRD_NM0.9960.2910.2380.2560.0001.0000.658
LWPRT_CTGRY_NM0.7010.1800.1250.1190.0000.6581.000

Missing values

2023-12-10T18:39:46.848578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:39:47.042725image/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_NOSRCHWRD_NMUPPER_CTGRY_NMLWPRT_CTGRY_NMSRCHWRD_TY_NMMOBILE_SCCNT_VALUEPC_SCCNT_VALUESCCNT_SM_VALUESCCNT_DE
0241606아이젠등산등산장비인기검색어2102249245920210101
1118465K2등산화등산등산화인기검색어1561378153420210101
2134509등산스틱등산등산인기검색어1251181130620210101
3117893K2등산화등산등산인기검색어1561378153420210101
4135653바람막이등산등산인기검색어11379190420210101
5135081등산스틱등산등산장비인기검색어1251181130620210101
6136225바람막이등산등산의류인기검색어11379190420210101
7229365충전식손난로등산등산장비인기검색어1661327149320210101
8136226바람막이등산등산의류인기검색어11686397920210102
9135654바람막이등산등산인기검색어11686397920210102
SEQ_NOSRCHWRD_NMUPPER_CTGRY_NMLWPRT_CTGRY_NMSRCHWRD_TY_NMMOBILE_SCCNT_VALUEPC_SCCNT_VALUESCCNT_SM_VALUESCCNT_DE
238134538등산스틱등산등산인기검색어1591220137920210130
239135682바람막이등산등산인기검색어1551525168020210130
240134539등산스틱등산등산인기검색어1701862203220210131
241135683바람막이등산등산인기검색어2412127236820210131
242241636아이젠등산등산장비인기검색어1531413156620210131
243117923K2등산화등산등산인기검색어1821744192620210131
244118495K2등산화등산등산화인기검색어1821744192620210131
245229395충전식손난로등산등산장비인기검색어4430334720210131
246136255바람막이등산등산의류인기검색어2412127236820210131
247135111등산스틱등산등산장비인기검색어1701862203220210131