Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory585.9 KiB
Average record size in memory60.0 B

Variable types

Numeric3
DateTime1
Categorical2

Dataset

Description부산광역시 상수도사업본부에서 상하수도 요금 계산 및 징수를 위해 운영하는 수용가정보시스템에 사용되는 간단e납부 시스템 연계(일반수납내역 분배 자료) 자료입니다.
Author부산광역시 상수도사업본부
URLhttps://www.data.go.kr/data/15083440/fileData.do

Alerts

이용기관발행기관 has constant value ""Constant
이용기관지로번호 has constant value ""Constant
수납금액 is highly skewed (γ1 = 47.2011528)Skewed
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-14 23:14:16.714424
Analysis finished2024-03-14 23:14:20.546719
Duration3.83 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean50438.086
Minimum2
Maximum99992
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T08:14:20.779724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile5377.75
Q125051.75
median50641
Q375659.25
95-th percentile95174.3
Maximum99992
Range99990
Interquartile range (IQR)50607.5

Descriptive statistics

Standard deviation28948.655
Coefficient of variation (CV)0.57394435
Kurtosis-1.2111833
Mean50438.086
Median Absolute Deviation (MAD)25282
Skewness-0.014580215
Sum5.0438086 × 108
Variance8.380246 × 108
MonotonicityNot monotonic
2024-03-15T08:14:21.231684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
92663 1
 
< 0.1%
73994 1
 
< 0.1%
98445 1
 
< 0.1%
467 1
 
< 0.1%
37059 1
 
< 0.1%
7644 1
 
< 0.1%
43980 1
 
< 0.1%
40364 1
 
< 0.1%
86056 1
 
< 0.1%
30046 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
2 1
< 0.1%
27 1
< 0.1%
41 1
< 0.1%
47 1
< 0.1%
48 1
< 0.1%
61 1
< 0.1%
77 1
< 0.1%
88 1
< 0.1%
94 1
< 0.1%
98 1
< 0.1%
ValueCountFrequency (%)
99992 1
< 0.1%
99985 1
< 0.1%
99984 1
< 0.1%
99971 1
< 0.1%
99965 1
< 0.1%
99955 1
< 0.1%
99949 1
< 0.1%
99944 1
< 0.1%
99940 1
< 0.1%
99937 1
< 0.1%

납부일자
Date

Distinct94
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-01 00:00:00
Maximum2023-04-26 00:00:00
2024-03-15T08:14:21.652819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:14:21.954242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

일련번호
Real number (ℝ)

Distinct4338
Distinct (%)43.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1884.3321
Minimum1
Maximum6951
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T08:14:22.195318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile61
Q1566
median1550
Q32793.25
95-th percentile5091
Maximum6951
Range6950
Interquartile range (IQR)2227.25

Descriptive statistics

Standard deviation1580.2159
Coefficient of variation (CV)0.83860794
Kurtosis0.25137518
Mean1884.3321
Median Absolute Deviation (MAD)1084
Skewness0.91818606
Sum18843321
Variance2497082.2
MonotonicityNot monotonic
2024-03-15T08:14:22.526051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
36 15
 
0.1%
105 14
 
0.1%
45 14
 
0.1%
116 14
 
0.1%
8 14
 
0.1%
49 14
 
0.1%
11 13
 
0.1%
97 13
 
0.1%
7 13
 
0.1%
12 13
 
0.1%
Other values (4328) 9863
98.6%
ValueCountFrequency (%)
1 10
0.1%
2 11
0.1%
3 9
0.1%
4 6
0.1%
5 7
0.1%
6 7
0.1%
7 13
0.1%
8 14
0.1%
9 12
0.1%
10 11
0.1%
ValueCountFrequency (%)
6951 1
< 0.1%
6938 1
< 0.1%
6934 1
< 0.1%
6926 1
< 0.1%
6910 1
< 0.1%
6893 2
< 0.1%
6883 1
< 0.1%
6879 1
< 0.1%
6875 1
< 0.1%
6855 1
< 0.1%

이용기관발행기관
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
부산광역시
10000 

Length

Max length5
Median length5
Mean length5
Min length5

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-15T08:14:22.973318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T08:14:23.151437image/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
1004102
10000 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1004102 10000
100.0%

Length

2024-03-15T08:14:23.318361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T08:14:23.486865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1004102 10000
100.0%

수납금액
Real number (ℝ)

SKEWED 

Distinct4565
Distinct (%)45.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean238396.06
Minimum30
Maximum1.8096968 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T08:14:23.681230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum30
5-th percentile2400
Q116900
median44660
Q3104177.5
95-th percentile551198
Maximum1.8096968 × 108
Range1.8096965 × 108
Interquartile range (IQR)87277.5

Descriptive statistics

Standard deviation2943758.3
Coefficient of variation (CV)12.348183
Kurtosis2577.7197
Mean238396.06
Median Absolute Deviation (MAD)34340
Skewness47.201153
Sum2.3839606 × 109
Variance8.6657128 × 1012
MonotonicityNot monotonic
2024-03-15T08:14:24.141150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2400 798
 
8.0%
22200 83
 
0.8%
19560 70
 
0.7%
15600 67
 
0.7%
2470 65
 
0.7%
16920 64
 
0.6%
10320 64
 
0.6%
12960 61
 
0.6%
3700 59
 
0.6%
8980 59
 
0.6%
Other values (4555) 8610
86.1%
ValueCountFrequency (%)
30 2
< 0.1%
270 2
< 0.1%
310 1
 
< 0.1%
600 2
< 0.1%
610 1
 
< 0.1%
770 1
 
< 0.1%
960 1
 
< 0.1%
980 4
< 0.1%
1010 1
 
< 0.1%
1070 1
 
< 0.1%
ValueCountFrequency (%)
180969680 1
< 0.1%
162660560 1
< 0.1%
112141420 1
< 0.1%
48689730 1
< 0.1%
42727350 1
< 0.1%
39211460 1
< 0.1%
38871880 1
< 0.1%
37214000 1
< 0.1%
27486940 1
< 0.1%
25914380 1
< 0.1%

Interactions

2024-03-15T08:14:19.040918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:14:17.310216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:14:18.148291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:14:19.320165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:14:17.574293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:14:18.424843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:14:19.611093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:14:17.873280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:14:18.730358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T08:14:24.622460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번납부일자일련번호수납금액
연번1.0000.9770.4750.000
납부일자0.9771.0000.6750.422
일련번호0.4750.6751.0000.000
수납금액0.0000.4220.0001.000
2024-03-15T08:14:24.945256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번일련번호수납금액
연번1.000-0.130-0.047
일련번호-0.1301.0000.091
수납금액-0.0470.0911.000

Missing values

2024-03-15T08:14:19.999838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T08:14:20.417651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

연번납부일자일련번호이용기관발행기관이용기관지로번호수납금액
92662926632023-02-211606부산광역시100410249960
7917922023-01-311046부산광역시10041025346230
64510645112023-03-20680부산광역시100410219780
46788467892023-02-231513부산광역시100410215760
60174601752023-03-20394부산광역시100410235580
19418194192023-01-254230부산광역시1004102117980
35660356612023-03-2842부산광역시10041022400
46679466802023-02-243489부산광역시100410222700
72905729062023-03-273922부산광역시100410288130
32622326232023-01-299부산광역시10041022470
연번납부일자일련번호이용기관발행기관이용기관지로번호수납금액
75072750732023-03-31446부산광역시1004102612600
38492384932023-02-1786부산광역시10041021652160
66367663682023-02-275334부산광역시100410218330
40491404922023-03-28794부산광역시1004102416990
15968159692023-01-252578부산광역시100410226160
280428052023-01-313056부산광역시1004102128640
17204172052023-01-271169부산광역시100410233860
13868138692023-01-2528부산광역시100410239000
27357273582023-01-30605부산광역시10041022400
11711117122023-01-191359부산광역시100410246940