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

Categorical7
Numeric16

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 (72.9%)Imbalance
합계 is highly skewed (γ1 = 37.57892328)Skewed
가구수 is highly skewed (γ1 = 46.74565393)Skewed
전월지침 is highly skewed (γ1 = 39.39463877)Skewed
당월지침 is highly skewed (γ1 = 39.20979388)Skewed
사용량 is highly skewed (γ1 = 29.73443802)Skewed
조정량 is highly skewed (γ1 = 29.76348806)Skewed
사용료 is highly skewed (γ1 = 38.93382718)Skewed
감면액 is highly skewed (γ1 = -49.13358418)Skewed
정산액 is highly skewed (γ1 = 92.88456489)Skewed
가산정산 is highly skewed (γ1 = -97.26382046)Skewed
소계 is highly skewed (γ1 = 40.1566214)Skewed
하수도 is highly skewed (γ1 = 36.66219723)Skewed
물부담금 is highly skewed (γ1 = 39.51848021)Skewed
납기후금액 is highly skewed (γ1 = 37.57737027)Skewed
합계 has 275 (2.8%) zerosZeros
사용량 has 1751 (17.5%) zerosZeros
조정량 has 1758 (17.6%) zerosZeros
사용료 has 1758 (17.6%) zerosZeros
감면액 has 4364 (43.6%) zerosZeros
정산액 has 9990 (99.9%) zerosZeros
가산정산 has 9615 (96.2%) zerosZeros
소계 has 304 (3.0%) zerosZeros
하수도 has 7435 (74.4%) zerosZeros
물부담금 has 6587 (65.9%) zerosZeros
납기후금액 has 275 (2.8%) zerosZeros

Reproduction

Analysis started2024-01-09 22:30:56.268467
Analysis finished2024-01-09 22:30:56.642608
Duration0.37 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

납기일
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-31
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-12-31
2nd row2023-12-31
3rd row2023-12-31
4th row2023-12-31
5th row2023-12-31

Common Values

ValueCountFrequency (%)
2023-12-31 10000
100.0%

Length

2024-01-10T07:30:56.694839image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:30:56.773082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12-31 10000
100.0%

고지구분
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

2024-01-10T07:30:56.853566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:30:56.938520image/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
자동
6619 
OCR
3381 

Length

Max length3
Median length2
Mean length2.3381
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
자동 6619
66.2%
OCR 3381
33.8%

Length

2024-01-10T07:30:57.035818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:30:57.125988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자동 6619
66.2%
ocr 3381
33.8%

합계
Real number (ℝ)

SKEWED  ZEROS 

Distinct1922
Distinct (%)19.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean29785.131
Minimum0
Maximum17230790
Zeros275
Zeros (%)2.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:57.233553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2170
Q13390
median8820
Q316370
95-th percentile60551.5
Maximum17230790
Range17230790
Interquartile range (IQR)12980

Descriptive statistics

Standard deviation307101.13
Coefficient of variation (CV)10.310552
Kurtosis1690.4779
Mean29785.131
Median Absolute Deviation (MAD)5870
Skewness37.578923
Sum2.9785131 × 108
Variance9.4311106 × 1010
MonotonicityNot monotonic
2024-01-10T07:30:57.373117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2170 1546
 
15.5%
0 275
 
2.8%
3990 151
 
1.5%
2780 135
 
1.4%
2950 127
 
1.3%
6400 107
 
1.1%
5190 107
 
1.1%
3380 105
 
1.1%
7610 104
 
1.0%
8210 95
 
0.9%
Other values (1912) 7248
72.5%
ValueCountFrequency (%)
0 275
2.8%
240 4
 
< 0.1%
440 1
 
< 0.1%
720 1
 
< 0.1%
830 1
 
< 0.1%
840 6
 
0.1%
930 1
 
< 0.1%
1200 2
 
< 0.1%
1520 1
 
< 0.1%
1670 1
 
< 0.1%
ValueCountFrequency (%)
17230790 1
< 0.1%
12824340 1
< 0.1%
12515640 1
< 0.1%
8984340 1
< 0.1%
6741290 1
< 0.1%
6472790 1
< 0.1%
4675070 1
< 0.1%
4394770 1
< 0.1%
4124640 1
< 0.1%
4111390 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

2024-01-10T07:30:57.506355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:30:57.590465image/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

2024-01-10T07:30:57.692732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:30:57.787979image/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.3309
Minimum13
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:57.864703image/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.3757507
Coefficient of variation (CV)0.37511605
Kurtosis69.730631
Mean14.3309
Median Absolute Deviation (MAD)0
Skewness6.9814119
Sum143309
Variance28.898695
MonotonicityNot monotonic
2024-01-10T07:30:57.959997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
13 8994
89.9%
20 581
 
5.8%
25 192
 
1.9%
32 81
 
0.8%
40 80
 
0.8%
50 55
 
0.5%
75 11
 
0.1%
100 6
 
0.1%
ValueCountFrequency (%)
13 8994
89.9%
20 581
 
5.8%
25 192
 
1.9%
32 81
 
0.8%
40 80
 
0.8%
50 55
 
0.5%
75 11
 
0.1%
100 6
 
0.1%
ValueCountFrequency (%)
100 6
 
0.1%
75 11
 
0.1%
50 55
 
0.5%
40 80
 
0.8%
32 81
 
0.8%
25 192
 
1.9%
20 581
 
5.8%
13 8994
89.9%

업종
Categorical

IMBALANCE 

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
가정용
8323 
일반용
1609 
일반혼합
 
47
일반용2
 
17
대중탕용
 
2

Length

Max length4
Median length3
Mean length3.0066
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
가정용 8323
83.2%
일반용 1609
 
16.1%
일반혼합 47
 
0.5%
일반용2 17
 
0.2%
대중탕용 2
 
< 0.1%
공업용 2
 
< 0.1%

Length

2024-01-10T07:30:58.073261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:30:58.160699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가정용 8323
83.2%
일반용 1609
 
16.1%
일반혼합 47
 
0.5%
일반용2 17
 
0.2%
대중탕용 2
 
< 0.1%
공업용 2
 
< 0.1%

가구수
Real number (ℝ)

SKEWED 

Distinct29
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.2434
Minimum0
Maximum492
Zeros39
Zeros (%)0.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:58.528543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q11
median1
Q31
95-th percentile1
Maximum492
Range492
Interquartile range (IQR)0

Descriptive statistics

Standard deviation7.3274228
Coefficient of variation (CV)5.8930536
Kurtosis2566.944
Mean1.2434
Median Absolute Deviation (MAD)0
Skewness46.745654
Sum12434
Variance53.691126
MonotonicityNot monotonic
2024-01-10T07:30:58.631011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
1 9805
98.0%
2 71
 
0.7%
0 39
 
0.4%
3 21
 
0.2%
4 17
 
0.2%
5 9
 
0.1%
6 8
 
0.1%
8 5
 
0.1%
16 2
 
< 0.1%
24 2
 
< 0.1%
Other values (19) 21
 
0.2%
ValueCountFrequency (%)
0 39
 
0.4%
1 9805
98.0%
2 71
 
0.7%
3 21
 
0.2%
4 17
 
0.2%
5 9
 
0.1%
6 8
 
0.1%
7 2
 
< 0.1%
8 5
 
0.1%
10 1
 
< 0.1%
ValueCountFrequency (%)
492 1
< 0.1%
277 1
< 0.1%
274 1
< 0.1%
239 1
< 0.1%
175 1
< 0.1%
120 1
< 0.1%
112 1
< 0.1%
108 1
< 0.1%
99 1
< 0.1%
75 1
< 0.1%

전월지침
Real number (ℝ)

SKEWED 

Distinct2785
Distinct (%)27.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1228.4793
Minimum0
Maximum425873
Zeros54
Zeros (%)0.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:58.757786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3
Q1187
median527.5
Q31137.25
95-th percentile3586.25
Maximum425873
Range425873
Interquartile range (IQR)950.25

Descriptive statistics

Standard deviation6655.7985
Coefficient of variation (CV)5.4179167
Kurtosis2043.3282
Mean1228.4793
Median Absolute Deviation (MAD)411.5
Skewness39.394639
Sum12284793
Variance44299653
MonotonicityNot monotonic
2024-01-10T07:30:58.875671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3 353
 
3.5%
1 94
 
0.9%
2 55
 
0.5%
0 54
 
0.5%
5 33
 
0.3%
4 33
 
0.3%
7 30
 
0.3%
6 30
 
0.3%
10 26
 
0.3%
12 25
 
0.2%
Other values (2775) 9267
92.7%
ValueCountFrequency (%)
0 54
 
0.5%
1 94
 
0.9%
2 55
 
0.5%
3 353
3.5%
4 33
 
0.3%
5 33
 
0.3%
6 30
 
0.3%
7 30
 
0.3%
8 19
 
0.2%
9 17
 
0.2%
ValueCountFrequency (%)
425873 1
< 0.1%
253344 1
< 0.1%
185357 1
< 0.1%
168434 1
< 0.1%
160266 1
< 0.1%
151344 1
< 0.1%
133289 1
< 0.1%
88138 1
< 0.1%
87003 1
< 0.1%
81715 1
< 0.1%

당월지침
Real number (ℝ)

SKEWED 

Distinct2869
Distinct (%)28.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1248.0916
Minimum0
Maximum434535
Zeros53
Zeros (%)0.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:58.996689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3
Q1193
median540
Q31158.25
95-th percentile3621.45
Maximum434535
Range434535
Interquartile range (IQR)965.25

Descriptive statistics

Standard deviation6822.2671
Coefficient of variation (CV)5.466159
Kurtosis2018.5972
Mean1248.0916
Median Absolute Deviation (MAD)416
Skewness39.209794
Sum12480916
Variance46543328
MonotonicityNot monotonic
2024-01-10T07:30:59.112966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3 328
 
3.3%
1 91
 
0.9%
2 56
 
0.6%
0 53
 
0.5%
4 34
 
0.3%
6 34
 
0.3%
7 32
 
0.3%
5 29
 
0.3%
12 26
 
0.3%
19 25
 
0.2%
Other values (2859) 9292
92.9%
ValueCountFrequency (%)
0 53
 
0.5%
1 91
 
0.9%
2 56
 
0.6%
3 328
3.3%
4 34
 
0.3%
5 29
 
0.3%
6 34
 
0.3%
7 32
 
0.3%
8 24
 
0.2%
9 22
 
0.2%
ValueCountFrequency (%)
434535 1
< 0.1%
259784 1
< 0.1%
190799 1
< 0.1%
173707 1
< 0.1%
165035 1
< 0.1%
155864 1
< 0.1%
139605 1
< 0.1%
90930 1
< 0.1%
89779 1
< 0.1%
84998 1
< 0.1%

사용량
Real number (ℝ)

SKEWED  ZEROS 

Distinct248
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.8425
Minimum0
Maximum8662
Zeros1751
Zeros (%)17.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:59.228026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q12
median9
Q318
95-th percentile52
Maximum8662
Range8662
Interquartile range (IQR)16

Descriptive statistics

Standard deviation182.86553
Coefficient of variation (CV)7.6697296
Kurtosis1050.1948
Mean23.8425
Median Absolute Deviation (MAD)8
Skewness29.734438
Sum238425
Variance33439.801
MonotonicityNot monotonic
2024-01-10T07:30:59.339588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 1751
 
17.5%
1 457
 
4.6%
4 391
 
3.9%
7 381
 
3.8%
2 377
 
3.8%
5 374
 
3.7%
10 374
 
3.7%
6 347
 
3.5%
8 342
 
3.4%
9 342
 
3.4%
Other values (238) 4864
48.6%
ValueCountFrequency (%)
0 1751
17.5%
1 457
 
4.6%
2 377
 
3.8%
3 331
 
3.3%
4 391
 
3.9%
5 374
 
3.7%
6 347
 
3.5%
7 381
 
3.8%
8 342
 
3.4%
9 342
 
3.4%
ValueCountFrequency (%)
8662 1
< 0.1%
6440 1
< 0.1%
6316 1
< 0.1%
5442 1
< 0.1%
5273 1
< 0.1%
4769 1
< 0.1%
4520 1
< 0.1%
3283 1
< 0.1%
3039 1
< 0.1%
2792 1
< 0.1%

조정량
Real number (ℝ)

SKEWED  ZEROS 

Distinct247
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.7796
Minimum0
Maximum8662
Zeros1758
Zeros (%)17.6%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:59.450859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q12
median9
Q318
95-th percentile52
Maximum8662
Range8662
Interquartile range (IQR)16

Descriptive statistics

Standard deviation182.80455
Coefficient of variation (CV)7.6874527
Kurtosis1051.6372
Mean23.7796
Median Absolute Deviation (MAD)8
Skewness29.763488
Sum237796
Variance33417.504
MonotonicityNot monotonic
2024-01-10T07:30:59.566350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 1758
 
17.6%
1 456
 
4.6%
4 391
 
3.9%
7 381
 
3.8%
2 377
 
3.8%
5 374
 
3.7%
10 374
 
3.7%
6 346
 
3.5%
8 342
 
3.4%
9 342
 
3.4%
Other values (237) 4859
48.6%
ValueCountFrequency (%)
0 1758
17.6%
1 456
 
4.6%
2 377
 
3.8%
3 331
 
3.3%
4 391
 
3.9%
5 374
 
3.7%
6 346
 
3.5%
7 381
 
3.8%
8 342
 
3.4%
9 342
 
3.4%
ValueCountFrequency (%)
8662 1
< 0.1%
6440 1
< 0.1%
6316 1
< 0.1%
5442 1
< 0.1%
5273 1
< 0.1%
4769 1
< 0.1%
4520 1
< 0.1%
3283 1
< 0.1%
3039 1
< 0.1%
2792 1
< 0.1%

사용료
Real number (ℝ)

SKEWED  ZEROS 

Distinct426
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23501.237
Minimum0
Maximum15708960
Zeros1758
Zeros (%)17.6%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:59.680993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11220
median5490
Q311590
95-th percentile46500
Maximum15708960
Range15708960
Interquartile range (IQR)10370

Descriptive statistics

Standard deviation274589.35
Coefficient of variation (CV)11.684038
Kurtosis1803.5353
Mean23501.237
Median Absolute Deviation (MAD)4880
Skewness38.933827
Sum2.3501237 × 108
Variance7.5399312 × 1010
MonotonicityNot monotonic
2024-01-10T07:30:59.815920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 1758
 
17.6%
610 381
 
3.8%
4270 349
 
3.5%
6100 344
 
3.4%
2440 341
 
3.4%
3050 333
 
3.3%
4880 316
 
3.2%
3660 315
 
3.1%
1220 313
 
3.1%
5490 306
 
3.1%
Other values (416) 5244
52.4%
ValueCountFrequency (%)
0 1758
17.6%
610 381
 
3.8%
810 75
 
0.8%
1220 313
 
3.1%
1620 64
 
0.6%
1830 295
 
2.9%
2430 36
 
0.4%
2440 341
 
3.4%
3050 333
 
3.3%
3240 50
 
0.5%
ValueCountFrequency (%)
15708960 1
< 0.1%
11642700 1
< 0.1%
11415780 1
< 0.1%
8129100 1
< 0.1%
5865390 1
< 0.1%
4937580 1
< 0.1%
4236690 1
< 0.1%
3695010 1
< 0.1%
3329920 1
< 0.1%
3319620 1
< 0.1%

구경요금
Real number (ℝ)

Distinct9
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2754.592
Minimum0
Maximum86840
Zeros48
Zeros (%)0.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:59.923813image/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 deviation3555.2587
Coefficient of variation (CV)1.2906662
Kurtosis245.36257
Mean2754.592
Median Absolute Deviation (MAD)0
Skewness13.338218
Sum27545920
Variance12639864
MonotonicityNot monotonic
2024-01-10T07:31:00.009891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
2170 8947
89.5%
3990 581
 
5.8%
5950 191
 
1.9%
10760 81
 
0.8%
15610 80
 
0.8%
26140 55
 
0.5%
0 48
 
0.5%
54290 11
 
0.1%
86840 6
 
