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

Reproduction

Analysis started2023-12-10 10:28:28.933660
Analysis finished2023-12-10 10:28:34.633334
Duration5.7 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-10T19:28:34.790357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

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

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0200127 × 109
Minimum2.0200123 × 109
Maximum2.0200131 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:28:35.208750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0200123 × 109
5-th percentile2.0200124 × 109
Q12.0200125 × 109
median2.0200127 × 109
Q32.0200129 × 109
95-th percentile2.0200131 × 109
Maximum2.0200131 × 109
Range806
Interquartile range (IQR)403

Descriptive statistics

Standard deviation241.9365
Coefficient of variation (CV)1.1976979 × 10-7
Kurtosis-1.1923273
Mean2.0200127 × 109
Median Absolute Deviation (MAD)202
Skewness-0.027309609
Sum2.0200127 × 1011
Variance58533.27
MonotonicityNot monotonic
2023-12-10T19:28:35.480381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2020012620 1
 
1.0%
2020013118 1
 
1.0%
2020013004 1
 
1.0%
2020013010 1
 
1.0%
2020013012 1
 
1.0%
2020013016 1
 
1.0%
2020013018 1
 
1.0%
2020013102 1
 
1.0%
2020013104 1
 
1.0%
2020013108 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
2020012318 1
1.0%
2020012320 1
1.0%
2020012322 1
1.0%
2020012324 1
1.0%
2020012402 1
1.0%
2020012404 1
1.0%
2020012406 1
1.0%
2020012408 1
1.0%
2020012410 1
1.0%
2020012412 1
1.0%
ValueCountFrequency (%)
2020013124 1
1.0%
2020013122 1
1.0%
2020013120 1
1.0%
2020013118 1
1.0%
2020013116 1
1.0%
2020013114 1
1.0%
2020013112 1
1.0%
2020013110 1
1.0%
2020013108 1
1.0%
2020013106 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:28:35.808043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

강우량(mm)
Real number (ℝ)

HIGH CORRELATION 

Distinct18
Distinct (%)18.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.78296
Minimum3.647
Maximum3.913
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:28:36.152846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3.647
5-th percentile3.7
Q13.752
median3.772
Q33.805
95-th percentile3.913
Maximum3.913
Range0.266
Interquartile range (IQR)0.053

Descriptive statistics

Standard deviation0.055199349
Coefficient of variation (CV)0.014591576
Kurtosis0.57097365
Mean3.78296
Median Absolute Deviation (MAD)0.033
Skewness0.53600138
Sum378.296
Variance0.0030469681
MonotonicityNot monotonic
2023-12-10T19:28:36.434652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
3.765 16
16.0%
3.805 13
13.0%
3.752 13
13.0%
3.792 12
12.0%
3.913 7
7.0%
3.726 7
7.0%
3.739 6
 
6.0%
3.819 5
 
5.0%
3.832 4
 
4.0%
3.779 3
 
3.0%
Other values (8) 14
14.0%
ValueCountFrequency (%)
3.647 1
 
1.0%
3.673 1
 
1.0%
3.686 2
 
2.0%
3.7 3
 
3.0%
3.713 1
 
1.0%
3.726 7
7.0%
3.739 6
 
6.0%
3.752 13
13.0%
3.765 16
16.0%
3.779 3
 
3.0%
ValueCountFrequency (%)
3.913 7
7.0%
3.872 1
 
1.0%
3.859 3
 
3.0%
3.845 2
 
2.0%
3.832 4
 
4.0%
3.819 5
 
5.0%
3.805 13
13.0%
3.792 12
12.0%
3.779 3
 
3.0%
3.765 16
16.0%

유입량(ms)
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)5.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
5.3
49 
5.2
32 
5.4
10 
5.5
7 
5.1
 
2

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
5.3 49
49.0%
5.2 32
32.0%
5.4 10
 
10.0%
5.5 7
 
7.0%
5.1 2
 
2.0%

Length

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

Common Values (Plot)

2023-12-10T19:28:36.936703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
5.3 49
49.0%
5.2 32
32.0%
5.4 10
 
