Overview

Dataset statistics

Number of variables23
Number of observations10000
Missing cells28
Missing cells (%)< 0.1%
Duplicate rows336
Duplicate rows (%)3.4%
Total size in memory2.0 MiB
Average record size in memory209.0 B

Variable types

DateTime1
Categorical6
Numeric16

Alerts

납기일 has constant value ""Constant
Dataset has 336 (3.4%) duplicate rowsDuplicates
고지구분 is highly imbalanced (99.0%)Imbalance
검침주기 is highly imbalanced (97.2%)Imbalance
조정구분 is highly imbalanced (97.2%)Imbalance
업종 is highly imbalanced (74.6%)Imbalance
정산액 is highly imbalanced (99.7%)Imbalance
합계 is highly skewed (γ1 = 35.61139617)Skewed
가구수 is highly skewed (γ1 = 35.14405535)Skewed
전월지침 is highly skewed (γ1 = 55.44301268)Skewed
당월지침 is highly skewed (γ1 = 55.00008659)Skewed
사용량 is highly skewed (γ1 = 33.87552398)Skewed
조정량 is highly skewed (γ1 = 33.87525976)Skewed
사용료 is highly skewed (γ1 = 46.86649192)Skewed
구경요금 is highly skewed (γ1 = 29.5465295)Skewed
감면액 is highly skewed (γ1 = -69.36703618)Skewed
가산정산 is highly skewed (γ1 = -89.71536197)Skewed
소계 is highly skewed (γ1 = 38.37428835)Skewed
하수도 is highly skewed (γ1 = 35.64481108)Skewed
물부담금 is highly skewed (γ1 = 47.44982665)Skewed
조정일 is highly skewed (γ1 = 54.38676764)Skewed
납기후금액 is highly skewed (γ1 = 35.61134857)Skewed
합계 has 252 (2.5%) zerosZeros
사용량 has 1838 (18.4%) zerosZeros
조정량 has 1848 (18.5%) zerosZeros
사용료 has 1849 (18.5%) zerosZeros
감면액 has 4627 (46.3%) zerosZeros
가산정산 has 9567 (95.7%) zerosZeros
소계 has 274 (2.7%) zerosZeros
하수도 has 7342 (73.4%) zerosZeros
물부담금 has 6531 (65.3%) zerosZeros
납기후금액 has 252 (2.5%) zerosZeros

Reproduction

Analysis started2024-01-09 22:30:49.269908
Analysis finished2024-01-09 22:30:49.727663
Duration0.46 seconds
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-01-31 00:00:00
Maximum2023-01-31 00:00:00
2024-01-10T07:30:49.764140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:30:49.844592image/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
정기
9991 
수시
 
9

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 (%)
정기 9991
99.9%
수시 9
 
0.1%

Length

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

Common Values (Plot)

2024-01-10T07:30:50.014605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정기 9991
99.9%
수시 9
 
0.1%

이체구분
Categorical

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

Length

Max length3
Median length2
Mean length2.3689
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
자동 6311
63.1%
OCR 3689
36.9%

Length

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

Common Values (Plot)

2024-01-10T07:30:50.200862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자동 6311
63.1%
ocr 3689
36.9%

합계
Real number (ℝ)

SKEWED  ZEROS 

Distinct1863
Distinct (%)18.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28584.806
Minimum0
Maximum15561720
Zeros252
Zeros (%)2.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:50.326265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2170
Q13430
median8820
Q316110
95-th percentile55542
Maximum15561720
Range15561720
Interquartile range (IQR)12680

Descriptive statistics

Standard deviation281056.46
Coefficient of variation (CV)9.8323723
Kurtosis1544.2736
Mean28584.806
Median Absolute Deviation (MAD)5870
Skewness35.611396
Sum2.8584806 × 108
Variance7.8992731 × 1010
MonotonicityNot monotonic
2024-01-10T07:30:50.468119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2170 1599
 
16.0%
0 252
 
2.5%
3990 147
 
1.5%
2780 126
 
1.3%
2950 110
 
1.1%
8210 95
 
0.9%
5800 89
 
0.9%
6400 89
 
0.9%
7010 88
 
0.9%
5190 84
 
0.8%
Other values (1853) 7321
73.2%
ValueCountFrequency (%)
0 252
2.5%
360 1
 
< 0.1%
480 1
 
< 0.1%
720 2
 
