Dataset statistics
Number of variables | 9 |
---|---|
Number of observations | 248 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 18.8 KiB |
Average record size in memory | 77.5 B |
Variable types
Numeric | 5 |
---|---|
Categorical | 4 |
Dataset
Description | Sample |
---|---|
Author | 데이터마케팅코리아 |
URL | https://www.bigdata-culture.kr/bigdata/user/data_market/detail.do?id=323bcc40-f584-11eb-8e60-2bcdc8456bfb |
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 fields | High correlation |
MOBILE_SCCNT_VALUE is highly overall correlated with SCCNT_SM_VALUE | High correlation |
PC_SCCNT_VALUE is highly overall correlated with SCCNT_SM_VALUE | High correlation |
SCCNT_SM_VALUE is highly overall correlated with MOBILE_SCCNT_VALUE and 1 other fields | High correlation |
SRCHWRD_NM is highly overall correlated with SEQ_NO and 1 other fields | High correlation |
LWPRT_CTGRY_NM is highly overall correlated with SEQ_NO and 1 other fields | High correlation |
SEQ_NO has unique values | Unique |
Reproduction
Analysis started | 2023-12-10 09:39:41.251994 |
---|---|
Analysis finished | 2023-12-10 09:39:47.127734 |
Duration | 5.88 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
SEQ_NO
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 248 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 156114.62 |
Minimum | 117893 |
---|---|
Maximum | 241636 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.3 KiB |
Quantile statistics
Minimum | 117893 |
---|---|
5-th percentile | 117905.35 |
Q1 | 130505.5 |
median | 135382 |
Q3 | 159532.5 |
95-th percentile | 241623.65 |
Maximum | 241636 |
Range | 123743 |
Interquartile range (IQR) | 29027 |
Descriptive statistics
Standard deviation | 46564.759 |
---|---|
Coefficient of variation (CV) | 0.29827288 |
Kurtosis | -0.6530967 |
Mean | 156114.62 |
Median Absolute Deviation (MAD) | 8880 |
Skewness | 1.0947876 |
Sum | 38716427 |
Variance | 2.1682768 × 109 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
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 |
Value | Count | Frequency (%) |
117893 | 1 | |
117894 | 1 | |
117895 | 1 | |
117896 | 1 | |
117897 | 1 | |
117898 | 1 | |
117899 | 1 | |
117900 | 1 | |
117901 | 1 | |
117902 | 1 |
Value | Count | Frequency (%) |
241636 | 1 | |
241635 | 1 | |
241634 | 1 | |
241633 | 1 | |
241632 | 1 | |
241631 | 1 | |
241630 | 1 | |
241629 | 1 | |
241628 | 1 | |
241627 | 1 |
SRCHWRD_NM
Categorical
HIGH CORRELATION
 
Distinct | 5 |
---|---|
Distinct (%) | 2.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 2.1 KiB |
K2등산화 | |
---|---|
등산스틱 | |
바람막이 | |
아이젠 | |
충전식손난로 |
Length
Max length | 6 |
---|---|
Median length | 5.5 |
Mean length | 4.375 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 아이젠 |
---|---|
2nd row | K2등산화 |
3rd row | 등산스틱 |
4th row | K2등산화 |
5th row | 바람막이 |
Common Values
Value | Count | Frequency (%) |
K2등산화 | 62 | |
등산스틱 | 62 | |
바람막이 | 62 | |
아이젠 | 31 | |
충전식손난로 | 31 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
k2등산화 | 62 | |
등산스틱 | 62 | |
바람막이 | 62 | |
아이젠 | 31 | |
충전식손난로 | 31 |
UPPER_CTGRY_NM
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 2.1 KiB |
등산 |
---|
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 등산 |
---|---|
2nd row | 등산 |
3rd row | 등산 |
4th row | 등산 |
5th row | 등산 |
Common Values
Value | Count | Frequency (%) |
등산 | 248 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
등산 | 248 |
LWPRT_CTGRY_NM
Categorical
HIGH CORRELATION
 
