gimi9 Pandas Profiling

Dataset statistics

Number of variables	9
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	849.6 KiB
Average record size in memory	87.0 B

Variable types

Numeric	7
Categorical	2

Dataset

Description	부산광역시상수도사업본부_수용가정보시스템_고지집계정보_고지전수집계_20210601
Author	부산광역시 상수도사업본부
URL	http://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15083673

Alerts

`상하수도구분` has constant value ""	Constant
`연번` is highly overall correlated with `고지년월`	High correlation
`구경` is highly overall correlated with `전수`	High correlation
`전수` is highly overall correlated with `구경`	High correlation
`고지년월` is highly overall correlated with `연번`	High correlation
`연번` has unique values	Unique

Reproduction

Analysis started	2023-12-10 16:49:15.732562
Analysis finished	2023-12-10 16:49:25.372259
Duration	9.64 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연번
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10774.55

Minimum	2
Maximum	21528
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	2
5-th percentile	1084.9
Q1	5429.75
median	10744.5
Q3	16104
95-th percentile	20481.1
Maximum	21528
Range	21526
Interquartile range (IQR)	10674.25

Descriptive statistics

Standard deviation	6209.4057
Coefficient of variation (CV)	0.57630303
Kurtosis	-1.1946968
Mean	10774.55
Median Absolute Deviation (MAD)	5338
Skewness	0.00018996161
Sum	1.077455 × 10⁸
Variance	38556720
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19661	1	< 0.1%
7111	1	< 0.1%
17437	1	< 0.1%
2720	1	< 0.1%
19294	1	< 0.1%
2	1	< 0.1%
4410	1	< 0.1%
17962	1	< 0.1%
7285	1	< 0.1%
20609	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
4	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
13	1	< 0.1%
14	1	< 0.1%
20	1	< 0.1%
24	1	< 0.1%
25	1	< 0.1%
26	1	< 0.1%

Value	Count	Frequency (%)
21528	1	< 0.1%
21527	1	< 0.1%
21526	1	< 0.1%
21523	1	< 0.1%
21520	1	< 0.1%
21519	1	< 0.1%
21518	1	< 0.1%
21516	1	< 0.1%
21515	1	< 0.1%
21512	1	< 0.1%

고지년월
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

2021-04	2021
2021-02	2006
2021-03	1996
2021-05	1994
2021-01	1983

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2021-05
2nd row	2021-01
3rd row	2021-05
4th row	2021-05
5th row	2021-03

Common Values

Value	Count	Frequency (%)
2021-04	2021	20.2%
2021-02	2006	20.1%
2021-03	1996	20.0%
2021-05	1994	19.9%
2021-01	1983	19.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2021-04	2021	20.2%
2021-02	2006	20.1%
2021-03	1996	20.0%
2021-05	1994	19.9%
2021-01	1983	19.8%

사업소코드
Real number (ℝ)

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	293.3814

Minimum	244
Maximum	312
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	244
5-th percentile	244
Q1	301
median	304
Q3	307
95-th percentile	311
Maximum	312
Range	68
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	24.838543
Coefficient of variation (CV)	0.084662979
Kurtosis	0.19338752
Mean	293.3814
Median Absolute Deviation (MAD)	3
Skewness	-1.4577056
Sum	2933814
Variance	616.95323
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
244	2001	20.0%
306	1369	13.7%
307	1215	12.2%
304	1204	12.0%
301	861	8.6%
309	840	8.4%
308	822	8.2%
303	574	5.7%
302	544	5.4%
311	312	3.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
244	2001	20.0%
301	861	8.6%
302	544	5.4%
303	574	5.7%
304	1204	12.0%
306	1369	13.7%
307	1215	12.2%
308	822	8.2%
309	840	8.4%
311	312	3.1%

Value	Count	Frequency (%)
312	258	2.6%
311	312	3.1%
309	840	8.4%
308	822	8.2%
307	1215	12.2%
306	1369	13.7%
304	1204	12.0%
303	574	5.7%
302	544	5.4%
301	861	8.6%

구코드
Real number (ℝ)

Distinct	16
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	329.777

Minimum	110
Maximum	710
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	110
5-th percentile	140
Q1	230
median	320
Q3	410
95-th percentile	530
Maximum	710
Range	600
Interquartile range (IQR)	180

Descriptive statistics

Standard deviation	132.31746
Coefficient of variation (CV)	0.40123315
Kurtosis	0.021774249
Mean	329.777
Median Absolute Deviation (MAD)	90
Skewness	0.51438875
Sum	3297770
Variance	17507.911
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
230	1204	12.0%
290	866	8.7%
380	840	8.4%
350	822	8.2%
410	702	7.0%
260	663	6.6%
470	636	6.4%
320	613	6.1%
530	602	6.0%
200	574	5.7%
Other values (6)	2478	24.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
110	347	3.5%
140	544	5.4%
170	514	5.1%
200	574	5.7%
230	1204	12.0%
260	663	6.6%
290	866	8.7%
320	613	6.1%
350	822	8.2%
380	840	8.4%

Value	Count	Frequency (%)
710	258	2.6%
530	602	6.0%
500	503	5.0%
470	636	6.4%
440	312	3.1%
410	702	7.0%
380	840	8.4%
350	822	8.2%
320	613	6.1%
290	866	8.7%

동코드
Real number (ℝ)

Distinct	63
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	602.2559

Minimum	250
Maximum	800
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	250
5-th percentile	510
Q1	550
median	591
Q3	660
95-th percentile	760
Maximum	800
Range	550
Interquartile range (IQR)	110

Descriptive statistics

Standard deviation	90.070927
Coefficient of variation (CV)	0.14955591
Kurtosis	2.8998375
Mean	602.2559
Median Absolute Deviation (MAD)	51
Skewness	-0.70502328
Sum	6022559
Variance	8112.7719
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
530	533	5.3%
560	486	4.9%
510	486	4.9%
520	464	4.6%
590	425	4.2%
550	405	4.0%
620	403	4.0%
580	392	3.9%
610	388	3.9%
660	387	3.9%
Other values (53)	5631	56.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
250	61	0.6%
253	55	0.5%
256	45	0.4%
310	51	0.5%
320	2	< 0.1%
330	44	0.4%
510	486	4.9%
520	464	4.6%
521	53	0.5%
525	38	0.4%

Value	Count	Frequency (%)
800	58	0.6%
790	83	0.8%
780	88	0.9%
770	105	1.1%
762	55	0.5%
761	49	0.5%
760	123	1.2%
750	155	1.6%
740	155	1.6%
730	156	1.6%

상하수도구분
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

S	10000

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
S	10000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
s	10000	100.0%

상수도업종
Real number (ℝ)

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.787

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	3
95-th percentile	6
Maximum	13
Range	12
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.8399917
Coefficient of variation (CV)	0.66020514
Kurtosis	1.300264
Mean	2.787
Median Absolute Deviation (MAD)	2
Skewness	1.0475106
Sum	27870
Variance	3.3855696
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	3942	39.4%
3	3709	37.1%
6	1254	12.5%
4	887	8.9%
8	109	1.1%
7	60	0.6%
12	16	0.2%
11	13	0.1%
9	7	0.1%
13	3	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3942	39.4%
3	3709	37.1%
4	887	8.9%
6	1254	12.5%
7	60	0.6%
8	109	1.1%
9	7	0.1%
11	13	0.1%
12	16	0.2%
13	3	< 0.1%

Value	Count	Frequency (%)
13	3	< 0.1%
12	16	0.2%
11	13	0.1%
9	7	0.1%
8	109	1.1%
7	60	0.6%
6	1254	12.5%
4	887	8.9%
3	3709	37.1%
1	3942	39.4%

구경
Real number (ℝ)

HIGH CORRELATION

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50.8953

Minimum	13
Maximum	300
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	13
5-th percentile	15
Q1	20
median	32
Q3	50
95-th percentile	150
Maximum	300
Range	287
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	48.628327
Coefficient of variation (CV)	0.95545811
Kurtosis	6.7997646
Mean	50.8953
Median Absolute Deviation (MAD)	17
Skewness	2.4459718
Sum	508953
Variance	2364.7142
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
15	1534	15.3%
40	1470	14.7%
25	1451	14.5%
20	1352	13.5%
50	1217	12.2%
80	809	8.1%
32	708	7.1%
100	649	6.5%
150	435	4.3%
200	207	2.1%
Other values (3)	168	1.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
13	4	< 0.1%
15	1534	15.3%
20	1352	13.5%
25	1451	14.5%
32	708	7.1%
40	1470	14.7%
50	1217	12.2%
80	809	8.1%
100	649	6.5%
150	435	4.3%

Value	Count	Frequency (%)
300	60	0.6%
250	104	1.0%
200	207	2.1%
150	435	4.3%
100	649	6.5%
80	809	8.1%
50	1217	12.2%
40	1470	14.7%
32	708	7.1%
25	1451	14.5%

전수
Real number (ℝ)

HIGH CORRELATION

Distinct	747
Distinct (%)	7.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	86.652

Minimum	1
Maximum	4561
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	5
Q3	22
95-th percentile	609.05
Maximum	4561
Range	4560
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	280.4149
Coefficient of variation (CV)	3.2361041
Kurtosis	33.803846
Mean	86.652
Median Absolute Deviation (MAD)	4
Skewness	5.1551795
Sum	866520
Variance	78632.513
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2436	24.4%
2	1216	12.2%
3	762	7.6%
4	510	5.1%
5	413	4.1%
6	371	3.7%
8	236	2.4%
7	227	2.3%
9	214	2.1%
10	156	1.6%
Other values (737)	3459	34.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2436	24.4%
2	1216	12.2%
3	762	7.6%
4	510	5.1%
5	413	4.1%
6	371	3.7%
7	227	2.3%
8	236	2.4%
9	214	2.1%
10	156	1.6%

Value	Count	Frequency (%)
4561	1	< 0.1%
2900	1	< 0.1%
2898	1	< 0.1%
2897	1	< 0.1%
2733	1	< 0.1%
2725	2	< 0.1%
2600	1	< 0.1%
2594	1	< 0.1%
2586	1	< 0.1%
2583	1	< 0.1%

Phik (φk)
Auto

Heatmap
Table

	연번	고지년월	사업소코드	구코드	동코드	상수도업종	구경	전수
연번	1.000	1.000	0.999	0.527	0.190	0.066	0.050	0.016
고지년월	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000
사업소코드	0.999	0.000	1.000	1.000	0.292	0.139	0.116	0.059
구코드	0.527	0.000	1.000	1.000	0.846	0.174	0.105	0.135
동코드	0.190	0.000	0.292	0.846	1.000	0.107	0.043	0.061
상수도업종	0.066	0.000	0.139	0.174	0.107	1.000	0.389	0.205
구경	0.050	0.000	0.116	0.105	0.043	0.389	1.000	0.195
전수	0.016	0.000	0.059	0.135	0.061	0.205	0.195	1.000

Heatmap
Table

	연번	사업소코드	구코드	동코드	상수도업종	구경	전수	고지년월
연번	1.000	0.203	0.085	-0.040	-0.003	0.019	0.001	0.999
사업소코드	0.203	1.000	0.374	-0.260	0.022	0.039	0.041	0.000
구코드	0.085	0.374	1.000	0.096	0.016	0.016	0.043	0.000
동코드	-0.040	-0.260	0.096	1.000	-0.013	0.012	-0.039	0.000
상수도업종	-0.003	0.022	0.016	-0.013	1.000	-0.221	-0.239	0.000
구경	0.019	0.039	0.016	0.012	-0.221	1.000	-0.561	0.000
전수	0.001	0.041	0.043	-0.039	-0.239	-0.561	1.000	0.000
고지년월	0.999	0.000	0.000	0.000	0.000	0.000	0.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

	연번	고지년월	사업소코드	구코드	동코드	상하수도구분	상수도업종	구경	전수
19660	19661	2021-05	306	290	620	S	3	300	1
3700	3701	2021-01	309	380	510	S	3	20	72
19917	19918	2021-05	306	500	760	S	3	80	2
20382	20383	2021-05	307	530	620	S	1	20	111
11588	11589	2021-03	307	320	560	S	3	32	5
16853	16854	2021-04	309	380	590	S	1	20	35
18577	18578	2021-05	302	140	590	S	4	40	1
16042	16043	2021-04	307	530	600	S	1	32	1
7522	7523	2021-02	307	530	650	S	1	32	2
21119	21120	2021-05	309	380	572	S	8	80	27

	연번	고지년월	사업소코드	구코드	동코드	상하수도구분	상수도업종	구경	전수
3544	3545	2021-01	308	350	570	S	6	25	2
17680	17681	2021-05	244	410	600	S	3	15	583
7470	7471	2021-02	307	530	620	S	1	25	41
9266	9267	2021-03	244	470	630	S	1	20	12
19647	19648	2021-05	306	290	620	S	1	80	2
12736	12737	2021-03	311	440	540	S	1	150	8
2571	2572	2021-01	306	290	710	S	3	100	2
12137	12138	2021-03	308	350	570	S	1	25	12
11137	11138	2021-03	306	290	690	S	3	15	444
11447	11448	2021-03	307	320	521	S	1	32	5

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample