gimi9 Pandas Profiling

Dataset statistics

Number of variables	8
Number of observations	100
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	7.1 KiB
Average record size in memory	72.3 B

Variable types

Categorical	1
Numeric	7

Dataset

Description	샘플 데이터
Author	한국수자원공사
URL	https://www.bigdata-environment.kr/user/data_market/detail.do?id=b503b3e0-38bb-11ea-be28-4fa0eb812a46

Alerts

`저수위(m)` is highly overall correlated with `유입량(ms)` and 2 other fields	High correlation
`강우량(mm)` is highly overall correlated with `유입량(ms)` and 3 other fields	High correlation
`유입량(ms)` is highly overall correlated with `저수위(m)` and 4 other fields	High correlation
`방류량(ms)` is highly overall correlated with `저수위(m)` and 4 other fields	High correlation
`저수량(백만m3)` is highly overall correlated with `강우량(mm)` and 4 other fields	High correlation
`저수율` is highly overall correlated with `강우량(mm)` and 4 other fields	High correlation
`댐이름` is highly overall correlated with `저수위(m)` and 2 other fields	High correlation
`강우량(mm)` has 56 (56.0%) zeros	Zeros
`유입량(ms)` has 31 (31.0%) zeros	Zeros
`방류량(ms)` has 31 (31.0%) zeros	Zeros
`저수량(백만m3)` has 31 (31.0%) zeros	Zeros
`저수율` has 31 (31.0%) zeros	Zeros

Reproduction

Analysis started	2023-12-10 10:53:26.438187
Analysis finished	2023-12-10 10:53:34.798669
Duration	8.36 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

댐이름
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

강천보	31
공주보	31
구담보	31
구미보	7

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	강천보
2nd row	강천보
3rd row	강천보
4th row	강천보
5th row	강천보

Common Values

Value	Count	Frequency (%)
강천보	31	31.0%
공주보	31	31.0%
구담보	31	31.0%
구미보	7	7.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
강천보	31	31.0%
공주보	31	31.0%
구담보	31	31.0%
구미보	7	7.0%

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

Distinct	31
Distinct (%)	31.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20191015

Minimum	20191001
Maximum	20191031
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	20191001
5-th percentile	20191002
Q1	20191007
median	20191015
Q3	20191023
95-th percentile	20191030
Maximum	20191031
Range	30
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	9.214306
Coefficient of variation (CV)	4.5635675 × 10^-7
Kurtosis	-1.2602055
Mean	20191015
Median Absolute Deviation (MAD)	8
Skewness	0.10720475
Sum	2.0191015 × 10⁹
Variance	84.903434
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
20191001	4	4.0%
20191003	4	4.0%
20191004	4	4.0%
20191005	4	4.0%
20191006	4	4.0%
20191007	4	4.0%
20191002	4	4.0%
20191026	3	3.0%
20191022	3	3.0%
20191023	3	3.0%
Other values (21)	63	63.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20191001	4	4.0%
20191002	4	4.0%
20191003	4	4.0%
20191004	4	4.0%
20191005	4	4.0%
20191006	4	4.0%
20191007	4	4.0%
20191008	3	3.0%
20191009	3	3.0%
20191010	3	3.0%

Value	Count	Frequency (%)
20191031	3	3.0%
20191030	3	3.0%
20191029	3	3.0%
20191028	3	3.0%
20191027	3	3.0%
20191026	3	3.0%
20191025	3	3.0%
20191024	3	3.0%
20191023	3	3.0%
20191022	3	3.0%

저수위(m)
Real number (ℝ)

HIGH CORRELATION

Distinct	66
Distinct (%)	66.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.9438

Minimum	3.68
Maximum	62.77
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	3.68
5-th percentile	3.719
Q1	7.4175
median	38.03
Q3	61.1325
95-th percentile	62.472
Maximum	62.77
Range	59.09
Interquartile range (IQR)	53.715

Descriptive statistics

