Dataset statistics
Number of variables | 3 |
---|---|
Number of observations | 87 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 8 |
Duplicate rows (%) | 9.2% |
Total size in memory | 2.3 KiB |
Average record size in memory | 26.5 B |
Variable types
Categorical | 2 |
---|---|
Numeric | 1 |
Dataset
Description | 경상북도 구미시 유수율제고블록시스템DB내의 수요예측블록별유량 테이블 정보입니다. |
---|---|
Author | 경상북도 구미시 |
URL | https://www.data.go.kr/data/15049707/fileData.do |
수요예측일자 has constant value "" | Constant |
등록시간 has constant value "" | Constant |
Dataset has 8 (9.2%) duplicate rows | Duplicates |
유량평균값 has 14 (16.1%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-12 13:31:44.607276 |
---|---|
Analysis finished | 2023-12-12 13:31:44.863381 |
Duration | 0.26 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
수요예측일자
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 1.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 828.0 B |
2020-08-31 |
---|
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2020-08-31 |
---|---|
2nd row | 2020-08-31 |
3rd row | 2020-08-31 |
4th row | 2020-08-31 |
5th row | 2020-08-31 |
Common Values
Value | Count | Frequency (%) |
2020-08-31 | 87 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2020-08-31 | 87 |
유량평균값
Real number (ℝ)
ZEROS
 
Distinct | 67 |
---|---|
Distinct (%) | 77.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 3955.4846 |
Minimum | 0 |
---|---|
Maximum | 86031.791 |
Zeros | 14 |
Zeros (%) | 16.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 915.0 B |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 230.4621 |
median | 1268.1301 |
Q3 | 3551.1678 |
95-th percentile | 13511.913 |
Maximum | 86031.791 |
Range | 86031.791 |
Interquartile range (IQR) | 3320.7057 |
Descriptive statistics
Standard deviation | 10219.774 |
---|---|
Coefficient of variation (CV) | 2.583697 |
Kurtosis | 49.832138 |
Mean | 3955.4846 |
Median Absolute Deviation (MAD) | 1268.1301 |
Skewness | 6.5319441 |
Sum | 344127.16 |
Variance | 1.0444377 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0.0 | 14 | 16.1% |
11146.3359 | 2 | 2.3% |
109.1921 | 2 | 2.3% |
4191.3611 | 2 | 2.3% |
2886.1146 | 2 | 2.3% |
3824.7034 | 2 | 2.3% |
2074.4086 | 2 | 2.3% |
1268.1301 | 2 | 2.3% |
221.7281 | 1 | 1.1% |
3327.9969 | 1 | 1.1% |
Other values (57) | 57 |
Value | Count | Frequency (%) |
0.0 | 14 | |
9.5806 | 1 | 1.1% |
33.25 | 1 | 1.1% |
109.1921 | 2 | 2.3% |
182.9833 | 1 | 1.1% |
221.7281 | 1 | 1.1% |
222.2451 | 1 | 1.1% |
230.2221 | 1 | 1.1% |
230.7021 | 1 | 1.1% |
386.8872 | 1 | 1.1% |
Value | Count | Frequency (%) |
86031.7906 | 1 | |
34288.8332 | 1 | |
18394.435 | 1 | |
15129.184 | 1 | |
14203.0739 | 1 | |
11899.2046 | 1 | |
11146.3359 | 2 | |
10023.4164 | 1 | |
9309.2166 | 1 | |
8257.5884 | 1 |
등록시간
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 1.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 828.0 B |
2020-08-31 17:29 |
---|
Length
Max length | 16 |
---|---|
Median length | 16 |
Mean length | 16 |
Min length | 16 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2020-08-31 17:29 |
---|---|
2nd row | 2020-08-31 17:29 |
3rd row | 2020-08-31 17:29 |
4th row | 2020-08-31 17:29 |
5th row | 2020-08-31 17:29 |
Common Values
Value | Count | Frequency (%) |
2020-08-31 17:29 | 87 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2020-08-31 | 87 | |
17:29 | 87 |
수요예측일자 | 유량평균값 | 등록시간 | |
---|---|---|---|
0 | 2020-08-31 | 11146.3359 | 2020-08-31 17:29 |
1 | 2020-08-31 | 11146.3359 | 2020-08-31 17:29 |
2 | 2020-08-31 | 9309.2166 | 2020-08-31 17:29 |
3 | 2020-08-31 | 1071.968 | 2020-08-31 17:29 |
4 | 2020-08-31 | 765.1513 | 2020-08-31 17:29 |
5 | 2020-08-31 | 0.0 | 2020-08-31 17:29 |
6 | 2020-08-31 | 0.0 | 2020-08-31 17:29 |
7 | 2020-08-31 | 86031.7906 | 2020-08-31 17:29 |
8 | 2020-08-31 | 1268.1301 | 2020-08-31 17:29 |
9 | 2020-08-31 | 1268.1301 | 2020-08-31 17:29 |
수요예측일자 | 유량평균값 | 등록시간 | |
---|---|---|---|
77 | 2020-08-31 | 2906.5604 | 2020-08-31 17:29 |
78 | 2020-08-31 | 2074.4086 | 2020-08-31 17:29 |
79 | 2020-08-31 | 2074.4086 | 2020-08-31 17:29 |
80 | 2020-08-31 | 8257.5884 | 2020-08-31 17:29 |
81 | 2020-08-31 | 399.6107 | 2020-08-31 17:29 |
82 | 2020-08-31 | 1715.6667 | 2020-08-31 17:29 |
83 | 2020-08-31 | 3218.0042 | 2020-08-31 17:29 |
84 | 2020-08-31 | 541.0578 | 2020-08-31 17:29 |
85 | 2020-08-31 | 2383.249 | 2020-08-31 17:29 |
86 | 2020-08-31 | 0.0 | 2020-08-31 17:29 |
Most frequently occurring
수요예측일자 | 유량평균값 | 등록시간 | # duplicates | |
---|---|---|---|---|
0 | 2020-08-31 | 0.0 | 2020-08-31 17:29 | 14 |
1 | 2020-08-31 | 109.1921 | 2020-08-31 17:29 | 2 |
2 | 2020-08-31 | 1268.1301 | 2020-08-31 17:29 | 2 |
3 | 2020-08-31 | 2074.4086 | 2020-08-31 17:29 | 2 |
4 | 2020-08-31 | 2886.1146 | 2020-08-31 17:29 | 2 |
5 | 2020-08-31 | 3824.7034 | 2020-08-31 17:29 | 2 |
6 | 2020-08-31 | 4191.3611 | 2020-08-31 17:29 | 2 |
7 | 2020-08-31 | 11146.3359 | 2020-08-31 17:29 | 2 |