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

Categorical5
Numeric3

Alerts

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

Reproduction

Analysis started2023-12-10 10:44:45.889259
Analysis finished2023-12-10 10:44:48.158212
Duration2.27 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 length6
Median length6
Mean length6
Min length6

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-10T19:44:48.272863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:44:48.446029image/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.0190202 × 1011
Minimum2.0190201 × 1011
Maximum2.0190202 × 1011
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:44:48.717636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0190201 × 1011
5-th percentile2.0190201 × 1011
Q12.0190201 × 1011
median2.0190202 × 1011
Q32.0190202 × 1011
95-th percentile2.0190202 × 1011
Maximum2.0190202 × 1011
Range9270
Interquartile range (IQR)8425

Descriptive statistics

Standard deviation4160.3393
Coefficient of variation (CV)2.0605734 × 10-8
Kurtosis-1.8547341
Mean2.0190202 × 1011
Median Absolute Deviation (MAD)680
Skewness-0.40813499
Sum2.0190202 × 1013
Variance17308423
MonotonicityNot monotonic
2023-12-10T19:44:49.047488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
201902020950 1
 
1.0%
201902012310 1
 
1.0%
201902012130 1
 
1.0%
201902012140 1
 
1.0%
201902012150 1
 
1.0%
201902012200 1
 
1.0%
201902012210 1
 
1.0%
201902012220 1
 
1.0%
201902012230 1
 
1.0%
201902012240 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
201902011730 1
1.0%
201902011740 1
1.0%
201902011750 1
1.0%
201902011800 1
1.0%
201902011810 1
1.0%
201902011820 1
1.0%
201902011830 1
1.0%
201902011840 1
1.0%
201902011850 1
1.0%
201902011900 1
1.0%
ValueCountFrequency (%)
201902021000 1
1.0%
201902020950 1
1.0%
201902020940 1
1.0%
201902020930 1
1.0%
201902020920 1
1.0%
201902020910 1
1.0%
201902020900 1
1.0%
201902020850 1
1.0%
201902020840 1
1.0%
201902020830 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-10T19:44:49.598480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

강우량(mm)
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
305.625
55 
305.159
28 
306.092
15 
304.694
 
2

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row305.625
2nd row305.625
3rd row305.625
4th row305.625
5th row305.625

Common Values

ValueCountFrequency (%)
305.625 55
55.0%
305.159 28
28.0%
306.092 15
 
15.0%
304.694 2
 
2.0%

Length

2023-12-10T19:44:49.916112image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:44:50.103777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
305.625 55
55.0%
305.159 28
28.0%
306.092 15
 
15.0%
304.694 2
 
2.0%

유입량(ms)
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
99.5
55 
99.3
28 
99.6
15 
99.2
 
2

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row99.5
2nd row99.5
3rd row99.5
4th row99.5
5th row99.5

Common Values

ValueCountFrequency (%)
99.5 55
55.0%
99.3 28
28.0%
99.6 15
 
15.0%
99.2 2
 
2.0%

Length

2023-12-10T19:44:50.321995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:44:50.520361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
99.5 55
55.0%
99.3 28
28.0%
99.6 15
 
15.0%
99.2 2
 
2.0%

방류량(ms)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct84
Distinct (%)84.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean75.10914
Minimum0
Maximum357.619
Zeros17
Zeros (%)17.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:44:50.756183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q127.75225
median29.6415
Q390.83675
95-th percentile287.08505
Maximum357.619
Range357.619
Interquartile range (IQR)63.0845

Descriptive statistics

Standard deviation94.133357
Coefficient of variation (CV)1.2532876
Kurtosis2.2092141
Mean75.10914
Median Absolute Deviation (MAD)27.2125
Skewness1.836095
Sum7510.914
Variance8861.0888
MonotonicityNot monotonic
2023-12-10T19:44:51.015238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 17
 
17.0%
54.425 1
 
1.0%
35.654 1
 
1.0%
81.426 1
 
1.0%
65.659 1
 
1.0%
47.1 1
 
1.0%
47.176 1
 
1.0%
46.935 1
 
1.0%
46.907 1
 
1.0%
46.892 1
 
1.0%
Other values (74) 74
74.0%
ValueCountFrequency (%)
0.0 17
17.0%
27.468 1
 
1.0%
27.594 1
 
1.0%
27.666 1
 
1.0%
27.678 1
 
1.0%
27.689 1
 
1.0%
27.7 1
 
1.0%
27.713 1
 
1.0%
27.726 1
 
1.0%
27.761 1
 
1.0%
ValueCountFrequency (%)
357.619 1
1.0%
351.562 1
1.0%
350.276 1
1.0%
288.432 1
1.0%
287.637 1
1.0%
287.056 1
1.0%
286.738 1
1.0%
286.695 1
1.0%
286.568 1
1.0%
286.5 1
1.0%

저수량(백만m3)
Real number (ℝ)

HIGH CORRELATION 

Distinct94
Distinct (%)94.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean51.68097
Minimum27.372
Maximum184.375
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:44:51.292423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum27.372
5-th percentile27.41295
Q127.719
median29.8705
Q390.54125
95-th percentile108.80265
Maximum184.375
Range157.003
Interquartile range (IQR)62.82225

Descriptive statistics

Standard deviation32.592545
Coefficient of variation (CV)0.63064887
Kurtosis1.283934
Mean51.68097
Median Absolute Deviation (MAD)2.488
Skewness1.2890362
Sum5168.097
Variance1062.274
MonotonicityNot monotonic
2023-12-10T19:44:51.566281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
27.472 6
 
6.0%
27.372 2
 
2.0%
70.068 1
 
1.0%
47.387 1
 
1.0%
90.756 1
 
1.0%
89.313 1
 
1.0%
94.617 1
 
1.0%
102.644 1
 
1.0%
47.019 1
 
1.0%
47.315 1
 
1.0%
Other values (84) 84
84.0%
ValueCountFrequency (%)
27.372 2
 
2.0%
27.382 1
 
1.0%
27.383 1
 
1.0%
27.412 1
 
1.0%
27.413 1
 
1.0%
27.472 6
6.0%
27.492 1
 
1.0%
27.495 1
 
1.0%
27.511 1
 
1.0%
27.515 1
 
1.0%
ValueCountFrequency (%)
184.375 1
1.0%
110.425 1
1.0%
110.115 1
1.0%
109.959 1
1.0%
109.176 1
1.0%
108.783 1
1.0%
108.753 1
1.0%
103.068 1
1.0%
102.644 1
1.0%
102.248 1
1.0%

저수율
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
0.94
55 
0.93
28 
0.95
15 
0.92
 
2

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0.94 55
55.0%
0.93 28
28.0%
0.95 15
 
15.0%
0.92 2
 
2.0%

Length

2023-12-10T19:44:51.845433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:44:52.023524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0.94 55
55.0%
0.93 28
28.0%
0.95 15
 
15.0%
0.92 2
 
2.0%

Interactions

2023-12-10T19:44:47.237813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:44:46.255190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:44:46.751273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:44:47.418359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:44:46.399096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:44:46.908289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:44:47.607347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:44:46.562413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:44:47.072615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T19:44:52.166462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일자/시간(t)강우량(mm)유입량(ms)방류량(ms)저수량(백만m3)저수율
일자/시간(t)1.0000.4220.4220.7690.6360.422
강우량(mm)0.4221.0001.0000.7070.6141.000
유입량(ms)0.4221.0001.0000.7070.6141.000
방류량(ms)0.7690.7070.7071.0000.8140.707
저수량(백만m3)0.6360.6140.6140.8141.0000.614
저수율0.4221.0001.0000.7070.6141.000
2023-12-10T19:44:52.366246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
저수율강우량(mm)유입량(ms)
저수율1.0001.0001.000
강우량(mm)1.0001.0001.000
유입량(ms)1.0001.0001.000
2023-12-10T19:44:52.553821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일자/시간(t)방류량(ms)저수량(백만m3)강우량(mm)유입량(ms)저수율
일자/시간(t)1.000-0.225-0.5240.4190.4190.419
방류량(ms)-0.2251.0000.2920.5320.5320.532
저수량(백만m3)-0.5240.2921.0000.4650.4650.465
강우량(mm)0.4190.5320.4651.0001.0001.000
유입량(ms)0.4190.5320.4651.0001.0001.000
저수율0.4190.5320.4651.0001.0001.000

Missing values

2023-12-10T19:44:47.838466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:44:48.070985image/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낙동강하굿둑2019020209500305.62599.554.42570.0680.94
1낙동강하굿둑2019020209400305.62599.547.846.6350.94
2낙동강하굿둑2019020209300305.62599.547.93447.9340.94
3낙동강하굿둑2019020209200305.62599.547.94150.1930.94
4낙동강하굿둑2019020209100305.62599.546.74547.0360.94
5낙동강하굿둑2019020209000305.62599.546.79246.7920.94
6낙동강하굿둑2019020208500305.62599.546.79946.6040.94
7낙동강하굿둑2019020208400305.62599.50.047.180.94
8낙동강하굿둑2019020208300305.62599.536.4536.450.94
9낙동강하굿둑2019020208200305.62599.530.23735.2650.94
댐이름일자/시간(t)저수위(m)강우량(mm)유입량(ms)방류량(ms)저수량(백만m3)저수율
90낙동강하굿둑2019020118500305.62599.50.0103.0680.94
91낙동강하굿둑2019020118400305.62599.50.092.9050.94
92낙동강하굿둑2019020118300306.09299.691.4791.7280.95
93낙동강하굿둑2019020118200306.09299.691.14591.360.95
94낙동강하굿둑2019020118100306.09299.690.88491.3240.95
95낙동강하굿둑2019020118000306.09299.690.79590.750.95
96낙동강하굿둑2019020117500306.09299.690.82190.5780.95
97낙동강하굿둑2019020117400306.09299.690.92491.0580.95
98낙동강하굿둑2019020117300306.09299.690.9890.980.95
99낙동강하굿둑2019020210000305.15999.30.0184.3750.93