Overview

Dataset statistics

Number of variables26
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.3 MiB
Average record size in memory237.0 B

Variable types

Numeric15
Categorical10
DateTime1

Dataset

Description부산광역시상수도사업본부_수용가정보시스템_세입집계정보_세입일집계_20220131
Author부산광역시 상수도사업본부
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15083668

Alerts

불납결손건수 has constant value ""Constant
결손취소건수 has constant value ""Constant
결손취소금액 is highly imbalanced (99.7%)Imbalance
체납이중수납건수 is highly imbalanced (98.9%)Imbalance
과오건수 is highly imbalanced (98.0%)Imbalance
충당건수 is highly imbalanced (99.3%)Imbalance
당월이중수납건수 is highly skewed (γ1 = 23.22480727)Skewed
당월이중수납금액 is highly skewed (γ1 = 34.18459567)Skewed
불납결손금액 is highly skewed (γ1 = 99.07557025)Skewed
반환금액 is highly skewed (γ1 = 70.91614365)Skewed
체납이중수납금액 is highly skewed (γ1 = 73.55003652)Skewed
과오금액 is highly skewed (γ1 = 74.40124598)Skewed
충당금액 is highly skewed (γ1 = 44.64341928)Skewed
연번 has unique valuesUnique
징수건수 has 4553 (45.5%) zerosZeros
징수금액 has 4024 (40.2%) zerosZeros
수납건수 has 415 (4.2%) zerosZeros
수납금액 has 408 (4.1%) zerosZeros
당월이중수납건수 has 9883 (98.8%) zerosZeros
당월이중수납금액 has 9883 (98.8%) zerosZeros
불납결손금액 has 9986 (99.9%) zerosZeros
반환건수 has 9771 (97.7%) zerosZeros
반환금액 has 9771 (97.7%) zerosZeros
체납이중수납금액 has 9985 (99.9%) zerosZeros
과오금액 has 9961 (99.6%) zerosZeros
충당금액 has 9991 (99.9%) zerosZeros

Reproduction

Analysis started2023-12-10 16:39:09.327216
Analysis finished2023-12-10 16:39:09.892312
Duration0.57 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean45202.73
Minimum8
Maximum89804
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:09.966324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum8
5-th percentile4516
Q123099
median45006
Q367523.25
95-th percentile85545.55
Maximum89804
Range89796
Interquartile range (IQR)44424.25

Descriptive statistics

Standard deviation25873.693
Coefficient of variation (CV)0.57239226
Kurtosis-1.1839334
Mean45202.73
Median Absolute Deviation (MAD)22219.5
Skewness-0.00070638159
Sum4.520273 × 108
Variance6.6944798 × 108
MonotonicityNot monotonic
2023-12-11T01:39:10.103967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
81863 1
 
< 0.1%
61305 1
 
< 0.1%
40797 1
 
< 0.1%
42312 1
 
< 0.1%
48226 1
 
< 0.1%
85808 1
 
< 0.1%
61888 1
 
< 0.1%
25983 1
 
< 0.1%
9466 1
 
< 0.1%
57417 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
8 1
< 0.1%
27 1
< 0.1%
30 1
< 0.1%
33 1
< 0.1%
42 1
< 0.1%
60 1
< 0.1%
67 1
< 0.1%
72 1
< 0.1%
76 1
< 0.1%
84 1
< 0.1%
ValueCountFrequency (%)
89804 1
< 0.1%
89780 1
< 0.1%
89749 1
< 0.1%
89737 1
< 0.1%
89723 1
< 0.1%
89717 1
< 0.1%
89692 1
< 0.1%
89679 1
< 0.1%
89674 1
< 0.1%
89663 1
< 0.1%

사업소코드
Real number (ℝ)

Distinct12
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean280.2785
Minimum101
Maximum306
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:10.222018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum101
5-th percentile244
Q1244
median301
Q3304
95-th percentile306
Maximum306
Range205
Interquartile range (IQR)60

Descriptive statistics

Standard deviation33.407861
Coefficient of variation (CV)0.11919523
Kurtosis4.2091631
Mean280.2785
Median Absolute Deviation (MAD)5
Skewness-1.5529172
Sum2802785
Variance1116.0851
MonotonicityNot monotonic
2023-12-11T01:39:10.328092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
244 3381
33.8%
306 1659
16.6%
301 1609
16.1%
304 1346
 
13.5%
302 945
 
9.4%
303 838
 
8.4%
101 74
 
0.7%
201 70
 
0.7%
202 44
 
0.4%
205 13
 
0.1%
Other values (2) 21
 
0.2%
ValueCountFrequency (%)
101 74
 
0.7%
201 70
 
0.7%
202 44
 
0.4%
203 11
 
0.1%
204 10
 
0.1%
205 13
 
0.1%
244 3381
33.8%
301 1609
16.1%
302 945
 
9.4%
303 838
 
8.4%
ValueCountFrequency (%)
306 1659
16.6%
304 1346
 
13.5%
303 838
 
8.4%
302 945
 
9.4%
301 1609
16.1%
244 3381
33.8%
205 13
 
0.1%
204 10
 
0.1%
203 11
 
0.1%
202 44
 
0.4%

사업소명
Categorical

Distinct12
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
동래통합사업소
3381 
남부 사업소
1659 
중동부 사업소
1609 
부산진 사업소
1346 
서부 사업소
945 
Other values (7)
1060 

Length

Max length9
Median length8
Mean length7.9603
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row남부 사업소
2nd row중동부 사업소
3rd row중동부 사업소
4th row중동부 사업소
5th row부산진 사업소

Common Values

ValueCountFrequency (%)
동래통합사업소 3381
33.8%
남부 사업소 1659
16.6%
중동부 사업소 1609
16.1%
부산진 사업소 1346
 
13.5%
서부 사업소 945
 
9.4%
영도 사업소 838
 
8.4%
경영지원부 74
 
0.7%
시설관리사업소 70
 
0.7%
수질연구소 44
 
0.4%
덕산정수사업소 13
 
0.1%
Other values (2) 21
 
0.2%

Length

2023-12-11T01:39:10.505732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
사업소 6397
39.0%
동래통합사업소 3381
20.6%
남부 1659
 
10.1%
중동부 1609
 
9.8%
부산진 1346
 
8.2%
서부 945
 
5.8%
영도 838
 
5.1%
경영지원부 74
 
0.5%
시설관리사업소 70
 
0.4%
수질연구소 44
 
0.3%
Other values (3) 34
 
0.2%

구코드
Real number (ℝ)

Distinct16
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean274.7916
Minimum0
Maximum500
Zeros74
Zeros (%)0.7%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:10.914460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile110
Q1170
median260
Q3410
95-th percentile500
Maximum500
Range500
Interquartile range (IQR)240

Descriptive statistics

Standard deviation123.11172
Coefficient of variation (CV)0.44801849
Kurtosis-0.89307438
Mean274.7916
Median Absolute Deviation (MAD)90
Skewness0.47856384
Sum2747916
Variance15156.495
MonotonicityNot monotonic
2023-12-11T01:39:11.013096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%)
230 1346
13.5%
260 1186
11.9%
410 1106
11.1%
470 1089
10.9%
290 1078
10.8%
140 945
9.4%
170 913
9.1%
200 838
8.4%
110 696
7.0%
500 581
5.8%
Other values (6) 222
 
2.2%
ValueCountFrequency (%)
0 74
 
0.7%
110 696
7.0%
140 945
9.4%
170 913
9.1%
200 838
8.4%
201 70
 
0.7%
202 44
 
0.4%
203 11
 
0.1%
204 10
 
0.1%
205 13
 
0.1%
ValueCountFrequency (%)
500 581
5.8%
470 1089
10.9%
410 1106
11.1%
290 1078
10.8%
260 1186
11.9%
230 1346
13.5%
205 13
 
0.1%
204 10
 
0.1%
203 11
 
0.1%
202 44
 
0.4%

구명
Categorical

Distinct16
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
부산진구
1346 
동래구
1186 
금정구
1106 
연제구
1089 
남구
1078 
Other values (11)
4195 

Length

Max length4
Median length3
Mean length2.764
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row남구
2nd row중구
3rd row동구
4th row동구
5th row부산진구

Common Values

ValueCountFrequency (%)
부산진구 1346
13.5%
동래구 1186
11.9%
금정구 1106
11.1%
연제구 1089
10.9%
남구 1078
10.8%
서구 945
9.4%
동구 913
9.1%
영도구 838
8.4%
중구 696
7.0%
수영구 581
5.8%
Other values (6) 222
 
2.2%

Length

2023-12-11T01:39:11.146046image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
부산진구 1346
13.5%
동래구 1186
11.9%
금정구 1106
11.1%
연제구 1089
10.9%
남구 1078
10.8%
서구 945
9.4%
동구 913
9.1%
영도구 838
8.4%
중구 696
7.0%
수영구 581
5.8%
Other values (6) 222
 
2.2%

결의일자
Date

Distinct365
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-01-01 00:00:00
Maximum2021-12-31 00:00:00
2023-12-11T01:39:11.273681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:39:11.425420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

예산과목
Categorical

Distinct28
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
기타수수료수익
1827 
하수도요금
1748 
물이용부담금
1425 
일반용
1345 
가정용
995 
Other values (23)
2660 

Length

Max length9
Median length8
Mean length5.6354
Min length3

Unique

Unique3 ?
Unique (%)< 0.1%

Sample

1st row물이용부담금
2nd row물이용부담금
3rd row가정용
4th row기타수수료수익
5th row기타수수료수익

Common Values

ValueCountFrequency (%)
기타수수료수익 1827
18.3%
하수도요금 1748
17.5%
물이용부담금 1425
14.2%
일반용 1345
13.5%
가정용 995
10.0%
수용가미수금이월액 917
9.2%
개조공사수입 790
7.9%
신설공사수입 370
 
3.7%
기타공사부담금수입 176
 
1.8%
변상금및위약금 118
 
1.2%
Other values (18) 289
 
2.9%

Length

2023-12-11T01:39:11.594607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
기타수수료수익 1827
18.3%
하수도요금 1748
17.5%
물이용부담금 1425
14.2%
일반용 1345
13.5%
가정용 995
10.0%
수용가미수금이월액 917
9.2%
개조공사수입 790
7.9%
신설공사수입 370
 
3.7%
기타공사부담금수입 176
 
1.8%
변상금및위약금 118
 
1.2%
Other values (18) 289
 
2.9%

결의서구분
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
상수도
6827 
하수도
1748 
물이용
1425 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row물이용
2nd row물이용
3rd row상수도
4th row상수도
5th row상수도

Common Values

ValueCountFrequency (%)
상수도 6827
68.3%
하수도 1748
 
17.5%
물이용 1425
 
14.2%

Length

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

Common Values (Plot)

2023-12-11T01:39:11.846234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
상수도 6827
68.3%
하수도 1748
 
17.5%
물이용 1425
 
14.2%

징수건수
Real number (ℝ)

ZEROS 

Distinct215
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.8786
Minimum0
Maximum12675
Zeros4553
Zeros (%)45.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:11.975040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q33
95-th percentile8
Maximum12675
Range12675
Interquartile range (IQR)3

Descriptive statistics

Standard deviation671.91003
Coefficient of variation (CV)8.9733253
Kurtosis129.33343
Mean74.8786
Median Absolute Deviation (MAD)1
Skewness10.83052
Sum748786
Variance451463.09
MonotonicityNot monotonic
2023-12-11T01:39:12.127146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4553
45.5%
2 1619
 
16.2%
1 1036
 
10.4%
3 854
 
8.5%
4 595
 
5.9%
6 325
 
3.2%
5 302
 
3.0%
7 130
 
1.3%
8 123
 
1.2%
9 68
 
0.7%
Other values (205) 395
 
4.0%
ValueCountFrequency (%)
0 4553
45.5%
1 1036
 
10.4%
2 1619
 
16.2%
3 854
 
8.5%
4 595
 
5.9%
5 302
 
3.0%
6 325
 
3.2%
7 130
 
1.3%
8 123
 
1.2%
9 68
 
0.7%
ValueCountFrequency (%)
12675 1
< 0.1%
11447 1
< 0.1%
10832 2
< 0.1%
9996 1
< 0.1%
9943 1
< 0.1%
9560 1
< 0.1%
9095 1
< 0.1%
9064 1
< 0.1%
9057 1
< 0.1%
9041 1
< 0.1%

징수금액
Real number (ℝ)

ZEROS 

Distinct3533
Distinct (%)35.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9196171.9
Minimum-43460220
Maximum1.9 × 109
Zeros4024
Zeros (%)40.2%
Negative1172
Negative (%)11.7%
Memory size166.0 KiB
2023-12-11T01:39:12.279055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-43460220
5-th percentile-173331
Q10
median0
Q3133000
95-th percentile7427000
Maximum1.9 × 109
Range1.9434602 × 109
Interquartile range (IQR)133000

Descriptive statistics

Standard deviation79010870
Coefficient of variation (CV)8.5917131
Kurtosis167.07464
Mean9196171.9
Median Absolute Deviation (MAD)14000
Skewness12.092486
Sum9.1961719 × 1010
Variance6.2427177 × 1015
MonotonicityNot monotonic
2023-12-11T01:39:12.426680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4024
40.2%
14000 357
 
3.6%
7000 139
 
1.4%
28000 116
 
1.2%
848000 67
 
0.7%
42000 47
 
0.5%
21000 46
 
0.5%
18000 43
 
0.4%
1269000 40
 
0.4%
1156000 36
 
0.4%
Other values (3523) 5085
50.8%
ValueCountFrequency (%)
-43460220 1
< 0.1%
-40642820 1
< 0.1%
-40615870 1
< 0.1%
-17481600 1
< 0.1%
-8061460 2
< 0.1%
-7338280 1
< 0.1%
-6390960 2
< 0.1%
-6161210 1
< 0.1%
-6062380 1
< 0.1%
-5947450 1
< 0.1%
ValueCountFrequency (%)
1900000000 1
< 0.1%
1372892840 1
< 0.1%
1310431220 1
< 0.1%
1286266640 1
< 0.1%
1285783250 1
< 0.1%
1224491000 1
< 0.1%
1204493730 2
< 0.1%
1197078470 2
< 0.1%
1170310000 1
< 0.1%
1104818270 1
< 0.1%

수납건수
Real number (ℝ)

ZEROS 

Distinct520
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean67.3245
Minimum0
Maximum8152
Zeros415
Zeros (%)4.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:12.616782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q12
median5
Q324
95-th percentile221.05
Maximum8152
Range8152
Interquartile range (IQR)22

Descriptive statistics

Standard deviation379.70499
Coefficient of variation (CV)5.6399229
Kurtosis146.39149
Mean67.3245
Median Absolute Deviation (MAD)4
Skewness11.409691
Sum673245
Variance144175.88
MonotonicityNot monotonic
2023-12-11T01:39:12.777187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2 1592
15.9%
1 1344
 
13.4%
3 832
 
8.3%
4 657
 
6.6%
0 415
 
4.2%
6 389
 
3.9%
5 351
 
3.5%
7 226
 
2.3%
8 225
 
2.2%
9 152
 
1.5%
Other values (510) 3817
38.2%
ValueCountFrequency (%)
0 415
 
4.2%
1 1344
13.4%
2 1592
15.9%
3 832
8.3%
4 657
6.6%
5 351
 
3.5%
6 389
 
3.9%
7 226
 
2.3%
8 225
 
2.2%
9 152
 
1.5%
ValueCountFrequency (%)
8152 1
< 0.1%
6018 1
< 0.1%
5973 2
< 0.1%
5833 1
< 0.1%
5796 1
< 0.1%
5627 1
< 0.1%
5542 1
< 0.1%
5475 1
< 0.1%
5309 1
< 0.1%
5303 1
< 0.1%

수납금액
Real number (ℝ)

ZEROS 

Distinct6648
Distinct (%)66.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8106138.5
Minimum0
Maximum1.9 × 109
Zeros408
Zeros (%)4.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:12.951729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1850
Q145595
median401050
Q31877920
95-th percentile18642678
Maximum1.9 × 109
Range1.9 × 109
Interquartile range (IQR)1832325

Descriptive statistics

Standard deviation58265278
Coefficient of variation (CV)7.187797
Kurtosis266.25224
Mean8106138.5
Median Absolute Deviation (MAD)391050
Skewness14.45379
Sum8.1061385 × 1010
Variance3.3948427 × 1015
MonotonicityNot monotonic
2023-12-11T01:39:13.173263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 408
 
4.1%
14000 369
 
3.7%
7000 237
 
2.4%
28000 125
 
1.2%
21000 70
 
0.7%
848000 67
 
0.7%
42000 46
 
0.5%
18000 43
 
0.4%
1269000 40
 
0.4%
1156000 36
 
0.4%
Other values (6638) 8559
85.6%
ValueCountFrequency (%)
0 408
4.1%
20 1
 
< 0.1%
80 2
 
< 0.1%
90 1
 
< 0.1%
110 1
 
< 0.1%
140 8
 
0.1%
150 1
 
< 0.1%
160 2
 
< 0.1%
200 1
 
< 0.1%
280 3
 
< 0.1%
ValueCountFrequency (%)
1900000000 1
< 0.1%
1224491000 1
< 0.1%
1170310000 1
< 0.1%
1099005830 1
< 0.1%
946720760 1
< 0.1%
917214390 1
< 0.1%
907609270 1
< 0.1%
902810520 1
< 0.1%
896154550 1
< 0.1%
868638250 1
< 0.1%

당월이중수납건수
Real number (ℝ)

SKEWED  ZEROS 

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.0174
Minimum0
Maximum8
Zeros9883
Zeros (%)98.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:13.318943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum8
Range8
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.21977732
Coefficient of variation (CV)12.63088
Kurtosis698.08749
Mean0.0174
Median Absolute Deviation (MAD)0
Skewness23.224807
Sum174
Variance0.04830207
MonotonicityNot monotonic
2023-12-11T01:39:13.462287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
0 9883
98.8%
1 96
 
1.0%
2 11
 
0.1%
5 4
 
< 0.1%
8 3
 
< 0.1%
3 2
 
< 0.1%
6 1
 
< 0.1%
ValueCountFrequency (%)
0 9883
98.8%
1 96
 
1.0%
2 11
 
0.1%
3 2
 
< 0.1%
5 4
 
< 0.1%
6 1
 
< 0.1%
8 3
 
< 0.1%
ValueCountFrequency (%)
8 3
 
< 0.1%
6 1
 
< 0.1%
5 4
 
< 0.1%
3 2
 
< 0.1%
2 11
 
0.1%
1 96
 
1.0%
0 9883
98.8%

당월이중수납금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct105
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1365.699
Minimum0
Maximum1337580
Zeros9883
Zeros (%)98.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:13.622874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum1337580
Range1337580
Interquartile range (IQR)0

Descriptive statistics

Standard deviation27687.43
Coefficient of variation (CV)20.273449
Kurtosis1401.0612
Mean1365.699
Median Absolute Deviation (MAD)0
Skewness34.184596
Sum13656990
Variance7.6659376 × 108
MonotonicityNot monotonic
2023-12-11T01:39:13.827807image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9883
98.8%
2380 4
 
< 0.1%
36040 3
 
< 0.1%
61310 2
 
< 0.1%
18180 2
 
< 0.1%
330740 2
 
< 0.1%
1337580 2
 
< 0.1%
608740 2
 
< 0.1%
126470 2
 
< 0.1%
48720 2
 
< 0.1%
Other values (95) 96
 
1.0%
ValueCountFrequency (%)
0 9883
98.8%
140 1
 
< 0.1%
280 1
 
< 0.1%
440 1
 
< 0.1%
1340 1
 
< 0.1%
2040 1
 
< 0.1%
2230 1
 
< 0.1%
2380 4
 
< 0.1%
2520 1
 
< 0.1%
2710 1
 
< 0.1%
ValueCountFrequency (%)
1337580 2
< 0.1%
1009720 1
< 0.1%
785860 1
< 0.1%
608740 2
< 0.1%
452580 1
< 0.1%
424720 1
< 0.1%
405570 1
< 0.1%
393160 1
< 0.1%
330740 2
< 0.1%
319740 1
< 0.1%

불납결손건수
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

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

Length

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

Common Values (Plot)

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

불납결손금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct13
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1676.656
Minimum0
Maximum14035200
Zeros9986
Zeros (%)99.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:14.139067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum14035200
Range14035200
Interquartile range (IQR)0

Descriptive statistics

Standard deviation140795.64
Coefficient of variation (CV)83.974075
Kurtosis9873.8465
Mean1676.656
Median Absolute Deviation (MAD)0
Skewness99.07557
Sum16766560
Variance1.9823411 × 1010
MonotonicityNot monotonic
2023-12-11T01:39:14.270385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
0 9986
99.9%
6200 2
 
< 0.1%
635340 2
 
< 0.1%
14035200 1
 
< 0.1%
4960 1
 
< 0.1%
55520 1
 
< 0.1%
411600 1
 
< 0.1%
322580 1
 
< 0.1%
322250 1
 
< 0.1%
55320 1
 
< 0.1%
Other values (3) 3
 
< 0.1%
ValueCountFrequency (%)
0 9986
99.9%
4960 1
 
< 0.1%
6200 2
 
< 0.1%
10460 1
 
< 0.1%
11740 1
 
< 0.1%
55320 1
 
< 0.1%
55520 1
 
< 0.1%
253850 1
 
< 0.1%
322250 1
 
< 0.1%
322580 1
 
< 0.1%
ValueCountFrequency (%)
14035200 1
< 0.1%
635340 2
< 0.1%
411600 1
< 0.1%
322580 1
< 0.1%
322250 1
< 0.1%
253850 1
< 0.1%
55520 1
< 0.1%
55320 1
< 0.1%
11740 1
< 0.1%
10460 1
< 0.1%

결손취소건수
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

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

Length

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

Common Values (Plot)

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

결손취소금액
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9996 
48160
 
1
4350
 
1
270
 
1
14920
 
1

Length

Max length5
Median length1
Mean length1.0013
Min length1

Unique

Unique4 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
0 9996
> 99.9%
48160 1
 
< 0.1%
4350 1
 
< 0.1%
270 1
 
< 0.1%
14920 1
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-11T01:39:14.730313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9996
> 99.9%
48160 1
 
< 0.1%
4350 1
 
< 0.1%
270 1
 
< 0.1%
14920 1
 
< 0.1%

반환건수
Real number (ℝ)

ZEROS 

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.0393
Minimum0
Maximum11
Zeros9771
Zeros (%)97.7%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:14.885817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum11
Range11
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.34404556
Coefficient of variation (CV)8.7543399
Kurtosis406.60568
Mean0.0393
Median Absolute Deviation (MAD)0
Skewness16.670583
Sum393
Variance0.11836735
MonotonicityNot monotonic
2023-12-11T01:39:15.078846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
0 9771
97.7%
1 151
 
1.5%
2 39
 
0.4%
3 25
 
0.2%
5 7
 
0.1%
11 3
 
< 0.1%
4 3
 
< 0.1%
9 1
 
< 0.1%
ValueCountFrequency (%)
0 9771
97.7%
1 151
 
1.5%
2 39
 
0.4%
3 25
 
0.2%
4 3
 
< 0.1%
5 7
 
0.1%
9 1
 
< 0.1%
11 3
 
< 0.1%
ValueCountFrequency (%)
11 3
 
< 0.1%
9 1
 
< 0.1%
5 7
 
0.1%
4 3
 
< 0.1%
3 25
 
0.2%
2 39
 
0.4%
1 151
 
1.5%
0 9771
97.7%

반환금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct198
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15015.623
Minimum0
Maximum43460220
Zeros9771
Zeros (%)97.7%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:15.311557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum43460220
Range43460220
Interquartile range (IQR)0

Descriptive statistics

Standard deviation503470.45
Coefficient of variation (CV)33.529774
Kurtosis5773.9892
Mean15015.623
Median Absolute Deviation (MAD)0
Skewness70.916144
Sum1.5015623 × 108
Variance2.534825 × 1011
MonotonicityNot monotonic
2023-12-11T01:39:15.569979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9771
97.7%
1330 6
 
0.1%
5088670 4
 
< 0.1%
126000 3
 
< 0.1%
3673000 3
 
< 0.1%
3618660 3
 
< 0.1%
151260 2
 
< 0.1%
217340 2
 
< 0.1%
1439000 2
 
< 0.1%
172120 2
 
< 0.1%
Other values (188) 202
 
2.0%
ValueCountFrequency (%)
0 9771
97.7%
300 1
 
< 0.1%
520 1
 
< 0.1%
1200 1
 
< 0.1%
1330 6
 
0.1%
1480 1
 
< 0.1%
1500 1
 
< 0.1%
1590 1
 
< 0.1%
2060 1
 
< 0.1%
2080 1
 
< 0.1%
ValueCountFrequency (%)
43460220 1
 
< 0.1%
19381970 1
 
< 0.1%
6780300 1
 
< 0.1%
5088670 4
< 0.1%
3673000 3
< 0.1%
3618660 3
< 0.1%
3383290 1
 
< 0.1%
2419600 1
 
< 0.1%
2354720 2
< 0.1%
1505420 1
 
< 0.1%

체납이중수납건수
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9985 
1
 
13
3
 
2

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 9985
99.9%
1 13
 
0.1%
3 2
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-11T01:39:16.032734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9985
99.9%
1 13
 
0.1%
3 2
 
< 0.1%

체납이중수납금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct15
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean151.022
Minimum0
Maximum616730
Zeros9985
Zeros (%)99.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:16.159477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum616730
Range616730
Interquartile range (IQR)0

Descriptive statistics

Standard deviation7008.4268
Coefficient of variation (CV)46.406661
Kurtosis6139.0655
Mean151.022
Median Absolute Deviation (MAD)0
Skewness73.550037
Sum1510220
Variance49118046
MonotonicityNot monotonic
2023-12-11T01:39:16.277807image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
0 9985
99.9%
27680 2
 
< 0.1%
74160 1
 
< 0.1%
1770 1
 
< 0.1%
616730 1
 
< 0.1%
45260 1
 
< 0.1%
34890 1
 
< 0.1%
219990 1
 
< 0.1%
56730 1
 
< 0.1%
32980 1
 
< 0.1%
Other values (5) 5
 
0.1%
ValueCountFrequency (%)
0 9985
99.9%
1770 1
 
< 0.1%
17340 1
 
< 0.1%
18110 1
 
< 0.1%
27680 2
 
< 0.1%
32980 1
 
< 0.1%
34890 1
 
< 0.1%
38060 1
 
< 0.1%
45260 1
 
< 0.1%
56730 1
 
< 0.1%
ValueCountFrequency (%)
616730 1
< 0.1%
219990 1
< 0.1%
174630 1
< 0.1%
124210 1
< 0.1%
74160 1
< 0.1%
56730 1
< 0.1%
45260 1
< 0.1%
38060 1
< 0.1%
34890 1
< 0.1%
32980 1
< 0.1%

과오건수
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9961 
1
 
32
2
 
6
3
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
0 9961
99.6%
1 32
 
0.3%
2 6
 
0.1%
3 1
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-11T01:39:16.501640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9961
99.6%
1 32
 
0.3%
2 6
 
0.1%
3 1
 
< 0.1%

과오금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct37
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean282.144
Minimum-9740
Maximum977660
Zeros9961
Zeros (%)99.6%
Negative2
Negative (%)< 0.1%
Memory size166.0 KiB
2023-12-11T01:39:16.631172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-9740
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum977660
Range987400
Interquartile range (IQR)0

Descriptive statistics

Standard deviation10942.328
Coefficient of variation (CV)38.782776
Kurtosis6419.7993
Mean282.144
Median Absolute Deviation (MAD)0
Skewness74.401246
Sum2821440
Variance1.1973453 × 108
MonotonicityNot monotonic
2023-12-11T01:39:16.786023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=37)
ValueCountFrequency (%)
0 9961
99.6%
94840 2
 
< 0.1%
11040 2
 
< 0.1%
178180 2
 
< 0.1%
7890 1
 
< 0.1%
910 1
 
< 0.1%
2820 1
 
< 0.1%
195280 1
 
< 0.1%
61960 1
 
< 0.1%
21340 1
 
< 0.1%
Other values (27) 27
 
0.3%
ValueCountFrequency (%)
-9740 1
 
< 0.1%
-700 1
 
< 0.1%
0 9961
99.6%
740 1
 
< 0.1%
910 1
 
< 0.1%
1230 1
 
< 0.1%
1400 1
 
< 0.1%
2360 1
 
< 0.1%
2820 1
 
< 0.1%
3710 1
 
< 0.1%
ValueCountFrequency (%)
977660 1
< 0.1%
233040 1
< 0.1%
195280 1
< 0.1%
178180 2
< 0.1%
159080 1
< 0.1%
138160 1
< 0.1%
94840 2
< 0.1%
77610 1
< 0.1%
61960 1
< 0.1%
54760 1
< 0.1%

충당건수
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9991 
1
 
7
2
 
2

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 9991
99.9%
1 7
 
0.1%
2 2
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-11T01:39:17.323118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9991
99.9%
1 7
 
0.1%
2 2
 
< 0.1%

충당금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct10
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20.116
Minimum0
Maximum44570
Zeros9991
Zeros (%)99.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:17.431121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum44570
Range44570
Interquartile range (IQR)0

Descriptive statistics

Standard deviation795.27738
Coefficient of variation (CV)39.534569
Kurtosis2109.7574
Mean20.116
Median Absolute Deviation (MAD)0
Skewness44.643419
Sum201160
Variance632466.11
MonotonicityNot monotonic
2023-12-11T01:39:17.531294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
0 9991
99.9%
14700 1
 
< 0.1%
9270 1
 
< 0.1%
22780 1
 
< 0.1%
35790 1
 
< 0.1%
36820 1
 
< 0.1%
2400 1
 
< 0.1%
5760 1
 
< 0.1%
44570 1
 
< 0.1%
29070 1
 
< 0.1%
ValueCountFrequency (%)
0 9991
99.9%
2400 1
 
< 0.1%
5760 1
 
< 0.1%
9270 1
 
< 0.1%
14700 1
 
< 0.1%
22780 1
 
< 0.1%
29070 1
 
< 0.1%
35790 1
 
< 0.1%
36820 1
 
< 0.1%
44570 1
 
< 0.1%
ValueCountFrequency (%)
44570 1
 
< 0.1%
36820 1
 
< 0.1%
35790 1
 
< 0.1%
29070 1
 
< 0.1%
22780 1
 
< 0.1%
14700 1
 
< 0.1%
9270 1
 
< 0.1%
5760 1
 
< 0.1%
2400 1
 
< 0.1%
0 9991
99.9%

Sample

연번사업소코드사업소명구코드구명결의일자예산과목결의서구분징수건수징수금액수납건수수납금액당월이중수납건수당월이중수납금액불납결손건수불납결손금액결손취소건수결손취소금액반환건수반환금액체납이중수납건수체납이중수납금액과오건수과오금액충당건수충당금액
8186281863306남부 사업소290남구2021-08-17물이용부담금물이용0-258902922003000000000000000
3872838729301중동부 사업소110중구2021-12-10물이용부담금물이용17300912778000000000000000
4548845489301중동부 사업소170동구2021-10-23가정용상수도0-20001049126977000000000000000
4325443255301중동부 사업소170동구2021-07-06기타수수료수익상수도2406000240600000000000000000
6484564846304부산진 사업소230부산진구2021-02-23기타수수료수익상수도21400021400000000000000000
5796457965303영도 사업소200영도구2021-04-21물이용부담금물이용00125607000000000000000
1359313594244동래통합사업소410금정구2021-01-18신설공사수입상수도3848000384800000000000000000
3572335724301중동부 사업소110중구2021-05-21기타수수료수익상수도214420002144200000000000000000
7026270263304부산진 사업소230부산진구2021-07-14신설공사수입상수도3848000384800000000000000000
6288062881304부산진 사업소230부산진구2021-01-01물이용부담금물이용384439281630108524000000000000000
연번사업소코드사업소명구코드구명결의일자예산과목결의서구분징수건수징수금액수납건수수납금액당월이중수납건수당월이중수납금액불납결손건수불납결손금액결손취소건수결손취소금액반환건수반환금액체납이중수납건수체납이중수납금액과오건수과오금액충당건수충당금액
4384943850301중동부 사업소170동구2021-07-29하수도요금하수도001391624110000000000000000
3596435965301중동부 사업소110중구2021-05-31물이용부담금물이용0-400135823000000000000000
4884648847302서부 사업소140서구2021-03-20일반용상수도0017273892000000000000000
3811638117301중동부 사업소110중구2021-10-26하수도요금하수도0021450000000000000000
8179081791306남부 사업소290남구2021-08-13기타수수료수익상수도2406000240600000000000000000
4811448115302서부 사업소140서구2021-02-19일반용상수도46946052345679000000000000000
1042610427244동래통합사업소260동래구2021-09-27수용가미수금이월액상수도00719734000000000000000
6018260183303영도 사업소200영도구2021-08-13욕탕용상수도31123898100000000000000000
94629463244동래통합사업소260동래구2021-08-18하수도요금하수도001251564000000000000000
3951039511301중동부 사업소170동구2021-01-23수용가미수금이월액상수도00511647000000000000000