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 | 1 |
---|---|
Categorical | 4 |
Numeric | 1 |
Dataset
Description | 년월,지사코드,지사명,전기판매량,단위,작업일시 |
---|---|
Author | 서울에너지공사 |
URL | https://data.seoul.go.kr/dataList/OA-20446/S/1/datasetView.do |
Reproduction
Analysis started | 2024-05-11 02:09:17.539006 |
---|---|
Analysis finished | 2024-05-11 02:09:18.638003 |
Duration | 1.1 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 | 126 |
---|---|
Distinct (%) | 75.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 4105964.1 |
Minimum | 0 |
---|---|
Maximum | 18783760 |
Zeros | 38 |
Zeros (%) | 22.9% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.6 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 72 |
median | 1616238.6 |
Q3 | 6818077.3 |
95-th percentile | 16597834 |
Maximum | 18783760 |
Range | 18783760 |
Interquartile range (IQR) | 6818005.3 |
Descriptive statistics
Standard deviation | 5424175 |
---|---|
Coefficient of variation (CV) | 1.3210479 |
Kurtosis | 0.45627896 |
Mean | 4105964.1 |
Median Absolute Deviation (MAD) | 1616238.6 |
Skewness | 1.2770715 |
Sum | 6.8159003 × 108 |
Variance | 2.9421675 × 1013 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0.0 | 38 | 22.9% |
72.0 | 4 | 2.4% |
17599681.71 | 1 | 0.6% |
2994266.52 | 1 | 0.6% |
7272.0 | 1 | 0.6% |
2879326.26 | 1 | 0.6% |
2254968.0 | 1 | 0.6% |
1697672.49 | 1 | 0.6% |
288.0 | 1 | 0.6% |
2448.0 | 1 | 0.6% |
Other values (116) | 116 |
Value | Count | Frequency (%) |
0.0 | 38 | |
8.0 | 1 | 0.6% |
72.0 | 4 | 2.4% |
133.0 | 1 | 0.6% |
288.0 | 1 | 0.6% |
504.0 | 1 | 0.6% |
648.0 | 1 | 0.6% |
1008.0 | 1 | 0.6% |
1152.0 | 1 | 0.6% |
1656.0 | 1 | 0.6% |
Value | Count | Frequency (%) |
18783760.38 | 1 | |
18373709.79 | 1 | |
18268954.11 | 1 | |
18011672.22 | 1 | |
17599681.71 | 1 | |
17322758.13 | 1 | |
16950051.0 | 1 | |
16916829.87 | 1 | |
16610322.51 | 1 | |
16560369.57 | 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 |
작업일시
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.4 KiB |
2024-05-10 20:56:50.0 |
---|
Length
Max length | 21 |
---|---|
Median length | 21 |
Mean length | 21 |
Min length | 21 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2024-05-10 20:56:50.0 |
---|---|
2nd row | 2024-05-10 20:56:50.0 |
3rd row | 2024-05-10 20:56:50.0 |
4th row | 2024-05-10 20:56:50.0 |
5th row | 2024-05-10 20:56:50.0 |
Common Values
Value | Count | Frequency (%) |
2024-05-10 20:56:50.0 | 166 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2024-05-10 | 166 | |
20:56:50.0 | 166 |
년월 | 지사코드 | 지사명 | 전기판매량 | |
---|---|---|---|---|
년월 | 1.000 | 0.000 | 0.000 | 0.548 |
지사코드 | 0.000 | 1.000 | 1.000 | 0.515 |
지사명 | 0.000 | 1.000 | 1.000 | 0.515 |
전기판매량 | 0.548 | 0.515 | 0.515 | 1.000 |
지사코드 | 지사명 | |
---|---|---|
지사코드 | 1.000 | 0.988 |
지사명 | 0.988 | 1.000 |
전기판매량 | 지사코드 | 지사명 | |
---|---|---|---|
전기판매량 | 1.000 | 0.386 | 0.386 |
지사코드 | 0.386 | 1.000 | 0.988 |
지사명 | 0.386 | 0.988 | 1.000 |
년월 | 지사코드 | 지사명 | 전기판매량 | 단위 | 작업일시 | |
---|---|---|---|---|---|---|
0 | 2023-10 | 2 | 동부지사 | 0.0 | kWh | 2024-05-10 20:56:50.0 |
1 | 2023-10 | 1 | 서부지사 | 0.0 | kWh | 2024-05-10 20:56:50.0 |
2 | 2023-09 | 2 | 동부지사 | 30071.0 | kWh | 2024-05-10 20:56:50.0 |
3 | 2023-09 | 1 | 서부지사 | 72.0 | kWh | 2024-05-10 20:56:50.0 |
4 | 2023-08 | 2 | 동부지사 | 21016.0 | kWh | 2024-05-10 20:56:50.0 |
5 | 2023-08 | 1 | 서부지사 | 122616.0 | kWh | 2024-05-10 20:56:50.0 |
6 | 2023-07 | 2 | 동부지사 | 12781.0 | kWh | 2024-05-10 20:56:50.0 |
7 | 2023-07 | 1 | 서부지사 | 0.0 | kWh | 2024-05-10 20:56:50.0 |
8 | 2023-06 | 2 | 동부지사 | 1041033.43 | kWh | 2024-05-10 20:56:50.0 |
9 | 2023-06 | 1 | 서부지사 | 0.0 | kWh | 2024-05-10 20:56:50.0 |
년월 | 지사코드 | 지사명 | 전기판매량 | 단위 | 작업일시 | |
---|---|---|---|---|---|---|
156 | 2017-04 | 1 | 서부지사 | 0.0 | kWh | 2024-05-10 20:56:50.0 |
157 | 2017-04 | 2 | 동부지사 | 8920722.12 | kWh | 2024-05-10 20:56:50.0 |
158 | 2017-03 | 2 | 동부지사 | 14314669.68 | kWh | 2024-05-10 20:56:50.0 |
159 | 2017-03 | 1 | 서부지사 | 8505360.0 | kWh | 2024-05-10 20:56:50.0 |
160 | 2017-02 | 1 | 서부지사 | 9748656.0 | kWh | 2024-05-10 20:56:50.0 |
161 | 2017-02 | 2 | 동부지사 | 10861612.08 | kWh | 2024-05-10 20:56:50.0 |
162 | 2017-01 | 2 | 동부지사 | 11486266.32 | kWh | 2024-05-10 20:56:50.0 |
163 | 2017-01 | 1 | 서부지사 | 11129040.0 | kWh | 2024-05-10 20:56:50.0 |
164 | 2016-12 | 2 | 동부지사 | 16610322.51 | kWh | 2024-05-10 20:56:50.0 |
165 | 2016-12 | 1 | 서부지사 | 11125512.0 | kWh | 2024-05-10 20:56:50.0 |