Overview

Dataset statistics

Number of variables23
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows347
Duplicate rows (%)3.5%
Total size in memory2.0 MiB
Average record size in memory208.0 B

Variable types

DateTime2
Categorical5
Numeric16

Dataset

Description2023년 12월 기준 서천군 상하수도 요금부과 현황입니다.등록월 기준 상수도 사용 가구수, 사용량, 계량기 구경 등의 현황을 보여줍니다.
Author충청남도 서천군
URLhttps://www.data.go.kr/data/15112226/fileData.do

Alerts

납기일 has constant value ""Constant
검침주기 has constant value ""Constant
조정구분 has constant value ""Constant
조정일 has constant value ""Constant
Dataset has 347 (3.5%) duplicate rowsDuplicates
고지구분 is highly imbalanced (99.9%)Imbalance
업종 is highly imbalanced (73.7%)Imbalance
합계 is highly skewed (γ1 = 38.25730329)Skewed
가구수 is highly skewed (γ1 = 33.44051415)Skewed
전월지침 is highly skewed (γ1 = 29.32707471)Skewed
당월지침 is highly skewed (γ1 = 29.47236918)Skewed
사용량 is highly skewed (γ1 = 34.35505481)Skewed
조정량 is highly skewed (γ1 = 34.3550651)Skewed
사용료 is highly skewed (γ1 = 58.09206491)Skewed
감면액 is highly skewed (γ1 = -88.78680113)Skewed
정산액 is highly skewed (γ1 = 98.86643851)Skewed
가산정산 is highly skewed (γ1 = -99.33674931)Skewed
소계 is highly skewed (γ1 = 42.46510349)Skewed
하수도 is highly skewed (γ1 = 35.48161095)Skewed
물부담금 is highly skewed (γ1 = 52.88650161)Skewed
납기후금액 is highly skewed (γ1 = 38.25610678)Skewed
합계 has 243 (2.4%) zerosZeros
사용량 has 1728 (17.3%) zerosZeros
조정량 has 1739 (17.4%) zerosZeros
사용료 has 1739 (17.4%) zerosZeros
감면액 has 4352 (43.5%) zerosZeros
정산액 has 9987 (99.9%) zerosZeros
가산정산 has 9608 (96.1%) zerosZeros
소계 has 263 (2.6%) zerosZeros
하수도 has 7340 (73.4%) zerosZeros
물부담금 has 6559 (65.6%) zerosZeros
납기후금액 has 243 (2.4%) zerosZeros

Reproduction

Analysis started2023-12-16 15:44:35.228265
Analysis finished2023-12-16 15:44:36.500245
Duration1.27 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

납기일
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-31 00:00:00
Maximum2023-12-31 00:00:00
2023-12-16T15:44:36.815094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:44:37.547469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

고지구분
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
정기
9999 
수시
 
1

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
정기 9999
> 99.9%
수시 1
 
< 0.1%

Length

2023-12-16T15:44:38.276564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:44:38.766136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정기 9999
> 99.9%
수시 1
 
< 0.1%

이체구분
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
자동
6632 
OCR
3368 

Length

Max length3
Median length2
Mean length2.3368
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
자동 6632
66.3%
OCR 3368
33.7%

Length

2023-12-16T15:44:39.348002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:44:40.132879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자동 6632
66.3%
ocr 3368
33.7%

합계
Real number (ℝ)

SKEWED  ZEROS 

Distinct1904
Distinct (%)19.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25913.349
Minimum0
Maximum13507110
Zeros243
Zeros (%)2.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-16T15:44:40.649044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2170
Q13720
median8820
Q316620
95-th percentile56407
Maximum13507110
Range13507110
Interquartile range (IQR)12900

Descriptive statistics

Standard deviation206321.65
Coefficient of variation (CV)7.9619833
Kurtosis2054.9125
Mean25913.349
Median Absolute Deviation (MAD)5870
Skewness38.257303
Sum2.5913349 × 108
Variance4.2568624 × 1010
MonotonicityNot monotonic
2023-12-16T15:44:41.281103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2170 1524
 
15.2%
0 243
 
2.4%
3990 132
 
1.3%
2780 127
 
1.3%
2950 124
 
1.2%
3380 116
 
1.2%
6400 108
 
1.1%
7010 101
 
1.0%
5190 100
 
1.0%
7610 99
 
1.0%
Other values (1894) 7326
73.3%
ValueCountFrequency (%)
0 243
2.4%
240 2
 
< 0.1%
440 1
 
< 0.1%
480 1
 
< 0.1%
930 1
 
< 0.1%
1200 2
 
< 0.1%
1520 1
 
< 0.1%
1670 3
 
< 0.1%
1680 5
 
0.1%
1880 1
 
< 0.1%
ValueCountFrequency (%)
13507110 1
< 0.1%
6741290 1
< 0.1%
4675070 1
< 0.1%
4464340 1
< 0.1%
4394770 1
< 0.1%
3740260 1
< 0.1%
3585690 1
< 0.1%
3492440 1
< 0.1%
3291840 1
< 0.1%
2969140 1
< 0.1%

검침주기
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

2023-12-16T15:44:41.891737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:44:42.203234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
매월검침 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

2023-12-16T15:44:42.656365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:44:43.195278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상조정 10000
100.0%

구경
Real number (ℝ)

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.2651
Minimum13
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-16T15:44:44.088078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum13
5-th percentile13
Q113
median13
Q313
95-th percentile20
Maximum100
Range87
Interquartile range (IQR)0

Descriptive statistics

Standard deviation5.1553351
Coefficient of variation (CV)0.36139495
Kurtosis75.75124
Mean14.2651
Median Absolute Deviation (MAD)0
Skewness7.244887
Sum142651
Variance26.57748
MonotonicityNot monotonic
2023-12-16T15:44:45.135993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
13 9009
90.1%
20 591
 
5.9%
25 181
 
1.8%
32 92
 
0.9%
40 68
 
0.7%
50 41
 
0.4%
75 13
 
0.1%
100 5
 
0.1%
ValueCountFrequency (%)
13 9009
90.1%
20 591
 
5.9%
25 181
 
1.8%
32 92
 
0.9%
40 68
 
0.7%
50 41
 
0.4%
75 13
 
0.1%
100 5
 
0.1%
ValueCountFrequency (%)
100 5
 
0.1%
75 13
 
0.1%
50 41
 
0.4%
40 68
 
0.7%
32 92
 
0.9%
25 181
 
1.8%
20 591
 
5.9%
13 9009
90.1%

업종
Categorical

IMBALANCE 

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
가정용
8376 
일반용
1572 
일반혼합
 
39
일반용2
 
9
대중탕용
 
2

Length

Max length4
Median length3
Mean length3.005
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
가정용 8376
83.8%
일반용 1572
 
15.7%
일반혼합 39
 
0.4%
일반용2 9
 
0.1%
대중탕용 2
 
< 0.1%
공업용 2
 
< 0.1%

Length

2023-12-16T15:44:45.743952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:44:46.625055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가정용 8376
83.8%
일반용 1572
 
15.7%
일반혼합 39
 
0.4%
일반용2 9
 
0.1%
대중탕용 2
 
< 0.1%
공업용 2
 
< 0.1%

가구수
Real number (ℝ)

SKEWED 

Distinct33
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.2874
Minimum0
Maximum323
Zeros26
Zeros (%)0.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-16T15:44:47.404465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q11
median1
Q31
95-th percentile1
Maximum323
Range323
Interquartile range (IQR)0

Descriptive statistics

Standard deviation6.9135216
Coefficient of variation (CV)5.3701426
Kurtosis1222.2898
Mean1.2874
Median Absolute Deviation (MAD)0
Skewness33.440514
Sum12874
Variance47.796781
MonotonicityNot monotonic
2023-12-16T15:44:48.059085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
1 9780
97.8%
2 86
 
0.9%
3 34
 
0.3%
0 26
 
0.3%
4 20
 
0.2%
5 11
 
0.1%
8 8
 
0.1%
6 4
 
< 0.1%
7 3
 
< 0.1%
16 3
 
< 0.1%
Other values (23) 25
 
0.2%
ValueCountFrequency (%)
0 26
 
0.3%
1 9780
97.8%
2 86
 
0.9%
3 34
 
0.3%
4 20
 
0.2%
5 11
 
0.1%
6 4
 
< 0.1%
7 3
 
< 0.1%
8 8
 
0.1%
9 1
 
< 0.1%
ValueCountFrequency (%)
323 1
< 0.1%
252 2
< 0.1%
240 1
< 0.1%
239 1
< 0.1%
194 1
< 0.1%
175 1
< 0.1%
120 1
< 0.1%
108 1
< 0.1%
106 1
< 0.1%
99 1
< 0.1%

전월지침
Real number (ℝ)

SKEWED 

Distinct2779
Distinct (%)27.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1158.4081
Minimum0
Maximum230982
Zeros51
Zeros (%)0.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-16T15:44:49.022239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3
Q1195
median537
Q31151.25
95-th percentile3535.1
Maximum230982
Range230982
Interquartile range (IQR)956.25

Descriptive statistics

Standard deviation4831.4283
Coefficient of variation (CV)4.170748
Kurtosis1083.2819
Mean1158.4081
Median Absolute Deviation (MAD)411
Skewness29.327075
Sum11584081
Variance23342700
MonotonicityNot monotonic
2023-12-16T15:44:49.871724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3 351
 
3.5%
1 100
 
1.0%
0 51
 
0.5%
2 47
 
0.5%
5 32
 
0.3%
4 31
 
0.3%
7 26
 
0.3%
6 25
 
0.2%
34 21
 
0.2%
37 20
 
0.2%
Other values (2769) 9296
93.0%
ValueCountFrequency (%)
0 51
 
0.5%
1 100
 
1.0%
2 47
 
0.5%
3 351
3.5%
4 31
 
0.3%
5 32
 
0.3%
6 25
 
0.2%
7 26
 
0.3%
8 19
 
0.2%
9 17
 
0.2%
ValueCountFrequency (%)
230982 1
< 0.1%
190833 1
< 0.1%
168434 1
< 0.1%
140116 1
< 0.1%
122779 1
< 0.1%
121041 1
< 0.1%
98276 1
< 0.1%
95568 1
< 0.1%
87003 1
< 0.1%
49303 1
< 0.1%

당월지침
Real number (ℝ)

SKEWED 

Distinct2827
Distinct (%)28.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1174.907
Minimum0
Maximum235949
Zeros52
Zeros (%)0.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-16T15:44:50.742142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3
Q1201
median547
Q31166
95-th percentile3560.4
Maximum235949
Range235949
Interquartile range (IQR)965

Descriptive statistics

Standard deviation4962.6556
Coefficient of variation (CV)4.223871
Kurtosis1085.8842
Mean1174.907
Median Absolute Deviation (MAD)418
Skewness29.472369
Sum11749070
Variance24627951
MonotonicityNot monotonic
2023-12-16T15:44:51.671264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3 322
 
3.2%
1 99
 
1.0%
0 52
 
0.5%
2 48
 
0.5%
4 33
 
0.3%
5 31
 
0.3%
7 27
 
0.3%
37 24
 
0.2%
11 23
 
0.2%
34 22
 
0.2%
Other values (2817) 9319
93.2%
ValueCountFrequency (%)
0 52
 
0.5%
1 99
 
1.0%
2 48
 
0.5%
3 322
3.2%
4 33
 
0.3%
5 31
 
0.3%
6 21
 
0.2%
7 27
 
0.3%
8 20
 
0.2%
9 22
 
0.2%
ValueCountFrequency (%)
235949 1
< 0.1%
196083 1
< 0.1%
173707 1
< 0.1%
149479 1
< 0.1%
126289 1
< 0.1%
124431 1
< 0.1%
99000 1
< 0.1%
98632 1
< 0.1%
89779 1
< 0.1%
50324 1
< 0.1%

사용량
Real number (ℝ)

SKEWED  ZEROS 

Distinct232
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.2594
Minimum0
Maximum9363
Zeros1728
Zeros (%)17.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-16T15:44:52.154745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q12
median9
Q318
95-th percentile49
Maximum9363
Range9363
Interquartile range (IQR)16

Descriptive statistics

Standard deviation160.86978
Coefficient of variation (CV)7.2270491
Kurtosis1534.9054
Mean22.2594
Median Absolute Deviation (MAD)8
Skewness34.355055
Sum222594
Variance25879.085
MonotonicityNot monotonic
2023-12-16T15:44:53.004993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 1728
 
17.3%
1 446
 
4.5%
7 397
 
4.0%
2 395
 
4.0%
5 375
 
3.8%
10 375
 
3.8%
4 357
 
3.6%
6 353
 
3.5%
9 342
 
3.4%
8 334
 
3.3%
Other values (222) 4898
49.0%
ValueCountFrequency (%)
0 1728
17.3%
1 446
 
4.5%
2 395
 
4.0%
3 320
 
3.2%
4 357
 
3.6%
5 375
 
3.8%
6 353
 
3.5%
7 397
 
4.0%
8 334
 
3.3%
9 342
 
3.4%
ValueCountFrequency (%)
9363 1
< 0.1%
5273 1
< 0.1%
5250 1
< 0.1%
4967 1
< 0.1%
3510 1
< 0.1%
3390 1
< 0.1%
3064 1
< 0.1%
3039 1
< 0.1%
2776 1
< 0.1%
2097 1
< 0.1%

조정량
Real number (ℝ)

SKEWED  ZEROS 

Distinct232
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.245
Minimum0
Maximum9363
Zeros1739
Zeros (%)17.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-16T15:44:53.576468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q12
median9
Q318
95-th percentile49
Maximum9363
Range9363
Interquartile range (IQR)16

Descriptive statistics

Standard deviation160.87017
Coefficient of variation (CV)7.2317453
Kurtosis1534.9025
Mean22.245
Median Absolute Deviation (MAD)8
Skewness34.355065
Sum222450
Variance25879.213
MonotonicityNot monotonic
2023-12-16T15:44:54.358646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 1739
 
17.4%
1 445
 
4.5%
7 397
 
4.0%
2 395
 
4.0%
10 375
 
3.8%
5 374
 
3.7%
4 357
 
3.6%
6 352
 
3.5%
9 340
 
3.4%
8 334
 
3.3%
Other values (222) 4892
48.9%
ValueCountFrequency (%)
0 1739
17.4%
1 445
 
4.5%
2 395
 
4.0%
3 317
 
3.2%
4 357
 
3.6%
5 374
 
3.7%
6 352
 
3.5%
7 397
 
4.0%
8 334
 
3.3%
9 340
 
3.4%
ValueCountFrequency (%)
9363 1
< 0.1%
5273 1
< 0.1%
5250 1
< 0.1%
4967 1
< 0.1%
3510 1
< 0.1%
3390 1
< 0.1%
3064 1
< 0.1%
3039 1
< 0.1%
2776 1
< 0.1%
2097 1
< 0.1%

사용료
Real number (ℝ)

SKEWED  ZEROS 

Distinct402
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19918.902
Minimum0
Maximum16991790
Zeros1739
Zeros (%)17.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-16T15:44:55.614637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11220
median6100
Q311590
95-th percentile43470
Maximum16991790
Range16991790
Interquartile range (IQR)10370

Descriptive statistics

Standard deviation209014.32
Coefficient of variation (CV)10.493265
Kurtosis4421.8369
Mean19918.902
Median Absolute Deviation (MAD)4880
Skewness58.092065
Sum1.9918902 × 108
Variance4.3686987 × 1010
MonotonicityNot monotonic
2023-12-16T15:44:57.113938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 1739
 
17.4%
610 373
 
3.7%
4270 359
 
3.6%
6100 344
 
3.4%
3050 330
 
3.3%
1220 319
 
3.2%
3660 317
 
3.2%
2440 312
 
3.1%
5490 309
 
3.1%
4880 302
 
3.0%
Other values (392) 5296
53.0%
ValueCountFrequency (%)
0 1739
17.4%
610 373
 
3.7%
810 72
 
0.7%
1220 319
 
3.2%
1620 76
 
0.8%
1830 273
 
2.7%
2430 44
 
0.4%
2440 312
 
3.1%
3050 330
 
3.3%
3240 45
 
0.4%
ValueCountFrequency (%)
16991790 1
< 0.1%
4937580 1
< 0.1%
3695010 1
< 0.1%
3329920 1
< 0.1%
3202500 1
< 0.1%
3100260 1
< 0.1%
3029870 1
< 0.1%
2928240 1
< 0.1%
2710550 1
< 0.1%
2463420 1
< 0.1%

구경요금
Real number (ℝ)

Distinct9
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2716.956
Minimum0
Maximum86840
Zeros36
Zeros (%)0.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-16T15:44:58.141106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2170
Q12170
median2170
Q32170
95-th percentile3990
Maximum86840
Range86840
Interquartile range (IQR)0

Descriptive statistics

Standard deviation3398.8432
Coefficient of variation (CV)1.2509747
Kurtosis264.69442
Mean2716.956
Median Absolute Deviation (MAD)0
Skewness13.974903
Sum27169560
Variance11552135
MonotonicityNot monotonic
2023-12-16T15:44:59.175939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
2170 8973
89.7%
3990 591
 
5.9%
5950 181
 
1.8%
10760 92
 
0.9%
15610 68
 
0.7%
26140 41
 
0.4%
0 36
 
0.4%
54290 13
 
0.1%
86840 5
 
0.1%
ValueCountFrequency (%)
0 36
 
0.4%
2170 8973
89.7%
3990 591
 
5.9%
5950 181
 
1.8%
10760 92
 
0.9%
15610 68
 
0.7%
26140 41
 
0.4%
54290 13
 
0.1%
86840 5
 
0.1%
ValueCountFrequency (%)
86840 5
 
0.1%
54290 13
 
0.1%
26140 41
 
0.4%
15610 68
 
0.7%
10760 92
 
0.9%
5950 181
 
1.8%
3990 591
 
5.9%
2170 8973
89.7%
0 36
 
0.4%

감면액
Real number (ℝ)

SKEWED  ZEROS 

Distinct295
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-1416.751
Minimum-5102530
Maximum0
Zeros4352
Zeros (%)43.5%
Negative5648
Negative (%)56.5%
Memory size166.0 KiB
2023-12-16T15:44:59.987847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-5102530
5-th percentile-3030
Q1-100
median-30
Q30
95-th percentile0
Maximum0
Range5102530
Interquartile range (IQR)100

Descriptive statistics

Standard deviation53376.26
Coefficient of variation (CV)-37.675117
Kurtosis8372.7559
Mean-1416.751
Median Absolute Deviation (MAD)30
Skewness-88.786801
Sum-14167510
Variance2.8490252 × 109
MonotonicityNot monotonic
2023-12-16T15:45:00.645257image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4352
43.5%
-40 488
 
4.9%
-30 444
 
4.4%
-10 424
 
4.2%
-60 401
 
4.0%
-70 390
 
3.9%
-90 310
 
3.1%
-100 267
 
2.7%
-50 231
 
2.3%
-20 212
 
2.1%
Other values (285) 2481
24.8%
ValueCountFrequency (%)
-5102530 1
< 0.1%
-1108500 1
< 0.1%
-930070 1
< 0.1%
-334470 1
< 0.1%
-269690 1
< 0.1%
-256510 1
< 0.1%
-158850 1
< 0.1%
-123600 1
< 0.1%
-114790 1
< 0.1%
-84000 1
< 0.1%
ValueCountFrequency (%)
0 4352
43.5%
-10 424
 
4.2%
-20 212
 
2.1%
-30 444
 
4.4%
-40 488
 
4.9%
-50 231
 
2.3%
-60 401
 
4.0%
-70 390
 
3.9%
-80 199
 
2.0%
-90 310
 
3.1%

정산액
Real number (ℝ)

SKEWED  ZEROS 

Distinct14
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean331.269
Minimum-43800
Maximum3007990
Zeros9987
Zeros (%)99.9%
Negative5
Negative (%)< 0.1%
Memory size166.0 KiB
2023-12-16T15:45:01.201889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-43800
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum3007990
Range3051790
Interquartile range (IQR)0

Descriptive statistics

Standard deviation30200.749
Coefficient of variation (CV)91.166842
Kurtosis9841.0179
Mean331.269
Median Absolute Deviation (MAD)0
Skewness98.866439
Sum3312690
Variance9.1208522 × 108
MonotonicityNot monotonic
2023-12-16T15:45:01.984146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
0 9987
99.9%
-5190 1
 
< 0.1%
14870 1
 
< 0.1%
262270 1
 
< 0.1%
-13200 1
 
< 0.1%
14600 1
 
< 0.1%
3007990 1
 
< 0.1%
-43800 1
 
< 0.1%
-2170 1
 
< 0.1%
25720 1
 
< 0.1%
Other values (4) 4
 
< 0.1%
ValueCountFrequency (%)
-43800 1
 
< 0.1%
-13200 1
 
< 0.1%
-5190 1
 
< 0.1%
-2170 1
 
< 0.1%
-1100 1
 
< 0.1%
0 9987
99.9%
10000 1
 
< 0.1%
14600 1
 
< 0.1%
14870 1
 
< 0.1%
18600 1
 
< 0.1%
ValueCountFrequency (%)
3007990 1
 
< 0.1%
262270 1
 
< 0.1%
25720 1
 
< 0.1%
24100 1
 
< 0.1%
18600 1
 
< 0.1%
14870 1
 
< 0.1%
14600 1
 
< 0.1%
10000 1
 
< 0.1%
0 9987
99.9%
-1100 1
 
< 0.1%

가산정산
Real number (ℝ)

SKEWED  ZEROS 

Distinct72
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-19.882
Minimum-117180
Maximum1220
Zeros9608
Zeros (%)96.1%
Negative391
Negative (%)3.9%
Memory size166.0 KiB
2023-12-16T15:45:02.828629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-117180
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum1220
Range118400
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1174.3388
Coefficient of variation (CV)-59.065426
Kurtosis9911.022
Mean-19.882
Median Absolute Deviation (MAD)0
Skewness-99.336749
Sum-198820
Variance1379071.6
MonotonicityNot monotonic
2023-12-16T15:45:03.508775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9608
96.1%
-20 31
 
0.3%
-40 30
 
0.3%
-60 25
 
0.2%
-30 24
 
0.2%
-10 23
 
0.2%
-50 18
 
0.2%
-90 18
 
0.2%
-100 16
 
0.2%
-130 11
 
0.1%
Other values (62) 196
 
2.0%
ValueCountFrequency (%)
-117180 1
< 0.1%
-2650 1
< 0.1%
-2170 1
< 0.1%
-1870 1
< 0.1%
-1810 1
< 0.1%
-1690 1
< 0.1%
-1620 1
< 0.1%
-1580 1
< 0.1%
-1420 1
< 0.1%
-1410 1
< 0.1%
ValueCountFrequency (%)
1220 1
 
< 0.1%
0 9608
96.1%
-10 23
 
0.2%
-20 31
 
0.3%
-30 24
 
0.2%
-40 30
 
0.3%
-50 18
 
0.2%
-60 25
 
0.2%
-70 10
 
0.1%
-80 11
 
0.1%

소계
Real number (ℝ)

SKEWED  ZEROS 

Distinct1255
Distinct (%)12.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21530.494
Minimum0
Maximum11915400
Zeros263
Zeros (%)2.6%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-16T15:45:04.131101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2170
Q13380
median7610
Q313650
95-th percentile46459.5
Maximum11915400
Range11915400
Interquartile range (IQR)10270

Descriptive statistics

Standard deviation169592.84
Coefficient of variation (CV)7.8768671
Kurtosis2572.3387
Mean21530.494
Median Absolute Deviation (MAD)4830
Skewness42.465103
Sum2.1530494 × 108
Variance2.8761732 × 1010
MonotonicityNot monotonic
2023-12-16T15:45:04.981366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2170 1574
 
15.7%
2780 312
 
3.1%
0 263
 
2.6%
3990 240
 
2.4%
6400 236
 
2.4%
3380 217
 
2.2%
7010 212
 
2.1%
7610 212
 
2.1%
5190 211
 
2.1%
8210 208
 
2.1%
Other values (1245) 6315
63.1%
ValueCountFrequency (%)
0 263
2.6%
1200 1
 
< 0.1%
1520 1
 
< 0.1%
1670 3
 
< 0.1%
1680 5
 
0.1%
1880 1
 
< 0.1%
1890 1
 
< 0.1%
2080 2
 
< 0.1%
2090 1
 
< 0.1%
2110 9
 
0.1%
ValueCountFrequency (%)
11915400 1
< 0.1%
4874690 1
< 0.1%
3370110 1
< 0.1%
3205340 1
< 0.1%
3007990 1
< 0.1%
2977530 1
< 0.1%
2960560 1
< 0.1%
2721160 1
< 0.1%
2612650 1
< 0.1%
2484560 1
< 0.1%

하수도
Real number (ℝ)

SKEWED  ZEROS 

Distinct447
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2656.57
Minimum0
Maximum1866600
Zeros7340
Zeros (%)73.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-16T15:45:05.732557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q3480
95-th percentile7340
Maximum1866600
Range1866600
Interquartile range (IQR)480

Descriptive statistics

Standard deviation34871.13
Coefficient of variation (CV)13.126374
Kurtosis1452.1383
Mean2656.57
Median Absolute Deviation (MAD)0
Skewness35.481611
Sum26565700
Variance1.2159957 × 109
MonotonicityNot monotonic
2023-12-16T15:45:06.423585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 7340
73.4%
2400 89
 
0.9%
2160 82
 
0.8%
1440 82
 
0.8%
1680 75
 
0.8%
1200 74
 
0.7%
3600 72
 
0.7%
3360 71
 
0.7%
1920 69
 
0.7%
3120 65
 
0.7%
Other values (437) 1981
 
19.8%
ValueCountFrequency (%)
0 7340
73.4%
200 7
 
0.1%
210 1
 
< 0.1%
220 4
 
< 0.1%
230 2
 
< 0.1%
240 64
 
0.6%
290 8
 
0.1%
310 34
 
0.3%
320 2
 
< 0.1%
440 7
 
0.1%
ValueCountFrequency (%)
1866600 1
< 0.1%
1304960 1
< 0.1%
1259000 1
< 0.1%
1131980 1
< 0.1%
1019100 1
< 0.1%
839400 1
< 0.1%
812600 1
< 0.1%
734360 1
< 0.1%
575340 1
< 0.1%
361360 1
< 0.1%

물부담금
Real number (ℝ)

SKEWED  ZEROS 

Distinct239
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1713.936
Minimum0
Maximum1591710
Zeros6559
Zeros (%)65.6%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-16T15:45:07.240849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31020
95-th percentile4760
Maximum1591710
Range1591710
Interquartile range (IQR)1020

Descriptive statistics

Standard deviation20760.282
Coefficient of variation (CV)12.112636
Kurtosis3626.4977
Mean1713.936
Median Absolute Deviation (MAD)0
Skewness52.886502
Sum17139360
Variance4.3098932 × 108
MonotonicityNot monotonic
2023-12-16T15:45:08.146515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 6559
65.6%
170 191
 
1.9%
1190 177
 
1.8%
680 172
 
1.7%
850 166
 
1.7%
1700 154
 
1.5%
340 146
 
1.5%
1360 143
 
1.4%
1020 142
 
1.4%
510 135
 
1.4%
Other values (229) 2015
 
20.2%
ValueCountFrequency (%)
0 6559
65.6%
160 3
 
< 0.1%
170 191
 
1.9%
330 4
 
< 0.1%
340 146
 
1.5%
470 1
 
< 0.1%
500 1
 
< 0.1%
510 135
 
1.4%
650 1
 
< 0.1%
660 2
 
< 0.1%
ValueCountFrequency (%)
1591710 1
< 0.1%
595000 1
< 0.1%
569500 1
< 0.1%
516630 1
< 0.1%
356490 1
< 0.1%
285260 1
< 0.1%
283850 1
< 0.1%
261630 1
< 0.1%
251770 1
< 0.1%
242080 1
< 0.1%

조정일
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-08 00:00:00
Maximum2023-12-08 00:00:00
2023-12-16T15:45:08.701581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:45:09.345728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

납기후금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct1943
Distinct (%)19.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean26680.551
Minimum0
Maximum13912320
Zeros243
Zeros (%)2.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-16T15:45:10.053366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2230
Q13820
median9080
Q317110
95-th percentile58153.5
Maximum13912320
Range13912320
Interquartile range (IQR)13290

Descriptive statistics

Standard deviation212527.01
Coefficient of variation (CV)7.9656156
Kurtosis2054.6225
Mean26680.551
Median Absolute Deviation (MAD)6060
Skewness38.256107
Sum2.6680551 × 108
Variance4.5167732 × 1010
MonotonicityNot monotonic
2023-12-16T15:45:10.770675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2230 1524
 
15.2%
0 243
 
2.4%
4100 132
 
1.3%
2850 127
 
1.3%
3020 124
 
1.2%
3470 115
 
1.1%
6580 108
 
1.1%
7210 101
 
1.0%
5340 101
 
1.0%
7830 99
 
1.0%
Other values (1933) 7326
73.3%
ValueCountFrequency (%)
0 243
2.4%
240 2
 
< 0.1%
450 1
 
< 0.1%
490 1
 
< 0.1%
950 1
 
< 0.1%
1230 2
 
< 0.1%
1580 1
 
< 0.1%
1710 3
 
< 0.1%
1720 5
 
0.1%
1940 1
 
< 0.1%
ValueCountFrequency (%)
13912320 1
< 0.1%
6948370 1
< 0.1%
4815300 1
< 0.1%
4598260 1
< 0.1%
4526580 1
< 0.1%
3852450 1
< 0.1%
3693250 1
< 0.1%
3597190 1
< 0.1%
3390640 1
< 0.1%
3058210 1
< 0.1%

Sample

납기일고지구분이체구분합계검침주기조정구분구경업종가구수전월지침당월지침사용량조정량사용료구경요금감면액정산액가산정산소계하수도물부담금조정일납기후금액
2692023-12-31정기자동2170매월검침정상조정13일반용14400021700002170002023-12-082230
105442023-12-31정기OCR8390매월검침정상조정13가정용1805813884880217000-107040013502023-12-088630
176482023-12-31정기OCR22770매월검침정상조정13가정용1582612303020600217000022770002023-12-0823440
172182023-12-31정기자동2780매월검침정상조정13가정용154551161021700002780002023-12-082850
148002023-12-31정기OCR23800매월검침정상조정13가정용131333164313121630217000023800002023-12-0824500
146292023-12-31정기자동2170매월검침정상조정13가정용13300021700002170002023-12-082230
117162023-12-31정기자동11460매월검침정상조정13가정용112591271121273202170-70009420020402023-12-0811790
180752023-12-31정기자동7010매월검침정상조정13가정용11481568848802170-40007010002023-12-087210
92672023-12-31정기자동11230매월검침정상조정13가정용1707722151591502170-900011230002023-12-0811560
11062023-12-31정기OCR7330매월검침정상조정13일반용14084124432402170000541012406802023-12-087530
납기일고지구분이체구분합계검침주기조정구분구경업종가구수전월지침당월지침사용량조정량사용료구경요금감면액정산액가산정산소계하수도물부담금조정일납기후금액
208252023-12-31정기자동28210매월검침정상조정13일반용1140914393030263002170-2600028210002023-12-0829050
180512023-12-31정기자동2170매월검침정상조정13가정용10000021700002170002023-12-082230
66772023-12-31정기OCR13220매월검침정상조정13가정용186587813137930217000010100312002023-12-0813600
169372023-12-31정기자동23590매월검침정상조정13가정용1132613573131216302170-2100023590002023-12-0824290
171542023-12-31정기OCR16770매월검침정상조정13가정용110381061232314720217000-12016770002023-12-0817270
148322023-12-31정기OCR2980매월검침정상조정13일반용14024031181021700002980002023-12-083060
158732023-12-31정기OCR20800매월검침정상조정13가정용1849872232314720217000016890039102023-12-0821410
88802023-12-31정기자동18410매월검침정상조정13가정용1216621912525164002170-1600018410002023-12-0818960
66082023-12-31정기OCR2170매월검침정상조정13가정용13300021700002170002023-12-082230
46572023-12-31정기OCR4370매월검침정상조정13일반용11421442216202170000379058002023-12-084480

Duplicate rows

Most frequently occurring

납기일고지구분이체구분합계검침주기조정구분구경업종가구수전월지침당월지침사용량조정량사용료구경요금감면액정산액가산정산소계하수도물부담금조정일납기후금액# duplicates
832023-12-31정기자동2170매월검침정상조정13가정용13300021700002170002023-12-082230195
92023-12-31정기OCR2170매월검침정상조정13가정용13300021700002170002023-12-08223073
812023-12-31정기자동2170매월검침정상조정13가정용11100021700002170002023-12-08223057
822023-12-31정기자동2170매월검침정상조정13가정용12200021700002170002023-12-08223036
802023-12-31정기자동2170매월검침정상조정13가정용10000021700002170002023-12-08223017
842023-12-31정기자동2170매월검침정상조정13가정용14400021700002170002023-12-08223016
872023-12-31정기자동2170매월검침정상조정13가정용17700021700002170002023-12-08223015
852023-12-31정기자동2170매월검침정상조정13가정용15500021700002170002023-12-08223014
72023-12-31정기OCR2170매월검침정상조정13가정용11100021700002170002023-12-08223013
862023-12-31정기자동2170매월검침정상조정13가정용16600021700002170002023-12-08223010