Dataset statistics
Number of variables | 9 |
---|---|
Number of observations | 186 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 14.1 KiB |
Average record size in memory | 77.7 B |
Variable types
Numeric | 5 |
---|---|
Categorical | 4 |
Dataset
Description | Sample |
---|---|
Author | 데이터마케팅코리아 |
URL | https://www.bigdata-culture.kr/bigdata/user/data_market/detail.do?id=16269e90-f584-11eb-8e60-2bcdc8456bfb |
SRCHWRD_TY_NM has constant value "" | Constant |
LWPRT_CTGRY_NM is highly overall correlated with SEQ_NO and 2 other fields | High correlation |
SRCHWRD_NM is highly overall correlated with SEQ_NO and 2 other fields | High correlation |
UPPER_CTGRY_NM is highly overall correlated with SEQ_NO and 2 other fields | High correlation |
SEQ_NO is highly overall correlated with SRCHWRD_NM and 2 other fields | High correlation |
MOBILE_SCCNT_VALUE is highly overall correlated with PC_SCCNT_VALUE and 1 other fields | High correlation |
PC_SCCNT_VALUE is highly overall correlated with MOBILE_SCCNT_VALUE and 1 other fields | High correlation |
SCCNT_SM_VALUE is highly overall correlated with MOBILE_SCCNT_VALUE and 1 other fields | High correlation |
SEQ_NO has unique values | Unique |
Reproduction
Analysis started | 2023-12-10 10:06:03.991142 |
---|---|
Analysis finished | 2023-12-10 10:06:09.418057 |
Duration | 5.43 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
SEQ_NO
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 186 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 431374.83 |
Minimum | 260332 |
---|---|
Maximum | 568890 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.8 KiB |
Quantile statistics
Minimum | 260332 |
---|---|
5-th percentile | 260341.25 |
Q1 | 350129.25 |
median | 440182.5 |
Q3 | 528532.75 |
95-th percentile | 568880.75 |
Maximum | 568890 |
Range | 308558 |
Interquartile range (IQR) | 178403.5 |
Descriptive statistics
Standard deviation | 115609.86 |
---|---|
Coefficient of variation (CV) | 0.26800326 |
Kurtosis | -1.6233398 |
Mean | 431374.83 |
Median Absolute Deviation (MAD) | 89202 |
Skewness | -0.17689105 |
Sum | 80235719 |
Variance | 1.336564 × 1010 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
527946 | 1 | 0.5% |
568881 | 1 | 0.5% |
260351 | 1 | 0.5% |
260352 | 1 | 0.5% |
350134 | 1 | 0.5% |
352409 | 1 | 0.5% |
568880 | 1 | 0.5% |
527966 | 1 | 0.5% |
528538 | 1 | 0.5% |
528539 | 1 | 0.5% |
Other values (176) | 176 |
Value | Count | Frequency (%) |
260332 | 1 | |
260333 | 1 | |
260334 | 1 | |
260335 | 1 | |
260336 | 1 | |
260337 | 1 | |
260338 | 1 | |
260339 | 1 | |
260340 | 1 | |
260341 | 1 |
Value | Count | Frequency (%) |
568890 | 1 | |
568889 | 1 | |
568888 | 1 | |
568887 | 1 | |
568886 | 1 | |
568885 | 1 | |
568884 | 1 | |
568883 | 1 | |
568882 | 1 | |
568881 | 1 |
SRCHWRD_NM
Categorical
HIGH CORRELATION
 
Distinct | 5 |
---|---|
Distinct (%) | 2.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.6 KiB |
돼지갈비 | |
---|---|
팽현숙순대국 | |
부대찌개 | |
다이어트도시락 | |
곱창 |
Length
Max length | 7 |
---|---|
Median length | 6.5 |
Mean length | 4.5 |
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 (%) |
돼지갈비 | 62 | |
팽현숙순대국 | 31 | |
부대찌개 | 31 | |
다이어트도시락 | 31 | |
곱창 | 31 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
돼지갈비 | 62 | |
팽현숙순대국 | 31 | |
부대찌개 | 31 | |
다이어트도시락 | 31 | |
곱창 | 31 |
UPPER_CTGRY_NM
Categorical
HIGH CORRELATION
 
Distinct | 3 |
---|---|
Distinct (%) | 1.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.6 KiB |
축산식품 | |
---|---|
냉동/간편조리식품 | |
가공식품 |
Length
Max length | 9 |
---|---|
Median length | 4 |
Mean length | 5.6666667 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 축산식품 |
---|---|
2nd row | 축산식품 |
3rd row | 냉동/간편조리식품 |
4th row | 가공식품 |
5th row | 냉동/간편조리식품 |
Common Values
Value | Count | Frequency (%) |
축산식품 | 93 | |
냉동/간편조리식품 | 62 | |
가공식품 | 31 | 16.7% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
축산식품 | 93 | |
냉동/간편조리식품 | 62 | |
가공식품 | 31 | 16.7% |
LWPRT_CTGRY_NM
Categorical
HIGH CORRELATION
 
Distinct | 4 |
---|---|
Distinct (%) | 2.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.6 KiB |
축산가공식품 | |
---|---|
냉동/간편조리식품 | |
돼지양념육 | |
쿠킹박스 |
Length
Max length | 9 |
---|---|
Median length | 6 |
Mean length | 6.5 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 돼지양념육 |
---|---|
2nd row | 축산가공식품 |
3rd row | 냉동/간편조리식품 |
4th row | 쿠킹박스 |
5th row | 냉동/간편조리식품 |
Common Values
Value | Count | Frequency (%) |
축산가공식품 | 62 | |
냉동/간편조리식품 | 62 | |
돼지양념육 | 31 | |
쿠킹박스 | 31 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
축산가공식품 | 62 | |
냉동/간편조리식품 | 62 | |
돼지양념육 | 31 | |
쿠킹박스 | 31 |
SRCHWRD_TY_NM
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.6 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 (%) |
인기검색어 | 186 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
인기검색어 | 186 |
MOBILE_SCCNT_VALUE
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 143 |
---|---|
Distinct (%) | 76.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 609.82258 |
Minimum | 66 |
---|---|
Maximum | 12878 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.8 KiB |
Quantile statistics
Minimum | 66 |
---|---|
5-th percentile | 106.5 |
Q1 | 208 |
median | 283 |
Q3 | 507.75 |
95-th percentile | 1568.25 |
Maximum | 12878 |
Range | 12812 |
Interquartile range (IQR) | 299.75 |
Descriptive statistics
Standard deviation | 1333.579 |
---|---|
Coefficient of variation (CV) | 2.1868311 |
Kurtosis | 50.094501 |
Mean | 609.82258 |
Median Absolute Deviation (MAD) | 126 |
Skewness | 6.6308424 |
Sum | 113427 |
Variance | 1778433 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
219 | 3 | 1.6% |
265 | 3 | 1.6% |
138 | 3 | 1.6% |
256 | 3 | 1.6% |
106 | 3 | 1.6% |
260 | 2 | 1.1% |
118 | 2 | 1.1% |
208 | 2 | 1.1% |
275 | 2 | 1.1% |
285 | 2 | 1.1% |
Other values (133) | 161 |
Value | Count | Frequency (%) |
66 | 1 | 0.5% |
67 | 1 | 0.5% |
71 | 1 | 0.5% |
99 | 1 | 0.5% |
100 | 1 | 0.5% |
102 | 2 | |
106 | 3 | |
108 | 1 | 0.5% |
111 | 1 | 0.5% |
113 | 1 | 0.5% |
Value | Count | Frequency (%) |
12878 | 1 | |
8584 | 1 | |
7710 | 1 | |
5986 | 1 | |
2629 | 1 | |
1805 | 1 | |
1764 | 1 | |
1595 | 1 | |
1573 | 1 | |
1571 | 1 |
PC_SCCNT_VALUE
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 154 |
---|---|
Distinct (%) | 82.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 3810.1828 |
Minimum | 1173 |
---|---|
Maximum | 22471 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.8 KiB |
Quantile statistics
Minimum | 1173 |
---|---|
5-th percentile | 1785 |
Q1 | 2302.25 |
median | 3768 |
Q3 | 4639.5 |
95-th percentile | 6150.5 |
Maximum | 22471 |
Range | 21298 |
Interquartile range (IQR) | 2337.25 |
Descriptive statistics
Standard deviation | 2138.5609 |
---|---|
Coefficient of variation (CV) | 0.56127513 |
Kurtosis | 32.078657 |
Mean | 3810.1828 |
Median Absolute Deviation (MAD) | 1267 |
Skewness | 4.239637 |
Sum | 708694 |
Variance | 4573442.5 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
2462 | 2 | 1.1% |
3050 | 2 | 1.1% |
1910 | 2 | 1.1% |
1883 | 2 | 1.1% |
2301 | 2 | 1.1% |
2174 | 2 | 1.1% |
2640 | 2 | 1.1% |
2654 | 2 | 1.1% |
2409 | 2 | 1.1% |
3280 | 2 | 1.1% |
Other values (144) | 166 |
Value | Count | Frequency (%) |
1173 | 1 | |
1350 | 1 | |
1380 | 1 | |
1561 | 1 | |
1621 | 1 | |
1630 | 1 | |
1645 | 1 | |
1649 | 1 | |
1713 | 1 | |
1777 | 1 |
Value | Count | Frequency (%) |
22471 | 1 | |
12269 | 1 | |
11211 | 1 | |
9133 | 1 | |
7549 | 1 | |
7188 | 1 | |
6882 | 1 | |
6330 | 1 | |
6277 | 1 | |
6210 | 1 |
SCCNT_SM_VALUE
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 152 |
---|---|
Distinct (%) | 81.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 4420.0054 |
Minimum | 1287 |
---|---|
Maximum | 35349 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.8 KiB |
Quantile statistics
Minimum | 1287 |
---|---|
5-th percentile | 2034 |
Q1 | 2550 |
median | 4148.5 |
Q3 | 5118.25 |
95-th percentile | 7476.75 |
Maximum | 35349 |
Range | 34062 |
Interquartile range (IQR) | 2568.25 |
Descriptive statistics
Standard deviation | 3318.7993 |
---|---|
Coefficient of variation (CV) | 0.75085867 |
Kurtosis | 44.851311 |
Mean | 4420.0054 |
Median Absolute Deviation (MAD) | 1483.5 |
Skewness | 5.6278039 |
Sum | 822121 |
Variance | 11014429 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
2665 | 4 | 2.2% |
2564 | 2 | 1.1% |
2417 | 2 | 1.1% |
2611 | 2 | 1.1% |
2566 | 2 | 1.1% |
2172 | 2 | 1.1% |
2112 | 2 | 1.1% |
2550 | 2 | 1.1% |
2424 | 2 | 1.1% |
2404 | 2 | 1.1% |
Other values (142) | 164 |
Value | Count | Frequency (%) |
1287 | 1 | |
1456 | 1 | |
1491 | 1 | |
1632 | 1 | |
1734 | 1 | |
1738 | 1 | |
1876 | 2 | |
1957 | 1 | |
2028 | 1 | |
2052 | 1 |
Value | Count | Frequency (%) |
35349 | 1 | |
20853 | 1 | |
18921 | 1 | |
11881 | 1 | |
10897 | 1 | |
10178 | 1 | |
8687 | 1 | |
7781 | 1 | |
7532 | 1 | |
7480 | 1 |
SCCNT_DE
Real number (ℝ)
Distinct | 31 |
---|---|
Distinct (%) | 16.7% |
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 | 1.8 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.968413 |
---|---|
Coefficient of variation (CV) | 4.4375861 × 10-7 |
Kurtosis | -1.2024973 |
Mean | 20210116 |
Median Absolute Deviation (MAD) | 8 |
Skewness | 0 |
Sum | 3.7590816 × 109 |
Variance | 80.432432 |
Monotonicity | Increasing |
Value | Count | Frequency (%) |
20210101 | 6 | 3.2% |
20210102 | 6 | 3.2% |
20210131 | 6 | 3.2% |
20210130 | 6 | 3.2% |
20210129 | 6 | 3.2% |
20210128 | 6 | 3.2% |
20210127 | 6 | 3.2% |
20210126 | 6 | 3.2% |
20210125 | 6 | 3.2% |
20210124 | 6 | 3.2% |
Other values (21) | 126 |
Value | Count | Frequency (%) |
20210101 | 6 | |
20210102 | 6 | |
20210103 | 6 | |
20210104 | 6 | |
20210105 | 6 | |
20210106 | 6 | |
20210107 | 6 | |
20210108 | 6 | |
20210109 | 6 | |
20210110 | 6 |
Value | Count | Frequency (%) |
20210131 | 6 | |
20210130 | 6 | |
20210129 | 6 | |
20210128 | 6 | |
20210127 | 6 | |
20210126 | 6 | |
20210125 | 6 | |
20210124 | 6 | |
20210123 | 6 | |
20210122 | 6 |
SEQ_NO | SRCHWRD_NM | UPPER_CTGRY_NM | LWPRT_CTGRY_NM | MOBILE_SCCNT_VALUE | PC_SCCNT_VALUE | SCCNT_SM_VALUE | SCCNT_DE | |
---|---|---|---|---|---|---|---|---|
SEQ_NO | 1.000 | 1.000 | 1.000 | 0.990 | 0.236 | 0.644 | 0.483 | 0.000 |
SRCHWRD_NM | 1.000 | 1.000 | 1.000 | 0.874 | 0.366 | 0.648 | 0.482 | 0.000 |
UPPER_CTGRY_NM | 1.000 | 1.000 | 1.000 | 1.000 | 0.335 | 0.490 | 0.448 | 0.000 |
LWPRT_CTGRY_NM | 0.990 | 0.874 | 1.000 | 1.000 | 0.237 | 0.486 | 0.310 | 0.000 |
MOBILE_SCCNT_VALUE | 0.236 | 0.366 | 0.335 | 0.237 | 1.000 | 0.975 | 0.919 | 0.000 |
PC_SCCNT_VALUE | 0.644 | 0.648 | 0.490 | 0.486 | 0.975 | 1.000 | 0.878 | 0.000 |
SCCNT_SM_VALUE | 0.483 | 0.482 | 0.448 | 0.310 | 0.919 | 0.878 | 1.000 | 0.000 |
SCCNT_DE | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 |
LWPRT_CTGRY_NM | SRCHWRD_NM | UPPER_CTGRY_NM | |
---|---|---|---|
LWPRT_CTGRY_NM | 1.000 | 0.860 | 0.997 |
SRCHWRD_NM | 0.860 | 1.000 | 0.995 |
UPPER_CTGRY_NM | 0.997 | 0.995 | 1.000 |
SEQ_NO | MOBILE_SCCNT_VALUE | PC_SCCNT_VALUE | SCCNT_SM_VALUE | SCCNT_DE | SRCHWRD_NM | UPPER_CTGRY_NM | LWPRT_CTGRY_NM | |
---|---|---|---|---|---|---|---|---|
SEQ_NO | 1.000 | -0.148 | -0.275 | -0.259 | 0.167 | 0.997 | 0.997 | 0.864 |
MOBILE_SCCNT_VALUE | -0.148 | 1.000 | 0.583 | 0.660 | 0.010 | 0.243 | 0.236 | 0.163 |
PC_SCCNT_VALUE | -0.275 | 0.583 | 1.000 | 0.989 | 0.014 | 0.485 | 0.369 | 0.349 |
SCCNT_SM_VALUE | -0.259 | 0.660 | 0.989 | 1.000 | 0.037 | 0.349 | 0.201 | 0.200 |
SCCNT_DE | 0.167 | 0.010 | 0.014 | 0.037 | 1.000 | 0.000 | 0.000 | 0.000 |
SRCHWRD_NM | 0.997 | 0.243 | 0.485 | 0.349 | 0.000 | 1.000 | 0.995 | 0.860 |
UPPER_CTGRY_NM | 0.997 | 0.236 | 0.369 | 0.201 | 0.000 | 0.995 | 1.000 | 0.997 |
LWPRT_CTGRY_NM | 0.864 | 0.163 | 0.349 | 0.200 | 0.000 | 0.860 | 0.997 | 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 | 527946 | 돼지갈비 | 축산식품 | 돼지양념육 | 인기검색어 | 102 | 2462 | 2564 | 20210101 |
1 | 528518 | 돼지갈비 | 축산식품 | 축산가공식품 | 인기검색어 | 102 | 2462 | 2564 | 20210101 |
2 | 352389 | 팽현숙순대국 | 냉동/간편조리식품 | 냉동/간편조리식품 | 인기검색어 | 208 | 1920 | 2128 | 20210101 |
3 | 260332 | 부대찌개 | 가공식품 | 쿠킹박스 | 인기검색어 | 138 | 4013 | 4151 | 20210101 |
4 | 350114 | 다이어트도시락 | 냉동/간편조리식품 | 냉동/간편조리식품 | 인기검색어 | 325 | 3542 | 3867 | 20210101 |
5 | 568860 | 곱창 | 축산식품 | 축산가공식품 | 인기검색어 | 204 | 3578 | 3782 | 20210101 |
6 | 568861 | 곱창 | 축산식품 | 축산가공식품 | 인기검색어 | 268 | 4420 | 4688 | 20210102 |
7 | 350115 | 다이어트도시락 | 냉동/간편조리식품 | 냉동/간편조리식품 | 인기검색어 | 400 | 4214 | 4614 | 20210102 |
8 | 528519 | 돼지갈비 | 축산식품 | 축산가공식품 | 인기검색어 | 106 | 2559 | 2665 | 20210102 |
9 | 527947 | 돼지갈비 | 축산식품 | 돼지양념육 | 인기검색어 | 106 | 2559 | 2665 | 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 | |
---|---|---|---|---|---|---|---|---|---|
176 | 350143 | 다이어트도시락 | 냉동/간편조리식품 | 냉동/간편조리식품 | 인기검색어 | 344 | 3452 | 3796 | 20210130 |
177 | 527975 | 돼지갈비 | 축산식품 | 돼지양념육 | 인기검색어 | 143 | 3250 | 3393 | 20210130 |
178 | 352418 | 팽현숙순대국 | 냉동/간편조리식품 | 냉동/간편조리식품 | 인기검색어 | 71 | 1561 | 1632 | 20210130 |
179 | 568889 | 곱창 | 축산식품 | 축산가공식품 | 인기검색어 | 215 | 4389 | 4604 | 20210130 |
180 | 568890 | 곱창 | 축산식품 | 축산가공식품 | 인기검색어 | 202 | 4082 | 4284 | 20210131 |
181 | 352419 | 팽현숙순대국 | 냉동/간편조리식품 | 냉동/간편조리식품 | 인기검색어 | 66 | 2680 | 2746 | 20210131 |
182 | 527976 | 돼지갈비 | 축산식품 | 돼지양념육 | 인기검색어 | 140 | 3199 | 3339 | 20210131 |
183 | 350144 | 다이어트도시락 | 냉동/간편조리식품 | 냉동/간편조리식품 | 인기검색어 | 484 | 5263 | 5747 | 20210131 |
184 | 260362 | 부대찌개 | 가공식품 | 쿠킹박스 | 인기검색어 | 168 | 6330 | 6498 | 20210131 |
185 | 528548 | 돼지갈비 | 축산식품 | 축산가공식품 | 인기검색어 | 140 | 3199 | 3339 | 20210131 |