Dataset statistics
Number of variables | 8 |
---|---|
Number of observations | 10000 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 5 |
Duplicate rows (%) | 0.1% |
Total size in memory | 761.7 KiB |
Average record size in memory | 78.0 B |
Variable types
Numeric | 6 |
---|---|
Categorical | 2 |
Dataset
Description | 계약종별 전력사용량 현황 |
---|---|
Author | 경기도 |
URL | https://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=4Z9SGF03FTIIXU9IQNQE26457615&infSeq=1 |
Dataset has 5 (0.1%) duplicate rows | Duplicates |
고객가구수(호) is highly overall correlated with 전력사용량(kWh) and 1 other fields | High correlation |
전력사용량(kWh) is highly overall correlated with 고객가구수(호) and 1 other fields | High correlation |
전기요금합계(원) is highly overall correlated with 고객가구수(호) and 1 other fields | High correlation |
Reproduction
Analysis started | 2024-04-11 02:55:39.236057 |
---|---|
Analysis finished | 2024-04-11 02:55:52.919407 |
Duration | 13.68 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
사용년도
Real number (ℝ)
Distinct | 23 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2012.9327 |
Minimum | 2002 |
---|---|
Maximum | 2024 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 2002 |
---|---|
5-th percentile | 2003 |
Q1 | 2007 |
median | 2013 |
Q3 | 2019 |
95-th percentile | 2023 |
Maximum | 2024 |
Range | 22 |
Interquartile range (IQR) | 12 |
Descriptive statistics
Standard deviation | 6.4347736 |
---|---|
Coefficient of variation (CV) | 0.0031967157 |
Kurtosis | -1.2249813 |
Mean | 2012.9327 |
Median Absolute Deviation (MAD) | 6 |
Skewness | -0.075310382 |
Sum | 20129327 |
Variance | 41.406311 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
2020 | 570 | 5.7% |
2023 | 529 | 5.3% |
2022 | 518 | 5.2% |
2018 | 496 | 5.0% |
2019 | 481 | 4.8% |
2015 | 471 | 4.7% |
2014 | 449 | 4.5% |
2016 | 444 | 4.4% |
2008 | 441 | 4.4% |
2002 | 439 | 4.4% |
Other values (13) | 5162 |
Value | Count | Frequency (%) |
2002 | 439 | |
2003 | 409 | |
2004 | 424 | |
2005 | 432 | |
2006 | 431 | |
2007 | 430 | |
2008 | 441 | |
2009 | 429 | |
2010 | 433 | |
2011 | 417 |
Value | Count | Frequency (%) |
2024 | 32 | 0.3% |
2023 | 529 | |
2022 | 518 | |
2021 | 437 | |
2020 | 570 | |
2019 | 481 | |
2018 | 496 | |
2017 | 431 | |
2016 | 444 | |
2015 | 471 |
사용월
Real number (ℝ)
Distinct | 12 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 6.5397 |
Minimum | 1 |
---|---|
Maximum | 12 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 1 |
Q1 | 3 |
median | 7 |
Q3 | 10 |
95-th percentile | 12 |
Maximum | 12 |
Range | 11 |
Interquartile range (IQR) | 7 |
Descriptive statistics
Standard deviation | 3.4812118 |
---|---|
Coefficient of variation (CV) | 0.5323198 |
Kurtosis | -1.2395437 |
Mean | 6.5397 |
Median Absolute Deviation (MAD) | 3 |
Skewness | -0.012688541 |
Sum | 65397 |
Variance | 12.118836 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
11 | 905 | |
3 | 878 | |
12 | 852 | |
1 | 846 | |
10 | 844 | |
5 | 839 | |
6 | 837 | |
9 | 827 | |
7 | 810 | |
2 | 808 | |
Other values (2) | 1554 |
Value | Count | Frequency (%) |
1 | 846 | |
2 | 808 | |
3 | 878 | |
4 | 770 | |
5 | 839 | |
6 | 837 | |
7 | 810 | |
8 | 784 | |
9 | 827 | |
10 | 844 |
Value | Count | Frequency (%) |
12 | 852 | |
11 | 905 | |
10 | 844 | |
9 | 827 | |
8 | 784 | |
7 | 810 | |
6 | 837 | |
5 | 839 | |
4 | 770 | |
3 | 878 |
시군명
Categorical
Distinct | 45 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
김포시 | 368 |
---|---|
광주시 | 350 |
성남시 | 346 |
과천시 | 344 |
평택시 | 339 |
Other values (40) |
Length
Max length | 8 |
---|---|
Median length | 3 |
Mean length | 3.1059 |
Min length | 3 |
Unique
Unique | 4 ? |
---|---|
Unique (%) | < 0.1% |
Sample
1st row | 양평군 |
---|---|
2nd row | 남양주시 |
3rd row | 용인시 |
4th row | 고양시 |
5th row | 고양시 |
Common Values
Value | Count | Frequency (%) |
김포시 | 368 | 3.7% |
광주시 | 350 | 3.5% |
성남시 | 346 | 3.5% |
과천시 | 344 | 3.4% |
평택시 | 339 | 3.4% |
광명시 | 338 | 3.4% |
여주시 | 334 | 3.3% |
연천군 | 330 | 3.3% |
가평군 | 330 | 3.3% |
안양시 | 330 | 3.3% |
Other values (35) | 6591 |
Length
Value | Count | Frequency (%) |
김포시 | 368 | 3.7% |
성남시 | 350 | 3.5% |
광주시 | 350 | 3.5% |
과천시 | 344 | 3.4% |
평택시 | 339 | 3.4% |
광명시 | 338 | 3.4% |
여주시 | 334 | 3.3% |
안양시 | 334 | 3.3% |
연천군 | 330 | 3.3% |
가평군 | 330 | 3.3% |
Other values (35) | 6608 |
계약종류명
Categorical
Distinct | 9 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
일반용 | |
---|---|
교육용 | |
농사용 | |
산업용 | |
주택용 | |
Other values (4) |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 2.8639 |
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 (%) |
일반용 | 1415 | |
교육용 | 1393 | |
농사용 | 1384 | |
산업용 | 1373 | |
주택용 | 1360 | |
가로등 | 1349 | |
심야 | 990 | |
합계 | 371 | 3.7% |
심 야 | 365 | 3.6% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
일반용 | 1415 | |
교육용 | 1393 | |
농사용 | 1384 | |
산업용 | 1373 | |
주택용 | 1360 | |
가로등 | 1349 | |
심야 | 990 | |
합계 | 371 | 3.6% |
심 | 365 | 3.5% |
야 | 365 | 3.5% |
고객가구수(호)
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 7374 |
---|---|
Distinct (%) | 73.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 22623.337 |
Minimum | 1 |
---|---|
Maximum | 377465 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 82 |
Q1 | 1099 |
median | 5912 |
Q3 | 16896 |
95-th percentile | 121652.4 |
Maximum | 377465 |
Range | 377464 |
Interquartile range (IQR) | 15797 |
Descriptive statistics
Standard deviation | 48377.351 |
---|---|
Coefficient of variation (CV) | 2.1383827 |
Kurtosis | 14.891009 |
Mean | 22623.337 |
Median Absolute Deviation (MAD) | 5435 |
Skewness | 3.6818258 |
Sum | 2.2623337 × 108 |
Variance | 2.3403681 × 109 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
43 | 24 | 0.2% |
45 | 22 | 0.2% |
81 | 19 | 0.2% |
80 | 19 | 0.2% |
67 | 18 | 0.2% |
47 | 17 | 0.2% |
85 | 17 | 0.2% |
109 | 17 | 0.2% |
69 | 16 | 0.2% |
87 | 16 | 0.2% |
Other values (7364) | 9815 |
Value | Count | Frequency (%) |
1 | 3 | < 0.1% |
19 | 2 | < 0.1% |
20 | 2 | < 0.1% |
21 | 1 | < 0.1% |
22 | 1 | < 0.1% |
24 | 2 | < 0.1% |
25 | 9 | |
26 | 4 | < 0.1% |
27 | 10 | |
29 | 2 | < 0.1% |
Value | Count | Frequency (%) |
377465 | 1 | |
377028 | 1 | |
376606 | 1 | |
375802 | 1 | |
375023 | 1 | |
373109 | 1 | |
372747 | 1 | |
372542 | 1 | |
370994 | 1 | |
370219 | 1 |
전력사용량(kWh)
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 9988 |
---|---|
Distinct (%) | 99.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 50714440 |
Minimum | -31815251 |
---|---|
Maximum | 1.9038944 × 109 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 2 |
Negative (%) | < 0.1% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | -31815251 |
---|---|
5-th percentile | 499445.4 |
Q1 | 1970838.5 |
median | 8979659 |
Q3 | 40095325 |
95-th percentile | 2.1822459 × 108 |
Maximum | 1.9038944 × 109 |
Range | 1.9357097 × 109 |
Interquartile range (IQR) | 38124486 |
Descriptive statistics
Standard deviation | 1.3982189 × 108 |
---|---|
Coefficient of variation (CV) | 2.7570429 |
Kurtosis | 59.528834 |
Mean | 50714440 |
Median Absolute Deviation (MAD) | 8261279.5 |
Skewness | 6.7255099 |
Sum | 5.071444 × 1011 |
Variance | 1.955016 × 1016 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
149471809 | 2 | < 0.1% |
1475582 | 2 | < 0.1% |
329377797 | 2 | < 0.1% |
19757781 | 2 | < 0.1% |
1612140864 | 2 | < 0.1% |
21951684 | 2 | < 0.1% |
215386081 | 2 | < 0.1% |
7838036 | 2 | < 0.1% |
9560068 | 2 | < 0.1% |
3555189 | 2 | < 0.1% |
Other values (9978) | 9980 |
Value | Count | Frequency (%) |
-31815251 | 1 | |
-3477031 | 1 | |
55 | 1 | |
59 | 1 | |
62 | 1 | |
23514 | 1 | |
28374 | 1 | |
29361 | 1 | |
38007 | 1 | |
44813 | 1 |
Value | Count | Frequency (%) |
1903894412 | 1 | |
1831832761 | 1 | |
1802210594 | 1 | |
1798416767 | 1 | |
1798098504 | 1 | |
1794299086 | 1 | |
1754155183 | 1 | |
1716594160 | 1 | |
1710803299 | 1 | |
1688288859 | 1 |
전기요금합계(원)
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 9988 |
---|---|
Distinct (%) | 99.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 5.5902334 × 109 |
Minimum | -1.0815438 × 1010 |
---|---|
Maximum | 3.0628301 × 1011 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 4 |
Negative (%) | < 0.1% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | -1.0815438 × 1010 |
---|---|
5-th percentile | 30332798 |
Q1 | 1.581845 × 108 |
median | 6.8433591 × 108 |
Q3 | 4.2568449 × 109 |
95-th percentile | 2.3671088 × 1010 |
Maximum | 3.0628301 × 1011 |
Range | 3.1709844 × 1011 |
Interquartile range (IQR) | 4.0986604 × 109 |
Descriptive statistics
Standard deviation | 1.6778764 × 1010 |
---|---|
Coefficient of variation (CV) | 3.0014426 |
Kurtosis | 89.294678 |
Mean | 5.5902334 × 109 |
Median Absolute Deviation (MAD) | 6.3748546 × 108 |
Skewness | 7.9557798 |
Sum | 5.5902334 × 1013 |
Variance | 2.8152693 × 1020 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
5372 | 3 | < 0.1% |
713026253 | 2 | < 0.1% |
162025002 | 2 | < 0.1% |
25442777082 | 2 | < 0.1% |
1476533601 | 2 | < 0.1% |
183372078564 | 2 | < 0.1% |
40125183338 | 2 | < 0.1% |
1656508896 | 2 | < 0.1% |
16617891421 | 2 | < 0.1% |
1056719212 | 2 | < 0.1% |
Other values (9978) | 9979 |
Value | Count | Frequency (%) |
-10815437993 | 1 | < 0.1% |
-316865845 | 1 | < 0.1% |
-155969415 | 1 | < 0.1% |
-75721638 | 1 | < 0.1% |
5372 | 3 | |
2182212 | 1 | < 0.1% |
2207553 | 1 | < 0.1% |
2411335 | 1 | < 0.1% |
2423930 | 1 | < 0.1% |
2706634 | 1 | < 0.1% |
Value | Count | Frequency (%) |
306283006324 | 1 | |
303779325045 | 1 | |
293903486026 | 1 | |
282882210520 | 1 | |
281148403727 | 1 | |
227808113424 | 1 | |
218333357624 | 1 | |
215808607328 | 1 | |
215708918001 | 1 | |
212638490804 | 1 |
평균판매단가(원/kWh)
Real number (ℝ)
Distinct | 1436 |
---|---|
Distinct (%) | 14.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 93.01394 |
Minimum | -313.3 |
---|---|
Maximum | 226.1 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 4 |
Negative (%) | < 0.1% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | -313.3 |
---|---|
5-th percentile | 41.1 |
Q1 | 64.2 |
median | 99 |
Q3 | 117.8 |
95-th percentile | 143.8 |
Maximum | 226.1 |
Range | 539.4 |
Interquartile range (IQR) | 53.6 |
Descriptive statistics
Standard deviation | 33.968068 |
---|---|
Coefficient of variation (CV) | 0.3651933 |
Kurtosis | 1.7749251 |
Mean | 93.01394 |
Median Absolute Deviation (MAD) | 24.6 |
Skewness | -0.29838778 |
Sum | 930139.4 |
Variance | 1153.8296 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
29.8 | 24 | 0.2% |
115.7 | 23 | 0.2% |
46.7 | 23 | 0.2% |
119.2 | 23 | 0.2% |
122.3 | 23 | 0.2% |
107.6 | 22 | 0.2% |
115.5 | 22 | 0.2% |
114.8 | 22 | 0.2% |
110.8 | 22 | 0.2% |
45.9 | 21 | 0.2% |
Other values (1426) | 9775 |
Value | Count | Frequency (%) |
-313.3 | 1 | < 0.1% |
-199.0 | 1 | < 0.1% |
-78.9 | 1 | < 0.1% |
-16.4 | 1 | < 0.1% |
23.2 | 9 | |
23.3 | 5 | |
23.4 | 1 | < 0.1% |
23.5 | 3 | < 0.1% |
23.7 | 1 | < 0.1% |
24.1 | 1 | < 0.1% |
Value | Count | Frequency (%) |
226.1 | 1 | |
193.8 | 1 | |
188.9 | 1 | |
188.5 | 1 | |
188.4 | 1 | |
186.9 | 1 | |
185.9 | 1 | |
185.1 | 1 | |
184.3 | 1 | |
183.0 | 1 |
사용년도 | 사용월 | 시군명 | 계약종류명 | 고객가구수(호) | 전력사용량(kWh) | 전기요금합계(원) | 평균판매단가(원/kWh) | |
---|---|---|---|---|---|---|---|---|
사용년도 | 1.000 | 0.094 | 0.066 | 0.340 | 0.242 | 0.190 | 0.173 | 0.364 |
사용월 | 0.094 | 1.000 | 0.102 | 0.000 | 0.000 | 0.000 | 0.025 | 0.182 |
시군명 | 0.066 | 0.102 | 1.000 | 0.000 | 0.502 | 0.425 | 0.383 | 0.065 |
계약종류명 | 0.340 | 0.000 | 0.000 | 1.000 | 0.596 | 0.431 | 0.546 | 0.575 |
고객가구수(호) | 0.242 | 0.000 | 0.502 | 0.596 | 1.000 | 0.643 | 0.546 | 0.218 |
전력사용량(kWh) | 0.190 | 0.000 | 0.425 | 0.431 | 0.643 | 1.000 | 0.865 | 0.105 |
전기요금합계(원) | 0.173 | 0.025 | 0.383 | 0.546 | 0.546 | 0.865 | 1.000 | 0.142 |
평균판매단가(원/kWh) | 0.364 | 0.182 | 0.065 | 0.575 | 0.218 | 0.105 | 0.142 | 1.000 |
시군명 | 계약종류명 | |
---|---|---|
시군명 | 1.000 | 0.000 |
계약종류명 | 0.000 | 1.000 |
사용년도 | 사용월 | 고객가구수(호) | 전력사용량(kWh) | 전기요금합계(원) | 평균판매단가(원/kWh) | 시군명 | 계약종류명 | |
---|---|---|---|---|---|---|---|---|
사용년도 | 1.000 | 0.017 | 0.152 | 0.137 | 0.209 | 0.452 | 0.024 | 0.162 |
사용월 | 0.017 | 1.000 | 0.012 | -0.028 | -0.019 | 0.051 | 0.035 | 0.000 |
고객가구수(호) | 0.152 | 0.012 | 1.000 | 0.638 | 0.631 | 0.289 | 0.193 | 0.322 |
전력사용량(kWh) | 0.137 | -0.028 | 0.638 | 1.000 | 0.981 | 0.342 | 0.157 | 0.212 |
전기요금합계(원) | 0.209 | -0.019 | 0.631 | 0.981 | 1.000 | 0.499 | 0.138 | 0.202 |
평균판매단가(원/kWh) | 0.452 | 0.051 | 0.289 | 0.342 | 0.499 | 1.000 | 0.020 | 0.324 |
시군명 | 0.024 | 0.035 | 0.193 | 0.157 | 0.138 | 0.020 | 1.000 | 0.000 |
계약종류명 | 0.162 | 0.000 | 0.322 | 0.212 | 0.202 | 0.324 | 0.000 | 1.000 |
사용년도 | 사용월 | 시군명 | 계약종류명 | 고객가구수(호) | 전력사용량(kWh) | 전기요금합계(원) | 평균판매단가(원/kWh) | |
---|---|---|---|---|---|---|---|---|
13368 | 2019 | 9 | 양평군 | 산업용 | 2658 | 8769735 | 1061229235 | 121.0 |
57851 | 2002 | 9 | 남양주시 | 주택용 | 63787 | 29820297 | 3338502875 | 112.0 |
52522 | 2004 | 10 | 용인시 | 농사용 | 6877 | 4103580 | 184940842 | 45.1 |
2571 | 2023 | 3 | 고양시 | 심 야 | 4349 | 7139116 | 723535483 | 101.3 |
33280 | 2012 | 2 | 고양시 | 교육용 | 526 | 9166733 | 1054207591 | 115.0 |
22708 | 2016 | 3 | 부천시 | 농사용 | 694 | 326850 | 16790578 | 51.4 |
16938 | 2018 | 6 | 하남시 | 일반용 | 13893 | 38063675 | 5201986727 | 136.7 |
24381 | 2015 | 7 | 고양시 | 산업용 | 5325 | 56594867 | 7726758972 | 136.5 |
5951 | 2022 | 2 | 연천군 | 심 야 | 3819 | 12289518 | 917600432 | 74.7 |
2391 | 2023 | 4 | 동두천시 | 산업용 | 577 | 19197983 | 2778913951 | 144.8 |
사용년도 | 사용월 | 시군명 | 계약종류명 | 고객가구수(호) | 전력사용량(kWh) | 전기요금합계(원) | 평균판매단가(원/kWh) | |
---|---|---|---|---|---|---|---|---|
16076 | 2018 | 9 | 안산시 | 주택용 | 236845 | 87009797 | 7482135907 | 86.0 |
7544 | 2021 | 6 | 광명시 | 주택용 | 44507 | 28287457 | 2851735561 | 100.8 |
11513 | 2020 | 4 | 광명시 | 합계 | 73532 | 82068651 | 8903433047 | 108.5 |
36541 | 2010 | 11 | 과천시 | 농사용 | 1163 | 610511 | 27932743 | 45.8 |
57568 | 2002 | 11 | 화성시 | 농사용 | 17536 | 13127381 | 455361028 | 34.7 |
33901 | 2011 | 12 | 포천시 | 심야 | 9891 | 32905895 | 2119304674 | 64.4 |
30554 | 2013 | 3 | 안성시 | 가로등 | 13529 | 1701809 | 175815057 | 103.3 |
54734 | 2003 | 12 | 포천시 | 교육용 | 68 | 1916540 | 151251489 | 78.9 |
38150 | 2010 | 4 | 안성시 | 심야 | 12529 | 31698683 | 1283615332 | 40.5 |
7120 | 2021 | 9 | 수원시 | 산업용 | 2318 | 61502156 | 6286096031 | 102.2 |
Most frequently occurring
사용년도 | 사용월 | 시군명 | 계약종류명 | 고객가구수(호) | 전력사용량(kWh) | 전기요금합계(원) | 평균판매단가(원/kWh) | # duplicates | |
---|---|---|---|---|---|---|---|---|---|
0 | 2020 | 11 | 가평군 | 산업용 | 1180 | 7838036 | 1056719212 | 134.8 | 2 |
1 | 2020 | 11 | 광주시 | 합계 | 195464 | 215386081 | 25442777082 | 118.1 | 2 |
2 | 2020 | 11 | 김포시 | 합계 | 134586 | 329377797 | 40125183338 | 121.8 | 2 |
3 | 2020 | 11 | 여주시 | 교육용 | 85 | 1475582 | 162025002 | 109.8 | 2 |
4 | 2020 | 11 | 화성시 | 합계 | 282590 | 1612140864 | 183372078564 | 113.7 | 2 |