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	2
Numeric	6

Dataset

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

Alerts

`댐이름` has constant value ""	Constant
`강우량(mm)` has constant value ""	Constant
`저수위(m)` is highly overall correlated with `유입량(ms)` and 3 other fields	High correlation
`유입량(ms)` is highly overall correlated with `저수위(m)` and 3 other fields	High correlation
`방류량(ms)` is highly overall correlated with `저수위(m)` and 3 other fields	High correlation
`저수량(백만m3)` is highly overall correlated with `저수위(m)` and 3 other fields	High correlation
`저수율` is highly overall correlated with `저수위(m)` and 3 other fields	High correlation
`유입량(ms)` has 7 (7.0%) zeros	Zeros

Reproduction

Analysis started	2023-12-10 13:17:49.500568
Analysis finished	2023-12-10 13:17:55.584490
Duration	6.08 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

댐이름
Categorical

CONSTANT

Distinct	1
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

강천보	100

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 (%)
강천보	100	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
강천보	100	100.0%

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

Distinct	75
Distinct (%)	75.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0191203 × 10¹¹

Minimum	2.0191202 × 10¹¹
Maximum	2.0191206 × 10¹¹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	2.0191202 × 10¹¹
5-th percentile	2.0191202 × 10¹¹
Q1	2.0191202 × 10¹¹
median	2.0191202 × 10¹¹
Q3	2.0191205 × 10¹¹
95-th percentile	2.0191206 × 10¹¹
Maximum	2.0191206 × 10¹¹
Range	39690
Interquartile range (IQR)	31482.5

Descriptive statistics

Standard deviation	16139.731
Coefficient of variation (CV)	7.9934469 × 10^-8
Kurtosis	-1.1396266
Mean	2.0191203 × 10¹¹
Median Absolute Deviation (MAD)	375
Skewness	0.89203228
Sum	2.0191203 × 10¹³
Variance	2.6049092 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
201912052200	2	2.0%
201912060100	2	2.0%
201912021230	2	2.0%
201912021100	2	2.0%
201912021030	2	2.0%
201912020900	2	2.0%
201912020830	2	2.0%
201912020500	2	2.0%
201912060130	2	2.0%
201912060030	2	2.0%
Other values (65)	80	80.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201912020440	1	1.0%
201912020450	1	1.0%
201912020500	2	2.0%
201912020510	1	1.0%
201912020520	1	1.0%
201912020530	2	2.0%
201912020540	1	1.0%
201912020550	1	1.0%
201912020600	2	2.0%
201912020610	1	1.0%

Value	Count	Frequency (%)
201912060130	2	2.0%
201912060120	1	1.0%
201912060110	1	1.0%
201912060100	2	2.0%
201912060050	1	1.0%
201912060040	1	1.0%
201912060030	2	2.0%
201912060020	1	1.0%
201912060010	1	1.0%
201912052400	2	2.0%

저수위(m)
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	6.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.1285

Minimum	38.1
Maximum	38.16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	38.1
5-th percentile	38.1
Q1	38.11
median	38.13
Q3	38.15
95-th percentile	38.16
Maximum	38.16
Range	0.06
Interquartile range (IQR)	0.04

Descriptive statistics

Standard deviation	0.02275806
Coefficient of variation (CV)	0.00059687792
Kurtosis	-1.5680829
Mean	38.1285
Median Absolute Deviation (MAD)	0.02
Skewness	0.23616602
Sum	3812.85
Variance	0.00051792929
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
38.11	35	35.0%
38.16	24	24.0%
38.14	17	17.0%
38.1	14	14.0%
38.13	6	6.0%
38.15	4	4.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
38.1	14	14.0%
38.11	35	35.0%
38.13	6	6.0%
38.14	17	17.0%
38.15	4	4.0%
38.16	24	24.0%

Value	Count	Frequency (%)
38.16	24	24.0%
38.15	4	4.0%
38.14	17	17.0%
38.13	6	6.0%
38.11	35	35.0%
38.1	14	14.0%

강우량(mm)
Categorical

CONSTANT

Distinct	1
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

0	100

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	100	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	100	100.0%

유입량(ms)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	71
Distinct (%)	71.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98.86564

Minimum	0
Maximum	246.754
Zeros	7
Zeros (%)	7.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	88.617
median	90.7165
Q3	98.873
95-th percentile	221.12805
Maximum	246.754
Range	246.754
Interquartile range (IQR)	10.256

Descriptive statistics

Standard deviation	47.596463
Coefficient of variation (CV)	0.48142573
Kurtosis	3.5522428
Mean	98.86564
Median Absolute Deviation (MAD)	4.1765
Skewness	1.0123533
Sum	9886.564
Variance	2265.4233
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	7	7.0%
86.54	3	3.0%
94.693	3	3.0%
94.687	3	3.0%
88.687	3	3.0%
88.713	2	2.0%
86.627	2	2.0%
98.74	2	2.0%
98.873	2	2.0%
88.66	2	2.0%
Other values (61)	71	71.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	7	7.0%
12.372	1	1.0%
71.974	1	1.0%
71.975	1	1.0%
72.778	1	1.0%
73.505	1	1.0%
86.54	3	3.0%
86.56	1	1.0%
86.61	1	1.0%
86.627	2	2.0%

Value	Count	Frequency (%)
246.754	2	2.0%
242.698	1	1.0%
238.718	1	1.0%
221.129	1	1.0%
221.128	1	1.0%
217.712	1	1.0%
174.022	1	1.0%
139.103	1	1.0%
123.62	1	1.0%
123.619	1	1.0%

방류량(ms)
Real number (ℝ)

HIGH CORRELATION

Distinct	81
Distinct (%)	81.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	92.27095

Minimum	86.51
Maximum	98.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	86.51
5-th percentile	86.56
Q1	88.64
median	90.969
Q3	96.03375
95-th percentile	98.84165
Maximum	98.95
Range	12.44
Interquartile range (IQR)	7.39375

Descriptive statistics

Standard deviation	4.4141533
Coefficient of variation (CV)	0.047839036
Kurtosis	-1.469661
Mean	92.27095
Median Absolute Deviation (MAD)	3.696
Skewness	0.30785265
Sum	9227.095
Variance	19.484749
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
88.64	4	4.0%
88.65	3	3.0%
88.66	3	3.0%
88.6	2	2.0%
94.69	2	2.0%
88.74	2	2.0%
88.68	2	2.0%
86.56	2	2.0%
88.63	2	2.0%
98.8	2	2.0%
Other values (71)	76	76.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
86.51	1	1.0%
86.54	1	1.0%
86.55	2	2.0%
86.56	2	2.0%
86.57	1	1.0%
86.627	1	1.0%
86.69	1	1.0%
86.762	1	1.0%
86.77	1	1.0%
87.398	1	1.0%

Value	Count	Frequency (%)
98.95	1	1.0%
98.9	2	2.0%
98.88	1	1.0%
98.873	1	1.0%
98.84	1	1.0%
98.83	1	1.0%
98.81	1	1.0%
98.8	2	2.0%
98.773	1	1.0%
98.77	1	1.0%

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

HIGH CORRELATION

Distinct	6
Distinct (%)	6.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.3097

Minimum	9.181
Maximum	9.452
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	9.181
5-th percentile	9.181
Q1	9.226
median	9.316
Q3	9.407
95-th percentile	9.452
Maximum	9.452
Range	0.271
Interquartile range (IQR)	0.181

Descriptive statistics

Standard deviation	0.10287194
Coefficient of variation (CV)	0.011049974
Kurtosis	-1.5708139
Mean	9.3097
Median Absolute Deviation (MAD)	0.09
Skewness	0.23580313
Sum	930.97
Variance	0.010582636
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
9.226	35	35.0%
9.452	24	24.0%
9.362	17	17.0%
9.181	14	14.0%
9.316	6	6.0%
9.407	4	4.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.181	14	14.0%
9.226	35	35.0%
9.316	6	6.0%
9.362	17	17.0%
9.407	4	4.0%
9.452	24	24.0%

Value	Count	Frequency (%)
9.452	24	24.0%
9.407	4	4.0%
9.362	17	17.0%
9.316	6	6.0%
9.226	35	35.0%
9.181	14	14.0%