10.0%
5.5 7
 
7.0%
5.1 2
 
2.0%

방류량(ms)
Real number (ℝ)

HIGH CORRELATION 

Distinct53
Distinct (%)53.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.54637
Minimum8.296
Maximum34.183
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:28:37.199503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum8.296
5-th percentile11.2
Q114.2
median15.661
Q322.4835
95-th percentile30.22145
Maximum34.183
Range25.887
Interquartile range (IQR)8.2835

Descriptive statistics

Standard deviation6.0251793
Coefficient of variation (CV)0.32487108
Kurtosis-0.55107367
Mean18.54637
Median Absolute Deviation (MAD)3.321
Skewness0.74187277
Sum1854.637
Variance36.302786
MonotonicityNot monotonic
2023-12-10T19:28:37.466514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
14.2 32
32.0%
28.0 6
 
6.0%
20.8 4
 
4.0%
19.6 3
 
3.0%
13.583 2
 
2.0%
11.2 2
 
2.0%
30.306 2
 
2.0%
10.533 2
 
2.0%
14.867 2
 
2.0%
17.106 2
 
2.0%
Other values (43) 43
43.0%
ValueCountFrequency (%)
8.296 1
 
1.0%
9.772 1
 
1.0%
10.533 2
 
2.0%
11.2 2
 
2.0%
11.959 1
 
1.0%
12.141 1
 
1.0%
12.147 1
 
1.0%
13.583 2
 
2.0%
14.113 1
 
1.0%
14.2 32
32.0%
ValueCountFrequency (%)
34.183 1
 
1.0%
30.506 1
 
1.0%
30.409 1
 
1.0%
30.306 2
 
2.0%
30.217 1
 
1.0%
30.089 1
 
1.0%
29.334 1
 
1.0%
28.161 1
 
1.0%
28.0 6
6.0%
26.989 1
 
1.0%

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

HIGH CORRELATION 

Distinct36
Distinct (%)36.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.50772
Minimum11.2
Maximum34.2
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:28:37.818857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum11.2
5-th percentile11.33965
Q114.2
median16.785
Q320.85
95-th percentile33.81665
Maximum34.2
Range23
Interquartile range (IQR)6.65

Descriptive statistics

Standard deviation5.9684289
Coefficient of variation (CV)0.32248321
Kurtosis0.70947668
Mean18.50772
Median Absolute Deviation (MAD)2.755
Skewness1.126913
Sum1850.772
Variance35.622144
MonotonicityNot monotonic
2023-12-10T19:28:38.236184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
14.2 35
35.0%
20.8 8
 
8.0%
28.0 7
 
7.0%
19.6 6
 
6.0%
11.2 5
 
5.0%
21.0 4
 
4.0%
19.2 2
 
2.0%
34.0 2
 
2.0%
19.8 2
 
2.0%
11.4 2
 
2.0%
Other values (26) 27
27.0%
ValueCountFrequency (%)
11.2 5
 
5.0%
11.347 1
 
1.0%
11.4 2
 
2.0%
11.935 1
 
1.0%
14.2 35
35.0%
14.29 1
 
1.0%
14.36 1
 
1.0%
14.662 1
 
1.0%
15.217 1
 
1.0%
15.808 1
 
1.0%
ValueCountFrequency (%)
34.2 1
 
1.0%
34.183 1
 
1.0%
34.103 1
 
1.0%
34.0 2
 
2.0%
33.807 1
 
1.0%
28.0 7
7.0%
25.098 1
 
1.0%
24.6 1
 
1.0%
23.8 1
 
1.0%
23.6 1
 
1.0%

저수율
Real number (ℝ)

HIGH CORRELATION 

Distinct18
Distinct (%)18.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25.8531
Minimum25.75
Maximum25.95
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:28:38.556694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum25.75
5-th percentile25.79
Q125.83
median25.845
Q325.87
95-th percentile25.95
Maximum25.95
Range0.2
Interquartile range (IQR)0.04

Descriptive statistics

