gimi9 Pandas Profiling

Dataset statistics

Number of variables	18
Number of observations	384
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	59.0 KiB
Average record size in memory	157.3 B

Variable types

Numeric	12
DateTime	1
Categorical	5

Dataset

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

Alerts

`업무용` has constant value ""	Constant
`구명` is highly overall correlated with `사업소코드` and 2 other fields	High correlation
`타이틀` is highly overall correlated with `생활용수계` and 4 other fields	High correlation
`사업소명` is highly overall correlated with `사업소코드` and 2 other fields	High correlation
`통계구분` is highly overall correlated with `생활용수계` and 4 other fields	High correlation
`사업소코드` is highly overall correlated with `공업용` and 2 other fields	High correlation
`구코드` is highly overall correlated with `사업소명` and 1 other fields	High correlation
`생활용수계` is highly overall correlated with `가정용` and 4 other fields	High correlation
`가정용` is highly overall correlated with `생활용수계` and 4 other fields	High correlation
`영업용` is highly overall correlated with `생활용수계` and 4 other fields	High correlation
`욕탕용` is highly overall correlated with `생활용수계` and 4 other fields	High correlation
`공업용` is highly overall correlated with `사업소코드`	High correlation
`온천수계` is highly overall correlated with `온천영업용` and 2 other fields	High correlation
`온천영업용` is highly overall correlated with `온천수계` and 2 other fields	High correlation
`온천일반` is highly overall correlated with `온천수계` and 2 other fields	High correlation
`온천목욕용` is highly overall correlated with `온천수계` and 2 other fields	High correlation
`연번` has unique values	Unique
`생활용수계` has unique values	Unique
`가정용` has unique values	Unique
`영업용` has unique values	Unique
`공업용` has 312 (81.2%) zeros	Zeros
`온천수계` has 334 (87.0%) zeros	Zeros
`온천영업용` has 334 (87.0%) zeros	Zeros
`온천일반` has 336 (87.5%) zeros	Zeros
`온천목욕용` has 336 (87.5%) zeros	Zeros

Reproduction

Analysis started	2023-12-10 17:27:06.052207
Analysis finished	2023-12-10 17:27:42.908619
Duration	36.86 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연번
Real number (ℝ)

UNIQUE

Distinct	384
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	192.5

Minimum	1
Maximum	384
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

Minimum	1
5-th percentile	20.15
Q1	96.75
median	192.5
Q3	288.25
95-th percentile	364.85
Maximum	384
Range	383
Interquartile range (IQR)	191.5

Descriptive statistics

Standard deviation	110.9955
Coefficient of variation (CV)	0.57659998
Kurtosis	-1.2
Mean	192.5
Median Absolute Deviation (MAD)	96
Skewness	0
Sum	73920
Variance	12320
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.3%
194	1	0.3%
264	1	0.3%
263	1	0.3%
262	1	0.3%
261	1	0.3%
260	1	0.3%
259	1	0.3%
258	1	0.3%
257	1	0.3%
Other values (374)	374	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.3%
2	1	0.3%
3	1	0.3%
4	1	0.3%
5	1	0.3%
6	1	0.3%
7	1	0.3%
8	1	0.3%
9	1	0.3%
10	1	0.3%

Value	Count	Frequency (%)
384	1	0.3%
383	1	0.3%
382	1	0.3%
381	1	0.3%
380	1	0.3%
379	1	0.3%
378	1	0.3%
377	1	0.3%
376	1	0.3%
375	1	0.3%

고지년월
Date

Distinct	12
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 KiB

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

Histogram

Histogram with fixed size bins (bins=12)

통계구분
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	3.1 KiB

기본요금	192
사용료	192

Length

Max length	4
Median length	3.5
Mean length	3.5
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 (%)
기본요금	192	50.0%
사용료	192	50.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
기본요금	192	50.0%
사용료	192	50.0%

사업소코드
Real number (ℝ)

HIGH CORRELATION

Distinct	11
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	294.3125

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

Quantile statistics

Minimum	244
5-th percentile	244
Q1	301
median	305
Q3	307.25
95-th percentile	312
Maximum	312
Range	68
Interquartile range (IQR)	6.25

Descriptive statistics

Standard deviation	24.400622
Coefficient of variation (CV)	0.082907188
Kurtosis	0.49420513
Mean	294.3125
Median Absolute Deviation (MAD)	3.5
Skewness	-1.5447328
Sum	113016
Variance	595.39034
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
244	72	18.8%
301	48	12.5%
306	48	12.5%
307	48	12.5%
302	24	6.2%
303	24	6.2%
304	24	6.2%
308	24	6.2%
309	24	6.2%
311	24	6.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
244	72	18.8%
301	48	12.5%
302	24	6.2%
303	24	6.2%
304	24	6.2%
306	48	12.5%
307	48	12.5%
308	24	6.2%
309	24	6.2%
311	24	6.2%

Value	Count	Frequency (%)
312	24	6.2%
311	24	6.2%
309	24	6.2%
308	24	6.2%
307	48	12.5%
306	48	12.5%
304	24	6.2%
303	24	6.2%
302	24	6.2%
301	48	12.5%

사업소명
Categorical

HIGH CORRELATION

Distinct	11
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Memory size	3.1 KiB

동래통합사업소	72
중동부 사업소	48
남부 사업소	48
북부 사업소	48
서부 사업소	24
Other values (6)	144

Length

Max length	9
Median length	9
Mean length	8.375
Min length	7

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	동래통합사업소
2nd row	동래통합사업소
3rd row	동래통합사업소
4th row	중동부 사업소
5th row	중동부 사업소

Common Values

Value	Count	Frequency (%)
동래통합사업소	72	18.8%
중동부 사업소	48	12.5%
남부 사업소	48	12.5%
북부 사업소	48	12.5%
서부 사업소	24	6.2%
영도 사업소	24	6.2%
부산진 사업소	24	6.2%
해운대 사업소	24	6.2%
사하 사업소	24	6.2%
강서 사업소	24	6.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
사업소	312	44.8%
동래통합사업소	72	10.3%
중동부	48	6.9%
남부	48	6.9%
북부	48	6.9%
서부	24	3.4%
영도	24	3.4%
부산진	24	3.4%
해운대	24	3.4%
사하	24	3.4%
Other values (2)	48	6.9%

구코드
Real number (ℝ)

HIGH CORRELATION

Distinct	16
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	344.375

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

Quantile statistics

Minimum	110
5-th percentile	110
Q1	222.5
median	335
Q3	447.5
95-th percentile	710
Maximum	710
Range	600
Interquartile range (IQR)	225

Descriptive statistics

Standard deviation	157.24663
Coefficient of variation (CV)	0.45661452
Kurtosis	-0.28040315
Mean	344.375
Median Absolute Deviation (MAD)	120
Skewness	0.48979243
Sum	132240
Variance	24726.501
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
260	24	6.2%
500	24	6.2%
710	24	6.2%
440	24	6.2%
380	24	6.2%
350	24	6.2%
530	24	6.2%
320	24	6.2%
290	24	6.2%
410	24	6.2%
Other values (6)	144	37.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
110	24	6.2%
140	24	6.2%
170	24	6.2%
200	24	6.2%
230	24	6.2%
260	24	6.2%
290	24	6.2%
320	24	6.2%
350	24	6.2%
380	24	6.2%

Value	Count	Frequency (%)
710	24	6.2%
530	24	6.2%
500	24	6.2%
470	24	6.2%
440	24	6.2%
410	24	6.2%
380	24	6.2%
350	24	6.2%
320	24	6.2%
290	24	6.2%

구명
Categorical

HIGH CORRELATION

Distinct	16
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Memory size	3.1 KiB

동래구	24
금정구	24
연제구	24
중구	24
동구	24
Other values (11)	264

Length

Max length	4
Median length	3
Mean length	2.8125
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	동래구
2nd row	금정구
3rd row	연제구
4th row	중구
5th row	동구

Common Values

Value	Count	Frequency (%)
동래구	24	6.2%
금정구	24	6.2%
연제구	24	6.2%
중구	24	6.2%
동구	24	6.2%
서구	24	6.2%
영도구	24	6.2%
부산진구	24	6.2%
남구	24	6.2%
수영구	24	6.2%
Other values (6)	144	37.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
동래구	24	6.2%
금정구	24	6.2%
연제구	24	6.2%
중구	24	6.2%
동구	24	6.2%
서구	24	6.2%
영도구	24	6.2%
부산진구	24	6.2%
남구	24	6.2%
수영구	24	6.2%
Other values (6)	144	37.5%

생활용수계
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	384
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.7439357 × 10⁸

Minimum	18705310
Maximum	3.160698 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

Minimum	18705310
5-th percentile	32479636
Q1	44374352
median	2.3546959 × 10⁸
Q3	1.4872735 × 10⁹
95-th percentile	2.3995188 × 10⁹
Maximum	3.160698 × 10⁹
Range	3.1419927 × 10⁹
Interquartile range (IQR)	1.4428992 × 10⁹

Descriptive statistics

Standard deviation	8.6897385 × 10⁸
Coefficient of variation (CV)	1.1221346
Kurtosis	-0.58434917
Mean	7.7439357 × 10⁸
Median Absolute Deviation (MAD)	2.165807 × 10⁸
Skewness	0.81942096
Sum	2.9736713 × 10¹¹
Variance	7.5511556 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50631910	1	0.3%
45946750	1	0.3%
78714920	1	0.3%
33648900	1	0.3%
33309730	1	0.3%
32467120	1	0.3%
18821640	1	0.3%
36587390	1	0.3%
45832490	1	0.3%
51046620	1	0.3%
Other values (374)	374	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18705310	1	0.3%
18741800	1	0.3%
18750320	1	0.3%
18750550	1	0.3%
18821640	1	0.3%
18956140	1	0.3%
20352570	1	0.3%
20377250	1	0.3%
20377510	1	0.3%
20383880	1	0.3%

Value	Count	Frequency (%)
3160697980	1	0.3%
3159342020	1	0.3%
2922042060	1	0.3%
2869418590	1	0.3%
2865065150	1	0.3%
2863123320	1	0.3%
2857359010	1	0.3%
2794401140	1	0.3%
2770213290	1	0.3%
2769336290	1	0.3%

가정용
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	384
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.8942656 × 10⁸

Minimum	6091260
Maximum	1.6000259 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

Minimum	6091260
5-th percentile	14913694
Q1	24240205
median	65485365
Q3	7.3590147 × 10⁸
95-th percentile	1.1953727 × 10⁹
Maximum	1.6000259 × 10⁹
Range	1.5939347 × 10⁹
Interquartile range (IQR)	7.1166127 × 10⁸

Descriptive statistics

Standard deviation	4.4802484 × 10⁸
Coefficient of variation (CV)	1.1504733
Kurtosis	-0.56052534
Mean	3.8942656 × 10⁸
Median Absolute Deviation (MAD)	57299850
Skewness	0.8652099
Sum	1.495398 × 10¹¹
Variance	2.0072626 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
29431780	1	0.3%
30816900	1	0.3%
44341530	1	0.3%
20806750	1	0.3%
20918460	1	0.3%
16963990	1	0.3%
8172980	1	0.3%
20560840	1	0.3%
30685230	1	0.3%
29975970	1	0.3%
Other values (374)	374	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6091260	1	0.3%
6092700	1	0.3%
6102180	1	0.3%
6103550	1	0.3%
6108650	1	0.3%
6122670	1	0.3%
8160740	1	0.3%
8166110	1	0.3%
8169150	1	0.3%
8172980	1	0.3%

Value	Count	Frequency (%)
1600025940	1	0.3%
1571740220	1	0.3%
1530516220	1	0.3%
1522203300	1	0.3%
1519762350	1	0.3%
1508003890	1	0.3%
1501212700	1	0.3%
1475463050	1	0.3%
1461242190	1	0.3%
1447369850	1	0.3%

업무용
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	3.1 KiB

0	384

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	384	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	384	100.0%

영업용
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	384
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.6208788 × 10⁸