0.1%
ValueCountFrequency (%)
0 48
 
0.5%
2170 8947
89.5%
3990 581
 
5.8%
5950 191
 
1.9%
10760 81
 
0.8%
15610 80
 
0.8%
26140 55
 
0.5%
54290 11
 
0.1%
86840 6
 
0.1%
ValueCountFrequency (%)
86840 6
 
0.1%
54290 11
 
0.1%
26140 55
 
0.5%
15610 80
 
0.8%
10760 81
 
0.8%
5950 191
 
1.9%
3990 581
 
5.8%
2170 8947
89.5%
0 48
 
0.5%

감면액
Real number (ℝ)

SKEWED  ZEROS 

Distinct315
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-1112.989
Minimum-1271000
Maximum0
Zeros4364
Zeros (%)43.6%
Negative5636
Negative (%)56.4%
Memory size166.0 KiB
2024-01-10T07:31:00.121775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-1271000
5-th percentile-3040
Q1-100
median-20
Q30
95-th percentile0
Maximum0
Range1271000
Interquartile range (IQR)100

Descriptive statistics

Standard deviation19884.127
Coefficient of variation (CV)-17.86552
Kurtosis2764.1422
Mean-1112.989
Median Absolute Deviation (MAD)20
Skewness-49.133584
Sum-11129890
Variance3.9537852 × 108
MonotonicityNot monotonic
2024-01-10T07:31:00.263702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4364
43.6%
-40 467
 
4.7%
-30 447
 
4.5%
-10 429
 
4.3%
-60 413
 
4.1%
-70 373
 
3.7%
-90 313
 
3.1%
-100 237
 
2.4%
-50 225
 
2.2%
-20 224
 
2.2%
Other values (305) 2508
25.1%
ValueCountFrequency (%)
-1271000 1
< 0.1%
-1108500 1
< 0.1%
-587500 1
< 0.1%
-473900 1
< 0.1%
-429990 1
< 0.1%
-269690 1
< 0.1%
-256510 1
< 0.1%
-254310 1
< 0.1%
-198940 1
< 0.1%
-155100 1
< 0.1%
ValueCountFrequency (%)
0 4364
43.6%
-10 429
 
4.3%
-20 224
 
2.2%
-30 447
 
4.5%
-40 467
 
4.7%
-50 225
 
2.2%
-60 413
 
4.1%
-70 373
 
3.7%
-80 184
 
1.8%
-90 313
 
3.1%

정산액
Real number (ℝ)

SKEWED  ZEROS 

Distinct11
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24.918
Minimum-43800
Maximum262270
Zeros9990
Zeros (%)99.9%
Negative6
Negative (%)0.1%
Memory size166.0 KiB
2024-01-10T07:31:00.385802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation2684.9025
Coefficient of variation (CV)107.74952
Kurtosis9113.0575
Mean24.918
Median Absolute Deviation (MAD)0
Skewness92.884565
Sum249180
Variance7208701.4
MonotonicityNot monotonic
2024-01-10T07:31:00.473512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
0 9990
99.9%
-13200 1
 
< 0.1%
14870 1
 
< 0.1%
262270 1
 
< 0.1%
-1100 1
 
< 0.1%
-5190 1
 
< 0.1%
-5200 1
 
< 0.1%
-43800 1
 
< 0.1%
-2170 1
 
< 0.1%
18600 1
 
< 0.1%
ValueCountFrequency (%)
-43800 1
 
< 0.1%
-13200 1
 
< 0.1%
-5200 1
 
< 0.1%
-5190 1
 
< 0.1%
-2170 1
 
< 0.1%
-1100 1
 
< 0.1%
0 9990
99.9%
14870 1
 
< 0.1%
18600 1
 
< 0.1%
24100 1
 
< 0.1%
ValueCountFrequency (%)
262270 1
 
< 0.1%
24100 1
 
< 0.1%
18600 1
 
< 0.1%
14870 1
 
< 0.1%
0 9990
99.9%
-1100 1
 
< 0.1%
-2170 1
 
< 0.1%
-5190 1
 
< 0.1%
-5200 1
 
< 0.1%
-13200 1
 
< 0.1%

