Dataset statistics
Number of variables | 6 |
---|---|
Number of observations | 166 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 8.2 KiB |
Average record size in memory | 50.8 B |
Variable types
DateTime | 2 |
---|---|
Categorical | 3 |
Numeric | 1 |
Dataset
Description | 년월,지사코드,지사명,전기생산량,단위,작업일시 |
---|---|
Author | 서울에너지공사 |
URL | https://data.seoul.go.kr/dataList/OA-20445/S/1/datasetView.do |
Reproduction
Analysis started | 2024-05-11 04:44:35.540919 |
---|---|
Analysis finished | 2024-05-11 04:44:36.612858 |
Duration | 1.07 second |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
년월
Date
Distinct | 83 |
---|---|
Distinct (%) | 50.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.4 KiB |
Minimum | 2016-12-01 00:00:00 |
---|---|
Maximum | 2023-10-01 00:00:00 |
지사코드
Categorical
HIGH CORRELATION
 
Distinct | 2 |
---|---|
Distinct (%) | 1.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.4 KiB |
2 | |
---|---|
1 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2 |
---|---|
2nd row | 1 |
3rd row | 2 |
4th row | 1 |
5th row | 2 |
Common Values
Value | Count | Frequency (%) |
2 | 83 | |
1 | 83 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2 | 83 | |
1 | 83 |
지사명
Categorical
HIGH CORRELATION
 
Distinct | 2 |
---|---|
Distinct (%) | 1.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.4 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 (%) |
동부지사 | 83 | |
서부지사 | 83 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
동부지사 | 83 | |
서부지사 | 83 |
전기생산량
Real number (ℝ)
ZEROS
 
Distinct | 117 |
---|---|
Distinct (%) | 70.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 4959578.6 |
Minimum | 0 |
---|---|
Maximum | 21902300 |
Zeros | 50 |
Zeros (%) | 30.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.6 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 2070550 |
Q3 | 8903627.9 |
95-th percentile | 19314700 |
Maximum | 21902300 |
Range | 21902300 |
Interquartile range (IQR) | 8903627.9 |
Descriptive statistics
Standard deviation | 6396501.4 |
---|---|
Coefficient of variation (CV) | 1.2897268 |
Kurtosis | 0.19878541 |
Mean | 4959578.6 |
Median Absolute Deviation (MAD) | 2070550 |
Skewness | 1.18786 |
Sum | 8.2329005 × 108 |
Variance | 4.0915231 × 1013 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0.0 | 50 | |
17780100.0 | 1 | 0.6% |
3766200.0 | 1 | 0.6% |
195209.0 | 1 | 0.6% |
3623000.0 | 1 | 0.6% |
2880041.5 | 1 | 0.6% |
2149800.0 | 1 | 0.6% |
8797000.0 | 1 | 0.6% |
15725900.0 | 1 | 0.6% |
1664650.0 | 1 | 0.6% |
Other values (107) | 107 |
Value | Count | Frequency (%) |
0.0 | 50 | |
100.0 | 1 | 0.6% |
569.0 | 1 | 0.6% |
3152.0 | 1 | 0.6% |
13853.0 | 1 | 0.6% |
16227.0 | 1 | 0.6% |
28347.0 | 1 | 0.6% |
33700.0 | 1 | 0.6% |
63686.0 | 1 | 0.6% |
65361.0 | 1 | 0.6% |
Value | Count | Frequency (%) |
21902300.0 | 1 | |
21736300.0 | 1 | |
21150600.0 | 1 | |
20606200.0 | 1 | |
20489200.0 | 1 | |
20231600.0 | 1 | |
19578700.0 | 1 | |
19542800.0 | 1 | |
19349800.0 | 1 | |
19209400.0 | 1 |
단위
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.4 KiB |
kWh |
---|
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | kWh |
---|---|
2nd row | kWh |
3rd row | kWh |
4th row | kWh |
5th row | kWh |
Common Values
Value | Count | Frequency (%) |
kWh | 166 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
kwh | 166 |
작업일시
Date
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.4 KiB |
Minimum | 2024-05-10 21:06:50 |
---|---|
Maximum | 2024-05-10 21:06:50 |
년월 | 지사코드 | 지사명 | 전기생산량 | |
---|---|---|---|---|
년월 | 1.000 | 0.000 | 0.000 | 0.681 |
지사코드 | 0.000 | 1.000 | 1.000 | 0.526 |
지사명 | 0.000 | 1.000 | 1.000 | 0.526 |
전기생산량 | 0.681 | 0.526 | 0.526 | 1.000 |
지사코드 | 지사명 | |
---|---|---|
지사코드 | 1.000 | 0.988 |
지사명 | 0.988 | 1.000 |
전기생산량 | 지사코드 | 지사명 | |
---|---|---|---|
전기생산량 | 1.000 | 0.395 | 0.395 |
지사코드 | 0.395 | 1.000 | 0.988 |
지사명 | 0.395 | 0.988 | 1.000 |
년월 | 지사코드 | 지사명 | 전기생산량 | 단위 | 작업일시 | |
---|---|---|---|---|---|---|
0 | 2023-10 | 2 | 동부지사 | 0.0 | kWh | 2024-05-10 21:06:50.0 |
1 | 2023-10 | 1 | 서부지사 | 0.0 | kWh | 2024-05-10 21:06:50.0 |
2 | 2023-09 | 2 | 동부지사 | 0.0 | kWh | 2024-05-10 21:06:50.0 |
3 | 2023-09 | 1 | 서부지사 | 0.0 | kWh | 2024-05-10 21:06:50.0 |
4 | 2023-08 | 2 | 동부지사 | 0.0 | kWh | 2024-05-10 21:06:50.0 |
5 | 2023-08 | 1 | 서부지사 | 169420.0 | kWh | 2024-05-10 21:06:50.0 |
6 | 2023-07 | 2 | 동부지사 | 0.0 | kWh | 2024-05-10 21:06:50.0 |
7 | 2023-07 | 1 | 서부지사 | 0.0 | kWh | 2024-05-10 21:06:50.0 |
8 | 2023-06 | 2 | 동부지사 | 33700.0 | kWh | 2024-05-10 21:06:50.0 |
9 | 2023-06 | 1 | 서부지사 | 0.0 | kWh | 2024-05-10 21:06:50.0 |
년월 | 지사코드 | 지사명 | 전기생산량 | 단위 | 작업일시 | |
---|---|---|---|---|---|---|
156 | 2017-04 | 1 | 서부지사 | 0.0 | kWh | 2024-05-10 21:06:50.0 |
157 | 2017-04 | 2 | 동부지사 | 10209700.0 | kWh | 2024-05-10 21:06:50.0 |
158 | 2017-03 | 2 | 동부지사 | 16356300.0 | kWh | 2024-05-10 21:06:50.0 |
159 | 2017-03 | 1 | 서부지사 | 9776968.0 | kWh | 2024-05-10 21:06:50.0 |
160 | 2017-02 | 1 | 서부지사 | 11866179.0 | kWh | 2024-05-10 21:06:50.0 |
161 | 2017-02 | 2 | 동부지사 | 12882200.0 | kWh | 2024-05-10 21:06:50.0 |
162 | 2017-01 | 2 | 동부지사 | 13780600.0 | kWh | 2024-05-10 21:06:50.0 |
163 | 2017-01 | 1 | 서부지사 | 13700956.0 | kWh | 2024-05-10 21:06:50.0 |
164 | 2016-12 | 2 | 동부지사 | 19349800.0 | kWh | 2024-05-10 21:06:50.0 |
165 | 2016-12 | 1 | 서부지사 | 13057554.0 | kWh | 2024-05-10 21:06:50.0 |