< 0.1%
760 1
 
< 0.1%
840 2
 
< 0.1%
1610 1
 
< 0.1%
1620 1
 
< 0.1%
1670 1
 
< 0.1%
1680 1
 
< 0.1%
ValueCountFrequency (%)
15561720 1
< 0.1%
11783490 1
< 0.1%
9853640 1
< 0.1%
7627110 1
< 0.1%
7616540 1
< 0.1%
6143970 1
< 0.1%
4783210 1
< 0.1%
4700540 1
< 0.1%
4038590 1
< 0.1%
3662190 1
< 0.1%

검침주기
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
매월검침
9972 
<NA>
 
28

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 (%)
매월검침 9972
99.7%
<NA> 28
 
0.3%

Length

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

Common Values (Plot)

2024-01-10T07:30:50.684036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
매월검침 9972
99.7%
na 28
 
0.3%

조정구분
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
정상조정
9972 
<NA>
 
28

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 (%)
정상조정 9972
99.7%
<NA> 28
 
0.3%

Length

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

Common Values (Plot)

2024-01-10T07:30:50.881791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상조정 9972
99.7%
na 28
 
0.3%

구경
Real number (ℝ)

Distinct9
Distinct (%)0.1%
Missing28
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean14.306659
Minimum13
Maximum200
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:50.954154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation5.5682618
Coefficient of variation (CV)0.38920771
Kurtosis179.31272
Mean14.306659
Median Absolute Deviation (MAD)0
Skewness9.6126435
Sum142666
Variance31.00554
MonotonicityNot monotonic
2024-01-10T07:30:51.069930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
13 8986
89.9%
20 579
 
5.8%
25 184
 
1.8%
32 79
 
0.8%
40 76
 
0.8%
50 50
 
0.5%
75 12
 
0.1%
100 5
 
0.1%
200 1
 
< 0.1%
(Missing) 28
 
0.3%
ValueCountFrequency (%)
13 8986
89.9%
20 579
 
5.8%
25 184
 
1.8%
32 79
 
0.8%
40 76
 
0.8%
50 50
 
0.5%
75 12
 
0.1%
100 5
 
0.1%
200 1
 
< 0.1%
ValueCountFrequency (%)
200 1
 
< 0.1%
100 5
 
0.1%
75 12
 
0.1%
50 50
 
0.5%
40 76
 
0.8%
32 79
 
0.8%
25 184
 
1.8%
20 579
 
5.8%
13 8986
89.9%

업종
Categorical

IMBALANCE 

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
가정용
8331 
일반용
1584 
일반혼합
 
38
<NA>
 
28
일반용2
 
12
Other values (2)
 
7

Length

Max length4
Median length3
Mean length3.0083
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
가정용 8331
83.3%
일반용 1584
 
15.8%
일반혼합 38
 
0.4%
<NA> 28
 
0.3%
일반용2 12
 
0.1%
대중탕용 5
 
0.1%
공업용 2
 
< 0.1%

Length

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

Common Values (Plot)

2024-01-10T07:30:51.285380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가정용 8331
83.3%
일반용 1584
 
15.8%
일반혼합 38
 
0.4%
na 28
 
0.3%
일반용2 12
 
0.1%
대중탕용 5
 
< 0.1%
공업용 2
 
< 0.1%

가구수
Real number (ℝ)

SKEWED 

Distinct30
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.2656
Minimum0
Maximum323
Zeros28
Zeros (%)0.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:51.387131image/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.7503936
Coefficient of variation (CV)5.3337497
Kurtosis1333.0211
Mean1.2656
Median Absolute Deviation (MAD)0
Skewness35.144055
Sum12656
Variance45.567813
MonotonicityNot monotonic
2024-01-10T07:30:51.488726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
1 9790
97.9%
2 78
 
0.8%
3 30
 
0.3%
0 28
 
0.3%
4 21
 
0.2%
5 11
 
0.1%
6 10
 
0.1%
8 6
 
0.1%
16 3
 
< 0.1%
252 2
 
< 0.1%
Other values (20) 21
 
0.2%
ValueCountFrequency (%)
0 28
 
0.3%
1 9790
97.9%
2 78
 
0.8%
3 30
 
0.3%
4 21
 
0.2%
5 11
 
0.1%
6 10
 
0.1%
8 6
 
0.1%
9 1
 
< 0.1%
10 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%
99 1
< 0.1%
82 1
< 0.1%
71 1
< 0.1%

전월지침
Real number (ℝ)

SKEWED 

Distinct2592
Distinct (%)25.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1124.0396
Minimum0
Maximum583977
Zeros62
Zeros (%)0.6%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:51.602805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3
Q1131
median428
Q3968
95-th percentile3310
Maximum583977
Range583977
Interquartile range (IQR)837

Descriptive statistics

Standard deviation7408.7939
Coefficient of variation (CV)6.5912214
Kurtosis4001.3617
Mean1124.0396
Median Absolute Deviation (MAD)354
Skewness55.443013
Sum11240396
Variance54890227
MonotonicityNot monotonic
2024-01-10T07:30:51.735024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3 403
 
4.0%
1 98
 
1.0%
0 62
 
0.6%
2 58
 
0.6%
6 41
 
0.4%
4 38
 
0.4%
8 35
 
0.4%
18 32
 
0.3%
9 31
 
0.3%
5 30
 
0.3%
Other values (2582) 9172
91.7%
ValueCountFrequency (%)
0 62
 
0.6%
1 98
 
1.0%
2 58
 
0.6%
3 403
4.0%
4 38
 
0.4%
5 30
 
0.3%
6 41
 
0.4%
7 25
 
0.2%
8 35
 
0.4%
9 31
 
0.3%
ValueCountFrequency (%)
583977 1
< 0.1%
245147 1
< 0.1%
174940 1
< 0.1%
131278 1
< 0.1%
112792 1
< 0.1%
84454 1
< 0.1%
84365 1
< 0.1%
78637 1
< 0.1%
73140 1
< 0.1%
70161 1
< 0.1%

당월지침
Real number (ℝ)

SKEWED 

Distinct2596
Distinct (%)26.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1144.5584
Minimum0
Maximum592273
Zeros60
Zeros (%)0.6%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:51.864866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3
Q1138.75
median439
Q3984
95-th percentile3370.25
Maximum592273
Range592273
Interquartile range (IQR)845.25

Descriptive statistics

Standard deviation7537.7724
Coefficient of variation (CV)6.5857473
Kurtosis3950.5057
Mean1144.5584
Median Absolute Deviation (MAD)359
Skewness55.000087
Sum11445584
Variance56818013
MonotonicityNot monotonic
2024-01-10T07:30:51.989163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3 358
 
3.6%
1 95
 
0.9%
0 60
 
0.6%
2 55
 
0.5%
6 40
 
0.4%
9 37
 
0.4%
5 34
 
0.3%
8 32
 
0.3%
4 31
 
0.3%
7 27
 
0.3%
Other values (2586) 9231
92.3%
ValueCountFrequency (%)
0 60
 
0.6%
1 95
 
0.9%
2 55
 
0.5%
3 358
3.6%
4 31
 
0.3%
5 34
 
0.3%
6 40
 
0.4%
7 27
 
0.3%
8 32
 
0.3%
9 37
 
0.4%
ValueCountFrequency (%)
592273 1
< 0.1%
246088 1
< 0.1%
179935 1
< 0.1%
136806 1
< 0.1%
117496 1
< 0.1%
88039 1
< 0.1%
87826 1
< 0.1%
83622 1
< 0.1%
73478 1
< 0.1%
70219 1
< 0.1%

사용량
Real number (ℝ)

SKEWED  ZEROS 

Distinct236
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.7657
Minimum0
Maximum10779
Zeros1838
Zeros (%)18.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:52.141849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q12
median9
Q318
95-th percentile50
Maximum10779
Range10779
Interquartile range (IQR)16

Descriptive statistics

Standard deviation196.39227
Coefficient of variation (CV)8.2636854
Kurtosis1437.1071
Mean23.7657
Median Absolute Deviation (MAD)8
Skewness33.875524
Sum237657
Variance38569.923
MonotonicityNot monotonic
2024-01-10T07:30:52.262586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 1838
 
18.4%
1 406
 
4.1%
10 395
 
4.0%
5 388
 
3.9%
7 381
 
3.8%
8 376
 
3.8%
6 374
 
3.7%
4 350
 
3.5%
3 343
 
3.4%
12 330
 
3.3%
Other values (226) 4819
48.2%
ValueCountFrequency (%)
0 1838
18.4%
1 406
 
4.1%
2 320
 
3.2%
3 343
 
3.4%
4 350
 
3.5%
5 388
 
3.9%
6 374
 
3.7%
7 381
 
3.8%
8 376
 
3.8%
9 324
 
3.2%
ValueCountFrequency (%)
10779 1
< 0.1%
8296 1
< 0.1%
5528 1
< 0.1%
4995 1
< 0.1%
4985 1
< 0.1%
4704 1
< 0.1%
3877 1
< 0.1%
3585 1
< 0.1%
3461 1
< 0.1%
2865 1
< 0.1%

조정량
Real number (ℝ)

SKEWED  ZEROS 

Distinct236
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.7574
Minimum0
Maximum10779
Zeros1848
Zeros (%)18.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:52.394997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q12
median9
Q318
95-th percentile50
Maximum10779
Range10779
Interquartile range (IQR)16

Descriptive statistics

Standard deviation196.39302
Coefficient of variation (CV)8.2666041
Kurtosis1437.0907
Mean23.7574
Median Absolute Deviation (MAD)8
Skewness33.87526
Sum237574
Variance38570.219
MonotonicityNot monotonic
2024-01-10T07:30:52.805593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 1848
 
18.5%
1 407
 
4.1%
10 395
 
4.0%
5 387
 
3.9%
7 381
 
3.8%
8 375
 
3.8%
6 374
 
3.7%
4 349
 
3.5%
3 341
 
3.4%
12 330
 
3.3%
Other values (226) 4813
48.1%
ValueCountFrequency (%)
0 1848
18.5%
1 407
 
4.1%
2 318
 
3.2%
3 341
 
3.4%
4 349
 
3.5%
5 387
 
3.9%
6 374
 
3.7%
7 381
 
3.8%
8 375
 
3.8%
9 323
 
3.2%
ValueCountFrequency (%)
10779 1
< 0.1%
8296 1
< 0.1%
5528 1
< 0.1%
4995 1
< 0.1%
4985 1
< 0.1%
4704 1
< 0.1%
3877 1
< 0.1%
3585 1
< 0.1%
3461 1
< 0.1%
2865 1
< 0.1%

사용료
Real number (ℝ)

SKEWED  ZEROS 

Distinct398
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23148.772
Minimum0
Maximum19583070
Zeros1849
Zeros (%)18.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:52.945399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11220
median5580
Q311590
95-th percentile42502.5
Maximum19583070
Range19583070
Interquartile range (IQR)10370

Descriptive statistics

Standard deviation297657.45
Coefficient of variation (CV)12.858455
Kurtosis2643.0765
Mean23148.772
Median Absolute Deviation (MAD)4790
Skewness46.866492
Sum2.3148772 × 108
Variance8.8599955 × 1010
MonotonicityNot monotonic
2024-01-10T07:30:53.099166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 1849
 
18.5%
3050 354
 
3.5%
6100 349
 
3.5%
4880 342
 
3.4%
3660 338
 
3.4%
4270 336
 
3.4%
610 336
 
3.4%
1830 309
 
3.1%
2440 305
 
3.0%
7320 300
 
3.0%
Other values (388) 5182
51.8%
ValueCountFrequency (%)
0 1849
18.5%
610 336
 
3.4%
810 71
 
0.7%
1220 268
 
2.7%
1620 50
 
0.5%
1830 309
 
3.1%
2430 32
 
0.3%
2440 305
 
3.0%
3050 354
 
3.5%
3240 45
 
0.4%
ValueCountFrequency (%)
19583070 1
< 0.1%
15039180 1
< 0.1%
8980050 1
< 0.1%
6952410 1
< 0.1%
5100450 1
< 0.1%
4390410 1
< 0.1%
3467200 1
< 0.1%
3372080 1
< 0.1%
3046950 1
< 0.1%
2869440 1
< 0.1%

구경요금
Real number (ℝ)

SKEWED 

Distinct10
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2757.65
Minimum0
Maximum268830
Zeros40
Zeros (%)0.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:53.204465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation4348.987
Coefficient of variation (CV)1.5770627
Kurtosis1497.4489
Mean2757.65
Median Absolute Deviation (MAD)0
Skewness29.546529
Sum27576500
Variance18913688
MonotonicityNot monotonic
2024-01-10T07:30:53.306245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
2170 8974
89.7%
3990 579
 
5.8%
5950 184
 
1.8%
10760 79
 
0.8%
15610 76
 
0.8%
26140 50
 
0.5%
0 40
 
0.4%
54290 12
 
0.1%
86840 5
 
0.1%
268830 1
 
< 0.1%
ValueCountFrequency (%)
0 40
 
0.4%
2170 8974
89.7%
3990 579
 
5.8%
5950 184
 
1.8%
10760 79
 
0.8%
15610 76
 
0.8%
26140 50
 
0.5%
54290 12
 
0.1%
86840 5
 
0.1%
268830 1
 
< 0.1%
ValueCountFrequency (%)
268830 1
 
< 0.1%
86840 5
 
0.1%
54290 12
 
0.1%
26140 50
 
0.5%
15610 76
 
0.8%
10760 79
 
0.8%
5950 184
 
1.8%
3990 579
 
5.8%
2170 8974
89.7%
0 40
 
0.4%

감면액
Real number (ℝ)

SKEWED  ZEROS 

Distinct281
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-1993.099
Minimum-5879920
Maximum0
Zeros4627
Zeros (%)46.3%
Negative5373
Negative (%)53.7%
Memory size166.0 KiB
2024-01-10T07:30:53.421667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-5879920
5-th percentile-3010
Q1-90
median-10
Q30
95-th percentile0
Maximum0
Range5879920
Interquartile range (IQR)90

Descriptive statistics

Standard deviation75262.939
Coefficient of variation (CV)-37.761766
Kurtosis5011.3374
Mean-1993.099
Median Absolute Deviation (MAD)10
Skewness-69.367036
Sum-19930990
Variance5.66451 × 109
MonotonicityNot monotonic
2024-01-10T07:30:53.545380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4627
46.3%
-40 459
 
4.6%
-30 457
 
4.6%
-60 412
 
4.1%
-10 389
 
3.9%
-70 371
 
3.7%
-90 293
 
2.9%
-100 242
 
2.4%
-80 214
 
2.1%
-20 202
 
2.0%
Other values (271) 2334
23.3%
ValueCountFrequency (%)
-5879920 1
< 0.1%
-4511750 1
< 0.1%
-706080 1
< 0.1%
-583710 1
< 0.1%
-474800 1
< 0.1%
-431580 1
< 0.1%
-325620 1
< 0.1%
-306470 1
< 0.1%
-245190 1
< 0.1%
-223360 1
< 0.1%
ValueCountFrequency (%)
0 4627
46.3%
-10 389
 
3.9%
-20 202
 
2.0%
-30 457
 
4.6%
-40 459
 
4.6%
-50 200
 
2.0%
-60 412
 
4.1%
-70 371
 
3.7%
-80 214
 
2.1%
-90 293
 
2.9%

정산액
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9996 
-4590
 
1
-1810
 
1
2230
 
1
-5190
 
1

Length

Max length5
Median length1
Mean length1.0015
Min length1

Unique

Unique4 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
0 9996
> 99.9%
-4590 1
 
< 0.1%
-1810 1
 
< 0.1%
2230 1
 
< 0.1%
-5190 1
 
< 0.1%

Length

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

Common Values (Plot)

2024-01-10T07:30:53.777122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9996
> 99.9%
4590 1
 
< 0.1%
1810 1
 
< 0.1%
2230 1
 
< 0.1%
5190 1
 
< 0.1%

가산정산
Real number (ℝ)

SKEWED  ZEROS 

Distinct83
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-13.743
Minimum-40190
Maximum870
Zeros9567
Zeros (%)95.7%
Negative432
Negative (%)4.3%
Memory size166.0 KiB
2024-01-10T07:30:53.880433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-40190
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum870
Range41060
Interquartile range (IQR)0

Descriptive statistics

Standard deviation417.60874
Coefficient of variation (CV)-30.387014
Kurtosis8577.5327
Mean-13.743
Median Absolute Deviation (MAD)0
Skewness-89.715362
Sum-137430
Variance174397.06
MonotonicityNot monotonic
2024-01-10T07:30:54.011407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9567
95.7%
-40 39
 
0.4%
-60 36
 
0.4%
-20 35
 
0.4%
-30 34
 
0.3%
-10 28
 
0.3%
-50 23
 
0.2%
-80 16
 
0.2%
-90 13
 
0.1%
-120 11
 
0.1%
Other values (73) 198
 
2.0%
ValueCountFrequency (%)
-40190 1
< 0.1%
-6660 1
< 0.1%
-3990 1
< 0.1%
-2920 1
< 0.1%
-2860 1
< 0.1%
-2680 1
< 0.1%
-2500 1
< 0.1%
-1950 1
< 0.1%
-1470 1
< 0.1%
-1230 1
< 0.1%
ValueCountFrequency (%)
870 1
 
< 0.1%
0 9567
95.7%
-10 28
 
0.3%
-20 35
 
0.4%
-30 34
 
0.3%
-40 39
 
0.4%
-50 23
 
0.2%
-60 36
 
0.4%
-70 10
 
0.1%
-80 16
 
0.2%

소계
Real number (ℝ)

SKEWED  ZEROS 

Distinct1251
Distinct (%)12.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23898.644
Minimum0
Maximum13729290
Zeros274
Zeros (%)2.7%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:54.139893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2170
Q13380
median7610
Q313650
95-th percentile46700
Maximum13729290
Range13729290
Interquartile range (IQR)10270

Descriptive statistics

Standard deviation240133.56
Coefficient of variation (CV)10.048
Kurtosis1778.9144
Mean23898.644
Median Absolute Deviation (MAD)4830
Skewness38.374288
Sum2.3898644 × 108
Variance5.7664128 × 1010
MonotonicityNot monotonic
2024-01-10T07:30:54.265030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2170 1644
 
16.4%
2780 290
 
2.9%
0 274
 
2.7%
3990 264
 
2.6%
8210 232
 
2.3%
5800 216
 
2.2%
5190 214
 
2.1%
7010 213
 
2.1%
6400 209
 
2.1%
9420 191
 
1.9%
Other values (1241) 6253
62.5%
ValueCountFrequency (%)
0 274
2.7%
360 1
 
< 0.1%
600 1
 
< 0.1%
840 1
 
< 0.1%
1610 1
 
< 0.1%
1620 1
 
< 0.1%
1670 1
 
< 0.1%
1680 1
 
< 0.1%
1830 1
 
< 0.1%
1920 1
 
< 0.1%
ValueCountFrequency (%)
13729290 1
< 0.1%
10796260 1
< 0.1%
9006190 1
< 0.1%
6968020 1
< 0.1%
5154740 1
< 0.1%
4444700 1
< 0.1%
3477810 1
< 0.1%
3374820 1
< 0.1%
3001940 1
< 0.1%
2909630 1
< 0.1%

하수도
Real number (ℝ)

SKEWED  ZEROS 

Distinct464
Distinct (%)4.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2810.42
Minimum0
Maximum1974750
Zeros7342
Zeros (%)73.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:54.400236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q3480
95-th percentile7040
Maximum1974750
Range1974750
Interquartile range (IQR)480

Descriptive statistics

Standard deviation38547.135
Coefficient of variation (CV)13.715792
Kurtosis1460.6064
Mean2810.42
Median Absolute Deviation (MAD)0
Skewness35.644811
Sum28104200
Variance1.4858816 × 109
MonotonicityNot monotonic
2024-01-10T07:30:54.550168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 7342
73.4%
1920 105
 
1.1%
1200 98
 
1.0%
2880 93
 
0.9%
1680 92
 
0.9%
2400 89
 
0.9%
1440 79
 
0.8%
720 73
 
0.7%
2160 68
 
0.7%
3120 65
 
0.7%
Other values (454) 1896
 
19.0%
ValueCountFrequency (%)
0 7342
73.4%
180 1
 
< 0.1%
200 5
 
0.1%
210 1
 
< 0.1%
220 5
 
0.1%
230 1
 
< 0.1%
240 56
 
0.6%
280 1
 
< 0.1%
290 6
 
0.1%
310 36
 
0.4%
ValueCountFrequency (%)
1974750 1
< 0.1%
1699270 1
< 0.1%
1325720 1
< 0.1%
1305400 1
< 0.1%
1128960 1
< 0.1%
857400 1
< 0.1%
829640 1
< 0.1%
651760 1
< 0.1%
451200 1
< 0.1%
430500 1
< 0.1%

물부담금
Real number (ℝ)

SKEWED  ZEROS 

Distinct250
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1857.732
Minimum0
Maximum1832430
Zeros6531
Zeros (%)65.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:54.705928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31020
95-th percentile4590
Maximum1832430
Range1832430
Interquartile range (IQR)1020

Descriptive statistics

Standard deviation26254.988
Coefficient of variation (CV)14.132818
Kurtosis2774.4028
Mean1857.732
Median Absolute Deviation (MAD)0
Skewness47.449827
Sum18577320
Variance6.8932438 × 108
MonotonicityNot monotonic
2024-01-10T07:30:54.847227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 6531
65.3%
850 177
 
1.8%
1700 176
 
1.8%
170 176
 
1.8%
1020 161
 
1.6%
1190 160
 
1.6%
1360 154
 
1.5%
680 149
 
1.5%
510 145
 
1.5%
340 144
 
1.4%
Other values (240) 2027
 
20.3%
ValueCountFrequency (%)
0 6531
65.3%
160 4
 
< 0.1%
170 176
 
1.8%
220 1
 
< 0.1%
330 4
 
< 0.1%
340 144
 
1.4%
490 3
 
< 0.1%
500 4
 
< 0.1%
510 145
 
1.5%
660 4
 
< 0.1%
ValueCountFrequency (%)
1832430 1
< 0.1%
987230 1
< 0.1%
847450 1
< 0.1%
659090 1
< 0.1%
607750 1
< 0.1%
583270 1
< 0.1%
487050 1
< 0.1%
237490 1
< 0.1%
236300 1
< 0.1%
230350 1
< 0.1%

조정일
Real number (ℝ)

SKEWED 

Distinct16
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20230109
Minimum20230105
Maximum20230201
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:54.976605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20230105
5-th percentile20230109
Q120230109
median20230109
Q320230109
95-th percentile20230109
Maximum20230201
Range96
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.1690688
Coefficient of variation (CV)5.7788558 × 10-8
Kurtosis3919.3942
Mean20230109
Median Absolute Deviation (MAD)0
Skewness54.386768
Sum2.0230109 × 1011
Variance1.3667219
MonotonicityNot monotonic
2024-01-10T07:30:55.088921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%)
20230109 9966
99.7%
20230130 6
 
0.1%
20230112 4
 
< 0.1%
20230125 3
 
< 0.1%
20230110 3
 
< 0.1%
20230118 3
 
< 0.1%
20230119 2
 
< 0.1%
20230127 2
 
< 0.1%
20230111 2
 
< 0.1%
20230117 2
 
< 0.1%
Other values (6) 7
 
0.1%
ValueCountFrequency (%)
20230105 1
 
< 0.1%
20230109 9966
99.7%
20230110 3
 
< 0.1%
20230111 2
 
< 0.1%
20230112 4
 
< 0.1%
20230113 1
 
< 0.1%
20230116 2
 
< 0.1%
20230117 2
 
< 0.1%
20230118 3
 
< 0.1%
20230119 2
 
< 0.1%
ValueCountFrequency (%)
20230201 1
 
< 0.1%
20230130 6
0.1%
20230127 2
 
< 0.1%
20230126 1
 
< 0.1%
20230125 3
< 0.1%
20230120 1
 
< 0.1%
20230119 2
 
< 0.1%
20230118 3
< 0.1%
20230117 2
 
< 0.1%
20230116 2
 
< 0.1%

납기후금액
Real number (ℝ)

SKEWED  ZEROS 

Distinct1909
Distinct (%)19.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean29431.936
Minimum0
Maximum16028570
Zeros252
Zeros (%)2.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:30:55.211747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2230
Q13520
median9080
Q316580
95-th percentile57192.5
Maximum16028570
Range16028570
Interquartile range (IQR)13060

Descriptive statistics

Standard deviation289488.31
Coefficient of variation (CV)9.8358569
Kurtosis1544.2714
Mean29431.936
Median Absolute Deviation (MAD)6060
Skewness35.611349
Sum2.9431936 × 108
Variance8.3803481 × 1010
MonotonicityNot monotonic
2024-01-10T07:30:55.361089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2230 1599
 
16.0%
0 252
 
2.5%
4100 147
 
1.5%
2850 126
 
1.3%
3020 110
 
1.1%
8450 97
 
1.0%
6580 89
 
0.9%
5960 89
 
0.9%
7210 88
 
0.9%
5340 87
 
0.9%
Other values (1899) 7316
73.2%
ValueCountFrequency (%)
0 252
2.5%
370 1
 
< 0.1%
490 1
 
< 0.1%
740 2
 
< 0.1%
780 1
 
< 0.1%
850 1
 
< 0.1%
860 1
 
< 0.1%
1650 1
 
< 0.1%
1660 1
 
< 0.1%
1710 1
 
< 0.1%
ValueCountFrequency (%)
16028570 1
< 0.1%
12136980 1
< 0.1%
10149240 1
< 0.1%
7855910 1
< 0.1%
7845020 1
< 0.1%
6328270 1
< 0.1%
4926690 1
< 0.1%
4841550 1
< 0.1%
4159730 1
< 0.1%
3772040 1
< 0.1%

Sample

납기일고지구분이체구분합계검침주기조정구분구경업종가구수전월지침당월지침사용량조정량사용료구경요금감면액정산액가산정산소계하수도물부담금조정일납기후금액
66102023-01-31정기자동6390매월검침정상조정13가정용15085135530502170-3000519012000202301096570
29322023-01-31정기자동10290매월검침정상조정13가정용15775858848802170-40007010192013602023010910580
33182023-01-31정기자동2170매월검침정상조정13가정용16686680002170000217000202301092230
144742023-01-31정기자동13780매월검침정상조정13가정용1327342151591502170-900011230025502023010914180
45822023-01-31정기OCR21210매월검침정상조정13일반용113111328171713770217000015940527002023010921830
136882023-01-31정기자동2170매월검침정상조정13가정용114140002170000217000202301092230
41322023-01-31정기자동3990매월검침정상조정20일반용13893890003990000399000202301094100
95332023-01-31정기자동29710매월검침정상조정13가정용16246613737278102170-2700029710002023010930600
76072023-01-31정기자동2780매월검침정상조정13가정용14647116102170000278000202301092850
19852023-01-31정기OCR48250매월검침정상조정13일반용17257583333293302170000315001114056102023010949670
납기일고지구분이체구분합계검침주기조정구분구경업종가구수전월지침당월지침사용량조정량사용료구경요금감면액정산액가산정산소계하수도물부담금조정일납기후금액
46392023-01-31정기OCR44030매월검침정상조정13일반용1415941933434303402170000325101152002023010945340
61152023-01-31정기OCR4370매월검침정상조정13일반용1382384221620217000-4037506200202301094480
29372023-01-31정기자동2170매월검침정상조정13가정용12772770002170000217000202301092230
143822023-01-31정기OCR2150매월검침정상조정13가정용18181000217000-20215000202301092210
17872023-01-31정기OCR31550매월검침정상조정13가정용115121539272718080217000-21020040697045402023010932490
123832023-01-31정기자동18650매월검침정상조정13가정용18879082121130402170-1300015080035702023010919200
21292023-01-31정기자동4200매월검침정상조정13가정용12772792212202170-10003380480340202301094310
54012023-01-31정기자동14860매월검침정상조정13가정용1137713961919115902170-30800010680418002023010915290
10772023-01-31정기OCR27910매월검침정상조정13가정용241194152333320130217000022300056102023010928730
109422023-01-31정기자동26670매월검침정상조정13가정용11691982929197602170-1900021740049302023010927460

Duplicate rows

Most frequently occurring

납기일고지구분이체구분합계검침주기조정구분구경업종가구수전월지침당월지침사용량조정량사용료구경요금감면액정산액가산정산소계하수도물부담금조정일납기후금액# duplicates
942023-01-31정기자동2170매월검침정상조정13가정용1330002170000217000202301092230192
102023-01-31정기OCR2170매월검침정상조정13가정용1330002170000217000202301092230100
922023-01-31정기자동2170매월검침정상조정13가정용111000217000021700020230109223056
932023-01-31정기자동2170매월검침정상조정13가정용122000217000021700020230109223035
972023-01-31정기자동2170매월검침정상조정13가정용166000217000021700020230109223020
572023-01-31정기OCR2170매월검침정상조정13일반용133000217000021700020230109223017
912023-01-31정기자동2170매월검침정상조정13가정용100000217000021700020230109223017
82023-01-31정기OCR2170매월검침정상조정13가정용111000217000021700020230109223016
962023-01-31정기자동2170매월검침정상조정13가정용155000217000021700020230109223013
1062023-01-31정기자동2170매월검침정상조정13가정용11515000217000021700020230109223011