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

강우량(mm) has constant value ""Constant
저수위(m) is highly overall correlated with 댐이름High correlation
유입량(ms) is highly overall correlated with 방류량(ms) and 3 other fieldsHigh correlation
방류량(ms) is highly overall correlated with 유입량(ms) and 2 other fieldsHigh correlation
저수량(백만m3) is highly overall correlated with 유입량(ms) and 2 other fieldsHigh correlation
저수율 is highly overall correlated with 유입량(ms) and 3 other fieldsHigh correlation
댐이름 is highly overall correlated with 저수위(m) and 4 other fieldsHigh correlation
유입량(ms) has 17 (17.0%) zerosZeros
방류량(ms) has 17 (17.0%) zerosZeros
저수량(백만m3) has 17 (17.0%) zerosZeros
저수율 has 21 (21.0%) zerosZeros

Reproduction

Analysis started2023-12-10 12:50:17.520470
Analysis finished2023-12-10 12:50:20.834368
Duration3.31 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일자/시간(t)
Categorical

Distinct5
Distinct (%)5.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2022080101
23 
2022080102
23 
2022080103
23 
2022080104
23 
2022080105
8 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2022080101 23
23.0%
2022080102 23
23.0%
2022080103 23
23.0%
2022080104 23
23.0%
2022080105 8
 
8.0%

Length

2023-12-10T21:50:20.917818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T21:50:21.018984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022080101 23
23.0%
2022080102 23
23.0%
2022080103 23
23.0%
2022080104 23
23.0%
2022080105 8
 
8.0%

저수위(m)
Real number (ℝ)

HIGH CORRELATION 

Distinct78
Distinct (%)78.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean38.670057
Minimum1.452
Maximum156.77
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T21:50:21.153205image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.452
5-th percentile2.9638
Q15.567
median28.315
Q350.525825
95-th percentile136.12745
Maximum156.77
Range155.318
Interquartile range (IQR)44.958825

Descriptive statistics

Standard deviation41.53452
Coefficient of variation (CV)1.0740744
Kurtosis1.9400818
Mean38.670057
Median Absolute Deviation (MAD)22.4
Skewness1.5890286
Sum3867.0057
Variance1725.1164
MonotonicityNot monotonic
2023-12-10T21:50:21.293404image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
60.4 5
 
5.0%
156.77 5
 
5.0%
77.57 4
 
4.0%
47.15 4
 
4.0%
39.83 2
 
2.0%
32.61 2
 
2.0%
8.69 2
 
2.0%
13.79 2
 
2.0%
38.33 2
 
2.0%
135.024 2
 
2.0%
Other values (68) 70
70.0%
ValueCountFrequency (%)
1.452 1
1.0%
1.484 1
1.0%
1.51 1
1.0%
1.512 1
1.0%
2.96 1
1.0%
2.964 1
1.0%
2.98 2
2.0%
3.74 1
1.0%
3.76 1
1.0%
3.776 1
1.0%
ValueCountFrequency (%)
156.77 5
5.0%
135.041 1
 
1.0%
135.026 1
 
1.0%
135.024 2
 
2.0%
85.5127 1
 
1.0%
85.5084 1
 
1.0%
85.3889 1
 
1.0%
85.1427 1
 
1.0%
77.57 4
4.0%
60.4 5
5.0%

강우량(mm)
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-10T21:50:21.427869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

유입량(ms)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct81
Distinct (%)81.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean80.718338
Minimum0
Maximum241.447
Zeros17
Zeros (%)17.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T21:50:21.633459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q115.785
median68.8775
Q398.812
95-th percentile227.59805
Maximum241.447
Range241.447
Interquartile range (IQR)83.027

Descriptive statistics

Standard deviation72.383304
Coefficient of variation (CV)0.89673928
Kurtosis-0.15328786
Mean80.718338
Median Absolute Deviation (MAD)38.34765
Skewness0.87588997
Sum8071.8338
Variance5239.3427
MonotonicityNot monotonic
2023-12-10T21:50:21.779651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 17
 
17.0%
5.73 4
 
4.0%
80.32 1
 
1.0%
227.392 1
 
1.0%
203.501 1
 
1.0%
27.608 1
 
1.0%
57.383 1
 
1.0%
74.212 1
 
1.0%
212.0752 1
 
1.0%
107.0553 1
 
1.0%
Other values (71) 71
71.0%
ValueCountFrequency (%)
0.0 17
17.0%
0.33 1
 
1.0%
3.969 1
 
1.0%
5.73 4
 
4.0%
6.097 1
 
1.0%
15.734 1
 
1.0%
15.802 1
 
1.0%
21.368 1
 
1.0%
23.941 1
 
1.0%
26.4211 1
 
1.0%
ValueCountFrequency (%)
241.447 1
1.0%
234.063 1
1.0%
233.155 1
1.0%
232.487 1
1.0%
231.513 1
1.0%
227.392 1
1.0%
226.986 1
1.0%
222.25 1
1.0%
222.049 1
1.0%
218.425 1
1.0%

방류량(ms)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct78
Distinct (%)78.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.85946
Minimum0
Maximum231.513
Zeros17
Zeros (%)17.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T21:50:21.971081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q16.00525
median64.9705
Q390.94425
95-th percentile215.23115
Maximum231.513
Range231.513
Interquartile range (IQR)84.939

Descriptive statistics

Standard deviation68.538835
Coefficient of variation (CV)0.91556679
Kurtosis-0.10367741
Mean74.85946
Median Absolute Deviation (MAD)46.339
Skewness0.89315658
Sum7485.946
Variance4697.572
MonotonicityNot monotonic
2023-12-10T21:50:22.168435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 17
 
17.0%
5.73 4
 
4.0%
0.33 4
 
4.0%
78.848 1
 
1.0%
6.097 1
 
1.0%
63.92 1
 
1.0%
152.334 1
 
1.0%
54.189 1
 
1.0%
74.212 1
 
1.0%
143.853 1
 
1.0%
Other values (68) 68
68.0%
ValueCountFrequency (%)
0.0 17
17.0%
0.33 4
 
4.0%
5.73 4
 
4.0%
6.097 1
 
1.0%
18.512 1
 
1.0%
18.58 1
 
1.0%
18.591 1
 
1.0%
18.672 1
 
1.0%
25.113 1
 
1.0%
49.45 1
 
1.0%
ValueCountFrequency (%)
231.513 1
1.0%
231.391 1
1.0%
224.458 1
1.0%
220.599 1
1.0%
220.098 1
1.0%
214.975 1
1.0%
210.25 1
1.0%
209.66 1
1.0%
208.896 1
1.0%
206.036 1
1.0%

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

HIGH CORRELATION  ZEROS 

Distinct69
Distinct (%)69.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24.788552
Minimum0
Maximum80.7126
Zeros17
Zeros (%)17.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T21:50:22.342400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11.432
median14.18805
Q350.754975
95-th percentile77.144765
Maximum80.7126
Range80.7126
Interquartile range (IQR)49.322975

Descriptive statistics

Standard deviation27.100001
Coefficient of variation (CV)1.0932467
Kurtosis-0.69715508
Mean24.788552
Median Absolute Deviation (MAD)14.0167
Skewness0.86137517
Sum2478.8552
Variance734.41008
MonotonicityNot monotonic
2023-12-10T21:50:22.509482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 17
 
17.0%
3.8755 5
 
5.0%
28.0334 4
 
4.0%
56.3399 2
 
2.0%
33.6796 2
 
2.0%
53.4493 2
 
2.0%
50.2336 2
 
2.0%
10.2216 2
 
2.0%
76.135 2
 
2.0%
52.3191 2
 
2.0%
Other values (59) 60
60.0%
ValueCountFrequency (%)
0.0 17
17.0%
0.9929 1
 
1.0%
0.9964 1
 
1.0%
0.9994 1
 
1.0%
1.0017 1
 
1.0%
1.0035 1
 
1.0%
1.389 1
 
1.0%
1.394 1
 
1.0%
1.399 1
 
1.0%
1.443 1
 
1.0%
ValueCountFrequency (%)
80.7126 1
1.0%
80.5284 1
1.0%
80.4823 1
1.0%
80.4363 1
1.0%
77.1726 1
1.0%
77.1433 1
1.0%
77.0261 1
1.0%
76.8795 1
1.0%
76.2375 1
1.0%
76.135 2
2.0%

저수율
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct57
Distinct (%)57.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean64.627
Minimum0
Maximum145.6
Zeros21
Zeros (%)21.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T21:50:22.658260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q110.725
median79.75
Q3102.2
95-th percentile117.1
Maximum145.6
Range145.6
Interquartile range (IQR)91.475

Descriptive statistics

Standard deviation47.218105
Coefficient of variation (CV)0.73062505
Kurtosis-1.42518
Mean64.627
Median Absolute Deviation (MAD)30.1
Skewness-0.28833466
Sum6462.7
Variance2229.5495
MonotonicityNot monotonic
2023-12-10T21:50:22.812817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 21
 
21.0%
102.2 6
 
6.0%
102.3 4
 
4.0%
101.1 3
 
3.0%
2.4 3
 
3.0%
17.6 2
 
2.0%
117.1 2
 
2.0%
17.7 2
 
2.0%
65.8 2
 
2.0%
97.1 2
 
2.0%
Other values (47) 53
53.0%
ValueCountFrequency (%)
0.0 21
21.0%
2.3 1
 
1.0%
2.4 3
 
3.0%
13.5 1
 
1.0%
13.6 2
 
2.0%
13.7 1
 
1.0%
13.8 1
 
1.0%
17.6 2
 
2.0%
17.7 2
 
