Dataset statistics
Number of variables | 4 |
---|---|
Number of observations | 76 |
Missing cells | 16 |
Missing cells (%) | 5.3% |
Duplicate rows | 1 |
Duplicate rows (%) | 1.3% |
Total size in memory | 2.7 KiB |
Average record size in memory | 36.7 B |
Variable types
DateTime | 1 |
---|---|
Numeric | 3 |
Dataset
Description | 인천광역시 동구청사 에너지사용량의 월별 데이터로, 연월, 전기사용량, 수도사용량, 가스사용량에 대한 항목을 제공합니다. |
---|---|
Author | 인천광역시 동구 |
URL | https://data.incheon.go.kr/findData/publicDataDetail?dataId=15113820&srcSe=7661IVAWM27C61E190 |
Dataset has 1 (1.3%) duplicate rows | Duplicates |
연월 has 4 (5.3%) missing values | Missing |
전기사용량 has 4 (5.3%) missing values | Missing |
수도사용량 has 4 (5.3%) missing values | Missing |
가스사용량 has 4 (5.3%) missing values | Missing |
Reproduction
Analysis started | 2024-05-17 21:16:48.951129 |
---|---|
Analysis finished | 2024-05-17 21:16:52.643831 |
Duration | 3.69 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
연월
Date
MISSING
 
Distinct | 72 |
---|---|
Distinct (%) | 100.0% |
Missing | 4 |
Missing (%) | 5.3% |
Memory size | 740.0 B |
Minimum | 2018-01-01 00:00:00 |
---|---|
Maximum | 2023-12-01 00:00:00 |
전기사용량
Real number (ℝ)
MISSING
 
Distinct | 72 |
---|---|
Distinct (%) | 100.0% |
Missing | 4 |
Missing (%) | 5.3% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 124618.97 |
Minimum | 86209 |
---|---|
Maximum | 178405 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 816.0 B |
Quantile statistics
Minimum | 86209 |
---|---|
5-th percentile | 93180.2 |
Q1 | 104910 |
median | 124442 |
Q3 | 141675.25 |
95-th percentile | 164932.15 |
Maximum | 178405 |
Range | 92196 |
Interquartile range (IQR) | 36765.25 |
Descriptive statistics
Standard deviation | 22814.369 |
---|---|
Coefficient of variation (CV) | 0.183073 |
Kurtosis | -0.72248694 |
Mean | 124618.97 |
Median Absolute Deviation (MAD) | 19394.5 |
Skewness | 0.34967554 |
Sum | 8972566 |
Variance | 5.2049545 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
114630 | 1 | 1.3% |
135014 | 1 | 1.3% |
104973 | 1 | 1.3% |
94906 | 1 | 1.3% |
117182 | 1 | 1.3% |
137715 | 1 | 1.3% |
167246 | 1 | 1.3% |
156878 | 1 | 1.3% |
125001 | 1 | 1.3% |
104638 | 1 | 1.3% |
Other values (62) | 62 | |
(Missing) | 4 | 5.3% |
Value | Count | Frequency (%) |
86209 | 1 | |
87737 | 1 | |
90531 | 1 | |
93079 | 1 | |
93263 | 1 | |
93309 | 1 | |
94906 | 1 | |
95703 | 1 | |
97077 | 1 | |
97429 | 1 |
Value | Count | Frequency (%) |
178405 | 1 | |
171672 | 1 | |
169088 | 1 | |
167246 | 1 | |
163039 | 1 | |
157839 | 1 | |
156878 | 1 | |
156326 | 1 | |
153473 | 1 | |
151191 | 1 |
수도사용량
Real number (ℝ)
MISSING
 
Distinct | 62 |
---|---|
Distinct (%) | 86.1% |
Missing | 4 |
Missing (%) | 5.3% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 715.09722 |
Minimum | 547 |
---|---|
Maximum | 918 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 816.0 B |
Quantile statistics
Minimum | 547 |
---|---|
5-th percentile | 570.65 |
Q1 | 662.75 |
median | 722 |
Q3 | 762.25 |
95-th percentile | 832.75 |
Maximum | 918 |
Range | 371 |
Interquartile range (IQR) | 99.5 |
Descriptive statistics
Standard deviation | 82.401484 |
---|---|
Coefficient of variation (CV) | 0.11523116 |
Kurtosis | -0.21165522 |
Mean | 715.09722 |
Median Absolute Deviation (MAD) | 56 |
Skewness | -0.056921961 |
Sum | 51487 |
Variance | 6790.0045 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
715 | 3 | 3.9% |
666 | 2 | 2.6% |
738 | 2 | 2.6% |
722 | 2 | 2.6% |
729 | 2 | 2.6% |
750 | 2 | 2.6% |
742 | 2 | 2.6% |
786 | 2 | 2.6% |
726 | 2 | 2.6% |
572 | 1 | 1.3% |
Other values (52) | 52 | |
(Missing) | 4 | 5.3% |
Value | Count | Frequency (%) |
547 | 1 | |
559 | 1 | |
566 | 1 | |
569 | 1 | |
572 | 1 | |
578 | 1 | |
584 | 1 | |
587 | 1 | |
588 | 1 | |
610 | 1 |
Value | Count | Frequency (%) |
918 | 1 | |
901 | 1 | |
854 | 1 | |
841 | 1 | |
826 | 1 | |
823 | 1 | |
816 | 1 | |
814 | 1 | |
808 | 1 | |
807 | 1 |
가스사용량
Real number (ℝ)
MISSING
 
Distinct | 69 |
---|---|
Distinct (%) | 95.8% |
Missing | 4 |
Missing (%) | 5.3% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 992.11111 |
Minimum | 5 |
---|---|
Maximum | 4799 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 816.0 B |
Quantile statistics
Minimum | 5 |
---|---|
5-th percentile | 10.65 |
Q1 | 83 |
median | 355 |
Q3 | 1291.75 |
95-th percentile | 3460.25 |
Maximum | 4799 |
Range | 4794 |
Interquartile range (IQR) | 1208.75 |
Descriptive statistics
Standard deviation | 1281.5833 |
---|---|
Coefficient of variation (CV) | 1.291774 |
Kurtosis | 0.45239462 |
Mean | 992.11111 |
Median Absolute Deviation (MAD) | 335 |
Skewness | 1.3126741 |
Sum | 71432 |
Variance | 1642455.8 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
15 | 2 | 2.6% |
355 | 2 | 2.6% |
20 | 2 | 2.6% |
795 | 1 | 1.3% |
90 | 1 | 1.3% |
412 | 1 | 1.3% |
1224 | 1 | 1.3% |
2953 | 1 | 1.3% |
3737 | 1 | 1.3% |
3317 | 1 | 1.3% |
Other values (59) | 59 | |
(Missing) | 4 | 5.3% |
Value | Count | Frequency (%) |
5 | 1 | |
7 | 1 | |
8 | 1 | |
9 | 1 | |
12 | 1 | |
14 | 1 | |
15 | 2 | |
20 | 2 | |
24 | 1 | |
28 | 1 |
Value | Count | Frequency (%) |
4799 | 1 | |
4201 | 1 | |
3737 | 1 | |
3540 | 1 | |
3395 | 1 | |
3317 | 1 | |
3266 | 1 | |
3098 | 1 | |
3062 | 1 | |
2976 | 1 |
연월 | 전기사용량 | 수도사용량 | 가스사용량 | |
---|---|---|---|---|
연월 | 1.000 | 1.000 | 1.000 | 1.000 |
전기사용량 | 1.000 | 1.000 | 0.436 | 0.690 |
수도사용량 | 1.000 | 0.436 | 1.000 | 0.000 |
가스사용량 | 1.000 | 0.690 | 0.000 | 1.000 |
전기사용량 | 수도사용량 | 가스사용량 | |
---|---|---|---|
전기사용량 | 1.000 | 0.206 | 0.355 |
수도사용량 | 0.206 | 1.000 | -0.072 |
가스사용량 | 0.355 | -0.072 | 1.000 |
연월 | 전기사용량 | 수도사용량 | 가스사용량 | |
---|---|---|---|---|
0 | 2018-01-01 | 153473 | 726 | 3098 |
1 | 2018-02-01 | 171672 | 715 | 4799 |
2 | 2018-03-01 | 121787 | 632 | 3266 |
3 | 2018-04-01 | 102556 | 547 | 553 |
4 | 2018-05-01 | 86209 | 746 | 93 |
5 | 2018-06-01 | 93079 | 633 | 71 |
6 | 2018-07-01 | 109462 | 566 | 9 |
7 | 2018-08-01 | 149640 | 712 | 15 |
8 | 2018-09-01 | 135637 | 794 | 5 |
9 | 2018-10-01 | 100244 | 713 | 12 |
연월 | 전기사용량 | 수도사용량 | 가스사용량 | |
---|---|---|---|---|
66 | 2023-07-01 | 126375 | 745 | 355 |
67 | 2023-08-01 | 149869 | 646 | 1375 |
68 | 2023-09-01 | 143836 | 739 | 766 |
69 | 2023-10-01 | 115224 | 808 | 278 |
70 | 2023-11-01 | 108960 | 569 | 243 |
71 | 2023-12-01 | 143837 | 799 | 407 |
72 | <NA> | <NA> | <NA> | <NA> |
73 | <NA> | <NA> | <NA> | <NA> |
74 | <NA> | <NA> | <NA> | <NA> |
75 | <NA> | <NA> | <NA> | <NA> |
Most frequently occurring
연월 | 전기사용량 | 수도사용량 | 가스사용량 | # duplicates | |
---|---|---|---|---|---|
0 | <NA> | <NA> | <NA> | <NA> | 4 |