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	부산광역시상수도사업본부_수용가정보시스템_고지집계정보_당초고지집계_20220131
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 336 (87.5%) zeros	Zeros
`온천영업용` has 336 (87.5%) zeros	Zeros
`온천일반` has 336 (87.5%) zeros	Zeros
`온천목욕용` has 336 (87.5%) zeros	Zeros

Reproduction

Analysis started	2023-12-10 17:28:00.656549
Analysis finished	2023-12-10 17:28:37.183739
Duration	36.53 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	2021-01-01 00:00:00
Maximum	2021-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.6943817 × 10⁸

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

Quantile statistics

Minimum	18650410
5-th percentile	32385376
Q1	44140362
median	2.4122958 × 10⁸
Q3	1.4720982 × 10⁹
95-th percentile	2.427223 × 10⁹
Maximum	3.1088824 × 10⁹
Range	3.090232 × 10⁹
Interquartile range (IQR)	1.4279578 × 10⁹

Descriptive statistics

Standard deviation	8.6121664 × 10⁸
Coefficient of variation (CV)	1.1192799
Kurtosis	-0.65267308
Mean	7.6943817 × 10⁸
Median Absolute Deviation (MAD)	2.2082266 × 10⁸
Skewness	0.80201346
Sum	2.9546426 × 10¹¹
Variance	7.416941 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
49153760	1	0.3%
46215440	1	0.3%
78431570	1	0.3%
33954670	1	0.3%
33457640	1	0.3%
32369290	1	0.3%
18758850	1	0.3%
36158330	1	0.3%
46167500	1	0.3%
50117100	1	0.3%
Other values (374)	374	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18650410	1	0.3%
18700050	1	0.3%
18740050	1	0.3%
18744690	1	0.3%
18758850	1	0.3%
18775440	1	0.3%
20353830	1	0.3%
20396780	1	0.3%
20417050	1	0.3%
20439750	1	0.3%

Value	Count	Frequency (%)
3108882390	1	0.3%
2947759980	1	0.3%
2852803370	1	0.3%
2827768080	1	0.3%
2793467910	1	0.3%
2781206660	1	0.3%
2771494660	1	0.3%
2712523410	1	0.3%
2705037230	1	0.3%
2675961430	1	0.3%

가정용
Real number (ℝ)

HIGH CORRELATION UNIQUE

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

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

Quantile statistics

Minimum	5955570
5-th percentile	14711088
Q1	24023490
median	67913315
Q3	7.5326926 × 10⁸
95-th percentile	1.2454763 × 10⁹
Maximum	1.7238164 × 10⁹
Range	1.7178608 × 10⁹
Interquartile range (IQR)	7.2924577 × 10⁸

Descriptive statistics

Standard deviation	4.6220039 × 10⁸
Coefficient of variation (CV)	1.1541437
Kurtosis	-0.4762143
Mean	4.0047039 × 10⁸
Median Absolute Deviation (MAD)	59691900
Skewness	0.88621428
Sum	1.5378063 × 10¹¹
Variance	2.136292 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28907690	1	0.3%
31119750	1	0.3%
44587610	1	0.3%
21225780	1	0.3%
21246580	1	0.3%
17146230	1	0.3%
8160670	1	0.3%
20367860	1	0.3%
31130800	1	0.3%
29383270	1	0.3%
Other values (374)	374	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5955570	1	0.3%
5960500	1	0.3%
6046330	1	0.3%
6077120	1	0.3%
6105840	1	0.3%
6120500	1	0.3%
8160670	1	0.3%
8160830	1	0.3%
8177410	1	0.3%
8205490	1	0.3%

Value	Count	Frequency (%)
1723816400	1	0.3%
1654894510	1	0.3%
1621447130	1	0.3%
1583176910	1	0.3%
1567834140	1	0.3%
1545380780	1	0.3%
1543722980	1	0.3%
1542807700	1	0.3%
1515358650	1	0.3%
1508397600	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.4758182 × 10⁸

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

Quantile statistics

Minimum	8877640
5-th percentile	10716436
Q1	15054162
median	1.4967791 × 10⁸
Q3	5.5062123 × 10⁸
95-th percentile	1.1250564 × 10⁹
Maximum	1.43911 × 10⁹
Range	1.4302323 × 10⁹
Interquartile range (IQR)	5.3556707 × 10⁸

Descriptive statistics

Standard deviation	3.9884433 × 10⁸
Coefficient of variation (CV)	1.1474833
Kurtosis	-0.29523684
Mean	3.4758182 × 10⁸
Median Absolute Deviation (MAD)	1.4025053 × 10⁸
Skewness	0.9390676
Sum	1.3347142 × 10¹¹
Variance	1.590768 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19608370	1	0.3%
14703290	1	0.3%
33123660	1	0.3%
12230390	1	0.3%
11831760	1	0.3%
14760160	1	0.3%
10279180	1	0.3%
15322470	1	0.3%
14644300	1	0.3%
20105430	1	0.3%
Other values (374)	374	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8877640	1	0.3%
8882180	1	0.3%
8934800	1	0.3%
8984860	1	0.3%
8984940	1	0.3%
9027180	1	0.3%
9417730	1	0.3%
9417900	1	0.3%
9425900	1	0.3%
9428860	1	0.3%

Value	Count	Frequency (%)
1439109980	1	0.3%
1394016540	1	0.3%
1393174370	1	0.3%
1362759320	1	0.3%
1351224370	1	0.3%
1320079430	1	0.3%
1278369930	1	0.3%
1276909750	1	0.3%
1267315280	1	0.3%
1253338800	1	0.3%

욕탕용
Real number (ℝ)

HIGH CORRELATION

Distinct	299
Distinct (%)	77.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12973753

Minimum	81400
Maximum	60699670
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 KiB

Quantile statistics

Minimum	81400
5-th percentile	133500
Q1	457267.5
median	1937580
Q3	27540370
95-th percentile	41995611
Maximum	60699670
Range	60618270
Interquartile range (IQR)	27083102

Descriptive statistics

Standard deviation	15757244
Coefficient of variation (CV)	1.2145478
Kurtosis	-0.48836633
Mean	12973753
Median Absolute Deviation (MAD)	1856180
Skewness	0.92186348
Sum	4.9819211 × 10⁹
Variance	2.4829073 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
319000	9	2.3%
637700	6	1.6%
578600	6	1.6%
421300	6	1.6%
85000	6	1.6%
379300	5	1.3%
133500	5	1.3%
321300	5	1.3%
81400	5	1.3%
427400	5	1.3%
Other values (289)	326	84.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
81400	5	1.3%
81850	1	0.3%
85000	6	1.6%
85900	2	0.5%
105600	1	0.3%
114900	3	0.8%
133500	5	1.3%
134430	1	0.3%
306800	1	0.3%
319000	9	2.3%

Value	Count	Frequency (%)
60699670	1	0.3%
56643010	1	0.3%
56000760	1	0.3%
55511720	1	0.3%
51642500	1	0.3%
50566470	1	0.3%
48997220	1	0.3%
48261510	1	0.3%
48003100	1	0.3%
47862750	1	0.3%

공업용
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	64
Distinct (%)	16.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8412211.7

Minimum	0
Maximum	1.7944481 × 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	96428555
Maximum	1.7944481 × 10⁸
Range	1.7944481 × 10⁸
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	32014469
Coefficient of variation (CV)	3.8057137
Kurtosis	15.393826
Mean	8412211.7
Median Absolute Deviation (MAD)	0
Skewness	4.0318319
Sum	3.2302893 × 10⁹
Variance	1.0249262 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	312	81.2%
454600	2	0.5%
379000	2	0.5%
497800	2	0.5%
3695200	2	0.5%
3753800	2	0.5%
335800	2	0.5%
3353200	2	0.5%
3039200	2	0.5%
3418600	2	0.5%
Other values (54)	54	14.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	312	81.2%
330400	1	0.3%
335800	2	0.5%
365060	1	0.3%
379000	2	0.5%
449200	1	0.3%
454600	2	0.5%
497800	2	0.5%
501200	1	0.3%
2931100	1	0.3%

Value	Count	Frequency (%)
179444810	1	0.3%
177777340	1	0.3%
176894730	1	0.3%
172982260	1	0.3%
169154810	1	0.3%
157811100	1	0.3%
154511700	1	0.3%
151026870	1	0.3%
150349600	1	0.3%
150022170	1	0.3%

온천수계
Real number (ℝ)

HIGH CORRELATION ZEROS

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

Minimum	0
Maximum	11125250
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	7804802.5
Maximum	11125250
Range	11125250
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2181337.9
Coefficient of variation (CV)	3.8676338
Kurtosis	12.464069
Mean	563998.05
Median Absolute Deviation (MAD)	0
Skewness	3.7529315
Sum	2.1657525 × 10⁸
Variance	4.7582351 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
0	336	87.5%
96600	12	3.1%
117800	6	1.6%
140000	6	1.6%
8508300	1	0.3%
9904950	1	0.3%
9326150	1	0.3%
8417350	1	0.3%
7020550	1	0.3%
9031350	1	0.3%
Other values (18)	18	4.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	336	87.5%
96600	12	3.1%
117800	6	1.6%
140000	6	1.6%
6372550	1	0.3%
6710750	1	0.3%
6736000	1	0.3%
7020550	1	0.3%
7943200	1	0.3%
8400300	1	0.3%

Value	Count	Frequency (%)
11125250	1	0.3%
10950050	1	0.3%
10647550	1	0.3%
10115700	1	0.3%
9905750	1	0.3%
9904950	1	0.3%
9571400	1	0.3%
9511250	1	0.3%
9399400	1	0.3%
9326150	1	0.3%

온천영업용
Real number (ℝ)

HIGH CORRELATION ZEROS

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

Minimum	0
Maximum	6144200
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	1668635
Maximum	6144200
Range	6144200
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	946653.25
Coefficient of variation (CV)	4.3028013
Kurtosis	22.591637
Mean	220008.59
Median Absolute Deviation (MAD)	0
Skewness	4.7849101
Sum	84483300
Variance	8.9615238 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
0	336	87.5%
35600	12	3.1%
79500	6	1.6%
72700	6	1.6%
2104400	1	0.3%
4927600	1	0.3%
2026300	1	0.3%
4698200	1	0.3%
1786500	1	0.3%
5142100	1	0.3%
Other values (18)	18	4.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	336	87.5%
35600	12	3.1%
72700	6	1.6%
79500	6	1.6%
1482900	1	0.3%
1580800	1	0.3%
1633600	1	0.3%
1667700	1	0.3%
1668800	1	0.3%
1699600	1	0.3%

Value	Count	Frequency (%)
6144200	1	0.3%
5744300	1	0.3%
5596900	1	0.3%
5499600	1	0.3%
5298300	1	0.3%
5180000	1	0.3%
5142100	1	0.3%
4964400	1	0.3%
4927600	1	0.3%
4698200	1	0.3%

온천일반
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	26
Distinct (%)	6.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33430.469

Minimum	0
Maximum	833500
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	216000
Maximum	833500
Range	833500
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	139326.13
Coefficient of variation (CV)	4.1676391
Kurtosis	19.540092
Mean	33430.469
Median Absolute Deviation (MAD)	0
Skewness	4.5142468
Sum	12837300
Variance	1.941177 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
0	336	87.5%
18600	12	3.1%
9300	6	1.6%
38300	6	1.6%
809500	2	0.5%
588000	2	0.5%
643000	1	0.3%
237000	1	0.3%
748000	1	0.3%
105500	1	0.3%
Other values (16)	16	4.2%

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%
62000	1	0.3%
92000	1	0.3%
105500	1	0.3%
190500	1	0.3%
220500	1	0.3%
237000	1	0.3%

Value	Count	Frequency (%)
833500	1	0.3%
812500	1	0.3%
809500	2	0.5%
782500	1	0.3%
748000	1	0.3%
671500	1	0.3%
670000	1	0.3%
652000	1	0.3%
643000	1	0.3%
596500	1	0.3%

온천목욕용
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	27
Distinct (%)	7.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	310558.98

Minimum	0
Maximum	8734950
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	3585292.5
Maximum	8734950
Range	8734950
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1255767
Coefficient of variation (CV)	4.04357
Kurtosis	18.331931
Mean	310558.98
Median Absolute Deviation (MAD)	0
Skewness	4.2740141
Sum	1.1925465 × 10⁸
Variance	1.5769507 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
0	336	87.5%
42400	12	3.1%
29000	12	3.1%
5733900	1	0.3%
4740350	1	0.3%
6551850	1	0.3%
3613650	1	0.3%
4562550	1	0.3%
3668750	1	0.3%
4032450	1	0.3%
Other values (17)	17	4.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	336	87.5%
29000	12	3.1%
42400	12	3.1%
2939150	1	0.3%
3241250	1	0.3%
3312500	1	0.3%
3424600	1	0.3%
3613650	1	0.3%
3668750	1	0.3%
3722900	1	0.3%

Value	Count	Frequency (%)
8734950	1	0.3%
7595900	1	0.3%
7372650	1	0.3%
7061050	1	0.3%
6551850	1	0.3%
5922000	1	0.3%
5874500	1	0.3%
5733900	1	0.3%
4761250	1	0.3%
4740350	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.985	0.213	0.324	0.324	0.209	0.296	1.000
사업소코드	0.000	0.000	0.000	1.000	1.000	1.000	1.000	0.741	0.724	0.506	0.240	0.171	0.188	0.188	0.057	0.188	0.000
사업소명	0.000	0.000	0.000	1.000	1.000	0.946	1.000	0.717	0.727	0.666	0.569	0.627	0.399	0.546	0.404	0.429	0.000
구코드	0.000	0.000	0.000	1.000	0.946	1.000	1.000	0.593	0.658	0.510	0.401	0.420	0.317	0.451	0.356	0.497	0.000
구명	0.000	0.000	0.000	1.000	1.000	1.000	1.000	0.769	0.806	0.725	0.653	0.637	0.520	0.670	0.538	0.640	0.000
생활용수계	0.000	0.000	1.000	0.741	0.717	0.593	0.769	1.000	0.949	0.941	0.835	0.628	0.594	0.641	0.588	0.601	1.000
가정용	0.000	0.000	0.995	0.724	0.727	0.658	0.806	0.949	1.000	0.886	0.820	0.534	0.594	0.722	0.685	0.631	0.995
영업용	0.000	0.000	1.000	0.506	0.666	0.510	0.725	0.941	0.886	1.000	0.834	0.727	0.455	0.530	0.491	0.464	1.000
욕탕용	0.000	0.000	0.985	0.240	0.569	0.401	0.653	0.835	0.820	0.834	1.000	0.643	0.444	0.419	0.346	0.336	0.985
공업용	0.000	0.000	0.213	0.171	0.627	0.420	0.637	0.628	0.534	0.727	0.643	1.000	0.000	0.000	0.000	0.000	0.213
온천수계	0.000	0.000	0.324	0.188	0.399	0.317	0.520	0.594	0.594	0.455	0.444	0.000	1.000	0.903	0.849	0.858	0.324
온천영업용	0.000	0.000	0.324	0.188	0.546	0.451	0.670	0.641	0.722	0.530	0.419	0.000	0.903	1.000	0.961	0.860	0.324
온천일반	0.000	0.000	0.209	0.057	0.404	0.356	0.538	0.588	0.685	0.491	0.346	0.000	0.849	0.961	1.000	0.844	0.209
온천목욕용	0.000	0.000	0.296	0.188	0.429	0.497	0.640	0.601	0.631	0.464	0.336	0.000	0.858	0.860	0.844	1.000	0.296
타이틀	0.000	0.000	1.000	0.000	0.000	0.000	0.000	1.000	0.995	1.000	0.985	0.213	0.324	0.324	0.209	0.296	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.099	0.081	0.111	0.018	0.026	-0.007	-0.003	-0.005	-0.006	0.000	0.000	0.000	0.000
사업소코드	0.041	1.000	0.470	0.185	0.076	0.227	-0.054	0.529	-0.073	-0.068	-0.089	-0.095	0.000	0.989	0.983	0.000
구코드	0.021	0.470	1.000	0.151	0.069	0.183	-0.096	0.388	-0.079	-0.078	-0.084	-0.085	0.000	0.837	0.989	0.000
생활용수계	0.099	0.185	0.151	1.000	0.963	0.975	0.863	0.221	0.200	0.202	0.197	0.197	0.989	0.405	0.430	0.989
가정용	0.081	0.076	0.069	0.963	1.000	0.898	0.889	0.051	0.214	0.215	0.211	0.210	0.928	0.416	0.477	0.928
영업용	0.111	0.227	0.183	0.975	0.898	1.000	0.822	0.289	0.154	0.156	0.151	0.150	0.989	0.358	0.384	0.989
욕탕용	0.018	-0.054	-0.096	0.863	0.889	0.822	1.000	0.013	0.169	0.168	0.169	0.169	0.884	0.286	0.323	0.884
공업용	0.026	0.529	0.388	0.221	0.051	0.289	0.013	1.000	-0.180	-0.180	-0.180	-0.180	0.226	0.370	0.352	0.226
온천수계	-0.007	-0.073	-0.079	0.200	0.214	0.154	0.169	-0.180	1.000	0.999	0.999	0.998	0.232	0.216	0.277	0.232
온천영업용	-0.003	-0.068	-0.078	0.202	0.215	0.156	0.168	-0.180	0.999	1.000	0.998	0.998	0.232	0.316	0.395	0.232
온천일반	-0.005	-0.089	-0.084	0.197	0.211	0.151	0.169	-0.180	0.999	0.998	1.000	0.999	0.207	0.195	0.253	0.207
온천목욕용	-0.006	-0.095	-0.085	0.197	0.210	0.150	0.169	-0.180	0.998	0.998	0.999	1.000	0.220	0.218	0.275	0.220
통계구분	0.000	0.000	0.000	0.989	0.928	0.989	0.884	0.226	0.232	0.232	0.207	0.220	1.000	0.000	0.000	0.995
사업소명	0.000	0.989	0.837	0.405	0.416	0.358	0.286	0.370	0.216	0.316	0.195	0.218	0.000	1.000	0.993	0.000
구명	0.000	0.983	0.989	0.430	0.477	0.384	0.323	0.352	0.277	0.395	0.253	0.275	0.000	0.993	1.000	0.000
타이틀	0.000	0.000	0.000	0.989	0.928	0.989	0.884	0.226	0.232	0.232	0.207	0.220	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	2021-01	기본요금	244	동래통합사업소	260	동래구	49153760	28907690	19608370	637700	96600	35600	18600	42400	기본요금집계(고지)
1	2	2021-01	기본요금	244	동래통합사업소	410	금정구	46128330	31163080	14569950	395300	0	0	0	0	기본요금집계(고지)
2	3	2021-01	기본요금	244	동래통합사업소	470	연제구	35759370	20376490	14892180	490700	0	0	0	0	기본요금집계(고지)
3	4	2021-01	기본요금	301	중동부 사업소	110	중구	18740050	8233650	10158400	348000	0	0	0	0	기본요금집계(고지)
4	5	2021-01	기본요금	301	중동부 사업소	170	동구	32442640	17143380	14796060	503200	0	0	0	0	기본요금집계(고지)
5	6	2021-01	기본요금	302	서부 사업소	140	서구	33660260	21525310	11755650	379300	0	0	0	0	기본요금집계(고지)
6	7	2021-01	기본요금	303	영도 사업소	200	영도구	34185300	21481070	12181930	522300	0	0	0	0	기본요금집계(고지)
7	8	2021-01	기본요금	304	부산진 사업소	230	부산진구	78329770	44950600	32610070	769100	0	0	0	0	기본요금집계(고지)
8	9	2021-01	기본요금	306	남부 사업소	290	남구	57847660	36189720	21044740	613200	0	0	0	0	기본요금집계(고지)
9	10	2021-01	기본요금	306	남부 사업소	500	수영구	34804110	21022560	13306550	475000	0	0	0	0	기본요금집계(고지)

	연번	고지년월	통계구분	사업소코드	사업소명	구코드	구명	생활용수계	가정용	영업용	욕탕용	공업용	온천수계	온천영업용	온천일반	온천목욕용	타이틀
374	375	2021-12	사용료	303	영도 사업소	200	영도구	727153090	415953630	291502970	19696490	0	0	0	0	0	사용료집계(고지)
375	376	2021-12	사용료	304	부산진 사업소	230	부산진구	2174125290	1127925680	1004044400	42155210	0	0	0	0	0	사용료집계(고지)
376	377	2021-12	사용료	306	남부 사업소	290	남구	1843058620	896552160	898643710	47862750	0	0	0	0	0	사용료집계(고지)
377	378	2021-12	사용료	306	남부 사업소	500	수영구	1200418990	646448710	522735690	31234590	0	0	0	0	0	사용료집계(고지)
378	379	2021-12	사용료	307	북부 사업소	320	북구	1471920150	1045943800	405859770	20116580	0	0	0	0	0	사용료집계(고지)
379	380	2021-12	사용료	307	북부 사업소	530	사상구	1668277120	744900420	901429550	16698200	5248950	0	0	0	0	사용료집계(고지)
380	381	2021-12	사용료	308	해운대 사업소	350	해운대구	2771494660	1508397600	1226783530	36313530	0	9904950	4927600	237000	4740350	사용료집계(고지)
381	382	2021-12	사용료	309	사하 사업소	380	사하구	2328903740	1063394550	1112109300	55511720	97888170	0	0	0	0	사용료집계(고지)
382	383	2021-12	사용료	311	강서 사업소	440	강서구	2110793650	554772260	1362759320	15484730	177777340	0	0	0	0	사용료집계(고지)
383	384	2021-12	사용료	312	기장 사업소	710	기장군	1381466340	665069980	708853880	7542480	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