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.2 KiB |
Average record size in memory | 74.3 B |
Variable types
DateTime | 1 |
---|---|
Text | 1 |
Numeric | 6 |
Dataset
Description | 상수도요금 총괄 집계 현황 |
---|---|
Author | 경기도 |
URL | https://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=092B1J2NN3H40A0CIVHN12133362&infSeq=1 |
집계일자 has constant value "" | Constant |
부과량(톤) is highly overall correlated with 부과액(천원) and 3 other fields | High correlation |
부과액(천원) is highly overall correlated with 부과량(톤) and 2 other fields | High correlation |
판매단가(원/㎥) is highly overall correlated with 부과량(톤) and 1 other fields | High correlation |
생산액(천원) is highly overall correlated with 부과량(톤) and 2 other fields | High correlation |
생산원가(원/㎥) is highly overall correlated with 부과량(톤) and 3 other fields | High correlation |
시군명 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 22:29:01.880968 |
---|---|
Analysis finished | 2023-12-10 22:29:05.409440 |
Duration | 3.53 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
집계일자
Date
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 3.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 380.0 B |
Minimum | 2021-12-31 00:00:00 |
---|---|
Maximum | 2021-12-31 00:00:00 |
시군명
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 | 48759435 |
Minimum | 5685767 |
---|---|
Maximum | 1.2278727 × 108 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 5685767 |
---|---|
5-th percentile | 7326946.5 |
Q1 | 18110056 |
median | 31687676 |
Q3 | 76452317 |
95-th percentile | 1.1368585 × 108 |
Maximum | 1.2278727 × 108 |
Range | 1.171015 × 108 |
Interquartile range (IQR) | 58342260 |
Descriptive statistics
Standard deviation | 38476807 |
---|---|
Coefficient of variation (CV) | 0.78911511 |
Kurtosis | -0.89787716 |
Mean | 48759435 |
Median Absolute Deviation (MAD) | 23229596 |
Skewness | 0.725714 |
Sum | 1.5115425 × 109 |
Variance | 1.4804647 × 1015 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
5685767 | 1 | 3.2% |
111111908 | 1 | 3.2% |
114118384 | 1 | 3.2% |
31687676 | 1 | 3.2% |
17333099 | 1 | 3.2% |
113253312 | 1 | 3.2% |
55489404 | 1 | 3.2% |
23058365 | 1 | 3.2% |
44179378 | 1 | 3.2% |
16544933 | 1 | 3.2% |
Other values (21) | 21 |
Value | Count | Frequency (%) |
5685767 | 1 | |
6534897 | 1 | |
8118996 | 1 | |
8458080 | 1 | |
9626819 | 1 | |
12822813 | 1 | |
16544933 | 1 | |
17333099 | 1 | |
18887014 | 1 | |
21987142 | 1 |
Value | Count | Frequency (%) |
122787269 | 1 | |
114118384 | 1 | |
113253312 | 1 | |
112329140 | 1 | |
111111908 | 1 | |
103261372 | 1 | |
88232670 | 1 | |
83197448 | 1 | |
69707186 | 1 | |
56856791 | 1 |
부과액(천원)
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 31 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 33586332 |
Minimum | 5383003 |
---|---|
Maximum | 93916810 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 5383003 |
---|---|
5-th percentile | 7445369.5 |
Q1 | 15387516 |
median | 27240639 |
Q3 | 46823748 |
95-th percentile | 82600253 |
Maximum | 93916810 |
Range | 88533807 |
Interquartile range (IQR) | 31436231 |
Descriptive statistics
Standard deviation | 24418869 |
---|---|
Coefficient of variation (CV) | 0.72704782 |
Kurtosis | 0.27423406 |
Mean | 33586332 |
Median Absolute Deviation (MAD) | 15072542 |
Skewness | 1.0116483 |
Sum | 1.0411763 × 109 |
Variance | 5.9628119 × 1014 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
7239641 | 1 | 3.2% |
65307184 | 1 | 3.2% |
93916810 | 1 | 3.2% |
16653590 | 1 | 3.2% |
17979948 | 1 | 3.2% |
87980116 | 1 | 3.2% |
46574852 | 1 | 3.2% |
27465629 | 1 | 3.2% |
30913652 | 1 | 3.2% |
14350489 | 1 | 3.2% |
Other values (21) | 21 |
Value | Count | Frequency (%) |
5383003 | 1 | |
7239641 | 1 | |
7651098 | 1 | |
8875059 | 1 | |
10654976 | 1 | |
10878605 | 1 | |
12168097 | 1 | |
14350489 | 1 | |
16424544 | 1 | |
16653590 | 1 |
Value | Count | Frequency (%) |
93916810 | 1 | |
87980116 | 1 | |
77220390 | 1 | |
68091903 | 1 | |
65307184 | 1 | |
49644505 | 1 | |
48753867 | 1 | |
47072643 | 1 | |
46574852 | 1 | |
41800121 | 1 |
판매단가(원/㎥)
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 31 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 784.26613 |
Minimum | 404.8 |
---|---|
Maximum | 1339.9 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 404.8 |
---|---|
5-th percentile | 539.055 |
Q1 | 628.34 |
median | 712.19 |
Q3 | 885.975 |
95-th percentile | 1232.215 |
Maximum | 1339.9 |
Range | 935.1 |
Interquartile range (IQR) | 257.635 |
Descriptive statistics
Standard deviation | 222.6168 |
---|---|
Coefficient of variation (CV) | 0.28385364 |
Kurtosis | 0.47204027 |
Mean | 784.26613 |
Median Absolute Deviation (MAD) | 118.75 |
Skewness | 0.8920703 |
Sum | 24312.25 |
Variance | 49558.239 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1273.29 | 1 | 3.2% |
587.76 | 1 | 3.2% |
822.98 | 1 | 3.2% |
525.55 | 1 | 3.2% |
1037.32 | 1 | 3.2% |
776.84 | 1 | 3.2% |
839.35 | 1 | 3.2% |
1191.14 | 1 | 3.2% |
699.73 | 1 | 3.2% |
867.36 | 1 | 3.2% |
Other values (21) | 21 |
Value | Count | Frequency (%) |
404.8 | 1 | |
525.55 | 1 | |
552.56 | 1 | |
565.79 | 1 | |
587.76 | 1 | |
606.18 | 1 | |
611.7 | 1 | |
627.78 | 1 | |
628.9 | 1 | |
637.05 | 1 |
Value | Count | Frequency (%) |
1339.9 | 1 | |
1273.29 | 1 | |
1191.14 | 1 | |
1076.49 | 1 | |
1037.32 | 1 | |
954.39 | 1 | |
921.91 | 1 | |
904.59 | 1 | |
867.36 | 1 | |
839.35 | 1 |
생산액(천원)
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 31 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 42697992 |
Minimum | 8083863 |
---|---|
Maximum | 1.0338142 × 108 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 8083863 |
---|---|
5-th percentile | 15317028 |
Q1 | 20680524 |
median | 33737679 |
Q3 | 58385530 |
95-th percentile | 94702641 |
Maximum | 1.0338142 × 108 |
Range | 95297561 |
Interquartile range (IQR) | 37705007 |
Descriptive statistics
Standard deviation | 27113926 |
---|---|
Coefficient of variation (CV) | 0.63501642 |
Kurtosis | -0.34862023 |
Mean | 42697992 |
Median Absolute Deviation (MAD) | 15389503 |
Skewness | 0.86351007 |
Sum | 1.3236378 × 109 |
Variance | 7.3516499 × 1014 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
14224615 | 1 | 3.2% |
78077747 | 1 | 3.2% |
103381424 | 1 | 3.2% |
18029712 | 1 | 3.2% |
30406861 | 1 | 3.2% |
92120048 | 1 | 3.2% |
54889976 | 1 | 3.2% |
29000484 | 1 | 3.2% |
46801885 | 1 | 3.2% |
16858968 | 1 | 3.2% |
Other values (21) | 21 |
Value | Count | Frequency (%) |
8083863 | 1 | |
14224615 | 1 | |
16409441 | 1 | |
16858968 | 1 | |
18029712 | 1 | |
18348176 | 1 | |
20117647 | 1 | |
20589000 | 1 | |
20772047 | 1 | |
21257169 | 1 |
Value | Count | Frequency (%) |
103381424 | 1 | |
97285234 | 1 | |
92120048 | 1 | |
85874155 | 1 | |
78077747 | 1 | |
69387839 | 1 | |
67597713 | 1 | |
58769855 | 1 | |
58001206 | 1 | |
54889976 | 1 |
생산원가(원/㎥)
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 30 |
---|---|
Distinct (%) | 96.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1018.3226 |
Minimum | 562 |
---|---|
Maximum | 2495 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 562 |
---|---|
5-th percentile | 655 |
Q1 | 705.5 |
median | 858 |
Q3 | 1202 |
95-th percentile | 1887.5 |
Maximum | 2495 |
Range | 1933 |
Interquartile range (IQR) | 496.5 |
Descriptive statistics
Standard deviation | 445.75168 |
---|---|
Coefficient of variation (CV) | 0.43773131 |
Kurtosis | 3.2432894 |
Mean | 1018.3226 |
Median Absolute Deviation (MAD) | 158 |
Skewness | 1.8008188 |
Sum | 31568 |
Variance | 198694.56 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
655 | 2 | 6.5% |
2495 | 1 | 3.2% |
1171 | 1 | 3.2% |
906 | 1 | 3.2% |
562 | 1 | 3.2% |
1754 | 1 | 3.2% |
813 | 1 | 3.2% |
874 | 1 | 3.2% |
1258 | 1 | 3.2% |
700 | 1 | 3.2% |
Other values (20) | 20 |
Value | Count | Frequency (%) |
562 | 1 | |
655 | 2 | |
671 | 1 | |
693 | 1 | |
700 | 1 | |
703 | 1 | |
704 | 1 | |
707 | 1 | |
765 | 1 | |
766 | 1 |
Value | Count | Frequency (%) |
2495 | 1 | |
2021 | 1 | |
1754 | 1 | |
1569 | 1 | |
1441 | 1 | |
1391 | 1 | |
1258 | 1 | |
1233 | 1 | |
1171 | 1 | |
1019 | 1 |
현실화율(%)
Real number (ℝ)
Distinct | 30 |
---|---|
Distinct (%) | 96.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 81.13871 |
Minimum | 51 |
---|---|
Maximum | 107.3 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 51 |
---|---|
5-th percentile | 56.05 |
Q1 | 72.1 |
median | 81.5 |
Q3 | 91.9 |
95-th percentile | 102.1 |
Maximum | 107.3 |
Range | 56.3 |
Interquartile range (IQR) | 19.8 |
Descriptive statistics
Standard deviation | 14.53753 |
---|---|
Coefficient of variation (CV) | 0.17916886 |
Kurtosis | -0.45585082 |
Mean | 81.13871 |
Median Absolute Deviation (MAD) | 11.5 |
Skewness | -0.36873585 |
Sum | 2515.3 |
Variance | 211.33978 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
66.3 | 2 | 6.5% |
51.0 | 1 | 3.2% |
88.8 | 1 | 3.2% |
90.8 | 1 | 3.2% |
93.5 | 1 | 3.2% |
59.1 | 1 | 3.2% |
95.5 | 1 | 3.2% |
96.0 | 1 | 3.2% |
94.7 | 1 | 3.2% |
100.0 | 1 | 3.2% |
Other values (20) | 20 |
Value | Count | Frequency (%) |
51.0 | 1 | |
53.0 | 1 | |
59.1 | 1 | |
61.8 | 1 | |
62.8 | 1 | |
66.3 | 2 | |
66.8 | 1 | |
77.4 | 1 | |
79.1 | 1 | |
79.2 | 1 |
Value | Count | Frequency (%) |
107.3 | 1 | |
104.2 | 1 | |
100.0 | 1 | |
96.0 | 1 | |
95.5 | 1 | |
94.7 | 1 | |
93.5 | 1 | |
93.0 | 1 | |
90.8 | 1 | |
90.5 | 1 |
시군명 | 부과량(톤) | 부과액(천원) | 판매단가(원/㎥) | 생산액(천원) | 생산원가(원/㎥) | 현실화율(%) | |
---|---|---|---|---|---|---|---|
시군명 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
부과량(톤) | 1.000 | 1.000 | 0.554 | 0.000 | 0.897 | 0.000 | 0.456 |
부과액(천원) | 1.000 | 0.554 | 1.000 | 0.000 | 0.870 | 0.000 | 0.000 |
판매단가(원/㎥) | 1.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.895 | 0.791 |
생산액(천원) | 1.000 | 0.897 | 0.870 | 0.000 | 1.000 | 0.000 | 0.000 |
생산원가(원/㎥) | 1.000 | 0.000 | 0.000 | 0.895 | 0.000 | 1.000 | 0.685 |
현실화율(%) | 1.000 | 0.456 | 0.000 | 0.791 | 0.000 | 0.685 | 1.000 |
부과량(톤) | 부과액(천원) | 판매단가(원/㎥) | 생산액(천원) | 생산원가(원/㎥) | 현실화율(%) | |
---|---|---|---|---|---|---|
부과량(톤) | 1.000 | 0.963 | -0.652 | 0.921 | -0.721 | 0.416 |
부과액(천원) | 0.963 | 1.000 | -0.466 | 0.947 | -0.569 | 0.431 |
판매단가(원/㎥) | -0.652 | -0.466 | 1.000 | -0.431 | 0.881 | -0.116 |
생산액(천원) | 0.921 | 0.947 | -0.431 | 1.000 | -0.517 | 0.335 |
생산원가(원/㎥) | -0.721 | -0.569 | 0.881 | -0.517 | 1.000 | -0.482 |
현실화율(%) | 0.416 | 0.431 | -0.116 | 0.335 | -0.482 | 1.000 |
집계일자 | 시군명 | 부과량(톤) | 부과액(천원) | 판매단가(원/㎥) | 생산액(천원) | 생산원가(원/㎥) | 현실화율(%) | |
---|---|---|---|---|---|---|---|---|
0 | 2021-12-31 | 가평군 | 5685767 | 7239641 | 1273.29 | 14224615 | 2495 | 51.0 |
1 | 2021-12-31 | 고양시 | 111111908 | 65307184 | 587.76 | 78077747 | 703 | 83.6 |
2 | 2021-12-31 | 과천시 | 6534897 | 5383003 | 823.73 | 8083863 | 1233 | 66.8 |
3 | 2021-12-31 | 광명시 | 29250180 | 18633801 | 637.05 | 20589000 | 704 | 90.5 |
4 | 2021-12-31 | 광주시 | 39864552 | 24385024 | 611.7 | 34033501 | 766 | 79.9 |
5 | 2021-12-31 | 구리시 | 18887014 | 12168097 | 644.26 | 18348176 | 972 | 66.3 |
6 | 2021-12-31 | 군포시 | 27050858 | 18517897 | 684.56 | 23375315 | 864 | 79.2 |
7 | 2021-12-31 | 김포시 | 51361637 | 40983530 | 797.94 | 44043227 | 858 | 93.0 |
8 | 2021-12-31 | 남양주시 | 69707186 | 49644505 | 712.19 | 58769855 | 834 | 85.4 |
9 | 2021-12-31 | 동두천시 | 9626819 | 8875059 | 921.91 | 21257169 | 884 | 104.2 |
집계일자 | 시군명 | 부과량(톤) | 부과액(천원) | 판매단가(원/㎥) | 생산액(천원) | 생산원가(원/㎥) | 현실화율(%) | |
---|---|---|---|---|---|---|---|---|
21 | 2021-12-31 | 오산시 | 24794620 | 16424544 | 662.42 | 20772047 | 838 | 79.1 |
22 | 2021-12-31 | 용인시 | 112329140 | 68091903 | 606.18 | 85874155 | 765 | 79.3 |
23 | 2021-12-31 | 의왕시 | 16544933 | 14350489 | 867.36 | 16858968 | 1019 | 85.1 |
24 | 2021-12-31 | 의정부시 | 44179378 | 30913652 | 699.73 | 46801885 | 700 | 100.0 |
25 | 2021-12-31 | 이천시 | 23058365 | 27465629 | 1191.14 | 29000484 | 1258 | 94.7 |
26 | 2021-12-31 | 파주시 | 55489404 | 46574852 | 839.35 | 54889976 | 874 | 96.0 |
27 | 2021-12-31 | 평택시 | 113253312 | 87980116 | 776.84 | 92120048 | 813 | 95.5 |
28 | 2021-12-31 | 포천시 | 17333099 | 17979948 | 1037.32 | 30406861 | 1754 | 59.1 |
29 | 2021-12-31 | 하남시 | 31687676 | 16653590 | 525.55 | 18029712 | 562 | 93.5 |
30 | 2021-12-31 | 화성시 | 114118384 | 93916810 | 822.98 | 103381424 | 906 | 90.8 |