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부산광역시상수도사업본부_수용가정보시스템_세입집계정보_세입일집계_20230126
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 (94.9%)Imbalance
체납이중수납건수 is highly imbalanced (98.1%)Imbalance
과오건수 is highly imbalanced (98.5%)Imbalance
충당건수 is highly imbalanced (99.7%)Imbalance
충당금액 is highly imbalanced (99.8%)Imbalance
당월이중수납금액 is highly skewed (γ1 = 80.09770861)Skewed
불납결손금액 is highly skewed (γ1 = 73.21795135)Skewed
결손취소금액 is highly skewed (γ1 = 75.06628476)Skewed
반환금액 is highly skewed (γ1 = 88.9922874)Skewed
체납이중수납금액 is highly skewed (γ1 = 36.73456584)Skewed
과오금액 is highly skewed (γ1 = 46.44816087)Skewed
연번 has unique valuesUnique
징수건수 has 4976 (49.8%) zerosZeros
징수금액 has 4343 (43.4%) zerosZeros
수납건수 has 427 (4.3%) zerosZeros
수납금액 has 420 (4.2%) zerosZeros
당월이중수납금액 has 9905 (99.1%) zerosZeros
불납결손금액 has 9961 (99.6%) zerosZeros
결손취소금액 has 9993 (99.9%) zerosZeros
반환건수 has 9828 (98.3%) zerosZeros
반환금액 has 9828 (98.3%) zerosZeros
체납이중수납금액 has 9982 (99.8%) zerosZeros
과오금액 has 9972 (99.7%) zerosZeros

Reproduction

Analysis started2023-12-10 16:38:57.259890
Analysis finished2023-12-10 16:38:57.826707
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%
Mean43785.479
Minimum5
Maximum87129
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:38:57.922979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum5
5-th percentile4264.1
Q122468.75
median44238
Q365136
95-th percentile82665.05
Maximum87129
Range87124
Interquartile range (IQR)42667.25

Descriptive statistics

Standard deviation24968.052
Coefficient of variation (CV)0.5702359
Kurtosis-1.180539
Mean43785.479
Median Absolute Deviation (MAD)21321
Skewness-0.024045854
Sum4.3785479 × 108
Variance6.2340362 × 108
MonotonicityNot monotonic
2023-12-11T01:38:58.110608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
51711 1
 
< 0.1%
65537 1
 
< 0.1%
59426 1
 
< 0.1%
70770 1
 
< 0.1%
20815 1
 
< 0.1%
5094 1
 
< 0.1%
70076 1
 
< 0.1%
86798 1
 
< 0.1%
56268 1
 
< 0.1%
81658 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
5 1
< 0.1%
19 1
< 0.1%
26 1
< 0.1%
28 1
< 0.1%
29 1
< 0.1%
48 1
< 0.1%
49 1
< 0.1%
54 1
< 0.1%
57 1
< 0.1%
62 1
< 0.1%
ValueCountFrequency (%)
87129 1
< 0.1%
87107 1
< 0.1%
87105 1
< 0.1%
87096 1
< 0.1%
87067 1
< 0.1%
87050 1
< 0.1%
87048 1
< 0.1%
87047 1
< 0.1%
87044 1
< 0.1%
87034 1
< 0.1%

사업소코드
Real number (ℝ)

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

Quantile statistics

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

Descriptive statistics

Standard deviation33.436337
Coefficient of variation (CV)0.11884854
Kurtosis4.6148343
Mean281.3357
Median Absolute Deviation (MAD)4
Skewness-1.6541439
Sum2813357
Variance1117.9886
MonotonicityNot monotonic
2023-12-11T01:38:58.460936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
244 3223
32.2%
306 2026
20.3%
301 1342
13.4%
304 1340
13.4%
302 942
 
9.4%
303 904
 
9.0%
101 77
 
0.8%
201 56
 
0.6%
202 46
 
0.5%
203 24
 
0.2%
Other values (2) 20
 
0.2%
ValueCountFrequency (%)
101 77
 
0.8%
201 56
 
0.6%
202 46
 
0.5%
203 24
 
0.2%
204 6
 
0.1%
205 14
 
0.1%
244 3223
32.2%
301 1342
13.4%
302 942
 
9.4%
303 904
 
9.0%
ValueCountFrequency (%)
306 2026
20.3%
304 1340
13.4%
303 904
 
9.0%
302 942
 
9.4%
301 1342
13.4%
244 3223
32.2%
205 14
 
0.1%
204 6
 
0.1%
203 24
 
0.2%
202 46
 
0.5%

사업소명
Categorical

Distinct12
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
동래통합사업소
3223 
남부 사업소
2026 
중동부 사업소
1342 
부산진 사업소
1340 
서부 사업소
942 
Other values (7)
1127 

Length

Max length9
Median length8
Mean length8.018
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row영도 사업소
2nd row영도 사업소
3rd row동래통합사업소
4th row중동부 사업소
5th row동래통합사업소

Common Values

ValueCountFrequency (%)
동래통합사업소 3223
32.2%
남부 사업소 2026
20.3%
중동부 사업소 1342
13.4%
부산진 사업소 1340
13.4%
서부 사업소 942
 
9.4%
영도 사업소 904
 
9.0%
경영지원부 77
 
0.8%
시설관리사업소 56
 
0.6%
수질연구소 46
 
0.5%
명장정수사업소 24
 
0.2%
Other values (2) 20
 
0.2%

Length

2023-12-11T01:38:58.624151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
사업소 6554
39.6%
동래통합사업소 3223
19.5%
남부 2026
 
12.2%
중동부 1342
 
8.1%
부산진 1340
 
8.1%
서부 942
 
5.7%
영도 904
 
5.5%
경영지원부 77
 
0.5%
시설관리사업소 56
 
0.3%
수질연구소 46
 
0.3%
Other values (3) 44
 
0.3%

구코드
Real number (ℝ)

Distinct16
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean284.1204
Minimum0
Maximum500
Zeros77
Zeros (%)0.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:38:58.774746image/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.84545
Coefficient of variation (CV)0.44644963
Kurtosis-1.0178796
Mean284.1204
Median Absolute Deviation (MAD)90
Skewness0.40974824
Sum2841204
Variance16089.767
MonotonicityNot monotonic
2023-12-11T01:38:58.904250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%)
230 1340
13.4%
260 1106
11.1%
290 1104
11.0%
410 1100
11.0%
470 1017
10.2%
140 942
9.4%
500 922
9.2%
200 904
9.0%
170 758
7.6%
110 584
5.8%
Other values (6) 223
 
2.2%
ValueCountFrequency (%)
0 77
 
0.8%
110 584
5.8%
140 942
9.4%
170 758
7.6%
200 904
9.0%
201 56
 
0.6%
202 46
 
0.5%
203 24
 
0.2%
204 6
 
0.1%
205 14
 
0.1%
ValueCountFrequency (%)
500 922
9.2%
470 1017
10.2%
410 1100
11.0%
290 1104
11.0%
260 1106
11.1%
230 1340
13.4%
205 14
 
0.1%
204 6
 
0.1%
203 24
 
0.2%
202 46
 
0.5%

구명
Categorical

Distinct16
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
부산진구
1340 
동래구
1106 
남구
1104 
금정구
1100 
연제구
1017 
Other values (11)
4333 

Length

Max length4
Median length3
Mean length2.7883
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row영도구
2nd row영도구
3rd row연제구
4th row동구
5th row동래구

Common Values

ValueCountFrequency (%)
부산진구 1340
13.4%
동래구 1106
11.1%
남구 1104
11.0%
금정구 1100
11.0%
연제구 1017
10.2%
서구 942
9.4%
수영구 922
9.2%
영도구 904
9.0%
동구 758
7.6%
중구 584
5.8%
Other values (6) 223
 
2.2%

Length

2023-12-11T01:38:59.044272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
부산진구 1340
13.4%
동래구 1106
11.1%
남구 1104
11.0%
금정구 1100
11.0%
연제구 1017
10.2%
서구 942
9.4%
수영구 922
9.2%
영도구 904
9.0%
동구 758
7.6%
중구 584
5.8%
Other values (6) 223
 
2.2%

결의일자
Date

Distinct362
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-01-01 00:00:00
Maximum2022-12-31 00:00:00
2023-12-11T01:38:59.202421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:38:59.374038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

예산과목
Text

Distinct108
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T01:38:59.636579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length14
Mean length8.1591
Min length4

Characters and Unicode

Total characters81591
Distinct characters145
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

Unique12 ?
Unique (%)0.1%

Sample

1st row물이용부담금
2nd row수용가미수금이월액
3rd row사회복지사용료
4th row하수도요금
5th row자재비(구경확대)
ValueCountFrequency (%)
하수도요금 1918
17.1%
물이용부담금 1537
13.7%
사용료 1184
 
10.5%
수용가미수금이월액 986
 
8.8%
가정용 456
 
4.1%
사회복지사용료 414
 
3.7%
일반용 402
 
3.6%
공사방수료(개조 342
 
3.0%
공사방수량(신설 328
 
2.9%
방수료(일반용 240
 
2.1%
Other values (104) 3424
30.5%
2023-12-11T01:39:00.035921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
수 6009
 
7.4%
용 5606
 
6.9%
금 4720
 
5.8%
사 4084
 
5.0%
료 3968
 
4.9%
이 3704
 
4.5%
) 3597
 
4.4%
( 3597
 
4.4%
하 2641
 
3.2%
공 2570
 
3.1%
Other values (135) 41095
50.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 68565
84.0%
Close Punctuation 3597
 
4.4%
Open Punctuation 3597
 
4.4%
Lowercase Letter 2066
 
2.5%
Decimal Number 2066
 
2.5%
Space Separator 1231
 
1.5%
Other Punctuation 469
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
수 6009
 
8.8%
용 5606
 
8.2%
금 4720
 
6.9%
사 4084
 
6.0%
료 3968
 
5.8%
이 3704
 
5.4%
하 2641
 
3.9%
공 2570
 
3.7%
도 2139
 
3.1%
요 1930
 
2.8%
Other values (127) 31194
45.5%
Decimal Number
ValueCountFrequency (%)
2 1033
50.0%
5 715
34.6%
3 318
 
15.4%
Close Punctuation
ValueCountFrequency (%)
) 3597
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3597
100.0%
Lowercase Letter
ValueCountFrequency (%)
m 2066
100.0%
Space Separator
ValueCountFrequency (%)
1231
100.0%
Other Punctuation
ValueCountFrequency (%)
, 469
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 68565
84.0%
Common 10960
 
13.4%
Latin 2066
 
2.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
수 6009
 
8.8%
용 5606
 
8.2%
금 4720
 
6.9%
사 4084
 
6.0%
료 3968
 
5.8%
이 3704
 
5.4%
하 2641
 
3.9%
공 2570
 
3.7%
도 2139
 
3.1%
요 1930
 
2.8%
Other values (127) 31194
45.5%
Common
ValueCountFrequency (%)
) 3597
32.8%
( 3597
32.8%
1231
 
11.2%
2 1033
 
9.4%
5 715
 
6.5%
, 469
 
4.3%
3 318
 
2.9%
Latin
ValueCountFrequency (%)
m 2066
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 68565
84.0%
ASCII 13026
 
16.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
수 6009
 
8.8%
용 5606
 
8.2%
금 4720
 
6.9%
사 4084
 
6.0%
료 3968
 
5.8%
이 3704
 
5.4%
하 2641
 
3.9%
공 2570
 
3.7%
도 2139
 
3.1%
요 1930
 
2.8%
Other values (127) 31194
45.5%
ASCII
ValueCountFrequency (%)
) 3597
27.6%
( 3597
27.6%
m 2066
15.9%
1231
 
9.5%
2 1033
 
7.9%
5 715
 
5.5%
, 469
 
3.6%
3 318
 
2.4%

결의서구분
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
상수도
6545 
하수도
1918 
물이용
1537 

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 (%)
상수도 6545
65.5%
하수도 1918
 
19.2%
물이용 1537
 
15.4%

Length

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

Common Values (Plot)

2023-12-11T01:39:00.314694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
상수도 6545
65.5%
하수도 1918
 
19.2%
물이용 1537
 
15.4%

징수건수
Real number (ℝ)

ZEROS 

Distinct204
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean80.9062
Minimum-14
Maximum12649
Zeros4976
Zeros (%)49.8%
Negative2
Negative (%)< 0.1%
Memory size166.0 KiB
2023-12-11T01:39:00.692589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-14
5-th percentile0
Q10
median1
Q32
95-th percentile7
Maximum12649
Range12663
Interquartile range (IQR)2

Descriptive statistics

Standard deviation705.77039
Coefficient of variation (CV)8.7233166
Kurtosis111.29427
Mean80.9062
Median Absolute Deviation (MAD)1
Skewness10.13218
Sum809062
Variance498111.85
MonotonicityNot monotonic
2023-12-11T01:39:00.901675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4976
49.8%
2 1461
 
14.6%
1 1184
 
11.8%
3 804
 
8.0%
4 565
 
5.7%
5 254
 
2.5%
6 203
 
2.0%
7 91
 
0.9%
8 67
 
0.7%
9 41
 
0.4%
Other values (194) 354
 
3.5%
ValueCountFrequency (%)
-14 1
 
< 0.1%
-10 1
 
< 0.1%
0 4976
49.8%
1 1184
 
11.8%
2 1461
 
14.6%
3 804
 
8.0%
4 565
 
5.7%
5 254
 
2.5%
6 203
 
2.0%
7 91
 
0.9%
ValueCountFrequency (%)
12649 1
< 0.1%
11040 1
< 0.1%
11006 1
< 0.1%
10341 1
< 0.1%
10306 1
< 0.1%
9927 1
< 0.1%
9255 1
< 0.1%
9195 1
< 0.1%
9192 1
< 0.1%
8912 1
< 0.1%

징수금액
Real number (ℝ)

ZEROS 

Distinct3352
Distinct (%)33.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9643779.9
Minimum-63979000
Maximum2.71 × 109
Zeros4343
Zeros (%)43.4%
Negative1218
Negative (%)12.2%
Memory size166.0 KiB
2023-12-11T01:39:01.072836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-63979000
5-th percentile-143772
Q10
median0
Q343202.5
95-th percentile5904000
Maximum2.71 × 109
Range2.773979 × 109
Interquartile range (IQR)43202.5

Descriptive statistics

Standard deviation82095405
Coefficient of variation (CV)8.5127829
Kurtosis225.17682
Mean9643779.9
Median Absolute Deviation (MAD)7000
Skewness12.840621
Sum9.6437799 × 1010
Variance6.7396555 × 1015
MonotonicityNot monotonic
2023-12-11T01:39:01.222699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4343
43.4%
14000 353
 
3.5%
7000 196
 
2.0%
28000 106
 
1.1%
21000 71
 
0.7%
1904000 63
 
0.6%
1018000 57
 
0.6%
18000 47
 
0.5%
1503000 37
 
0.4%
310000 35
 
0.4%
Other values (3342) 4692
46.9%
ValueCountFrequency (%)
-63979000 1
< 0.1%
-31900090 1
< 0.1%
-14761600 1
< 0.1%
-14041800 1
< 0.1%
-8670970 1
< 0.1%
-8060620 1
< 0.1%
-7342730 1
< 0.1%
-7140590 1
< 0.1%
-6725720 1
< 0.1%
-6087780 1
< 0.1%
ValueCountFrequency (%)
2710000000 1
< 0.1%
1505417970 1
< 0.1%
1413620800 1
< 0.1%
1310546840 1
< 0.1%
1308980050 1
< 0.1%
1190709890 1
< 0.1%
1158137260 1
< 0.1%
1147143280 1
< 0.1%
1120997960 1
< 0.1%
1094809810 1
< 0.1%

수납건수
Real number (ℝ)

ZEROS 

Distinct523
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean77.1677
Minimum0
Maximum7893
Zeros427
Zeros (%)4.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:01.387458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q12
median5
Q328
95-th percentile238
Maximum7893
Range7893
Interquartile range (IQR)26

Descriptive statistics

Standard deviation418.52883
Coefficient of variation (CV)5.4236271
Kurtosis129.80996
Mean77.1677
Median Absolute Deviation (MAD)4
Skewness10.738777
Sum771677
Variance175166.38
MonotonicityNot monotonic
2023-12-11T01:39:01.545420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1480
 
14.8%
2 1469
 
14.7%
3 736
 
7.4%
4 617
 
6.2%
0 427
 
4.3%
5 339
 
3.4%
6 300
 
3.0%
8 176
 
1.8%
7 176
 
1.8%
9 173
 
1.7%
Other values (513) 4107
41.1%
ValueCountFrequency (%)
0 427
 
4.3%
1 1480
14.8%
2 1469
14.7%
3 736
7.4%
4 617
6.2%
5 339
 
3.4%
6 300
 
3.0%
7 176
 
1.8%
8 176
 
1.8%
9 173
 
1.7%
ValueCountFrequency (%)
7893 1
< 0.1%
7831 1
< 0.1%
6949 1
< 0.1%
6640 1
< 0.1%
6310 1
< 0.1%
6181 1
< 0.1%
5932 1
< 0.1%
5887 1
< 0.1%
5787 1
< 0.1%
5772 1
< 0.1%

수납금액
Real number (ℝ)

ZEROS 

Distinct6904
Distinct (%)69.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8886165.3
Minimum0
Maximum1.3528852 × 109
Zeros420
Zeros (%)4.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:01.741284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1340
Q140722.5
median376720
Q31948830
95-th percentile20001628
Maximum1.3528852 × 109
Range1.3528852 × 109
Interquartile range (IQR)1908107.5

Descriptive statistics

Standard deviation59567787
Coefficient of variation (CV)6.7034299
Kurtosis165.52404
Mean8886165.3
Median Absolute Deviation (MAD)369720
Skewness12.00681
Sum8.8861653 × 1010
Variance3.5483212 × 1015
MonotonicityNot monotonic
2023-12-11T01:39:01.896581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 420
 
4.2%
14000 368
 
3.7%
7000 260
 
2.6%
28000 95
 
0.9%
21000 71
 
0.7%
1904000 63
 
0.6%
1018000 57
 
0.6%
18000 49
 
0.5%
1503000 37
 
0.4%
310000 35
 
0.4%
Other values (6894) 8545
85.5%
ValueCountFrequency (%)
0 420
4.2%
80 4
 
< 0.1%
100 1
 
< 0.1%
140 3
 
< 0.1%
150 3
 
< 0.1%
200 1
 
< 0.1%
280 2
 
< 0.1%
290 1
 
< 0.1%
390 1
 
< 0.1%
440 5
 
0.1%
ValueCountFrequency (%)
1352885150 1
< 0.1%
1113495720 1
< 0.1%
1043116160 1
< 0.1%
1011394520 1
< 0.1%
993310910 1
< 0.1%
972481880 1
< 0.1%
951587600 1
< 0.1%
928852150 1
< 0.1%
894391010 1
< 0.1%
848776260 1
< 0.1%

당월이중수납건수
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9905 
1
 
87
2
 
8

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 9905
99.1%
1 87
 
0.9%
2 8
 
0.1%

Length

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

Common Values (Plot)

2023-12-11T01:39:02.219448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9905
99.1%
1 87
 
0.9%
2 8
 
0.1%

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

SKEWED  ZEROS 

Distinct84
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean755.923
Minimum0
Maximum2863040
Zeros9905
Zeros (%)99.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:02.342186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum2863040
Range2863040
Interquartile range (IQR)0

Descriptive statistics

Standard deviation31405.33
Coefficient of variation (CV)41.545673
Kurtosis7039.767
Mean755.923
Median Absolute Deviation (MAD)0
Skewness80.097709
Sum7559230
Variance9.8629472 × 108
MonotonicityNot monotonic
2023-12-11T01:39:02.514596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9905
99.1%
2380 5
 
0.1%
1800 2
 
< 0.1%
4520 2
 
< 0.1%
89100 2
 
< 0.1%
62880 2
 
< 0.1%
50900 2
 
< 0.1%
4020 2
 
< 0.1%
14500 2
 
< 0.1%
13920 2
 
< 0.1%
Other values (74) 74
 
0.7%
ValueCountFrequency (%)
0 9905
99.1%
440 1
 
< 0.1%
1200 1
 
< 0.1%
1280 1
 
< 0.1%
1500 1
 
< 0.1%
1800 2
 
< 0.1%
2230 1
 
< 0.1%
2340 1
 
< 0.1%
2380 5
 
0.1%
2400 1
 
< 0.1%
ValueCountFrequency (%)
2863040 1
< 0.1%
1068330 1
< 0.1%
397480 1
< 0.1%
337840 1
< 0.1%
211860 1
< 0.1%
201320 1
< 0.1%
174320 1
< 0.1%
173110 1
< 0.1%
112180 1
< 0.1%
98040 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:02.721068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

불납결손금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct35
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean985.856
Minimum0
Maximum3338080
Zeros9961
Zeros (%)99.6%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:03.016189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum3338080
Range3338080
Interquartile range (IQR)0

Descriptive statistics

Standard deviation37658.81
Coefficient of variation (CV)38.199098
Kurtosis6241.6168
Mean985.856
Median Absolute Deviation (MAD)0
Skewness73.217951
Sum9858560
Variance1.4181859 × 109
MonotonicityNot monotonic
2023-12-11T01:39:03.209493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
0 9961
99.6%
332350 3
 
< 0.1%
7480 2
 
< 0.1%
135340 2
 
< 0.1%
42810 2
 
< 0.1%
67270 1
 
< 0.1%
32110 1
 
< 0.1%
224210 1
 
< 0.1%
39370 1
 
< 0.1%
61740 1
 
< 0.1%
Other values (25) 25
 
0.2%
ValueCountFrequency (%)
0 9961
99.6%
1220 1
 
< 0.1%
2470 1
 
< 0.1%
2670 1
 
< 0.1%
3700 1
 
< 0.1%
3910 1
 
< 0.1%
7410 1
 
< 0.1%
7480 2
 
< 0.1%
10600 1
 
< 0.1%
11980 1
 
< 0.1%
ValueCountFrequency (%)
3338080 1
 
< 0.1%
1022120 1
 
< 0.1%
599780 1
 
< 0.1%
521460 1
 
< 0.1%
505960 1
 
< 0.1%
449100 1
 
< 0.1%
388630 1
 
< 0.1%
370940 1
 
< 0.1%
332350 3
< 0.1%
331690 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:03.455028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:39:03.620616image/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%
Mean65.892
Minimum0
Maximum321780
Zeros9993
Zeros (%)99.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:03.736784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum321780
Range321780
Interquartile range (IQR)0

Descriptive statistics

Standard deviation3632.0819
Coefficient of variation (CV)55.121744
Kurtosis6304.1001
Mean65.892
Median Absolute Deviation (MAD)0
Skewness75.066285
Sum658920
Variance13192019
MonotonicityNot monotonic
2023-12-11T01:39:03.888346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
0 9993
99.9%
12420 2
 
< 0.1%
94630 1
 
< 0.1%
321780 1
 
< 0.1%
26500 1
 
< 0.1%
86380 1
 
< 0.1%
104790 1
 
< 0.1%
ValueCountFrequency (%)
0 9993
99.9%
12420 2
 
< 0.1%
26500 1
 
< 0.1%
86380 1
 
< 0.1%
94630 1
 
< 0.1%
104790 1
 
< 0.1%
321780 1
 
< 0.1%
ValueCountFrequency (%)
321780 1
 
< 0.1%
104790 1
 
< 0.1%
94630 1
 
< 0.1%
86380 1
 
< 0.1%
26500 1
 
< 0.1%
12420 2
 
< 0.1%
0 9993
99.9%

반환건수
Real number (ℝ)

ZEROS 

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.027
Minimum0
Maximum6
Zeros9828
Zeros (%)98.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:04.079836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum6
Range6
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.23510961
Coefficient of variation (CV)8.7077632
Kurtosis162.49546
Mean0.027
Median Absolute Deviation (MAD)0
Skewness11.430243
Sum270
Variance0.055276528
MonotonicityNot monotonic
2023-12-11T01:39:04.224185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
0 9828
98.3%
1 108
 
1.1%
2 39
 
0.4%
3 19
 
0.2%
4 4
 
< 0.1%
5 1
 
< 0.1%
6 1
 
< 0.1%
ValueCountFrequency (%)
0 9828
98.3%
1 108
 
1.1%
2 39
 
0.4%
3 19
 
0.2%
4 4
 
< 0.1%
5 1
 
< 0.1%
6 1
 
< 0.1%
ValueCountFrequency (%)
6 1
 
< 0.1%
5 1
 
< 0.1%
4 4
 
< 0.1%
3 19
 
0.2%
2 39
 
0.4%
1 108
 
1.1%
0 9828
98.3%

반환금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct144
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14153.511
Minimum0
Maximum63979000
Zeros9828
Zeros (%)98.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:04.395521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum63979000
Range63979000
Interquartile range (IQR)0

Descriptive statistics

Standard deviation667932.97
Coefficient of variation (CV)47.192034
Kurtosis8434.3817
Mean14153.511
Median Absolute Deviation (MAD)0
Skewness88.992287
Sum1.4153511 × 108
Variance4.4613445 × 1011
MonotonicityNot monotonic
2023-12-11T01:39:04.599213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9828
98.3%
8000 5
 
0.1%
18000 5
 
0.1%
150 4
 
< 0.1%
392050 3
 
< 0.1%
174720 3
 
< 0.1%
1330 3
 
< 0.1%
1907110 2
 
< 0.1%
11460 2
 
< 0.1%
14000 2
 
< 0.1%
Other values (134) 143
 
1.4%
ValueCountFrequency (%)
0 9828
98.3%
150 4
 
< 0.1%
880 1
 
< 0.1%
1200 1
 
< 0.1%
1330 3
 
< 0.1%
1480 1
 
< 0.1%
1780 1
 
< 0.1%
1800 1
 
< 0.1%
2050 1
 
< 0.1%
2690 1
 
< 0.1%
ValueCountFrequency (%)
63979000 1
< 0.1%
14041800 1
< 0.1%
4829440 2
< 0.1%
4250540 2
< 0.1%
3769710 1
< 0.1%
3769360 1
< 0.1%
3768000 1
< 0.1%
3067420 1
< 0.1%
2863040 1
< 0.1%
2741760 1
< 0.1%

체납이중수납건수
Categorical

IMBALANCE 

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

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 9982
99.8%
1 18
 
0.2%

Length

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

Common Values (Plot)

2023-12-11T01:39:04.892179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9982
99.8%
1 18
 
0.2%

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

SKEWED  ZEROS 

Distinct17
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean67.535
Minimum0
Maximum106290
Zeros9982
Zeros (%)99.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:05.000241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum106290
Range106290
Interquartile range (IQR)0

Descriptive statistics

Standard deviation2142.0396
Coefficient of variation (CV)31.717474
Kurtosis1434.0824
Mean67.535
Median Absolute Deviation (MAD)0
Skewness36.734566
Sum675350
Variance4588333.6
MonotonicityNot monotonic
2023-12-11T01:39:05.134348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
0 9982
99.8%
80340 2
 
< 0.1%
3700 2
 
< 0.1%
18700 1
 
< 0.1%
106290 1
 
< 0.1%
12890 1
 
< 0.1%
14820 1
 
< 0.1%
68000 1
 
< 0.1%
11120 1
 
< 0.1%
11650 1
 
< 0.1%
Other values (7) 7
 
0.1%
ValueCountFrequency (%)
0 9982
99.8%
1380 1
 
< 0.1%
3660 1
 
< 0.1%
3700 2
 
< 0.1%
9660 1
 
< 0.1%
11120 1
 
< 0.1%
11650 1
 
< 0.1%
12890 1
 
< 0.1%
14820 1
 
< 0.1%
18700 1
 
< 0.1%
ValueCountFrequency (%)
106290 1
< 0.1%
80340 2
< 0.1%
74710 1
< 0.1%
70820 1
< 0.1%
68000 1
< 0.1%
52900 1
< 0.1%
50670 1
< 0.1%
18700 1
< 0.1%
14820 1
< 0.1%
12890 1
< 0.1%

과오건수
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9972 
1
 
26
2
 
1
4
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique2 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
0 9972
99.7%
1 26
 
0.3%
2 1
 
< 0.1%
4 1
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-11T01:39:05.351055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9972
99.7%
1 26
 
0.3%
2 1
 
< 0.1%
4 1
 
< 0.1%

과오금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct27
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean152.056
Minimum0
Maximum323740
Zeros9972
Zeros (%)99.7%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:05.473844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum323740
Range323740
Interquartile range (IQR)0

Descriptive statistics

Standard deviation5128.2849
Coefficient of variation (CV)33.726291
Kurtosis2406.1224
Mean152.056
Median Absolute Deviation (MAD)0
Skewness46.448161
Sum1520560
Variance26299306
MonotonicityNot monotonic
2023-12-11T01:39:05.650702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
0 9972
99.7%
16930 2
 
< 0.1%
2470 2
 
< 0.1%
19060 1
 
< 0.1%
220020 1
 
< 0.1%
33400 1
 
< 0.1%
209240 1
 
< 0.1%
4450 1
 
< 0.1%
21840 1
 
< 0.1%
26400 1
 
< 0.1%
Other values (17) 17
 
0.2%
ValueCountFrequency (%)
0 9972
99.7%
330 1
 
< 0.1%
1240 1
 
< 0.1%
2470 2
 
< 0.1%
4450 1
 
< 0.1%
4740 1
 
< 0.1%
6060 1
 
< 0.1%
8830 1
 
< 0.1%
8910 1
 
< 0.1%
16930 2
 
< 0.1%
ValueCountFrequency (%)
323740 1
< 0.1%
220020 1
< 0.1%
209240 1
< 0.1%
186300 1
< 0.1%
110020 1
< 0.1%
93050 1
< 0.1%
60600 1
< 0.1%
33480 1
< 0.1%
33400 1
< 0.1%
26400 1
< 0.1%

충당건수
Categorical

IMBALANCE 

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

Length

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

Common Values (Plot)

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

충당금액
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9998 
12100
 
1
50640
 
1

Length

Max length5
Median length1
Mean length1.0008
Min length1

Unique

Unique2 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
0 9998
> 99.9%
12100 1
 
< 0.1%
50640 1
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-11T01:39:06.263881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9998
> 99.9%
12100 1
 
< 0.1%
50640 1
 
< 0.1%

Sample

연번사업소코드사업소명구코드구명결의일자예산과목결의서구분징수건수징수금액수납건수수납금액당월이중수납건수당월이중수납금액불납결손건수불납결손금액결손취소건수결손취소금액반환건수반환금액체납이중수납건수체납이중수납금액과오건수과오금액충당건수충당금액
5171051711303영도 사업소200영도구2022-02-24물이용부담금물이용0897011845000000000000000
5096250963303영도 사업소200영도구2022-01-24수용가미수금이월액상수도0069183396000000000000000
2293722938244동래통합사업소470연제구2022-02-08사회복지사용료상수도47437034100019000000000000000
3910139102301중동부 사업소170동구2022-06-08하수도요금하수도322460934461000000000000000
50315032244동래통합사업소260동래구2022-04-14자재비(구경확대)상수도315030003150300000000000000000
5350253503303영도 사업소200영도구2022-05-17물이용부담금물이용0-2818085280000000000000000
2772927730244동래통합사업소470연제구2022-08-09수용가미수금이월액상수도001411245000000000000000
1842818429244동래통합사업소410금정구2022-08-16공사방수료(개조)상수도59637719576702792572000000000000000
4664546646302서부 사업소140서구2022-06-27공사방수량(신설)상수도11628001161320777000000000000000
7824978250306남부 사업소290남구2022-11-30물이용부담금물이용0-34906662097000000000000000
연번사업소코드사업소명구코드구명결의일자예산과목결의서구분징수건수징수금액수납건수수납금액당월이중수납건수당월이중수납금액불납결손건수불납결손금액결손취소건수결손취소금액반환건수반환금액체납이중수납건수체납이중수납금액과오건수과오금액충당건수충당금액
1767017671244동래통합사업소410금정구2022-07-16일반용사용료추징상수도00513748000000000000000
4654246543302서부 사업소140서구2022-06-21하수도요금하수도001695000000000000000
5630856309303영도 사업소200영도구2022-10-09수용가미수금이월액상수도001396000000000000000
5342353424303영도 사업소200영도구2022-05-15사회복지사용료상수도00611534000000000000000
7320773208306남부 사업소290남구2022-05-06공동수도 사용료상수도4716802461162000000000000000
57025703244동래통합사업소260동래구2022-05-06시공비(세대별분리공사)상수도319040003190400000000000000000
1538615387244동래통합사업소410금정구2022-04-22물이용부담금물이용0053331000000000000000
4342343424302서부 사업소140서구2022-01-31하수도요금하수도0056566000000000000000
1472814729244동래통합사업소410금정구2022-03-30물이용부담금물이용00145000000000000000
1006010061244동래통합사업소260동래구2022-10-21설계료(비정액제)상수도2392000239200000000000000000