Overview

Dataset statistics

Number of variables6
Number of observations65
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.3 KiB
Average record size in memory52.0 B

Variable types

Numeric2
Categorical4

Dataset

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

Alerts

녹물출수 경험 has constant value ""Constant
자재지원여부 has constant value ""Constant
사업소코드 is highly overall correlated with 사업소명High correlation
사업소명 is highly overall correlated with 사업소코드 and 1 other fieldsHigh correlation
건물형태 is highly overall correlated with 사업소명High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-14 14:46:32.437630
Analysis finished2024-03-14 14:46:33.615825
Duration1.18 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct65
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean33
Minimum1
Maximum65
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size713.0 B
2024-03-14T23:46:33.820283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.2
Q117
median33
Q349
95-th percentile61.8
Maximum65
Range64
Interquartile range (IQR)32

Descriptive statistics

Standard deviation18.90767
Coefficient of variation (CV)0.57295971
Kurtosis-1.2
Mean33
Median Absolute Deviation (MAD)16
Skewness0
Sum2145
Variance357.5
MonotonicityStrictly increasing
2024-03-14T23:46:34.075338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.5%
50 1
 
1.5%
36 1
 
1.5%
37 1
 
1.5%
38 1
 
1.5%
39 1
 
1.5%
40 1
 
1.5%
41 1
 
1.5%
42 1
 
1.5%
43 1
 
1.5%
Other values (55) 55
84.6%
ValueCountFrequency (%)
1 1
1.5%
2 1
1.5%
3 1
1.5%
4 1
1.5%
5 1
1.5%
6 1
1.5%
7 1
1.5%
8 1
1.5%
9 1
1.5%
10 1
1.5%
ValueCountFrequency (%)
65 1
1.5%
64 1
1.5%
63 1
1.5%
62 1
1.5%
61 1
1.5%
60 1
1.5%
59 1
1.5%
58 1
1.5%
57 1
1.5%
56 1
1.5%

사업소코드
Real number (ℝ)

HIGH CORRELATION 

Distinct11
Distinct (%)16.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean303.6
Minimum244
Maximum312
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size713.0 B
2024-03-14T23:46:34.278957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum244
5-th percentile301
Q1302
median306
Q3307
95-th percentile311
Maximum312
Range68
Interquartile range (IQR)5

Descriptive statistics

Standard deviation11.074746
Coefficient of variation (CV)0.036478083
Kurtosis25.670952
Mean303.6
Median Absolute Deviation (MAD)2
Skewness-4.9813535
Sum19734
Variance122.65
MonotonicityNot monotonic
2024-03-14T23:46:34.460809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
307 17
26.2%
302 12
18.5%
306 11
16.9%
303 8
12.3%
308 5
 
7.7%
311 3
 
4.6%
301 3
 
4.6%
244 2
 
3.1%
312 2
 
3.1%
309 1
 
1.5%
ValueCountFrequency (%)
244 2
 
3.1%
301 3
 
4.6%
302 12
18.5%
303 8
12.3%
304 1
 
1.5%
306 11
16.9%
307 17
26.2%
308 5
 
7.7%
309 1
 
1.5%
311 3
 
4.6%
ValueCountFrequency (%)
312 2
 
3.1%
311 3
 
4.6%
309 1
 
1.5%
308 5
 
7.7%
307 17
26.2%
306 11
16.9%
304 1
 
1.5%
303 8
12.3%
302 12
18.5%
301 3
 
4.6%

사업소명
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)16.9%
Missing0
Missing (%)0.0%
Memory size648.0 B
북부사업소
17 
서부 사업소
12 
남부사업소
11 
영도사업소
8 
해운대사업소
5 
Other values (6)
12 

Length

Max length9
Median length5
Mean length5.9692308
Min length5

Unique

Unique2 ?
Unique (%)3.1%

Sample

1st row남부사업소
2nd row서부 사업소
3rd row서부 사업소
4th row서부 사업소
5th row사하사업소

