Overview

Dataset statistics

Number of variables34
Number of observations10000
Missing cells1219
Missing cells (%)0.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.9 MiB
Average record size in memory300.0 B

Variable types

DateTime5
Categorical18
Numeric9
Unsupported2

Dataset

Description전북특별자치도 진안군 상하수도요금관리시스템 수납정보에 대한 데이터입니다. 상수도금액, 하수도금액, 납기내일자 등에 대한 정보를 제공합니다.
Author전북특별자치도 진안군
URLhttps://www.data.go.kr/data/15070415/fileData.do

Alerts

고지종류 has constant value ""Constant
고지종류명 has constant value ""Constant
오류코드 has constant value ""Constant
오류코드명 has constant value ""Constant
지하수납기내금액 has constant value ""Constant
물부담금납기내금액 has constant value ""Constant
지하수납기후금액 has constant value ""Constant
물부담금납기후금액 has constant value ""Constant
지하수수납액 has constant value ""Constant
물부담금수납액 has constant value ""Constant
소인상태코드 has constant value ""Constant
소인상태코드명 has constant value ""Constant
수납시점코드 is highly imbalanced (54.8%)Imbalance
수납시점코드명 is highly imbalanced (54.8%)Imbalance
이체코드명 is highly imbalanced (53.8%)Imbalance
수납종류코드명 is highly imbalanced (53.8%)Imbalance
수납은행코드명 is highly imbalanced (52.5%)Imbalance
묶은번호 is highly imbalanced (50.5%)Imbalance
묶음일련번호 has 1219 (12.2%) missing valuesMissing
상수도납기내금액 is highly skewed (γ1 = 31.81986393)Skewed
하수도납기내금액 is highly skewed (γ1 = 32.69987893)Skewed
상수도납기후금액 is highly skewed (γ1 = 31.82088863)Skewed
하수도납기후금액 is highly skewed (γ1 = 32.70093672)Skewed
상수도수납액 is highly skewed (γ1 = 31.78658039)Skewed
하수도수납액 is highly skewed (γ1 = 32.68683832)Skewed
이체코드 is an unsupported type, check if it needs cleaning or further analysisUnsupported
수납종류코드 is an unsupported type, check if it needs cleaning or further analysisUnsupported
하수도납기내금액 has 4492 (44.9%) zerosZeros
하수도납기후금액 has 4492 (44.9%) zerosZeros
하수도수납액 has 4492 (44.9%) zerosZeros
묶음일련번호 has 7762 (77.6%) zerosZeros

Reproduction

Analysis started2024-03-14 21:07:13.755178
Analysis finished2024-03-14 21:07:15.044042
Duration1.29 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

접수일자
Date

Distinct110
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-01 00:00:00
Maximum2023-05-08 00:00:00
2024-03-15T06:07:15.313858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:07:15.825854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

고지종류
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
11
10000 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
11 10000
100.0%

Length

2024-03-15T06:07:16.305565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:16.628808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
11 10000
100.0%

고지종류명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
정기
10000 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row정기
2nd row정기
3rd row정기
4th row정기
5th row정기

Common Values

ValueCountFrequency (%)
정기 10000
100.0%

Length

2024-03-15T06:07:16.949291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:17.244298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정기 10000
100.0%

납기마감일
Date

Distinct66
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2016-03-31 00:00:00
Maximum2023-04-30 00:00:00
2024-03-15T06:07:17.565949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:07:17.996972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수용가번호
Real number (ℝ)

Distinct6815
Distinct (%)68.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.0618931 × 109
Minimum1.0010001 × 109
Maximum1.1070067 × 1010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T06:07:18.410120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.0010001 × 109
5-th percentile1.0070097 × 109
Q11.0660014 × 109
median5.0040029 × 109
Q38.004183 × 109
95-th percentile1.1002023 × 1010
Maximum1.1070067 × 1010
Range1.0069067 × 1010
Interquartile range (IQR)6.9381816 × 109

Descriptive statistics

Standard deviation3.544574 × 109
Coefficient of variation (CV)0.70024671
Kurtosis-1.4106474
Mean5.0618931 × 109
Median Absolute Deviation (MAD)3.9359924 × 109
Skewness0.20790929
Sum5.0618931 × 1013
Variance1.2564005 × 1019
MonotonicityNot monotonic
2024-03-15T06:07:18.797348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1068008300 15
 
0.1%
1054005200 14
 
0.1%
1054006700 13
 
0.1%
1067000400 12
 
0.1%
4013000110 12
 
0.1%
1071001600 11
 
0.1%
11002022100 11
 
0.1%
1007022000 11
 
0.1%
1007024200 9
 
0.1%
7028001800 8
 
0.1%
Other values (6805) 9884
98.8%
ValueCountFrequency (%)
1001000101 1
 
< 0.1%
1001000103 3
< 0.1%
1001000104 1
 
< 0.1%
1001000200 1
 
< 0.1%
1001000301 1
 
< 0.1%
1001000303 2
< 0.1%
1001000400 1
 
< 0.1%
1001000401 1
 
< 0.1%
1001000500 2
< 0.1%
1001000510 1
 
< 0.1%
ValueCountFrequency (%)
11070067000 1
< 0.1%
11015023500 2
< 0.1%
11015023400 1
< 0.1%
11015023200 1
< 0.1%
11015023120 1
< 0.1%
11015023110 1
< 0.1%
11015023100 2
< 0.1%
11015022900 1
< 0.1%
11015022700 1
< 0.1%
11015022600 2
< 0.1%

수납시점코드
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1
9052 
2
948 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 9052
90.5%
2 948
 
9.5%

Length

2024-03-15T06:07:19.205493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:19.504380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 9052
90.5%
2 948
 
9.5%

수납시점코드명
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
납기내
9052 
납기후
948 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row납기내
2nd row납기내
3rd row납기내
4th row납기내
5th row납기내

Common Values

ValueCountFrequency (%)
납기내 9052
90.5%
납기후 948
 
9.5%

Length

2024-03-15T06:07:19.846843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:20.183540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
납기내 9052
90.5%
납기후 948
 
9.5%

수납일자
Date

Distinct119
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-11-30 00:00:00
Maximum2023-05-03 00:00:00
2024-03-15T06:07:20.627168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:07:21.260567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

오류코드
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 10000
100.0%

Length

2024-03-15T06:07:21.682682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:22.377743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

오류코드명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
오류없음
10000 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row오류없음
2nd row오류없음
3rd row오류없음
4th row오류없음
5th row오류없음

Common Values

ValueCountFrequency (%)
오류없음 10000
100.0%

Length

2024-03-15T06:07:22.911560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:23.256662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
오류없음 10000
100.0%

상수도납기내금액
Real number (ℝ)

SKEWED 

Distinct1129
Distinct (%)11.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12988.318
Minimum350
Maximum4698790
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T06:07:23.573786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum350
5-th percentile1000
Q11000
median4390
Q38910
95-th percentile33130
Maximum4698790
Range4698440
Interquartile range (IQR)7910

Descriptive statistics

Standard deviation85218.998
Coefficient of variation (CV)6.5612036
Kurtosis1348.4627
Mean12988.318
Median Absolute Deviation (MAD)3390
Skewness31.819864
Sum1.2988318 × 108
Variance7.2622777 × 109
MonotonicityNot monotonic
2024-03-15T06:07:24.130621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1000 2548
25.5%
1570 344
 
3.4%
3830 269
 
2.7%
3260 266
 
2.7%
4390 263
 
2.6%
2700 262
 
2.6%
2130 259
 
2.6%
4960 256
 
2.6%
6650 250
 
2.5%
6080 231
 
2.3%
Other values (1119) 5052
50.5%
ValueCountFrequency (%)
350 1
 
< 0.1%
820 1
 
< 0.1%
880 2
 
< 0.1%
940 1
 
< 0.1%
960 2
 
< 0.1%
970 1
 
< 0.1%
980 23
 
0.2%
990 56
 
0.6%
1000 2548
25.5%
1020 8
 
0.1%
ValueCountFrequency (%)
4698790 1
< 0.1%
3216260 1
< 0.1%
2742900 1
< 0.1%
2530150 1
< 0.1%
1598100 1
< 0.1%
1556500 1
< 0.1%
1310920 1
< 0.1%
1297280 1
< 0.1%
1228750 1
< 0.1%
1091400 1
< 0.1%

하수도납기내금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct428
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2029.135
Minimum0
Maximum863940
Zeros4492
Zeros (%)44.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T06:07:24.795251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median260
Q31430
95-th percentile5140
Maximum863940
Range863940
Interquartile range (IQR)1430

Descriptive statistics

Standard deviation17171.483
Coefficient of variation (CV)8.4624647
Kurtosis1284.1404
Mean2029.135
Median Absolute Deviation (MAD)260
Skewness32.699879
Sum20291350
Variance2.9485984 × 108
MonotonicityNot monotonic
2024-03-15T06:07:25.238511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4492
44.9%
1100 259
 
2.6%
660 241
 
2.4%
440 236
 
2.4%
770 234
 
2.3%
110 233
 
2.3%
550 233
 
2.3%
220 227
 
2.3%
990 227
 
2.3%
330 213
 
2.1%
Other values (418) 3405
34.1%
ValueCountFrequency (%)
0 4492
44.9%
110 233
 
2.3%
130 36
 
0.4%
220 227
 
2.3%
260 53
 
0.5%
310 1
 
< 0.1%
330 213
 
2.1%
390 30
 
0.3%
440 236
 
2.4%
520 37
 
0.4%
ValueCountFrequency (%)
863940 1
< 0.1%
693390 1
< 0.1%
572240 1
< 0.1%
532840 1
< 0.1%
522720 1
< 0.1%
508160 1
< 0.1%
258540 1
< 0.1%
192600 1
< 0.1%
187980 1
< 0.1%
184250 1
< 0.1%

지하수납기내금액
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 10000
100.0%

Length

2024-03-15T06:07:25.737033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:26.100253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

물부담금납기내금액
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 10000
100.0%

Length

2024-03-15T06:07:26.441557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:26.735973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

상수도납기후금액
Real number (ℝ)

SKEWED 

Distinct1156
Distinct (%)11.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13244.77
Minimum350
Maximum4792760
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T06:07:27.075259image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum350
5-th percentile1020
Q11020
median4470
Q39080
95-th percentile33790
Maximum4792760
Range4792410
Interquartile range (IQR)8060

Descriptive statistics

Standard deviation86922.33
Coefficient of variation (CV)6.5627663
Kurtosis1348.5251
Mean13244.77
Median Absolute Deviation (MAD)3450
Skewness31.820889
Sum1.324477 × 108
Variance7.5554914 × 109
MonotonicityNot monotonic
2024-03-15T06:07:27.394908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1020 2550
25.5%
1600 345
 
3.5%
2750 260
 
2.6%
2170 259
 
2.6%
6780 250
 
2.5%
5050 248
 
2.5%
6200 230
 
2.3%
5630 229
 
2.3%
3320 225
 
2.2%
4470 220
 
2.2%
Other values (1146) 5184
51.8%
ValueCountFrequency (%)
350 1
 
< 0.1%
840 1
 
< 0.1%
890 2
 
< 0.1%
960 1
 
< 0.1%
970 1
 
< 0.1%
980 1
 
< 0.1%
990 1
 
< 0.1%
1000 29
 
0.3%
1010 56
 
0.6%
1020 2550
25.5%
ValueCountFrequency (%)
4792760 1
< 0.1%
3280580 1
< 0.1%
2797760 1
< 0.1%
2580750 1
< 0.1%
1630050 1
< 0.1%
1587620 1
< 0.1%
1337130 1
< 0.1%
1323210 1
< 0.1%
1253320 1
< 0.1%
1113220 1
< 0.1%

하수도납기후금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct429
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2066.975
Minimum0
Maximum881210
Zeros4492
Zeros (%)44.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T06:07:27.822582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median260
Q31450
95-th percentile5240
Maximum881210
Range881210
Interquartile range (IQR)1450

Descriptive statistics

Standard deviation17514.618
Coefficient of variation (CV)8.4735508
Kurtosis1284.1959
Mean2066.975
Median Absolute Deviation (MAD)260
Skewness32.700937
Sum20669750
Variance3.0676183 × 108
MonotonicityNot monotonic
2024-03-15T06:07:28.167572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4492
44.9%
1120 259
 
2.6%
670 240
 
2.4%
440 236
 
2.4%
780 234
 
2.3%
110 233
 
2.3%
560 233
 
2.3%
220 227
 
2.3%
1000 227
 
2.3%
330 213
 
2.1%
Other values (419) 3406
34.1%
ValueCountFrequency (%)
0 4492
44.9%
110 233
 
2.3%
130 36
 
0.4%
220 227
 
2.3%
260 53
 
0.5%
310 1
 
< 0.1%
330 213
 
2.1%
390 30
 
0.3%
440 236
 
2.4%
530 37
 
0.4%
ValueCountFrequency (%)
881210 1
< 0.1%
707250 1
< 0.1%
583680 1
< 0.1%
543490 1
< 0.1%
533170 1
< 0.1%
518320 1
< 0.1%
263710 1
< 0.1%
196450 1
< 0.1%
191730 1
< 0.1%
187930 1
< 0.1%

지하수납기후금액
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 10000
100.0%

Length

2024-03-15T06:07:28.400977image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:28.560825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

물부담금납기후금액
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 10000
100.0%

Length

2024-03-15T06:07:28.724043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:28.883897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

상수도수납액
Real number (ℝ)

SKEWED 

Distinct1256
Distinct (%)12.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13008.209
Minimum350
Maximum4698790
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T06:07:29.181579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum350
5-th percentile1000
Q11020
median4390
Q38910
95-th percentile33152.5
Maximum4698790
Range4698440
Interquartile range (IQR)7890

Descriptive statistics

Standard deviation85259.692
Coefficient of variation (CV)6.5542991
Kurtosis1346.0527
Mean13008.209
Median Absolute Deviation (MAD)3390
Skewness31.78658
Sum1.3008209 × 108
Variance7.2692151 × 109
MonotonicityNot monotonic
2024-03-15T06:07:29.628073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1000 2240
22.4%
1020 324
 
3.2%
1570 316
 
3.2%
4390 260
 
2.6%
3260 260
 
2.6%
3830 259
 
2.6%
2700 257
 
2.6%
2130 256
 
2.6%
4960 253
 
2.5%
6650 245
 
2.5%
Other values (1246) 5330
53.3%
ValueCountFrequency (%)
350 1
 
< 0.1%
840 1
 
< 0.1%
890 2
 
< 0.1%
960 2
 
< 0.1%
980 16
 
0.2%
990 38
 
0.4%
1000 2240
22.4%
1010 19
 
0.2%
1020 324
 
3.2%
1280 2
 
< 0.1%
ValueCountFrequency (%)
4698790 1
< 0.1%
3216260 1
< 0.1%
2742900 1
< 0.1%
2530150 1
< 0.1%
1598100 1
< 0.1%
1556500 1
< 0.1%
1310920 1
< 0.1%
1297280 1
< 0.1%
1228750 1
< 0.1%
1091400 1
< 0.1%

하수도수납액
Real number (ℝ)

SKEWED  ZEROS 

Distinct501
Distinct (%)5.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2031.937
Minimum0
Maximum863940
Zeros4492
Zeros (%)44.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T06:07:30.037117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median260
Q31430
95-th percentile5140
Maximum863940
Range863940
Interquartile range (IQR)1430

Descriptive statistics

Standard deviation17173.833
Coefficient of variation (CV)8.4519513
Kurtosis1283.418
Mean2031.937
Median Absolute Deviation (MAD)260
Skewness32.686838
Sum20319370
Variance2.9494052 × 108
MonotonicityNot monotonic
2024-03-15T06:07:30.365080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4492
44.9%
1100 244
 
2.4%
660 240
 
2.4%
440 236
 
2.4%
110 233
 
2.3%
220 227
 
2.3%
770 225
 
2.2%
330 213
 
2.1%
550 213
 
2.1%
990 208
 
2.1%
Other values (491) 3469
34.7%
ValueCountFrequency (%)
0 4492
44.9%
110 233
 
2.3%
130 36
 
0.4%
220 227
 
2.3%
260 53
 
0.5%
310 1
 
< 0.1%
330 213
 
2.1%
390 30
 
0.3%
440 236
 
2.4%
520 35
 
0.4%
ValueCountFrequency (%)
863940 1
< 0.1%
693390 1
< 0.1%
572240 1
< 0.1%
532840 1
< 0.1%
522720 1
< 0.1%
508160 1
< 0.1%
258540 1
< 0.1%
192600 1
< 0.1%
187980 1
< 0.1%
184250 1
< 0.1%

지하수수납액
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 10000
100.0%

Length

2024-03-15T06:07:30.765209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:31.056078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

물부담금수납액
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 10000
100.0%

Length

2024-03-15T06:07:31.368131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:31.666528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

이체코드
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size156.2 KiB

이체코드명
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
자동납부
7762 
인터넷
1191 
계좌이체
862 
OCR
 
157
위텍스
 
28

Length

Max length4
Median length4
Mean length3.8624
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row자동납부
2nd row자동납부
3rd row자동납부
4th row자동납부
5th row자동납부

Common Values

ValueCountFrequency (%)
자동납부 7762
77.6%
인터넷 1191
 
11.9%
계좌이체 862
 
8.6%
OCR 157
 
1.6%
위텍스 28
 
0.3%

Length

2024-03-15T06:07:31.984596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:32.261245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자동납부 7762
77.6%
인터넷 1191
 
11.9%
계좌이체 862
 
8.6%
ocr 157
 
1.6%
위텍스 28
 
0.3%

수납종류코드
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size156.2 KiB

수납종류코드명
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
자동납부
7762 
인터넷
1191 
계좌이체
862 
OCR
 
157
위텍스
 
28

Length

Max length4
Median length4
Mean length3.8624
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row자동납부
2nd row자동납부
3rd row자동납부
4th row자동납부
5th row자동납부

Common Values

ValueCountFrequency (%)
자동납부 7762
77.6%
인터넷 1191
 
11.9%
계좌이체 862
 
8.6%
OCR 157
 
1.6%
위텍스 28
 
0.3%

Length

2024-03-15T06:07:32.636594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:32.993011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자동납부 7762
77.6%
인터넷 1191
 
11.9%
계좌이체 862
 
8.6%
ocr 157
 
1.6%
위텍스 28
 
0.3%

수납은행코드
Real number (ℝ)

Distinct137
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean500901.62
Minimum11604
Maximum3710000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T06:07:33.371228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum11604
5-th percentile110000
Q1110000
median137818
Q3990000
95-th percentile990000
Maximum3710000
Range3698396
Interquartile range (IQR)880000

Descriptive statistics

Standard deviation450190.08
Coefficient of variation (CV)0.89875947
Kurtosis4.6825827
Mean500901.62
Median Absolute Deviation (MAD)27818
Skewness1.1247597
Sum5.0090162 × 109
Variance2.0267111 × 1011
MonotonicityNot monotonic
2024-03-15T06:07:33.888007image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
110000 4517
45.2%
990000 3245
32.5%
920000 862
 
8.6%
377513 169
 
1.7%
158790 144
 
1.4%
127336 90
 
0.9%
175139 90
 
0.9%
115173 86
 
0.9%
740179 81
 
0.8%
131607 63
 
0.6%
Other values (127) 653
 
6.5%
ValueCountFrequency (%)
11604 1
< 0.1%
31817 1
< 0.1%
31901 2
< 0.1%
32874 1
< 0.1%
35062 2
< 0.1%
36058 2
< 0.1%
40659 1
< 0.1%
40701 1
< 0.1%
42301 1
< 0.1%
42835 1
< 0.1%
ValueCountFrequency (%)
3710000 10
 
0.1%
3670000 4
 
< 0.1%
3660000 7
 
0.1%
3650000 1
 
< 0.1%
3610000 6
 
0.1%
990000 3245
32.5%
920000 862
 
8.6%
900032 4
 
< 0.1%
817028 2
 
< 0.1%
802240 2
 
< 0.1%

수납은행코드명
Categorical

IMBALANCE 

Distinct18
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
농협중앙회
4629 
금융결제원
3248 
가상계좌(전북은행)
868 
농협회원
676 
우체국
 
227
Other values (13)
 
352

Length

Max length11
Median length5
Mean length5.3133
Min length2

Unique

Unique2 ?
Unique (%)< 0.1%

Sample

1st row농협중앙회
2nd row농협중앙회
3rd row금융결제원
4th row금융결제원
5th row금융결제원

Common Values

ValueCountFrequency (%)
농협중앙회 4629
46.3%
금융결제원 3248
32.5%
가상계좌(전북은행) 868
 
8.7%
농협회원 676
 
6.8%
우체국 227
 
2.3%
전북은행 182
 
1.8%
새마을금고 80
 
0.8%
wetax(신용카드) 28
 
0.3%
국민은행 16
 
0.2%
산림조합 11
 
0.1%
Other values (8) 35
 
0.4%

Length

2024-03-15T06:07:34.250296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
농협중앙회 4629
46.3%
금융결제원 3248
32.5%
가상계좌(전북은행 868
 
8.7%
농협회원 676
 
6.8%
우체국 227
 
2.3%
전북은행 182
 
1.8%
새마을금고 80
 
0.8%
wetax(신용카드 28
 
0.3%
국민은행 16
 
0.2%
산림조합 11
 
0.1%
Other values (8) 35
 
0.4%

묶은번호
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
7886 
<NA>
1219 
1
816 
2
 
79

Length

Max length4
Median length1
Mean length1.3657
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 7886
78.9%
<NA> 1219
 
12.2%
1 816
 
8.2%
2 79
 
0.8%

Length

2024-03-15T06:07:34.457555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:34.768717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 7886
78.9%
na 1219
 
12.2%
1 816
 
8.2%
2 79
 
0.8%

묶음일련번호
Real number (ℝ)

MISSING  ZEROS 

Distinct670
Distinct (%)7.6%
Missing1219
Missing (%)12.2%
Infinite0
Infinite (%)0.0%
Mean4739.4923
Minimum0
Maximum95958
Zeros7762
Zeros (%)77.6%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T06:07:35.152966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile50013
Maximum95958
Range95958
Interquartile range (IQR)0

Descriptive statistics

Standard deviation17201.276
Coefficient of variation (CV)3.6293499
Kurtosis14.123562
Mean4739.4923
Median Absolute Deviation (MAD)0
Skewness3.8537065
Sum41617482
Variance2.958839 × 108
MonotonicityNot monotonic
2024-03-15T06:07:35.566706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 7762
77.6%
2 23
 
0.2%
1 22
 
0.2%
4 21
 
0.2%
33856 15
 
0.1%
5 14
 
0.1%
40101 14
 
0.1%
3 13
 
0.1%
256 12
 
0.1%
25924 12
 
0.1%
Other values (660) 873
 
8.7%
(Missing) 1219
 
12.2%
ValueCountFrequency (%)
0 7762
77.6%
1 22
 
0.2%
2 23
 
0.2%
3 13
 
0.1%
4 21
 
0.2%
5 14
 
0.1%
6 7
 
0.1%
7 10
 
0.1%
8 6
 
0.1%
9 5
 
0.1%
ValueCountFrequency (%)
95958 1
< 0.1%
95903 1
< 0.1%
95817 1
< 0.1%
95622 1
< 0.1%
95617 1
< 0.1%
95534 1
< 0.1%
95528 1
< 0.1%
95519 1
< 0.1%
95455 1
< 0.1%
95351 1
< 0.1%

소인상태코드
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
3
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 10000
100.0%

Length

2024-03-15T06:07:35.796499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:35.951136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 10000
100.0%

소인상태코드명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
소인처리
10000 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row소인처리
2nd row소인처리
3rd row소인처리
4th row소인처리
5th row소인처리

Common Values

ValueCountFrequency (%)
소인처리 10000
100.0%

Length

2024-03-15T06:07:36.327416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:07:36.503523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
소인처리 10000
100.0%

변경일자
Date

Distinct87
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-12-16 00:00:00
Maximum2023-05-04 00:00:00
2024-03-15T06:07:36.693131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:07:36.961689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

변경시간
Date

Distinct88
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-03-15 08:52:00
Maximum2024-03-15 17:29:00
2024-03-15T06:07:37.248643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:07:37.623546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Sample

접수일자고지종류고지종류명납기마감일수용가번호수납시점코드수납시점코드명수납일자오류코드오류코드명상수도납기내금액하수도납기내금액지하수납기내금액물부담금납기내금액상수도납기후금액하수도납기후금액지하수납기후금액물부담금납기후금액상수도수납액하수도수납액지하수수납액물부담금수납액이체코드이체코드명수납종류코드수납종류코드명수납은행코드수납은행코드명묶은번호묶음일련번호소인상태코드소인상태코드명변경일자변경시간
75702023-01-0311정기2022-12-3190060004001납기내2023-01-020오류없음9380368000956037500093803680003자동납부3자동납부110000농협중앙회003소인처리2023-01-0313:18
487032023-05-0311정기2023-04-3010270034101납기내2023-05-020오류없음5810650005920660005810650003자동납부3자동납부110000농협중앙회003소인처리2023-05-0313:17
6672023-01-0311정기2022-12-3160010002191납기내2023-01-020오류없음1000000102000010000003자동납부3자동납부990000금융결제원003소인처리2023-01-0313:03
19652023-01-0311정기2022-12-3110080020001납기내2023-01-020오류없음5240175000535017800052401750003자동납부3자동납부990000금융결제원003소인처리2023-01-0313:03
409062023-04-0311정기2023-03-3130080021001납기내2023-03-310오류없음2130220002170220002130220003자동납부3자동납부990000금융결제원003소인처리2023-04-0313:06
419892023-04-0311정기2023-02-28110020216502납기후2023-03-310오류없음6650110000678011200067801120003자동납부3자동납부990000금융결제원003소인처리2023-04-0313:06
455142023-05-0311정기2023-04-3080052005001납기내2023-05-020오류없음1000000102000010000003자동납부3자동납부110000농협중앙회003소인처리2023-05-0313:17
531582023-05-0311정기2023-04-3010180005011납기내2023-05-020오류없음2405051400024530524000240505140003자동납부3자동납부990000금융결제원003소인처리2023-05-0313:09
339752023-04-0311정기2023-03-3170230010001납기내2023-03-310오류없음8910000908000089100003자동납부3자동납부110000농협중앙회003소인처리2023-04-0313:18
187372023-02-0111정기2023-01-3190290008221납기내2023-01-310오류없음10009900010201000001000990003자동납부3자동납부990000금융결제원003소인처리2023-02-0113:11
접수일자고지종류고지종류명납기마감일수용가번호수납시점코드수납시점코드명수납일자오류코드오류코드명상수도납기내금액하수도납기내금액지하수납기내금액물부담금납기내금액상수도납기후금액하수도납기후금액지하수납기후금액물부담금납기후금액상수도수납액하수도수납액지하수수납액물부담금수납액이체코드이체코드명수납종류코드수납종류코드명수납은행코드수납은행코드명묶은번호묶음일련번호소인상태코드소인상태코드명변경일자변경시간
63702023-01-0311정기2022-12-3160140011201납기내2023-01-020오류없음2130440002170440002130440003자동납부3자동납부110000농협중앙회003소인처리2023-01-0313:18
125922023-02-0111정기2023-01-3170320003001납기내2023-01-310오류없음3260440003320440003260440003자동납부3자동납부110000농협중앙회003소인처리2023-02-0113:17
105412023-01-3011정기2023-01-3110150111501납기내2023-01-300오류없음1570110001600110001570110008계좌이체8계좌이체920000가상계좌(전북은행)0842313소인처리2023-01-3109:00
527742023-05-0311정기2023-04-3010350027001납기내2023-05-020오류없음3830550003900560003830550003자동납부3자동납부990000금융결제원003소인처리2023-05-0313:09
123152023-02-0111정기2023-01-3110140059001납기내2023-01-310오류없음7949012230008108012470007949012230003자동납부3자동납부990000금융결제원003소인처리2023-02-0113:11
381652023-04-0311정기2023-03-31100010066321납기내2023-03-310오류없음2130220002170220002130220003자동납부3자동납부990000금융결제원003소인처리2023-04-0313:06
443902023-04-2111정기2023-04-3090320021001납기내2023-04-210오류없음1654000016870000165400008계좌이체8계좌이체920000가상계좌(전북은행)0701113소인처리2023-04-2409:06
107512023-01-3111정기2023-01-3190110004001납기내2023-01-310오류없음9550000974000095500008계좌이체8계좌이체920000가상계좌(전북은행)1946243소인처리2023-02-0109:04
258442023-03-0211정기2023-02-2810150135001납기내2023-02-280오류없음2700390002750390002700390003자동납부3자동납부990000금융결제원003소인처리2023-03-0213:18
383712023-04-0311정기2023-03-3110010088001납기내2023-03-310오류없음60809900062001000006080990003자동납부3자동납부990000금융결제원003소인처리2023-04-0313:06