Distinct | 4 |
---|---|
Distinct (%) | 1.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 2.1 KiB |
등산장비 | |
---|---|
등산 | |
등산화 | |
등산의류 |
Length
Max length | 4 |
---|---|
Median length | 3.5 |
Mean length | 3.125 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 등산장비 |
---|---|
2nd row | 등산화 |
3rd row | 등산 |
4th row | 등산 |
5th row | 등산 |
Common Values
Value | Count | Frequency (%) |
등산장비 | 93 | |
등산 | 93 | |
등산화 | 31 | 12.5% |
등산의류 | 31 | 12.5% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
등산장비 | 93 | |
등산 | 93 | |
등산화 | 31 | 12.5% |
등산의류 | 31 | 12.5% |
SRCHWRD_TY_NM
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 2.1 KiB |
인기검색어 |
---|
Length
Max length | 5 |
---|---|
Median length | 5 |
Mean length | 5 |
Min length | 5 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 인기검색어 |
---|---|
2nd row | 인기검색어 |
3rd row | 인기검색어 |
4th row | 인기검색어 |
5th row | 인기검색어 |
Common Values
Value | Count | Frequency (%) |
인기검색어 | 248 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
인기검색어 | 248 |
MOBILE_SCCNT_VALUE
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 132 |
---|---|
Distinct (%) | 53.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 311.08871 |
Minimum | 40 |
---|---|
Maximum | 3615 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.3 KiB |
Quantile statistics
Minimum | 40 |
---|---|
5-th percentile | 105 |
Q1 | 180.5 |
median | 252 |
Q3 | 319 |
95-th percentile | 692.9 |
Maximum | 3615 |
Range | 3575 |
Interquartile range (IQR) | 138.5 |
Descriptive statistics
Standard deviation | 358.57556 |
---|---|
Coefficient of variation (CV) | 1.1526473 |
Kurtosis | 46.987853 |
Mean | 311.08871 |
Median Absolute Deviation (MAD) | 70 |
Skewness | 6.1769245 |
Sum | 77150 |
Variance | 128576.43 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
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 |
Value | Count | Frequency (%) |
40 | 1 | |
44 | 2 | |
47 | 1 | |
64 | 1 | |
68 | 1 | |
75 | 1 | |
78 | 1 | |
80 | 1 | |
98 | 2 | |
103 | 1 |
Value | Count | Frequency (%) |
3615 | 1 | |
3155 | 1 | |
1979 | 1 | |
1708 | 1 | |
1267 | 1 | |
1265 | 1 | |
1186 | 1 | |
1137 | 1 | |
1021 | 1 | |
808 | 1 |
PC_SCCNT_VALUE
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 149 |
---|---|
Distinct (%) | 60.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1564.5444 |
Minimum | 280 |
---|---|
Maximum | 13290 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.3 KiB |
Quantile statistics
Minimum | 280 |
---|---|
5-th percentile | 774.9 |
Q1 | 1036 |
median | 1277 |
Q3 | 1673 |
95-th percentile | 3465.6 |
Maximum | 13290 |
Range | 13010 |
Interquartile range (IQR) | 637 |
Descriptive statistics
Standard deviation | 1272.7337 |
---|---|
Coefficient of variation (CV) | 0.81348523 |
Kurtosis | 42.137359 |
Mean | 1564.5444 |
Median Absolute Deviation (MAD) | 311 |
Skewness | 5.5585134 |
Sum | 388007 |
Variance | 1619851.1 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
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 |
Value | Count | Frequency (%) |
280 | 1 | |
282 | 1 | |
283 | 1 | |
296 | 1 | |
303 | 1 | |
314 | 1 | |
361 | 1 | |
375 | 1 | |
392 | 1 | |
483 | 1 |
Value | Count | Frequency (%) |
13290 | 1 | |
11157 | 1 | |
5772 | 1 | |
5669 | 1 | |
4921 | 1 | |
4791 | 1 | |
4748 | 1 | |
4514 | 1 | |
3989 | 1 | |
3880 | 1 |
SCCNT_SM_VALUE
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 152 |
---|---|
Distinct (%) | 61.3% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1875.6331 |
Minimum | 326 |
---|---|
Maximum | 16905 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.3 KiB |
Quantile statistics
Minimum | 326 |
---|---|
5-th percentile | 904 |
Q1 | 1251 |
median | 1563 |
Q3 | 1968 |
95-th percentile | 3994.7 |
Maximum | 16905 |
Range | 16579 |
Interquartile range (IQR) | 717 |
Descriptive statistics
Standard deviation | 1605.7277 |
---|---|
Coefficient of variation (CV) | 0.85609906 |
Kurtosis | 45.805608 |
Mean | 1875.6331 |
Median Absolute Deviation (MAD) | 342 |
Skewness | 5.8935354 |
Sum | 465157 |
Variance | 2578361.4 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
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 |
Value | Count | Frequency (%) |
326 | 1 | |
343 | 1 | |
347 | 1 | |
348 | 1 | |
358 | 1 | |
392 | 1 | |
415 | 1 | |
425 | 1 | |
495 | 1 | |
602 | 1 |
Value | Count | Frequency (%) |
16905 | 1 | |
14312 | 1 | |
7648 | 1 | |
7480 | 1 | |
6058 | 1 | |
5313 | 1 | |
5254 | 1 | |
5236 | 1 | |
5147 | 1 | |
5047 | 1 |
SCCNT_DE
Real number (ℝ)
Distinct | 31 |
---|---|
Distinct (%) | 12.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20210116 |
Minimum | 20210101 |
---|---|
Maximum | 20210131 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.3 KiB |
Quantile statistics
Minimum | 20210101 |
---|---|
5-th percentile | 20210102 |
Q1 | 20210108 |
median | 20210116 |
Q3 | 20210124 |
95-th percentile | 20210130 |
Maximum | 20210131 |
Range | 30 |
Interquartile range (IQR) | 16 |
Descriptive statistics
Standard deviation | 8.9623594 |
---|---|
Coefficient of variation (CV) | 4.4345908 × 10-7 |
Kurtosis | -1.2025113 |
Mean | 20210116 |
Median Absolute Deviation (MAD) | 8 |
Skewness | 0 |
Sum | 5.0121088 × 109 |
Variance | 80.323887 |
Monotonicity | Increasing |
Value | Count | Frequency (%) |
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 |
Value | Count | Frequency (%) |
20210101 | 8 | |
20210102 | 8 | |
20210103 | 8 | |
20210104 | 8 | |
20210105 | 8 | |
20210106 | 8 | |
20210107 | 8 | |
20210108 | 8 | |
20210109 | 8 | |
20210110 | 8 |
Value | Count | Frequency (%) |
20210131 | 8 | |
20210130 | 8 | |
20210129 | 8 | |
20210128 | 8 | |
20210127 | 8 | |
20210126 | 8 | |
20210125 | 8 | |
20210124 | 8 | |
20210123 | 8 | |
20210122 | 8 |
SEQ_NO | SRCHWRD_NM | LWPRT_CTGRY_NM | MOBILE_SCCNT_VALUE | PC_SCCNT_VALUE | SCCNT_SM_VALUE | SCCNT_DE | |
---|---|---|---|---|---|---|---|
SEQ_NO | 1.000 | 1.000 | 0.674 | 0.486 | 0.409 | 0.410 | 0.000 |
SRCHWRD_NM | 1.000 | 1.000 | 0.720 | 0.445 | 0.361 | 0.385 | 0.000 |
LWPRT_CTGRY_NM | 0.674 | 0.720 | 1.000 | 0.388 | 0.187 | 0.178 | 0.000 |
MOBILE_SCCNT_VALUE | 0.486 | 0.445 | 0.388 | 1.000 | 0.908 | 0.907 | 0.098 |
PC_SCCNT_VALUE | 0.409 | 0.361 | 0.187 | 0.908 | 1.000 | 0.997 | 0.293 |
SCCNT_SM_VALUE | 0.410 | 0.385 | 0.178 | 0.907 | 0.997 | 1.000 | 0.181 |
SCCNT_DE | 0.000 | 0.000 | 0.000 | 0.098 | 0.293 | 0.181 | 1.000 |
SRCHWRD_NM | LWPRT_CTGRY_NM | |
---|---|---|
SRCHWRD_NM | 1.000 | 0.658 |
LWPRT_CTGRY_NM | 0.658 | 1.000 |
SEQ_NO | MOBILE_SCCNT_VALUE | PC_SCCNT_VALUE | SCCNT_SM_VALUE | SCCNT_DE | SRCHWRD_NM | LWPRT_CTGRY_NM | |
---|---|---|---|---|---|---|---|
SEQ_NO | 1.000 | 0.042 | -0.006 | -0.008 | 0.125 | 0.996 | 0.701 |
MOBILE_SCCNT_VALUE | 0.042 | 1.000 | 0.473 | 0.590 | -0.067 | 0.291 | 0.180 |
PC_SCCNT_VALUE | -0.006 | 0.473 | 1.000 | 0.985 | -0.109 | 0.238 | 0.125 |
SCCNT_SM_VALUE | -0.008 | 0.590 | 0.985 | 1.000 | -0.093 | 0.256 | 0.119 |
SCCNT_DE | 0.125 | -0.067 | -0.109 | -0.093 | 1.000 | 0.000 | 0.000 |
SRCHWRD_NM | 0.996 | 0.291 | 0.238 | 0.256 | 0.000 | 1.000 | 0.658 |
LWPRT_CTGRY_NM | 0.701 | 0.180 | 0.125 | 0.119 | 0.000 | 0.658 | 1.000 |
SEQ_NO | SRCHWRD_NM | UPPER_CTGRY_NM | LWPRT_CTGRY_NM | SRCHWRD_TY_NM | MOBILE_SCCNT_VALUE | PC_SCCNT_VALUE | SCCNT_SM_VALUE | SCCNT_DE | |
---|---|---|---|---|---|---|---|---|---|
0 | 241606 | 아이젠 | 등산 | 등산장비 | 인기검색어 | 210 | 2249 | 2459 | 20210101 |
1 | 118465 | K2등산화 | 등산 | 등산화 | 인기검색어 | 156 | 1378 | 1534 | 20210101 |
2 | 134509 | 등산스틱 | 등산 | 등산 | 인기검색어 | 125 | 1181 | 1306 | 20210101 |
3 | 117893 | K2등산화 | 등산 | 등산 | 인기검색어 | 156 | 1378 | 1534 | 20210101 |
4 | 135653 | 바람막이 | 등산 | 등산 | 인기검색어 | 113 | 791 | 904 | 20210101 |
5 | 135081 | 등산스틱 | 등산 | 등산장비 | 인기검색어 | 125 | 1181 | 1306 | 20210101 |
6 | 136225 | 바람막이 | 등산 | 등산의류 | 인기검색어 | 113 | 791 | 904 | 20210101 |
7 | 229365 | 충전식손난로 | 등산 | 등산장비 | 인기검색어 | 166 | 1327 | 1493 | 20210101 |
8 | 136226 | 바람막이 | 등산 | 등산의류 | 인기검색어 | 116 | 863 | 979 | 20210102 |
9 | 135654 | 바람막이 | 등산 | 등산 | 인기검색어 | 116 | 863 | 979 | 20210102 |
SEQ_NO | SRCHWRD_NM | UPPER_CTGRY_NM | LWPRT_CTGRY_NM | SRCHWRD_TY_NM | MOBILE_SCCNT_VALUE | PC_SCCNT_VALUE | SCCNT_SM_VALUE | SCCNT_DE | |
---|---|---|---|---|---|---|---|---|---|
238 | 134538 | 등산스틱 | 등산 | 등산 | 인기검색어 | 159 | 1220 | 1379 | 20210130 |
239 | 135682 | 바람막이 | 등산 | 등산 | 인기검색어 | 155 | 1525 | 1680 | 20210130 |
240 | 134539 | 등산스틱 | 등산 | 등산 | 인기검색어 | 170 | 1862 | 2032 | 20210131 |
241 | 135683 | 바람막이 | 등산 | 등산 | 인기검색어 | 241 | 2127 | 2368 | 20210131 |
242 | 241636 | 아이젠 | 등산 | 등산장비 | 인기검색어 | 153 | 1413 | 1566 | 20210131 |
243 | 117923 | K2등산화 | 등산 | 등산 | 인기검색어 | 182 | 1744 | 1926 | 20210131 |
244 | 118495 | K2등산화 | 등산 | 등산화 | 인기검색어 | 182 | 1744 | 1926 | 20210131 |
245 | 229395 | 충전식손난로 | 등산 | 등산장비 | 인기검색어 | 44 | 303 | 347 | 20210131 |
246 | 136255 | 바람막이 | 등산 | 등산의류 | 인기검색어 | 241 | 2127 | 2368 | 20210131 |
247 | 135111 | 등산스틱 | 등산 | 등산장비 | 인기검색어 | 170 | 1862 | 2032 | 20210131 |