Overview

Dataset statistics

Number of variables28
Number of observations10000
Missing cells46901
Missing cells (%)16.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.4 MiB
Average record size in memory250.0 B

Variable types

Numeric18
DateTime4
Categorical5
Text1

Dataset

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

Alerts

과오납코드 is highly imbalanced (68.2%)Imbalance
결의코드 is highly imbalanced (77.7%)Imbalance
예산과목 is highly imbalanced (59.5%)Imbalance
분류코드 is highly imbalanced (53.5%)Imbalance
통지일자 has 9061 (90.6%) missing valuesMissing
처리고지번호 has 814 (8.1%) missing valuesMissing
감액고지번호 has 9209 (92.1%) missing valuesMissing
결의일자 has 9209 (92.1%) missing valuesMissing
결의번호 has 9216 (92.2%) missing valuesMissing
결재처리문서ID has 9392 (93.9%) missing valuesMissing
과오납총금액 is highly skewed (γ1 = -57.35886336)Skewed
상수도과오금액 is highly skewed (γ1 = -57.47090531)Skewed
총이자 is highly skewed (γ1 = -57.6594507)Skewed
상수도이자 is highly skewed (γ1 = -57.65956763)Skewed
하수도이자 is highly skewed (γ1 = -26.6798091)Skewed
물이용이자 is highly skewed (γ1 = -70.16832962)Skewed
고지금액(정산_충당_환불) is highly skewed (γ1 = -24.70548739)Skewed
가산금(정산_충당_환불) is highly skewed (γ1 = -76.50369754)Skewed
이자 is highly skewed (γ1 = -48.04315049)Skewed
총사용금액 is highly skewed (γ1 = -24.70601141)Skewed
연번 has unique valuesUnique
상수도과오금액 has 515 (5.1%) zerosZeros
하수도과오금액 has 1145 (11.5%) zerosZeros
물이용과오금액 has 555 (5.5%) zerosZeros
총이자 has 9397 (94.0%) zerosZeros
상수도이자 has 9617 (96.2%) zerosZeros
하수도이자 has 9858 (98.6%) zerosZeros
물이용이자 has 9806 (98.1%) zerosZeros
가산금(정산_충당_환불) has 9985 (99.9%) zerosZeros
이자 has 9581 (95.8%) zerosZeros

Reproduction

Analysis started2024-03-14 08:45:28.162149
Analysis finished2024-03-14 08:45:28.963007
Duration0.8 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%
Mean15494.876
Minimum4
Maximum30963
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T17:45:29.151998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4
5-th percentile1552.7
Q17710.75
median15446.5
Q323291.25
95-th percentile29461.15
Maximum30963
Range30959
Interquartile range (IQR)15580.5

Descriptive statistics

Standard deviation8962.9229
Coefficient of variation (CV)0.57844431
Kurtosis-1.2082569
Mean15494.876
Median Absolute Deviation (MAD)7791.5
Skewness0.0047154115
Sum1.5494876 × 108
Variance80333988
MonotonicityNot monotonic
2024-03-14T17:45:29.586448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
21082 1
 
< 0.1%
5011 1
 
< 0.1%
30571 1
 
< 0.1%
27305 1
 
< 0.1%
14495 1
 
< 0.1%
11507 1
 
< 0.1%
18411 1
 
< 0.1%
447 1
 
< 0.1%
28505 1
 
< 0.1%
3841 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
4 1
< 0.1%
9 1
< 0.1%
12 1
< 0.1%
20 1
< 0.1%
21 1
< 0.1%
27 1
< 0.1%
30 1
< 0.1%
31 1
< 0.1%
32 1
< 0.1%
33 1
< 0.1%
ValueCountFrequency (%)
30963 1
< 0.1%
30962 1
< 0.1%
30958 1
< 0.1%
30957 1
< 0.1%
30956 1
< 0.1%
30950 1
< 0.1%
30949 1
< 0.1%
30947 1
< 0.1%
30937 1
< 0.1%
30932 1
< 0.1%

고지년월
Date

Distinct48
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2013-08-01 00:00:00
Maximum2023-12-01 00:00:00
2024-03-14T17:45:29.996001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T17:45:30.421904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=48)

과오납코드
Categorical

IMBALANCE 

Distinct14
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
옥내누수감면
7950 
수조정정산
 
783
이중수납
 
561
정산복구
 
359
과대수납
 
118
Other values (9)
 
229

Length

Max length13
Median length6
Mean length5.7703
Min length4

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row옥내누수감면
2nd row수조정정산
3rd row옥내누수감면
4th row이중수납
5th row옥내누수감면

Common Values

ValueCountFrequency (%)
옥내누수감면 7950
79.5%
수조정정산 783
 
7.8%
이중수납 561
 
5.6%
정산복구 359
 
3.6%
과대수납 118
 
1.2%
급수공사정산잔액환불 94
 
0.9%
급수공사취소 48
 
0.5%
사용료 착오분 환불 38
 
0.4%
추징복구 21
 
0.2%
청구 착오분 환불 15
 
0.1%
Other values (4) 13
 
0.1%

Length

2024-03-14T17:45:30.831387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
옥내누수감면 7950
78.6%
수조정정산 783
 
7.7%
이중수납 561
 
5.5%
정산복구 359
 
3.5%
과대수납 118
 
1.2%
급수공사정산잔액환불 94
 
0.9%
환불 56
 
0.6%
착오분 53
 
0.5%
급수공사취소 48
 
0.5%
사용료 38
 
0.4%
Other values (7) 55
 
0.5%

통지일자
Date

MISSING 

Distinct183
Distinct (%)19.5%
Missing9061
Missing (%)90.6%
Memory size156.2 KiB
Minimum2022-12-29 00:00:00
Maximum2023-12-29 00:00:00
2024-03-14T17:45:31.183541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T17:45:31.431033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

과오납총금액
Real number (ℝ)

SKEWED 

Distinct3563
Distinct (%)35.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-301978.37
Minimum-4.849961 × 108
Maximum3259310
Zeros0
Zeros (%)0.0%
Negative9935
Negative (%)99.4%
Memory size166.0 KiB
2024-03-14T17:45:31.688124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-4.849961 × 108
5-th percentile-560720
Q1-112140
median-47870
Q3-20895
95-th percentile-5220
Maximum3259310
Range4.8825541 × 108
Interquartile range (IQR)91245

Descriptive statistics

Standard deviation8414467.5
Coefficient of variation (CV)-27.864471
Kurtosis3302.1425
Mean-301978.37
Median Absolute Deviation (MAD)33670
Skewness-57.358863
Sum-3.0197837 × 109
Variance7.0803264 × 1013
MonotonicityNot monotonic
2024-03-14T17:45:31.946014image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-16740 21
 
0.2%
-2380 19
 
0.2%
-20820 19
 
0.2%
-4400 18
 
0.2%
-20180 18
 
0.2%
-52500 18
 
0.2%
-15700 17
 
0.2%
-31740 17
 
0.2%
-1780 16
 
0.2%
-13210 16
 
0.2%
Other values (3553) 9821
98.2%
ValueCountFrequency (%)
-484996100 3
< 0.1%
-14240790 2
< 0.1%
-12775610 1
 
< 0.1%
-12315780 2
< 0.1%
-12157000 2
< 0.1%
-9049630 3
< 0.1%
-7738400 1
 
< 0.1%
-6297840 1
 
< 0.1%
-6186390 1
 
< 0.1%
-6062000 1
 
< 0.1%
ValueCountFrequency (%)
3259310 2
< 0.1%
637080 2
< 0.1%
517880 1
< 0.1%
371480 1
< 0.1%
333560 1
< 0.1%
322080 2
< 0.1%
320920 2
< 0.1%
292880 1
< 0.1%
210000 1
< 0.1%
170330 2
< 0.1%

상수도과오금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct2426
Distinct (%)24.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-227484.14
Minimum-4.849961 × 108
Maximum1745830
Zeros515
Zeros (%)5.1%
Negative9432
Negative (%)94.3%
Memory size166.0 KiB
2024-03-14T17:45:32.289646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-4.849961 × 108
5-th percentile-218040
Q1-43365
median-19600
Q3-8175
95-th percentile0
Maximum1745830
Range4.8674193 × 108
Interquartile range (IQR)35190

Descriptive statistics

Standard deviation8410243.9
Coefficient of variation (CV)-36.970683
Kurtosis3310.8222
Mean-227484.14
Median Absolute Deviation (MAD)13920
Skewness-57.470905
Sum-2.2748414 × 109
Variance7.0732202 × 1013
MonotonicityNot monotonic
2024-03-14T17:45:32.726828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 515
 
5.1%
-7200 35
 
0.4%
-7720 32
 
0.3%
-5400 30
 
0.3%
-11520 29
 
0.3%
-6000 29
 
0.3%
-2380 28
 
0.3%
-6420 27
 
0.3%
-15000 26
 
0.3%
-11880 26
 
0.3%
Other values (2416) 9223
92.2%
ValueCountFrequency (%)
-484996100 3
< 0.1%
-14240790 2
< 0.1%
-12157000 2
< 0.1%
-9049480 3
< 0.1%
-7577010 2
< 0.1%
-6297840 1
 
< 0.1%
-5895620 2
< 0.1%
-5513520 1
 
< 0.1%
-5445690 1
 
< 0.1%
-4992330 3
< 0.1%
ValueCountFrequency (%)
1745830 2
< 0.1%
228760 1
< 0.1%
200340 1
< 0.1%
197260 2
< 0.1%
175940 1
< 0.1%
150000 1
< 0.1%
145720 2
< 0.1%
141730 2
< 0.1%
138860 1
< 0.1%
100780 2
< 0.1%

하수도과오금액
Real number (ℝ)

ZEROS 

Distinct2360
Distinct (%)23.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-67606.637
Minimum-6632800
Maximum1159380
Zeros1145
Zeros (%)11.5%
Negative8786
Negative (%)87.9%
Memory size166.0 KiB
2024-03-14T17:45:33.174305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-6632800
5-th percentile-275510
Q1-54260
median-21480
Q3-7200
95-th percentile0
Maximum1159380
Range7792180
Interquartile range (IQR)47060

Descriptive statistics

Standard deviation191486.67
Coefficient of variation (CV)-2.8323649
Kurtosis244.54363
Mean-67606.637
Median Absolute Deviation (MAD)17440
Skewness-11.469756
Sum-6.7606637 × 108
Variance3.6667144 × 1010
MonotonicityNot monotonic
2024-03-14T17:45:33.569398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 1145
 
11.5%
-4500 58
 
0.6%
-6380 47
 
0.5%
-5400 46
 
0.5%
-4940 44
 
0.4%
-5840 44
 
0.4%
-9000 43
 
0.4%
-4040 41
 
0.4%
-5220 41
 
0.4%
-3600 38
 
0.4%
Other values (2350) 8453
84.5%
ValueCountFrequency (%)
-6632800 1
< 0.1%
-4483050 1
< 0.1%
-4017600 1
< 0.1%
-3873960 2
< 0.1%
-3081000 1
< 0.1%
-2378140 1
< 0.1%
-2215200 1
< 0.1%
-2103200 1
< 0.1%
-2065050 2
< 0.1%
-1932440 2
< 0.1%
ValueCountFrequency (%)
1159380 2
< 0.1%
411820 2
< 0.1%
293400 1
< 0.1%
207460 2
< 0.1%
162920 2
< 0.1%
136780 1
< 0.1%
122000 1
< 0.1%
116960 1
< 0.1%
100580 2
< 0.1%
69400 1
< 0.1%

물이용과오금액
Real number (ℝ)

ZEROS 

Distinct1237
Distinct (%)12.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-6887.599
Minimum-864810
Maximum354100
Zeros555
Zeros (%)5.5%
Negative9382
Negative (%)93.8%
Memory size166.0 KiB
2024-03-14T17:45:33.985133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-864810
5-th percentile-22900
Q1-6325
median-3100
Q3-1417.5
95-th percentile0
Maximum354100
Range1218910
Interquartile range (IQR)4907.5

Descriptive statistics

Standard deviation21991.734
Coefficient of variation (CV)-3.1929464
Kurtosis625.52084
Mean-6887.599
Median Absolute Deviation (MAD)2040
Skewness-18.282438
Sum-68875990
Variance4.8363639 × 108
MonotonicityNot monotonic
2024-03-14T17:45:34.422677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 555
 
5.5%
-1500 104
 
1.0%
-1960 101
 
1.0%
-760 92
 
0.9%
-460 83
 
0.8%
-1360 79
 
0.8%
-680 76
 
0.8%
-1140 76
 
0.8%
-1060 74
 
0.7%
-840 73
 
0.7%
Other values (1227) 8687
86.9%
ValueCountFrequency (%)
-864810 2
< 0.1%
-629290 1
 
< 0.1%
-616310 1
 
< 0.1%
-381170 1
 
< 0.1%
-311040 1
 
< 0.1%
-248810 1
 
< 0.1%
-233230 3
< 0.1%
-212210 1
 
< 0.1%
-201820 4
< 0.1%
-198230 1
 
< 0.1%
ValueCountFrequency (%)
354100 2
< 0.1%
35620 1
< 0.1%
30000 1
< 0.1%
28000 2
< 0.1%
25760 1
< 0.1%
24140 1
< 0.1%
22210 2
< 0.1%
17430 2
< 0.1%
17240 1
< 0.1%
12680 2
< 0.1%

총이자
Real number (ℝ)

SKEWED  ZEROS 

Distinct116
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-1271.707
Minimum-3986260
Maximum30
Zeros9397
Zeros (%)94.0%
Negative602
Negative (%)6.0%
Memory size166.0 KiB
2024-03-14T17:45:34.852612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-3986260
5-th percentile-20
Q10
median0
Q30
95-th percentile0
Maximum30
Range3986290
Interquartile range (IQR)0

Descriptive statistics

Standard deviation69059.472
Coefficient of variation (CV)-54.304547
Kurtosis3325.4388
Mean-1271.707
Median Absolute Deviation (MAD)0
Skewness-57.659451
Sum-12717070
Variance4.7692107 × 109
MonotonicityNot monotonic
2024-03-14T17:45:35.317125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9397
94.0%
-10 74
 
0.7%
-20 54
 
0.5%
-30 39
 
0.4%
-40 29
 
0.3%
-50 21
 
0.2%
-60 19
 
0.2%
-70 18
 
0.2%
-100 15
 
0.1%
-180 13
 
0.1%
Other values (106) 321
 
3.2%
ValueCountFrequency (%)
-3986260 3
< 0.1%
-119100 2
< 0.1%
-26680 2
< 0.1%
-13570 4
< 0.1%
-12630 3
< 0.1%
-12550 2
< 0.1%
-9500 2
< 0.1%
-8130 4
< 0.1%
-7670 2
< 0.1%
-6940 3
< 0.1%
ValueCountFrequency (%)
30 1
 
< 0.1%
0 9397
94.0%
-10 74
 
0.7%
-20 54
 
0.5%
-30 39
 
0.4%
-40 29
 
0.3%
-50 21
 
0.2%
-60 19
 
0.2%
-70 18
 
0.2%
-80 11
 
0.1%

상수도이자
Real number (ℝ)

SKEWED  ZEROS 

Distinct95
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-1265.723
Minimum-3986260
Maximum20
Zeros9617
Zeros (%)96.2%
Negative382
Negative (%)3.8%
Memory size166.0 KiB
2024-03-14T17:45:35.760343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-3986260
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum20
Range3986280
Interquartile range (IQR)0

Descriptive statistics

Standard deviation69059.529
Coefficient of variation (CV)-54.561329
Kurtosis3325.4478
Mean-1265.723
Median Absolute Deviation (MAD)0
Skewness-57.659568
Sum-12657230
Variance4.7692186 × 109
MonotonicityNot monotonic
2024-03-14T17:45:36.228695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9617
96.2%
-10 39
 
0.4%
-20 25
 
0.2%
-40 22
 
0.2%
-30 21
 
0.2%
-60 14
 
0.1%
-50 11
 
0.1%
-100 10
 
0.1%
-80 10
 
0.1%
-410 9
 
0.1%
Other values (85) 222
 
2.2%
ValueCountFrequency (%)
-3986260 3
< 0.1%
-119100 2
< 0.1%
-26680 2
< 0.1%
-13570 4
< 0.1%
-12630 3
< 0.1%
-12550 2
< 0.1%
-9500 2
< 0.1%
-8130 4
< 0.1%
-7670 2
< 0.1%
-6940 3
< 0.1%
ValueCountFrequency (%)
20 1
 
< 0.1%
0 9617
96.2%
-10 39
 
0.4%
-20 25
 
0.2%
-30 21
 
0.2%
-40 22
 
0.2%
-50 11
 
0.1%
-60 14
 
0.1%
-70 7
 
0.1%
-80 10
 
0.1%

하수도이자
Real number (ℝ)

SKEWED  ZEROS 

Distinct55
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-4.429
Minimum-3220
Maximum10
Zeros9858
Zeros (%)98.6%
Negative141
Negative (%)1.4%
Memory size166.0 KiB
2024-03-14T17:45:36.650566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-3220
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum10
Range3230
Interquartile range (IQR)0

Descriptive statistics

Standard deviation72.524478
Coefficient of variation (CV)-16.37491
Kurtosis870.51903
Mean-4.429
Median Absolute Deviation (MAD)0
Skewness-26.679809
Sum-44290
Variance5259.7999
MonotonicityNot monotonic
2024-03-14T17:45:37.085400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9858
98.6%
-10 18
 
0.2%
-20 13
 
0.1%
-30 8
 
0.1%
-50 7
 
0.1%
-60 7
 
0.1%
-40 5
 
0.1%
-70 5
 
0.1%
-580 5
 
0.1%
-320 4
 
< 0.1%
Other values (45) 70
 
0.7%
ValueCountFrequency (%)
-3220 1
< 0.1%
-2760 1
< 0.1%
-2050 1
< 0.1%
-2010 1
< 0.1%
-1950 1
< 0.1%
-1620 1
< 0.1%
-1380 1
< 0.1%
-1350 1
< 0.1%
-1330 1
< 0.1%
-1310 1
< 0.1%
ValueCountFrequency (%)
10 1
 
< 0.1%
0 9858
98.6%
-10 18
 
0.2%
-20 13
 
0.1%
-30 8
 
0.1%
-40 5
 
0.1%
-50 7
 
0.1%
-60 7
 
0.1%
-70 5
 
0.1%
-80 1
 
< 0.1%

물이용이자
Real number (ℝ)

SKEWED  ZEROS 

Distinct27
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-1.555
Minimum-3180
Maximum0
Zeros9806
Zeros (%)98.1%
Negative194
Negative (%)1.9%
Memory size166.0 KiB
2024-03-14T17:45:37.464981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-3180
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum0
Range3180
Interquartile range (IQR)0

Descriptive statistics

Standard deviation36.405831
Coefficient of variation (CV)-23.41211
Kurtosis5881.8539
Mean-1.555
Median Absolute Deviation (MAD)0
Skewness-70.16833
Sum-15550
Variance1325.3845
MonotonicityNot monotonic
2024-03-14T17:45:37.851836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
0 9806
98.1%
-10 44
 
0.4%
-20 40
 
0.4%
-30 22
 
0.2%
-40 21
 
0.2%
-50 13
 
0.1%
-100 7
 
0.1%
-60 7
 
0.1%
-70 7
 
0.1%
-120 5
 
0.1%
Other values (17) 28
 
0.3%
ValueCountFrequency (%)
-3180 1
< 0.1%
-930 1
< 0.1%
-680 1
< 0.1%
-610 1
< 0.1%
-490 2
< 0.1%
-350 1
< 0.1%
-260 1
< 0.1%
-230 1
< 0.1%
-220 2
< 0.1%
-210 1
< 0.1%
ValueCountFrequency (%)
0 9806
98.1%
-10 44
 
0.4%
-20 40
 
0.4%
-30 22
 
0.2%
-40 21
 
0.2%
-50 13
 
0.1%
-60 7
 
0.1%
-70 7
 
0.1%
-80 4
 
< 0.1%
-100 7
 
0.1%

사용순번
Real number (ℝ)

Distinct14
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0279
Minimum1
Maximum14
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T17:45:38.208705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q32
95-th percentile6
Maximum14
Range13
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.6906825
Coefficient of variation (CV)0.833711
Kurtosis5.9695562
Mean2.0279
Median Absolute Deviation (MAD)0
Skewness2.2890857
Sum20279
Variance2.8584074
MonotonicityNot monotonic
2024-03-14T17:45:38.582509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
1 5655
56.5%
2 2018
 
20.2%
3 898
 
9.0%
4 534
 
5.3%
5 339
 
3.4%
6 208
 
2.1%
7 158
 
1.6%
8 86
 
0.9%
9 53
 
0.5%
10 30
 
0.3%
Other values (4) 21
 
0.2%
ValueCountFrequency (%)
1 5655
56.5%
2 2018
 
20.2%
3 898
 
9.0%
4 534
 
5.3%
5 339
 
3.4%
6 208
 
2.1%
7 158
 
1.6%
8 86
 
0.9%
9 53
 
0.5%
10 30
 
0.3%
ValueCountFrequency (%)
14 1
 
< 0.1%
13 2
 
< 0.1%
12 6
 
0.1%
11 12
 
0.1%
10 30
 
0.3%
9 53
 
0.5%
8 86
 
0.9%
7 158
1.6%
6 208
2.1%
5 339
3.4%

일련번호
Real number (ℝ)

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0033
Minimum1
Maximum8
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T17:45:38.918380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median2
Q33
95-th percentile3
Maximum8
Range7
Interquartile range (IQR)2

Descriptive statistics

Standard deviation0.83364177
Coefficient of variation (CV)0.41613427
Kurtosis2.1177167
Mean2.0033
Median Absolute Deviation (MAD)1
Skewness0.68791319
Sum20033
Variance0.69495861
MonotonicityNot monotonic
2024-03-14T17:45:39.271977image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
2 4010
40.1%
1 3075
30.8%
3 2836
28.4%
6 25
 
0.2%
4 22
 
0.2%
5 17
 
0.2%
7 13
 
0.1%
8 2
 
< 0.1%
ValueCountFrequency (%)
1 3075
30.8%
2 4010
40.1%
3 2836
28.4%
4 22
 
0.2%
5 17
 
0.2%
6 25
 
0.2%
7 13
 
0.1%
8 2
 
< 0.1%
ValueCountFrequency (%)
8 2
 
< 0.1%
7 13
 
0.1%
6 25
 
0.2%
5 17
 
0.2%
4 22
 
0.2%
3 2836
28.4%
2 4010
40.1%
1 3075
30.8%

사용일자
Date

Distinct5073
Distinct (%)50.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-02 11:45:58
Maximum2024-01-02 10:10:31
2024-03-14T17:45:39.647801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T17:45:40.066040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

결의코드
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
급수수입
9171 
과오납반환
 
776
<NA>
 
38
과오납충당
 
15

Length

Max length5
Median length4
Mean length4.0791
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row급수수입
2nd row급수수입
3rd row급수수입
4th row급수수입
5th row급수수입

Common Values

ValueCountFrequency (%)
급수수입 9171
91.7%
과오납반환 776
 
7.8%
<NA> 38
 
0.4%
과오납충당 15
 
0.1%

Length

2024-03-14T17:45:40.483094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T17:45:40.802374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
급수수입 9171
91.7%
과오납반환 776
 
7.8%
na 38
 
0.4%
과오납충당 15
 
0.1%

처리고지번호
Real number (ℝ)

MISSING 

Distinct4909
Distinct (%)53.4%
Missing814
Missing (%)8.1%
Infinite0
Infinite (%)0.0%
Mean2.0230665 × 1013
Minimum2.02112 × 1013
Maximum2.0240109 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T17:45:41.159649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.02112 × 1013
5-th percentile2.023012 × 1013
Q12.023042 × 1013
median2.02308 × 1013
Q32.023102 × 1013
95-th percentile2.023122 × 1013
Maximum2.0240109 × 1013
Range2.8909066 × 1010
Interquartile range (IQR)6.0000296 × 108

Descriptive statistics

Standard deviation1.0168604 × 109
Coefficient of variation (CV)5.0263321 × 10-5
Kurtosis96.596104
Mean2.0230665 × 1013
Median Absolute Deviation (MAD)2.9998062 × 108
Skewness-8.319574
Sum1.8583889 × 1017
Variance1.0340051 × 1018
MonotonicityNot monotonic
2024-03-14T17:45:41.606726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20230520080219 9
 
0.1%
20221220051024 9
 
0.1%
20230120052693 8
 
0.1%
20230900068433 8
 
0.1%
20231200010910 8
 
0.1%
20230320053500 7
 
0.1%
20230520000380 7
 
0.1%
20231120074752 7
 
0.1%
20231000028063 7
 
0.1%
20231000043066 7
 
0.1%
Other values (4899) 9109
91.1%
(Missing) 814
 
8.1%
ValueCountFrequency (%)
20211200056211 2
< 0.1%
20220820081235 2
< 0.1%
20220900059614 2
< 0.1%
20220920015309 1
 
< 0.1%
20221000002411 1
 
< 0.1%
20221000005360 3
< 0.1%
20221000025115 2
< 0.1%
20221100028357 2
< 0.1%
20221100030172 2
< 0.1%
20221100036040 1
 
< 0.1%
ValueCountFrequency (%)
20240109122270 2
< 0.1%
20240109122125 1
< 0.1%
20240109121932 1
< 0.1%
20231220103909 1
< 0.1%
20231220103182 1
< 0.1%
20231220103054 1
< 0.1%
20231220102962 2
< 0.1%
20231220102857 1
< 0.1%
20231220102839 1
< 0.1%
20231220102736 1
< 0.1%

감액고지번호
Real number (ℝ)

MISSING 

Distinct650
Distinct (%)82.2%
Missing9209
Missing (%)92.1%
Infinite0
Infinite (%)0.0%
Mean2.0230797 × 1013
Minimum2.023015 × 1013
Maximum2.023125 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T17:45:42.039566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.023015 × 1013
5-th percentile2.023025 × 1013
Q12.023045 × 1013
median2.023085 × 1013
Q32.023115 × 1013
95-th percentile2.023125 × 1013
Maximum2.023125 × 1013
Range1.1000225 × 109
Interquartile range (IQR)7.000107 × 108

Descriptive statistics

Standard deviation3.4861634 × 108
Coefficient of variation (CV)1.7231963 × 10-5
Kurtosis-1.293219
Mean2.0230797 × 1013
Median Absolute Deviation (MAD)3.0000615 × 108
Skewness-0.28831857
Sum1.600256 × 1016
Variance1.2153335 × 1017
MonotonicityNot monotonic
2024-03-14T17:45:42.487813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20230250294393 6
 
0.1%
20230850305741 5
 
0.1%
20230250295719 5
 
0.1%
20230150294149 5
 
0.1%
20230650302576 4
 
< 0.1%
20230750302685 4
 
< 0.1%
20230550300005 4
 
< 0.1%
20230150293824 4
 
< 0.1%
20230850304958 4
 
< 0.1%
20230550299997 4
 
< 0.1%
Other values (640) 746
 
7.5%
(Missing) 9209
92.1%
ValueCountFrequency (%)
20230150292628 1
< 0.1%
20230150292632 2
< 0.1%
20230150292644 1
< 0.1%
20230150292645 1
< 0.1%
20230150292647 1
< 0.1%
20230150292656 1
< 0.1%
20230150292664 1
< 0.1%
20230150292676 1
< 0.1%
20230150292698 1
< 0.1%
20230150292703 1
< 0.1%
ValueCountFrequency (%)
20231250315110 1
< 0.1%
20231250314980 1
< 0.1%
20231250314976 1
< 0.1%
20231250314952 2
< 0.1%
20231250314604 1
< 0.1%
20231250314603 1
< 0.1%
20231250314595 1
< 0.1%
20231250314591 1
< 0.1%
20231250314588 2
< 0.1%
20231250314587 1
< 0.1%

예산과목
Categorical

IMBALANCE 

Distinct9
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
<NA>
6826 
가정용
1874 
일반용
1191 
기타수수료수익
 
47
개조공사수입
 
30
Other values (4)
 
32

Length

Max length8
Median length4
Mean length3.72
Min length3

Unique

Unique2 ?
Unique (%)< 0.1%

Sample

1st row<NA>
2nd row가정용
3rd row일반용
4th row가정용
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 6826
68.3%
가정용 1874
 
18.7%
일반용 1191
 
11.9%
기타수수료수익 47
 
0.5%
개조공사수입 30
 
0.3%
신설공사수입 28
 
0.3%
기본재산임대수입 2
 
< 0.1%
전용공업용 1
 
< 0.1%
욕탕용 1
 
< 0.1%

Length

2024-03-14T17:45:42.934396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T17:45:43.288949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 6826
68.3%
가정용 1874
 
18.7%
일반용 1191
 
11.9%
기타수수료수익 47
 
0.5%
개조공사수입 30
 
0.3%
신설공사수입 28
 
0.3%
기본재산임대수입 2
 
< 0.1%
전용공업용 1
 
< 0.1%
욕탕용 1
 
< 0.1%

분류코드
Categorical

IMBALANCE 

Distinct31
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
하수도요금
3986 
가정용 사용료
1858 
물이용부담금(가정용)
1612 
물이용부담금(일반용)
1206 
일반용 사용료
1171 
Other values (26)
 
167

Length

Max length17
Median length14
Mean length7.381
Min length4

Unique

Unique7 ?
Unique (%)0.1%

Sample

1st row하수도요금
2nd row가정용 사용료
3rd row일반용 사용료
4th row가정용 사용료
5th row하수도요금

Common Values

ValueCountFrequency (%)
하수도요금 3986
39.9%
가정용 사용료 1858
18.6%
물이용부담금(가정용) 1612
16.1%
물이용부담금(일반용) 1206
 
12.1%
일반용 사용료 1171
 
11.7%
신설수탁급수공사수입 28
 
0.3%
개조수탁급수공사수입 18
 
0.2%
사회복지사용료 15
 
0.1%
물이용부담금(사회복지) 11
 
0.1%
공사방수료(개조) 10
 
0.1%
Other values (21) 85
 
0.9%

Length

2024-03-14T17:45:43.860896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
하수도요금 3986
30.6%
사용료 3032
23.3%
가정용 1858
14.3%
물이용부담금(가정용 1612
12.4%
물이용부담금(일반용 1206
 
9.3%
일반용 1171
 
9.0%
신설수탁급수공사수입 28
 
0.2%
개조수탁급수공사수입 18
 
0.1%
사회복지사용료 15
 
0.1%
물이용부담금(사회복지 11
 
0.1%
Other values (22) 95
 
0.7%

고지금액(정산_충당_환불)
Real number (ℝ)

SKEWED 

Distinct2923
Distinct (%)29.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-30214.426
Minimum-8910000
Maximum1745830
Zeros76
Zeros (%)0.8%
Negative9857
Negative (%)98.6%
Memory size166.0 KiB
2024-03-14T17:45:44.116133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-8910000
5-th percentile-88403.5
Q1-14500
median-5340
Q3-1800
95-th percentile-310
Maximum1745830
Range10655830
Interquartile range (IQR)12700

Descriptive statistics

Standard deviation199962.38
Coefficient of variation (CV)-6.6181094
Kurtosis838.57604
Mean-30214.426
Median Absolute Deviation (MAD)4260
Skewness-24.705487
Sum-3.0214426 × 108
Variance3.9984953 × 1010
MonotonicityNot monotonic
2024-03-14T17:45:44.567890image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-1200 205
 
2.1%
-3600 77
 
0.8%
0 76
 
0.8%
-900 65
 
0.7%
-1800 59
 
0.6%
-220 57
 
0.6%
-450 56
 
0.6%
-2700 55
 
0.5%
-4500 51
 
0.5%
-2250 49
 
0.5%
Other values (2913) 9250
92.5%
ValueCountFrequency (%)
-8910000 1
< 0.1%
-7469000 1
< 0.1%
-6297840 1
< 0.1%
-6246000 1
< 0.1%
-4017600 1
< 0.1%
-3906840 1
< 0.1%
-3659000 1
< 0.1%
-3181560 1
< 0.1%
-3080000 1
< 0.1%
-2925370 1
< 0.1%
ValueCountFrequency (%)
1745830 1
< 0.1%
1159380 1
< 0.1%
411820 1
< 0.1%
328710 1
< 0.1%
207460 1
< 0.1%
200340 1
< 0.1%
175940 1
< 0.1%
162920 1
< 0.1%
150000 1
< 0.1%
145720 1
< 0.1%

가산금(정산_충당_환불)
Real number (ℝ)

SKEWED  ZEROS 

Distinct16
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-5.491
Minimum-24800
Maximum0
Zeros9985
Zeros (%)99.9%
Negative15
Negative (%)0.1%
Memory size166.0 KiB
2024-03-14T17:45:44.941597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-24800
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum0
Range24800
Interquartile range (IQR)0

Descriptive statistics

Standard deviation277.49713
Coefficient of variation (CV)-50.536721
Kurtosis6521.0863
Mean-5.491
Median Absolute Deviation (MAD)0
Skewness-76.503698
Sum-54910
Variance77004.659
MonotonicityNot monotonic
2024-03-14T17:45:45.314138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%)
0 9985
99.9%
-1510 1
 
< 0.1%
-400 1
 
< 0.1%
-320 1
 
< 0.1%
-3300 1
 
< 0.1%
-370 1
 
< 0.1%
-420 1
 
< 0.1%
-7040 1
 
< 0.1%
-2660 1
 
< 0.1%
-8810 1
 
< 0.1%
Other values (6) 6
 
0.1%
ValueCountFrequency (%)
-24800 1
< 0.1%
-8810 1
< 0.1%
-7040 1
< 0.1%
-3300 1
< 0.1%
-2660 1
< 0.1%
-1980 1
< 0.1%
-1510 1
< 0.1%
-1260 1
< 0.1%
-1100 1
< 0.1%
-660 1
< 0.1%
ValueCountFrequency (%)
0 9985
99.9%
-280 1
 
< 0.1%
-320 1
 
< 0.1%
-370 1
 
< 0.1%
-400 1
 
< 0.1%
-420 1
 
< 0.1%
-660 1
 
< 0.1%
-1100 1
 
< 0.1%
-1260 1
 
< 0.1%
-1510 1
 
< 0.1%

이자
Real number (ℝ)

SKEWED  ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-17.642
Minimum-26680
Maximum6000
Zeros9581
Zeros (%)95.8%
Negative415
Negative (%)4.2%
Memory size166.0 KiB
2024-03-14T17:45:45.686560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-26680
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum6000
Range32680
Interquartile range (IQR)0

Descriptive statistics

Standard deviation358.46415
Coefficient of variation (CV)-20.318793
Kurtosis3272.074
Mean-17.642
Median Absolute Deviation (MAD)0
Skewness-48.04315
Sum-176420
Variance128496.55
MonotonicityNot monotonic
2024-03-14T17:45:46.127427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9581
95.8%
-10 72
 
0.7%
-20 47
 
0.5%
-30 35
 
0.4%
-40 22
 
0.2%
-50 18
 
0.2%
-1200 16
 
0.2%
-60 14
 
0.1%
-70 12
 
0.1%
-80 11
 
0.1%
Other values (91) 172
 
1.7%
ValueCountFrequency (%)
-26680 1
< 0.1%
-12630 1
< 0.1%
-6940 1
< 0.1%
-6730 1
< 0.1%
-5000 1
< 0.1%
-4890 1
< 0.1%
-4790 1
< 0.1%
-4750 1
< 0.1%
-4550 1
< 0.1%
-4540 1
< 0.1%
ValueCountFrequency (%)
6000 1
 
< 0.1%
4800 1
 
< 0.1%
1340 1
 
< 0.1%
1200 1
 
< 0.1%
0 9581
95.8%
-10 72
 
0.7%
-20 47
 
0.5%
-30 35
 
0.4%
-40 22
 
0.2%
-50 18
 
0.2%

총사용금액
Real number (ℝ)

SKEWED 

Distinct2962
Distinct (%)29.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-30237.559
Minimum-8910000
Maximum1745830
Zeros59
Zeros (%)0.6%
Negative9874
Negative (%)98.7%
Memory size166.0 KiB
2024-03-14T17:45:46.584707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-8910000
5-th percentile-88403.5
Q1-14500
median-5340
Q3-1800
95-th percentile-320
Maximum1745830
Range10655830
Interquartile range (IQR)12700

Descriptive statistics

Standard deviation200140.1
Coefficient of variation (CV)-6.6189238
Kurtosis838.53732
Mean-30237.559
Median Absolute Deviation (MAD)4240
Skewness-24.706011
Sum-3.0237559 × 108
Variance4.005606 × 1010
MonotonicityNot monotonic
2024-03-14T17:45:47.040266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-1200 222
 
2.2%
-3600 77
 
0.8%
-900 65
 
0.7%
0 59
 
0.6%
-1800 59
 
0.6%
-220 57
 
0.6%
-450 56
 
0.6%
-2700 54
 
0.5%
-4500 51
 
0.5%
-2250 49
 
0.5%
Other values (2952) 9251
92.5%
ValueCountFrequency (%)
-8910000 1
< 0.1%
-7495680 1
< 0.1%
-6297840 1
< 0.1%
-6246000 1
< 0.1%
-4017600 1
< 0.1%
-3911590 1
< 0.1%
-3665730 1
< 0.1%
-3181560 1
< 0.1%
-3080000 1
< 0.1%
-2927000 1
< 0.1%
ValueCountFrequency (%)
1745830 1
< 0.1%
1159380 1
< 0.1%
411820 1
< 0.1%
328710 1
< 0.1%
207460 1
< 0.1%
200340 1
< 0.1%
175940 1
< 0.1%
162920 1
< 0.1%
150000 1
< 0.1%
145720 1
< 0.1%

사업소명
Categorical

Distinct13
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
동래통합사업소
2598 
북부사업소
1219 
부산진 사업소
993 
남부사업소
951 
사하사업소
878 
Other values (8)
3361 

Length

Max length9
Median length8
Mean length6.1184
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
동래통합사업소 2598
26.0%
북부사업소 1219
12.2%
부산진 사업소 993
 
9.9%
남부사업소 951
 
9.5%
사하사업소 878
 
8.8%
강서사업소 770
 
7.7%
해운대사업소 670
 
6.7%
중동부사업소 649
 
6.5%
영도사업소 491
 
4.9%
서부 사업소 418
 
4.2%
Other values (3) 363
 
3.6%

Length

2024-03-14T17:45:47.486979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
동래통합사업소 2598
22.8%
사업소 1411
12.4%
북부사업소 1219
10.7%
부산진 993
 
8.7%
남부사업소 951
 
8.3%
사하사업소 878
 
7.7%
강서사업소 770
 
6.7%
해운대사업소 670
 
5.9%
중동부사업소 649
 
5.7%
영도사업소 491
 
4.3%
Other values (4) 781
 
6.8%

결의일자
Date

MISSING 

Distinct177
Distinct (%)22.4%
Missing9209
Missing (%)92.1%
Memory size156.2 KiB
Minimum2023-01-04 00:00:00
Maximum2023-12-29 00:00:00
2024-03-14T17:45:47.870040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T17:45:48.289281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

결의번호
Real number (ℝ)

MISSING 

Distinct710
Distinct (%)90.6%
Missing9216
Missing (%)92.2%
Infinite0
Infinite (%)0.0%
Mean2.9148694 × 1013
Minimum2.0112023 × 1013
Maximum3.1232023 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T17:45:48.726957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0112023 × 1013
5-th percentile2.4412023 × 1013
Q13.0112023 × 1013
median3.0427023 × 1013
Q33.0732023 × 1013
95-th percentile3.1132023 × 1013
Maximum3.1232023 × 1013
Range1.112 × 1013
Interquartile range (IQR)6.2000002 × 1011

Descriptive statistics

Standard deviation2.7507276 × 1012
Coefficient of variation (CV)0.09436881
Kurtosis0.19113492
Mean2.9148694 × 1013
Median Absolute Deviation (MAD)3.0500004 × 1011
Skewness-1.3477157
Sum2.2852576 × 1016
Variance7.5665022 × 1024
MonotonicityNot monotonic
2024-03-14T17:45:49.178400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
24412023020565 5
 
0.1%
24412023082056 5
 
0.1%
24412023012382 4
 
< 0.1%
24412023081078 4
 
< 0.1%
24412023011865 4
 
< 0.1%
24412023090396 4
 
< 0.1%
31112023050282 4
 
< 0.1%
31112023070033 4
 
< 0.1%
24412023022379 4
 
< 0.1%
20112023060022 4
 
< 0.1%
Other values (700) 742
 
7.4%
(Missing) 9216
92.2%
ValueCountFrequency (%)
20112023060022 4
< 0.1%
20112023120043 2
< 0.1%
20412023050001 1
 
< 0.1%
20412023110001 1
 
< 0.1%
24412023010243 1
 
< 0.1%
24412023011749 1
 
< 0.1%
24412023011865 4
< 0.1%
24412023012382 4
< 0.1%
24412023020090 1
 
< 0.1%
24412023020320 1
 
< 0.1%
ValueCountFrequency (%)
31232023120047 1
< 0.1%
31232023110312 1
< 0.1%
31232023110308 1
< 0.1%
31232023110291 1
< 0.1%
31232023110285 1
< 0.1%
31232023110277 1
< 0.1%
31232023110273 1
< 0.1%
31232023110271 1
< 0.1%
31232023110267 1
< 0.1%
31232023110250 1
< 0.1%

결재처리문서ID
Text

MISSING 

Distinct472
Distinct (%)77.6%
Missing9392
Missing (%)93.9%
Memory size156.2 KiB
2024-03-14T17:45:50.070886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length20
Mean length20
Min length20

Characters and Unicode

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

Unique

Unique376 ?
Unique (%)61.8%

Sample

1st rowRECV_311_20230500488
2nd rowRECV_303_20231100612
3rd rowRECV_307_20231100883
4th rowRECV_244_20230802775
5th rowRECV_244_20231002816
ValueCountFrequency (%)
recv_244_20230202570 6
 
1.0%
recv_244_20230802775 5
 
0.8%
recv_244_20230202576 5
 
0.8%
recv_244_20230102555 5
 
0.8%
recv_311_20230500478 4
 
0.7%
recv_311_20230700494 4
 
0.7%
recv_244_20230102554 4
 
0.7%
recv_201_20230600046 4
 
0.7%
recv_311_20230500472 4
 
0.7%
recv_244_20230902788 4
 
0.7%
Other values (462) 563
92.6%
2024-03-14T17:45:51.354813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 2420
19.9%
2 1813
14.9%
3 1318
10.8%
_ 1216
10.0%
1 961
 
7.9%
R 608
 
5.0%
E 608
 
5.0%
C 608
 
5.0%
V 608
 
5.0%
4 578
 
4.8%
Other values (5) 1422
11.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 8512
70.0%
Uppercase Letter 2432
 
20.0%
Connector Punctuation 1216
 
10.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 2420
28.4%
2 1813
21.3%
3 1318
15.5%
1 961
 
11.3%
4 578
 
6.8%
6 349
 
4.1%
7 305
 
3.6%
5 288
 
3.4%
8 281
 
3.3%
9 199
 
2.3%
Uppercase Letter
ValueCountFrequency (%)
R 608
25.0%
E 608
25.0%
C 608
25.0%
V 608
25.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1216
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 9728
80.0%
Latin 2432
 
20.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 2420
24.9%
2 1813
18.6%
3 1318
13.5%
_ 1216
12.5%
1 961
 
9.9%
4 578
 
5.9%
6 349
 
3.6%
7 305
 
3.1%
5 288
 
3.0%
8 281
 
2.9%
Latin
ValueCountFrequency (%)
R 608
25.0%
E 608
25.0%
C 608
25.0%
V 608
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 12160
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 2420
19.9%
2 1813
14.9%
3 1318
10.8%
_ 1216
10.0%
1 961
 
7.9%
R 608
 
5.0%
E 608
 
5.0%
C 608
 
5.0%
V 608
 
5.0%
4 578
 
4.8%
Other values (5) 1422
11.7%

Sample

연번고지년월과오납코드통지일자과오납총금액상수도과오금액하수도과오금액물이용과오금액총이자상수도이자하수도이자물이용이자사용순번일련번호사용일자결의코드처리고지번호감액고지번호예산과목분류코드고지금액(정산_충당_환불)가산금(정산_충당_환불)이자총사용금액사업소명결의일자결의번호결재처리문서ID
21081210822023-07옥내누수감면<NA>-230140-61660-161050-74300000122023-12-06 13:23:01급수수입20231100074268<NA><NA>하수도요금-7258000-72580동래통합사업소<NA><NA><NA>
18426184272023-02수조정정산<NA>-108450-56480-42840-91300000712023-10-13 10:16:27급수수입20231020082729<NA>가정용가정용 사용료-140000-1400동래통합사업소<NA><NA><NA>
21466214672023-09옥내누수감면<NA>-12560-4380-7580-6000000112023-11-14 16:51:20급수수입20231100032778<NA>일반용일반용 사용료-438000-4380동래통합사업소<NA><NA><NA>
15307153082023-05이중수납<NA>-68440-37840-23220-73800000112023-07-14 10:01:00급수수입20230720005924<NA>가정용가정용 사용료-1488000-14880서부 사업소<NA><NA><NA>
461346142022-12옥내누수감면<NA>-27180-10140-15080-19600000122023-02-22 15:14:00급수수입20230200007812<NA><NA>하수도요금-1016000-10160중동부사업소<NA><NA><NA>
15757157582023-02옥내누수감면<NA>-88340-34900-47440-60000000132023-06-29 16:37:40급수수입20230600040824<NA><NA>물이용부담금(가정용)-600000-6000북부사업소<NA><NA><NA>
313631372022-08옥내누수감면<NA>-11460-4260-6380-8200000222023-02-15 12:50:34급수수입20230200076088<NA><NA>하수도요금-188000-1880동래통합사업소<NA><NA><NA>
975497552023-05옥내누수감면<NA>-48460-11980-35100-13800000122023-07-21 15:00:46급수수입20230700017890<NA><NA>하수도요금-3510000-35100부산진 사업소<NA><NA><NA>
29200292012023-07옥내누수감면<NA>-216920-70900-137140-88800000132023-11-14 09:53:23급수수입20231100060013<NA><NA>물이용부담금(일반용)-554000-5540사하사업소<NA><NA><NA>
187318742023-01옥내누수감면<NA>-39340-24000-12320-30200000212023-03-14 11:32:49급수수입20230300091684<NA>일반용일반용 사용료-570000-5700기장사업소<NA><NA><NA>
연번고지년월과오납코드통지일자과오납총금액상수도과오금액하수도과오금액물이용과오금액총이자상수도이자하수도이자물이용이자사용순번일련번호사용일자결의코드처리고지번호감액고지번호예산과목분류코드고지금액(정산_충당_환불)가산금(정산_충당_환불)이자총사용금액사업소명결의일자결의번호결재처리문서ID
397039712022-12옥내누수감면<NA>-133000-60480-65280-72400000122023-02-14 18:35:14급수수입20230200085194<NA><NA>하수도요금-4080000-40800북부사업소<NA><NA><NA>
649864992022-11이중수납<NA>-86800-47520-30180-91000000412023-03-14 11:32:29급수수입20230300091636<NA>일반용일반용 사용료-1044000-10440기장사업소<NA><NA><NA>
19547195482023-02옥내누수감면<NA>-142530-54520-78720-92900000212023-04-21 10:58:06급수수입20230420083531<NA>가정용가정용 사용료-1411000-14110동래통합사업소<NA><NA><NA>
195919602022-11옥내누수감면<NA>-21160-8560-10800-18000000132023-01-16 09:38:12급수수입20230120050345<NA><NA>물이용부담금(가정용)-180000-1800북부사업소<NA><NA><NA>
371337142023-01옥내누수감면<NA>-15900-6720-8120-10600000112023-03-14 11:32:49급수수입20230300091678<NA>일반용일반용 사용료-624000-6240기장사업소<NA><NA><NA>
152215232022-12옥내누수감면<NA>-28960-10140-17380-14400000522023-06-14 09:54:11급수수입20230600030080<NA><NA>하수도요금-188000-1880동래통합사업소<NA><NA><NA>
23764237652023-09과대수납<NA>-95900-52880-33860-91600000132023-11-14 09:52:42급수수입20231120056144<NA><NA>물이용부담금(가정용)-68000-680해운대사업소<NA><NA><NA>
11343113442023-01옥내누수감면<NA>-46540-18460-24840-32400000422023-07-14 10:04:22급수수입20230700060752<NA><NA>하수도요금-132000-1320사하사업소<NA><NA><NA>
21027210282023-09옥내누수감면<NA>-60860-20780-37440-26400000222023-11-21 14:28:50급수수입20231120058705<NA><NA>하수도요금-740000-7400사하사업소<NA><NA><NA>
21151211522023-10옥내누수감면2023-11-20-588400-588400-400-400122023-11-21 10:05:33과오납반환<NA>20231150312486<NA>하수도요금-588400-40-58880동래통합사업소2023-11-2124422023112444<NA>