Dataset statistics
Number of variables | 8 |
---|---|
Number of observations | 10000 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 819 |
Duplicate rows (%) | 8.2% |
Total size in memory | 742.2 KiB |
Average record size in memory | 76.0 B |
Variable types
Categorical | 3 |
---|---|
Numeric | 4 |
DateTime | 1 |
Dataset
Description | 광주광역시 서구 관급봉투관리시스템의 종량제봉투(납부필증) 판매현황 정보입니다. |
---|---|
Author | 광주광역시 서구 |
URL | https://www.data.go.kr/data/15039805/fileData.do |
기관명 has constant value "" | Constant |
판매구분 has constant value "" | Constant |
데이터기준일자 has constant value "" | Constant |
Dataset has 819 (8.2%) duplicate rows | Duplicates |
바코드번호 is highly overall correlated with 봉투구분 | High correlation |
봉투구분 is highly overall correlated with 바코드번호 | High correlation |
금액 is highly skewed (γ1 = 25.47593399) | Skewed |
금액 has 360 (3.6%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-12 16:19:25.583059 |
---|---|
Analysis finished | 2023-12-12 16:19:28.428263 |
Duration | 2.85 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
기관명
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
서구청 |
---|
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 서구청 |
---|---|
2nd row | 서구청 |
3rd row | 서구청 |
4th row | 서구청 |
5th row | 서구청 |
Common Values
Value | Count | Frequency (%) |
서구청 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
서구청 | 10000 |
수불날짜
Real number (ℝ)
Distinct | 167 |
---|---|
Distinct (%) | 1.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 20190445 |
Minimum | 20190102 |
---|---|
Maximum | 20190902 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 20190102 |
---|---|
5-th percentile | 20190110 |
Q1 | 20190221 |
median | 20190417 |
Q3 | 20190702 |
95-th percentile | 20190820 |
Maximum | 20190902 |
Range | 800 |
Interquartile range (IQR) | 481 |
Descriptive statistics
Standard deviation | 241.536 |
---|---|
Coefficient of variation (CV) | 1.1962886 × 10-5 |
Kurtosis | -1.3052164 |
Mean | 20190445 |
Median Absolute Deviation (MAD) | 203 |
Skewness | 0.13470176 |
Sum | 2.0190445 × 1011 |
Variance | 58339.638 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20190125 | 156 | 1.6% |
20190222 | 146 | 1.5% |
20190129 | 130 | 1.3% |
20190308 | 119 | 1.2% |
20190104 | 114 | 1.1% |
20190109 | 113 | 1.1% |
20190118 | 111 | 1.1% |
20190214 | 98 | 1.0% |
20190131 | 97 | 1.0% |
20190705 | 97 | 1.0% |
Other values (157) | 8819 |
Value | Count | Frequency (%) |
20190102 | 55 | |
20190103 | 67 | |
20190104 | 114 | |
20190107 | 53 | |
20190108 | 75 | |
20190109 | 113 | |
20190110 | 69 | |
20190111 | 57 | |
20190114 | 49 | |
20190115 | 78 |
Value | Count | Frequency (%) |
20190902 | 45 | |
20190830 | 59 | |
20190829 | 42 | |
20190828 | 50 | |
20190827 | 50 | |
20190826 | 35 | 0.4% |
20190823 | 89 | |
20190822 | 51 | |
20190821 | 58 | |
20190820 | 69 |
판매구분
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
일반판매 |
---|
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
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 (%) |
일반판매 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
일반판매 | 10000 |
바코드번호
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 896 |
---|---|
Distinct (%) | 9.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 5.6548727 × 1011 |
Minimum | 1.215 × 1010 |
---|---|
Maximum | 9.05 × 1011 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 1.215 × 1010 |
---|---|
5-th percentile | 9.9160001 × 1010 |
Q1 | 3.96 × 1011 |
median | 5.9 × 1011 |
Q3 | 6.33 × 1011 |
95-th percentile | 9.05 × 1011 |
Maximum | 9.05 × 1011 |
Range | 8.9285 × 1011 |
Interquartile range (IQR) | 2.37 × 1011 |
Descriptive statistics
Standard deviation | 2.4887611 × 1011 |
---|---|
Coefficient of variation (CV) | 0.44010913 |
Kurtosis | -0.38765295 |
Mean | 5.6548727 × 1011 |
Median Absolute Deviation (MAD) | 4.3 × 1010 |
Skewness | -0.59463123 |
Sum | 5.6548727 × 1015 |
Variance | 6.1939318 × 1022 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
584000000000 | 1609 | |
613000000000 | 1111 | |
609000000000 | 864 | |
905000000000 | 849 | |
879000000000 | 827 | |
119000000000 | 691 | 6.9% |
590000000000 | 666 | 6.7% |
854000000000 | 574 | 5.7% |
633000000000 | 545 | 5.5% |
370000000000 | 469 | 4.7% |
Other values (886) | 1795 |
Value | Count | Frequency (%) |
12150000006 | 1 | |
12150000010 | 1 | |
12150000012 | 1 | |
12150000016 | 1 | |
12160000735 | 1 | |
12160000736 | 1 | |
12160000737 | 1 | |
12160006515 | 1 | |
12160006524 | 1 | |
12160006573 | 1 |
Value | Count | Frequency (%) |
905000000000 | 849 | |
879000000000 | 827 | |
854000000000 | 574 | 5.7% |
844000000000 | 101 | 1.0% |
794000000000 | 1 | < 0.1% |
633000000000 | 545 | 5.5% |
613000000000 | 1111 | |
609000000000 | 864 | |
590000000000 | 666 | |
584000000000 | 1609 |
금액
Real number (ℝ)
SKEWED
  ZEROS
 
Distinct | 21 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 14294.354 |
Minimum | 0 |
---|---|
Maximum | 1336000 |
Zeros | 360 |
Zeros (%) | 3.6% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 3600 |
Q1 | 6800 |
median | 13400 |
Q3 | 20200 |
95-th percentile | 33400 |
Maximum | 1336000 |
Range | 1336000 |
Interquartile range (IQR) | 13400 |
Descriptive statistics
Standard deviation | 46363.208 |
---|---|
Coefficient of variation (CV) | 3.243463 |
Kurtosis | 672.73035 |
Mean | 14294.354 |
Median Absolute Deviation (MAD) | 6600 |
Skewness | 25.475934 |
Sum | 1.4294354 × 108 |
Variance | 2.1495471 × 109 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
7000 | 2168 | |
13600 | 2100 | |
20200 | 1623 | |
33400 | 894 | |
6800 | 877 | |
3800 | 720 | 7.2% |
13400 | 651 | 6.5% |
3600 | 519 | 5.2% |
0 | 360 | 3.6% |
1010 | 32 | 0.3% |
Other values (11) | 56 | 0.6% |
Value | Count | Frequency (%) |
0 | 360 | |
180 | 4 | < 0.1% |
350 | 2 | < 0.1% |
670 | 2 | < 0.1% |
680 | 8 | 0.1% |
1010 | 32 | 0.3% |
1670 | 26 | 0.3% |
3600 | 519 | |
3800 | 720 | |
6800 | 877 |
Value | Count | Frequency (%) |
1336000 | 2 | < 0.1% |
1260000 | 4 | < 0.1% |
1224000 | 4 | < 0.1% |
1212000 | 2 | < 0.1% |
1206000 | 1 | < 0.1% |
950000 | 1 | < 0.1% |
33400 | 894 | |
20200 | 1623 | |
13600 | 2100 | |
13400 | 651 | 6.5% |
수량
Real number (ℝ)
Distinct | 7 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 58.6182 |
Minimum | 1 |
---|---|
Maximum | 5000 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 20 |
Q1 | 20 |
median | 20 |
Q3 | 20 |
95-th percentile | 20 |
Maximum | 5000 |
Range | 4999 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 314.84217 |
---|---|
Coefficient of variation (CV) | 5.3710651 |
Kurtosis | 118.25659 |
Mean | 58.6182 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 10.183722 |
Sum | 586182 |
Variance | 99125.589 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20 | 9694 | |
1 | 102 | 1.0% |
1800 | 68 | 0.7% |
1200 | 49 | 0.5% |
800 | 41 | 0.4% |
3600 | 37 | 0.4% |
5000 | 9 | 0.1% |
Value | Count | Frequency (%) |
1 | 102 | 1.0% |
20 | 9694 | |
800 | 41 | 0.4% |
1200 | 49 | 0.5% |
1800 | 68 | 0.7% |
3600 | 37 | 0.4% |
5000 | 9 | 0.1% |
Value | Count | Frequency (%) |
5000 | 9 | 0.1% |
3600 | 37 | 0.4% |
1800 | 68 | 0.7% |
1200 | 49 | 0.5% |
800 | 41 | 0.4% |
20 | 9694 | |
1 | 102 | 1.0% |
봉투구분
Categorical
HIGH CORRELATION
 
Distinct | 5 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
10리터 | |
---|---|
20리터 | |
30리터 | |
5리터 | |
50리터 |
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 3.8737 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 10리터 |
---|---|
2nd row | 10리터 |
3rd row | 20리터 |
4th row | 5리터 |
5th row | 5리터 |
Common Values
Value | Count | Frequency (%) |
10리터 | 3199 | |
20리터 | 2873 | |
30리터 | 1704 | |
5리터 | 1263 | 12.6% |
50리터 | 961 | 9.6% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
10리터 | 3199 | |
20리터 | 2873 | |
30리터 | 1704 | |
5리터 | 1263 | 12.6% |
50리터 | 961 | 9.6% |
데이터기준일자
Date
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
Minimum | 2021-01-07 00:00:00 |
---|---|
Maximum | 2021-01-07 00:00:00 |
수불날짜 | 바코드번호 | 금액 | 수량 | 봉투구분 | |
---|---|---|---|---|---|
수불날짜 | 1.000 | 0.577 | 0.041 | 0.184 | 0.390 |
바코드번호 | 0.577 | 1.000 | 0.000 | 0.136 | 0.691 |
금액 | 0.041 | 0.000 | 1.000 | 0.600 | 0.012 |
수량 | 0.184 | 0.136 | 0.600 | 1.000 | 0.221 |
봉투구분 | 0.390 | 0.691 | 0.012 | 0.221 | 1.000 |
수불날짜 | 바코드번호 | 금액 | 수량 | 봉투구분 | |
---|---|---|---|---|---|
수불날짜 | 1.000 | -0.012 | -0.297 | -0.016 | 0.172 |
바코드번호 | -0.012 | 1.000 | 0.282 | -0.004 | 0.538 |
금액 | -0.297 | 0.282 | 1.000 | -0.076 | 0.009 |
수량 | -0.016 | -0.004 | -0.076 | 1.000 | 0.151 |
봉투구분 | 0.172 | 0.538 | 0.009 | 0.151 | 1.000 |
기관명 | 수불날짜 | 판매구분 | 바코드번호 | 금액 | 수량 | 봉투구분 | 데이터기준일자 | |
---|---|---|---|---|---|---|---|---|
20500 | 서구청 | 20190308 | 일반판매 | 584000000000 | 7000 | 20 | 10리터 | 2021-01-07 |
25395 | 서구청 | 20190422 | 일반판매 | 584000000000 | 0 | 20 | 10리터 | 2021-01-07 |
44326 | 서구청 | 20190116 | 일반판매 | 396000000000 | 13600 | 20 | 20리터 | 2021-01-07 |
1944 | 서구청 | 20190222 | 일반판매 | 347000000000 | 3800 | 20 | 5리터 | 2021-01-07 |
6480 | 서구청 | 20190614 | 일반판매 | 590000000000 | 3800 | 20 | 5리터 | 2021-01-07 |
23965 | 서구청 | 20190409 | 일반판매 | 584000000000 | 7000 | 20 | 10리터 | 2021-01-07 |
45794 | 서구청 | 20190124 | 일반판매 | 609000000000 | 13600 | 20 | 20리터 | 2021-01-07 |
24756 | 서구청 | 20190416 | 일반판매 | 584000000000 | 7000 | 20 | 10리터 | 2021-01-07 |
94546 | 서구청 | 20190409 | 일반판매 | 905000000000 | 1670 | 1 | 50리터 | 2021-01-07 |
94194 | 서구청 | 20190404 | 일반판매 | 905000000000 | 33400 | 20 | 50리터 | 2021-01-07 |
기관명 | 수불날짜 | 판매구분 | 바코드번호 | 금액 | 수량 | 봉투구분 | 데이터기준일자 | |
---|---|---|---|---|---|---|---|---|
40575 | 서구청 | 20190821 | 일반판매 | 613000000000 | 0 | 20 | 10리터 | 2021-01-07 |
92147 | 서구청 | 20190308 | 일반판매 | 905000000000 | 33400 | 20 | 50리터 | 2021-01-07 |
70951 | 서구청 | 20190115 | 일반판매 | 74230005704 | 20200 | 20 | 30리터 | 2021-01-07 |
40449 | 서구청 | 20190821 | 일반판매 | 613000000000 | 6800 | 20 | 10리터 | 2021-01-07 |
70540 | 서구청 | 20190109 | 일반판매 | 74230002453 | 20200 | 20 | 30리터 | 2021-01-07 |
84471 | 서구청 | 20190808 | 일반판매 | 119000000000 | 20200 | 20 | 30리터 | 2021-01-07 |
11906 | 서구청 | 20190102 | 일반판매 | 370000000000 | 7000 | 20 | 10리터 | 2021-01-07 |
62410 | 서구청 | 20190619 | 일반판매 | 633000000000 | 13600 | 20 | 20리터 | 2021-01-07 |
2714 | 서구청 | 20190315 | 일반판매 | 561000000000 | 3800 | 20 | 5리터 | 2021-01-07 |
50773 | 서구청 | 20190305 | 일반판매 | 609000000000 | 13600 | 20 | 20리터 | 2021-01-07 |
Most frequently occurring
기관명 | 수불날짜 | 판매구분 | 바코드번호 | 금액 | 수량 | 봉투구분 | 데이터기준일자 | # duplicates | |
---|---|---|---|---|---|---|---|---|---|
101 | 서구청 | 20190129 | 일반판매 | 609000000000 | 13600 | 20 | 20리터 | 2021-01-07 | 38 |
5 | 서구청 | 20190104 | 일반판매 | 370000000000 | 7000 | 20 | 10리터 | 2021-01-07 | 36 |
182 | 서구청 | 20190222 | 일반판매 | 609000000000 | 13600 | 20 | 20리터 | 2021-01-07 | 36 |
752 | 서구청 | 20190808 | 일반판매 | 613000000000 | 6800 | 20 | 10리터 | 2021-01-07 | 36 |
113 | 서구청 | 20190131 | 일반판매 | 609000000000 | 13600 | 20 | 20리터 | 2021-01-07 | 35 |
675 | 서구청 | 20190705 | 일반판매 | 613000000000 | 6800 | 20 | 10리터 | 2021-01-07 | 35 |
146 | 서구청 | 20190214 | 일반판매 | 584000000000 | 7000 | 20 | 10리터 | 2021-01-07 | 34 |
151 | 서구청 | 20190215 | 일반판매 | 584000000000 | 7000 | 20 | 10리터 | 2021-01-07 | 34 |
51 | 서구청 | 20190118 | 일반판매 | 370000000000 | 7000 | 20 | 10리터 | 2021-01-07 | 32 |
180 | 서구청 | 20190222 | 일반판매 | 584000000000 | 7000 | 20 | 10리터 | 2021-01-07 | 32 |