Dataset statistics
Number of variables | 7 |
---|---|
Number of observations | 10000 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 1445 |
Duplicate rows (%) | 14.4% |
Total size in memory | 664.1 KiB |
Average record size in memory | 68.0 B |
Variable types
Numeric | 4 |
---|---|
Categorical | 2 |
DateTime | 1 |
Dataset
Description | 이천시의 강수에 따른 하천, 저수지 등의 수위 데이터 지점코드, 지점명, 분류, 시간, 평균수위, 최저수위, 최고수위 등을 알수 있음 |
---|---|
Author | 경기도 이천시 |
URL | https://www.data.go.kr/data/15038194/fileData.do |
분류(M 10분) has constant value "" | Constant |
Dataset has 1445 (14.4%) duplicate rows | Duplicates |
지점코드 is highly overall correlated with 지점명 | High correlation |
평균수위(cm) is highly overall correlated with 최저수위(cm) and 2 other fields | High correlation |
최저수위(cm) is highly overall correlated with 평균수위(cm) and 2 other fields | High correlation |
최고수위(cm) is highly overall correlated with 평균수위(cm) and 2 other fields | High correlation |
지점명 is highly overall correlated with 지점코드 and 3 other fields | High correlation |
평균수위(cm) has 1850 (18.5%) zeros | Zeros |
최저수위(cm) has 1850 (18.5%) zeros | Zeros |
최고수위(cm) has 1850 (18.5%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-12 15:57:50.714331 |
---|---|
Analysis finished | 2023-12-12 15:57:54.102529 |
Duration | 3.39 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
지점코드
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 8 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 4.1500324 × 109 |
Minimum | 4.150025 × 109 |
---|---|
Maximum | 4.150037 × 109 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 4.150025 × 109 |
---|---|
5-th percentile | 4.150025 × 109 |
Q1 | 4.150031 × 109 |
median | 4.150034 × 109 |
Q3 | 4.150036 × 109 |
95-th percentile | 4.150037 × 109 |
Maximum | 4.150037 × 109 |
Range | 12021 |
Interquartile range (IQR) | 4993 |
Descriptive statistics
Standard deviation | 4611.9872 |
---|---|
Coefficient of variation (CV) | 1.1113135 × 10-6 |
Kurtosis | -1.0750166 |
Mean | 4.1500324 × 109 |
Median Absolute Deviation (MAD) | 2992 |
Skewness | -0.69443154 |
Sum | 4.1500324 × 1013 |
Variance | 21270426 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
4150031029 | 1318 | |
4150034021 | 1288 | |
4150025003 | 1260 | |
4150034029 | 1254 | |
4150037024 | 1247 | |
4150037022 | 1233 | |
4150025004 | 1204 | |
4150036022 | 1196 |
Value | Count | Frequency (%) |
4150025003 | 1260 | |
4150025004 | 1204 | |
4150031029 | 1318 | |
4150034021 | 1288 | |
4150034029 | 1254 | |
4150036022 | 1196 | |
4150037022 | 1233 | |
4150037024 | 1247 |
Value | Count | Frequency (%) |
4150037024 | 1247 | |
4150037022 | 1233 | |
4150036022 | 1196 | |
4150034029 | 1254 | |
4150034021 | 1288 | |
4150031029 | 1318 | |
4150025004 | 1204 | |
4150025003 | 1260 |
지점명
Categorical
HIGH CORRELATION
 
Distinct | 8 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
학암저수지 | |
---|---|
오천1교 | |
장호원교 | |
각평저수지 | |
고당교 | |
Other values (3) |
Length
Max length | 5 |
---|---|
Median length | 5 |
Mean length | 4.255 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 오천1교 |
---|---|
2nd row | 고당교 |
3rd row | 복하교 |
4th row | 장호원교 |
5th row | 복하교 |
Common Values
Value | Count | Frequency (%) |
학암저수지 | 1318 | |
오천1교 | 1288 | |
장호원교 | 1260 | |
각평저수지 | 1254 | |
고당교 | 1247 | |
성호저수지 | 1233 | |
복하교 | 1204 | |
서경저수지 | 1196 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
학암저수지 | 1318 | |
오천1교 | 1288 | |
장호원교 | 1260 | |
각평저수지 | 1254 | |
고당교 | 1247 | |
성호저수지 | 1233 | |
복하교 | 1204 | |
서경저수지 | 1196 |
분류(M 10분)
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
M |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | M |
---|---|
2nd row | M |
3rd row | M |
4th row | M |
5th row | M |
Common Values
Value | Count | Frequency (%) |
M | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
m | 10000 |
날짜
Date
Distinct | 83 |
---|---|
Distinct (%) | 0.8% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
Minimum | 2020-07-28 00:00:00 |
---|---|
Maximum | 2020-10-18 00:00:00 |
평균수위(cm)
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 368 |
---|---|
Distinct (%) | 3.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 92.0612 |
Minimum | -17 |
---|---|
Maximum | 759 |
Zeros | 1850 |
Zeros (%) | 18.5% |
Negative | 338 |
Negative (%) | 3.4% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | -17 |
---|---|
5-th percentile | 0 |
Q1 | 13 |
median | 99 |
Q3 | 168 |
95-th percentile | 230 |
Maximum | 759 |
Range | 776 |
Interquartile range (IQR) | 155 |
Descriptive statistics
Standard deviation | 89.600836 |
---|---|
Coefficient of variation (CV) | 0.9732747 |
Kurtosis | 4.1844004 |
Mean | 92.0612 |
Median Absolute Deviation (MAD) | 81 |
Skewness | 1.1907028 |
Sum | 920612 |
Variance | 8028.3099 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 1850 | 18.5% |
34 | 413 | 4.1% |
35 | 321 | 3.2% |
36 | 141 | 1.4% |
99 | 140 | 1.4% |
13 | 136 | 1.4% |
100 | 134 | 1.3% |
101 | 105 | 1.1% |
109 | 104 | 1.0% |
14 | 103 | 1.0% |
Other values (358) | 6553 |
Value | Count | Frequency (%) |
-17 | 41 | |
-16 | 43 | |
-15 | 48 | |
-14 | 41 | |
-13 | 25 | |
-12 | 24 | |
-11 | 31 | |
-10 | 26 | |
-9 | 12 | 0.1% |
-8 | 17 | 0.2% |
Value | Count | Frequency (%) |
759 | 1 | < 0.1% |
758 | 1 | < 0.1% |
755 | 1 | < 0.1% |
730 | 1 | < 0.1% |
728 | 2 | |
727 | 1 | < 0.1% |
726 | 3 | |
725 | 1 | < 0.1% |
724 | 1 | < 0.1% |
723 | 1 | < 0.1% |
최저수위(cm)
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 368 |
---|---|
Distinct (%) | 3.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 92.0612 |
Minimum | -17 |
---|---|
Maximum | 759 |
Zeros | 1850 |
Zeros (%) | 18.5% |
Negative | 338 |
Negative (%) | 3.4% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | -17 |
---|---|
5-th percentile | 0 |
Q1 | 13 |
median | 99 |
Q3 | 168 |
95-th percentile | 230 |
Maximum | 759 |
Range | 776 |
Interquartile range (IQR) | 155 |
Descriptive statistics
Standard deviation | 89.600836 |
---|---|
Coefficient of variation (CV) | 0.9732747 |
Kurtosis | 4.1844004 |
Mean | 92.0612 |
Median Absolute Deviation (MAD) | 81 |
Skewness | 1.1907028 |
Sum | 920612 |
Variance | 8028.3099 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 1850 | 18.5% |
34 | 413 | 4.1% |
35 | 321 | 3.2% |
36 | 141 | 1.4% |
99 | 140 | 1.4% |
13 | 136 | 1.4% |
100 | 134 | 1.3% |
101 | 105 | 1.1% |
109 | 104 | 1.0% |
14 | 103 | 1.0% |
Other values (358) | 6553 |
Value | Count | Frequency (%) |
-17 | 41 | |
-16 | 43 | |
-15 | 48 | |
-14 | 41 | |
-13 | 25 | |
-12 | 24 | |
-11 | 31 | |
-10 | 26 | |
-9 | 12 | 0.1% |
-8 | 17 | 0.2% |
Value | Count | Frequency (%) |
759 | 1 | < 0.1% |
758 | 1 | < 0.1% |
755 | 1 | < 0.1% |
730 | 1 | < 0.1% |
728 | 2 | |
727 | 1 | < 0.1% |
726 | 3 | |
725 | 1 | < 0.1% |
724 | 1 | < 0.1% |
723 | 1 | < 0.1% |
최고수위(cm)
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 368 |
---|---|
Distinct (%) | 3.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 92.0612 |
Minimum | -17 |
---|---|
Maximum | 759 |
Zeros | 1850 |
Zeros (%) | 18.5% |
Negative | 338 |
Negative (%) | 3.4% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | -17 |
---|---|
5-th percentile | 0 |
Q1 | 13 |
median | 99 |
Q3 | 168 |
95-th percentile | 230 |
Maximum | 759 |
Range | 776 |
Interquartile range (IQR) | 155 |
Descriptive statistics
Standard deviation | 89.600836 |
---|---|
Coefficient of variation (CV) | 0.9732747 |
Kurtosis | 4.1844004 |
Mean | 92.0612 |
Median Absolute Deviation (MAD) | 81 |
Skewness | 1.1907028 |
Sum | 920612 |
Variance | 8028.3099 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 1850 | 18.5% |
34 | 413 | 4.1% |
35 | 321 | 3.2% |
36 | 141 | 1.4% |
99 | 140 | 1.4% |
13 | 136 | 1.4% |
100 | 134 | 1.3% |
101 | 105 | 1.1% |
109 | 104 | 1.0% |
14 | 103 | 1.0% |
Other values (358) | 6553 |
Value | Count | Frequency (%) |
-17 | 41 | |
-16 | 43 | |
-15 | 48 | |
-14 | 41 | |
-13 | 25 | |
-12 | 24 | |
-11 | 31 | |
-10 | 26 | |
-9 | 12 | 0.1% |
-8 | 17 | 0.2% |
Value | Count | Frequency (%) |
759 | 1 | < 0.1% |
758 | 1 | < 0.1% |
755 | 1 | < 0.1% |
730 | 1 | < 0.1% |
728 | 2 | |
727 | 1 | < 0.1% |
726 | 3 | |
725 | 1 | < 0.1% |
724 | 1 | < 0.1% |
723 | 1 | < 0.1% |
지점코드 | 지점명 | 날짜 | 평균수위(cm) | 최저수위(cm) | 최고수위(cm) | |
---|---|---|---|---|---|---|
지점코드 | 1.000 | 1.000 | 0.077 | 0.679 | 0.679 | 0.679 |
지점명 | 1.000 | 1.000 | 0.000 | 0.775 | 0.775 | 0.775 |
날짜 | 0.077 | 0.000 | 1.000 | 0.506 | 0.506 | 0.506 |
평균수위(cm) | 0.679 | 0.775 | 0.506 | 1.000 | 1.000 | 1.000 |
최저수위(cm) | 0.679 | 0.775 | 0.506 | 1.000 | 1.000 | 1.000 |
최고수위(cm) | 0.679 | 0.775 | 0.506 | 1.000 | 1.000 | 1.000 |
지점코드 | 평균수위(cm) | 최저수위(cm) | 최고수위(cm) | 지점명 | |
---|---|---|---|---|---|
지점코드 | 1.000 | 0.353 | 0.353 | 0.353 | 1.000 |
평균수위(cm) | 0.353 | 1.000 | 1.000 | 1.000 | 0.517 |
최저수위(cm) | 0.353 | 1.000 | 1.000 | 1.000 | 0.517 |
최고수위(cm) | 0.353 | 1.000 | 1.000 | 1.000 | 0.517 |
지점명 | 1.000 | 0.517 | 0.517 | 0.517 | 1.000 |
지점코드 | 지점명 | 분류(M 10분) | 날짜 | 평균수위(cm) | 최저수위(cm) | 최고수위(cm) | |
---|---|---|---|---|---|---|---|
65665 | 4150034021 | 오천1교 | M | 2020-09-23 | 104 | 104 | 104 |
66137 | 4150037024 | 고당교 | M | 2020-09-23 | 201 | 201 | 201 |
34071 | 4150025004 | 복하교 | M | 2020-08-26 | 14 | 14 | 14 |
72728 | 4150025003 | 장호원교 | M | 2020-09-29 | 107 | 107 | 107 |
9375 | 4150025004 | 복하교 | M | 2020-08-05 | 52 | 52 | 52 |
46997 | 4150025004 | 복하교 | M | 2020-09-06 | 21 | 21 | 21 |
59397 | 4150036022 | 서경저수지 | M | 2020-09-17 | 0 | 0 | 0 |
90534 | 4150037022 | 성호저수지 | M | 2020-10-14 | 202 | 202 | 202 |
53374 | 4150034021 | 오천1교 | M | 2020-09-12 | 113 | 113 | 113 |
39622 | 4150034021 | 오천1교 | M | 2020-08-31 | 110 | 110 | 110 |
지점코드 | 지점명 | 분류(M 10분) | 날짜 | 평균수위(cm) | 최저수위(cm) | 최고수위(cm) | |
---|---|---|---|---|---|---|---|
1019 | 4150025004 | 복하교 | M | 2020-07-28 | -1 | -1 | -1 |
51931 | 4150034029 | 각평저수지 | M | 2020-09-11 | 36 | 36 | 36 |
37859 | 4150036022 | 서경저수지 | M | 2020-08-29 | 0 | 0 | 0 |
90763 | 4150025004 | 복하교 | M | 2020-10-14 | -16 | -16 | -16 |
72808 | 4150034029 | 각평저수지 | M | 2020-09-29 | 34 | 34 | 34 |
43010 | 4150025004 | 복하교 | M | 2020-09-03 | 122 | 122 | 122 |
23416 | 4150034029 | 각평저수지 | M | 2020-08-17 | 37 | 37 | 37 |
19168 | 4150031029 | 학암저수지 | M | 2020-08-13 | 12 | 12 | 12 |
29725 | 4150037022 | 성호저수지 | M | 2020-08-22 | 204 | 204 | 204 |
12953 | 4150036022 | 서경저수지 | M | 2020-08-08 | 0 | 0 | 0 |
Most frequently occurring
지점코드 | 지점명 | 분류(M 10분) | 날짜 | 평균수위(cm) | 최저수위(cm) | 최고수위(cm) | # duplicates | |
---|---|---|---|---|---|---|---|---|
512 | 4150031029 | 학암저수지 | M | 2020-09-16 | 0 | 0 | 0 | 24 |
955 | 4150036022 | 서경저수지 | M | 2020-09-13 | 0 | 0 | 0 | 24 |
909 | 4150036022 | 서경저수지 | M | 2020-07-29 | 0 | 0 | 0 | 23 |
965 | 4150036022 | 서경저수지 | M | 2020-09-23 | 0 | 0 | 0 | 23 |
1054 | 4150037022 | 성호저수지 | M | 2020-08-21 | 205 | 205 | 205 | 23 |
201 | 4150025003 | 장호원교 | M | 2020-10-17 | 99 | 99 | 99 | 22 |
392 | 4150025004 | 복하교 | M | 2020-10-11 | -15 | -15 | -15 | 22 |
477 | 4150031029 | 학암저수지 | M | 2020-09-01 | 14 | 14 | 14 | 22 |
931 | 4150036022 | 서경저수지 | M | 2020-08-20 | 0 | 0 | 0 | 22 |
933 | 4150036022 | 서경저수지 | M | 2020-08-22 | 0 | 0 | 0 | 22 |