Dataset statistics
Number of variables | 8 |
---|---|
Number of observations | 500 |
Missing cells | 128 |
Missing cells (%) | 3.2% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 34.8 KiB |
Average record size in memory | 71.3 B |
Variable types
Numeric | 7 |
---|---|
Categorical | 1 |
Dataset
Description | 샘플 데이터 |
---|---|
Author | 신한은행 |
URL | https://bigdata.seoul.go.kr/data/selectSampleData.do?sample_data_seq=317 |
인프라지수(INFRASTRUCTURE) has 68 (13.6%) missing values | Missing |
금융지수(DEPOSIT) has 57 (11.4%) missing values | Missing |
상권번호(TRDAR_NO) has unique values | Unique |
Reproduction
Analysis started | 2023-12-10 14:57:43.473973 |
---|---|
Analysis finished | 2023-12-10 14:57:55.443722 |
Duration | 11.97 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
일자(DATE)
Real number (ℝ)
Distinct | 24 |
---|---|
Distinct (%) | 4.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 201862.23 |
Minimum | 201801 |
---|---|
Maximum | 201912 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.5 KiB |
Quantile statistics
Minimum | 201801 |
---|---|
5-th percentile | 201803 |
Q1 | 201807 |
median | 201902 |
Q3 | 201907 |
95-th percentile | 201911 |
Maximum | 201912 |
Range | 111 |
Interquartile range (IQR) | 100 |
Descriptive statistics
Standard deviation | 49.57344 |
---|---|
Coefficient of variation (CV) | 0.00024558057 |
Kurtosis | -1.9394521 |
Mean | 201862.23 |
Median Absolute Deviation (MAD) | 9 |
Skewness | -0.22339674 |
Sum | 1.0093111 × 108 |
Variance | 2457.526 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
201905 | 35 | 7.0% |
201806 | 30 | 6.0% |
201903 | 29 | 5.8% |
201911 | 25 | 5.0% |
201901 | 25 | 5.0% |
201908 | 24 | 4.8% |
201810 | 24 | 4.8% |
201909 | 24 | 4.8% |
201812 | 22 | 4.4% |
201802 | 21 | 4.2% |
Other values (14) | 241 |
Value | Count | Frequency (%) |
201801 | 1 | 0.2% |
201802 | 21 | |
201803 | 20 | |
201804 | 18 | |
201805 | 17 | |
201806 | 30 | |
201807 | 19 | |
201808 | 18 | |
201809 | 17 | |
201810 | 24 |
Value | Count | Frequency (%) |
201912 | 21 | |
201911 | 25 | |
201910 | 21 | |
201909 | 24 | |
201908 | 24 | |
201907 | 16 | |
201906 | 19 | |
201905 | 35 | |
201904 | 19 | |
201903 | 29 |
상권구분코드(TRDAR_SE_CD)
Categorical
Distinct | 3 |
---|---|
Distinct (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 4.0 KiB |
A | |
---|---|
R | |
D |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | A |
---|---|
2nd row | A |
3rd row | A |
4th row | R |
5th row | R |
Common Values
Value | Count | Frequency (%) |
A | 349 | |
R | 77 | 15.4% |
D | 74 | 14.8% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
a | 349 | |
r | 77 | 15.4% |
d | 74 | 14.8% |
상권번호(TRDAR_NO)
Real number (ℝ)
UNIQUE
 
Distinct | 500 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1000756.9 |
Minimum | 1000003 |
---|---|
Maximum | 1001490 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.5 KiB |
Quantile statistics
Minimum | 1000003 |
---|---|
5-th percentile | 1000083.8 |
Q1 | 1000386.8 |
median | 1000774.5 |
Q3 | 1001121.8 |
95-th percentile | 1001410.1 |
Maximum | 1001490 |
Range | 1487 |
Interquartile range (IQR) | 735 |
Descriptive statistics
Standard deviation | 423.20419 |
---|---|
Coefficient of variation (CV) | 0.00042288412 |
Kurtosis | -1.1898758 |
Mean | 1000756.9 |
Median Absolute Deviation (MAD) | 365 |
Skewness | -0.053242799 |
Sum | 5.0037844 × 108 |
Variance | 179101.79 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1000433 | 1 | 0.2% |
1000592 | 1 | 0.2% |
1000757 | 1 | 0.2% |
1000474 | 1 | 0.2% |
1001179 | 1 | 0.2% |
1000792 | 1 | 0.2% |
1001035 | 1 | 0.2% |
1000606 | 1 | 0.2% |
1000107 | 1 | 0.2% |
1000293 | 1 | 0.2% |
Other values (490) | 490 |
Value | Count | Frequency (%) |
1000003 | 1 | |
1000004 | 1 | |
1000012 | 1 | |
1000013 | 1 | |
1000015 | 1 | |
1000022 | 1 | |
1000024 | 1 | |
1000033 | 1 | |
1000034 | 1 | |
1000035 | 1 |
Value | Count | Frequency (%) |
1001490 | 1 | |
1001482 | 1 | |
1001475 | 1 | |
1001474 | 1 | |
1001473 | 1 | |
1001472 | 1 | |
1001471 | 1 | |
1001468 | 1 | |
1001464 | 1 | |
1001463 | 1 |
매출지수(SALES)
Real number (ℝ)
Distinct | 457 |
---|---|
Distinct (%) | 91.6% |
Missing | 1 |
Missing (%) | 0.2% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20.005571 |
Minimum | 0.99 |
---|---|
Maximum | 100 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.5 KiB |
Quantile statistics
Minimum | 0.99 |
---|---|
5-th percentile | 5.154 |
Q1 | 9.76 |
median | 14.8 |
Q3 | 24.82 |
95-th percentile | 52.543 |
Maximum | 100 |
Range | 99.01 |
Interquartile range (IQR) | 15.06 |
Descriptive statistics
Standard deviation | 15.459995 |
---|---|
Coefficient of variation (CV) | 0.77278449 |
Kurtosis | 3.6893603 |
Mean | 20.005571 |
Median Absolute Deviation (MAD) | 6.4 |
Skewness | 1.8114121 |
Sum | 9982.78 |
Variance | 239.01145 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
19.84 | 3 | 0.6% |
13.23 | 3 | 0.6% |
8.87 | 3 | 0.6% |
16.28 | 3 | 0.6% |
10.69 | 2 | 0.4% |
8.21 | 2 | 0.4% |
16.85 | 2 | 0.4% |
11.45 | 2 | 0.4% |
6.31 | 2 | 0.4% |
13.73 | 2 | 0.4% |
Other values (447) | 475 |
Value | Count | Frequency (%) |
0.99 | 1 | |
3.0 | 1 | |
3.04 | 1 | |
3.08 | 1 | |
3.32 | 1 | |
3.44 | 1 | |
3.52 | 1 | |
3.57 | 1 | |
3.81 | 1 | |
3.97 | 1 |
Value | Count | Frequency (%) |
100.0 | 1 | |
83.99 | 1 | |
82.88 | 1 | |
76.7 | 1 | |
75.12 | 1 | |
73.46 | 1 | |
72.5 | 1 | |
71.06 | 1 | |
69.54 | 1 | |
69.06 | 1 |
인프라지수(INFRASTRUCTURE)
Real number (ℝ)
MISSING
 
Distinct | 411 |
---|---|
Distinct (%) | 95.1% |
Missing | 68 |
Missing (%) | 13.6% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 26.238981 |
Minimum | 1.59 |
---|---|
Maximum | 100 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.5 KiB |
Quantile statistics
Minimum | 1.59 |
---|---|
5-th percentile | 6.627 |
Q1 | 13.2675 |
median | 20.08 |
Q3 | 32.01 |
95-th percentile | 74.4275 |
Maximum | 100 |
Range | 98.41 |
Interquartile range (IQR) | 18.7425 |
Descriptive statistics
Standard deviation | 19.21336 |
---|---|
Coefficient of variation (CV) | 0.7322449 |
Kurtosis | 2.2201614 |
Mean | 26.238981 |
Median Absolute Deviation (MAD) | 8.125 |
Skewness | 1.5994352 |
Sum | 11335.24 |
Variance | 369.15322 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
14.2 | 3 | 0.6% |
22.67 | 2 | 0.4% |
11.75 | 2 | 0.4% |
12.87 | 2 | 0.4% |
11.93 | 2 | 0.4% |
15.27 | 2 | 0.4% |
9.5 | 2 | 0.4% |
14.29 | 2 | 0.4% |
17.38 | 2 | 0.4% |
13.96 | 2 | 0.4% |
Other values (401) | 411 | |
(Missing) | 68 | 13.6% |
Value | Count | Frequency (%) |
1.59 | 1 | |
3.37 | 1 | |
3.45 | 1 | |
4.16 | 1 | |
4.42 | 1 | |
4.52 | 1 | |
4.86 | 1 | |
4.98 | 1 | |
5.08 | 1 | |
5.58 | 1 |
Value | Count | Frequency (%) |
100.0 | 1 | |
95.63 | 1 | |
94.69 | 1 | |
88.51 | 1 | |
87.76 | 1 | |
86.23 | 1 | |
85.37 | 1 | |
81.6 | 1 | |
81.18 | 1 | |
79.68 | 1 |
가맹점지수(STORE)
Real number (ℝ)
Distinct | 478 |
---|---|
Distinct (%) | 95.6% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 34.09808 |
Minimum | 4.81 |
---|---|
Maximum | 96.37 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.5 KiB |
Quantile statistics
Minimum | 4.81 |
---|---|
5-th percentile | 11.9595 |
Q1 | 20.4575 |
median | 30.305 |
Q3 | 43.195 |
95-th percentile | 72.3795 |
Maximum | 96.37 |
Range | 91.56 |
Interquartile range (IQR) | 22.7375 |
Descriptive statistics
Standard deviation | 18.248445 |
---|---|
Coefficient of variation (CV) | 0.53517514 |
Kurtosis | 0.81933062 |
Mean | 34.09808 |
Median Absolute Deviation (MAD) | 11.22 |
Skewness | 1.0336442 |
Sum | 17049.04 |
Variance | 333.00574 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
30.27 | 2 | 0.4% |
32.45 | 2 | 0.4% |
47.33 | 2 | 0.4% |
15.14 | 2 | 0.4% |
32.98 | 2 | 0.4% |
41.62 | 2 | 0.4% |
22.78 | 2 | 0.4% |
17.66 | 2 | 0.4% |
31.05 | 2 | 0.4% |
26.92 | 2 | 0.4% |
Other values (468) | 480 |
Value | Count | Frequency (%) |
4.81 | 1 | |
5.28 | 1 | |
5.31 | 1 | |
5.75 | 1 | |
5.81 | 1 | |
6.81 | 1 | |
6.82 | 1 | |
7.9 | 1 | |
8.4 | 1 | |
8.46 | 1 |
Value | Count | Frequency (%) |
96.37 | 1 | |
95.77 | 1 | |
94.45 | 1 | |
93.05 | 1 | |
89.86 | 1 | |
88.64 | 1 | |
87.1 | 1 | |
84.13 | 1 | |
83.96 | 1 | |
82.58 | 1 |
인구지수(POPULATION)
Real number (ℝ)
Distinct | 453 |
---|---|
Distinct (%) | 91.0% |
Missing | 2 |
Missing (%) | 0.4% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 27.728072 |
Minimum | 4.25 |
---|---|
Maximum | 82.01 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.5 KiB |
Quantile statistics
Minimum | 4.25 |
---|---|
5-th percentile | 13.6265 |
Q1 | 18.8125 |
median | 23.605 |
Q3 | 32.45 |
95-th percentile | 56.27 |
Maximum | 82.01 |
Range | 77.76 |
Interquartile range (IQR) | 13.6375 |
Descriptive statistics
Standard deviation | 13.408627 |
---|---|
Coefficient of variation (CV) | 0.48357588 |
Kurtosis | 1.5503272 |
Mean | 27.728072 |
Median Absolute Deviation (MAD) | 5.97 |
Skewness | 1.355176 |
Sum | 13808.58 |
Variance | 179.79128 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
16.52 | 3 | 0.6% |
24.01 | 3 | 0.6% |
19.51 | 3 | 0.6% |
19.14 | 2 | 0.4% |
29.81 | 2 | 0.4% |
20.92 | 2 | 0.4% |
25.82 | 2 | 0.4% |
21.8 | 2 | 0.4% |
17.32 | 2 | 0.4% |
21.71 | 2 | 0.4% |
Other values (443) | 475 |
Value | Count | Frequency (%) |
4.25 | 1 | |
4.6 | 1 | |
8.23 | 1 | |
8.75 | 1 | |
8.78 | 1 | |
9.75 | 1 | |
10.72 | 1 | |
10.98 | 1 | |
11.1 | 1 | |
11.12 | 1 |
Value | Count | Frequency (%) |
82.01 | 1 | |
76.09 | 1 | |
74.38 | 1 | |
73.94 | 1 | |
73.4 | 1 | |
72.84 | 1 | |
66.17 | 1 | |
64.88 | 1 | |
63.9 | 1 | |
63.63 | 1 |
금융지수(DEPOSIT)
Real number (ℝ)
MISSING
 
Distinct | 403 |
---|---|
Distinct (%) | 91.0% |
Missing | 57 |
Missing (%) | 11.4% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 49.919029 |
Minimum | 9.41 |
---|---|
Maximum | 90 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.5 KiB |
Quantile statistics
Minimum | 9.41 |
---|---|
5-th percentile | 35.93 |
Q1 | 42.94 |
median | 48.09 |
Q3 | 55.385 |
95-th percentile | 72.808 |
Maximum | 90 |
Range | 80.59 |
Interquartile range (IQR) | 12.445 |
Descriptive statistics
Standard deviation | 11.101241 |
---|---|
Coefficient of variation (CV) | 0.22238496 |
Kurtosis | 1.7347058 |
Mean | 49.919029 |
Median Absolute Deviation (MAD) | 6.07 |
Skewness | 0.79642764 |
Sum | 22114.13 |
Variance | 123.23755 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
42.02 | 3 | 0.6% |
45.52 | 3 | 0.6% |
53.63 | 3 | 0.6% |
42.64 | 2 | 0.4% |
52.7 | 2 | 0.4% |
37.47 | 2 | 0.4% |
62.45 | 2 | 0.4% |
45.18 | 2 | 0.4% |
46.6 | 2 | 0.4% |
47.21 | 2 | 0.4% |
Other values (393) | 420 | |
(Missing) | 57 | 11.4% |
Value | Count | Frequency (%) |
9.41 | 1 | |
12.53 | 1 | |
28.06 | 1 | |
29.4 | 1 | |
30.11 | 1 | |
30.3 | 1 | |
30.96 | 1 | |
31.14 | 1 | |
31.83 | 1 | |
32.22 | 1 |
Value | Count | Frequency (%) |
90.0 | 1 | |
89.87 | 1 | |
89.12 | 1 | |
89.03 | 1 | |
84.79 | 1 | |
81.3 | 1 | |
80.78 | 1 | |
79.28 | 1 | |
78.95 | 1 | |
78.39 | 1 |
일자(DATE) | 상권구분코드(TRDAR_SE_CD) | 상권번호(TRDAR_NO) | 매출지수(SALES) | 인프라지수(INFRASTRUCTURE) | 가맹점지수(STORE) | 인구지수(POPULATION) | 금융지수(DEPOSIT) | |
---|---|---|---|---|---|---|---|---|
일자(DATE) | 1.000 | 0.047 | 0.033 | 0.101 | 0.000 | 0.000 | 0.054 | 0.000 |
상권구분코드(TRDAR_SE_CD) | 0.047 | 1.000 | 0.000 | 0.156 | 0.161 | 0.000 | 0.230 | 0.153 |
상권번호(TRDAR_NO) | 0.033 | 0.000 | 1.000 | 0.000 | 0.000 | 0.133 | 0.113 | 0.000 |
매출지수(SALES) | 0.101 | 0.156 | 0.000 | 1.000 | 0.240 | 0.000 | 0.000 | 0.086 |
인프라지수(INFRASTRUCTURE) | 0.000 | 0.161 | 0.000 | 0.240 | 1.000 | 0.227 | 0.000 | 0.130 |
가맹점지수(STORE) | 0.000 | 0.000 | 0.133 | 0.000 | 0.227 | 1.000 | 0.000 | 0.129 |
인구지수(POPULATION) | 0.054 | 0.230 | 0.113 | 0.000 | 0.000 | 0.000 | 1.000 | 0.177 |
금융지수(DEPOSIT) | 0.000 | 0.153 | 0.000 | 0.086 | 0.130 | 0.129 | 0.177 | 1.000 |
일자(DATE) | 상권번호(TRDAR_NO) | 매출지수(SALES) | 인프라지수(INFRASTRUCTURE) | 가맹점지수(STORE) | 인구지수(POPULATION) | 금융지수(DEPOSIT) | 상권구분코드(TRDAR_SE_CD) | |
---|---|---|---|---|---|---|---|---|
일자(DATE) | 1.000 | -0.017 | 0.052 | 0.060 | 0.085 | 0.026 | 0.044 | 0.076 |
상권번호(TRDAR_NO) | -0.017 | 1.000 | -0.009 | 0.007 | -0.009 | -0.004 | 0.031 | 0.000 |
매출지수(SALES) | 0.052 | -0.009 | 1.000 | -0.069 | -0.009 | -0.016 | -0.043 | 0.093 |
인프라지수(INFRASTRUCTURE) | 0.060 | 0.007 | -0.069 | 1.000 | -0.045 | -0.007 | 0.016 | 0.095 |
가맹점지수(STORE) | 0.085 | -0.009 | -0.009 | -0.045 | 1.000 | 0.012 | 0.083 | 0.000 |
인구지수(POPULATION) | 0.026 | -0.004 | -0.016 | -0.007 | 0.012 | 1.000 | 0.023 | 0.140 |
금융지수(DEPOSIT) | 0.044 | 0.031 | -0.043 | 0.016 | 0.083 | 0.023 | 1.000 | 0.067 |
상권구분코드(TRDAR_SE_CD) | 0.076 | 0.000 | 0.093 | 0.095 | 0.000 | 0.140 | 0.067 | 1.000 |
일자(DATE) | 상권구분코드(TRDAR_SE_CD) | 상권번호(TRDAR_NO) | 매출지수(SALES) | 인프라지수(INFRASTRUCTURE) | 가맹점지수(STORE) | 인구지수(POPULATION) | 금융지수(DEPOSIT) | |
---|---|---|---|---|---|---|---|---|
0 | 201903 | A | 1000433 | 14.19 | 30.07 | 41.69 | 36.05 | 44.34 |
1 | 201811 | A | 1000689 | 7.7 | 13.33 | 25.51 | 29.25 | 40.9 |
2 | 201804 | A | 1001174 | 13.6 | 17.32 | 20.25 | 34.27 | 54.34 |
3 | 201906 | R | 1000583 | 13.23 | 52.79 | 28.18 | 41.15 | 52.19 |
4 | 201806 | R | 1000916 | 48.81 | 13.61 | 21.26 | 72.84 | 48.56 |
5 | 201908 | A | 1001141 | 16.21 | 19.37 | 22.28 | 27.2 | 39.69 |
6 | 201912 | A | 1001076 | 20.13 | 29.15 | 16.72 | 17.54 | 55.03 |
7 | 201812 | R | 1000857 | 13.15 | 17.5 | 14.36 | 19.97 | 42.98 |
8 | 201802 | A | 1000495 | 9.11 | <NA> | 18.01 | 8.78 | 45.24 |
9 | 201905 | R | 1001112 | 10.31 | 17.14 | 18.97 | 35.51 | 46.44 |
일자(DATE) | 상권구분코드(TRDAR_SE_CD) | 상권번호(TRDAR_NO) | 매출지수(SALES) | 인프라지수(INFRASTRUCTURE) | 가맹점지수(STORE) | 인구지수(POPULATION) | 금융지수(DEPOSIT) | |
---|---|---|---|---|---|---|---|---|
490 | 201910 | D | 1000387 | 6.31 | 10.92 | 96.37 | 50.05 | 43.69 |
491 | 201911 | A | 1000502 | 12.69 | <NA> | 22.32 | 60.76 | 89.87 |
492 | 201807 | A | 1001192 | 5.88 | 26.27 | 47.33 | 15.35 | 58.53 |
493 | 201907 | A | 1000855 | 75.12 | 29.08 | 12.39 | 29.41 | <NA> |
494 | 201808 | A | 1000660 | 4.01 | 17.38 | 20.31 | 25.39 | 37.68 |
495 | 201802 | A | 1001162 | 39.47 | 28.67 | 4.81 | 22.19 | 44.94 |
496 | 201906 | A | 1000629 | 8.87 | 10.45 | 53.71 | 29.2 | 59.92 |
497 | 201905 | A | 1000833 | 11.31 | 12.15 | 40.41 | 32.21 | 40.87 |
498 | 201804 | A | 1001073 | 30.24 | 8.22 | 9.47 | 15.58 | 34.64 |
499 | 201904 | A | 1000966 | 25.94 | 35.22 | 32.65 | 19.38 | <NA> |