Overview

Dataset statistics

Number of variables26
Number of observations1211
Missing cells2536
Missing cells (%)8.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory259.1 KiB
Average record size in memory219.1 B

Variable types

Numeric7
Categorical10
DateTime8
Boolean1

Dataset

Description부산광역시상수도사업본부_수용가정보시스템_조례위반정보_조례위반대장_20230126
Author부산광역시 상수도사업본부
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15083424

Alerts

가산금 has constant value ""Constant
중가산횟수 is highly imbalanced (92.0%)Imbalance
할인금액 is highly imbalanced (73.6%)Imbalance
중가산금 is highly imbalanced (97.8%)Imbalance
중가산부과여부 is highly imbalanced (96.8%)Imbalance
수납일자 has 138 (11.4%) missing valuesMissing
중가산결정일 has 1199 (99.0%) missing valuesMissing
중가산기한일 has 1199 (99.0%) missing valuesMissing
조정량 is highly skewed (γ1 = 26.90378407)Skewed
연번 has unique valuesUnique
조정량 has 480 (39.6%) zerosZeros

Reproduction

Analysis started2023-12-10 16:15:57.701040
Analysis finished2023-12-10 16:15:58.260706
Duration0.56 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct1211
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean606
Minimum1
Maximum1211
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.8 KiB
2023-12-11T01:15:58.514247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile61.5
Q1303.5
median606
Q3908.5
95-th percentile1150.5
Maximum1211
Range1210
Interquartile range (IQR)605

Descriptive statistics

Standard deviation349.7299
Coefficient of variation (CV)0.57711204
Kurtosis-1.2
Mean606
Median Absolute Deviation (MAD)303
Skewness0
Sum733866
Variance122311
MonotonicityStrictly increasing
2023-12-11T01:15:58.797027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
815 1
 
0.1%
813 1
 
0.1%
812 1
 
0.1%
811 1
 
0.1%
810 1
 
0.1%
809 1
 
0.1%
808 1
 
0.1%
807 1
 
0.1%
806 1
 
0.1%
Other values (1201) 1201
99.2%
ValueCountFrequency (%)
1 1
0.1%
2 1
0.1%
3 1
0.1%
4 1
0.1%
5 1
0.1%
6 1
0.1%
7 1
0.1%
8 1
0.1%
9 1
0.1%
10 1
0.1%
ValueCountFrequency (%)
1211 1
0.1%
1210 1
0.1%
1209 1
0.1%
1208 1
0.1%
1207 1
0.1%
1206 1
0.1%
1205 1
0.1%
1204 1
0.1%
1203 1
0.1%
1202 1
0.1%

사업소코드
Real number (ℝ)

Distinct12
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean293.89761
Minimum201
Maximum312
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.8 KiB
2023-12-11T01:15:58.980455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum201
5-th percentile244
Q1302
median306
Q3309
95-th percentile312
Maximum312
Range111
Interquartile range (IQR)7

Descriptive statistics

Standard deviation26.136566
Coefficient of variation (CV)0.088930858
Kurtosis0.51616583
Mean293.89761
Median Absolute Deviation (MAD)3
Skewness-1.4926939
Sum355910
Variance683.12009
MonotonicityNot monotonic
2023-12-11T01:15:59.227120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
244 241
19.9%
304 160
13.2%
306 153
12.6%
311 126
10.4%
312 111
9.2%
307 105
8.7%
308 87
 
7.2%
309 80
 
6.6%
302 67
 
5.5%
301 43
 
3.6%
Other values (2) 38
 
3.1%
ValueCountFrequency (%)
201 6
 
0.5%
244 241
19.9%
301 43
 
3.6%
302 67
 
5.5%
303 32
 
2.6%
304 160
13.2%
306 153
12.6%
307 105
8.7%
308 87
 
7.2%
309 80
 
6.6%
ValueCountFrequency (%)
312 111
9.2%
311 126
10.4%
309 80
6.6%
308 87
7.2%
307 105
8.7%
306 153
12.6%
304 160
13.2%
303 32
 
2.6%
302 67
5.5%
301 43
 
3.6%

사업소명
Categorical

Distinct12
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size9.6 KiB
동래통합사업소
241 
부산진 사업소
160 
남부 사업소
153 
강서 사업소
126 
기장 사업소
111 
Other values (7)
420 

Length

Max length9
Median length9
Mean length8.3526012
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
동래통합사업소 241
19.9%
부산진 사업소 160
13.2%
남부 사업소 153
12.6%
강서 사업소 126
10.4%
기장 사업소 111
9.2%
북부 사업소 105
8.7%
해운대 사업소 87
 
7.2%
사하 사업소 80
 
6.6%
서부 사업소 67
 
5.5%
중동부 사업소 43
 
3.6%
Other values (2) 38
 
3.1%

Length

2023-12-11T01:15:59.450417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
사업소 964
44.3%
동래통합사업소 241
 
11.1%
부산진 160
 
7.4%
남부 153
 
7.0%
강서 126
 
5.8%
기장 111
 
5.1%
북부 105
 
4.8%
해운대 87
 
4.0%
사하 80
 
3.7%
서부 67
 
3.1%
Other values (3) 81
 
3.7%

접수일자
Date

Distinct170
Distinct (%)14.0%
Missing0
Missing (%)0.0%
Memory size9.6 KiB
Minimum2022-01-04 00:00:00
Maximum2022-12-29 00:00:00
2023-12-11T01:15:59.707616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:15:59.919939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

일련번호
Real number (ℝ)

Distinct11
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.3492981
Minimum1
Maximum11
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.8 KiB
2023-12-11T01:16:00.120181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q31
95-th percentile3
Maximum11
Range10
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.0449591
Coefficient of variation (CV)0.77444646
Kurtosis30.825405
Mean1.3492981
Median Absolute Deviation (MAD)0
Skewness4.9151307
Sum1634
Variance1.0919396
MonotonicityNot monotonic
2023-12-11T01:16:00.647613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
1 994
82.1%
2 132
 
10.9%
3 40
 
3.3%
4 17
 
1.4%
5 12
 
1.0%
7 4
 
0.3%
6 4
 
0.3%
10 2
 
0.2%
11 2
 
0.2%
9 2
 
0.2%
ValueCountFrequency (%)
1 994
82.1%
2 132
 
10.9%
3 40
 
3.3%
4 17
 
1.4%
5 12
 
1.0%
6 4
 
0.3%
7 4
 
0.3%
8 2
 
0.2%
9 2
 
0.2%
10 2
 
0.2%
ValueCountFrequency (%)
11 2
 
0.2%
10 2
 
0.2%
9 2
 
0.2%
8 2
 
0.2%
7 4
 
0.3%
6 4
 
0.3%
5 12
 
1.0%
4 17
 
1.4%
3 40
 
3.3%
2 132
10.9%

위반종류
Categorical

Distinct4
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size9.6 KiB
관파열사고
714 
계량기분실등
477 
무단이설,계량기철거및판매
 
12
부정수도
 
8

Length

Max length13
Median length5
Mean length5.4665566
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row계량기분실등
2nd row계량기분실등
3rd row계량기분실등
4th row계량기분실등
5th row관파열사고

Common Values

ValueCountFrequency (%)
관파열사고 714
59.0%
계량기분실등 477
39.4%
무단이설,계량기철거및판매 12
 
1.0%
부정수도 8
 
0.7%

Length

2023-12-11T01:16:00.842506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:16:01.035871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
관파열사고 714
59.0%
계량기분실등 477
39.4%
무단이설,계량기철거및판매 12
 
1.0%
부정수도 8
 
0.7%

위반항목
Categorical

Distinct6
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size9.6 KiB
관파열사고
714 
계량기분실
429 
기타
 
25
계량기매몰
 
23
계량기무단철거
 
12

Length

Max length7
Median length5
Mean length4.9644922
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row계량기분실
2nd row계량기분실
3rd row계량기분실
4th row계량기분실
5th row관파열사고

Common Values

ValueCountFrequency (%)
관파열사고 714
59.0%
계량기분실 429
35.4%
기타 25
 
2.1%
계량기매몰 23
 
1.9%
계량기무단철거 12
 
1.0%
계량기분실등 8
 
0.7%

Length

2023-12-11T01:16:01.231843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:16:01.425455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
관파열사고 714
59.0%
계량기분실 429
35.4%
기타 25
 
2.1%
계량기매몰 23
 
1.9%
계량기무단철거 12
 
1.0%
계량기분실등 8
 
0.7%

위반일자
Date

Distinct203
Distinct (%)16.8%
Missing0
Missing (%)0.0%
Memory size9.6 KiB
Minimum2016-08-01 00:00:00
Maximum2022-12-24 00:00:00
2023-12-11T01:16:01.619500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:02.010332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

고지일자
Date

Distinct172
Distinct (%)14.2%
Missing0
Missing (%)0.0%
Memory size9.6 KiB
Minimum2022-01-04 00:00:00
Maximum2022-12-29 00:00:00
2023-12-11T01:16:02.258719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:02.468006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

납기내일자
Date

Distinct106
Distinct (%)8.8%
Missing0
Missing (%)0.0%
Memory size9.6 KiB
Minimum2022-01-21 00:00:00
Maximum2023-01-31 00:00:00
2023-12-11T01:16:02.721111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:02.950476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

납기후일자
Date

Distinct89
Distinct (%)7.3%
Missing0
Missing (%)0.0%
Memory size9.6 KiB
Minimum2022-01-28 00:00:00
Maximum2023-01-31 00:00:00
2023-12-11T01:16:03.147521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:03.346680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수납일자
Date

MISSING 

Distinct159
Distinct (%)14.8%
Missing138
Missing (%)11.4%
Memory size9.6 KiB
Minimum2022-01-06 00:00:00
Maximum2023-01-19 00:00:00
2023-12-11T01:16:03.589141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:03.801189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

중가산결정일
Date

MISSING 

Distinct3
Distinct (%)25.0%
Missing1199
Missing (%)99.0%
Memory size9.6 KiB
Minimum2022-05-31 00:00:00
Maximum2022-12-31 00:00:00
2023-12-11T01:16:03.954425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:04.118108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=3)

중가산기한일
Date

MISSING 

Distinct3
Distinct (%)25.0%
Missing1199
Missing (%)99.0%
Memory size9.6 KiB
Minimum2022-06-30 00:00:00
Maximum2023-01-31 00:00:00
2023-12-11T01:16:04.278074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:04.441405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=3)

중가산횟수
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size9.6 KiB
<NA>
1199 
1
 
12

Length

Max length4
Median length4
Mean length3.9702725
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 1199
99.0%
1 12
 
1.0%

Length

2023-12-11T01:16:04.668158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:16:04.806334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 1199
99.0%
1 12
 
1.0%

순번
Real number (ℝ)

Distinct6
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.4508671
Minimum1
Maximum6
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.8 KiB
2023-12-11T01:16:04.931415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median2
Q33
95-th percentile4
Maximum6
Range5
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.2337628
Coefficient of variation (CV)0.50339852
Kurtosis-0.66459525
Mean2.4508671
Median Absolute Deviation (MAD)1
Skewness0.4662525
Sum2968
Variance1.5221707
MonotonicityNot monotonic
2023-12-11T01:16:05.130406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
1 342
28.2%
2 331
27.3%
3 256
21.1%
4 225
18.6%
5 46
 
3.8%
6 11
 
0.9%
ValueCountFrequency (%)
1 342
28.2%
2 331
27.3%
3 256
21.1%
4 225
18.6%
5 46
 
3.8%
6 11
 
0.9%
ValueCountFrequency (%)
6 11
 
0.9%
5 46
 
3.8%
4 225
18.6%
3 256
21.1%
2 331
27.3%
1 342
28.2%

예산과목
Categorical

Distinct9
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size9.6 KiB
<NA>
451 
관파열복구비
194 
방수료(일반용)
187 
조례위반과태료 등
146 
계량기수선비
96 
Other values (4)
137 

Length

Max length9
Median length8
Mean length6.0255987
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row조례위반과태료 등
2nd row계량기교체비
3rd row일반용사용료추징
4th row<NA>
5th row관파열복구비

Common Values

ValueCountFrequency (%)
<NA> 451
37.2%
관파열복구비 194
16.0%
방수료(일반용) 187
15.4%
조례위반과태료 등 146
 
12.1%
계량기수선비 96
 
7.9%
계량기교체비 79
 
6.5%
일반용사용료추징 35
 
2.9%
가정용사용료추징 18
 
1.5%
기타변상금,위약금 5
 
0.4%

Length

2023-12-11T01:16:05.307335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:16:05.506656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 451
33.2%
관파열복구비 194
14.3%
방수료(일반용 187
13.8%
조례위반과태료 146
 
10.8%
등 146
 
10.8%
계량기수선비 96
 
7.1%
계량기교체비 79
 
5.8%
일반용사용료추징 35
 
2.6%
가정용사용료추징 18
 
1.3%
기타변상금,위약금 5
 
0.4%

분류코드
Categorical

Distinct12
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size9.6 KiB
물이용부담금(일반용)
206 
하수도(영업용)
205 
관파열복구비
194 
방수료(일반용)
187 
조례위반과태료 등
146 
Other values (7)
273 

Length

Max length11
Median length9
Mean length8.0776218
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row조례위반과태료 등
2nd row계량기교체비
3rd row일반용사용료추징
4th row물이용부담금(일반용)
5th row관파열복구비

Common Values

ValueCountFrequency (%)
물이용부담금(일반용) 206
17.0%
하수도(영업용) 205
16.9%
관파열복구비 194
16.0%
방수료(일반용) 187
15.4%
조례위반과태료 등 146
12.1%
계량기수선비 96
7.9%
계량기교체비 79
 
6.5%
일반용사용료추징 35
 
2.9%
물이용부담금(가정용) 21
 
1.7%
하수도(가정용) 19
 
1.6%
Other values (2) 23
 
1.9%

Length

2023-12-11T01:16:05.711148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
물이용부담금(일반용 206
15.2%
하수도(영업용 205
15.1%
관파열복구비 194
14.3%
방수료(일반용 187
13.8%
조례위반과태료 146
10.8%
등 146
10.8%
계량기수선비 96
7.1%
계량기교체비 79
 
5.8%
일반용사용료추징 35
 
2.6%
물이용부담금(가정용 21
 
1.5%
Other values (3) 42
 
3.1%

조정량
Real number (ℝ)

SKEWED  ZEROS 

Distinct79
Distinct (%)6.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.72172
Minimum0
Maximum80000
Zeros480
Zeros (%)39.6%
Negative0
Negative (%)0.0%
Memory size10.8 KiB
2023-12-11T01:16:05.914658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median2
Q312
95-th percentile109
Maximum80000
Range80000
Interquartile range (IQR)12

Descriptive statistics

Standard deviation2652.017
Coefficient of variation (CV)20.602716
Kurtosis754.79164
Mean128.72172
Median Absolute Deviation (MAD)2
Skewness26.903784
Sum155882
Variance7033194.3
MonotonicityNot monotonic
2023-12-11T01:16:06.159090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 480
39.6%
1 114
 
9.4%
5 62
 
5.1%
3 61
 
5.0%
2 54
 
4.5%
6 39
 
3.2%
10 37
 
3.1%
16 23
 
1.9%
13 21
 
1.7%
7 19
 
1.6%
Other values (69) 301
24.9%
ValueCountFrequency (%)
0 480
39.6%
1 114
 
9.4%
2 54
 
4.5%
3 61
 
5.0%
4 11
 
0.9%
5 62
 
5.1%
6 39
 
3.2%
7 19
 
1.6%
8 3
 
0.2%
9 13
 
1.1%
ValueCountFrequency (%)
80000 1
 
0.1%
46021 1
 
0.1%
1250 4
0.3%
977 1
 
0.1%
668 4
0.3%
562 4
0.3%
310 1
 
0.1%
306 3
0.2%
294 3
0.2%
206 3
0.2%

위반금액
Real number (ℝ)

Distinct556
Distinct (%)45.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean166961.94
Minimum0
Maximum13360900
Zeros3
Zeros (%)0.2%
Negative0
Negative (%)0.0%
Memory size10.8 KiB
2023-12-11T01:16:06.468551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile450
Q14665
median30000
Q372150
95-th percentile674685
Maximum13360900
Range13360900
Interquartile range (IQR)67485

Descriptive statistics

Standard deviation640079.63
Coefficient of variation (CV)3.8336859
Kurtosis212.34035
Mean166961.94
Median Absolute Deviation (MAD)26010
Skewness12.490883
Sum2.0219091 × 108
Variance4.0970193 × 1011
MonotonicityNot monotonic
2023-12-11T01:16:06.824106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
34600 89
 
7.3%
50000 85
 
7.0%
30000 47
 
3.9%
1950 30
 
2.5%
150 28
 
2.3%
46020 27
 
2.2%
1330 27
 
2.2%
750 19
 
1.6%
300 18
 
1.5%
6650 17
 
1.4%
Other values (546) 824
68.0%
ValueCountFrequency (%)
0 3
 
0.2%
149 1
 
0.1%
150 28
2.3%
210 1
 
0.1%
300 18
1.5%
440 2
 
0.2%
450 17
1.4%
590 1
 
0.1%
600 4
 
0.3%
720 1
 
0.1%
ValueCountFrequency (%)
13360900 1
0.1%
10368410 1
0.1%
5827710 1
0.1%
5168580 1
0.1%
3453240 1
0.1%
3423500 1
0.1%
3224000 1
0.1%
3010790 1
0.1%
2968000 1
0.1%
2716920 1
0.1%

할인금액
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size9.6 KiB
0
1084 
10000
 
77
6000
 
44
20000
 
4
60000
 
2

Length

Max length5
Median length1
Mean length1.3831544
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row10000
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 1084
89.5%
10000 77
 
6.4%
6000 44
 
3.6%
20000 4
 
0.3%
60000 2
 
0.2%

Length

2023-12-11T01:16:07.055486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:16:07.257334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1084
89.5%
10000 77
 
6.4%
6000 44
 
3.6%
20000 4
 
0.3%
60000 2
 
0.2%

고지(징수)금액
Real number (ℝ)

Distinct557
Distinct (%)46.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean165942.95
Minimum0
Maximum13360900
Zeros3
Zeros (%)0.2%
Negative0
Negative (%)0.0%
Memory size10.8 KiB
2023-12-11T01:16:07.456125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile450
Q14665
median28800
Q372150
95-th percentile674685
Maximum13360900
Range13360900
Interquartile range (IQR)67485

Descriptive statistics

Standard deviation640239.74
Coefficient of variation (CV)3.858192
Kurtosis212.20478
Mean165942.95
Median Absolute Deviation (MAD)24810
Skewness12.486122
Sum2.0095691 × 108
Variance4.0990693 × 1011
MonotonicityNot monotonic
2023-12-11T01:16:07.711502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
34600 89
 
7.3%
40000 85
 
7.0%
24000 47
 
3.9%
1950 30
 
2.5%
150 28
 
2.3%
46020 27
 
2.2%
1330 27
 
2.2%
750 19
 
1.6%
300 18
 
1.5%
6650 17
 
1.4%
Other values (547) 824
68.0%
ValueCountFrequency (%)
0 3
 
0.2%
149 1
 
0.1%
150 28
2.3%
210 1
 
0.1%
300 18
1.5%
440 2
 
0.2%
450 17
1.4%
590 1
 
0.1%
600 4
 
0.3%
720 1
 
0.1%
ValueCountFrequency (%)
13360900 1
0.1%
10368410 1
0.1%
5827710 1
0.1%
5168580 1
0.1%
3453240 1
0.1%
3423500 1
0.1%
3224000 1
0.1%
3010790 1
0.1%
2968000 1
0.1%
2716920 1
0.1%

가산금
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size9.6 KiB
0
1211 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 1211
100.0%

Length

2023-12-11T01:16:07.957989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:16:08.137825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1211
100.0%

중가산금
Categorical

IMBALANCE 

Distinct3
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size9.6 KiB
0
1207 
600
 
2
360
 
2

Length

Max length3
Median length1
Mean length1.0066061
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 1207
99.7%
600 2
 
0.2%
360 2
 
0.2%

Length

2023-12-11T01:16:08.659676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:16:08.826244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1207
99.7%
600 2
 
0.2%
360 2
 
0.2%

중가산부과여부
Boolean

IMBALANCE 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
False
1207 
True
 
4
ValueCountFrequency (%)
False 1207
99.7%
True 4
 
0.3%
2023-12-11T01:16:08.942174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

부과사유
Categorical

Distinct15
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size9.6 KiB
물이용부담금(일반용)
205 
하수도(영업용)
205 
관파열복구비
193 
방수료(일반용)
186 
조례위반과태료 등
146 
Other values (10)
276 

Length

Max length23
Median length15
Mean length8.1279934
Min length5

Unique

Unique1 ?
Unique (%)0.1%

Sample

1st row조례위반과태료 등
2nd row계량기교체비
3rd row일반용사용료추징
4th row물이용부담금(일반용)
5th row관파열복구비

Common Values

ValueCountFrequency (%)
물이용부담금(일반용) 205
16.9%
하수도(영업용) 205
16.9%
관파열복구비 193
15.9%
방수료(일반용) 186
15.4%
조례위반과태료 등 146
12.1%
계량기수선비 96
7.9%
계량기교체비 76
 
6.3%
일반용사용료추징 35
 
2.9%
물이용부담금(가정용) 21
 
1.7%
하수도(가정용) 19
 
1.6%
Other values (5) 29
 
2.4%

Length

2023-12-11T01:16:09.142228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
물이용부담금(일반용 205
15.0%
하수도(영업용 205
15.0%
관파열복구비 193
14.2%
방수료(일반용 186
13.6%
조례위반과태료 146
10.7%
등 146
10.7%
계량기수선비 96
7.0%
계량기교체비 76
 
5.6%
일반용사용료추징 35
 
2.6%
물이용부담금(가정용 21
 
1.5%
Other values (9) 54
 
4.0%

Sample

연번사업소코드사업소명접수일자일련번호위반종류위반항목위반일자고지일자납기내일자납기후일자수납일자중가산결정일중가산기한일중가산횟수순번예산과목분류코드조정량위반금액할인금액고지(징수)금액가산금중가산금중가산부과여부부과사유
01311강서 사업소2022-06-281계량기분실등계량기분실2022-06-222022-06-282022-07-312022-07-312022-06-28<NA><NA><NA>1조례위반과태료 등조례위반과태료 등050000100004000000N조례위반과태료 등
12311강서 사업소2022-06-281계량기분실등계량기분실2022-06-222022-06-282022-07-312022-07-312022-06-28<NA><NA><NA>2계량기교체비계량기교체비04300004300000N계량기교체비
23311강서 사업소2022-06-281계량기분실등계량기분실2022-06-222022-06-282022-07-312022-07-312022-06-28<NA><NA><NA>3일반용사용료추징일반용사용료추징024000240000N일반용사용료추징
34311강서 사업소2022-06-281계량기분실등계량기분실2022-06-222022-06-282022-07-312022-07-312022-06-28<NA><NA><NA>4<NA>물이용부담금(일반용)000000N물이용부담금(일반용)
45244동래통합사업소2022-07-121관파열사고관파열사고2022-06-222022-07-132022-07-312022-07-312022-07-15<NA><NA><NA>1관파열복구비관파열복구비5453230045323000N관파열복구비
56244동래통합사업소2022-07-121관파열사고관파열사고2022-06-222022-07-132022-07-312022-07-312022-07-15<NA><NA><NA>2방수료(일반용)방수료(일반용)566500665000N방수료(일반용)
67244동래통합사업소2022-07-121관파열사고관파열사고2022-06-222022-07-132022-07-312022-07-312022-07-15<NA><NA><NA>3<NA>물이용부담금(일반용)5750075000N물이용부담금(일반용)
78244동래통합사업소2022-07-121관파열사고관파열사고2022-06-222022-07-132022-07-312022-07-312022-07-15<NA><NA><NA>4<NA>하수도(영업용)597500975000N하수도(영업용)
89201시설관리사업소2022-08-261관파열사고관파열사고2022-08-062022-08-262022-09-302022-12-312022-12-16<NA><NA><NA>1관파열복구비관파열복구비01336090001336090000N관파열복구비
910201시설관리사업소2022-08-261관파열사고관파열사고2022-08-062022-08-262022-09-302022-12-312022-12-16<NA><NA><NA>2방수료(일반용)방수료(일반용)310372000037200000N방수료(일반용)
연번사업소코드사업소명접수일자일련번호위반종류위반항목위반일자고지일자납기내일자납기후일자수납일자중가산결정일중가산기한일중가산횟수순번예산과목분류코드조정량위반금액할인금액고지(징수)금액가산금중가산금중가산부과여부부과사유
12011202311강서 사업소2022-06-301관파열사고관파열사고2022-06-242022-06-302022-07-312023-01-31<NA><NA><NA><NA>3<NA>하수도(영업용)358500585000N하수도(영업용)
12021203311강서 사업소2022-06-301관파열사고관파열사고2022-06-242022-06-302022-07-312023-01-31<NA><NA><NA><NA>4방수료(일반용)방수료(일반용)339900399000N방수료(일반용)
12031204302서부 사업소2022-07-081관파열사고관파열사고2022-07-032022-07-082022-07-312022-07-312022-07-14<NA><NA><NA>1관파열복구비관파열복구비0574910057491000N관파열복구비
12041205302서부 사업소2022-07-081관파열사고관파열사고2022-07-032022-07-082022-07-312022-07-312022-07-14<NA><NA><NA>2방수료(일반용)방수료(일반용)113300133000N방수료(일반용)
12051206302서부 사업소2022-07-081관파열사고관파열사고2022-07-032022-07-082022-07-312022-07-312022-07-14<NA><NA><NA>3<NA>물이용부담금(일반용)1150015000N물이용부담금(일반용)
12061207302서부 사업소2022-07-081관파열사고관파열사고2022-07-032022-07-082022-07-312022-07-312022-07-14<NA><NA><NA>4<NA>하수도(영업용)119500195000N하수도(영업용)
12071208308해운대 사업소2022-03-221관파열사고관파열사고2022-03-152022-03-222022-04-302022-04-302022-03-29<NA><NA><NA>1관파열복구비관파열복구비0387440038744000N관파열복구비
12081209308해운대 사업소2022-03-221관파열사고관파열사고2022-03-152022-03-222022-04-302022-04-302022-03-29<NA><NA><NA>2방수료(일반용)방수료(일반용)182394002394000N방수료(일반용)
12091210308해운대 사업소2022-03-221관파열사고관파열사고2022-03-152022-03-222022-04-302022-04-302022-03-29<NA><NA><NA>3<NA>물이용부담금(일반용)1827000270000N물이용부담금(일반용)
12101211308해운대 사업소2022-03-221관파열사고관파열사고2022-03-152022-03-222022-04-302022-04-302022-03-29<NA><NA><NA>4<NA>하수도(영업용)183510003510000N하수도(영업용)