Minimum	9025290
Maximum	1.5424291 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

Minimum	9025290
5-th percentile	10972812
Q1	15361845
median	1.4536186 × 10⁸
Q3	5.9221066 × 10⁸
95-th percentile	1.2081011 × 10⁹
Maximum	1.5424291 × 10⁹
Range	1.5334038 × 10⁹
Interquartile range (IQR)	5.7684882 × 10⁸

Descriptive statistics

Standard deviation	4.1872546 × 10⁸
Coefficient of variation (CV)	1.1564194
Kurtosis	-0.13650885
Mean	3.6208788 × 10⁸
Median Absolute Deviation (MAD)	1.3627454 × 10⁸
Skewness	0.98025017
Sum	1.3904175 × 10¹¹
Variance	1.7533101 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20581030	1	0.3%
14745180	1	0.3%
33697090	1	0.3%
12376750	1	0.3%
12014370	1	0.3%
15040230	1	0.3%
10315160	1	0.3%
15602160	1	0.3%
14765060	1	0.3%
20536550	1	0.3%
Other values (374)	374	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9025290	1	0.3%
9038520	1	0.3%
9045990	1	0.3%
9084370	1	0.3%
9086820	1	0.3%
9087810	1	0.3%
9506530	1	0.3%
9533670	1	0.3%
9544910	1	0.3%
9556260	1	0.3%

Value	Count	Frequency (%)
1542429100	1	0.3%
1530770840	1	0.3%
1507106310	1	0.3%
1478227980	1	0.3%
1430869070	1	0.3%
1422874810	1	0.3%
1417919310	1	0.3%
1397275240	1	0.3%
1384412210	1	0.3%
1379122570	1	0.3%

욕탕용
Real number (ℝ)

HIGH CORRELATION

Distinct	302
Distinct (%)	78.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13865767

Minimum	78000
Maximum	57227920
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

Minimum	78000
5-th percentile	133500
Q1	435952.5
median	1998455
Q3	28851785
95-th percentile	46616171
Maximum	57227920
Range	57149920
Interquartile range (IQR)	28415832

Descriptive statistics

Standard deviation	16789369
Coefficient of variation (CV)	1.2108503
Kurtosis	-0.64730495
Mean	13865767
Median Absolute Deviation (MAD)	1917055
Skewness	0.87987097
Sum	5.3244545 × 10⁹
Variance	2.818829 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
479900	7	1.8%
85000	6	1.6%
462900	6	1.6%
85900	6	1.6%
133500	5	1.3%
465400	5	1.3%
81400	5	1.3%
481500	5	1.3%
318900	4	1.0%
304500	4	1.0%
Other values (292)	331	86.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
78000	1	0.3%
81400	5	1.3%
85000	6	1.6%
85900	6	1.6%
133500	5	1.3%
140320	1	0.3%
295200	1	0.3%
304500	4	1.0%
309700	1	0.3%
315150	1	0.3%

Value	Count	Frequency (%)
57227920	1	0.3%
56830960	1	0.3%
55752020	1	0.3%
53565730	1	0.3%
52399940	1	0.3%
51955990	1	0.3%
50544660	1	0.3%
50034470	1	0.3%
49842950	1	0.3%
49334550	1	0.3%

공업용
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	61
Distinct (%)	15.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9013368.3

Minimum	0
Maximum	2.0387918 × 10⁸
Zeros	312
Zeros (%)	81.2%
Negative	0
Negative (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	96513357
Maximum	2.0387918 × 10⁸
Range	2.0387918 × 10⁸
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	34810656
Coefficient of variation (CV)	3.862114
Kurtosis	16.512068
Mean	9013368.3
Median Absolute Deviation (MAD)	0
Skewness	4.1466391
Sum	3.4611334 × 10⁹
Variance	1.2117818 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	312	81.2%
379000	6	1.6%
495400	5	1.3%
3374900	2	0.5%
3684500	2	0.5%
2925700	2	0.5%
186554980	1	0.3%
91825930	1	0.3%
5213360	1	0.3%
104763900	1	0.3%
Other values (51)	51	13.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	312	81.2%
379000	6	1.6%
495400	5	1.3%
497800	1	0.3%
2920100	1	0.3%
2923500	1	0.3%
2925700	2	0.5%
2977700	1	0.3%
2983100	1	0.3%
3329400	1	0.3%

Value	Count	Frequency (%)
203879180	1	0.3%
198040210	1	0.3%
188728420	1	0.3%
188203720	1	0.3%
186554980	1	0.3%
183452010	1	0.3%
171307920	1	0.3%
167343570	1	0.3%
165193630	1	0.3%
160554260	1	0.3%

온천수계
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	35
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	553238.83

Minimum	0
Maximum	12009000
Zeros	334
Zeros (%)	87.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	2151410.8
Coefficient of variation (CV)	3.8887559
Kurtosis	13.177578
Mean	553238.83
Median Absolute Deviation (MAD)	0
Skewness	3.8225029
Sum	2.1244371 × 10⁸
Variance	4.6285683 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
0	334	87.0%
96600	10	2.6%
109000	5	1.3%
86800	3	0.8%
117800	2	0.5%
8316400	1	0.3%
380000	1	0.3%
7819200	1	0.3%
6592400	1	0.3%
2280	1	0.3%
Other values (25)	25	6.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	334	87.0%
2280	1	0.3%
80000	1	0.3%
82100	1	0.3%
86800	3	0.8%
96130	1	0.3%
96600	10	2.6%
109000	5	1.3%
117800	2	0.5%
140000	1	0.3%

Value	Count	Frequency (%)
12009000	1	0.3%
11071150	1	0.3%
10403300	1	0.3%
10342600	1	0.3%
10139650	1	0.3%
9887900	1	0.3%
9812750	1	0.3%
9742150	1	0.3%
9723150	1	0.3%
9161200	1	0.3%

온천영업용
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	32
Distinct (%)	8.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	214361.67

Minimum	0
Maximum	5396700
Zeros	334
Zeros (%)	87.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	895713.1
Coefficient of variation (CV)	4.1785134
Kurtosis	20.420482
Mean	214361.67
Median Absolute Deviation (MAD)	0
Skewness	4.5611156
Sum	82314880
Variance	8.0230195 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
0	334	87.0%
35600	12	3.1%
41700	6	1.6%
48500	3	0.8%
79500	2	0.5%
3975300	1	0.3%
2280	1	0.3%
1570900	1	0.3%
380000	1	0.3%
4446600	1	0.3%
Other values (22)	22	5.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	334	87.0%
2280	1	0.3%
35600	12	3.1%
41700	6	1.6%
48500	3	0.8%
72700	1	0.3%
79500	2	0.5%
380000	1	0.3%
1559900	1	0.3%
1570900	1	0.3%

Value	Count	Frequency (%)
5396700	1	0.3%
5249600	1	0.3%
5235600	1	0.3%
5152500	1	0.3%
5062100	1	0.3%
4834400	1	0.3%
4814000	1	0.3%
4715600	1	0.3%
4495600	1	0.3%
4446600	1	0.3%

온천일반
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	28
Distinct (%)	7.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34703.906

Minimum	0
Maximum	1444000
Zeros	336
Zeros (%)	87.5%
Negative	0
Negative (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	159640.53
Coefficient of variation (CV)	4.6000738
Kurtosis	34.496806
Mean	34703.906
Median Absolute Deviation (MAD)	0
Skewness	5.6551566
Sum	13326300
Variance	2.5485099 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
0	336	87.5%
18600	12	3.1%
9300	6	1.6%
38300	6	1.6%
593500	1	0.3%
238500	1	0.3%
1444000	1	0.3%
99500	1	0.3%
1051000	1	0.3%
205500	1	0.3%
Other values (18)	18	4.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	336	87.5%
9300	6	1.6%
18600	12	3.1%
38300	6	1.6%
69500	1	0.3%
99500	1	0.3%
105500	1	0.3%
119000	1	0.3%
156500	1	0.3%
199500	1	0.3%

Value	Count	Frequency (%)
1444000	1	0.3%
1136500	1	0.3%
1051000	1	0.3%
986500	1	0.3%
847000	1	0.3%
782500	1	0.3%
758500	1	0.3%
757000	1	0.3%
745000	1	0.3%
599500	1	0.3%

온천목욕용
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	29
Distinct (%)	7.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	304173.26

Minimum	0
Maximum	8677000
Zeros	336
Zeros (%)	87.5%
Negative	0
Negative (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	1252507
Coefficient of variation (CV)	4.117742
Kurtosis	19.554195
Mean	304173.26
Median Absolute Deviation (MAD)	0
Skewness	4.4157997
Sum	1.1680253 × 10⁸
Variance	1.5687738 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
0	336	87.5%
29000	12	3.1%
42400	10	2.6%
2599450	1	0.3%
3582300	1	0.3%
6456850	1	0.3%
3468300	1	0.3%
5560050	1	0.3%
2745350	1	0.3%
5582850	1	0.3%
Other values (19)	19	4.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	336	87.5%
27900	1	0.3%
29000	12	3.1%
41930	1	0.3%
42400	10	2.6%
2417600	1	0.3%
2599450	1	0.3%
2745350	1	0.3%
2803300	1	0.3%
2872650	1	0.3%

Value	Count	Frequency (%)
8677000	1	0.3%
7802050	1	0.3%
7293800	1	0.3%
6914750	1	0.3%
6673450	1	0.3%
6456850	1	0.3%
5944800	1	0.3%
5659800	1	0.3%
5582850	1	0.3%
5560050	1	0.3%

타이틀
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	3.1 KiB

기본요금집계(고지)	192
사용료집계(고지)	192

Length

Max length	10
Median length	9.5
Mean length	9.5
Min length	9

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	기본요금집계(고지)
2nd row	기본요금집계(고지)
3rd row	기본요금집계(고지)
4th row	기본요금집계(고지)
5th row	기본요금집계(고지)

Common Values

Value	Count	Frequency (%)
기본요금집계(고지)	192	50.0%
사용료집계(고지)	192	50.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
기본요금집계(고지	192	50.0%
사용료집계(고지	192	50.0%

Heatmap
Table

	연번	고지년월	통계구분	사업소코드	사업소명	구코드	구명	생활용수계	가정용	영업용	욕탕용	공업용	온천수계	온천영업용	온천일반	온천목욕용	타이틀
연번	1.000	0.957	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
고지년월	0.957	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
통계구분	0.000	0.000	1.000	0.000	0.000	0.000	0.000	1.000	0.995	1.000	0.986	0.324	0.213	0.213	0.187	0.217	1.000
사업소코드	0.000	0.000	0.000	1.000	1.000	1.000	1.000	0.754	0.747	0.527	0.373	0.266	0.091	0.188	0.061	0.091	0.000
사업소명	0.000	0.000	0.000	1.000	1.000	0.946	1.000	0.716	0.740	0.640	0.638	0.660	0.355	0.511	0.374	0.430	0.000
구코드	0.000	0.000	0.000	1.000	0.946	1.000	1.000	0.600	0.664	0.498	0.532	0.451	0.280	0.420	0.355	0.371	0.000
구명	0.000	0.000	0.000	1.000	1.000	1.000	1.000	0.771	0.817	0.700	0.746	0.670	0.473	0.637	0.533	0.557	0.000
생활용수계	0.000	0.000	1.000	0.754	0.716	0.600	0.771	1.000	0.946	0.941	0.866	0.626	0.549	0.654	0.548	0.668	1.000
가정용	0.000	0.000	0.995	0.747	0.740	0.664	0.817	0.946	1.000	0.902	0.854	0.595	0.578	0.695	0.584	0.654	0.995
영업용	0.000	0.000	1.000	0.527	0.640	0.498	0.700	0.941	0.902	1.000	0.865	0.641	0.456	0.522	0.470	0.529	1.000
욕탕용	0.000	0.000	0.986	0.373	0.638	0.532	0.746	0.866	0.854	0.865	1.000	0.628	0.482	0.568	0.451	0.532	0.986
공업용	0.000	0.000	0.324	0.266	0.660	0.451	0.670	0.626	0.595	0.641	0.628	1.000	0.000	0.000	0.000	0.000	0.324
온천수계	0.000	0.000	0.213	0.091	0.355	0.280	0.473	0.549	0.578	0.456	0.482	0.000	1.000	0.955	0.851	0.885	0.213
온천영업용	0.000	0.000	0.213	0.188	0.511	0.420	0.637	0.654	0.695	0.522	0.568	0.000	0.955	1.000	0.845	0.891	0.213
온천일반	0.000	0.000	0.187	0.061	0.374	0.355	0.533	0.548	0.584	0.470	0.451	0.000	0.851	0.845	1.000	0.952	0.187
온천목욕용	0.000	0.000	0.217	0.091	0.430	0.371	0.557	0.668	0.654	0.529	0.532	0.000	0.885	0.891	0.952	1.000	0.217
타이틀	0.000	0.000	1.000	0.000	0.000	0.000	0.000	1.000	0.995	1.000	0.986	0.324	0.213	0.213	0.187	0.217	1.000

Heatmap
Table

	구명	타이틀	사업소명	통계구분
구명	1.000	0.000	0.993	0.000
타이틀	0.000	1.000	0.000	0.995
사업소명	0.993	0.000	1.000	0.000
통계구분	0.000	0.995	0.000	1.000

Heatmap
Table

	연번	사업소코드	구코드	생활용수계	가정용	영업용	욕탕용	공업용	온천수계	온천영업용	온천일반	온천목욕용	통계구분	사업소명	구명	타이틀
연번	1.000	0.041	0.021	0.094	0.071	0.110	0.063	0.026	0.001	0.005	-0.004	-0.007	0.000	0.000	0.000	0.000
사업소코드	0.041	1.000	0.470	0.192	0.076	0.234	-0.032	0.529	-0.077	-0.064	-0.089	-0.094	0.000	0.989	0.983	0.000
구코드	0.021	0.470	1.000	0.159	0.076	0.193	-0.113	0.387	-0.063	-0.060	-0.084	-0.085	0.000	0.837	0.989	0.000
생활용수계	0.094	0.192	0.159	1.000	0.960	0.975	0.875	0.220	0.194	0.197	0.199	0.198	0.989	0.404	0.432	0.989
가정용	0.071	0.076	0.076	0.960	1.000	0.895	0.904	0.044	0.211	0.213	0.214	0.214	0.928	0.430	0.494	0.928
영업용	0.110	0.234	0.193	0.975	0.895	1.000	0.834	0.286	0.146	0.150	0.149	0.148	0.989	0.336	0.360	0.989
욕탕용	0.063	-0.032	-0.113	0.875	0.904	0.834	1.000	0.010	0.180	0.182	0.179	0.179	0.889	0.334	0.405	0.889
공업용	0.026	0.529	0.387	0.220	0.044	0.286	0.010	1.000	-0.184	-0.184	-0.180	-0.180	0.232	0.412	0.395	0.232
온천수계	0.001	-0.077	-0.063	0.194	0.211	0.146	0.180	-0.184	1.000	0.999	0.979	0.979	0.226	0.182	0.236	0.226
온천영업용	0.005	-0.064	-0.060	0.197	0.213	0.150	0.182	-0.184	0.999	1.000	0.978	0.978	0.226	0.281	0.352	0.226
온천일반	-0.004	-0.089	-0.084	0.199	0.214	0.149	0.179	-0.180	0.979	0.978	1.000	0.999	0.185	0.178	0.250	0.185
온천목욕용	-0.007	-0.094	-0.085	0.198	0.214	0.148	0.179	-0.180	0.979	0.978	0.999	1.000	0.214	0.210	0.265	0.214
통계구분	0.000	0.000	0.000	0.989	0.928	0.989	0.889	0.232	0.226	0.226	0.185	0.214	1.000	0.000	0.000	0.995
사업소명	0.000	0.989	0.837	0.404	0.430	0.336	0.334	0.412	0.182	0.281	0.178	0.210	0.000	1.000	0.993	0.000
구명	0.000	0.983	0.989	0.432	0.494	0.360	0.405	0.395	0.236	0.352	0.250	0.265	0.000	0.993	1.000	0.000
타이틀	0.000	0.000	0.000	0.989	0.928	0.989	0.889	0.232	0.226	0.226	0.185	0.214	0.995	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

	연번	고지년월	통계구분	사업소코드	사업소명	구코드	구명	생활용수계	가정용	영업용	욕탕용	온천수계	온천영업용	온천일반	온천목욕용	타이틀
0	1	2022-01	기본요금	244	동래통합사업소	260	동래구	50631910	29431780	20581030	619100	96600	35600	18600	42400	기본요금집계(고지)
1	2	2022-01	기본요금	244	동래통합사업소	410	금정구	46026030	30952410	14688020	385600	0	0	0	0	기본요금집계(고지)
2	3	2022-01	기본요금	244	동래통합사업소	470	연제구	36357900	20518380	15389420	450100	0	0	0	0	기본요금집계(고지)
3	4	2022-01	기본요금	301	중동부 사업소	110	중구	18705310	8191350	10194960	319000	0	0	0	0	기본요금집계(고지)
4	5	2022-01	기본요금	301	중동부 사업소	170	동구	32598770	17003620	15132250	462900	0	0	0	0	기본요금집계(고지)
5	6	2022-01	기본요금	302	서부 사업소	140	서구	33317200	21025910	11911990	379300	0	0	0	0	기본요금집계(고지)
6	7	2022-01	기본요금	303	영도 사업소	200	영도구	33914940	21147110	12287930	479900	0	0	0	0	기본요금집계(고지)
7	8	2022-01	기본요금	304	부산진 사업소	230	부산진구	78628930	44575650	33357680	695600	0	0	0	0	기본요금집계(고지)
8	9	2022-01	기본요금	306	남부 사업소	290	남구	57518300	35907290	21040210	570800	0	0	0	0	기본요금집계(고지)
9	10	2022-01	기본요금	306	남부 사업소	500	수영구	35344890	21194390	13713800	436700	0	0	0	0	기본요금집계(고지)

	연번	고지년월	통계구분	사업소코드	사업소명	구코드	구명	생활용수계	가정용	영업용	욕탕용	공업용	온천수계	온천영업용	온천일반	온천목욕용	타이틀
374	375	2022-12	사용료	303	영도 사업소	200	영도구	694697660	386099760	288040900	20557000	0	0	0	0	0	사용료집계(고지)
375	376	2022-12	사용료	304	부산진 사업소	230	부산진구	2218807580	1113381540	1060130300	45295740	0	0	0	0	0	사용료집계(고지)
376	377	2022-12	사용료	306	남부 사업소	290	남구	1808678380	855413540	904277540	48987300	0	0	0	0	0	사용료집계(고지)
377	378	2022-12	사용료	306	남부 사업소	500	수영구	1194334940	622611020	533940440	37783480	0	0	0	0	0	사용료집계(고지)
378	379	2022-12	사용료	307	북부 사업소	320	북구	1457539620	1020222290	414925210	22392120	0	0	0	0	0	사용료집계(고지)
379	380	2022-12	사용료	307	북부 사업소	530	사상구	1668514220	718910200	930514680	14888440	4200900	0	0	0	0	사용료집계(고지)
380	381	2022-12	사용료	308	해운대 사업소	350	해운대구	2769336290	1445492870	1273808950	50034470	0	8316400	4495600	238500	3582300	사용료집계(고지)
381	382	2022-12	사용료	309	사하 사업소	380	사하구	2292690980	1026662780	1116974350	57227920	91825930	0	0	0	0	사용료집계(고지)
382	383	2022-12	사용료	311	강서 사업소	440	강서구	2170986070	547711360	1422874810	13844920	186554980	0	0	0	0	사용료집계(고지)
383	384	2022-12	사용료	312	기장 사업소	710	기장군	1425473970	656590560	763560430	5322980	0	0	0	0	0	사용료집계(고지)

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values

Length

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample