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 4 other fieldsHigh correlation
강우량(mm) is highly overall correlated with 일자/시간(t) and 4 other fieldsHigh correlation
방류량(ms) is highly overall correlated with 일자/시간(t) and 4 other fieldsHigh correlation
저수량(백만m3) is highly overall correlated with 일자/시간(t) and 4 other fieldsHigh correlation
저수율 is highly overall correlated with 일자/시간(t) and 4 other fieldsHigh correlation
유입량(ms) is highly overall correlated with 일자/시간(t) and 4 other fieldsHigh correlation
일자/시간(t) has unique valuesUnique

Reproduction

Analysis started2023-12-10 13:16:14.308348
Analysis finished2023-12-10 13:16:19.109500
Duration4.8 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:16:19.195008image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:16:19.336727image/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.0190102 × 1011
Minimum2.0190101 × 1011
Maximum2.0190102 × 1011
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:16:19.530283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0190101 × 1011
5-th percentile2.0190101 × 1011
Q12.0190101 × 1011
median2.0190102 × 1011
Q32.0190102 × 1011
95-th percentile2.0190102 × 1011
Maximum2.0190102 × 1011
Range9700
Interquartile range (IQR)8415

Descriptive statistics

Standard deviation4296.4393
Coefficient of variation (CV)2.1279929 × 10-8
Kurtosis-2.0114511
Mean2.0190102 × 1011
Median Absolute Deviation (MAD)1010
Skewness-0.078973605
Sum2.0190102 × 1013
Variance18459391
MonotonicityNot monotonic
2023-12-10T22:16:19.767371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
201901012000 1
 
1.0%
201901020550 1
 
1.0%
201901020240 1
 
1.0%
201901020310 1
 
1.0%
201901020320 1
 
1.0%
201901020340 1
 
1.0%
201901020350 1
 
1.0%
201901020430 1
 
1.0%
201901020440 1
 
1.0%
201901020500 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
201901011350 1
1.0%
201901011400 1
1.0%
201901011410 1
1.0%
201901011420 1
1.0%
201901011430 1
1.0%
201901011450 1
1.0%
201901011500 1
1.0%
201901011510 1
1.0%
201901011520 1
1.0%
201901011740 1
1.0%
ValueCountFrequency (%)
201901021050 1
1.0%
201901021040 1
1.0%
201901021030 1
1.0%
201901021020 1
1.0%
201901021010 1
1.0%
201901021000 1
1.0%
201901020950 1
1.0%
201901020940 1
1.0%
201901020930 1
1.0%
201901020920 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:16:19.985467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

강우량(mm)
Real number (ℝ)

HIGH CORRELATION 

Distinct8
Distinct (%)8.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.62414
Minimum3.57
Maximum3.66
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:16:20.250269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3.57
5-th percentile3.582
Q13.61775
median3.634
Q33.634
95-th percentile3.66
Maximum3.66
Range0.09
Interquartile range (IQR)0.01625

Descriptive statistics

Standard deviation0.022740974
Coefficient of variation (CV)0.0062748609
Kurtosis-0.19264721
Mean3.62414
Median Absolute Deviation (MAD)0
Skewness-0.81580313
Sum362.414
Variance0.00051715192
MonotonicityNot monotonic
2023-12-10T22:16:20.415111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
3.634 53
53.0%
3.582 11
 
11.0%
3.621 9
 
9.0%
3.595 9
 
9.0%
3.66 7
 
7.0%
3.647 6
 
6.0%
3.608 3
 
3.0%
3.57 2
 
2.0%
ValueCountFrequency (%)
3.57 2
 
2.0%
3.582 11
 
11.0%
3.595 9
 
9.0%
3.608 3
 
3.0%
3.621 9
 
9.0%
3.634 53
53.0%
3.647 6
 
6.0%
3.66 7
 
7.0%
ValueCountFrequency (%)
3.66 7
 
7.0%
3.647 6
 
6.0%
3.634 53
53.0%
3.621 9
 
9.0%
3.608 3
 
3.0%
3.595 9
 
9.0%
3.582 11
 
11.0%
3.57 2
 
2.0%

유입량(ms)
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
5.1
75 
5.0
25 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
5.1 75
75.0%
5.0 25
 
25.0%

Length

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

Common Values (Plot)

2023-12-10T22:16:20.765471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
5.1 75
75.0%
5.0 25
 
25.0%

방류량(ms)
Real number (ℝ)

HIGH CORRELATION 

Distinct21
Distinct (%)21.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.51864
Minimum3.778
Maximum33.562
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:16:20.972533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3.778
5-th percentile10.78445
Q118.88925
median27
Q327
95-th percentile27
Maximum33.562
Range29.784
Interquartile range (IQR)8.11075

Descriptive statistics

Standard deviation7.3867876
Coefficient of variation (CV)0.32802992
Kurtosis-0.13937609
Mean22.51864
Median Absolute Deviation (MAD)0
Skewness-1.1459927
Sum2251.864
Variance54.564631
MonotonicityNot monotonic
2023-12-10T22:16:21.190581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
27.0 61
61.0%
11.0 11
 
11.0%
12.556 5
 
5.0%
3.778 3
 
3.0%
12.411 3
 
3.0%
6.689 2
 
2.0%
25.37 1
 
1.0%
26.37 1
 
1.0%
20.4 1
 
1.0%
29.162 1
 
1.0%
Other values (11) 11
 
11.0%
ValueCountFrequency (%)
3.778 3
 
3.0%
6.689 2
 
2.0%
11.0 11
11.0%
12.411 3
 
3.0%
12.556 5
5.0%
16.703 1
 
1.0%
19.618 1
 
1.0%
19.684 1
 
1.0%
19.751 1
 
1.0%
20.4 1
 
1.0%
ValueCountFrequency (%)
33.562 1
 
1.0%
31.362 1
 
1.0%
29.162 1
 
1.0%
27.0 61
61.0%
26.78 1
 
1.0%
26.37 1
 
1.0%
25.37 1
 
1.0%
25.24 1
 
1.0%
23.04 1
 
1.0%
21.06 1
 
1.0%

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

HIGH CORRELATION 

Distinct10
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.9343
Minimum11
Maximum27
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:16:21.368023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum11
5-th percentile11
Q126.685
median27
Q327
95-th percentile27
Maximum27
Range16
Interquartile range (IQR)0.315

Descriptive statistics

Standard deviation5.9455513
Coefficient of variation (CV)0.24841133
Kurtosis0.69484592
Mean23.9343
Median Absolute Deviation (MAD)0
Skewness-1.5910418
Sum2393.43
Variance35.34958
MonotonicityNot monotonic
2023-12-10T22:16:21.533130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
27.0 69
69.0%
11.0 14
 
14.0%
26.8 5
 
5.0%
13.8 4
 
4.0%
20.4 3
 
3.0%
26.34 1
 
1.0%
25.24 1
 
1.0%
22.51 1
 
1.0%
26.92 1
 
1.0%
25.02 1
 
1.0%
ValueCountFrequency (%)
11.0 14
 
14.0%
13.8 4
 
4.0%
20.4 3
 
3.0%
22.51 1
 
1.0%
25.02 1
 
1.0%
25.24 1
 
1.0%
26.34 1
 
1.0%
26.8 5
 
5.0%
26.92 1
 
1.0%
27.0 69
69.0%
ValueCountFrequency (%)
27.0 69
69.0%
26.92 1
 
1.0%
26.8 5
 
5.0%
26.34 1
 
1.0%
25.24 1
 
1.0%
25.02 1
 
1.0%
22.51 1
 
1.0%
20.4 3
 
3.0%
13.8 4
 
4.0%
11.0 14
 
14.0%

저수율
Real number (ℝ)

HIGH CORRELATION 

Distinct8
Distinct (%)8.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25.7324
Minimum25.69
Maximum25.76
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:16:21.726711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum25.69
5-th percentile25.7
Q125.7275
median25.74
Q325.74
95-th percentile25.76
Maximum25.76
Range0.07
Interquartile range (IQR)0.0125

Descriptive statistics

Standard deviation0.017530349
Coefficient of variation (CV)0.00068125588
Kurtosis-0.16833448
Mean25.7324
Median Absolute Deviation (MAD)0
Skewness-0.82352129
Sum2573.24
Variance0.00030731313
MonotonicityNot monotonic
2023-12-10T22:16:22.030754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
25.74 53
53.0%
25.7 11
 
11.0%
25.73 9
 
9.0%
25.71 9
 
9.0%
25.76 7
 
7.0%
25.75 6
 
6.0%
25.72 3
 
3.0%
25.69 2
 
2.0%
ValueCountFrequency (%)
25.69 2
 
2.0%
25.7 11
 
11.0%
25.71 9
 
9.0%
25.72 3
 
3.0%
25.73 9
 
9.0%
25.74 53
53.0%
25.75 6
 
6.0%
25.76 7
 
7.0%
ValueCountFrequency (%)
25.76 7
 
7.0%
25.75 6
 
6.0%
25.74 53
53.0%
25.73 9
 
9.0%
25.72 3
 
3.0%
25.71 9
 
9.0%
25.7 11
 
11.0%
25.69 2
 
2.0%

Interactions

2023-12-10T22:16:17.764565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:14.655235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:15.379053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:16.167002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:16.944891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:17.900782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:14.791503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:15.509171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:16.301657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:17.087078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:18.024785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:14.927355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:15.653126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:16.474801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:17.231709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:18.472769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:15.060784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:15.794008image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:16.613256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:17.378214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:18.616122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:15.217668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:15.974376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:16.762910image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:16:17.608855image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T22:16:22.176862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일자/시간(t)강우량(mm)유입량(ms)방류량(ms)저수량(백만m3)저수율
일자/시간(t)1.0000.7850.8030.6160.3980.785
강우량(mm)0.7851.0001.0000.8950.7201.000
유입량(ms)0.8031.0001.0000.9530.9641.000
방류량(ms)0.6160.8950.9531.0000.7960.895
저수량(백만m3)0.3980.7200.9640.7961.0000.720
저수율0.7851.0001.0000.8950.7201.000
2023-12-10T22:16:22.352444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일자/시간(t)강우량(mm)방류량(ms)저수량(백만m3)저수율유입량(ms)
일자/시간(t)1.000-0.787-0.652-0.760-0.7870.591
강우량(mm)-0.7871.0000.7730.7051.0000.969
방류량(ms)-0.6520.7731.0000.8330.7730.784
저수량(백만m3)-0.7600.7050.8331.0000.7050.813
저수율-0.7871.0000.7730.7051.0000.969
유입량(ms)0.5910.9690.7840.8130.9691.000

Missing values

2023-12-10T22:16:18.805096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T22:16:18.982845image/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군남20190101200003.6345.127.027.025.74
1군남20190101141003.665.127.027.025.76
2군남20190102012003.6345.126.7826.3425.74
3군남20190101201003.6345.127.027.025.74
4군남20190102101003.5825.03.77811.025.7
5군남20190101142003.665.127.027.025.76
6군남20190102040003.6215.127.027.025.73
7군남20190102013003.6345.125.2425.2425.74
8군남20190101225003.6345.127.027.025.74
9군남20190101202003.6345.127.027.025.74
댐이름일자/시간(t)저수위(m)강우량(mm)유입량(ms)방류량(ms)저수량(백만m3)저수율
90군남20190101213003.6345.127.027.025.74
91군남20190101212003.6345.127.027.025.74
92군남20190101210003.6345.127.027.025.74
93군남20190101205003.6345.127.027.025.74
94군남20190101195003.6345.127.027.025.74
95군남20190101194003.6345.127.027.025.74
96군남20190101192003.6345.127.027.025.74
97군남20190101191003.6345.127.027.025.74
98군남20190101135003.665.126.3727.025.76
99군남20190101140003.665.127.027.025.76