Overview

Dataset statistics

Number of variables24
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.1 MiB
Average record size in memory222.0 B

Variable types

Numeric16
DateTime1
Text1
Categorical6

Dataset

Description부산광역시상수도사업본부_수용가정보시스템_세입집계정보_세입일집계_20210601
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.8%)Imbalance
체납이중수납건수 is highly imbalanced (98.8%)Imbalance
과오건수 is highly imbalanced (97.4%)Imbalance
당월이중수납건수 is highly skewed (γ1 = 21.36673317)Skewed
당월이중수납금액 is highly skewed (γ1 = 28.78111611)Skewed
불납결손금액 is highly skewed (γ1 = 53.10651005)Skewed
반환건수 is highly skewed (γ1 = 34.32888856)Skewed
반환금액 is highly skewed (γ1 = 80.12215185)Skewed
체납이중수납금액 is highly skewed (γ1 = 85.38208511)Skewed
과오금액 is highly skewed (γ1 = 68.57007616)Skewed
충당건수 is highly skewed (γ1 = 51.45593469)Skewed
충당금액 is highly skewed (γ1 = 71.06007298)Skewed
연번 has unique valuesUnique
징수건수 has 6393 (63.9%) zerosZeros
징수금액 has 5609 (56.1%) zerosZeros
수납건수 has 416 (4.2%) zerosZeros
수납금액 has 403 (4.0%) zerosZeros
당월이중수납건수 has 9851 (98.5%) zerosZeros
당월이중수납금액 has 9851 (98.5%) zerosZeros
불납결손금액 has 9990 (99.9%) zerosZeros
반환건수 has 9778 (97.8%) zerosZeros
반환금액 has 9778 (97.8%) zerosZeros
체납이중수납금액 has 9983 (99.8%) zerosZeros
과오금액 has 9958 (99.6%) zerosZeros
충당건수 has 9986 (99.9%) zerosZeros
충당금액 has 9986 (99.9%) zerosZeros

Reproduction

Analysis started2023-12-10 16:39:19.889501
Analysis finished2023-12-10 16:39:20.324826
Duration0.44 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%
Mean16628.492
Minimum3
Maximum33607
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:20.428192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile1690.95
Q18244
median16558.5
Q324936.25
95-th percentile31934.1
Maximum33607
Range33604
Interquartile range (IQR)16692.25

Descriptive statistics

Standard deviation9690.9954
Coefficient of variation (CV)0.58279459
Kurtosis-1.1944504
Mean16628.492
Median Absolute Deviation (MAD)8337.5
Skewness0.033066141
Sum1.6628492 × 108
Variance93915392
MonotonicityNot monotonic
2023-12-11T01:39:20.655554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
23288 1
 
< 0.1%
27367 1
 
< 0.1%
20916 1
 
< 0.1%
4079 1
 
< 0.1%
15845 1
 
< 0.1%
31584 1
 
< 0.1%
23045 1
 
< 0.1%
18477 1
 
< 0.1%
28360 1
 
< 0.1%
4281 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
3 1
< 0.1%
4 1
< 0.1%
16 1
< 0.1%
17 1
< 0.1%
25 1
< 0.1%
26 1
< 0.1%
27 1
< 0.1%
28 1
< 0.1%
33 1
< 0.1%
35 1
< 0.1%
ValueCountFrequency (%)
33607 1
< 0.1%
33604 1
< 0.1%
33603 1
< 0.1%
33602 1
< 0.1%
33600 1
< 0.1%
33597 1
< 0.1%
33593 1
< 0.1%
33580 1
< 0.1%
33578 1
< 0.1%
33572 1
< 0.1%

사업소코드
Real number (ℝ)

Distinct17
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean292.6835
Minimum101
Maximum312
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:20.837080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation28.903018
Coefficient of variation (CV)0.098751786
Kurtosis8.2324579
Mean292.6835
Median Absolute Deviation (MAD)3
Skewness-2.3882761
Sum2926835
Variance835.38447
MonotonicityNot monotonic
2023-12-11T01:39:20.969349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
244 1888
18.9%
307 1270
12.7%
306 1184
11.8%
301 1085
10.8%
309 742
 
7.4%
311 693
 
6.9%
304 676
 
6.8%
308 651
 
6.5%
312 614
 
6.1%
303 549
 
5.5%
Other values (7) 648
 
6.5%
ValueCountFrequency (%)
101 46
 
0.5%
201 38
 
0.4%
202 19
 
0.2%
203 6
 
0.1%
204 7
 
0.1%
205 8
 
0.1%
244 1888
18.9%
301 1085
10.8%
302 524
 
5.2%
303 549
 
5.5%
ValueCountFrequency (%)
312 614
6.1%
311 693
6.9%
309 742
7.4%
308 651
6.5%
307 1270
12.7%
306 1184
11.8%
304 676
6.8%
303 549
5.5%
302 524
5.2%
301 1085
10.8%

구코드
Real number (ℝ)

Distinct22
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean348.4902
Minimum0
Maximum710
Zeros46
Zeros (%)0.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:21.126203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile110
Q1230
median350
Q3440
95-th percentile710
Maximum710
Range710
Interquartile range (IQR)210

Descriptive statistics

Standard deviation154.9264
Coefficient of variation (CV)0.44456458
Kurtosis-0.21005229
Mean348.4902
Median Absolute Deviation (MAD)120
Skewness0.44035676
Sum3484902
Variance24002.189
MonotonicityNot monotonic
2023-12-11T01:39:21.320849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
380 742
 
7.4%
440 693
 
6.9%
530 682
 
6.8%
230 676
 
6.8%
260 663
 
6.6%
350 651
 
6.5%
410 623
 
6.2%
710 614
 
6.1%
290 607
 
6.1%
470 602
 
6.0%
Other values (12) 3447
34.5%
ValueCountFrequency (%)
0 46
 
0.5%
110 492
4.9%
140 524
5.2%
170 593
5.9%
200 549
5.5%
201 38
 
0.4%
202 19
 
0.2%
203 6
 
0.1%
204 7
 
0.1%
205 8
 
0.1%
ValueCountFrequency (%)
710 614
6.1%
530 682
6.8%
500 577
5.8%
470 602
6.0%
440 693
6.9%
410 623
6.2%
380 742
7.4%
350 651
6.5%
320 588
5.9%
290 607
6.1%

결의일자
Date

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

예산과목
Text

Distinct53
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T01:39:22.042085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length4
Mean length4.3306
Min length4

Characters and Unicode

Total characters43306
Distinct characters12
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique5 ?
Unique (%)< 0.1%

Sample

1st row6991
2nd rowH993
3rd rowH993
4th row6996
5th row6992
ValueCountFrequency (%)
6983 703
 
7.0%
11111 685
 
6.9%
6991 684
 
6.8%
11117 660
 
6.6%
6981 649
 
6.5%
31100 635
 
6.3%
6993 625
 
6.2%
m981 571
 
5.7%
h991 563
 
5.6%
m983 560
 
5.6%
Other values (43) 3665
36.6%
2023-12-11T01:39:22.485363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 13642
31.5%
9 10358
23.9%
6 5365
 
12.4%
3 3652
 
8.4%
8 3146
 
7.3%
0 1664
 
3.8%
7 1400
 
3.2%
H 1320
 
3.0%
M 1204
 
2.8%
2 872
 
2.0%
Other values (2) 683
 
1.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 40782
94.2%
Uppercase Letter 2524
 
5.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 13642
33.5%
9 10358
25.4%
6 5365
 
13.2%
3 3652
 
9.0%
8 3146
 
7.7%
0 1664
 
4.1%
7 1400
 
3.4%
2 872
 
2.1%
4 470
 
1.2%
5 213
 
0.5%
Uppercase Letter
ValueCountFrequency (%)
H 1320
52.3%
M 1204
47.7%

Most occurring scripts

ValueCountFrequency (%)
Common 40782
94.2%
Latin 2524
 
5.8%

Most frequent character per script

Common
ValueCountFrequency (%)
1 13642
33.5%
9 10358
25.4%
6 5365
 
13.2%
3 3652
 
9.0%
8 3146
 
7.7%
0 1664
 
4.1%
7 1400
 
3.4%
2 872
 
2.1%
4 470
 
1.2%
5 213
 
0.5%
Latin
ValueCountFrequency (%)
H 1320
52.3%
M 1204
47.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 43306
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 13642
31.5%
9 10358
23.9%
6 5365
 
12.4%
3 3652
 
8.4%
8 3146
 
7.3%
0 1664
 
3.8%
7 1400
 
3.2%
H 1320
 
3.0%
M 1204
 
2.8%
2 872
 
2.0%
Other values (2) 683
 
1.6%

결의서구분
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2
3632 
1
3306 
3
3062 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2 3632
36.3%
1 3306
33.1%
3 3062
30.6%

Length

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

Common Values (Plot)

2023-12-11T01:39:22.790200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 3632
36.3%
1 3306
33.1%
3 3062
30.6%

징수건수
Real number (ℝ)

ZEROS 

Distinct282
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean88.8125
Minimum-13
Maximum11550
Zeros6393
Zeros (%)63.9%
Negative3
Negative (%)< 0.1%
Memory size166.0 KiB
2023-12-11T01:39:22.930325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-13
5-th percentile0
Q10
median0
Q32
95-th percentile8
Maximum11550
Range11563
Interquartile range (IQR)2

Descriptive statistics

Standard deviation718.71801
Coefficient of variation (CV)8.0925321
Kurtosis101.44668
Mean88.8125
Median Absolute Deviation (MAD)0
Skewness9.6075596
Sum888125
Variance516555.57
MonotonicityNot monotonic
2023-12-11T01:39:23.113793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 6393
63.9%
1 905
 
9.0%
2 817
 
8.2%
3 530
 
5.3%
4 339
 
3.4%
5 203
 
2.0%
6 178
 
1.8%
8 74
 
0.7%
7 73
 
0.7%
9 51
 
0.5%
Other values (272) 437
 
4.4%
ValueCountFrequency (%)
-13 1
 
< 0.1%
-10 1
 
< 0.1%
-8 1
 
< 0.1%
0 6393
63.9%
1 905
 
9.0%
2 817
 
8.2%
3 530
 
5.3%
4 339
 
3.4%
5 203
 
2.0%
6 178
 
1.8%
ValueCountFrequency (%)
11550 1
< 0.1%
11497 1
< 0.1%
11447 1
< 0.1%
11435 1
< 0.1%
10013 1
< 0.1%
9424 1
< 0.1%
9250 1
< 0.1%
9055 1
< 0.1%
9041 1
< 0.1%
9024 1
< 0.1%

징수금액
Real number (ℝ)

ZEROS 

Distinct3608
Distinct (%)36.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7737576.2
Minimum-76492800
Maximum1.2044937 × 109
Zeros5609
Zeros (%)56.1%
Negative1423
Negative (%)14.2%
Memory size166.0 KiB
2023-12-11T01:39:23.288248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-76492800
5-th percentile-188957
Q10
median0
Q36280
95-th percentile3131050
Maximum1.2044937 × 109
Range1.2809865 × 109
Interquartile range (IQR)6280

Descriptive statistics

Standard deviation66876191
Coefficient of variation (CV)8.6430414
Kurtosis158.77383
Mean7737576.2
Median Absolute Deviation (MAD)0
Skewness11.894267
Sum7.7375762 × 1010
Variance4.472425 × 1015
MonotonicityNot monotonic
2023-12-11T01:39:23.462344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 5609
56.1%
14000 87
 
0.9%
848000 45
 
0.4%
310000 40
 
0.4%
28000 30
 
0.3%
150 29
 
0.3%
1330 20
 
0.2%
7000 16
 
0.2%
42000 15
 
0.1%
1269000 13
 
0.1%
Other values (3598) 4096
41.0%
ValueCountFrequency (%)
-76492800 1
< 0.1%
-59976060 1
< 0.1%
-17587900 1
< 0.1%
-15264270 1
< 0.1%
-10571110 1
< 0.1%
-10022770 1
< 0.1%
-8304190 1
< 0.1%
-8169960 1
< 0.1%
-7471040 1
< 0.1%
-7338280 1
< 0.1%
ValueCountFrequency (%)
1204493730 1
< 0.1%
1132681400 1
< 0.1%
1122229060 1
< 0.1%
1111097240 1
< 0.1%
1102524020 1
< 0.1%
1097928210 1
< 0.1%
1080848040 1
< 0.1%
1079505300 1
< 0.1%
1075458020 1
< 0.1%
1060248620 1
< 0.1%

수납건수
Real number (ℝ)

ZEROS 

Distinct553
Distinct (%)5.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean79.1447
Minimum0
Maximum7930
Zeros416
Zeros (%)4.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:23.645035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q12
median8
Q329
95-th percentile226
Maximum7930
Range7930
Interquartile range (IQR)27

Descriptive statistics

Standard deviation426.99053
Coefficient of variation (CV)5.3950616
Kurtosis121.35884
Mean79.1447
Median Absolute Deviation (MAD)7
Skewness10.387822
Sum791447
Variance182320.91
MonotonicityNot monotonic
2023-12-11T01:39:23.803673image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1463
 
14.6%
2 1019
 
10.2%
3 639
 
6.4%
4 511
 
5.1%
0 416
 
4.2%
5 357
 
3.6%
6 317
 
3.2%
7 248
 
2.5%
8 236
 
2.4%
9 188
 
1.9%
Other values (543) 4606
46.1%
ValueCountFrequency (%)
0 416
 
4.2%
1 1463
14.6%
2 1019
10.2%
3 639
6.4%
4 511
 
5.1%
5 357
 
3.6%
6 317
 
3.2%
7 248
 
2.5%
8 236
 
2.4%
9 188
 
1.9%
ValueCountFrequency (%)
7930 1
< 0.1%
7199 1
< 0.1%
7003 1
< 0.1%
6970 1
< 0.1%
6235 1
< 0.1%
6190 1
< 0.1%
6089 1
< 0.1%
5908 1
< 0.1%
5830 1
< 0.1%
5812 1
< 0.1%

수납금액
Real number (ℝ)

ZEROS 

Distinct8484
Distinct (%)84.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7778246.2
Minimum0
Maximum1.3813309 × 109
Zeros403
Zeros (%)4.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:23.992294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1040
Q151682.5
median306855
Q31440642.5
95-th percentile16005235
Maximum1.3813309 × 109
Range1.3813309 × 109
Interquartile range (IQR)1388960

Descriptive statistics

Standard deviation56127473
Coefficient of variation (CV)7.2159548
Kurtosis190.83519
Mean7778246.2
Median Absolute Deviation (MAD)295990
Skewness12.822224
Sum7.7782462 × 1010
Variance3.1502932 × 1015
MonotonicityNot monotonic
2023-12-11T01:39:24.202977image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 403
 
4.0%
14000 84
 
0.8%
848000 45
 
0.4%
310000 40
 
0.4%
7000 39
 
0.4%
28000 30
 
0.3%
42000 20
 
0.2%
140 14
 
0.1%
21000 14
 
0.1%
1269000 13
 
0.1%
Other values (8474) 9298
93.0%
ValueCountFrequency (%)
0 403
4.0%
10 1
 
< 0.1%
20 1
 
< 0.1%
60 1
 
< 0.1%
110 1
 
< 0.1%
140 14
 
0.1%
150 4
 
< 0.1%
170 1
 
< 0.1%
200 1
 
< 0.1%
240 1
 
< 0.1%
ValueCountFrequency (%)
1381330940 1
< 0.1%
1051110890 1
< 0.1%
1035539880 1
< 0.1%
1020736840 1
< 0.1%
993819870 1
< 0.1%
966753250 1
< 0.1%
965205000 1
< 0.1%
955971170 1
< 0.1%
911178680 1
< 0.1%
908041290 1
< 0.1%

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

SKEWED  ZEROS 

Distinct9
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.0242
Minimum0
Maximum11
Zeros9851
Zeros (%)98.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:24.388898image/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.27968229
Coefficient of variation (CV)11.557119
Kurtosis593.56996
Mean0.0242
Median Absolute Deviation (MAD)0
Skewness21.366733
Sum242
Variance0.078222182
MonotonicityNot monotonic
2023-12-11T01:39:24.511641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
0 9851
98.5%
1 117
 
1.2%
2 12
 
0.1%
3 9
 
0.1%
7 3
 
< 0.1%
8 3
 
< 0.1%
4 2
 
< 0.1%
5 2
 
< 0.1%
11 1
 
< 0.1%
ValueCountFrequency (%)
0 9851
98.5%
1 117
 
1.2%
2 12
 
0.1%
3 9
 
0.1%
4 2
 
< 0.1%
5 2
 
< 0.1%
7 3
 
< 0.1%
8 3
 
< 0.1%
11 1
 
< 0.1%
ValueCountFrequency (%)
11 1
 
< 0.1%
8 3
 
< 0.1%
7 3
 
< 0.1%
5 2
 
< 0.1%
4 2
 
< 0.1%
3 9
 
0.1%
2 12
 
0.1%
1 117
 
1.2%
0 9851
98.5%

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

SKEWED  ZEROS 

Distinct139
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1247.991
Minimum0
Maximum1009720
Zeros9851
Zeros (%)98.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:24.652007image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum1009720
Range1009720
Interquartile range (IQR)0

Descriptive statistics

Standard deviation22385.888
Coefficient of variation (CV)17.93754
Kurtosis983.33778
Mean1247.991
Median Absolute Deviation (MAD)0
Skewness28.781116
Sum12479910
Variance5.0112799 × 108
MonotonicityNot monotonic
2023-12-11T01:39:24.860296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9851
98.5%
2380 5
 
0.1%
12360 2
 
< 0.1%
23080 2
 
< 0.1%
440 2
 
< 0.1%
10740 2
 
< 0.1%
5940 2
 
< 0.1%
2360 2
 
< 0.1%
13080 2
 
< 0.1%
281560 1
 
< 0.1%
Other values (129) 129
 
1.3%
ValueCountFrequency (%)
0 9851
98.5%
140 1
 
< 0.1%
440 2
 
< 0.1%
740 1
 
< 0.1%
900 1
 
< 0.1%
1180 1
 
< 0.1%
1340 1
 
< 0.1%
1350 1
 
< 0.1%
2080 1
 
< 0.1%
2180 1
 
< 0.1%
ValueCountFrequency (%)
1009720 1
< 0.1%
836000 1
< 0.1%
767400 1
< 0.1%
717600 1
< 0.1%
585300 1
< 0.1%
526500 1
< 0.1%
424100 1
< 0.1%
419320 1
< 0.1%
388820 1
< 0.1%
366780 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:25.032796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

불납결손금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct11
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean39.143
Minimum0
Maximum114220
Zeros9990
Zeros (%)99.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:25.250495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum114220
Range114220
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1727.0493
Coefficient of variation (CV)44.121538
Kurtosis3070.2465
Mean39.143
Median Absolute Deviation (MAD)0
Skewness53.10651
Sum391430
Variance2982699.4
MonotonicityNot monotonic
2023-12-11T01:39:25.411956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
0 9990
99.9%
41320 1
 
< 0.1%
95640 1
 
< 0.1%
740 1
 
< 0.1%
114220 1
 
< 0.1%
4530 1
 
< 0.1%
35940 1
 
< 0.1%
11130 1
 
< 0.1%
61960 1
 
< 0.1%
200 1
 
< 0.1%
ValueCountFrequency (%)
0 9990
99.9%
200 1
 
< 0.1%
740 1
 
< 0.1%
4530 1
 
< 0.1%
11130 1
 
< 0.1%
25750 1
 
< 0.1%
35940 1
 
< 0.1%
41320 1
 
< 0.1%
61960 1
 
< 0.1%
95640 1
 
< 0.1%
ValueCountFrequency (%)
114220 1
< 0.1%
95640 1
< 0.1%
61960 1
< 0.1%
41320 1
< 0.1%
35940 1
< 0.1%
25750 1
< 0.1%
11130 1
< 0.1%
4530 1
< 0.1%
740 1
< 0.1%
200 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:25.597560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

결손취소금액
Categorical

IMBALANCE 

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

Length

Max length5
Median length1
Mean length1.0007
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%
2470 1
 
< 0.1%
10240 1
 
< 0.1%

Length

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

Common Values (Plot)

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

반환건수
Real number (ℝ)

SKEWED  ZEROS 

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.0373
Minimum0
Maximum25
Zeros9778
Zeros (%)97.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:26.187135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum25
Range25
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.380425
Coefficient of variation (CV)10.199062
Kurtosis1956.6506
Mean0.0373
Median Absolute Deviation (MAD)0
Skewness34.328889
Sum373
Variance0.14472318
MonotonicityNot monotonic
2023-12-11T01:39:26.304849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
0 9778
97.8%
1 149
 
1.5%
2 44
 
0.4%
3 15
 
0.1%
5 7
 
0.1%
4 5
 
0.1%
11 1
 
< 0.1%
25 1
 
< 0.1%
ValueCountFrequency (%)
0 9778
97.8%
1 149
 
1.5%
2 44
 
0.4%
3 15
 
0.1%
4 5
 
0.1%
5 7
 
0.1%
11 1
 
< 0.1%
25 1
 
< 0.1%
ValueCountFrequency (%)
25 1
 
< 0.1%
11 1
 
< 0.1%
5 7
 
0.1%
4 5
 
0.1%
3 15
 
0.1%
2 44
 
0.4%
1 149
 
1.5%
0 9778
97.8%

반환금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct217
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7373.477
Minimum0
Maximum26454270
Zeros9778
Zeros (%)97.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:26.827128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum26454270
Range26454270
Interquartile range (IQR)0

Descriptive statistics

Standard deviation289097.63
Coefficient of variation (CV)39.207776
Kurtosis7099.673
Mean7373.477
Median Absolute Deviation (MAD)0
Skewness80.122152
Sum73734770
Variance8.357744 × 1010
MonotonicityNot monotonic
2023-12-11T01:39:27.029584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9778
97.8%
9480 2
 
< 0.1%
8540 2
 
< 0.1%
1780 2
 
< 0.1%
9000 2
 
< 0.1%
10030 2
 
< 0.1%
2360 2
 
< 0.1%
8770 1
 
< 0.1%
35300 1
 
< 0.1%
24420 1
 
< 0.1%
Other values (207) 207
 
2.1%
ValueCountFrequency (%)
0 9778
97.8%
150 1
 
< 0.1%
300 1
 
< 0.1%
740 1
 
< 0.1%
1060 1
 
< 0.1%
1180 1
 
< 0.1%
1200 1
 
< 0.1%
1330 1
 
< 0.1%
1590 1
 
< 0.1%
1780 2
 
< 0.1%
ValueCountFrequency (%)
26454270 1
< 0.1%
8770340 1
< 0.1%
4340000 1
< 0.1%
3907770 1
< 0.1%
2930100 1
< 0.1%
1650700 1
< 0.1%
1439000 1
< 0.1%
1240000 1
< 0.1%
1150700 1
< 0.1%
1057810 1
< 0.1%

체납이중수납건수
Categorical

IMBALANCE 

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

Length

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

Common Values (Plot)

2023-12-11T01:39:27.284250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9983
99.8%
1 15
 
0.1%
3 2
 
< 0.1%

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

SKEWED  ZEROS 

Distinct18
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean123.492
Minimum0
Maximum667310
Zeros9983
Zeros (%)99.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:27.382547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum667310
Range667310
Interquartile range (IQR)0

Descriptive statistics

Standard deviation7121.2209
Coefficient of variation (CV)57.665443
Kurtosis7799.5816
Mean123.492
Median Absolute Deviation (MAD)0
Skewness85.382085
Sum1234920
Variance50711787
MonotonicityNot monotonic
2023-12-11T01:39:27.532535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
0 9983
99.8%
219990 1
 
< 0.1%
61140 1
 
< 0.1%
8790 1
 
< 0.1%
29250 1
 
< 0.1%
30950 1
 
< 0.1%
31950 1
 
< 0.1%
21130 1
 
< 0.1%
14500 1
 
< 0.1%
450 1
 
< 0.1%
Other values (8) 8
 
0.1%
ValueCountFrequency (%)
0 9983
99.8%
450 1
 
< 0.1%
460 1
 
< 0.1%
790 1
 
< 0.1%
5250 1
 
< 0.1%
8790 1
 
< 0.1%
14500 1
 
< 0.1%
16560 1
 
< 0.1%
21130 1
 
< 0.1%
26210 1
 
< 0.1%
ValueCountFrequency (%)
667310 1
< 0.1%
219990 1
< 0.1%
61140 1
< 0.1%
60250 1
< 0.1%
39940 1
< 0.1%
31950 1
< 0.1%
30950 1
< 0.1%
29250 1
< 0.1%
26210 1
< 0.1%
21130 1
< 0.1%

과오건수
Categorical

IMBALANCE 

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

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 9958
99.6%
1 39
 
0.4%
2 3
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-11T01:39:27.760079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9958
99.6%
1 39
 
0.4%
2 3
 
< 0.1%

과오금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct43
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1521.866
Minimum-988270
Maximum7263580
Zeros9958
Zeros (%)99.6%
Negative3
Negative (%)< 0.1%
Memory size166.0 KiB
2023-12-11T01:39:27.886971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-988270
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum7263580
Range8251850
Interquartile range (IQR)0

Descriptive statistics

Standard deviation97497.514
Coefficient of variation (CV)64.064454
Kurtosis4842.413
Mean1521.866
Median Absolute Deviation (MAD)0
Skewness68.570076
Sum15218660
Variance9.5057652 × 109
MonotonicityNot monotonic
2023-12-11T01:39:28.022877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=43)
ValueCountFrequency (%)
0 9958
99.6%
78600 1
 
< 0.1%
-9740 1
 
< 0.1%
9700 1
 
< 0.1%
4020 1
 
< 0.1%
256320 1
 
< 0.1%
13880 1
 
< 0.1%
49440 1
 
< 0.1%
10340 1
 
< 0.1%
6570 1
 
< 0.1%
Other values (33) 33
 
0.3%
ValueCountFrequency (%)
-988270 1
 
< 0.1%
-10940 1
 
< 0.1%
-9740 1
 
< 0.1%
0 9958
99.6%
720 1
 
< 0.1%
1340 1
 
< 0.1%
1630 1
 
< 0.1%
2080 1
 
< 0.1%
2240 1
 
< 0.1%
2360 1
 
< 0.1%
ValueCountFrequency (%)
7263580 1
< 0.1%
6317840 1
< 0.1%
1075900 1
< 0.1%
297800 1
< 0.1%
256320 1
< 0.1%
233040 1
< 0.1%
166380 1
< 0.1%
78600 1
< 0.1%
72700 1
< 0.1%
54760 1
< 0.1%

충당건수
Real number (ℝ)

SKEWED  ZEROS 

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.0035
Minimum0
Maximum9
Zeros9986
Zeros (%)99.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:28.126595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum9
Range9
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.13072666
Coefficient of variation (CV)37.350474
Kurtosis2994.1009
Mean0.0035
Median Absolute Deviation (MAD)0
Skewness51.455935
Sum35
Variance0.017089459
MonotonicityNot monotonic
2023-12-11T01:39:28.247504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
0 9986
99.9%
1 9
 
0.1%
9 1
 
< 0.1%
5 1
 
< 0.1%
2 1
 
< 0.1%
4 1
 
< 0.1%
6 1
 
< 0.1%
ValueCountFrequency (%)
0 9986
99.9%
1 9
 
0.1%
2 1
 
< 0.1%
4 1
 
< 0.1%
5 1
 
< 0.1%
6 1
 
< 0.1%
9 1
 
< 0.1%
ValueCountFrequency (%)
9 1
 
< 0.1%
6 1
 
< 0.1%
5 1
 
< 0.1%
4 1
 
< 0.1%
2 1
 
< 0.1%
1 9
 
0.1%
0 9986
99.9%

충당금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct15
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean80.375
Minimum0
Maximum313170
Zeros9986
Zeros (%)99.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T01:39:28.396391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum313170
Range313170
Interquartile range (IQR)0

Descriptive statistics

Standard deviation3593.4556
Coefficient of variation (CV)44.708624
Kurtosis5869.6083
Mean80.375
Median Absolute Deviation (MAD)0
Skewness71.060073
Sum803750
Variance12912923
MonotonicityNot monotonic
2023-12-11T01:39:28.561101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
0 9986
99.9%
22230 1
 
< 0.1%
80440 1
 
< 0.1%
92700 1
 
< 0.1%
64270 1
 
< 0.1%
63770 1
 
< 0.1%
70820 1
 
< 0.1%
7870 1
 
< 0.1%
37580 1
 
< 0.1%
3950 1
 
< 0.1%
Other values (5) 5
 
0.1%
ValueCountFrequency (%)
0 9986
99.9%
2400 1
 
< 0.1%
3950 1
 
< 0.1%
7750 1
 
< 0.1%
7870 1
 
< 0.1%
11260 1
 
< 0.1%
22230 1
 
< 0.1%
25540 1
 
< 0.1%
37580 1
 
< 0.1%
63770 1
 
< 0.1%
ValueCountFrequency (%)
313170 1
< 0.1%
92700 1
< 0.1%
80440 1
< 0.1%
70820 1
< 0.1%
64270 1
< 0.1%
63770 1
< 0.1%
37580 1
< 0.1%
25540 1
< 0.1%
22230 1
< 0.1%
11260 1
< 0.1%

Sample

연번사업소코드구코드결의일자예산과목결의서구분징수건수징수금액수납건수수납금액당월이중수납건수당월이중수납금액불납결손건수불납결손금액결손취소건수결손취소금액반환건수반환금액체납이중수납건수체납이중수납금액과오건수과오금액충당건수충당금액
23287232883093802021-01-09699120011306000000000000000
114011412442602021-02-19H99320025433923000000000000000
256425653042302021-03-10H993200830720000000000000000
15550155513021402021-01-14699624551678900000000000000000
15880158813011102021-01-256992200320709000000000000000
506750682444702021-03-08699620013085000000000000000
26563265643114402021-01-236997200370992000000000000000
23436234373011102021-01-29M9833001721870000000000000000
11473114743073202021-02-1511111141091079505300940676000000000000000
961196123083502021-02-23699220011145963000000000000000
연번사업소코드구코드결의일자예산과목결의서구분징수건수징수금액수납건수수납금액당월이중수납건수당월이중수납금액불납결손건수불납결손금액결손취소건수결손취소금액반환건수반환금액체납이중수납건수체납이중수납금액과오건수과오금액충당건수충당금액
21152211533042302021-05-086983300514257000000000000000
29754297553032002021-04-12H99120021758000000000000000
521952203032002021-03-12M983300312424000000000000000
25222252233114402021-05-18111111001548573000000000000000
972897293075302021-02-226981355310218161960000000000000000
23445234463032002021-01-296983300204302545000000000000000
32214322152442602021-04-181111710028070000000000000000
21941219423042302021-05-17699124-29989107311029700000002275400011150000
19489194903011102021-05-256994200197568000000000000000
23892238933073202021-01-0769813077600017760000000000000