Standard deviation0.041431335
Coefficient of variation (CV)0.0016025674
Kurtosis0.54281423
Mean25.8531
Median Absolute Deviation (MAD)0.025
Skewness0.50197049
Sum2585.31
Variance0.0017165556
MonotonicityNot monotonic
2023-12-10T19:28:38.751210image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
25.84 16
16.0%
25.87 13
13.0%
25.83 13
13.0%
25.86 12
12.0%
25.95 7
7.0%
25.81 7
7.0%
25.82 6
 
6.0%
25.88 5
 
5.0%
25.89 4
 
4.0%
25.85 3
 
3.0%
Other values (8) 14
14.0%
ValueCountFrequency (%)
25.75 1
 
1.0%
25.77 1
 
1.0%
25.78 2
 
2.0%
25.79 3
 
3.0%
25.8 1
 
1.0%
25.81 7
7.0%
25.82 6
 
6.0%
25.83 13
13.0%
25.84 16
16.0%
25.85 3
 
3.0%
ValueCountFrequency (%)
25.95 7
7.0%
25.92 1
 
1.0%
25.91 3
 
3.0%
25.9 2
 
2.0%
25.89 4
 
4.0%
25.88 5
 
5.0%
25.87 13
13.0%
25.86 12
12.0%
25.85 3
 
3.0%
25.84 16
16.0%

Interactions

2023-12-10T19:28:33.082790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:29.668641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:30.506191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:31.290256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:32.363651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:33.291590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:29.865157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:30.692168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:31.522976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:32.518438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:33.457592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:30.036892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:30.826239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:31.784383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:32.644262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:33.637402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:30.189753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:30.966263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:32.017481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:32.786227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:33.849875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:30.326528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:31.085337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:32.203436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:28:32.908663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T19:28:38.936512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일자/시간(t)강우량(mm)유입량(ms)방류량(ms)저수량(백만m3)저수율
일자/시간(t)1.0000.8870.8790.6460.6710.851
강우량(mm)0.8871.0000.9990.7660.6760.971
유입량(ms)0.8790.9991.0000.8230.6500.995
방류량(ms)0.6460.7660.8231.0000.7420.783
저수량(백만m3)0.6710.6760.6500.7421.0000.656
저수율0.8510.9710.9950.7830.6561.000
2023-12-10T19:28:39.154454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일자/시간(t)강우량(mm)방류량(ms)저수량(백만m3)저수율유입량(ms)
일자/시간(t)1.0000.021-0.308-0.1890.0210.496
강우량(mm)0.0211.0000.4390.4211.0000.937
방류량(ms)-0.3080.4391.0000.6730.4390.469
저수량(백만m3)-0.1890.4210.6731.0000.4210.438
저수율0.0211.0000.4390.4211.0000.937
유입량(ms)0.4960.9370.4690.4380.9371.000

Missing values

2023-12-10T19:28:34.138026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:28:34.504828image/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군남202001262003.8195.330.50634.225.88
1군남202001232203.6735.111.95919.23725.77
2군남202001291203.7395.212.14719.4825.82
3군남202001262203.7925.330.40934.10325.86
4군남202001250603.8195.322.422.425.88
5군남202001232403.6475.115.58919.225.75
6군남202001302003.7655.314.214.225.84
7군남202001291403.7395.214.214.225.82
8군남202001280603.8055.319.619.625.87
9군남202001262403.7795.330.30634.025.85
댐이름일자/시간(t)저수위(m)강우량(mm)유입량(ms)방류량(ms)저수량(백만m3)저수율
90군남202001271403.7525.218.6811.34725.83
91군남202001271203.7265.214.86711.225.81
92군남202001270803.7265.220.820.825.81
93군남202001270603.7265.220.820.825.81
94군남202001261803.8325.434.18334.18325.89
95군남202001261603.8055.323.29419.625.87
96군남202001261203.8055.315.87819.625.87
97군남202001261003.8455.416.07819.825.9
98군남202001231803.7655.320.9117.24325.84
99군남202001232003.7395.215.73319.425.82