gimi9 Pandas Profiling

Dataset statistics

Number of variables	16
Number of observations	160
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	22.3 KiB
Average record size in memory	142.8 B

Variable types

Numeric	12
DateTime	1
Categorical	3

Dataset

Description	부산광역시상수도사업본부_수용가정보시스템_고지집계정보_당초고지집계_20210601
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 5 other fields	High correlation
`통계구분` is highly overall correlated with `연번` and 5 other fields	High correlation
`연번` is highly overall correlated with `통계구분` and 1 other fields	High correlation
`사업소코드` is highly overall correlated with `공업용`	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 130 (81.2%) zeros	Zeros
`온천수계` has 140 (87.5%) zeros	Zeros
`온천영업용` has 140 (87.5%) zeros	Zeros
`온천일반` has 140 (87.5%) zeros	Zeros
`온천목욕용` has 140 (87.5%) zeros	Zeros

Reproduction

Analysis started	2023-12-10 17:28:57.106674
Analysis finished	2023-12-10 17:29:33.617719
Duration	36.51 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연번
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	160
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	80.5

Minimum	1
Maximum	160
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

Minimum	1
5-th percentile	8.95
Q1	40.75
median	80.5
Q3	120.25
95-th percentile	152.05
Maximum	160
Range	159
Interquartile range (IQR)	79.5

Descriptive statistics

Standard deviation	46.332134
Coefficient of variation (CV)	0.57555446
Kurtosis	-1.2
Mean	80.5
Median Absolute Deviation (MAD)	40
Skewness	0
Sum	12880
Variance	2146.6667
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.6%
82	1	0.6%
104	1	0.6%
105	1	0.6%
106	1	0.6%
107	1	0.6%
108	1	0.6%
109	1	0.6%
110	1	0.6%
111	1	0.6%
Other values (150)	150	93.8%

Minimum 10 values
Maximum 10 values

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

Value	Count	Frequency (%)
160	1	0.6%
159	1	0.6%
158	1	0.6%
157	1	0.6%
156	1	0.6%
155	1	0.6%
154	1	0.6%
153	1	0.6%
152	1	0.6%
151	1	0.6%

고지년월
Date

Distinct	5
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 KiB

Minimum	2021-01-01 00:00:00
Maximum	2021-05-01 00:00:00

Histogram

Histogram with fixed size bins (bins=5)

통계구분
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	1.4 KiB

1	80
2	80

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
1	80	50.0%
2	80	50.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	80	50.0%
2	80	50.0%

사업소코드
Real number (ℝ)

HIGH CORRELATION

Distinct	11
Distinct (%)	6.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	1.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.445341
Coefficient of variation (CV)	0.083059132
Kurtosis	0.52576322
Mean	294.3125
Median Absolute Deviation (MAD)	3.5
Skewness	-1.5532923
Sum	47090
Variance	597.57469
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
244	30	18.8%
301	20	12.5%
306	20	12.5%
307	20	12.5%
302	10	6.2%
303	10	6.2%
304	10	6.2%
308	10	6.2%
309	10	6.2%
311	10	6.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
244	30	18.8%
301	20	12.5%
302	10	6.2%
303	10	6.2%
304	10	6.2%
306	20	12.5%
307	20	12.5%
308	10	6.2%
309	10	6.2%
311	10	6.2%

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

구코드
Real number (ℝ)

Distinct	16
Distinct (%)	10.0%
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	1.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.53481
Coefficient of variation (CV)	0.45745136
Kurtosis	-0.26323719
Mean	344.375
Median Absolute Deviation (MAD)	120
Skewness	0.49250642
Sum	55100
Variance	24817.217
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

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

Minimum 10 values
Maximum 10 values

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

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

생활용수계
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	160
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.36169 × 10⁸

Minimum	18700050
Maximum	2.7050372 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

Minimum	18700050
5-th percentile	32447751
Q1	43965705
median	2.411922 × 10⁸
Q3	1.4292248 × 10⁹
95-th percentile	2.3611626 × 10⁹
Maximum	2.7050372 × 10⁹
Range	2.6863372 × 10⁹
Interquartile range (IQR)	1.3852591 × 10⁹

Descriptive statistics

Standard deviation	8.2511775 × 10⁸
Coefficient of variation (CV)	1.1208265
Kurtosis	-0.66021191
Mean	7.36169 × 10⁸
Median Absolute Deviation (MAD)	2.1581114 × 10⁸
Skewness	0.81076454
Sum	1.1778704 × 10¹¹
Variance	6.8081929 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
49153760	1	0.6%
1189502440	1	0.6%
66750150	1	0.6%
47067730	1	0.6%
38528720	1	0.6%
34807680	1	0.6%
48028580	1	0.6%
64172500	1	0.6%
71440260	1	0.6%
59313120	1	0.6%
Other values (150)	150	93.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18700050	1	0.6%
18740050	1	0.6%
18744690	1	0.6%
20353830	1	0.6%
20396780	1	0.6%
30365360	1	0.6%
30478880	1	0.6%
32442640	1	0.6%
32448020	1	0.6%
32506670	1	0.6%

Value	Count	Frequency (%)
2705037230	1	0.6%
2675961430	1	0.6%
2629407900	1	0.6%
2583344060	1	0.6%
2489762610	1	0.6%
2454061990	1	0.6%
2412256770	1	0.6%
2367015160	1	0.6%
2360854620	1	0.6%
2359194160	1	0.6%

가정용
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	160
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.8713635 × 10⁸

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

Quantile statistics

Minimum	5955570
5-th percentile	14704298
Q1	23557300
median	67996705
Q3	7.3657278 × 10⁸
95-th percentile	1.1909316 × 10⁹
Maximum	1.5831769 × 10⁹
Range	1.5772213 × 10⁹
Interquartile range (IQR)	7.1301548 × 10⁸

Descriptive statistics

Standard deviation	4.4784866 × 10⁸
Coefficient of variation (CV)	1.1568241
Kurtosis	-0.44003681
Mean	3.8713635 × 10⁸
Median Absolute Deviation (MAD)	57175795
Skewness	0.90334091
Sum	6.1941816 × 10¹⁰
Variance	2.0056842 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28907690	1	0.6%
724888730	1	0.6%
39714480	1	0.6%
31858870	1	0.6%
23510330	1	0.6%
23527180	1	0.6%
23890990	1	0.6%
39683870	1	0.6%
41718510	1	0.6%
13413490	1	0.6%
Other values (150)	150	93.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5955570	1	0.6%
5960500	1	0.6%
8205490	1	0.6%
8209180	1	0.6%
8233650	1	0.6%
13408170	1	0.6%
13413490	1	0.6%
14688860	1	0.6%
14705110	1	0.6%
14744960	1	0.6%

Value	Count	Frequency (%)
1583176910	1	0.6%
1545380780	1	0.6%
1542807700	1	0.6%
1486574910	1	0.6%
1397904550	1	0.6%
1316155300	1	0.6%
1283199930	1	0.6%
1230353960	1	0.6%
1188856720	1	0.6%
1157431210	1	0.6%

업무용
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.4 KiB

0	160

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

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	160	100.0%

영업용
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	160
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.268258 × 10⁸

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

Quantile statistics

Minimum	8877640
5-th percentile	10838571
Q1	15011580
median	1.4933109 × 10⁸
Q3	5.0265956 × 10⁸
95-th percentile	1.0642496 × 10⁹
Maximum	1.3931744 × 10⁹
Range	1.3842967 × 10⁹
Interquartile range (IQR)	4.8764798 × 10⁸

Descriptive statistics

Standard deviation	3.7428299 × 10⁸
Coefficient of variation (CV)	1.1452063
Kurtosis	-0.29882679
Mean	3.268258 × 10⁸
Median Absolute Deviation (MAD)	1.3849278 × 10⁸
Skewness	0.93941015
Sum	5.2292129 × 10¹⁰
Variance	1.4008775 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19608370	1	0.6%
457649590	1	0.6%
26295670	1	0.6%
14615360	1	0.6%
14590990	1	0.6%
10838600	1	0.6%
23258090	1	0.6%
23910030	1	0.6%
25261050	1	0.6%
40080750	1	0.6%
Other values (150)	150	93.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8877640	1	0.6%
8882180	1	0.6%
9417730	1	0.6%
9436700	1	0.6%
10158400	1	0.6%
10171870	1	0.6%
10191200	1	0.6%
10838020	1	0.6%
10838600	1	0.6%
11309000	1	0.6%

Value	Count	Frequency (%)
1393174370	1	0.6%
1253169210	1	0.6%
1173271940	1	0.6%
1122968760	1	0.6%
1107725070	1	0.6%
1100427810	1	0.6%
1100292900	1	0.6%
1098677790	1	0.6%
1062437570	1	0.6%
1058197180	1	0.6%

욕탕용
Real number (ℝ)

HIGH CORRELATION

Distinct	132
Distinct (%)	82.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13868853

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

Quantile statistics

Minimum	81400
5-th percentile	132570
Q1	470675
median	2599075
Q3	31161215
95-th percentile	44083537
Maximum	60699670
Range	60618270
Interquartile range (IQR)	30690540

Descriptive statistics

Standard deviation	16706624
Coefficient of variation (CV)	1.2046147
Kurtosis	-0.54690141
Mean	13868853
Median Absolute Deviation (MAD)	2515650
Skewness	0.88929383
Sum	2.2190164 × 10⁹
Variance	2.7911129 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
637700	5	3.1%
348000	3	1.9%
379300	3	1.9%
578600	3	1.9%
421300	3	1.9%
427400	3	1.9%
392400	2	1.2%
319000	2	1.2%
81400	2	1.2%
85000	2	1.2%
Other values (122)	132	82.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
81400	2	1.2%
81850	1	0.6%
85000	2	1.2%
105600	1	0.6%
114900	2	1.2%
133500	2	1.2%
319000	2	1.2%
321300	2	1.2%
348000	3	1.9%
379300	3	1.9%

Value	Count	Frequency (%)
60699670	1	0.6%
56643010	1	0.6%
56000760	1	0.6%
51642500	1	0.6%
48003100	1	0.6%
47299000	1	0.6%
45704640	1	0.6%
44781930	1	0.6%
44046780	1	0.6%
42069810	1	0.6%

공업용
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	26
Distinct (%)	16.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8337994.5

Minimum	0
Maximum	1.7944481 × 10⁸
Zeros	130
Zeros (%)	81.2%
Negative	0
Negative (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	31782159
Coefficient of variation (CV)	3.811727
Kurtosis	15.698698
Mean	8337994.5
Median Absolute Deviation (MAD)	0
Skewness	4.0553257
Sum	1.3340791 × 10⁹
Variance	1.0101056 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
0	130	81.2%
3418600	2	1.2%
3039200	2	1.2%
454600	2	1.2%
3695200	2	1.2%
335800	2	1.2%
136172820	1	0.6%
151026870	1	0.6%
106188150	1	0.6%
5069830	1	0.6%
Other values (16)	16	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	130	81.2%
330400	1	0.6%
335800	2	1.2%
454600	2	1.2%
3024700	1	0.6%
3039200	2	1.2%
3384200	1	0.6%
3418600	2	1.2%
3695200	2	1.2%
5069830	1	0.6%

Value	Count	Frequency (%)
179444810	1	0.6%
169154810	1	0.6%
151026870	1	0.6%
150022170	1	0.6%
136172820	1	0.6%
106188150	1	0.6%
104789820	1	0.6%
98185760	1	0.6%
92285550	1	0.6%
79626000	1	0.6%

온천수계
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	14
Distinct (%)	8.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	625405.94

Minimum	0
Maximum	11125250
Zeros	140
Zeros (%)	87.5%
Negative	0
Negative (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	2409271.7
Coefficient of variation (CV)	3.8523326
Kurtosis	11.887297
Mean	625405.94
Median Absolute Deviation (MAD)	0
Skewness	3.6906638
Sum	1.0006495 × 10⁸
Variance	5.80459 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0	140	87.5%
96600	5	3.1%
117800	3	1.9%
140000	2	1.2%
11125250	1	0.6%
9399400	1	0.6%
9905750	1	0.6%
10647550	1	0.6%
10115700	1	0.6%
9571400	1	0.6%
Other values (4)	4	2.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	140	87.5%
96600	5	3.1%
117800	3	1.9%
140000	2	1.2%
8400300	1	0.6%
9321900	1	0.6%
9399400	1	0.6%
9511250	1	0.6%
9571400	1	0.6%
9905750	1	0.6%

Value	Count	Frequency (%)
11125250	1	0.6%
10950050	1	0.6%
10647550	1	0.6%
10115700	1	0.6%
9905750	1	0.6%
9571400	1	0.6%
9511250	1	0.6%
9399400	1	0.6%
9321900	1	0.6%
8400300	1	0.6%

온천영업용
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	14
Distinct (%)	8.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	226358.12

Minimum	0
Maximum	6144200
Zeros	140
Zeros (%)	87.5%
Negative	0
Negative (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	990534.36
Coefficient of variation (CV)	4.3759612
Kurtosis	23.695522
Mean	226358.12
Median Absolute Deviation (MAD)	0
Skewness	4.89463
Sum	36217300
Variance	9.8115832 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0	140	87.5%
35600	5	3.1%
79500	3	1.9%
72700	2	1.2%
1580800	1	0.6%
4964400	1	0.6%
1699600	1	0.6%
5298300	1	0.6%
1707300	1	0.6%
5744300	1	0.6%
Other values (4)	4	2.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	140	87.5%
35600	5	3.1%
72700	2	1.2%
79500	3	1.9%
1580800	1	0.6%
1667700	1	0.6%
1668800	1	0.6%
1699600	1	0.6%
1707300	1	0.6%
4964400	1	0.6%

Value	Count	Frequency (%)
6144200	1	0.6%
5744300	1	0.6%
5298300	1	0.6%
5180000	1	0.6%
4964400	1	0.6%
1707300	1	0.6%
1699600	1	0.6%
1668800	1	0.6%
1667700	1	0.6%
1580800	1	0.6%

온천일반
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	12
Distinct (%)	7.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40509.375

Minimum	0
Maximum	833500
Zeros	140
Zeros (%)	87.5%
Negative	0
Negative (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	160704.09
Coefficient of variation (CV)	3.967084
Kurtosis	16.257066
Mean	40509.375
Median Absolute Deviation (MAD)	0
Skewness	4.1509436
Sum	6481500
Variance	2.5825805 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	140	87.5%
18600	5	3.1%
9300	3	1.9%
809500	2	1.2%
38300	2	1.2%
588000	2	1.2%
239000	1	0.6%
833500	1	0.6%
812500	1	0.6%
402500	1	0.6%
Other values (2)	2	1.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	140	87.5%
9300	3	1.9%
18600	5	3.1%
38300	2	1.2%
239000	1	0.6%
402500	1	0.6%
419000	1	0.6%
588000	2	1.2%
782500	1	0.6%
809500	2	1.2%

Value	Count	Frequency (%)
833500	1	0.6%
812500	1	0.6%
809500	2	1.2%
782500	1	0.6%
588000	2	1.2%
419000	1	0.6%
402500	1	0.6%
239000	1	0.6%
38300	2	1.2%
18600	5	3.1%

온천목욕용
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	13
Distinct (%)	8.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	358538.44

Minimum	0
Maximum	8734950
Zeros	140
Zeros (%)	87.5%
Negative	0
Negative (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	1454511.1
Coefficient of variation (CV)	4.0567787
Kurtosis	17.512684
Mean	358538.44
Median Absolute Deviation (MAD)	0
Skewness	4.2318686
Sum	57366150
Variance	2.1156025 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
0	140	87.5%
42400	5	3.1%
29000	5	3.1%
8734950	1	0.6%
4196000	1	0.6%
7372650	1	0.6%
4761250	1	0.6%
7595900	1	0.6%
3424600	1	0.6%
7061050	1	0.6%
Other values (3)	3	1.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	140	87.5%
29000	5	3.1%
42400	5	3.1%
3424600	1	0.6%
3722900	1	0.6%
4196000	1	0.6%
4217850	1	0.6%
4761250	1	0.6%
5922000	1	0.6%
7061050	1	0.6%

Value	Count	Frequency (%)
8734950	1	0.6%
7595900	1	0.6%
7372650	1	0.6%
7061050	1	0.6%
5922000	1	0.6%
4761250	1	0.6%
4217850	1	0.6%
4196000	1	0.6%
3722900	1	0.6%
3424600	1	0.6%

타이틀
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	1.4 KiB

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

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 (%)
기본요금집계(고지)	80	50.0%
사용료집계(고지)	80	50.0%

Length

Histogram of lengths of the category

Common Values (Plot)

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

Heatmap
Table

	연번	고지년월	통계구분	사업소코드	구코드	생활용수계	가정용	영업용	욕탕용	공업용	온천수계	온천영업용	온천일반	온천목욕용	타이틀
연번	1.000	1.000	1.000	0.000	0.000	0.703	0.650	0.722	0.666	0.000	0.000	0.000	0.000	0.000	1.000
고지년월	1.000	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
통계구분	1.000	0.000	1.000	0.000	0.000	1.000	0.995	1.000	0.986	0.266	0.331	0.331	0.266	0.163	1.000
사업소코드	0.000	0.000	0.000	1.000	1.000	0.700	0.732	0.439	0.251	0.165	0.060	0.060	0.000	0.067	0.000
구코드	0.000	0.000	0.000	1.000	1.000	0.593	0.609	0.371	0.467	0.377	0.396	0.645	0.377	0.326	0.000
생활용수계	0.703	0.000	1.000	0.700	0.593	1.000	0.955	0.940	0.895	0.662	0.487	0.703	0.638	0.595	1.000
가정용	0.650	0.000	0.995	0.732	0.609	0.955	1.000	0.880	0.855	0.545	0.620	0.803	0.752	0.736	0.995
영업용	0.722	0.000	1.000	0.439	0.371	0.940	0.880	1.000	0.851	0.774	0.535	0.634	0.511	0.473	1.000
욕탕용	0.666	0.000	0.986	0.251	0.467	0.895	0.855	0.851	1.000	0.677	0.482	0.505	0.361	0.267	0.986
공업용	0.000	0.000	0.266	0.165	0.377	0.662	0.545	0.774	0.677	1.000	0.000	0.000	0.000	0.000	0.266
온천수계	0.000	0.000	0.331	0.060	0.396	0.487	0.620	0.535	0.482	0.000	1.000	0.910	0.865	0.918	0.331
온천영업용	0.000	0.000	0.331	0.060	0.645	0.703	0.803	0.634	0.505	0.000	0.910	1.000	0.987	0.923	0.331
온천일반	0.000	0.000	0.266	0.000	0.377	0.638	0.752	0.511	0.361	0.000	0.865	0.987	1.000	0.906	0.266
온천목욕용	0.000	0.000	0.163	0.067	0.326	0.595	0.736	0.473	0.267	0.000	0.918	0.923	0.906	1.000	0.163
타이틀	1.000	0.000	1.000	0.000	0.000	1.000	0.995	1.000	0.986	0.266	0.331	0.331	0.266	0.163	1.000

Heatmap
Table

	타이틀	통계구분
타이틀	1.000	0.987
통계구분	0.987	1.000

Heatmap
Table

	연번	사업소코드	구코드	생활용수계	가정용	영업용	욕탕용	공업용	온천수계	온천영업용	온천일반	온천목욕용	통계구분	타이틀
연번	1.000	0.099	0.051	0.171	0.150	0.189	0.126	0.059	-0.011	-0.006	-0.009	-0.012	0.974	0.974
사업소코드	0.099	1.000	0.470	0.176	0.080	0.220	-0.054	0.528	-0.075	-0.068	-0.091	-0.096	0.000	0.000
구코드	0.051	0.470	1.000	0.143	0.066	0.168	-0.100	0.388	-0.080	-0.078	-0.084	-0.086	0.000	0.000
생활용수계	0.171	0.176	0.143	1.000	0.966	0.975	0.861	0.218	0.204	0.206	0.201	0.201	0.974	0.974
가정용	0.150	0.080	0.066	0.966	1.000	0.906	0.883	0.058	0.208	0.209	0.205	0.204	0.912	0.912
영업용	0.189	0.220	0.168	0.975	0.906	1.000	0.823	0.288	0.158	0.160	0.155	0.154	0.974	0.974
욕탕용	0.126	-0.054	-0.100	0.861	0.883	0.823	1.000	0.009	0.147	0.147	0.147	0.148	0.875	0.875
공업용	0.059	0.528	0.388	0.218	0.058	0.288	0.009	1.000	-0.180	-0.180	-0.180	-0.180	0.188	0.188
온천수계	-0.011	-0.075	-0.080	0.204	0.208	0.158	0.147	-0.180	1.000	0.999	0.999	0.998	0.219	0.219
온천영업용	-0.006	-0.068	-0.078	0.206	0.209	0.160	0.147	-0.180	0.999	1.000	0.998	0.998	0.219	0.219
온천일반	-0.009	-0.091	-0.084	0.201	0.205	0.155	0.147	-0.180	0.999	0.998	1.000	0.999	0.188	0.188
온천목욕용	-0.012	-0.096	-0.086	0.201	0.204	0.154	0.148	-0.180	0.998	0.998	0.999	1.000	0.171	0.171
통계구분	0.974	0.000	0.000	0.974	0.912	0.974	0.875	0.188	0.219	0.219	0.188	0.171	1.000	0.987
타이틀	0.974	0.000	0.000	0.974	0.912	0.974	0.875	0.188	0.219	0.219	0.188	0.171	0.987	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	1	244	260	49153760	28907690	19608370	637700	96600	35600	18600	42400	기본요금집계(고지)
1	2	2021-01	1	244	410	46128330	31163080	14569950	395300	0	0	0	0	기본요금집계(고지)
2	3	2021-01	1	244	470	35759370	20376490	14892180	490700	0	0	0	0	기본요금집계(고지)
3	4	2021-01	1	301	110	18740050	8233650	10158400	348000	0	0	0	0	기본요금집계(고지)
4	5	2021-01	1	301	170	32442640	17143380	14796060	503200	0	0	0	0	기본요금집계(고지)
5	6	2021-01	1	302	140	33660260	21525310	11755650	379300	0	0	0	0	기본요금집계(고지)
6	7	2021-01	1	303	200	34185300	21481070	12181930	522300	0	0	0	0	기본요금집계(고지)
7	8	2021-01	1	304	230	78329770	44950600	32610070	769100	0	0	0	0	기본요금집계(고지)
8	9	2021-01	1	306	290	57847660	36189720	21044740	613200	0	0	0	0	기본요금집계(고지)
9	10	2021-01	1	306	500	34804110	21022560	13306550	475000	0	0	0	0	기본요금집계(고지)

	연번	고지년월	통계구분	사업소코드	구코드	생활용수계	가정용	영업용	욕탕용	공업용	온천수계	온천영업용	온천일반	온천목욕용	타이틀
150	151	2021-05	2	303	200	632694540	336132740	280777260	15784540	0	0	0	0	0	사용료집계(고지)
151	152	2021-05	2	304	230	2489762610	1283199930	1173271940	33290740	0	0	0	0	0	사용료집계(고지)
152	153	2021-05	2	306	290	2095797720	1033113380	1030551320	32133020	0	0	0	0	0	사용료집계(고지)
153	154	2021-05	2	306	500	999173010	560341320	399786890	39044800	0	0	0	0	0	사용료집계(고지)
154	155	2021-05	2	307	320	1590681450	1091872470	480449580	18359400	0	0	0	0	0	사용료집계(고지)
155	156	2021-05	2	307	530	1618237870	746061700	854206220	12900120	5069830	0	0	0	0	사용료집계(고지)
156	157	2021-05	2	308	350	2629407900	1486574910	1107725070	35107920	0	9321900	5180000	419000	3722900	사용료집계(고지)
157	158	2021-05	2	309	380	2317946260	1115195670	1050857800	45704640	106188150	0	0	0	0	사용료집계(고지)
158	159	2021-05	2	311	440	1425881400	511628900	747887800	15337830	151026870	0	0	0	0	사용료집계(고지)
159	160	2021-05	2	312	710	1194532010	647080670	542854550	4596790	0	0	0	0	0	사용료집계(고지)

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample