Overview

Dataset statistics

Number of variables26
Number of observations1259
Missing cells2557
Missing cells (%)7.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory269.4 KiB
Average record size in memory219.1 B

Variable types

Numeric7
Categorical10
DateTime8
Boolean1

Dataset

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

Alerts

가산금 has constant value ""Constant
중가산횟수 is highly imbalanced (78.5%)Imbalance
할인금액 is highly imbalanced (76.9%)Imbalance
중가산금 is highly imbalanced (94.6%)Imbalance
중가산부과여부 is highly imbalanced (90.7%)Imbalance
수납일자 has 125 (9.9%) missing valuesMissing
중가산결정일 has 1216 (96.6%) missing valuesMissing
중가산기한일 has 1216 (96.6%) missing valuesMissing
조정량 is highly skewed (γ1 = 35.07721232)Skewed
위반금액 is highly skewed (γ1 = 32.82204912)Skewed
고지(징수)금액 is highly skewed (γ1 = 32.82063661)Skewed
연번 has unique valuesUnique
조정량 has 529 (42.0%) zerosZeros

Reproduction

Analysis started2023-12-10 16:16:11.572419
Analysis finished2023-12-10 16:16:12.025438
Duration0.45 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct1259
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean630
Minimum1
Maximum1259
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size11.2 KiB
2023-12-11T01:16:12.131391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile63.9
Q1315.5
median630
Q3944.5
95-th percentile1196.1
Maximum1259
Range1258
Interquartile range (IQR)629

Descriptive statistics

Standard deviation363.5863
Coefficient of variation (CV)0.57712112
Kurtosis-1.2
Mean630
Median Absolute Deviation (MAD)315
Skewness0
Sum793170
Variance132195
MonotonicityStrictly increasing
2023-12-11T01:16:12.289953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
838 1
 
0.1%
845 1
 
0.1%
844 1
 
0.1%
843 1
 
0.1%
842 1
 
0.1%
841 1
 
0.1%
840 1
 
0.1%
839 1
 
0.1%
837 1
 
0.1%
Other values (1249) 1249
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 (%)
1259 1
0.1%
1258 1
0.1%
1257 1
0.1%
1256 1
0.1%
1255 1
0.1%
1254 1
0.1%
1253 1
0.1%
1252 1
0.1%
1251 1
0.1%
1250 1
0.1%

사업소코드
Real number (ℝ)

Distinct12
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean293.05163
Minimum201
Maximum312
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size11.2 KiB
2023-12-11T01:16:12.430626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation26.90089
Coefficient of variation (CV)0.091795738
Kurtosis0.37529052
Mean293.05163
Median Absolute Deviation (MAD)3
Skewness-1.430439
Sum368952
Variance723.6579
MonotonicityNot monotonic
2023-12-11T01:16:12.556990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
244 263
20.9%
307 204
16.2%
311 166
13.2%
304 158
12.5%
308 108
8.6%
312 76
 
6.0%
302 67
 
5.3%
306 65
 
5.2%
309 58
 
4.6%
301 46
 
3.7%
Other values (2) 48
 
3.8%
ValueCountFrequency (%)
201 9
 
0.7%
244 263
20.9%
301 46
 
3.7%
302 67
 
5.3%
303 39
 
3.1%
304 158
12.5%
306 65
 
5.2%
307 204
16.2%
308 108
8.6%
309 58
 
4.6%
ValueCountFrequency (%)
312 76
 
6.0%
311 166
13.2%
309 58
 
4.6%
308 108
8.6%
307 204
16.2%
306 65
 
5.2%
304 158
12.5%
303 39
 
3.1%
302 67
 
5.3%
301 46
 
3.7%

사업소명
Categorical

Distinct12
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
동래통합사업소
263 
북부 사업소
204 
강서 사업소
166 
부산진 사업소
158 
해운대 사업소
108 
Other values (7)
360 

Length

Max length9
Median length9
Mean length8.3200953
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row남부 사업소
2nd row남부 사업소
3rd row남부 사업소
4th row남부 사업소
5th row남부 사업소

Common Values

ValueCountFrequency (%)
동래통합사업소 263
20.9%
북부 사업소 204
16.2%
강서 사업소 166
13.2%
부산진 사업소 158
12.5%
해운대 사업소 108
8.6%
기장 사업소 76
 
6.0%
서부 사업소 67
 
5.3%
남부 사업소 65
 
5.2%
사하 사업소 58
 
4.6%
중동부 사업소 46
 
3.7%
Other values (2) 48
 
3.8%

Length

2023-12-11T01:16:12.726351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
사업소 987
43.9%
동래통합사업소 263
 
11.7%
북부 204
 
9.1%
강서 166
 
7.4%
부산진 158
 
7.0%
해운대 108
 
4.8%
기장 76
 
3.4%
서부 67
 
3.0%
남부 65
 
2.9%
사하 58
 
2.6%
Other values (3) 94
 
4.2%

접수일자
Date

Distinct180
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
Minimum2021-01-04 00:00:00
Maximum2021-12-30 00:00:00
2023-12-11T01:16:12.878628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:13.085718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

일련번호
Real number (ℝ)

Distinct10
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.2875298
Minimum1
Maximum10
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size11.2 KiB
2023-12-11T01:16:13.248628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation0.88257924
Coefficient of variation (CV)0.68548258
Kurtosis29.60125
Mean1.2875298
Median Absolute Deviation (MAD)0
Skewness4.8673021
Sum1621
Variance0.77894612
MonotonicityNot monotonic
2023-12-11T01:16:13.356944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
1 1052
83.6%
2 143
 
11.4%
3 29
 
2.3%
4 10
 
0.8%
5 10
 
0.8%
6 7
 
0.6%
8 3
 
0.2%
7 3
 
0.2%
9 1
 
0.1%
10 1
 
0.1%
ValueCountFrequency (%)
1 1052
83.6%
2 143
 
11.4%
3 29
 
2.3%
4 10
 
0.8%
5 10
 
0.8%
6 7
 
0.6%
7 3
 
0.2%
8 3
 
0.2%
9 1
 
0.1%
10 1
 
0.1%
ValueCountFrequency (%)
10 1
 
0.1%
9 1
 
0.1%
8 3
 
0.2%
7 3
 
0.2%
6 7
 
0.6%
5 10
 
0.8%
4 10
 
0.8%
3 29
 
2.3%
2 143
 
11.4%
1 1052
83.6%

위반종류
Categorical

Distinct4
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
관파열사고
772 
계량기분실등
478 
무단이설,계량기철거및판매
 
6
부정수도
 
3

Length

Max length13
Median length5
Mean length5.4154091
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row계량기분실등
2nd row계량기분실등
3rd row계량기분실등
4th row계량기분실등
5th row계량기분실등

Common Values

ValueCountFrequency (%)
관파열사고 772
61.3%
계량기분실등 478
38.0%
무단이설,계량기철거및판매 6
 
0.5%
부정수도 3
 
0.2%

Length

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

Common Values (Plot)

2023-12-11T01:16:13.637804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
관파열사고 772
61.3%
계량기분실등 478
38.0%
무단이설,계량기철거및판매 6
 
0.5%
부정수도 3
 
0.2%

위반항목
Categorical

Distinct6
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
관파열사고
772 
계량기분실
390 
기타
 
70
계량기매몰
 
18
계량기무단철거
 
6

Length

Max length7
Median length5
Mean length4.8403495
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
관파열사고 772
61.3%
계량기분실 390
31.0%
기타 70
 
5.6%
계량기매몰 18
 
1.4%
계량기무단철거 6
 
0.5%
급수도용 3
 
0.2%

Length

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

Common Values (Plot)

2023-12-11T01:16:13.893708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
관파열사고 772
61.3%
계량기분실 390
31.0%
기타 70
 
5.6%
계량기매몰 18
 
1.4%
계량기무단철거 6
 
0.5%
급수도용 3
 
0.2%

위반일자
Date

Distinct199
Distinct (%)15.8%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
Minimum2020-09-09 00:00:00
Maximum2021-12-28 00:00:00
2023-12-11T01:16:14.049182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:14.214060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

고지일자
Date

Distinct181
Distinct (%)14.4%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
Minimum2021-01-04 00:00:00
Maximum2021-12-30 00:00:00
2023-12-11T01:16:14.372453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:14.533782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

납기내일자
Date

Distinct113
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
Minimum2021-01-20 00:00:00
Maximum2022-01-31 00:00:00
2023-12-11T01:16:14.672193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:14.826724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

납기후일자
Date

Distinct91
Distinct (%)7.2%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
Minimum2021-01-20 00:00:00
Maximum2022-05-31 00:00:00
2023-12-11T01:16:14.984635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:15.131818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수납일자
Date

MISSING 

Distinct179
Distinct (%)15.8%
Missing125
Missing (%)9.9%
Memory size10.0 KiB
Minimum2021-01-04 00:00:00
Maximum2022-05-03 00:00:00
2023-12-11T01:16:15.308367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:15.449684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

중가산결정일
Date

MISSING 

Distinct5
Distinct (%)11.6%
Missing1216
Missing (%)96.6%
Memory size10.0 KiB
Minimum2021-02-28 00:00:00
Maximum2022-04-30 00:00:00
2023-12-11T01:16:15.620931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:15.743062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=5)

중가산기한일
Date

MISSING 

Distinct5
Distinct (%)11.6%
Missing1216
Missing (%)96.6%
Memory size10.0 KiB
Minimum2021-03-31 00:00:00
Maximum2022-05-31 00:00:00
2023-12-11T01:16:15.864670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:15.991909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=5)

중가산횟수
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
<NA>
1216 
1
 
43

Length

Max length4
Median length4
Mean length3.8975377
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 1216
96.6%
1 43
 
3.4%

Length

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

Common Values (Plot)

2023-12-11T01:16:16.307512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 1216
96.6%
1 43
 
3.4%

순번
Real number (ℝ)

Distinct6
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.3653693
Minimum1
Maximum6
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size11.2 KiB
2023-12-11T01:16:16.445524image/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.2250467
Coefficient of variation (CV)0.51790925
Kurtosis-0.56074052
Mean2.3653693
Median Absolute Deviation (MAD)1
Skewness0.549652
Sum2978
Variance1.5007394
MonotonicityNot monotonic
2023-12-11T01:16:16.587847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
1 394
31.3%
2 341
27.1%
3 256
20.3%
4 218
17.3%
5 38
 
3.0%
6 12
 
1.0%
ValueCountFrequency (%)
1 394
31.3%
2 341
27.1%
3 256
20.3%
4 218
17.3%
5 38
 
3.0%
6 12
 
1.0%
ValueCountFrequency (%)
6 12
 
1.0%
5 38
 
3.0%
4 218
17.3%
3 256
20.3%
2 341
27.1%
1 394
31.3%

예산과목
Categorical

Distinct5
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
변상금및위약금
565 
<NA>
445 
일반용
231 
가정용
 
17
전용공업용
 
1

Length

Max length7
Median length5
Mean length5.1501191
Min length3

Unique

Unique1 ?
Unique (%)0.1%

Sample

1st row변상금및위약금
2nd row변상금및위약금
3rd row변상금및위약금
4th row가정용
5th row<NA>

Common Values

ValueCountFrequency (%)
변상금및위약금 565
44.9%
<NA> 445
35.3%
일반용 231
18.3%
가정용 17
 
1.4%
전용공업용 1
 
0.1%

Length

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

Common Values (Plot)

2023-12-11T01:16:16.916185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
변상금및위약금 565
44.9%
na 445
35.3%
일반용 231
18.3%
가정용 17
 
1.4%
전용공업용 1
 
0.1%

분류코드
Categorical

Distinct12
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
하수도요금
222 
관파열복구비
219 
방수료(일반용)
200 
물이용부담금(일반용)
181 
조례위반과태료 등
140 
Other values (7)
297 

Length

Max length11
Median length10
Mean length7.4400318
Min length5

Unique

Unique2 ?
Unique (%)0.2%

Sample

1st row조례위반과태료 등
2nd row계량기교체비
3rd row계량기수선비
4th row가정용사용료추징
5th row하수도요금

Common Values

ValueCountFrequency (%)
하수도요금 222
17.6%
관파열복구비 219
17.4%
방수료(일반용) 200
15.9%
물이용부담금(일반용) 181
14.4%
조례위반과태료 등 140
11.1%
계량기교체비 112
8.9%
계량기수선비 94
7.5%
물이용부담금(가정용) 41
 
3.3%
일반용사용료추징 31
 
2.5%
가정용사용료추징 17
 
1.4%
Other values (2) 2
 
0.2%

Length

2023-12-11T01:16:17.054832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
하수도요금 222
15.9%
관파열복구비 219
15.7%
방수료(일반용 200
14.3%
물이용부담금(일반용 181
12.9%
조례위반과태료 140
10.0%
등 140
10.0%
계량기교체비 112
8.0%
계량기수선비 94
6.7%
물이용부담금(가정용 41
 
2.9%
일반용사용료추징 31
 
2.2%
Other values (3) 19
 
1.4%

조정량
Real number (ℝ)

SKEWED  ZEROS 

Distinct76
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean213.1803
Minimum0
Maximum214150
Zeros529
Zeros (%)42.0%
Negative0
Negative (%)0.0%
Memory size11.2 KiB
2023-12-11T01:16:17.497847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q39
95-th percentile100
Maximum214150
Range214150
Interquartile range (IQR)9

Descriptive statistics

Standard deviation6058.3031
Coefficient of variation (CV)28.418681
Kurtosis1239.0539
Mean213.1803
Median Absolute Deviation (MAD)1
Skewness35.077212
Sum268394
Variance36703036
MonotonicityNot monotonic
2023-12-11T01:16:17.682017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 529
42.0%
1 179
 
14.2%
3 73
 
5.8%
4 39
 
3.1%
2 36
 
2.9%
10 36
 
2.9%
5 35
 
2.8%
6 31
 
2.5%
9 24
 
1.9%
12 22
 
1.7%
Other values (66) 255
20.3%
ValueCountFrequency (%)
0 529
42.0%
1 179
 
14.2%
2 36
 
2.9%
3 73
 
5.8%
4 39
 
3.1%
5 35
 
2.8%
6 31
 
2.5%
7 9
 
0.7%
8 6
 
0.5%
9 24
 
1.9%
ValueCountFrequency (%)
214150 1
 
0.1%
15600 1
 
0.1%
10640 1
 
0.1%
1639 1
 
0.1%
1260 1
 
0.1%
1238 1
 
0.1%
1200 1
 
0.1%
801 3
0.2%
708 1
 
0.1%
469 3
0.2%

위반금액
Real number (ℝ)

SKEWED 

Distinct532
Distinct (%)42.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean212726.25
Minimum0
Maximum76669000
Zeros6
Zeros (%)0.5%
Negative0
Negative (%)0.0%
Memory size11.2 KiB
2023-12-11T01:16:17.862278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile450
Q14175
median24310
Q366170
95-th percentile660744
Maximum76669000
Range76669000
Interquartile range (IQR)61995

Descriptive statistics

Standard deviation2216375.5
Coefficient of variation (CV)10.41891
Kurtosis1128.5587
Mean212726.25
Median Absolute Deviation (MAD)22810
Skewness32.822049
Sum2.6782234 × 108
Variance4.9123205 × 1012
MonotonicityNot monotonic
2023-12-11T01:16:18.096159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
24310 88
 
7.0%
30000 69
 
5.5%
50000 63
 
5.0%
62590 35
 
2.8%
1950 33
 
2.6%
150 30
 
2.4%
1330 30
 
2.4%
5850 23
 
1.8%
3990 23
 
1.8%
450 21
 
1.7%
Other values (522) 844
67.0%
ValueCountFrequency (%)
0 6
 
0.5%
140 6
 
0.5%
149 1
 
0.1%
150 30
2.4%
280 1
 
0.1%
300 12
 
1.0%
440 1
 
0.1%
450 21
1.7%
580 1
 
0.1%
600 11
 
0.9%
ValueCountFrequency (%)
76669000 1
0.1%
10639000 1
0.1%
8085000 1
0.1%
4505000 1
0.1%
3687360 1
0.1%
3494300 1
0.1%
3340030 1
0.1%
2497120 1
0.1%
2439920 1
0.1%
2368200 1
0.1%

할인금액
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
0
1147 
10000
 
57
6000
 
52
20000
 
2
60000
 
1

Length

Max length5
Median length1
Mean length1.3145353
Min length1

Unique

Unique1 ?
Unique (%)0.1%

Sample

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

Common Values

ValueCountFrequency (%)
0 1147
91.1%
10000 57
 
4.5%
6000 52
 
4.1%
20000 2
 
0.2%
60000 1
 
0.1%

Length

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

Common Values (Plot)

2023-12-11T01:16:18.445337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1147
91.1%
10000 57
 
4.5%
6000 52
 
4.1%
20000 2
 
0.2%
60000 1
 
0.1%

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

SKEWED 

Distinct532
Distinct (%)42.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean211946.26
Minimum0
Maximum76669000
Zeros6
Zeros (%)0.5%
Negative0
Negative (%)0.0%
Memory size11.2 KiB
2023-12-11T01:16:18.590942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile450
Q14175
median24310
Q366170
95-th percentile660744
Maximum76669000
Range76669000
Interquartile range (IQR)61995

Descriptive statistics

Standard deviation2216431
Coefficient of variation (CV)10.457514
Kurtosis1128.4917
Mean211946.26
Median Absolute Deviation (MAD)22060
Skewness32.820637
Sum2.6684034 × 108
Variance4.9125663 × 1012
MonotonicityNot monotonic
2023-12-11T01:16:18.750498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
24310 88
 
7.0%
40000 60
 
4.8%
24000 54
 
4.3%
62590 35
 
2.8%
1950 33
 
2.6%
150 30
 
2.4%
1330 30
 
2.4%
5850 23
 
1.8%
3990 23
 
1.8%
450 21
 
1.7%
Other values (522) 862
68.5%
ValueCountFrequency (%)
0 6
 
0.5%
140 6
 
0.5%
149 1
 
0.1%
150 30
2.4%
280 1
 
0.1%
300 12
 
1.0%
440 1
 
0.1%
450 21
1.7%
580 1
 
0.1%
600 11
 
0.9%
ValueCountFrequency (%)
76669000 1
0.1%
10639000 1
0.1%
8085000 1
0.1%
4505000 1
0.1%
3687360 1
0.1%
3494300 1
0.1%
3340030 1
0.1%
2497120 1
0.1%
2439920 1
0.1%
2368200 1
0.1%

가산금
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
0
1259 

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

Length

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

Common Values (Plot)

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

중가산금
Categorical

IMBALANCE 

Distinct4
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
0
1244 
360
 
10
600
 
4
280
 
1

Length

Max length3
Median length1
Mean length1.0238284
Min length1

Unique

Unique1 ?
Unique (%)0.1%

Sample

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

Common Values

ValueCountFrequency (%)
0 1244
98.8%
360 10
 
0.8%
600 4
 
0.3%
280 1
 
0.1%

Length

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

Common Values (Plot)

2023-12-11T01:16:19.271227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 1244
98.8%
360 10
 
0.8%
600 4
 
0.3%
280 1
 
0.1%

중가산부과여부
Boolean

IMBALANCE 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
False
1244 
True
 
15
ValueCountFrequency (%)
False 1244
98.8%
True 15
 
1.2%
2023-12-11T01:16:19.393545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

부과사유
Categorical

Distinct18
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
관파열복구비
219 
방수료(일반용)
200 
물이용부담금(일반용)
181 
하수도(영업용)
171 
조례위반과태료 등
139 
Other values (13)
349 

Length

Max length13
Median length11
Mean length7.9753773
Min length6

Unique

Unique6 ?
Unique (%)0.5%

Sample

1st row조례위반과태료 등
2nd row계량기교체비
3rd row계량기수선비
4th row가정용사용료추징
5th row하수도(가정용)

Common Values

ValueCountFrequency (%)
관파열복구비 219
17.4%
방수료(일반용) 200
15.9%
물이용부담금(일반용) 181
14.4%
하수도(영업용) 171
13.6%
조례위반과태료 등 139
11.0%
계량기교체비 111
8.8%
계량기수선비 94
7.5%
하수도(가정용) 49
 
3.9%
물이용부담금(가정용) 41
 
3.3%
일반용사용료추징 29
 
2.3%
Other values (8) 25
 
2.0%

Length

2023-12-11T01:16:19.520211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
관파열복구비 219
15.6%
방수료(일반용 200
14.2%
물이용부담금(일반용 181
12.9%
하수도(영업용 171
12.2%
조례위반과태료 139
9.9%
등 139
9.9%
계량기교체비 111
7.9%
계량기수선비 94
6.7%
하수도(가정용 49
 
3.5%
물이용부담금(가정용 41
 
2.9%
Other values (13) 60
 
4.3%

Sample

연번사업소코드사업소명접수일자일련번호위반종류위반항목위반일자고지일자납기내일자납기후일자수납일자중가산결정일중가산기한일중가산횟수순번예산과목분류코드조정량위반금액할인금액고지(징수)금액가산금중가산금중가산부과여부부과사유
01306남부 사업소2021-01-151계량기분실등기타2021-01-142021-01-152021-02-282021-03-312021-03-242021-02-282021-03-3111변상금및위약금조례위반과태료 등0300000300000360Y조례위반과태료 등
12306남부 사업소2021-01-151계량기분실등기타2021-01-142021-01-152021-02-282021-03-312021-03-242021-02-282021-03-3112변상금및위약금계량기교체비02133002133000N계량기교체비
23306남부 사업소2021-01-151계량기분실등기타2021-01-142021-01-152021-02-282021-03-312021-03-242021-02-282021-03-3113변상금및위약금계량기수선비03864003864000N계량기수선비
34306남부 사업소2021-01-151계량기분실등기타2021-01-142021-01-152021-02-282021-03-312021-03-242021-02-282021-03-3114가정용가정용사용료추징643200432000N가정용사용료추징
45306남부 사업소2021-01-151계량기분실등기타2021-01-142021-01-152021-02-282021-03-312021-03-242021-02-282021-03-3115<NA>하수도요금627000270000N하수도(가정용)
56306남부 사업소2021-01-151계량기분실등기타2021-01-142021-01-152021-02-282021-03-312021-03-242021-02-282021-03-3116<NA>물이용부담금(가정용)6890089000N물이용부담금(가정용)
67312기장 사업소2021-01-281관파열사고관파열사고2021-01-212021-01-282021-02-272021-03-312021-03-09<NA><NA><NA>1변상금및위약금관파열복구비0354930035493000N관파열복구비
78312기장 사업소2021-01-281관파열사고관파열사고2021-01-212021-01-282021-02-272021-03-312021-03-09<NA><NA><NA>2일반용방수료(일반용)566500665000N방수료(일반용)
89312기장 사업소2021-01-281관파열사고관파열사고2021-01-212021-01-282021-02-272021-03-312021-03-09<NA><NA><NA>3<NA>하수도요금597500975000N하수도(영업용)
910312기장 사업소2021-01-281관파열사고관파열사고2021-01-212021-01-282021-02-272021-03-312021-03-09<NA><NA><NA>4<NA>물이용부담금(일반용)5750075000N물이용부담금(일반용)
연번사업소코드사업소명접수일자일련번호위반종류위반항목위반일자고지일자납기내일자납기후일자수납일자중가산결정일중가산기한일중가산횟수순번예산과목분류코드조정량위반금액할인금액고지(징수)금액가산금중가산금중가산부과여부부과사유
12491250244동래통합사업소2021-12-211계량기분실등계량기분실2021-08-032021-12-212022-01-312022-01-312021-12-30<NA><NA><NA>1가정용가정용사용료추징174168660016866000N가정용사용료추징
12501251244동래통합사업소2021-12-211계량기분실등계량기분실2021-08-032021-12-212022-01-312022-01-312021-12-30<NA><NA><NA>2변상금및위약금계량기교체비02431002431000N계량기교체비
12511252244동래통합사업소2021-12-211계량기분실등계량기분실2021-08-032021-12-212022-01-312022-01-312021-12-30<NA><NA><NA>3변상금및위약금조례위반과태료 등03000060002400000N조례위반과태료 등
12521253244동래통합사업소2021-04-292계량기분실등계량기분실2021-02-042021-04-292021-05-312022-05-31<NA>2022-04-302022-05-3111변상금및위약금계량기수선비02431002431000N계량기수선비
12531254244동래통합사업소2021-04-292계량기분실등계량기분실2021-02-042021-04-292021-05-312022-05-31<NA>2022-04-302022-05-3112변상금및위약금조례위반과태료 등0300000300000360Y조례위반과태료 등
12541255244동래통합사업소2021-04-292계량기분실등계량기분실2021-02-042021-04-292021-05-312022-05-31<NA>2022-04-302022-05-3113가정용가정용사용료추징000000N가정용사용료추징
12551256244동래통합사업소2021-04-292계량기분실등계량기분실2021-02-042021-04-292021-05-312022-05-31<NA>2022-04-302022-05-3114<NA>하수도요금000000N하수도(가정용)
12561257244동래통합사업소2021-04-292계량기분실등계량기분실2021-02-042021-04-292021-05-312022-05-31<NA>2022-04-302022-05-3115<NA>물이용부담금(가정용)000000N물이용부담금(가정용)
12571258307북부 사업소2021-05-251계량기분실등계량기매몰2021-05-252021-05-312021-06-302021-07-312021-07-232021-06-302021-07-3111변상금및위약금조례위반과태료 등0500000500000600Y조례위반과태료 등
12581259307북부 사업소2021-05-251계량기분실등계량기매몰2021-05-252021-05-312021-06-302021-07-312021-07-232021-06-302021-07-3112변상금및위약금계량기수선비035800358000N계량기수선비