Common Values

ValueCountFrequency (%)
북부사업소 17
26.2%
서부 사업소 12
18.5%
남부사업소 11
16.9%
영도사업소 8
12.3%
해운대사업소 5
 
7.7%
강서사업소 3
 
4.6%
중동부사업소 3
 
4.6%
동래통합사업소 2
 
3.1%
기장사업소 2
 
3.1%
사하사업소 1
 
1.5%

Length

2024-03-14T23:46:34.692256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
북부사업소 17
21.8%
사업소 13
16.7%
서부 12
15.4%
남부사업소 11
14.1%
영도사업소 8
10.3%
해운대사업소 5
 
6.4%
강서사업소 3
 
3.8%
중동부사업소 3
 
3.8%
동래통합사업소 2
 
2.6%
기장사업소 2
 
2.6%
Other values (2) 2
 
2.6%

건물형태
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)6.2%
Missing0
Missing (%)0.0%
Memory size648.0 B
단독주택
45 
근린생활시설(상가 등)
9 
공동주택
8 
기타
 
3

Length

Max length12
Median length4
Mean length5.0153846
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row단독주택
2nd row단독주택
3rd row단독주택
4th row단독주택
5th row기타

Common Values

ValueCountFrequency (%)
단독주택 45
69.2%
근린생활시설(상가 등) 9
 
13.8%
공동주택 8
 
12.3%
기타 3
 
4.6%

Length

2024-03-14T23:46:35.002258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:46:35.184251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
단독주택 45
60.8%
근린생활시설(상가 9
 
12.2%
등 9
 
12.2%
공동주택 8
 
10.8%
기타 3
 
4.1%

녹물출수 경험
Categorical

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size648.0 B
있음
65 

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 (%)
있음 65
100.0%

Length

2024-03-14T23:46:35.383225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:46:35.546380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
있음 65
100.0%

자재지원여부
Categorical

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size648.0 B
없음
65 

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 (%)
없음 65
100.0%

Length

2024-03-14T23:46:35.716453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:46:35.879059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
없음 65
100.0%

Interactions

2024-03-14T23:46:32.991863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T23:46:32.633279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T23:46:33.144289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T23:46:32.840539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T23:46:35.986388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번사업소코드사업소명건물형태
연번1.0000.0000.6430.500
사업소코드0.0001.0001.0000.478
사업소명0.6431.0001.0000.795
건물형태0.5000.4780.7951.000
2024-03-14T23:46:36.212925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
건물형태사업소명
건물형태1.0000.587
사업소명0.5871.000
2024-03-14T23:46:36.559677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번사업소코드사업소명건물형태
연번1.0000.2200.3330.302
사업소코드0.2201.0000.9330.360
사업소명0.3330.9331.0000.587
건물형태0.3020.3600.5871.000

Missing values

2024-03-14T23:46:33.342963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T23:46:33.527227image/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

연번사업소코드사업소명건물형태녹물출수 경험자재지원여부
01306남부사업소단독주택있음없음
12302서부 사업소단독주택있음없음
23302서부 사업소단독주택있음없음
34302서부 사업소단독주택있음없음
45309사하사업소기타있음없음
56306남부사업소단독주택있음없음
67303영도사업소단독주택있음없음
78306남부사업소단독주택있음없음
89303영도사업소단독주택있음없음
910302서부 사업소단독주택있음없음
연번사업소코드사업소명건물형태녹물출수 경험자재지원여부
5556301중동부사업소단독주택있음없음
5657306남부사업소단독주택있음없음
5758303영도사업소단독주택있음없음
5859302서부 사업소단독주택있음없음
5960312기장사업소단독주택있음없음
6061302서부 사업소단독주택있음없음
6162302서부 사업소단독주택있음없음
6263308해운대사업소공동주택있음없음
6364308해운대사업소공동주택있음없음
6465308해운대사업소공동주택있음없음