Dataset statistics
Number of variables | 8 |
---|---|
Number of observations | 31 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 2.3 KiB |
Average record size in memory | 75.3 B |
Variable types
Categorical | 1 |
---|---|
Text | 1 |
Numeric | 6 |
Dataset
Description | 하수도요금 현황 |
---|---|
Author | 경기도 |
URL | https://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=G2A890QDSDU47X0126ZQ12049961&infSeq=1 |
집계년도 has constant value "" | Constant |
연간부과량(천톤) is highly overall correlated with 부과액(백만원) and 3 other fields | High correlation |
부과액(백만원) is highly overall correlated with 연간부과량(천톤) and 3 other fields | High correlation |
평균단가(원/톤) is highly overall correlated with 처리원가(원/톤) | High correlation |
총괄원가(백만원) is highly overall correlated with 연간부과량(천톤) and 1 other fields | High correlation |
처리원가(원/톤) is highly overall correlated with 연간부과량(천톤) and 3 other fields | High correlation |
현실화율(%) is highly overall correlated with 연간부과량(천톤) and 2 other fields | High correlation |
시군명 has unique values | Unique |
연간부과량(천톤) has unique values | Unique |
부과액(백만원) has unique values | Unique |
총괄원가(백만원) has unique values | Unique |
처리원가(원/톤) has unique values | Unique |
현실화율(%) has unique values | Unique |
Reproduction
Analysis started | 2023-12-10 21:14:45.375012 |
---|---|
Analysis finished | 2023-12-10 21:14:48.741727 |
Duration | 3.37 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
집계년도
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 3.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 380.0 B |
2021 |
---|
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2021 |
---|---|
2nd row | 2021 |
3rd row | 2021 |
4th row | 2021 |
5th row | 2021 |
Common Values
Value | Count | Frequency (%) |
2021 | 31 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2021 | 31 |
시군명
Text
UNIQUE
 