Standard deviation	22.514906
Coefficient of variation (CV)	0.64431761
Kurtosis	-1.3933018
Mean	34.9438
Median Absolute Deviation (MAD)	24.17
Skewness	-0.17913662
Sum	3494.38
Variance	506.92097
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38.02	8	8.0%
38.03	7	7.0%
62.34	4	4.0%
62.35	4	4.0%
3.69	3	3.0%
4.32	3	3.0%
61.07	2	2.0%
62.2	2	2.0%
62.51	2	2.0%
38.1	2	2.0%
Other values (56)	63	63.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.68	1	1.0%
3.69	3	3.0%
3.7	1	1.0%
3.72	1	1.0%
3.77	1	1.0%
4.15	1	1.0%
4.21	1	1.0%
4.31	1	1.0%
4.32	3	3.0%
4.33	1	1.0%

Value	Count	Frequency (%)
62.77	1	1.0%
62.52	2	2.0%
62.51	2	2.0%
62.47	1	1.0%
62.35	4	4.0%
62.34	4	4.0%
62.33	1	1.0%
62.23	1	1.0%
62.21	2	2.0%
62.2	2	2.0%

강우량(mm)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	42
Distinct (%)	42.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.850959

Minimum	0
Maximum	91.3363
Zeros	56
Zeros (%)	56.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.044975
95-th percentile	20.137555
Maximum	91.3363
Range	91.3363
Interquartile range (IQR)	0.044975

Descriptive statistics

Standard deviation	11.898639
Coefficient of variation (CV)	4.1735565
Kurtosis	34.774102
Mean	2.850959
Median Absolute Deviation (MAD)	0
Skewness	5.5586208
Sum	285.0959
Variance	141.5776
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
0.0	56	56.0%
0.0119	4	4.0%
0.0101	1	1.0%
0.021	1	1.0%
0.0406	1	1.0%
0.0447	1	1.0%
0.0416	1	1.0%
0.0175	1	1.0%
0.4368	1	1.0%
0.0458	1	1.0%
Other values (32)	32	32.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	56	56.0%
0.0062	1	1.0%
0.0101	1	1.0%
0.0119	4	4.0%
0.0174	1	1.0%
0.0175	1	1.0%
0.018	1	1.0%
0.021	1	1.0%
0.0272	1	1.0%
0.0317	1	1.0%

Value	Count	Frequency (%)
91.3363	1	1.0%
53.2008	1	1.0%
41.1994	1	1.0%
31.0095	1	1.0%
20.9043	1	1.0%
20.0972	1	1.0%
8.8628	1	1.0%
6.8848	1	1.0%
4.9397	1	1.0%
1.7417	1	1.0%

유입량(ms)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	70
Distinct (%)	70.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	152.36432

Minimum	0
Maximum	3422.727
Zeros	31
Zeros (%)	31.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	78.4765
Q3	125.552
95-th percentile	376.8548
Maximum	3422.727
Range	3422.727
Interquartile range (IQR)	125.552

Descriptive statistics

Standard deviation	376.38859
Coefficient of variation (CV)	2.4703197
Kurtosis	59.21185
Mean	152.36432
Median Absolute Deviation (MAD)	74.5125
Skewness	7.1282987
Sum	15236.432
Variance	141668.37
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	31	31.0%
244.58	1	1.0%
56.448	1	1.0%
65.438	1	1.0%
66.099	1	1.0%
64.565	1	1.0%
65.968	1	1.0%
59.501	1	1.0%
66.394	1	1.0%
110.476	1	1.0%
Other values (60)	60	60.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	31	31.0%
40.65	1	1.0%
41.072	1	1.0%
41.281	1	1.0%
41.718	1	1.0%
41.801	1	1.0%
43.372	1	1.0%
43.945	1	1.0%
48.654	1	1.0%
54.973	1	1.0%

Value	Count	Frequency (%)
3422.727	1	1.0%
1326.977	1	1.0%
770.436	1	1.0%
560.622	1	1.0%
531.834	1	1.0%
368.698	1	1.0%
348.986	1	1.0%
346.462	1	1.0%
335.474	1	1.0%
326.878	1	1.0%

방류량(ms)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	70
Distinct (%)	70.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	153.21252

Minimum	0
Maximum	3435.54
Zeros	31
Zeros (%)	31.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	78.7385
Q3	129.23075
95-th percentile	374.32495
Maximum	3435.54
Range	3435.54
Interquartile range (IQR)	129.23075