2.0%
17.8 1
 
1.0%
ValueCountFrequency (%)
145.6 1
1.0%
145.3 1
1.0%
145.2 2
2.0%
117.1 2
2.0%
116.7 1
1.0%
116.6 1
1.0%
116.1 1
1.0%
112.7 1
1.0%
112.3 1
1.0%
111.9 1
1.0%

댐이름
Categorical

HIGH CORRELATION 

Distinct23
Distinct (%)23.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
세종보
 
5
상주보
 
5
영주유사조절지
 
5
달성보
 
5
구담보
 
5
Other values (18)
75 

Length

Max length7
Median length3
Mean length3.52
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row세종보
2nd row승촌보
3rd row귤현보
4th row상주보
5th row여주보

Common Values

ValueCountFrequency (%)
세종보 5
 
5.0%
상주보 5
 
5.0%
영주유사조절지 5
 
5.0%
달성보 5
 
5.0%
구담보 5
 
5.0%
승촌보 5
 
5.0%
공주보 5
 
5.0%
강천보 5
 
5.0%
죽산보 4
 
4.0%
귤현보 4
 
4.0%
Other values (13) 52
52.0%

Length

2023-12-10T21:50:22.978309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
세종보 5
 
5.0%
영주유사조절지 5
 
5.0%
달성보 5
 
5.0%
구담보 5
 
5.0%
승촌보 5
 
5.0%
공주보 5
 
5.0%
강천보 5
 
5.0%
상주보 5
 
5.0%
백제보 4
 
4.0%
합천창녕보 4
 
4.0%
Other values (13) 52
52.0%

Interactions

2023-12-10T21:50:19.779371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:17.804269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:18.320185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:18.782994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:19.237713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:20.152681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:17.896798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:18.408620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:18.891803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:19.356488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:20.243916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:18.006145image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:18.484743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:18.987922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:19.452183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:20.333263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:18.109493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:18.573538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:19.066923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:19.538865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:20.445294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:18.226178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:18.680368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:19.154283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:50:19.650707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T21:50:23.085286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일자/시간(t)저수위(m)유입량(ms)방류량(ms)저수량(백만m3)저수율댐이름
일자/시간(t)1.0000.0000.0000.0000.0000.0000.000
저수위(m)0.0001.0000.5670.5440.6540.9101.000
유입량(ms)0.0000.5671.0000.9310.7140.6820.898
방류량(ms)0.0000.5440.9311.0000.6760.7400.909
저수량(백만m3)0.0000.6540.7140.6761.0000.7800.992
저수율0.0000.9100.6820.7400.7801.0000.996
댐이름0.0001.0000.8980.9090.9920.9961.000
2023-12-10T21:50:23.206945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
댐이름일자/시간(t)
댐이름1.0000.000
일자/시간(t)0.0001.000
2023-12-10T21:50:23.287181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
저수위(m)유입량(ms)방류량(ms)저수량(백만m3)저수율일자/시간(t)댐이름
저수위(m)1.000-0.414-0.421-0.2820.2410.0000.915
유입량(ms)-0.4141.0000.9140.5150.5670.0000.580
방류량(ms)-0.4210.9141.0000.4380.5380.0000.605
저수량(백만m3)-0.2820.5150.4381.0000.5840.0000.881
저수율0.2410.5670.5380.5841.0000.0000.894
일자/시간(t)0.0000.0000.0000.0000.0001.0000.000
댐이름0.9150.5800.6050.8810.8940.0001.000

Missing values

2023-12-10T21:50:20.659552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T21:50:20.788270image/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)저수율댐이름
020220801018.744080.3278.8480.992917.6세종보
120220801015.576057.140825.1136.230269.5승촌보
220220801014.54021.36818.5911.3990.0귤현보
3202208010147.14066.30366.30327.9912102.2상주보
4202208010133.30202.377190.37712.5652111.5여주보
52022080101156.7705.735.733.8755102.2영주유사조절지
62022080101135.024023.9410.3352.3191145.2단양수중보
7202208010113.772091.95156.5956.148995.9달성보
8202208010118.52057.42257.42276.879583.3강정고령보
920220801014.052087.436151.3880.436379.7창녕함안보
일자/시간(t)저수위(m)강우량(mm)유입량(ms)방류량(ms)저수량(백만m3)저수율댐이름
90202208010439.83085.28485.28433.679697.1낙단보
91202208010477.5700.00.00.00.0수하보
9220220801055.43067.582771.6666.014467.0승촌보
93202208010538.330231.513231.51310.2216117.1강천보
94202208010547.15067.667.628.0334102.3상주보
95202208010513.8093.71264.2456.44696.4달성보
96202208010560.400.00.00.00.0구담보
972022080105156.7705.735.733.8755102.2영주유사조절지
9820220801053.822068.42165.4772.139413.8공주보
9920220801058.8520105.82105.321.003517.8세종보