Distinct | 31 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 380.0 B |
Value | Count | Frequency (%) |
가평군 | 1 | 3.2% |
안양시 | 1 | 3.2% |
하남시 | 1 | 3.2% |
포천시 | 1 | 3.2% |
평택시 | 1 | 3.2% |
파주시 | 1 | 3.2% |
이천시 | 1 | 3.2% |
의정부시 | 1 | 3.2% |
의왕시 | 1 | 3.2% |
용인시 | 1 | 3.2% |
Other values (21) | 21 |
Most occurring characters
Value | Count | Frequency (%) |
시 | 29 | |
천 | 6 | 6.2% |
양 | 5 | 5.2% |
주 | 5 | 5.2% |
군 | 4 | 4.2% |
성 | 3 | 3.1% |
포 | 3 | 3.1% |
안 | 3 | 3.1% |
평 | 3 | 3.1% |
남 | 3 | 3.1% |
Other values (28) | 32 |
Most occurring categories
Value | Count | Frequency (%) |
Other Letter | 96 |
Most frequent character per category
Other Letter
Value | Count | Frequency (%) |
시 | 29 | |
천 | 6 | 6.2% |
양 | 5 | 5.2% |
주 | 5 | 5.2% |
군 | 4 | 4.2% |
성 | 3 | 3.1% |
포 | 3 | 3.1% |
안 | 3 | 3.1% |
평 | 3 | 3.1% |
남 | 3 | 3.1% |
Other values (28) | 32 |
Most occurring scripts
Value | Count | Frequency (%) |
Hangul | 96 |
Most frequent character per script
Hangul
Value | Count | Frequency (%) |
시 | 29 | |
천 | 6 | 6.2% |
양 | 5 | 5.2% |
주 | 5 | 5.2% |
군 | 4 | 4.2% |
성 | 3 | 3.1% |
포 | 3 | 3.1% |
안 | 3 | 3.1% |
평 | 3 | 3.1% |
남 | 3 | 3.1% |
Other values (28) | 32 |
Most occurring blocks
Value | Count | Frequency (%) |
Hangul | 96 |
Most frequent character per block
Hangul
Value | Count | Frequency (%) |
시 | 29 | |
천 | 6 | 6.2% |
양 | 5 | 5.2% |
주 | 5 | 5.2% |
군 | 4 | 4.2% |
성 | 3 | 3.1% |
포 | 3 | 3.1% |
안 | 3 | 3.1% |
평 | 3 | 3.1% |
남 | 3 | 3.1% |
Other values (28) | 32 |
연간부과량(천톤)
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 31 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 47115.226 |
Minimum | 5574 |
---|---|
Maximum | 139977 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 5574 |
---|---|
5-th percentile | 6201 |
Q1 | 16081.5 |
median | 40752 |
Q3 | 65677 |
95-th percentile | 117505.5 |
Maximum | 139977 |
Range | 134403 |
Interquartile range (IQR) | 49595.5 |
Descriptive statistics
Standard deviation | 37736.743 |
---|---|
Coefficient of variation (CV) | 0.80094581 |
Kurtosis | 0.19285786 |
Mean | 47115.226 |
Median Absolute Deviation (MAD) | 25278 |
Skewness | 0.99062733 |
Sum | 1460572 |
Variance | 1.4240618 × 109 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
6109 | 1 | 3.2% |
100154 | 1 | 3.2% |
77956 | 1 | 3.2% |
28349 | 1 | 3.2% |
12919 | 1 | 3.2% |
56155 | 1 | 3.2% |
41769 | 1 | 3.2% |
20426 | 1 | 3.2% |
44513 | 1 | 3.2% |
16689 | 1 | 3.2% |
Other values (21) | 21 |
Value | Count | Frequency (%) |
5574 | 1 | |
6109 | 1 | |
6293 | 1 | |
7097 | 1 | |
8728 | 1 | |
12919 | 1 | |
15065 | 1 | |
15474 | 1 | |
16689 | 1 | |
20426 | 1 |
Value | Count | Frequency (%) |
139977 | 1 | |
132331 | 1 | |
102680 | 1 | |
100730 | 1 | |
100154 | 1 | |
87298 | 1 | |
77956 | 1 | |
66639 | 1 | |
64715 | 1 | |
56949 | 1 |
부과액(백만원)
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 31 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 28641.452 |
Minimum | 1707 |
---|---|
Maximum | 74336 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 1707 |
---|---|
5-th percentile | 4563 |
Q1 | 13111 |
median | 24116 |
Q3 | 41919 |
95-th percentile | 65716.5 |
Maximum | 74336 |
Range | 72629 |
Interquartile range (IQR) | 28808 |
Descriptive statistics
Standard deviation | 20757.502 |
---|---|
Coefficient of variation (CV) | 0.72473638 |
Kurtosis | -0.55898417 |
Mean | 28641.452 |
Median Absolute Deviation (MAD) | 14203 |
Skewness | 0.66874012 |
Sum | 887885 |
Variance | 4.3087388 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
5416 | 1 | 3.2% |
61269 | 1 | 3.2% |
63272 | 1 | 3.2% |
14594 | 1 | 3.2% |
11628 | 1 | 3.2% |
38319 | 1 | 3.2% |
41986 | 1 | 3.2% |
16143 | 1 | 3.2% |
25320 | 1 | 3.2% |
15561 | 1 | 3.2% |
Other values (21) | 21 |
Value | Count | Frequency (%) |
1707 | 1 | |
3962 | 1 | |
5164 | 1 | |
5416 | 1 | |
5681 | 1 | |
8193 | 1 | |
10085 | 1 | |
11628 | 1 | |
14594 | 1 | |
14665 | 1 |
Value | Count | Frequency (%) |
74336 | 1 | |
68161 | 1 | |
63272 | 1 | |
61269 | 1 | |
57233 | 1 | |
48075 | 1 | |
42093 | 1 | |
41986 | 1 | |
41852 | 1 | |
38319 | 1 |
평균단가(원/톤)
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 30 |
---|---|
Distinct (%) | 96.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 657.12903 |
Minimum | 196 |
---|---|
Maximum | 1041 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 196 |
---|---|
5-th percentile | 425.5 |
Q1 | 530.5 |
median | 647 |
Q3 | 806.5 |
95-th percentile | 968.5 |
Maximum | 1041 |
Range | 845 |
Interquartile range (IQR) | 276 |
Descriptive statistics
Standard deviation | 189.793 |
---|---|
Coefficient of variation (CV) | 0.28882151 |
Kurtosis | 0.00027230604 |
Mean | 657.12903 |
Median Absolute Deviation (MAD) | 132 |
Skewness | 0.071820759 |
Sum | 20371 |
Variance | 36021.383 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
812 | 2 | 6.5% |
887 | 1 | 3.2% |
562 | 1 | 3.2% |
515 | 1 | 3.2% |
900 | 1 | 3.2% |
682 | 1 | 3.2% |
1005 | 1 | 3.2% |
790 | 1 | 3.2% |
569 | 1 | 3.2% |
932 | 1 | 3.2% |
Other values (20) | 20 |
Value | Count | Frequency (%) |
196 | 1 | |
418 | 1 | |
433 | 1 | |
470 | 1 | |
479 | 1 | |
515 | 1 | |
519 | 1 | |
530 | 1 | |
531 | 1 | |
545 | 1 |
Value | Count | Frequency (%) |
1041 | 1 | |
1005 | 1 | |
932 | 1 | |
900 | 1 | |
887 | 1 | |
821 | 1 | |
812 | 2 | |
801 | 1 | |
790 | 1 | |
711 | 1 |
총괄원가(백만원)
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 31 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 60912.903 |
Minimum | 14882 |
---|---|
Maximum | 163115 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 14882 |
---|---|
5-th percentile | 18487 |
Q1 | 40982.5 |
median | 51627 |
Q3 | 80372 |
95-th percentile | 105191.5 |
Maximum | 163115 |
Range | 148233 |
Interquartile range (IQR) | 39389.5 |
Descriptive statistics
Standard deviation | 33861.58 |
---|---|
Coefficient of variation (CV) | 0.5559016 |
Kurtosis | 1.1268881 |
Mean | 60912.903 |
Median Absolute Deviation (MAD) | 23999 |
Skewness | 0.90653612 |
Sum | 1888300 |
Variance | 1.1466066 × 109 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
43693 | 1 | 3.2% |
102389 | 1 | 3.2% |
107622 | 1 | 3.2% |
42982 | 1 | 3.2% |
52189 | 1 | 3.2% |
101616 | 1 | 3.2% |
90414 | 1 | 3.2% |
41194 | 1 | 3.2% |
51627 | 1 | 3.2% |
16807 | 1 | 3.2% |
Other values (21) | 21 |
Value | Count | Frequency (%) |
14882 | 1 | |
16807 | 1 | |
20167 | 1 | |
21266 | 1 | |
23227 | 1 | |
25025 | 1 | |
31798 | 1 | |
40771 | 1 | |
41194 | 1 | |
42436 | 1 |
Value | Count | Frequency (%) |
163115 | 1 | |
107622 | 1 | |
102761 | 1 | |
102389 | 1 | |
101616 | 1 | |
94713 | 1 | |
90414 | 1 | |
82105 | 1 | |
78639 | 1 | |
75626 | 1 |
처리원가(원/톤)
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 31 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2034.3226 |
Minimum | 572 |
---|---|
Maximum | 7152 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 572 |
---|---|
5-th percentile | 693 |
Q1 | 1004 |
median | 1381 |
Q3 | 2319.5 |
95-th percentile | 6257.5 |
Maximum | 7152 |
Range | 6580 |
Interquartile range (IQR) | 1315.5 |
Descriptive statistics
Standard deviation | 1707.0173 |
---|---|
Coefficient of variation (CV) | 0.83910847 |
Kurtosis | 3.5354478 |
Mean | 2034.3226 |
Median Absolute Deviation (MAD) | 600 |
Skewness | 2.0062728 |
Sum | 63064 |
Variance | 2913908.1 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
7152 | 1 | 3.2% |
1022 | 1 | 3.2% |
1381 | 1 | 3.2% |
1516 | 1 | 3.2% |
4040 | 1 | 3.2% |
1810 | 1 | 3.2% |
2165 | 1 | 3.2% |
2017 | 1 | 3.2% |
1160 | 1 | 3.2% |
1007 | 1 | 3.2% |
Other values (21) | 21 |
Value | Count | Frequency (%) |
572 | 1 | |
677 | 1 | |
709 | 1 | |
744 | 1 | |
781 | 1 | |
821 | 1 | |
991 | 1 | |
1001 | 1 | |
1007 | 1 | |
1022 | 1 |
Value | Count | Frequency (%) |
7152 | 1 | |
6810 | 1 | |
5705 | 1 | |
4040 | 1 | |
2867 | 1 | |
2817 | 1 | |
2534 | 1 | |
2365 | 1 | |
2274 | 1 | |
2165 | 1 |
현실화율(%)
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 31 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 45.483871 |
Minimum | 6.8 |
---|---|
Maximum | 92.6 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 6.8 |
---|---|
5-th percentile | 12.1 |
Q1 | 34.35 |
median | 45.8 |
Q3 | 57.65 |
95-th percentile | 77.7 |
Maximum | 92.6 |
Range | 85.8 |
Interquartile range (IQR) | 23.3 |
Descriptive statistics
Standard deviation | 20.930649 |
---|---|
Coefficient of variation (CV) | 0.46017739 |
Kurtosis | -0.17842621 |
Mean | 45.483871 |
Median Absolute Deviation (MAD) | 11.8 |
Skewness | 0.099803976 |
Sum | 1410 |
Variance | 438.09206 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
12.4 | 1 | 3.2% |
59.8 | 1 | 3.2% |
58.8 | 1 | 3.2% |
34.0 | 1 | 3.2% |
22.3 | 1 | 3.2% |
37.7 | 1 | 3.2% |
46.4 | 1 | 3.2% |
39.2 | 1 | 3.2% |
49.0 | 1 | 3.2% |
92.6 | 1 | 3.2% |
Other values (21) | 21 |
Value | Count | Frequency (%) |
6.8 | 1 | |
11.8 | 1 | |
12.4 | 1 | |
12.5 | 1 | |
22.3 | 1 | |
23.8 | 1 | |
32.0 | 1 | |
34.0 | 1 | |
34.7 | 1 | |
37.7 | 1 |
Value | Count | Frequency (%) |
92.6 | 1 | |
78.5 | 1 | |
76.9 | 1 | |
75.7 | 1 | |
67.1 | 1 | |
63.1 | 1 | |
59.8 | 1 | |
58.8 | 1 | |
56.5 | 1 | |
54.4 | 1 |
시군명 | 연간부과량(천톤) | 부과액(백만원) | 평균단가(원/톤) | 총괄원가(백만원) | 처리원가(원/톤) | 현실화율(%) | |
---|---|---|---|---|---|---|---|
시군명 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
연간부과량(천톤) | 1.000 | 1.000 | 0.825 | 0.315 | 0.644 | 0.000 | 0.736 |
부과액(백만원) | 1.000 | 0.825 | 1.000 | 0.000 | 0.719 | 0.000 | 0.889 |
평균단가(원/톤) | 1.000 | 0.315 | 0.000 | 1.000 | 0.375 | 0.740 | 0.000 |
총괄원가(백만원) | 1.000 | 0.644 | 0.719 | 0.375 | 1.000 | 0.000 | 0.000 |
처리원가(원/톤) | 1.000 | 0.000 | 0.000 | 0.740 | 0.000 | 1.000 | 0.640 |
현실화율(%) | 1.000 | 0.736 | 0.889 | 0.000 | 0.000 | 0.640 | 1.000 |
연간부과량(천톤) | 부과액(백만원) | 평균단가(원/톤) | 총괄원가(백만원) | 처리원가(원/톤) | 현실화율(%) | |
---|---|---|---|---|---|---|
연간부과량(천톤) | 1.000 | 0.953 | -0.376 | 0.758 | -0.691 | 0.671 |
부과액(백만원) | 0.953 | 1.000 | -0.102 | 0.850 | -0.543 | 0.634 |
평균단가(원/톤) | -0.376 | -0.102 | 1.000 | 0.097 | 0.620 | -0.264 |
총괄원가(백만원) | 0.758 | 0.850 | 0.097 | 1.000 | -0.091 | 0.182 |
처리원가(원/톤) | -0.691 | -0.543 | 0.620 | -0.091 | 1.000 | -0.902 |
현실화율(%) | 0.671 | 0.634 | -0.264 | 0.182 | -0.902 | 1.000 |
집계년도 | 시군명 | 연간부과량(천톤) | 부과액(백만원) | 평균단가(원/톤) | 총괄원가(백만원) | 처리원가(원/톤) | 현실화율(%) | |
---|---|---|---|---|---|---|---|---|
0 | 2021 | 가평군 | 6109 | 5416 | 887 | 43693 | 7152 | 12.4 |
1 | 2021 | 고양시 | 100154 | 61269 | 612 | 102389 | 1022 | 59.8 |
2 | 2021 | 과천시 | 6293 | 5164 | 821 | 14882 | 2365 | 34.7 |
3 | 2021 | 광명시 | 28463 | 15506 | 545 | 20167 | 709 | 76.9 |
4 | 2021 | 광주시 | 36111 | 37580 | 1041 | 82105 | 2274 | 45.8 |
5 | 2021 | 구리시 | 40752 | 19513 | 479 | 40771 | 1001 | 47.9 |
6 | 2021 | 군포시 | 31227 | 14665 | 470 | 23227 | 744 | 63.1 |
7 | 2021 | 김포시 | 41363 | 28472 | 688 | 50430 | 1219 | 56.5 |
8 | 2021 | 남양주시 | 64715 | 41852 | 647 | 102761 | 1588 | 40.7 |
9 | 2021 | 동두천시 | 15474 | 8193 | 530 | 21266 | 1374 | 38.5 |
집계년도 | 시군명 | 연간부과량(천톤) | 부과액(백만원) | 평균단가(원/톤) | 총괄원가(백만원) | 처리원가(원/톤) | 현실화율(%) | |
---|---|---|---|---|---|---|---|---|
21 | 2021 | 오산시 | 41690 | 24116 | 579 | 44323 | 1063 | 54.4 |
22 | 2021 | 용인시 | 102680 | 68161 | 664 | 163115 | 1589 | 41.8 |
23 | 2021 | 의왕시 | 16689 | 15561 | 932 | 16807 | 1007 | 92.6 |
24 | 2021 | 의정부시 | 44513 | 25320 | 569 | 51627 | 1160 | 49.0 |
25 | 2021 | 이천시 | 20426 | 16143 | 790 | 41194 | 2017 | 39.2 |
26 | 2021 | 파주시 | 41769 | 41986 | 1005 | 90414 | 2165 | 46.4 |
27 | 2021 | 평택시 | 56155 | 38319 | 682 | 101616 | 1810 | 37.7 |
28 | 2021 | 포천시 | 12919 | 11628 | 900 | 52189 | 4040 | 22.3 |
29 | 2021 | 하남시 | 28349 | 14594 | 515 | 42982 | 1516 | 34.0 |
30 | 2021 | 화성시 | 77956 | 63272 | 812 | 107622 | 1381 | 58.8 |