저수율
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	6.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	106.67

Minimum	105.2
Maximum	108.3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	105.2
5-th percentile	105.2
Q1	105.7
median	106.7
Q3	107.8
95-th percentile	108.3
Maximum	108.3
Range	3.1
Interquartile range (IQR)	2.1

Descriptive statistics

Standard deviation	1.184112
Coefficient of variation (CV)	0.011100703
Kurtosis	-1.5919863
Mean	106.67
Median Absolute Deviation (MAD)	1
Skewness	0.23308774
Sum	10667
Variance	1.4021212
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
105.7	35	35.0%
108.3	24	24.0%
107.3	17	17.0%
105.2	14	14.0%
106.7	6	6.0%
107.8	4	4.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
105.2	14	14.0%
105.7	35	35.0%
106.7	6	6.0%
107.3	17	17.0%
107.8	4	4.0%
108.3	24	24.0%

Value	Count	Frequency (%)
108.3	24	24.0%
107.8	4	4.0%
107.3	17	17.0%
106.7	6	6.0%
105.7	35	35.0%
105.2	14	14.0%

Phik (φk)
Auto

Heatmap
Table

	일자/시간(t)	저수위(m)	유입량(ms)	방류량(ms)	저수량(백만m3)	저수율
일자/시간(t)	1.000	0.653	0.609	0.672	0.653	0.653
저수위(m)	0.653	1.000	0.809	0.965	1.000	1.000
유입량(ms)	0.609	0.809	1.000	0.723	0.809	0.809
방류량(ms)	0.672	0.965	0.723	1.000	0.965	0.965
저수량(백만m3)	0.653	1.000	0.809	0.965	1.000	1.000
저수율	0.653	1.000	0.809	0.965	1.000	1.000

Heatmap
Table

	일자/시간(t)	저수위(m)	유입량(ms)	방류량(ms)	저수량(백만m3)	저수율
일자/시간(t)	1.000	0.214	0.190	0.182	0.214	0.214
저수위(m)	0.214	1.000	0.760	0.918	1.000	1.000
유입량(ms)	0.190	0.760	1.000	0.675	0.760	0.760
방류량(ms)	0.182	0.918	0.675	1.000	0.918	0.918
저수량(백만m3)	0.214	1.000	0.760	0.918	1.000	1.000
저수율	0.214	1.000	0.760	0.918	1.000	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)	유입량(ms)	방류량(ms)	저수량(백만m3)	저수율
0	강천보	201912052200	38.13	116.949	92.58	9.316	106.7
1	강천보	201912052210	38.13	117.675	92.75	9.316	106.7
2	강천보	201912052230	38.14	117.973	92.862	9.362	107.3
3	강천보	201912052230	38.14	117.972	93.094	9.362	107.3
4	강천보	201912052220	38.13	92.69	92.74	9.316	106.7
5	강천보	201912052300	38.14	94.747	94.61	9.362	107.3
6	강천보	201912020600	38.1	0.0	93.081	9.181	105.2
7	강천보	201912020940	38.11	88.733	88.79	9.226	105.7
8	강천보	201912020600	38.1	0.0	89.832	9.181	105.2
9	강천보	201912052250	38.14	119.352	94.8	9.362	107.3

	댐이름	일자/시간(t)	저수위(m)	유입량(ms)	방류량(ms)	저수량(백만m3)	저수율
90	강천보	201912020700	38.11	88.64	88.64	9.226	105.7
91	강천보	201912020700	38.11	88.64	88.66	9.226	105.7
92	강천보	201912020640	38.11	113.204	88.61	9.226	105.7
93	강천보	201912020630	38.11	112.565	87.398	9.226	105.7
94	강천보	201912020540	38.14	94.693	94.69	9.362	107.3
95	강천보	201912020550	38.14	94.687	94.72	9.362	107.3
96	강천보	201912020530	38.14	94.693	94.693	9.362	107.3
97	강천보	201912020530	38.14	94.693	94.65	9.362	107.3
98	강천보	201912052150	38.13	116.305	92.196	9.316	106.7
99	강천보	201912052200	38.13	116.949	91.782	9.316	106.7

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample