Dataset statistics
Number of variables | 7 |
---|---|
Number of observations | 213 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 12.6 KiB |
Average record size in memory | 60.6 B |
Variable types
DateTime | 1 |
---|---|
Categorical | 3 |
Numeric | 3 |
Dataset
Description | 년월,업종코드,업종,난방 판매량,냉방 판매량,총 판매량,작업일시 |
---|---|
Author | 서울에너지공사 |
URL | https://data.seoul.go.kr/dataList/OA-20441/S/1/datasetView.do |
작업일시 has constant value "" | Constant |
업종 is highly overall correlated with 난방 판매량 and 2 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 |
냉방 판매량 is highly overall correlated with 난방 판매량 | High correlation |
총 판매량 is highly overall correlated with 난방 판매량 and 2 other fields | High correlation |
난방 판매량 has unique values | Unique |
총 판매량 has unique values | Unique |
냉방 판매량 has 93 (43.7%) zeros | Zeros |
Reproduction
Analysis started | 2024-05-18 07:07:25.819354 |
---|---|
Analysis finished | 2024-05-18 07:07:30.614923 |
Duration | 4.8 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
년월
Date
Distinct | 71 |
---|---|
Distinct (%) | 33.3% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.8 KiB |
Minimum | 2016-12-01 00:00:00 |
---|---|
Maximum | 2022-10-01 00:00:00 |
업종코드
Categorical
HIGH CORRELATION
 
Distinct | 3 |
---|---|
Distinct (%) | 1.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.8 KiB |
3 | |
---|---|
2 | |
1 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 3 |
---|---|
2nd row | 2 |
3rd row | 1 |
4th row | 3 |
5th row | 2 |
Common Values
Value | Count | Frequency (%) |
3 | 71 | |
2 | 71 | |
1 | 71 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
3 | 71 | |
2 | 71 | |
1 | 71 |
업종
Categorical
HIGH CORRELATION
 
Distinct | 3 |
---|---|
Distinct (%) | 1.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.8 KiB |
공공용 | |
---|---|
업무용 | |
주택용 |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 공공용 |
---|---|
2nd row | 업무용 |
3rd row | 주택용 |
4th row | 공공용 |
5th row | 업무용 |
Common Values
Value | Count | Frequency (%) |
공공용 | 71 | |
업무용 | 71 | |
주택용 | 71 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
공공용 | 71 | |
업무용 | 71 | |
주택용 | 71 |
난방 판매량
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 213 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 59437.794 |
Minimum | 507.5 |
---|---|
Maximum | 403956.4 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.0 KiB |
Quantile statistics
Minimum | 507.5 |
---|---|
5-th percentile | 950.72 |
Q1 | 4319.7 |
median | 11930.2 |
Q3 | 51117.3 |
95-th percentile | 326240.84 |
Maximum | 403956.4 |
Range | 403448.9 |
Interquartile range (IQR) | 46797.6 |
Descriptive statistics
Standard deviation | 98849.703 |
---|---|
Coefficient of variation (CV) | 1.6630783 |
Kurtosis | 3.3727813 |
Mean | 59437.794 |
Median Absolute Deviation (MAD) | 10976 |
Skewness | 2.1139577 |
Sum | 12660250 |
Variance | 9.7712639 × 109 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
2666.3 | 1 | 0.5% |
9520.0 | 1 | 0.5% |
11930.2 | 1 | 0.5% |
52859.6 | 1 | 0.5% |
11318.6 | 1 | 0.5% |
48953.4 | 1 | 0.5% |
342210.3 | 1 | 0.5% |
191841.9 | 1 | 0.5% |
22273.2 | 1 | 0.5% |
6048.6 | 1 | 0.5% |
Other values (203) | 203 |
Value | Count | Frequency (%) |
507.5 | 1 | |
721.2 | 1 | |
741.4 | 1 | |
759.3 | 1 | |
776.1 | 1 | |
810.7 | 1 | |
854.5 | 1 | |
855.1 | 1 | |
884.9 | 1 | |
921.9 | 1 |
Value | Count | Frequency (%) |
403956.4 | 1 | |
401822.3 | 1 | |
388121.1 | 1 | |
370119.9 | 1 | |
357264.5 | 1 | |
354651.1 | 1 | |
346060.5 | 1 | |
342210.3 | 1 | |
337241.2 | 1 | |
333131.6 | 1 |
냉방 판매량
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 117 |
---|---|
Distinct (%) | 54.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 3598.6817 |
Minimum | 0 |
---|---|
Maximum | 42293.6 |
Zeros | 93 |
Zeros (%) | 43.7% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.0 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 52.5 |
Q3 | 2872.3 |
95-th percentile | 22624.28 |
Maximum | 42293.6 |
Range | 42293.6 |
Interquartile range (IQR) | 2872.3 |
Descriptive statistics
Standard deviation | 8297.6965 |
---|---|
Coefficient of variation (CV) | 2.30576 |
Kurtosis | 9.1465667 |
Mean | 3598.6817 |
Median Absolute Deviation (MAD) | 52.5 |
Skewness | 3.0410355 |
Sum | 766519.2 |
Variance | 68851767 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0.0 | 93 | |
0.1 | 5 | 2.3% |
886.0 | 1 | 0.5% |
447.1 | 1 | 0.5% |
5089.7 | 1 | 0.5% |
1383.4 | 1 | 0.5% |
15021.3 | 1 | 0.5% |
2936.4 | 1 | 0.5% |
36.0 | 1 | 0.5% |
685.9 | 1 | 0.5% |
Other values (107) | 107 |
Value | Count | Frequency (%) |
0.0 | 93 | |
0.1 | 5 | 2.3% |
0.2 | 1 | 0.5% |
1.4 | 1 | 0.5% |
3.5 | 1 | 0.5% |
9.8 | 1 | 0.5% |
15.6 | 1 | 0.5% |
30.8 | 1 | 0.5% |
36.0 | 1 | 0.5% |
41.7 | 1 | 0.5% |
Value | Count | Frequency (%) |
42293.6 | 1 | |
41405.6 | 1 | |
40184.6 | 1 | |
39716.6 | 1 | |
35257.5 | 1 | |
34873.9 | 1 | |
30704.0 | 1 | |
28270.8 | 1 | |
27109.6 | 1 | |
25942.8 | 1 |
총 판매량
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 213 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 63036.476 |
Minimum | 1424.3 |
---|---|
Maximum | 403956.4 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.0 KiB |
Quantile statistics
Minimum | 1424.3 |
---|---|
5-th percentile | 2846.9 |
Q1 | 8380.2 |
median | 24328.6 |
Q3 | 51473.4 |
95-th percentile | 326240.84 |
Maximum | 403956.4 |
Range | 402532.1 |
Interquartile range (IQR) | 43093.2 |
Descriptive statistics
Standard deviation | 97185.664 |
---|---|
Coefficient of variation (CV) | 1.541737 |
Kurtosis | 3.4766961 |
Mean | 63036.476 |
Median Absolute Deviation (MAD) | 18272.2 |
Skewness | 2.1360759 |
Sum | 13426769 |
Variance | 9.4450533 × 109 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
3552.3 | 1 | 0.5% |
9520.0 | 1 | 0.5% |
11930.2 | 1 | 0.5% |
53008.9 | 1 | 0.5% |
11318.6 | 1 | 0.5% |
49562.7 | 1 | 0.5% |
342210.3 | 1 | 0.5% |
191841.9 | 1 | 0.5% |
22959.1 | 1 | 0.5% |
6048.7 | 1 | 0.5% |
Other values (203) | 203 |
Value | Count | Frequency (%) |
1424.3 | 1 | |
1512.3 | 1 | |
1721.4 | 1 | |
2069.4 | 1 | |
2194.4 | 1 | |
2203.4 | 1 | |
2238.5 | 1 | |
2723.2 | 1 | |
2740.1 | 1 | |
2755.5 | 1 |
Value | Count | Frequency (%) |
403956.4 | 1 | |
401822.3 | 1 | |
388121.1 | 1 | |
370119.9 | 1 | |
357264.5 | 1 | |
354651.1 | 1 | |
346060.5 | 1 | |
342210.3 | 1 | |
337241.2 | 1 | |
333131.6 | 1 |
작업일시
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.8 KiB |
2024-05-10 20:46: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:46:50.0 |
---|---|
2nd row | 2024-05-10 20:46:50.0 |
3rd row | 2024-05-10 20:46:50.0 |
4th row | 2024-05-10 20:46:50.0 |
5th row | 2024-05-10 20:46:50.0 |
Common Values
Value | Count | Frequency (%) |
2024-05-10 20:46:50.0 | 213 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2024-05-10 | 213 | |
20:46:50.0 | 213 |
년월 | 업종코드 | 업종 | 난방 판매량 | 냉방 판매량 | 총 판매량 | |
---|---|---|---|---|---|---|
년월 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
업종코드 | 0.000 | 1.000 | 1.000 | 0.802 | 0.484 | 0.805 |
업종 | 0.000 | 1.000 | 1.000 | 0.802 | 0.484 | 0.805 |
난방 판매량 | 0.000 | 0.802 | 0.802 | 1.000 | 0.000 | 1.000 |
냉방 판매량 | 0.000 | 0.484 | 0.484 | 0.000 | 1.000 | 0.000 |
총 판매량 | 0.000 | 0.805 | 0.805 | 1.000 | 0.000 | 1.000 |
업종 | 업종코드 | |
---|---|---|
업종 | 1.000 | 1.000 |
업종코드 | 1.000 | 1.000 |
난방 판매량 | 냉방 판매량 | 총 판매량 | 업종코드 | 업종 | |
---|---|---|---|---|---|
난방 판매량 | 1.000 | -0.715 | 0.896 | 0.502 | 0.502 |
냉방 판매량 | -0.715 | 1.000 | -0.438 | 0.327 | 0.327 |
총 판매량 | 0.896 | -0.438 | 1.000 | 0.505 | 0.505 |
업종코드 | 0.502 | 0.327 | 0.505 | 1.000 | 1.000 |
업종 | 0.502 | 0.327 | 0.505 | 1.000 | 1.000 |
년월 | 업종코드 | 업종 | 난방 판매량 | 냉방 판매량 | 총 판매량 | 작업일시 | |
---|---|---|---|---|---|---|---|
0 | 2022-10 | 3 | 공공용 | 2666.3 | 886.0 | 3552.3 | 2024-05-10 20:46:50.0 |
1 | 2022-10 | 2 | 업무용 | 9928.0 | 3349.9 | 13277.9 | 2024-05-10 20:46:50.0 |
2 | 2022-10 | 1 | 주택용 | 100927.3 | 0.0 | 100927.3 | 2024-05-10 20:46:50.0 |
3 | 2022-09 | 3 | 공공용 | 1286.4 | 4565.4 | 5851.8 | 2024-05-10 20:46:50.0 |
4 | 2022-09 | 2 | 업무용 | 4856.9 | 20412.4 | 25269.3 | 2024-05-10 20:46:50.0 |
5 | 2022-09 | 1 | 주택용 | 39891.0 | 0.0 | 39891.0 | 2024-05-10 20:46:50.0 |
6 | 2022-08 | 3 | 공공용 | 1085.2 | 9629.9 | 10715.1 | 2024-05-10 20:46:50.0 |
7 | 2022-08 | 2 | 업무용 | 5257.0 | 39716.6 | 44973.6 | 2024-05-10 20:46:50.0 |
8 | 2022-08 | 1 | 주택용 | 30800.7 | 0.0 | 30800.7 | 2024-05-10 20:46:50.0 |
9 | 2022-07 | 3 | 공공용 | 1037.5 | 9365.9 | 10403.4 | 2024-05-10 20:46:50.0 |
년월 | 업종코드 | 업종 | 난방 판매량 | 냉방 판매량 | 총 판매량 | 작업일시 | |
---|---|---|---|---|---|---|---|
203 | 2017-03 | 3 | 공공용 | 5904.6 | 0.0 | 5904.6 | 2024-05-10 20:46:50.0 |
204 | 2017-02 | 3 | 공공용 | 8273.3 | 0.0 | 8273.3 | 2024-05-10 20:46:50.0 |
205 | 2017-02 | 2 | 업무용 | 23961.1 | 30.8 | 23991.9 | 2024-05-10 20:46:50.0 |
206 | 2017-02 | 1 | 주택용 | 304119.5 | 0.0 | 304119.5 | 2024-05-10 20:46:50.0 |
207 | 2017-01 | 3 | 공공용 | 9174.8 | 0.0 | 9174.8 | 2024-05-10 20:46:50.0 |
208 | 2017-01 | 2 | 업무용 | 26647.5 | 0.0 | 26647.5 | 2024-05-10 20:46:50.0 |
209 | 2017-01 | 1 | 주택용 | 354651.1 | 0.0 | 354651.1 | 2024-05-10 20:46:50.0 |
210 | 2016-12 | 3 | 공공용 | 8187.0 | 0.0 | 8187.0 | 2024-05-10 20:46:50.0 |
211 | 2016-12 | 2 | 업무용 | 21565.8 | 9.8 | 21575.6 | 2024-05-10 20:46:50.0 |
212 | 2016-12 | 1 | 주택용 | 303310.2 | 0.0 | 303310.2 | 2024-05-10 20:46:50.0 |