Dataset statistics
Number of variables | 3 |
---|---|
Number of observations | 1715 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 189 |
Duplicate rows (%) | 11.0% |
Total size in memory | 43.7 KiB |
Average record size in memory | 26.1 B |
Variable types
DateTime | 1 |
---|---|
Numeric | 2 |
Dataset
Description | 경상북도 구미시 유수율제고블럭 시스템의 수요예측블록시간대별유량 테이블 정보로서 시간대별 유량값정보를 제공합니다. |
---|---|
Author | 경상북도 구미시 |
URL | https://www.data.go.kr/data/15049703/fileData.do |
수요예측일자 has constant value "" | Constant |
Dataset has 189 (11.0%) duplicate rows | Duplicates |
시간HH24 has 72 (4.2%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-12 15:16:47.515454 |
---|---|
Analysis finished | 2023-12-12 15:16:48.182329 |
Duration | 0.67 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
수요예측일자
Date
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 13.5 KiB |
Minimum | 2020-08-31 00:00:00 |
---|---|
Maximum | 2020-08-31 00:00:00 |
시간HH24
Real number (ℝ)
ZEROS
 
Distinct | 24 |
---|---|
Distinct (%) | 1.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 11.447813 |
Minimum | 0 |
---|---|
Maximum | 23 |
Zeros | 72 |
Zeros (%) | 4.2% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 15.2 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 1 |
Q1 | 5 |
median | 11 |
Q3 | 17 |
95-th percentile | 22 |
Maximum | 23 |
Range | 23 |
Interquartile range (IQR) | 12 |
Descriptive statistics
Standard deviation | 6.9343512 |
---|---|
Coefficient of variation (CV) | 0.60573587 |
Kurtosis | -1.2095514 |
Mean | 11.447813 |
Median Absolute Deviation (MAD) | 6 |
Skewness | 0.010346378 |
Sum | 19633 |
Variance | 48.085227 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
3 | 73 | 4.3% |
4 | 73 | 4.3% |
2 | 73 | 4.3% |
1 | 72 | 4.2% |
5 | 72 | 4.2% |
6 | 72 | 4.2% |
7 | 72 | 4.2% |
0 | 72 | 4.2% |
17 | 71 | 4.1% |
23 | 71 | 4.1% |
Other values (14) | 994 |
Value | Count | Frequency (%) |
0 | 72 | |
1 | 72 | |
2 | 73 | |
3 | 73 | |
4 | 73 | |
5 | 72 | |
6 | 72 | |
7 | 72 | |
8 | 71 | |
9 | 71 |
Value | Count | Frequency (%) |
23 | 71 | |
22 | 71 | |
21 | 71 | |
20 | 71 | |
19 | 71 | |
18 | 71 | |
17 | 71 | |
16 | 71 | |
15 | 71 | |
14 | 71 |
실제유량값
Real number (ℝ)
Distinct | 1523 |
---|---|
Distinct (%) | 88.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 250.87151 |
Minimum | 1.0667 |
---|---|
Maximum | 6485.0087 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 15.2 KiB |
Quantile statistics
Minimum | 1.0667 |
---|---|
5-th percentile | 10.92765 |
Q1 | 38.15425 |
median | 87.1769 |
Q3 | 223.86125 |
95-th percentile | 867.74349 |
Maximum | 6485.0087 |
Range | 6483.942 |
Interquartile range (IQR) | 185.707 |
Descriptive statistics
Standard deviation | 610.92707 |
---|---|
Coefficient of variation (CV) | 2.435219 |
Kurtosis | 51.067787 |
Mean | 250.87151 |
Median Absolute Deviation (MAD) | 63.1314 |
Skewness | 6.5657368 |
Sum | 430244.63 |
Variance | 373231.88 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1.25 | 3 | 0.2% |
194.6032 | 2 | 0.1% |
55.56 | 2 | 0.1% |
46.7624 | 2 | 0.1% |
72.3304 | 2 | 0.1% |
69.3871 | 2 | 0.1% |
90.7259 | 2 | 0.1% |
46.449 | 2 | 0.1% |
27.6892 | 2 | 0.1% |
27.2081 | 2 | 0.1% |
Other values (1513) | 1694 |
Value | Count | Frequency (%) |
1.0667 | 1 | |
1.0682 | 1 | |
1.0714 | 1 | |
1.075 | 1 | |
1.0833 | 1 | |
1.087 | 1 | |
1.1071 | 1 | |
1.1333 | 1 | |
1.1489 | 1 | |
1.15 | 1 |
Value | Count | Frequency (%) |
6485.0087 | 1 | |
6315.3926 | 1 | |
6138.7047 | 1 | |
6079.5558 | 1 | |
6045.5153 | 1 | |
6026.7129 | 1 | |
5549.4207 | 1 | |
5294.8657 | 1 | |
5251.6934 | 1 | |
4980.7192 | 1 |
시간HH24 | 실제유량값 | |
---|---|---|
시간HH24 | 1.000 | 0.133 |
실제유량값 | 0.133 | 1.000 |
시간HH24 | 실제유량값 | |
---|---|---|
시간HH24 | 1.000 | 0.186 |
실제유량값 | 0.186 | 1.000 |
수요예측일자 | 시간HH24 | 실제유량값 | |
---|---|---|---|
0 | 2020-08-31 | 1 | 264.036 |
1 | 2020-08-31 | 2 | 204.9777 |
2 | 2020-08-31 | 3 | 198.0914 |
3 | 2020-08-31 | 4 | 173.2973 |
4 | 2020-08-31 | 5 | 208.28 |
5 | 2020-08-31 | 6 | 370.2442 |
6 | 2020-08-31 | 7 | 510.5816 |
7 | 2020-08-31 | 8 | 697.9512 |
8 | 2020-08-31 | 9 | 669.8957 |
9 | 2020-08-31 | 10 | 492.5153 |
수요예측일자 | 시간HH24 | 실제유량값 | |
---|---|---|---|
1705 | 2020-08-31 | 23 | 4292.1266 |
1706 | 2020-08-31 | 0 | 3421.4469 |
1707 | 2020-08-31 | 8 | 6485.0087 |
1708 | 2020-08-31 | 9 | 6026.7129 |
1709 | 2020-08-31 | 19 | 6138.7047 |
1710 | 2020-08-31 | 4 | 1861.5465 |
1711 | 2020-08-31 | 6 | 3826.7953 |
1712 | 2020-08-31 | 7 | 6045.5153 |
1713 | 2020-08-31 | 14 | 4313.4741 |
1714 | 2020-08-31 | 3 | 1967.0284 |
Most frequently occurring
수요예측일자 | 시간HH24 | 실제유량값 | # duplicates | |
---|---|---|---|---|
0 | 2020-08-31 | 0 | 32.6763 | 2 |
1 | 2020-08-31 | 0 | 34.2277 | 2 |
2 | 2020-08-31 | 0 | 37.3333 | 2 |
3 | 2020-08-31 | 0 | 94.6254 | 2 |
4 | 2020-08-31 | 0 | 125.5161 | 2 |
5 | 2020-08-31 | 0 | 162.2679 | 2 |
6 | 2020-08-31 | 0 | 168.1071 | 2 |
7 | 2020-08-31 | 0 | 423.2644 | 2 |
8 | 2020-08-31 | 1 | 21.7 | 2 |
9 | 2020-08-31 | 1 | 26.2938 | 2 |