Descriptive statistics

Standard deviation	377.254
Coefficient of variation (CV)	2.4622922
Kurtosis	59.51641
Mean	153.21252
Median Absolute Deviation (MAD)	75.0365
Skewness	7.1485447
Sum	15321.252
Variance	142320.58
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	31	31.0%
241.585	1	1.0%
56.281	1	1.0%
65.438	1	1.0%
66.099	1	1.0%
64.509	1	1.0%
66.079	1	1.0%
59.891	1	1.0%
71.615	1	1.0%
110.476	1	1.0%
Other values (60)	60	60.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	31	31.0%
40.256	1	1.0%
41.072	1	1.0%
41.202	1	1.0%
41.876	1	1.0%
41.959	1	1.0%
43.787	1	1.0%
56.281	1	1.0%
59.891	1	1.0%
61.064	1	1.0%

Value	Count	Frequency (%)
3435.54	1	1.0%
1323.208	1	1.0%
767.198	1	1.0%
567.561	1	1.0%
527.312	1	1.0%
366.273	1	1.0%
350.364	1	1.0%
332.236	1	1.0%
331.4	1	1.0%
330.452	1	1.0%

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

HIGH CORRELATION ZEROS

Distinct	48
Distinct (%)	48.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.08636

Minimum	0
Maximum	54.035
Zeros	31
Zeros (%)	31.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	5.1965
Q3	8.97675
95-th percentile	52.9443
Maximum	54.035
Range	54.035
Interquartile range (IQR)	8.97675

Descriptive statistics

Standard deviation	13.133088
Coefficient of variation (CV)	1.6241038
Kurtosis	7.5901377
Mean	8.08636
Median Absolute Deviation (MAD)	4.052
Skewness	2.8690485
Sum	808.636
Variance	172.47799
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
0.0	31	31.0%
8.819	8	8.0%
8.864	7	7.0%
2.076	3	3.0%
2.443	3	3.0%
10.591	2	2.0%
9.135	2	2.0%
9.045	2	2.0%
53.254	2	2.0%
9.181	2	2.0%
Other values (38)	38	38.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	31	31.0%
2.071	1	1.0%
2.076	3	3.0%
2.081	1	1.0%
2.09	1	1.0%
2.114	1	1.0%
2.327	1	1.0%
2.368	1	1.0%
2.436	1	1.0%
2.443	3	3.0%

Value	Count	Frequency (%)
54.035	1	1.0%
53.84	1	1.0%
53.645	1	1.0%
53.254	2	2.0%
52.928	1	1.0%
52.652	1	1.0%
10.631	1	1.0%
10.629	1	1.0%
10.591	2	2.0%
10.311	1	1.0%

저수율
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	43
Distinct (%)	43.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49.177

Minimum	0
Maximum	121.8
Zeros	31
Zeros (%)	31.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	33.45
Q3	101
95-th percentile	105.275
Maximum	121.8
Range	121.8
Interquartile range (IQR)	101

Descriptive statistics

Standard deviation	46.14
Coefficient of variation (CV)	0.93824348
Kurtosis	-1.797826
Mean	49.177
Median Absolute Deviation (MAD)	33.45
Skewness	0.18344815
Sum	4917.7
Variance	2128.8996
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
0.0	31	31.0%
101.0	10	10.0%
101.6	7	7.0%
13.4	4	4.0%
15.7	4	4.0%
103.6	2	2.0%
68.2	2	2.0%
102.1	2	2.0%
15.8	2	2.0%
105.2	2	2.0%
Other values (33)	34	34.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	31	31.0%
13.3	1	1.0%
13.4	4	4.0%
13.5	1	1.0%
13.6	1	1.0%
15.0	1	1.0%
15.2	1	1.0%
15.7	4	4.0%
15.8	2	2.0%
15.9	1	1.0%

Value	Count	Frequency (%)
121.8	1	1.0%
113.0	1	1.0%
111.9	1	1.0%
110.9	1	1.0%
106.7	1	1.0%
105.2	2	2.0%
104.7	2	2.0%
103.6	2	2.0%
102.6	1	1.0%
102.5	1	1.0%