가산정산
Real number (ℝ)

SKEWED  ZEROS 

Distinct82
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-22.012
Minimum-117180
Maximum1220
Zeros9615
Zeros (%)96.2%
Negative384
Negative (%)3.8%
Memory size166.0 KiB
2024-01-10T07:31:00.599060image/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 deviation1183.2251
Coefficient of variation (CV)-53.753641
Kurtosis9617.5315
Mean-22.012
Median Absolute Deviation (MAD)0
Skewness-97.26382
Sum-220120
Variance1400021.8
MonotonicityNot monotonic
2024-01-10T07:31:00.713276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9615
96.2%
-20 35
 
0.4%
-50 24
 
0.2%
-10 22
 
0.2%
-30 21
 
0.2%
-40 20
 
0.2%
-120 15
 
0.1%
-100 15
 
0.1%
-60 15
 
0.1%
-80 13
 
0.1%
Other values (72) 205
 
2.1%
ValueCountFrequency (%)
-117180 1
< 0.1%
-13490 1
< 0.1%
-3970 1
< 0.1%
-3160 1
< 0.1%
-2780 1
< 0.1%
-2520 1
< 0.1%
-2140 1
< 0.1%
-1870 1
< 0.1%
-1750 1
< 0.1%
-1690 1
< 0.1%
ValueCountFrequency (%)
1220 1
 
< 0.1%
0 9615
96.2%
-10 22
 
0.2%
-20 35
 
0.4%
-30 21
 
0.2%
-40 20
 
0.2%
-50 24
 
0.2%
-60 15
 
0.1%
-70 10
 
0.1%
-80 13
 
0.1%

소계
Real number (ℝ)

SKEWED  ZEROS 

Distinct1304
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25145.746
Minimum0
Maximum15758250
Zeros304
Zeros (%)3.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:31:00.827165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2170
Q13380
median7610
Q313650
95-th percentile50433
Maximum15758250
Range15758250
Interquartile range (IQR)10270

Descriptive statistics

Standard deviation271791.5
Coefficient of variation (CV)10.808647
Kurtosis1901.0534
Mean25145.746
Median Absolute Deviation (MAD)4830
Skewness40.156621
Sum2.5145746 × 108
Variance7.3870618 × 1010
MonotonicityNot monotonic
2024-01-10T07:31:00.958398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2170 1607
 
16.1%
2780 325
 
3.2%
0 304
 
3.0%
3990 259
 
2.6%
6400 224
 
2.2%
8210 220
 
2.2%
5190 217
 
2.2%
7010 211
 
2.1%
3380 206
 
2.1%
7610 205
 
2.1%
Other values (1294) 6222
62.2%
ValueCountFrequency (%)
0 304
3.0%
830 1
 
< 0.1%
840 6
 
0.1%
1520 1
 
< 0.1%
1670 1
 
< 0.1%
1680 3
 
< 0.1%
2030 1
 
< 0.1%
2040 1
 
< 0.1%
2080 2
 
< 0.1%
2090 2
 
< 0.1%
ValueCountFrequency (%)
15758250 1
< 0.1%
11729540 1
< 0.1%
11441920 1
< 0.1%
8215940 1
< 0.1%
5914680 1
< 0.1%
4874690 1
< 0.1%
3370110 1
< 0.1%
2991830 1
< 0.1%
2977530 1
< 0.1%
2966830 1
< 0.1%

하수도
Real number (ℝ)

SKEWED  ZEROS 

Distinct454
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2657.756
Minimum0
Maximum1866600
Zeros7435
Zeros (%)74.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:31:01.099883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q3240
95-th percentile7360
Maximum1866600
Range1866600
Interquartile range (IQR)240

Descriptive statistics

Standard deviation33946.747
Coefficient of variation (CV)12.77271
Kurtosis1570.7043
Mean2657.756
Median Absolute Deviation (MAD)0
Skewness36.662197
Sum26577560
Variance1.1523817 × 109
MonotonicityNot monotonic
2024-01-10T07:31:01.229383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 7435
74.4%
1440 93
 
0.9%
2400 89
 
0.9%
1920 85
 
0.9%
1680 77
 
0.8%
2160 72
 
0.7%
1200 71
 
0.7%
3120 64
 
0.6%
3360 64
 
0.6%
240 64
 
0.6%
Other values (444) 1886
 
18.9%
ValueCountFrequency (%)
0 7435
74.4%
200 7
 
0.1%
210 1
 
< 0.1%
220 3
 
< 0.1%
230 1
 
< 0.1%
240 64
 
0.6%
290 8
 
0.1%
310 33
 
0.3%
440 12
 
0.1%
460 2
 
< 0.1%
ValueCountFrequency (%)
1866600 1
< 0.1%
1304960 1
< 0.1%
1192080 1
< 0.1%
1144560 1
< 0.1%
1131980 1
< 0.1%
784470 1
< 0.1%
575340 1
< 0.1%
432630 1
< 0.1%
403520 1
< 0.1%
361360 1
< 0.1%

물부담금
Real number (ℝ)

SKEWED  ZEROS 

Distinct252
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1958.791
Minimum0
Maximum1472540
Zeros6587
Zeros (%)65.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:31:01.374835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation25727.617
Coefficient of variation (CV)13.134437
Kurtosis1829.1395
Mean1958.791
Median Absolute Deviation (MAD)0
Skewness39.51848
Sum19587910
Variance6.6191026 × 108
MonotonicityNot monotonic
2024-01-10T07:31:01.496606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 6587
65.9%
170 205
 
2.1%
680 169
 
1.7%
1190 169
 
1.7%
1700 163
 
1.6%
340 156
 
1.6%
850 152
 
1.5%
1360 144
 
1.4%
1020 141
 
1.4%
1530 134
 
1.3%
Other values (242) 1980
 
19.8%
ValueCountFrequency (%)
0 6587
65.9%
160 3
 
< 0.1%
170 205
 
2.1%
320 1
 
< 0.1%
330 5
 
0.1%
340 156
 
1.6%
480 1
 
< 0.1%
500 1
 
< 0.1%
510 121
 
1.2%
650 3
 
< 0.1%
ValueCountFrequency (%)
1472540 1
< 0.1%
1094800 1
< 0.1%
1073720 1
< 0.1%
768400 1
< 0.1%
558110 1
< 0.1%
516630 1
< 0.1%
472940 1
< 0.1%
356490 1
< 0.1%
285260 1
< 0.1%
261630 1
< 0.1%

조정일
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-08
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-12-08
2nd row2023-12-08
3rd row2023-12-08
4th row2023-12-08
5th row2023-12-08

Common Values

ValueCountFrequency (%)
2023-12-08 10000
100.0%

Length

2024-01-10T07:31:01.619876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:31:01.698810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12-08 10000
100.0%

납기후금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct1961
Distinct (%)19.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean30668.724
Minimum0
Maximum17747690
Zeros275
Zeros (%)2.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:31:01.783590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2230
Q13480
median9080
Q316850
95-th percentile62390.5
Maximum17747690
Range17747690
Interquartile range (IQR)13370

Descriptive statistics

Standard deviation316324.55
Coefficient of variation (CV)10.314239
Kurtosis1690.3164
Mean30668.724
Median Absolute Deviation (MAD)6060
Skewness37.57737
Sum3.0668724 × 108
Variance1.0006122 × 1011
MonotonicityNot monotonic
2024-01-10T07:31:01.925958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2230 1546
 
15.5%
0 275
 
2.8%
4100 151
 
1.5%
2850 135
 
1.4%
3020 127
 
1.3%
5340 108
 
1.1%
6580 107
 
1.1%
7830 104
 
1.0%
3470 103
 
1.0%
8450 93
 
0.9%
Other values (1951) 7251
72.5%
ValueCountFrequency (%)
0 275
2.8%
240 4
 
< 0.1%
450 1
 
< 0.1%
740 1
 
< 0.1%
850 1
 
< 0.1%
860 6
 
0.1%
950 1
 
< 0.1%
1230 2
 
< 0.1%
1580 1
 
< 0.1%
1710 1
 
< 0.1%
ValueCountFrequency (%)
17747690 1
< 0.1%
13209060 1
< 0.1%
12891100 1
< 0.1%
9253860 1
< 0.1%
6948370 1
< 0.1%
6666960 1
< 0.1%
4815300 1
< 0.1%
4526580 1
< 0.1%
4248370 1
< 0.1%
4234720 1
< 0.1%

Sample

납기일고지구분이체구분합계검침주기조정구분구경업종가구수전월지침당월지침사용량조정량사용료구경요금감면액정산액가산정산소계하수도물부담금조정일납기후금액
106292023-12-31정기자동21660매월검침정상조정13가정용197810022424155602170-1500017580040802023-12-0822300
146582023-12-31정기자동6820매월검침정상조정13가정용13193256636602170-30005800010202023-12-087010
67702023-12-31정기OCR139910매월검침정상조정40일반용138403925858589900156100001055103440002023-12-08144090
181682023-12-31정기자동9420매월검침정상조정13가정용1308320121273202170-70009420002023-12-089690
211072023-12-31정기OCR8270매월검침정상조정13가정용1118011901010610021700008270002023-12-088510
94722023-12-31정기자동7610매월검침정상조정13가정용11551649954902170-50007610002023-12-087830
177852023-12-31정기자동11230매월검침정상조정13가정용1471486151591502170-900011230002023-12-0811560
161312023-12-31정기자동2950매월검침정상조정13가정용11213116102170000278001702023-12-083020
8872023-12-31정기OCR12370매월검침정상조정13가정용16726821010610021700008270240017002023-12-0812730
37292023-12-31정기자동5220매월검침정상조정13가정용19209233318302170-100039907205102023-12-085360
납기일고지구분이체구분합계검침주기조정구분구경업종가구수전월지침당월지침사용량조정량사용료구경요금감면액정산액가산정산소계하수도물부담금조정일납기후금액
197012023-12-31정기자동5800매월검침정상조정13가정용11851916636602170-30005800002023-12-085960
76772023-12-31정기자동8210매월검침정상조정13가정용1254264101061002170-60008210002023-12-088450
195992023-12-31정기OCR16050매월검침정상조정13가정용1497519222213880217000016050002023-12-0816520
202922023-12-31정기OCR31300매월검침정상조정20일반용119752006313127310399000031300002023-12-0832220
59642023-12-31정기OCR3020매월검침정상조정13가정용12223116102170000278024002023-12-083090
82462023-12-31정기자동3380매월검침정상조정13가정용11771792212202170-10003380002023-12-083470
8352023-12-31정기자동2170매월검침정상조정13일반용16600021700002170002023-12-082230
113242023-12-31정기자동11590매월검침정상조정13가정용122862302161697602170-3060008870027202023-12-0811930
91602023-12-31정기OCR12170매월검침정상조정13가정용1464481171710370217000-37012170002023-12-0812540
128172023-12-31정기OCR2170매월검침정상조정13가정용15500021700002170002023-12-082230

Duplicate rows

Most frequently occurring

납기일고지구분이체구분합계검침주기조정구분구경업종가구수전월지침당월지침사용량조정량사용료구경요금감면액정산액가산정산소계하수도물부담금조정일납기후금액# duplicates
922023-12-31정기자동2170매월검침정상조정13가정용13300021700002170002023-12-082230195
112023-12-31정기OCR2170매월검침정상조정13가정용13300021700002170002023-12-08223086
902023-12-31정기자동2170매월검침정상조정13가정용11100021700002170002023-12-08223052
912023-12-31정기자동2170매월검침정상조정13가정용12200021700002170002023-12-08223035
962023-12-31정기자동2170매월검침정상조정13가정용17700021700002170002023-12-08223021
952023-12-31정기자동2170매월검침정상조정13가정용16600021700002170002023-12-08223015
932023-12-31정기자동2170매월검침정상조정13가정용14400021700002170002023-12-08223014
92023-12-31정기OCR2170매월검침정상조정13가정용11100021700002170002023-12-08223012
942023-12-31정기자동2170매월검침정상조정13가정용15500021700002170002023-12-08223012
892023-12-31정기자동2170매월검침정상조정13가정용10000021700002170002023-12-08223011