gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	72
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.8 KiB
Average record size in memory	53.8 B

Variable types

DateTime	2
Numeric	4

Dataset

Description	남양주시 정수처리장(화도정수장,도곡정수장) 별로 월별로 정수처리량, 정수슬러지처리량 항목을 제공합니다.
Author	경기도 남양주시
URL	https://www.data.go.kr/data/15098867/fileData.do

Alerts

`데이터기준일` has constant value ""	Constant
`년월` has unique values	Unique
`화도정수장 정수생산량(톤)` has unique values	Unique
`도곡정수장 정수생산량(톤)` has unique values	Unique
`도곡정수장 슬러지처리량(톤)` has 60 (83.3%) zeros	Zeros

Reproduction

Analysis started	2024-04-17 09:53:06.209134
Analysis finished	2024-04-17 09:53:07.755668
Duration	1.55 second
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

년월
Date

UNIQUE

Distinct	72
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	708.0 B

Minimum	2017-01-01 00:00:00
Maximum	2022-12-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

화도정수장 정수생산량(톤)
Real number (ℝ)

UNIQUE

Distinct	72
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1368535.1

Minimum	1009821
Maximum	1751230
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	780.0 B

Quantile statistics

Minimum	1009821
5-th percentile	1060758.9
Q1	1101929.2
median	1456574.5
Q3	1575217.8
95-th percentile	1671945.6
Maximum	1751230
Range	741409
Interquartile range (IQR)	473288.5

Descriptive statistics

Standard deviation	235879.2
Coefficient of variation (CV)	0.17235889
Kurtosis	-1.6244137
Mean	1368535.1
Median Absolute Deviation (MAD)	173141
Skewness	-0.14858495
Sum	98534530
Variance	5.5638997 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1468110	1	1.4%
1488596	1	1.4%
1086404	1	1.4%
1098602	1	1.4%
1065198	1	1.4%
1107875	1	1.4%
1047842	1	1.4%
1199509	1	1.4%
1079730	1	1.4%
1009821	1	1.4%
Other values (62)	62	86.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1009821	1	1.4%
1010697	1	1.4%
1047842	1	1.4%
1060017	1	1.4%
1061366	1	1.4%
1065198	1	1.4%
1070257	1	1.4%
1071778	1	1.4%
1079730	1	1.4%
1086404	1	1.4%

Value	Count	Frequency (%)
1751230	1	1.4%
1731961	1	1.4%
1714676	1	1.4%
1710747	1	1.4%
1640199	1	1.4%
1636447	1	1.4%
1633654	1	1.4%
1625777	1	1.4%
1625224	1	1.4%
1615940	1	1.4%

화도정수장 슬러지처리량(톤)
Real number (ℝ)

Distinct	71
Distinct (%)	98.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	71.866667

Minimum	16.44
Maximum	166.46
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	780.0 B

Quantile statistics

Minimum	16.44
5-th percentile	30.4625
Q1	51.685
median	65.825
Q3	91.4475
95-th percentile	128.5765
Maximum	166.46
Range	150.02
Interquartile range (IQR)	39.7625

Descriptive statistics

Standard deviation	33.476839
Coefficient of variation (CV)	0.46581872
Kurtosis	0.49549428
Mean	71.866667
Median Absolute Deviation (MAD)	20.255
Skewness	0.81154734
Sum	5174.4
Variance	1120.6987
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17.06	2	2.8%
82.59	1	1.4%
57.5	1	1.4%
53.91	1	1.4%
97.8	1	1.4%
37.39	1	1.4%
31.79	1	1.4%
39.86	1	1.4%
105.73	1	1.4%
75.03	1	1.4%
Other values (61)	61	84.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16.44	1	1.4%
17.06	2	2.8%
28.84	1	1.4%
31.79	1	1.4%
33.84	1	1.4%
36.38	1	1.4%
36.55	1	1.4%
36.68	1	1.4%
37.31	1	1.4%
37.32	1	1.4%

Value	Count	Frequency (%)
166.46	1	1.4%
160.51	1	1.4%
157.4	1	1.4%
130.87	1	1.4%
126.7	1	1.4%
122.58	1	1.4%
122.37	1	1.4%
116.61	1	1.4%
115.71	1	1.4%
112.41	1	1.4%

도곡정수장 정수생산량(톤)
Real number (ℝ)

UNIQUE

Distinct	72
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	369262.81

Minimum	326939
Maximum	414881
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	780.0 B

Quantile statistics

Minimum	326939
5-th percentile	340312.1
Q1	356384.75
median	368203.5
Q3	378303.75
95-th percentile	406391.85
Maximum	414881
Range	87942
Interquartile range (IQR)	21919

Descriptive statistics

Standard deviation	19292.265
Coefficient of variation (CV)	0.052245351
Kurtosis	-0.0084862736
Mean	369262.81
Median Absolute Deviation (MAD)	12105
Skewness	0.36954533
Sum	26586922
Variance	3.7219148 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
373119	1	1.4%
345239	1	1.4%
365382	1	1.4%
361085	1	1.4%
355526	1	1.4%
366948	1	1.4%
339421	1	1.4%
393236	1	1.4%
413467	1	1.4%
414881	1	1.4%
Other values (62)	62	86.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
326939	1	1.4%
336110	1	1.4%
339421	1	1.4%
339442	1	1.4%
341024	1	1.4%
342018	1	1.4%
343514	1	1.4%
345002	1	1.4%
345239	1	1.4%
346636	1	1.4%

