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

Numeric14
Categorical10
DateTime1
Text1

Dataset

Description부산광역시 상수도사업본부에서 상하수도 요금 계산 및 징수를 위해 운영하는 수용가정보시스템에 사용되는 세입 집계정보(세입 일 집계) 자료입니다.
Author부산광역시 상수도사업본부
URLhttps://www.data.go.kr/data/15083668/fileData.do

Alerts

불납결손건수 has constant value ""Constant
결손취소건수 has constant value ""Constant
당월이중수납건수 is highly imbalanced (95.4%)Imbalance
체납이중수납건수 is highly imbalanced (97.6%)Imbalance
과오건수 is highly imbalanced (97.3%)Imbalance
충당건수 is highly imbalanced (99.6%)Imbalance
충당금액 is highly imbalanced (99.7%)Imbalance
당월이중수납금액 is highly skewed (γ1 = 39.24493615)Skewed
불납결손금액 is highly skewed (γ1 = 53.96712208)Skewed
결손취소금액 is highly skewed (γ1 = 99.83219827)Skewed
반환금액 is highly skewed (γ1 = 35.00849962)Skewed
체납이중수납금액 is highly skewed (γ1 = 38.4576324)Skewed
과오금액 is highly skewed (γ1 = 40.17854261)Skewed
연번 has unique valuesUnique
징수건수 has 5296 (53.0%) zerosZeros
징수금액 has 4662 (46.6%) zerosZeros
수납건수 has 467 (4.7%) zerosZeros
수납금액 has 460 (4.6%) zerosZeros
당월이중수납금액 has 9878 (98.8%) zerosZeros
불납결손금액 has 9939 (99.4%) zerosZeros
결손취소금액 has 9994 (99.9%) zerosZeros
반환건수 has 9812 (98.1%) zerosZeros
반환금액 has 9812 (98.1%) zerosZeros
체납이중수납금액 has 9976 (99.8%) zerosZeros
과오금액 has 9955 (99.6%) zerosZeros

Reproduction

Analysis started2024-03-14 09:01:13.264150
Analysis finished2024-03-14 09:01:14.003799
Duration0.74 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%
Mean44533.187
Minimum1
Maximum88779
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T18:01:14.244128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4548.5
Q122585.75
median44594
Q366674
95-th percentile84241.75
Maximum88779
Range88778
Interquartile range (IQR)44088.25

Descriptive statistics

Standard deviation25539.138
Coefficient of variation (CV)0.57348553
Kurtosis-1.1930067
Mean44533.187
Median Absolute Deviation (MAD)22036
Skewness-0.0081377552
Sum4.4533187 × 108
Variance6.5224757 × 108
MonotonicityNot monotonic
2024-03-14T18:01:14.661953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
44767 1
 
< 0.1%
10334 1
 
< 0.1%
62655 1
 
< 0.1%
71853 1
 
< 0.1%
42764 1
 
< 0.1%
56091 1
 
< 0.1%
2284 1
 
< 0.1%
54105 1
 
< 0.1%
30546 1
 
< 0.1%
12355 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
1 1
< 0.1%
11 1
< 0.1%
22 1
< 0.1%
33 1
< 0.1%
40 1
< 0.1%
44 1
< 0.1%
48 1
< 0.1%
61 1
< 0.1%
68 1
< 0.1%
93 1
< 0.1%
ValueCountFrequency (%)
88779 1
< 0.1%
88778 1
< 0.1%
88775 1
< 0.1%
88772 1
< 0.1%
88763 1
< 0.1%
88758 1
< 0.1%
88748 1
< 0.1%
88744 1
< 0.1%
88739 1
< 0.1%
88738 1
< 0.1%

사업소코드
Real number (ℝ)

Distinct13
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean283.0793
Minimum101
Maximum307
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T18:01:15.037391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum101
5-th percentile244
Q1244
median302
Q3306
95-th percentile307
Maximum307
Range206
Interquartile range (IQR)62

Descriptive statistics

Standard deviation32.744805
Coefficient of variation (CV)0.11567361
Kurtosis5.3403169
Mean283.0793
Median Absolute Deviation (MAD)4
Skewness-1.7843911
Sum2830793
Variance1072.2222
MonotonicityNot monotonic
2024-03-14T18:01:15.399533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
244 3057
30.6%
306 1957
19.6%
301 1444
14.4%
304 1177
 
11.8%
302 875
 
8.8%
303 753
 
7.5%
307 571
 
5.7%
101 76
 
0.8%
201 30
 
0.3%
202 29
 
0.3%
Other values (3) 31
 
0.3%
ValueCountFrequency (%)
101 76
 
0.8%
201 30
 
0.3%
202 29
 
0.3%
203 12
 
0.1%
204 10
 
0.1%
205 9
 
0.1%
244 3057
30.6%
301 1444
14.4%
302 875
 
8.8%
303 753
 
7.5%
ValueCountFrequency (%)
307 571
 
5.7%
306 1957
19.6%
304 1177
 
11.8%
303 753
 
7.5%
302 875
 
8.8%
301 1444
14.4%
244 3057
30.6%
205 9
 
0.1%
204 10
 
0.1%
203 12
 
0.1%

사업소명
Categorical

Distinct13
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
동래통합사업소
3057 
남부사업소
1957 
중동부사업소
1444 
부산진 사업소
1177 
서부 사업소
875 
Other values (8)
1490 

Length

Max length9
Median length8
Mean length6.4711
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
동래통합사업소 3057
30.6%
남부사업소 1957
19.6%
중동부사업소 1444
14.4%
부산진 사업소 1177
 
11.8%
서부 사업소 875
 
8.8%
영도사업소 753
 
7.5%
북부사업소 571
 
5.7%
경영지원부 76
 
0.8%
시설관리사업소 30
 
0.3%
수질연구소 29
 
0.3%
Other values (3) 31
 
0.3%

Length

2024-03-14T18:01:15.833272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
동래통합사업소 3057
25.4%
사업소 2052
17.0%
남부사업소 1957
16.2%
중동부사업소 1444
12.0%
부산진 1177
 
9.8%
서부 875
 
7.3%
영도사업소 753
 
6.2%
북부사업소 571
 
4.7%
경영지원부 76
 
0.6%
시설관리사업소 30
 
0.2%
Other values (4) 60
 
0.5%

구코드
Real number (ℝ)

Distinct17
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean288.3719
Minimum0
Maximum500
Zeros76
Zeros (%)0.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T18:01:16.211919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation126.39794
Coefficient of variation (CV)0.43831572
Kurtosis-1.0303105
Mean288.3719
Median Absolute Deviation (MAD)90
Skewness0.32878587
Sum2883719
Variance15976.439
MonotonicityNot monotonic
2024-03-14T18:01:16.785465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
230 1177
11.8%
410 1036
10.4%
260 1015
10.2%
470 1006
10.1%
290 1002
10.0%
500 955
9.6%
140 875
8.8%
170 843
8.4%
200 753
7.5%
110 601
6.0%
Other values (7) 737
7.4%
ValueCountFrequency (%)
0 76
 
0.8%
110 601
6.0%
140 875
8.8%
170 843
8.4%
200 753
7.5%
201 30
 
0.3%
202 29
 
0.3%
203 12
 
0.1%
204 10
 
0.1%
205 9
 
0.1%
ValueCountFrequency (%)
500 955
9.6%
470 1006
10.1%
410 1036
10.4%
320 571
5.7%
290 1002
10.0%
260 1015
10.2%
230 1177
11.8%
205 9
 
0.1%
204 10
 
0.1%
203 12
 
0.1%

구명
Categorical

Distinct17
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
부산진구
1177 
금정구
1036 
동래구
1015 
연제구
1006 
남구
1002 
Other values (12)
4764 

Length

Max length4
Median length3
Mean length2.7271
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서구
2nd row북구
3rd row남구
4th row북구
5th row금정구

Common Values

ValueCountFrequency (%)
부산진구 1177
11.8%
금정구 1036
10.4%
동래구 1015
10.2%
연제구 1006
10.1%
남구 1002
10.0%
수영구 955
9.6%
서구 875
8.8%
동구 843
8.4%
영도구 753
7.5%
중구 601
6.0%
Other values (7) 737
7.4%

Length

2024-03-14T18:01:17.211362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
부산진구 1177
11.8%
금정구 1036
10.4%
동래구 1015
10.2%
연제구 1006
10.1%
남구 1002
10.0%
수영구 955
9.6%
서구 875
8.8%
동구 843
8.4%
영도구 753
7.5%
중구 601
6.0%
Other values (7) 737
7.4%

결의일자
Date

Distinct363
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-01 00:00:00
Maximum2023-12-31 00:00:00
2024-03-14T18:01:17.596958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:01:18.023312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

예산과목
Text

Distinct105
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-03-14T18:01:18.895861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length13
Mean length8.0462
Min length4

Characters and Unicode

Total characters80462
Distinct characters137
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique13 ?
Unique (%)0.1%

Sample

1st row물이용부담금
2nd row하수도요금
3rd row하수도요금
4th row방수료(일반용)
5th row하수도요금
ValueCountFrequency (%)
하수도요금 1965
17.5%
물이용부담금 1585
14.1%
사용료 1194
 
10.6%
수용가미수금이월액 1192
 
10.6%
사회복지사용료 431
 
3.8%
일반용 423
 
3.8%
가정용 420
 
3.7%
공사방수료(개조 400
 
3.6%
공사방수량(신설 355
 
3.2%
방수료(일반용 232
 
2.1%
Other values (98) 3021
26.9%
2024-03-14T18:01:19.870975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
수 6469
 
8.0%
용 5854
 
7.3%
금 4886
 
6.1%
사 4141
 
5.1%
이 4015
 
5.0%
료 3955
 
4.9%
) 3329
 
4.1%
( 3329
 
4.1%
하 2736
 
3.4%
공 2474
 
3.1%
Other values (127) 39274
48.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 67897
84.4%
Close Punctuation 3329
 
4.1%
Open Punctuation 3329
 
4.1%
Lowercase Letter 2160
 
2.7%
Decimal Number 2160
 
2.7%
Space Separator 1218
 
1.5%
Other Punctuation 369
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
수 6469
 
9.5%
용 5854
 
8.6%
금 4886
 
7.2%
사 4141
 
6.1%
이 4015
 
5.9%
료 3955
 
5.8%
하 2736
 
4.0%
공 2474
 
3.6%
도 2200
 
3.2%
요 1978
 
2.9%
Other values (119) 29189
43.0%
Decimal Number
ValueCountFrequency (%)
2 1080
50.0%
5 765
35.4%
3 315
 
14.6%
Close Punctuation
ValueCountFrequency (%)
) 3329
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3329
100.0%
Lowercase Letter
ValueCountFrequency (%)
m 2160
100.0%
Space Separator
ValueCountFrequency (%)
1218
100.0%
Other Punctuation
ValueCountFrequency (%)
, 369
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 67897
84.4%
Common 10405
 
12.9%
Latin 2160
 
2.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
수 6469
 
9.5%
용 5854
 
8.6%
금 4886
 
7.2%
사 4141
 
6.1%
이 4015
 
5.9%
료 3955
 
5.8%
하 2736
 
4.0%
공 2474
 
3.6%
도 2200
 
3.2%
요 1978
 
2.9%
Other values (119) 29189
43.0%
Common
ValueCountFrequency (%)
) 3329
32.0%
( 3329
32.0%
1218
 
11.7%
2 1080
 
10.4%
5 765
 
7.4%
, 369
 
3.5%
3 315
 
3.0%
Latin
ValueCountFrequency (%)
m 2160
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 67897
84.4%
ASCII 12565
 
15.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
수 6469
 
9.5%
용 5854
 
8.6%
금 4886
 
7.2%
사 4141
 
6.1%
이 4015
 
5.9%
료 3955
 
5.8%
하 2736
 
4.0%
공 2474
 
3.6%
도 2200
 
3.2%
요 1978
 
2.9%
Other values (119) 29189
43.0%
ASCII
ValueCountFrequency (%)
) 3329
26.5%
( 3329
26.5%
m 2160
17.2%
1218
 
9.7%
2 1080
 
8.6%
5 765
 
6.1%
, 369
 
2.9%
3 315
 
2.5%

결의서구분
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
상수도
6450 
하수도
1965 
물이용
1585 

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 (%)
상수도 6450
64.5%
하수도 1965
 
19.7%
물이용 1585
 
15.8%

Length

2024-03-14T18:01:20.098117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T18:01:20.264445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
상수도 6450
64.5%
하수도 1965
 
19.7%
물이용 1585
 
15.8%

징수건수
Real number (ℝ)

ZEROS 

Distinct222
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean92.8091
Minimum0
Maximum13201
Zeros5296
Zeros (%)53.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T18:01:20.470271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q32
95-th percentile7
Maximum13201
Range13201
Interquartile range (IQR)2

Descriptive statistics

Standard deviation777.74574
Coefficient of variation (CV)8.3800591
Kurtosis106.65835
Mean92.8091
Median Absolute Deviation (MAD)0
Skewness9.8652224
Sum928091
Variance604888.44
MonotonicityNot monotonic
2024-03-14T18:01:20.800239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 5296
53.0%
2 1417
 
14.2%
1 1181
 
11.8%
3 724
 
7.2%
4 482
 
4.8%
5 172
 
1.7%
6 161
 
1.6%
8 87
 
0.9%
7 76
 
0.8%
9 45
 
0.4%
Other values (212) 359
 
3.6%
ValueCountFrequency (%)
0 5296
53.0%
1 1181
 
11.8%
2 1417
 
14.2%
3 724
 
7.2%
4 482
 
4.8%
5 172
 
1.7%
6 161
 
1.6%
7 76
 
0.8%
8 87
 
0.9%
9 45
 
0.4%
ValueCountFrequency (%)
13201 1
 
< 0.1%
12830 2
< 0.1%
10767 2
< 0.1%
10680 1
 
< 0.1%
10528 4
< 0.1%
10053 1
 
< 0.1%
9622 1
 
< 0.1%
9505 1
 
< 0.1%
9478 1
 
< 0.1%
9218 1
 
< 0.1%

징수금액
Real number (ℝ)

ZEROS 

Distinct3239
Distinct (%)32.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8323628.7
Minimum-53057600
Maximum1.4877813 × 109
Zeros4662
Zeros (%)46.6%
Negative1221
Negative (%)12.2%
Memory size166.0 KiB
2024-03-14T18:01:21.217382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-53057600
5-th percentile-164906.5
Q10
median0
Q321050
95-th percentile4144000
Maximum1.4877813 × 109
Range1.5408389 × 109
Interquartile range (IQR)21050

Descriptive statistics

Standard deviation71227547
Coefficient of variation (CV)8.5572711
Kurtosis160.41815
Mean8323628.7
Median Absolute Deviation (MAD)2525
Skewness11.832415
Sum8.3236287 × 1010
Variance5.0733634 × 1015
MonotonicityNot monotonic
2024-03-14T18:01:21.528534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4662
46.6%
14000 389
 
3.9%
7000 206
 
2.1%
28000 88
 
0.9%
1018000 67
 
0.7%
1904000 55
 
0.5%
21000 54
 
0.5%
18000 48
 
0.5%
1503000 34
 
0.3%
42000 29
 
0.3%
Other values (3229) 4368
43.7%
ValueCountFrequency (%)
-53057600 1
< 0.1%
-12483750 1
< 0.1%
-12276100 1
< 0.1%
-12034210 1
< 0.1%
-7348080 1
< 0.1%
-5469030 1
< 0.1%
-5322435 2
< 0.1%
-5086900 1
< 0.1%
-4547590 1
< 0.1%
-4501632 1
< 0.1%
ValueCountFrequency (%)
1487781280 1
< 0.1%
1337802520 1
< 0.1%
1250000000 1
< 0.1%
1198733500 1
< 0.1%
1175579640 1
< 0.1%
1169873030 1
< 0.1%
1162216540 1
< 0.1%
1154463560 1
< 0.1%
1150403500 1
< 0.1%
1135994240 1
< 0.1%

수납건수
Real number (ℝ)

ZEROS 

Distinct528
Distinct (%)5.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean82.6401
Minimum0
Maximum7956
Zeros467
Zeros (%)4.7%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T18:01:22.030464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q12
median6
Q331
95-th percentile218
Maximum7956
Range7956
Interquartile range (IQR)29

Descriptive statistics

Standard deviation441.05406
Coefficient of variation (CV)5.3370465
Kurtosis106.49507
Mean82.6401
Median Absolute Deviation (MAD)5
Skewness9.8234208
Sum826401
Variance194528.68
MonotonicityNot monotonic
2024-03-14T18:01:22.488190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2 1360
 
13.6%
1 1357
 
13.6%
3 768
 
7.7%
4 530
 
5.3%
0 467
 
4.7%
5 309
 
3.1%
6 267
 
2.7%
8 211
 
2.1%
7 185
 
1.8%
10 160
 
1.6%
Other values (518) 4386
43.9%
ValueCountFrequency (%)
0 467
 
4.7%
1 1357
13.6%
2 1360
13.6%
3 768
7.7%
4 530
 
5.3%
5 309
 
3.1%
6 267
 
2.7%
7 185
 
1.8%
8 211
 
2.1%
9 155
 
1.6%
ValueCountFrequency (%)
7956 1
< 0.1%
6873 1
< 0.1%
6848 1
< 0.1%
6362 1
< 0.1%
5946 1
< 0.1%
5803 1
< 0.1%
5558 1
< 0.1%
5555 1
< 0.1%
5540 1
< 0.1%
5376 2
< 0.1%

수납금액
Real number (ℝ)

ZEROS 

Distinct6941
Distinct (%)69.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9544683
Minimum0
Maximum1.25 × 109
Zeros460
Zeros (%)4.6%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T18:01:22.968098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile450
Q135985
median369700
Q31904000
95-th percentile19513492
Maximum1.25 × 109
Range1.25 × 109
Interquartile range (IQR)1868015

Descriptive statistics

Standard deviation64665739
Coefficient of variation (CV)6.7750536
Kurtosis146.14395
Mean9544683
Median Absolute Deviation (MAD)362700
Skewness11.376089
Sum9.544683 × 1010
Variance4.1816578 × 1015
MonotonicityNot monotonic
2024-03-14T18:01:23.475497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 460
 
4.6%
14000 367
 
3.7%
7000 325
 
3.2%
21000 94
 
0.9%
28000 89
 
0.9%
1018000 69
 
0.7%
1904000 56
 
0.6%
18000 52
 
0.5%
1503000 34
 
0.3%
42000 30
 
0.3%
Other values (6931) 8424
84.2%
ValueCountFrequency (%)
0 460
4.6%
10 1
 
< 0.1%
60 2
 
< 0.1%
70 1
 
< 0.1%
100 2
 
< 0.1%
120 1
 
< 0.1%
140 8
 
0.1%
150 4
 
< 0.1%
160 1
 
< 0.1%
240 1
 
< 0.1%
ValueCountFrequency (%)
1250000000 1
< 0.1%
1197409820 1
< 0.1%
1150403500 1
< 0.1%
1076873250 1
< 0.1%
1057136000 1
< 0.1%
1056316550 1
< 0.1%
958404970 1
< 0.1%
941294290 1
< 0.1%
929279160 1
< 0.1%
908987890 2
< 0.1%

당월이중수납건수
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9878 
1
 
99
2
 
17
3
 
5
4
 
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 9878
98.8%
1 99
 
1.0%
2 17
 
0.2%
3 5
 
0.1%
4 1
 
< 0.1%

Length

2024-03-14T18:01:23.840922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T18:01:24.124313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9878
98.8%
1 99
 
1.0%
2 17
 
0.2%
3 5
 
< 0.1%
4 1
 
< 0.1%

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

SKEWED  ZEROS 

Distinct115
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1181.232
Minimum0
Maximum1512260
Zeros9878
Zeros (%)98.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T18:01:24.456314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum1512260
Range1512260
Interquartile range (IQR)0

Descriptive statistics

Standard deviation24927.89
Coefficient of variation (CV)21.103298
Kurtosis1912.4584
Mean1181.232
Median Absolute Deviation (MAD)0
Skewness39.244936
Sum11812320
Variance6.2139972 × 108
MonotonicityNot monotonic
2024-03-14T18:01:24.942389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9878
98.8%
9000 2
 
< 0.1%
120720 2
 
< 0.1%
1060 2
 
< 0.1%
22620 2
 
< 0.1%
2380 2
 
< 0.1%
19290 2
 
< 0.1%
25200 2
 
< 0.1%
19540 2
 
< 0.1%
31620 1
 
< 0.1%
Other values (105) 105
 
1.1%
ValueCountFrequency (%)
0 9878
98.8%
140 1
 
< 0.1%
440 1
 
< 0.1%
740 1
 
< 0.1%
900 1
 
< 0.1%
1060 2
 
< 0.1%
1070 1
 
< 0.1%
1190 1
 
< 0.1%
1200 1
 
< 0.1%
1500 1
 
< 0.1%
ValueCountFrequency (%)
1512260 1
< 0.1%
1058960 1
< 0.1%
848210 1
< 0.1%
653130 1
< 0.1%
551680 1
< 0.1%
486350 1
< 0.1%
407330 1
< 0.1%
369890 1
< 0.1%
349320 1
< 0.1%
243840 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

2024-03-14T18:01:25.304770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T18:01:25.534319image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

불납결손금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct55
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4289.481
Minimum0
Maximum11495980
Zeros9939
Zeros (%)99.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T18:01:25.875794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum11495980
Range11495980
Interquartile range (IQR)0

Descriptive statistics

Standard deviation154377.82
Coefficient of variation (CV)35.98986
Kurtosis3456.3841
Mean4289.481
Median Absolute Deviation (MAD)0
Skewness53.967122
Sum42894810
Variance2.3832512 × 1010
MonotonicityNot monotonic
2024-03-14T18:01:26.349823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9939
99.4%
2470 3
 
< 0.1%
5226360 2
 
< 0.1%
17360 2
 
< 0.1%
10020 2
 
< 0.1%
3230 2
 
< 0.1%
52360 2
 
< 0.1%
7410 1
 
< 0.1%
4172620 1
 
< 0.1%
675380 1
 
< 0.1%
Other values (45) 45
 
0.4%
ValueCountFrequency (%)
0 9939
99.4%
280 1
 
< 0.1%
1420 1
 
< 0.1%
2460 1
 
< 0.1%
2470 3
 
< 0.1%
3180 1
 
< 0.1%
3230 2
 
< 0.1%
4940 1
 
< 0.1%
5500 1
 
< 0.1%
7000 1
 
< 0.1%
ValueCountFrequency (%)
11495980 1
< 0.1%
5226360 2
< 0.1%
4276780 1
< 0.1%
4172620 1
< 0.1%
2435850 1
< 0.1%
2428410 1
< 0.1%
1296500 1
< 0.1%
792900 1
< 0.1%
699880 1
< 0.1%
675380 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

2024-03-14T18:01:26.768759image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T18:01:27.059037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

결손취소금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean113.585
Minimum0
Maximum1069030
Zeros9994
Zeros (%)99.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T18:01:27.335693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum1069030
Range1069030
Interquartile range (IQR)0

Descriptive statistics

Standard deviation10696.308
Coefficient of variation (CV)94.170079
Kurtosis9977.2996
Mean113.585
Median Absolute Deviation (MAD)0
Skewness99.832198
Sum1135850
Variance1.1441101 × 108
MonotonicityNot monotonic
2024-03-14T18:01:27.650366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
0 9994
99.9%
12350 1
 
< 0.1%
1069030 1
 
< 0.1%
2780 1
 
< 0.1%
29390 1
 
< 0.1%
14820 1
 
< 0.1%
7480 1
 
< 0.1%
ValueCountFrequency (%)
0 9994
99.9%
2780 1
 
< 0.1%
7480 1
 
< 0.1%
12350 1
 
< 0.1%
14820 1
 
< 0.1%
29390 1
 
< 0.1%
1069030 1
 
< 0.1%
ValueCountFrequency (%)
1069030 1
 
< 0.1%
29390 1
 
< 0.1%
14820 1
 
< 0.1%
12350 1
 
< 0.1%
7480 1
 
< 0.1%
2780 1
 
< 0.1%
0 9994
99.9%

반환건수
Real number (ℝ)

ZEROS 

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.0301
Minimum0
Maximum8
Zeros9812
Zeros (%)98.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T18:01:28.039612image/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.26306066
Coefficient of variation (CV)8.7395568
Kurtosis237.00346
Mean0.0301
Median Absolute Deviation (MAD)0
Skewness13.145232
Sum301
Variance0.06920091
MonotonicityNot monotonic
2024-03-14T18:01:28.325356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
0 9812
98.1%
1 123
 
1.2%
2 36
 
0.4%
3 21
 
0.2%
4 3
 
< 0.1%
6 3
 
< 0.1%
8 1
 
< 0.1%
5 1
 
< 0.1%
ValueCountFrequency (%)
0 9812
98.1%
1 123
 
1.2%
2 36
 
0.4%
3 21
 
0.2%
4 3
 
< 0.1%
5 1
 
< 0.1%
6 3
 
< 0.1%
8 1
 
< 0.1%
ValueCountFrequency (%)
8 1
 
< 0.1%
6 3
 
< 0.1%
5 1
 
< 0.1%
4 3
 
< 0.1%
3 21
 
0.2%
2 36
 
0.4%
1 123
 
1.2%
0 9812
98.1%

반환금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct156
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14642.528
Minimum0
Maximum14387750
Zeros9812
Zeros (%)98.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T18:01:28.568849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum14387750
Range14387750
Interquartile range (IQR)0

Descriptive statistics

Standard deviation318131.98
Coefficient of variation (CV)21.726574
Kurtosis1420.3909
Mean14642.528
Median Absolute Deviation (MAD)0
Skewness35.0085
Sum1.4642528 × 108
Variance1.0120795 × 1011
MonotonicityNot monotonic
2024-03-14T18:01:28.829133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9812
98.1%
7000 5
 
0.1%
2927000 4
 
< 0.1%
1330 3
 
< 0.1%
4126920 2
 
< 0.1%
14000 2
 
< 0.1%
192820 2
 
< 0.1%
41710 2
 
< 0.1%
1134530 2
 
< 0.1%
1504000 2
 
< 0.1%
Other values (146) 164
 
1.6%
ValueCountFrequency (%)
0 9812
98.1%
150 1
 
< 0.1%
460 1
 
< 0.1%
720 1
 
< 0.1%
910 1
 
< 0.1%
1330 3
 
< 0.1%
1820 1
 
< 0.1%
1970 1
 
< 0.1%
2270 1
 
< 0.1%
2380 2
 
< 0.1%
ValueCountFrequency (%)
14387750 1
< 0.1%
13988240 2
< 0.1%
12276100 1
< 0.1%
5322435 2
< 0.1%
4547590 1
< 0.1%
4501632 1
< 0.1%
4126920 2
< 0.1%
3683840 1
< 0.1%
3557390 1
< 0.1%
3472190 2
< 0.1%

체납이중수납건수
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9976 
1
 
24

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 9976
99.8%
1 24
 
0.2%

Length

2024-03-14T18:01:29.066591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T18:01:29.224436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9976
99.8%
1 24
 
0.2%

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

SKEWED  ZEROS 

Distinct22
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean78.661
Minimum0
Maximum113560
Zeros9976
Zeros (%)99.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T18:01:29.473200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum113560
Range113560
Interquartile range (IQR)0

Descriptive statistics

Standard deviation2305.0935
Coefficient of variation (CV)29.304147
Kurtosis1635.027
Mean78.661
Median Absolute Deviation (MAD)0
Skewness38.457632
Sum786610
Variance5313456
MonotonicityNot monotonic
2024-03-14T18:01:29.674294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
0 9976
99.8%
8680 2
 
< 0.1%
2490 2
 
< 0.1%
35340 2
 
< 0.1%
5740 1
 
< 0.1%
113560 1
 
< 0.1%
20920 1
 
< 0.1%
104290 1
 
< 0.1%
14820 1
 
< 0.1%
22240 1
 
< 0.1%
Other values (12) 12
 
0.1%
ValueCountFrequency (%)
0 9976
99.8%
2490 2
 
< 0.1%
5720 1
 
< 0.1%
5740 1
 
< 0.1%
5970 1
 
< 0.1%
7410 1
 
< 0.1%
8680 2
 
< 0.1%
11120 1
 
< 0.1%
12810 1
 
< 0.1%
14820 1
 
< 0.1%
ValueCountFrequency (%)
113560 1
< 0.1%
104720 1
< 0.1%
104290 1
< 0.1%
70930 1
< 0.1%
69210 1
< 0.1%
45320 1
< 0.1%
38810 1
< 0.1%
35340 2
< 0.1%
22700 1
< 0.1%
22240 1
< 0.1%

과오건수
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9955 
1
 
44
2
 
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 9955
99.6%
1 44
 
0.4%
2 1
 
< 0.1%

Length

2024-03-14T18:01:29.885959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T18:01:30.049247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9955
99.6%
1 44
 
0.4%
2 1
 
< 0.1%

과오금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct43
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean207.711
Minimum-62360
Maximum354040
Zeros9955
Zeros (%)99.6%
Negative2
Negative (%)< 0.1%
Memory size166.0 KiB
2024-03-14T18:01:30.236135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-62360
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum354040
Range416400
Interquartile range (IQR)0

Descriptive statistics

Standard deviation6332.8576
Coefficient of variation (CV)30.488793
Kurtosis1878.758
Mean207.711
Median Absolute Deviation (MAD)0
Skewness40.178543
Sum2077110
Variance40105086
MonotonicityNot monotonic
2024-03-14T18:01:30.480793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=43)
ValueCountFrequency (%)
0 9955
99.6%
42520 2
 
< 0.1%
18920 2
 
< 0.1%
2470 2
 
< 0.1%
3840 1
 
< 0.1%
27250 1
 
< 0.1%
1340 1
 
< 0.1%
229730 1
 
< 0.1%
19000 1
 
< 0.1%
11600 1
 
< 0.1%
Other values (33) 33
 
0.3%
ValueCountFrequency (%)
-62360 1
 
< 0.1%
-54820 1
 
< 0.1%
0 9955
99.6%
140 1
 
< 0.1%
200 1
 
< 0.1%
350 1
 
< 0.1%
470 1
 
< 0.1%
1230 1
 
< 0.1%
1340 1
 
< 0.1%
2100 1
 
< 0.1%
ValueCountFrequency (%)
354040 1
< 0.1%
308840 1
< 0.1%
229730 1
< 0.1%
191600 1
< 0.1%
174840 1
< 0.1%
131680 1
< 0.1%
81620 1
< 0.1%
71480 1
< 0.1%
68140 1
< 0.1%
57760 1
< 0.1%

충당건수
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9995 
1
 
3
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 9995
> 99.9%
1 3
 
< 0.1%
2 2
 
< 0.1%

Length

2024-03-14T18:01:30.757808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T18:01:30.922269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9995
> 99.9%
1 3
 
< 0.1%
2 2
 
< 0.1%

충당금액
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9995 
31850
 
2
22240
 
2
3960
 
1

Length

Max length5
Median length1
Mean length1.0019
Min length1

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
0 9995
> 99.9%
31850 2
 
< 0.1%
22240 2
 
< 0.1%
3960 1
 
< 0.1%

Length

2024-03-14T18:01:31.120937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T18:01:31.311557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9995
> 99.9%
31850 2
 
< 0.1%
22240 2
 
< 0.1%
3960 1
 
< 0.1%

Sample

연번사업소코드사업소명구코드구명결의일자예산과목결의서구분징수건수징수금액수납건수수납금액당월이중수납건수당월이중수납금액불납결손건수불납결손금액결손취소건수결손취소금액반환건수반환금액체납이중수납건수체납이중수납금액과오건수과오금액충당건수충당금액
4476644767302서부 사업소140서구2023-05-03물이용부담금물이용0042103000000000000000
8639686397307북부사업소320북구2023-05-07하수도요금하수도0043965000000000000000
7235372354306남부사업소290남구2023-08-06하수도요금하수도0011175000000000000000
8546885469307북부사업소320북구2023-03-22방수료(일반용)상수도349601371323908000000000000000
1163911640244동래통합사업소410금정구2023-01-24하수도요금하수도001231810000000000000000
6202862029304부산진 사업소230부산진구2023-07-06설계료(공동주택)상수도5251410525141000000000000000
1143611437244동래통합사업소410금정구2023-01-19수용가미수금이월액상수도0-2012091331986000000000000000
6854268543306남부사업소290남구2023-03-02준공검사료(25mm이하)상수도2406000341300000000000000000
8202682027306남부사업소500수영구2023-10-17성능검사료(32mm이상)상수도170000000000000000000
772773201시설관리사업소201시설2023-04-20토지임대수입상수도00120746000000000000000
연번사업소코드사업소명구코드구명결의일자예산과목결의서구분징수건수징수금액수납건수수납금액당월이중수납건수당월이중수납금액불납결손건수불납결손금액결손취소건수결손취소금액반환건수반환금액체납이중수납건수체납이중수납금액과오건수과오금액충당건수충당금액
1647916480244동래통합사업소410금정구2023-07-14물이용부담금물이용0024704000000000000000
1750117502244동래통합사업소410금정구2023-08-31하수도요금하수도002553000000000000000
2487024871244동래통합사업소470연제구2023-06-06하수도요금하수도00529157000000000000000
2939429395301중동부사업소110중구2023-01-09정수해제료(25mm이하)상수도5350000000000000000000
5562455625303영도사업소200영도구2023-12-20설계료(비정액제)상수도42800042800000000000000000
81728173244동래통합사업소260동래구2023-09-10일반용 사용료상수도00633748000000000000000
5599455995304부산진 사업소230부산진구2023-01-05물이용부담금물이용31387021628000000013160000000
1239612397244동래통합사업소410금정구2023-02-13물이용부담금물이용0-4640822875000000000000000
1778117782244동래통합사업소410금정구2023-09-15공사방수료(개조)상수도1-6920101453549000000000000000
5485554856303영도사업소200영도구2023-10-22물이용부담금물이용003617064000000000000000