Overview

Dataset statistics

Number of variables8
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.1 KiB
Average record size in memory72.3 B

Variable types

Categorical3
Numeric5

Alerts

댐이름 has constant value ""Constant
저수위(m) has constant value ""Constant
일자/시간(t) is highly overall correlated with 강우량(mm) and 3 other fieldsHigh correlation
강우량(mm) is highly overall correlated with 일자/시간(t) and 3 other fieldsHigh correlation
유입량(ms) is highly overall correlated with 일자/시간(t) and 3 other fieldsHigh correlation
저수율 is highly overall correlated with 일자/시간(t) and 3 other fieldsHigh correlation
저수량(백만m3) is highly overall correlated with 일자/시간(t) and 3 other fieldsHigh correlation
일자/시간(t) has unique valuesUnique

Reproduction

Analysis started2023-12-10 13:15:52.636157
Analysis finished2023-12-10 13:15:58.226129
Duration5.59 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

댐이름
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
군남
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row군남
2nd row군남
3rd row군남
4th row군남
5th row군남

Common Values

ValueCountFrequency (%)
군남 100
100.0%

Length

2023-12-10T22:15:58.339621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:15:58.488176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
군남 100
100.0%

일자/시간(t)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0190401 × 1011
Minimum2.0190401 × 1011
Maximum2.0190402 × 1011
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:15:58.659056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0190401 × 1011
5-th percentile2.0190401 × 1011
Q12.0190401 × 1011
median2.0190401 × 1011
Q32.0190401 × 1011
95-th percentile2.0190402 × 1011
Maximum2.0190402 × 1011
Range10420
Interquartile range (IQR)815

Descriptive statistics

Standard deviation3563.5355
Coefficient of variation (CV)1.7649652 × 10-8
Kurtosis1.491252
Mean2.0190401 × 1011
Median Absolute Deviation (MAD)410
Skewness1.8383492
Sum2.0190401 × 1013
Variance12698785
MonotonicityNot monotonic
2023-12-10T22:15:58.958436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
201904010620 1
 
1.0%
201904010440 1
 
1.0%
201904010130 1
 
1.0%
201904010200 1
 
1.0%
201904010210 1
 
1.0%
201904010230 1
 
1.0%
201904010240 1
 
1.0%
201904010320 1
 
1.0%
201904010330 1
 
1.0%
201904010350 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
201904010010 1
1.0%
201904010020 1
1.0%
201904010030 1
1.0%
201904010040 1
1.0%
201904010050 1
1.0%
201904010100 1
1.0%
201904010110 1
1.0%
201904010120 1
1.0%
201904010130 1
1.0%
201904010140 1
1.0%
ValueCountFrequency (%)
201904020430 1
1.0%
201904020420 1
1.0%
201904020410 1
1.0%
201904020400 1
1.0%
201904020350 1
1.0%
201904020340 1
1.0%
201904020330 1
1.0%
201904020320 1
1.0%
201904020310 1
1.0%
201904020300 1
1.0%

저수위(m)
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
0
100 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 100
100.0%

Length

2023-12-10T22:15:59.212510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:15:59.382218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 100
100.0%

강우량(mm)
Real number (ℝ)

HIGH CORRELATION 

Distinct19
Distinct (%)19.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.04988
Minimum7.816
Maximum8.298
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:15:59.582394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum7.816
5-th percentile7.836
Q17.975
median8.035
Q38.095
95-th percentile8.278
Maximum8.298
Range0.482
Interquartile range (IQR)0.12

Descriptive statistics

Standard deviation0.12169919
Coefficient of variation (CV)0.015118137
Kurtosis-0.17765215
Mean8.04988
Median Absolute Deviation (MAD)0.06
Skewness0.13552608
Sum804.988
Variance0.014810693
MonotonicityNot monotonic
2023-12-10T22:15:59.849220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
8.095 26
26.0%
8.035 13
13.0%
8.015 9
 
9.0%
8.075 7
 
7.0%
7.975 6
 
6.0%
8.278 5
 
5.0%
7.955 4
 
4.0%
7.816 4
 
4.0%
7.915 4
 
4.0%
7.855 4
 
4.0%
Other values (9) 18
18.0%
ValueCountFrequency (%)
7.816 4
4.0%
7.836 2
 
2.0%
7.855 4
4.0%
7.875 2
 
2.0%
7.915 4
4.0%
7.935 2
 
2.0%
7.955 4
4.0%
7.975 6
6.0%
7.995 1
 
1.0%
8.015 9
9.0%
ValueCountFrequency (%)
8.298 3
 
3.0%
8.278 5
 
5.0%
8.258 2
 
2.0%
8.237 1
 
1.0%
8.217 4
 
4.0%
8.197 1
 
1.0%
8.095 26
26.0%
8.075 7
 
7.0%
8.035 13
13.0%
8.015 9
 
9.0%

유입량(ms)
Real number (ℝ)

HIGH CORRELATION 

Distinct7
Distinct (%)7.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.243
Minimum10.9
Maximum11.6
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:16:00.048309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10.9
5-th percentile10.9
Q111.1
median11.2
Q311.3
95-th percentile11.6
Maximum11.6
Range0.7
Interquartile range (IQR)0.2

Descriptive statistics

Standard deviation0.17652939
Coefficient of variation (CV)0.015701271
Kurtosis-0.043646223
Mean11.243
Median Absolute Deviation (MAD)0.1
Skewness0.24183418
Sum1124.3
Variance0.031162626
MonotonicityNot monotonic
2023-12-10T22:16:00.257064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
11.3 33
33.0%
11.2 23
23.0%
11.1 16
16.0%
11.5 8
 
8.0%
11.6 8
 
8.0%
10.9 6
 
6.0%
11.0 6
 
6.0%
ValueCountFrequency (%)
10.9 6
 
6.0%
11.0 6
 
6.0%
11.1 16
16.0%
11.2 23
23.0%
11.3 33
33.0%
11.5 8
 
8.0%
11.6 8
 
8.0%
ValueCountFrequency (%)
11.6 8
 
8.0%
11.5 8
 
8.0%
11.3 33
33.0%
11.2 23
23.0%
11.1 16
16.0%
11.0 6
 
6.0%
10.9 6
 
6.0%

방류량(ms)
Real number (ℝ)

Distinct24
Distinct (%)24.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12.01416
Minimum5
Maximum39.111
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:16:00.448008image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum5
5-th percentile5
Q15.1
median5.5
Q316.433
95-th percentile27.7138
Maximum39.111
Range34.111
Interquartile range (IQR)11.333

Descriptive statistics

Standard deviation8.323853
Coefficient of variation (CV)0.69283687
Kurtosis0.00050973635
Mean12.01416
Median Absolute Deviation (MAD)0.5
Skewness0.91101494
Sum1201.416
Variance69.28653
MonotonicityNot monotonic
2023-12-10T22:16:00.809789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
5.1 30
30.0%
5.0 20
20.0%
17.0 7
 
7.0%
16.111 7
 
7.0%
16.433 5
 
5.0%
16.378 5
 
5.0%
16.322 3
 
3.0%
28.056 2
 
2.0%
16.056 2
 
2.0%
27.278 2
 
2.0%
Other values (14) 17
17.0%
ValueCountFrequency (%)
5.0 20
20.0%
5.1 30
30.0%
5.9 1
 
1.0%
6.0 2
 
2.0%
16.056 2
 
2.0%
16.111 7
 
7.0%
16.167 1
 
1.0%
16.322 3
 
3.0%
16.344 1
 
1.0%
16.378 5
 
5.0%
ValueCountFrequency (%)
39.111 1
1.0%
28.056 2
2.0%
28.0 1
1.0%
27.767 1
1.0%
27.711 2
2.0%
27.423 1
1.0%
27.39 1
1.0%
27.357 1
1.0%
27.278 2
2.0%
27.167 1
1.0%

저수량(백만m3)
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)5.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
5.1
48 
5.0
35 
6.0
15 
5.07
 
1
5.7
 
1

Length

Max length4
Median length3
Mean length3.01
Min length3

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st row5.0
2nd row5.1
3rd row6.0
4th row5.0
5th row5.1

Common Values

ValueCountFrequency (%)
5.1 48
48.0%
5.0 35
35.0%
6.0 15
 
15.0%
5.07 1
 
1.0%
5.7 1
 
1.0%

Length

2023-12-10T22:16:01.084788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:16:01.314133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
5.1 48
48.0%
5.0 35
35.0%
6.0 15
 
15.0%
5.07 1
 
1.0%
5.7 1
 
1.0%

저수율
Real number (ℝ)

HIGH CORRELATION 

Distinct19
Distinct (%)19.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28.4172
Minimum28.3
Maximum28.54
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:16:01.483643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum28.3
5-th percentile28.31
Q128.38
median28.41
Q328.44
95-th percentile28.53
Maximum28.54
Range0.24
Interquartile range (IQR)0.06

Descriptive statistics

Standard deviation0.060537658
Coefficient of variation (CV)0.0021303175
Kurtosis-0.1847043
Mean28.4172
Median Absolute Deviation (MAD)0.03
Skewness0.1111209
Sum2841.72
Variance0.0036648081
MonotonicityNot monotonic
2023-12-10T22:16:01.699895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
28.44 26
26.0%
28.41 13
13.0%
28.4 9
 
9.0%
28.43 7
 
7.0%
28.38 6
 
6.0%
28.53 5
 
5.0%
28.37 4
 
4.0%
28.3 4
 
4.0%
28.35 4
 
4.0%
28.32 4
 
4.0%
Other values (9) 18
18.0%
ValueCountFrequency (%)
28.3 4
4.0%
28.31 2
 
2.0%
28.32 4
4.0%
28.33 2
 
2.0%
28.35 4
4.0%
28.36 2
 
2.0%
28.37 4
4.0%
28.38 6
6.0%
28.39 1
 
1.0%
28.4 9
9.0%
ValueCountFrequency (%)
28.54 3
 
3.0%
28.53 5
 
5.0%
28.52 2
 
2.0%
28.51 1
 
1.0%
28.5 4
 
4.0%
28.49 1
 
1.0%
28.44 26
26.0%
28.43 7
 
7.0%
28.41 13
13.0%
28.4 9
 
9.0%

Interactions

2023-12-10T22:15:56.998043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:53.103152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:53.928976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:55.230177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:56.254498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:57.150024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:53.281265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:54.080992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:55.467536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:56.389466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:57.357850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:53.430809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:54.230116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:55.701755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:56.551572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:57.537501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:53.624843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:54.390348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:55.960828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:56.698912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:57.722781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:53.794467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:54.547550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:56.093156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:15:56.858271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T22:16:01.848514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일자/시간(t)강우량(mm)유입량(ms)방류량(ms)저수량(백만m3)저수율
일자/시간(t)1.0000.9820.8600.3320.5650.982
강우량(mm)0.9821.0000.9450.4740.8201.000
유입량(ms)0.8600.9451.0000.3940.7780.945
방류량(ms)0.3320.4740.3941.0000.2490.474
저수량(백만m3)0.5650.8200.7780.2491.0000.820
저수율0.9821.0000.9450.4740.8201.000
2023-12-10T22:16:02.116712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일자/시간(t)강우량(mm)유입량(ms)방류량(ms)저수율저수량(백만m3)
일자/시간(t)1.0000.9890.973-0.1410.9890.506
강우량(mm)0.9891.0000.983-0.1001.0000.641
유입량(ms)0.9730.9831.000-0.0500.9830.642
방류량(ms)-0.141-0.100-0.0501.000-0.1000.203
저수율0.9891.0000.983-0.1001.0000.641
저수량(백만m3)0.5060.6410.6420.2030.6411.000

Missing values

2023-12-10T22:15:57.919434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T22:15:58.130054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

댐이름일자/시간(t)저수위(m)강우량(mm)유입량(ms)방류량(ms)저수량(백만m3)저수율
0군남20190401062008.01511.25.05.028.4
1군남20190402022008.21711.516.3785.128.5
2군남20190401001007.81610.917.06.028.3
3군남20190401063008.03511.216.1115.028.41
4군남20190401120008.09511.35.15.128.44
5군남20190402023008.21711.516.3785.128.5
6군남20190401025007.93511.116.6785.028.36
7군남20190401002007.81610.917.06.028.3
8군남20190401091008.07511.35.15.128.43
9군남20190401064008.03511.216.1115.028.41
댐이름일자/시간(t)저수위(m)강우량(mm)유입량(ms)방류량(ms)저수량(백만m3)저수율
90군남20190401075008.03511.25.05.028.41
91군남20190401074008.03511.25.05.028.41
92군남20190401072008.03511.25.05.028.41
93군남20190401071008.03511.25.05.028.41
94군남20190401061008.01511.25.05.028.4
95군남20190401060008.01511.25.05.028.4
96군남20190401054008.01511.25.05.028.4
97군남20190401053008.01511.25.05.028.4
98군남20190402020008.19711.516.3785.128.49
99군남20190402021008.21711.516.3785.128.5