Value	Count	Frequency (%)
414881	1	1.4%
413467	1	1.4%
412127	1	1.4%
407972	1	1.4%
405099	1	1.4%
403114	1	1.4%
398064	1	1.4%
393236	1	1.4%
391813	1	1.4%
391164	1	1.4%

도곡정수장 슬러지처리량(톤)
Real number (ℝ)

ZEROS

Distinct	13
Distinct (%)	18.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.197778

Minimum	0
Maximum	273.39
Zeros	60
Zeros (%)	83.3%
Negative	0
Negative (%)	0.0%
Memory size	780.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	212.797
Maximum	273.39
Range	273.39
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	64.205554
Coefficient of variation (CV)	3.0288814
Kurtosis	9.6362459
Mean	21.197778
Median Absolute Deviation (MAD)	0
Skewness	3.2730946
Sum	1526.24
Variance	4122.3532
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
0.0	60	83.3%
178.57	1	1.4%
260.82	1	1.4%
254.63	1	1.4%
273.39	1	1.4%
258.68	1	1.4%
39.25	1	1.4%
15.45	1	1.4%
67.29	1	1.4%
48.08	1	1.4%
Other values (3)	3	4.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	60	83.3%
13.29	1	1.4%
15.45	1	1.4%
19.56	1	1.4%
39.25	1	1.4%
48.08	1	1.4%
67.29	1	1.4%
97.23	1	1.4%
178.57	1	1.4%
254.63	1	1.4%

Value	Count	Frequency (%)
273.39	1	1.4%
260.82	1	1.4%
258.68	1	1.4%
254.63	1	1.4%
178.57	1	1.4%
97.23	1	1.4%
67.29	1	1.4%
48.08	1	1.4%
39.25	1	1.4%
19.56	1	1.4%

데이터기준일
Date

CONSTANT

Distinct	1
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Memory size	708.0 B

Minimum	2023-02-01 00:00:00
Maximum	2023-02-01 00:00:00

Histogram

Histogram with fixed size bins (bins=1)

Phik (φk)
Auto

Heatmap
Table

	년월	화도정수장 정수생산량(톤)	화도정수장 슬러지처리량(톤)	도곡정수장 정수생산량(톤)	도곡정수장 슬러지처리량(톤)
년월	1.000	1.000	1.000	1.000	1.000
화도정수장 정수생산량(톤)	1.000	1.000	0.488	0.665	0.000
화도정수장 슬러지처리량(톤)	1.000	0.488	1.000	0.000	0.000
도곡정수장 정수생산량(톤)	1.000	0.665	0.000	1.000	0.311
도곡정수장 슬러지처리량(톤)	1.000	0.000	0.000	0.311	1.000

Heatmap
Table

	화도정수장 정수생산량(톤)	화도정수장 슬러지처리량(톤)	도곡정수장 정수생산량(톤)	도곡정수장 슬러지처리량(톤)
화도정수장 정수생산량(톤)	1.000	0.399	0.330	-0.229
화도정수장 슬러지처리량(톤)	0.399	1.000	0.203	-0.197
도곡정수장 정수생산량(톤)	0.330	0.203	1.000	-0.004
도곡정수장 슬러지처리량(톤)	-0.229	-0.197	-0.004	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

	년월	화도정수장 정수생산량(톤)	화도정수장 슬러지처리량(톤)	도곡정수장 정수생산량(톤)	데이터기준일
0	2017-01	1468110	82.59	373119	2023-02-01
1	2017-02	1327952	53.03	336110	2023-02-01
2	2017-03	1472048	104.73	374215	2023-02-01
3	2017-04	1448891	68.96	362008	2023-02-01
4	2017-05	1520623	65.58	375177	2023-02-01
5	2017-06	1515081	77.55	376774	2023-02-01
6	2017-07	1612363	160.51	381624	2023-02-01
7	2017-08	1559262	91.15	361231	2023-02-01
8	2017-09	1497634	74.03	342018	2023-02-01
9	2017-10	1523554	51.83	365052	2023-02-01

	년월	화도정수장 정수생산량(톤)	화도정수장 슬러지처리량(톤)	도곡정수장 정수생산량(톤)	도곡정수장 슬러지처리량(톤)	데이터기준일
62	2022-03	1097529	78.49	385674	39.25	2023-02-01
63	2022-04	1060017	56.81	358990	15.45	2023-02-01
64	2022-05	1099157	36.38	373835	0.0	2023-02-01
65	2022-06	1070257	16.44	377167	0.0	2023-02-01
66	2022-07	1141715	75.8	370708	0.0	2023-02-01
67	2022-08	1147023	57.88	366772	67.29	2023-02-01
68	2022-09	1098291	60.76	346636	48.08	2023-02-01
69	2022-10	1102701	61.47	354503	19.56	2023-02-01
70	2022-11	1071778	106.51	341024	97.23	2023-02-01
71	2022-12	1152115	37.31	356671	13.29	2023-02-01

Overview

Variables

Interactions

Correlations

Missing values

Sample