Phik (φk)
Auto

Heatmap
Table

	댐이름	일자/시간(t)	저수위(m)	강우량(mm)	유입량(ms)	방류량(ms)	저수량(백만m3)	저수율
댐이름	1.000	0.000	1.000	0.375	0.376	0.329	0.844	0.979
일자/시간(t)	0.000	1.000	0.000	0.000	0.402	0.245	0.360	0.429
저수위(m)	1.000	0.000	1.000	0.375	0.376	0.329	0.844	0.979
강우량(mm)	0.375	0.000	0.375	1.000	0.768	0.740	0.654	0.133
유입량(ms)	0.376	0.402	0.376	0.768	1.000	1.000	0.479	0.000
방류량(ms)	0.329	0.245	0.329	0.740	1.000	1.000	0.437	0.000
저수량(백만m3)	0.844	0.360	0.844	0.654	0.479	0.437	1.000	0.790
저수율	0.979	0.429	0.979	0.133	0.000	0.000	0.790	1.000

Heatmap
Table

	일자/시간(t)	저수위(m)	강우량(mm)	유입량(ms)	방류량(ms)	저수량(백만m3)	저수율	댐이름
일자/시간(t)	1.000	-0.048	-0.370	-0.390	-0.392	-0.377	-0.216	0.000
저수위(m)	-0.048	1.000	-0.359	-0.520	-0.520	-0.434	-0.328	1.000
강우량(mm)	-0.370	-0.359	1.000	0.627	0.630	0.675	0.587	0.246
유입량(ms)	-0.390	-0.520	0.627	1.000	0.999	0.911	0.822	0.312
방류량(ms)	-0.392	-0.520	0.630	0.999	1.000	0.912	0.822	0.271
저수량(백만m3)	-0.377	-0.434	0.675	0.911	0.912	1.000	0.915	0.910
저수율	-0.216	-0.328	0.587	0.822	0.822	0.915	1.000	0.790
댐이름	0.000	1.000	0.246	0.312	0.271	0.910	0.790	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	댐이름	일자/시간(t)	저수위(m)	강우량(mm)	유입량(ms)	방류량(ms)	저수량(백만m3)	저수율
0	강천보	20191001	38.02	0.0101	110.476	110.476	8.819	101.0
1	강천보	20191002	38.07	41.1994	116.818	114.199	9.045	103.6
2	강천보	20191003	38.42	20.9043	368.698	350.364	10.629	121.8
3	강천보	20191004	38.09	0.0814	348.986	366.273	9.135	104.7
4	강천보	20191005	38.25	0.3049	177.962	169.581	9.86	113.0
5	강천보	20191006	38.23	0.0	149.025	150.073	9.769	111.9
6	강천보	20191007	38.21	6.8848	145.768	146.816	9.678	110.9
7	강천보	20191008	38.1	0.1868	130.061	135.823	9.181	105.2
8	강천보	20191009	38.1	0.07	76.504	76.504	9.181	105.2
9	강천보	20191010	38.09	0.0119	80.449	80.973	9.135	104.7

	댐이름	일자/시간(t)	저수위(m)	강우량(mm)	유입량(ms)	방류량(ms)	저수량(백만m3)	저수율
90	구담보	20191029	62.34	0.0	0.0	0.0	0.0	0.0
91	구담보	20191030	62.33	0.0	0.0	0.0	0.0	0.0
92	구담보	20191031	62.34	0.0	0.0	0.0	0.0	0.0
93	구미보	20191001	32.49	0.0703	130.783	137.748	52.652	99.9
94	구미보	20191002	32.7	91.3363	346.462	330.452	54.035	102.5
95	구미보	20191003	32.53	31.0095	3422.727	3435.54	52.928	100.4
96	구미보	20191004	32.58	0.1279	1326.977	1323.208	53.254	101.0
97	구미보	20191005	32.64	0.5731	531.834	527.312	53.645	101.7
98	구미보	20191006	32.58	0.0	326.878	331.4	53.254	101.0
99	구미보	20191007	32.67	4.9397	265.989	259.206	53.84	102.1

Overview

Variables

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample