Overview

Dataset statistics

Number of variables27
Number of observations590
Missing cells1744
Missing cells (%)10.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory134.4 KiB
Average record size in memory233.2 B

Variable types

Numeric10
DateTime8
Categorical8
Boolean1

Dataset

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

Alerts

가산금 has constant value ""Constant
중가산횟수 is highly imbalanced (66.9%)Imbalance
할인금액 is highly imbalanced (64.6%)Imbalance
중가산금 is highly imbalanced (92.0%)Imbalance
중가산부과여부 is highly imbalanced (85.7%)Imbalance
수납일자 has 57 (9.7%) missing valuesMissing
중가산결정일 has 554 (93.9%) missing valuesMissing
중가산기한일 has 554 (93.9%) missing valuesMissing
할인금액결의번호 has 579 (98.1%) missing valuesMissing
위반금액 is highly skewed (γ1 = 23.36395608)Skewed
고지(징수)금액 is highly skewed (γ1 = 23.36335118)Skewed
연번 has unique valuesUnique
조정량 has 321 (54.4%) zerosZeros
위반금액 has 6 (1.0%) zerosZeros
고지(징수)금액 has 6 (1.0%) zerosZeros

Reproduction

Analysis started2023-12-10 16:16:21.332188
Analysis finished2023-12-10 16:16:21.678040
Duration0.35 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct590
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean295.5
Minimum1
Maximum590
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.3 KiB
2023-12-11T01:16:21.743471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile30.45
Q1148.25
median295.5
Q3442.75
95-th percentile560.55
Maximum590
Range589
Interquartile range (IQR)294.5

Descriptive statistics

Standard deviation170.46261
Coefficient of variation (CV)0.57686161
Kurtosis-1.2
Mean295.5
Median Absolute Deviation (MAD)147.5
Skewness0
Sum174345
Variance29057.5
MonotonicityStrictly increasing
2023-12-11T01:16:21.889106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
407 1
 
0.2%
391 1
 
0.2%
392 1
 
0.2%
393 1
 
0.2%
394 1
 
0.2%
395 1
 
0.2%
396 1
 
0.2%
397 1
 
0.2%
398 1
 
0.2%
Other values (580) 580
98.3%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
590 1
0.2%
589 1
0.2%
588 1
0.2%
587 1
0.2%
586 1
0.2%
585 1
0.2%
584 1
0.2%
583 1
0.2%
582 1
0.2%
581 1
0.2%

사업소코드
Real number (ℝ)

Distinct12
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean296.95424
Minimum201
Maximum312
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.3 KiB
2023-12-11T01:16:22.039032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation23.990581
Coefficient of variation (CV)0.080788816
Kurtosis2.6814506
Mean296.95424
Median Absolute Deviation (MAD)3
Skewness-2.0228768
Sum175203
Variance575.54799
MonotonicityNot monotonic
2023-12-11T01:16:22.179380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
244 85
14.4%
304 77
13.1%
308 76
12.9%
307 71
12.0%
311 52
8.8%
312 51
8.6%
306 47
8.0%
302 47
8.0%
309 44
7.5%
303 27
 
4.6%
Other values (2) 13
 
2.2%
ValueCountFrequency (%)
201 5
 
0.8%
244 85
14.4%
301 8
 
1.4%
302 47
8.0%
303 27
 
4.6%
304 77
13.1%
306 47
8.0%
307 71
12.0%
308 76
12.9%
309 44
7.5%
ValueCountFrequency (%)
312 51
8.6%
311 52
8.8%
309 44
7.5%
308 76
12.9%
307 71
12.0%
306 47
8.0%
304 77
13.1%
303 27
 
4.6%
302 47
8.0%
301 8
 
1.4%

접수일자
Date

Distinct78
Distinct (%)13.2%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
Minimum2021-01-04 00:00:00
Maximum2021-05-28 00:00:00
2023-12-11T01:16:22.347975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:22.521920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

일련번호
Real number (ℝ)

Distinct8
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.4050847
Minimum1
Maximum8
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.3 KiB
2023-12-11T01:16:22.682191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation1.0161554
Coefficient of variation (CV)0.72319863
Kurtosis13.844737
Mean1.4050847
Median Absolute Deviation (MAD)0
Skewness3.488601
Sum829
Variance1.0325717
MonotonicityNot monotonic
2023-12-11T01:16:22.798784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
1 462
78.3%
2 80
 
13.6%
3 20
 
3.4%
4 9
 
1.5%
5 9
 
1.5%
6 6
 
1.0%
7 2
 
0.3%
8 2
 
0.3%
ValueCountFrequency (%)
1 462
78.3%
2 80
 
13.6%
3 20
 
3.4%
4 9
 
1.5%
5 9
 
1.5%
6 6
 
1.0%
7 2
 
0.3%
8 2
 
0.3%
ValueCountFrequency (%)
8 2
 
0.3%
7 2
 
0.3%
6 6
 
1.0%
5 9
 
1.5%
4 9
 
1.5%
3 20
 
3.4%
2 80
 
13.6%
1 462
78.3%

위반종류코드
Categorical

Distinct3
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
400
327 
500
257 
300
 
6

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
400 327
55.4%
500 257
43.6%
300 6
 
1.0%

Length

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

Common Values (Plot)

2023-12-11T01:16:23.093774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
400 327
55.4%
500 257
43.6%
300 6
 
1.0%

위반항목코드
Categorical

Distinct5
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
401
268 
501
257 
499
53 
402
 
6
302
 
6

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
401 268
45.4%
501 257
43.6%
499 53
 
9.0%
402 6
 
1.0%
302 6
 
1.0%

Length

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

Common Values (Plot)

2023-12-11T01:16:23.358786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
401 268
45.4%
501 257
43.6%
499 53
 
9.0%
402 6
 
1.0%
302 6
 
1.0%

위반일자
Date

Distinct87
Distinct (%)14.7%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
Minimum2020-09-09 00:00:00
Maximum2021-05-25 00:00:00
2023-12-11T01:16:23.523902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:23.689768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

고지일자
Date

Distinct79
Distinct (%)13.4%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
Minimum2021-01-04 00:00:00
Maximum2021-05-31 00:00:00
2023-12-11T01:16:23.883381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:24.081234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

고지번호
Real number (ℝ)

Distinct205
Distinct (%)34.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.021033 × 1013
Minimum2.021013 × 1013
Maximum2.021053 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.3 KiB
2023-12-11T01:16:24.298613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.021013 × 1013
5-th percentile2.021013 × 1013
Q12.021023 × 1013
median2.021033 × 1013
Q32.021043 × 1013
95-th percentile2.021053 × 1013
Maximum2.021053 × 1013
Range4.0000374 × 108
Interquartile range (IQR)2.0000153 × 108

Descriptive statistics

Standard deviation1.2511547 × 108
Coefficient of variation (CV)6.1906693 × 10-6
Kurtosis-0.99243698
Mean2.021033 × 1013
Median Absolute Deviation (MAD)1.0000075 × 108
Skewness-0.15656828
Sum1.1924095 × 1016
Variance1.5653881 × 1016
MonotonicityNot monotonic
2023-12-11T01:16:24.494317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20210130278417 6
 
1.0%
20210430280303 6
 
1.0%
20210430280227 6
 
1.0%
20210430280594 6
 
1.0%
20210230279059 6
 
1.0%
20210330279319 6
 
1.0%
20210430280111 6
 
1.0%
20210330279491 6
 
1.0%
20210330279493 6
 
1.0%
20210430280937 6
 
1.0%
Other values (195) 530
89.8%
ValueCountFrequency (%)
20210130278069 1
 
0.2%
20210130278102 1
 
0.2%
20210130278126 4
0.7%
20210130278133 3
0.5%
20210130278172 4
0.7%
20210130278187 1
 
0.2%
20210130278199 2
 
0.3%
20210130278315 5
0.8%
20210130278327 4
0.7%
20210130278360 4
0.7%
ValueCountFrequency (%)
20210530281804 1
 
0.2%
20210530281748 5
0.8%
20210530281730 4
0.7%
20210530281725 1
 
0.2%
20210530281694 2
 
0.3%
20210530281654 4
0.7%
20210530281642 3
0.5%
20210530281474 3
0.5%
20210530281472 3
0.5%
20210530281397 2
 
0.3%

납기내일자
Date

Distinct52
Distinct (%)8.8%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
Minimum2021-01-20 00:00:00
Maximum2021-06-30 00:00:00
2023-12-11T01:16:24.678359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:24.869191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

납기후일자
Date

Distinct42
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
Minimum2021-01-20 00:00:00
Maximum2021-06-30 00:00:00
2023-12-11T01:16:25.340914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:25.493364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)

수납일자
Date

MISSING 

Distinct77
Distinct (%)14.4%
Missing57
Missing (%)9.7%
Memory size4.7 KiB
Minimum2021-01-04 00:00:00
Maximum2021-06-10 00:00:00
2023-12-11T01:16:25.643579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:25.839933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

중가산결정일
Date

MISSING 

Distinct3
Distinct (%)8.3%
Missing554
Missing (%)93.9%
Memory size4.7 KiB
Minimum2021-02-28 00:00:00
Maximum2021-05-31 00:00:00
2023-12-11T01:16:25.994085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:26.136169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=3)

중가산기한일
Date

MISSING 

Distinct3
Distinct (%)8.3%
Missing554
Missing (%)93.9%
Memory size4.7 KiB
Minimum2021-03-31 00:00:00
Maximum2021-06-30 00:00:00
2023-12-11T01:16:26.278006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:16:26.423649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=3)

중가산횟수
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
<NA>
554 
1
 
36

Length

Max length4
Median length4
Mean length3.8169492
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 554
93.9%
1 36
 
6.1%

Length

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

Common Values (Plot)

2023-12-11T01:16:26.759270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 554
93.9%
1 36
 
6.1%

순번
Real number (ℝ)

Distinct6
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.2966102
Minimum1
Maximum6
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.3 KiB
2023-12-11T01:16:26.884918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median2
Q33
95-th percentile5
Maximum6
Range5
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.284023
Coefficient of variation (CV)0.5590949
Kurtosis-0.088446064
Mean2.2966102
Median Absolute Deviation (MAD)1
Skewness0.81879177
Sum1355
Variance1.6487151
MonotonicityNot monotonic
2023-12-11T01:16:27.020266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
1 205
34.7%
2 167
28.3%
3 102
17.3%
4 81
 
13.7%
5 24
 
4.1%
6 11
 
1.9%
ValueCountFrequency (%)
1 205
34.7%
2 167
28.3%
3 102
17.3%
4 81
 
13.7%
5 24
 
4.1%
6 11
 
1.9%
ValueCountFrequency (%)
6 11
 
1.9%
5 24
 
4.1%
4 81
 
13.7%
3 102
17.3%
2 167
28.3%
1 205
34.7%

예산코드
Categorical

Distinct5
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
11630
322 
<NA>
169 
11117
85 
11111
 
13
11126
 
1

Length

Max length5
Median length5
Mean length4.7135593
Min length4

Unique

Unique1 ?
Unique (%)0.2%

Sample

1st row11630
2nd row11630
3rd row11630
4th row11111
5th row<NA>

Common Values

ValueCountFrequency (%)
11630 322
54.6%
<NA> 169
28.6%
11117 85
 
14.4%
11111 13
 
2.2%
11126 1
 
0.2%

Length

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

Common Values (Plot)

2023-12-11T01:16:27.354861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
11630 322
54.6%
na 169
28.6%
11117 85
 
14.4%
11111 13
 
2.2%
11126 1
 
0.2%

분류코드
Real number (ℝ)

Distinct13
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6584.9576
Minimum6421
Maximum6993
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.3 KiB
2023-12-11T01:16:27.478242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum6421
5-th percentile6421
Q16423
median6424
Q36983
95-th percentile6993
Maximum6993
Range572
Interquartile range (IQR)560

Descriptive statistics

Standard deviation255.27248
Coefficient of variation (CV)0.038766002
Kurtosis-1.105446
Mean6584.9576
Median Absolute Deviation (MAD)2
Skewness0.94741984
Sum3885125
Variance65164.041
MonotonicityNot monotonic
2023-12-11T01:16:27.622879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
6424 99
16.8%
6422 83
14.1%
6423 76
12.9%
6425 68
11.5%
6983 68
11.5%
6421 64
10.8%
6993 64
10.8%
6991 19
 
3.2%
6981 17
 
2.9%
6428 17
 
2.9%
Other values (3) 15
 
2.5%
ValueCountFrequency (%)
6421 64
10.8%
6422 83
14.1%
6423 76
12.9%
6424 99
16.8%
6425 68
11.5%
6426 13
 
2.2%
6428 17
 
2.9%
6431 1
 
0.2%
6981 17
 
2.9%
6983 68
11.5%
ValueCountFrequency (%)
6993 64
10.8%
6991 19
 
3.2%
6984 1
 
0.2%
6983 68
11.5%
6981 17
 
2.9%
6431 1
 
0.2%
6428 17
 
2.9%
6426 13
 
2.2%
6425 68
11.5%
6424 99
16.8%

조정량
Real number (ℝ)

ZEROS 

Distinct45
Distinct (%)7.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17.567797
Minimum0
Maximum1639
Zeros321
Zeros (%)54.4%
Negative0
Negative (%)0.0%
Memory size5.3 KiB
2023-12-11T01:16:27.795420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q39
95-th percentile73
Maximum1639
Range1639
Interquartile range (IQR)9

Descriptive statistics

Standard deviation101.88441
Coefficient of variation (CV)5.7994984
Kurtosis180.32598
Mean17.567797
Median Absolute Deviation (MAD)0
Skewness12.941435
Sum10365
Variance10380.433
MonotonicityNot monotonic
2023-12-11T01:16:27.963442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
0 321
54.4%
1 33
 
5.6%
4 26
 
4.4%
6 19
 
3.2%
3 15
 
2.5%
10 15
 
2.5%
9 13
 
2.2%
12 13
 
2.2%
2 12
 
2.0%
15 9
 
1.5%
Other values (35) 114
 
19.3%
ValueCountFrequency (%)
0 321
54.4%
1 33
 
5.6%
2 12
 
2.0%
3 15
 
2.5%
4 26
 
4.4%
5 3
 
0.5%
6 19
 
3.2%
7 6
 
1.0%
8 6
 
1.0%
9 13
 
2.2%
ValueCountFrequency (%)
1639 1
 
0.2%
1260 1
 
0.2%
1238 1
 
0.2%
180 3
0.5%
165 1
 
0.2%
158 3
0.5%
126 3
0.5%
124 3
0.5%
100 3
0.5%
99 1
 
0.2%

위반금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct257
Distinct (%)43.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean258394.78
Minimum0
Maximum76669000
Zeros6
Zeros (%)1.0%
Negative0
Negative (%)0.0%
Memory size5.3 KiB
2023-12-11T01:16:28.161219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile600
Q18647.5
median24410
Q359970
95-th percentile547935
Maximum76669000
Range76669000
Interquartile range (IQR)51322.5

Descriptive statistics

Standard deviation3195033.2
Coefficient of variation (CV)12.36493
Kurtosis558.25467
Mean258394.78
Median Absolute Deviation (MAD)21770
Skewness23.363956
Sum1.5245292 × 108
Variance1.0208237 × 1013
MonotonicityNot monotonic
2023-12-11T01:16:28.368635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
24310 60
 
10.2%
30000 50
 
8.5%
50000 44
 
7.5%
62590 30
 
5.1%
41870 11
 
1.9%
1330 9
 
1.5%
150 9
 
1.5%
1950 8
 
1.4%
24410 7
 
1.2%
600 7
 
1.2%
Other values (247) 355
60.2%
ValueCountFrequency (%)
0 6
1.0%
140 2
 
0.3%
150 9
1.5%
280 1
 
0.2%
300 3
 
0.5%
440 1
 
0.2%
450 2
 
0.3%
580 1
 
0.2%
600 7
1.2%
750 2
 
0.3%
ValueCountFrequency (%)
76669000 1
0.2%
10639000 1
0.2%
3340030 1
0.2%
2497120 1
0.2%
2368200 1
0.2%
1967000 1
0.2%
1863660 1
0.2%
1670000 1
0.2%
1540900 1
0.2%
1496420 1
0.2%

할인금액
Categorical

IMBALANCE 

Distinct4
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
0
513 
10000
 
41
6000
 
34
20000
 
2

Length

Max length5
Median length1
Mean length1.4644068
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 513
86.9%
10000 41
 
6.9%
6000 34
 
5.8%
20000 2
 
0.3%

Length

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

Common Values (Plot)

2023-12-11T01:16:28.751018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 513
86.9%
10000 41
 
6.9%
6000 34
 
5.8%
20000 2
 
0.3%

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

SKEWED  ZEROS 

Distinct258
Distinct (%)43.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean257286.3
Minimum0
Maximum76669000
Zeros6
Zeros (%)1.0%
Negative0
Negative (%)0.0%
Memory size5.3 KiB
2023-12-11T01:16:28.916798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile600
Q18647.5
median24310
Q359970
95-th percentile547935
Maximum76669000
Range76669000
Interquartile range (IQR)51322.5

Descriptive statistics

Standard deviation3195108.2
Coefficient of variation (CV)12.418493
Kurtosis558.23465
Mean257286.3
Median Absolute Deviation (MAD)18395
Skewness23.363351
Sum1.5179892 × 108
Variance1.0208716 × 1013
MonotonicityNot monotonic
2023-12-11T01:16:29.130424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
24310 60
 
10.2%
40000 41
 
6.9%
24000 36
 
6.1%
62590 30
 
5.1%
30000 16
 
2.7%
41870 11
 
1.9%
1330 9
 
1.5%
150 9
 
1.5%
1950 8
 
1.4%
600 7
 
1.2%
Other values (248) 363
61.5%
ValueCountFrequency (%)
0 6
1.0%
140 2
 
0.3%
150 9
1.5%
280 1
 
0.2%
300 3
 
0.5%
440 1
 
0.2%
450 2
 
0.3%
580 1
 
0.2%
600 7
1.2%
750 2
 
0.3%
ValueCountFrequency (%)
76669000 1
0.2%
10639000 1
0.2%
3340030 1
0.2%
2497120 1
0.2%
2368200 1
0.2%
1967000 1
0.2%
1863660 1
0.2%
1670000 1
0.2%
1540900 1
0.2%
1496420 1
0.2%

가산금
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
0
590 

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

Length

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

Common Values (Plot)

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

중가산금
Categorical

IMBALANCE 

Distinct4
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
0
578 
360
 
10
600
 
1
280
 
1

Length

Max length3
Median length1
Mean length1.040678
Min length1

Unique

Unique2 ?
Unique (%)0.3%

Sample

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

Common Values

ValueCountFrequency (%)
0 578
98.0%
360 10
 
1.7%
600 1
 
0.2%
280 1
 
0.2%

Length

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

Common Values (Plot)

2023-12-11T01:16:29.912581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 578
98.0%
360 10
 
1.7%
600 1
 
0.2%
280 1
 
0.2%

중가산부과여부
Boolean

IMBALANCE 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size722.0 B
False
578 
True
 
12
ValueCountFrequency (%)
False 578
98.0%
True 12
 
2.0%
2023-12-11T01:16:30.112878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

부과사유
Categorical

Distinct14
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
조례위반과태료 등
99 
계량기교체비
82 
관파열복구비
76 
방수료(일반용)
68 
물이용부담금(일반용)
68 
Other values (9)
197 

Length

Max length11
Median length10
Mean length7.8576271
Min length6

Unique

Unique3 ?
Unique (%)0.5%

Sample

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

Common Values

ValueCountFrequency (%)
조례위반과태료 등 99
16.8%
계량기교체비 82
13.9%
관파열복구비 76
12.9%
방수료(일반용) 68
11.5%
물이용부담금(일반용) 68
11.5%
계량기수선비 64
10.8%
하수도(영업용) 64
10.8%
하수도(가정용) 19
 
3.2%
물이용부담금(가정용) 17
 
2.9%
일반용사용료추징 17
 
2.9%
Other values (4) 16
 
2.7%

Length

2023-12-11T01:16:30.413280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
조례위반과태료 99
14.4%
등 99
14.4%
계량기교체비 82
11.9%
관파열복구비 76
11.0%
방수료(일반용 68
9.9%
물이용부담금(일반용 68
9.9%
계량기수선비 64
9.3%
하수도(영업용 64
9.3%
하수도(가정용 19
 
2.8%
물이용부담금(가정용 17
 
2.5%
Other values (5) 33
 
4.8%

할인금액결의번호
Real number (ℝ)

MISSING 

Distinct11
Distinct (%)100.0%
Missing579
Missing (%)98.1%
Infinite0
Infinite (%)0.0%
Mean2.9084748 × 1013
Minimum2.4412021 × 1013
Maximum3.0912021 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.3 KiB
2023-12-11T01:16:30.675797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.4412021 × 1013
5-th percentile2.4412021 × 1013
Q12.7512021 × 1013
median3.0912021 × 1013
Q33.0912021 × 1013
95-th percentile3.0912021 × 1013
Maximum3.0912021 × 1013
Range6.5 × 1012
Interquartile range (IQR)3.4 × 1012

Descriptive statistics

Standard deviation3.0033617 × 1012
Coefficient of variation (CV)0.10326243
Kurtosis-0.76877058
Mean2.9084748 × 1013
Median Absolute Deviation (MAD)5
Skewness-1.1835939
Sum3.1993223 × 1014
Variance9.0201818 × 1024
MonotonicityNot monotonic
2023-12-11T01:16:30.913543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
30612021021789 1
 
0.2%
30912021031704 1
 
0.2%
30912021031705 1
 
0.2%
30912021031706 1
 
0.2%
24412021052462 1
 
0.2%
24412021052463 1
 
0.2%
30912021031707 1
 
0.2%
30912021031708 1
 
0.2%
30612021021790 1
 
0.2%
30912021031709 1
 
0.2%
(Missing) 579
98.1%
ValueCountFrequency (%)
24412021052462 1
0.2%
24412021052463 1
0.2%
24412021052464 1
0.2%
30612021021789 1
0.2%
30612021021790 1
0.2%
30912021031704 1
0.2%
30912021031705 1
0.2%
30912021031706 1
0.2%
30912021031707 1
0.2%
30912021031708 1
0.2%
ValueCountFrequency (%)
30912021031709 1
0.2%
30912021031708 1
0.2%
30912021031707 1
0.2%
30912021031706 1
0.2%
30912021031705 1
0.2%
30912021031704 1
0.2%
30612021021790 1
0.2%
30612021021789 1
0.2%
24412021052464 1
0.2%
24412021052463 1
0.2%

Sample

연번사업소코드접수일자일련번호위반종류코드위반항목코드위반일자고지일자고지번호납기내일자납기후일자수납일자중가산결정일중가산기한일중가산횟수순번예산코드분류코드조정량위반금액할인금액고지(징수)금액가산금중가산금중가산부과여부부과사유할인금액결의번호
013062021-01-1514004992021-01-142021-01-15202101302784172021-02-282021-03-312021-03-242021-02-282021-03-31111163064240300000300000360Y조례위반과태료 등30612021021789
123062021-01-1514004992021-01-142021-01-15202101302784172021-02-282021-03-312021-03-242021-02-282021-03-311211630642202133002133000N계량기교체비<NA>
233062021-01-1514004992021-01-142021-01-15202101302784172021-02-282021-03-312021-03-242021-02-282021-03-311311630642103864003864000N계량기수선비<NA>
343062021-01-1514004992021-01-142021-01-15202101302784172021-02-282021-03-312021-03-242021-02-282021-03-3114111116426643200432000N가정용사용료추징<NA>
453062021-01-1514004992021-01-142021-01-15202101302784172021-02-282021-03-312021-03-242021-02-282021-03-3115<NA>6991627000270000N하수도(가정용)<NA>
563062021-01-1514004992021-01-142021-01-15202101302784172021-02-282021-03-312021-03-242021-02-282021-03-3116<NA>69816890089000N물이용부담금(가정용)<NA>
673122021-01-2815005012021-01-212021-01-28202101302786692021-02-272021-03-312021-03-09<NA><NA><NA>11163064230354930035493000N관파열복구비<NA>
783122021-01-2815005012021-01-212021-01-28202101302786692021-02-272021-03-312021-03-09<NA><NA><NA>2111176425566500665000N방수료(일반용)<NA>
893122021-01-2815005012021-01-212021-01-28202101302786692021-02-272021-03-312021-03-09<NA><NA><NA>3<NA>6993597500975000N하수도(영업용)<NA>
9103122021-01-2815005012021-01-212021-01-28202101302786692021-02-272021-03-312021-03-09<NA><NA><NA>4<NA>69835750075000N물이용부담금(일반용)<NA>
연번사업소코드접수일자일련번호위반종류코드위반항목코드위반일자고지일자고지번호납기내일자납기후일자수납일자중가산결정일중가산기한일중가산횟수순번예산코드분류코드조정량위반금액할인금액고지(징수)금액가산금중가산금중가산부과여부부과사유할인금액결의번호
5805813032021-03-2554004992021-03-252021-03-25202103302799722021-03-312021-04-302021-04-14<NA><NA><NA>111630642106259006259000N계량기수선비<NA>
5815822442021-04-2924004012021-02-042021-04-29202104302810322021-05-312021-06-30<NA>2021-05-312021-06-301111630642102431002431000N계량기수선비<NA>
5825832442021-04-2924004012021-02-042021-04-29202104302810322021-05-312021-06-30<NA>2021-05-312021-06-30121163064240300000300000360Y조례위반과태료 등24412021052464
5835842442021-04-2924004012021-02-042021-04-29202104302810322021-05-312021-06-30<NA>2021-05-312021-06-3013111116426000000N가정용사용료추징<NA>
5845852442021-04-2924004012021-02-042021-04-29202104302810322021-05-312021-06-30<NA>2021-05-312021-06-3014<NA>6991000000N하수도(가정용)<NA>
5855862442021-04-2924004012021-02-042021-04-29202104302810322021-05-312021-06-30<NA>2021-05-312021-06-3015<NA>6981000000N물이용부담금(가정용)<NA>
5865873072021-05-2514004022021-05-252021-05-31202105302816942021-06-302021-06-30<NA><NA><NA><NA>1116306424050000100004000000N조례위반과태료 등<NA>
5875883072021-05-2514004022021-05-252021-05-31202105302816942021-06-302021-06-30<NA><NA><NA><NA>2116306421035800358000N계량기수선비<NA>
5885893042021-04-2314004012021-04-232021-04-23202104302808562021-05-312021-05-312021-04-23<NA><NA><NA>211630642102431002431000N계량기수선비<NA>
5895903042021-04-2314004012021-04-232021-04-23202104302808562021-05-312021-05-312021-04-23<NA><NA><NA>111630642403000060002400000N조례위반과태료 등<NA>