Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory566.4 KiB
Average record size in memory58.0 B

Variable types

Numeric2
Categorical3
DateTime1

Dataset

Description부산광역시 상수도사업본부에서 상하수도 요금 계산 및 징수를 위해 운영하는 수용가정보시스템에 사용되는 민원 신청 정보(전자고지) 자료입니다.
Author부산광역시 상수도사업본부
URLhttps://www.data.go.kr/data/15100352/fileData.do

Alerts

전자고지구분 is highly overall correlated with 신청구분High correlation
신청구분 is highly overall correlated with 전자고지구분High correlation
사업소코드 is highly overall correlated with 사업소명High correlation
사업소명 is highly overall correlated with 사업소코드High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-15 01:02:47.281412
Analysis finished2024-03-15 01:02:49.585887
Duration2.3 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%
Mean6041.0745
Minimum1
Maximum12037
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T10:02:49.801105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile605.95
Q13032.75
median6044.5
Q39052.25
95-th percentile11449.05
Maximum12037
Range12036
Interquartile range (IQR)6019.5

Descriptive statistics

Standard deviation3476.0199
Coefficient of variation (CV)0.57539762
Kurtosis-1.1990627
Mean6041.0745
Median Absolute Deviation (MAD)3010.5
Skewness-0.009042425
Sum60410745
Variance12082714
MonotonicityNot monotonic
2024-03-15T10:02:50.262461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
6981 1
 
< 0.1%
6497 1
 
< 0.1%
7963 1
 
< 0.1%
3903 1
 
< 0.1%
5372 1
 
< 0.1%
11145 1
 
< 0.1%
3086 1
 
< 0.1%
1050 1
 
< 0.1%
4270 1
 
< 0.1%
240 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
12037 1
< 0.1%
12035 1
< 0.1%
12031 1
< 0.1%
12030 1
< 0.1%
12029 1
< 0.1%
12027 1
< 0.1%
12026 1
< 0.1%
12025 1
< 0.1%
12024 1
< 0.1%
12023 1
< 0.1%

사업소코드
Real number (ℝ)

HIGH CORRELATION 

Distinct11
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean296.4569
Minimum244
Maximum312
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T10:02:50.629601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum244
5-th percentile244
Q1302
median306
Q3311
95-th percentile312
Maximum312
Range68
Interquartile range (IQR)9

Descriptive statistics

Standard deviation24.230668
Coefficient of variation (CV)0.0817342
Kurtosis0.86190268
Mean296.4569
Median Absolute Deviation (MAD)5
Skewness-1.6548649
Sum2964569
Variance587.12525
MonotonicityNot monotonic
2024-03-15T10:02:51.021580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
312 1792
17.9%
244 1731
17.3%
306 1105
11.1%
311 1040
10.4%
304 889
8.9%
307 779
7.8%
309 618
 
6.2%
303 603
 
6.0%
301 545
 
5.5%
308 535
 
5.3%
ValueCountFrequency (%)
244 1731
17.3%
301 545
 
5.5%
302 363
 
3.6%
303 603
 
6.0%
304 889
8.9%
306 1105
11.1%
307 779
7.8%
308 535
 
5.3%
309 618
 
6.2%
311 1040
10.4%
ValueCountFrequency (%)
312 1792
17.9%
311 1040
10.4%
309 618
 
6.2%
308 535
 
5.3%
307 779
7.8%
306 1105
11.1%
304 889
8.9%
303 603
 
6.0%
302 363
 
3.6%
301 545
 
5.5%

사업소명
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
기장사업소
1792 
동래통합사업소
1731 
남부사업소
1105 
강서사업소
1040 
부산진 사업소
889 
Other values (6)
3443 

Length

Max length9
Median length5
Mean length5.8661
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row북부사업소
2nd row동래통합사업소
3rd row부산진 사업소
4th row부산진 사업소
5th row남부사업소

Common Values

ValueCountFrequency (%)
기장사업소 1792
17.9%
동래통합사업소 1731
17.3%
남부사업소 1105
11.1%
강서사업소 1040
10.4%
부산진 사업소 889
8.9%
북부사업소 779
7.8%
사하사업소 618
 
6.2%
영도사업소 603
 
6.0%
중동부사업소 545
 
5.5%
해운대사업소 535
 
5.3%

Length

2024-03-15T10:02:51.465374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
기장사업소 1792
15.9%
동래통합사업소 1731
15.4%
사업소 1252
11.1%
남부사업소 1105
9.8%
강서사업소 1040
9.2%
부산진 889
7.9%
북부사업소 779
6.9%
사하사업소 618
 
5.5%
영도사업소 603
 
5.4%
중동부사업소 545
 
4.8%
Other values (2) 898
8.0%

신청구분
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
전자고지 신규
7714 
전자고지 해지
1952 
전자고지 변경
 
334

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전자고지 신규
2nd row전자고지 신규
3rd row전자고지 신규
4th row전자고지 신규
5th row전자고지 신규

Common Values

ValueCountFrequency (%)
전자고지 신규 7714
77.1%
전자고지 해지 1952
 
19.5%
전자고지 변경 334
 
3.3%

Length

2024-03-15T10:02:51.871673image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T10:02:52.183426image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전자고지 10000
50.0%
신규 7714
38.6%
해지 1952
 
9.8%
변경 334
 
1.7%

전자고지구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
신청
8045 
해지
1955 

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 (%)
신청 8045
80.5%
해지 1955
 
19.6%

Length

2024-03-15T10:02:52.523659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T10:02:52.835189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
신청 8045
80.5%
해지 1955
 
19.6%

신청일자
Date

Distinct294
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-02 00:00:00
Maximum2023-12-31 00:00:00
2024-03-15T10:02:53.101105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T10:02:53.346571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-03-15T10:02:48.407902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T10:02:47.860836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T10:02:48.686548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T10:02:48.134543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T10:02:53.548341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번사업소코드사업소명신청구분전자고지구분
연번1.0000.0520.1110.0710.073
사업소코드0.0521.0001.0000.0220.030
사업소명0.1111.0001.0000.1920.138
신청구분0.0710.0220.1921.0000.868
전자고지구분0.0730.0300.1380.8681.000
2024-03-15T10:02:53.717096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사업소명전자고지구분신청구분
사업소명1.0000.1320.113
전자고지구분0.1321.0000.999
신청구분0.1130.9991.000
2024-03-15T10:02:53.894343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번사업소코드사업소명신청구분전자고지구분
연번1.000-0.0860.0470.0420.056
사업소코드-0.0861.0001.0000.0460.046
사업소명0.0471.0001.0000.1130.132
신청구분0.0420.0460.1131.0000.999
전자고지구분0.0560.0460.1320.9991.000

Missing values

2024-03-15T10:02:49.062754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T10:02:49.427906image/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

연번사업소코드사업소명신청구분전자고지구분신청일자
69806981307북부사업소전자고지 신규신청2023-04-13
172173244동래통합사업소전자고지 신규신청2023-03-20
84218422304부산진 사업소전자고지 신규신청2023-12-11
43814382304부산진 사업소전자고지 신규신청2023-05-04
90509051306남부사업소전자고지 신규신청2023-07-19
26182619306남부사업소전자고지 신규신청2023-02-09
570571304부산진 사업소전자고지 해지해지2023-06-30
66826683307북부사업소전자고지 신규신청2023-08-07
23622363312기장사업소전자고지 해지해지2023-03-06
37503751244동래통합사업소전자고지 신규신청2023-06-07
연번사업소코드사업소명신청구분전자고지구분신청일자
79847985304부산진 사업소전자고지 신규신청2023-10-04
76037604304부산진 사업소전자고지 해지해지2023-07-13
95979598306남부사업소전자고지 신규신청2023-12-22
13381339307북부사업소전자고지 신규신청2023-05-22
12171218301중동부사업소전자고지 해지해지2023-03-03
29612962302서부 사업소전자고지 신규신청2023-01-30
1042010421304부산진 사업소전자고지 신규신청2023-11-10
61116112311강서사업소전자고지 신규신청2023-07-21
91959196244동래통합사업소전자고지 신규신청2023-10-20
51735174306남부사업소전자고지 신규신청2023-04-21