Overview

Dataset statistics

Number of variables8
Number of observations39
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.6 KiB
Average record size in memory69.4 B

Variable types

Categorical7
Numeric1

Dataset

Description(중장기개방계획) 강원도 강릉시 상하수도요금정보에 대한 데이터로 구분,업종,단계,사용량별단가,관리부서,연락처 등의 항목을 제공합니다.
Author강원특별자치도 강릉시
URLhttps://www.data.go.kr/data/15092362/fileData.do

Alerts

관리기관 has constant value ""Constant
연락처 has constant value ""Constant
데이터기준일자 has constant value ""Constant
세제곱미터당금액(원) is highly overall correlated with 단계High correlation
업종 is highly overall correlated with 사용량(세제곱미터)High correlation
단계 is highly overall correlated with 세제곱미터당금액(원) and 1 other fieldsHigh correlation
사용량(세제곱미터) is highly overall correlated with 업종 and 1 other fieldsHigh correlation
세제곱미터당금액(원) has unique valuesUnique

Reproduction

Analysis started2024-03-30 09:02:51.070745
Analysis finished2024-03-30 09:02:53.025220
Duration1.95 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

Distinct3
Distinct (%)7.7%
Missing0
Missing (%)0.0%
Memory size444.0 B
상수도
13 
하수도(합류식)
13 
하수도(분류식)
13 

Length

Max length8
Median length8
Mean length6.3333333
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row상수도
2nd row상수도
3rd row상수도
4th row상수도
5th row상수도

Common Values

ValueCountFrequency (%)
상수도 13
33.3%
하수도(합류식) 13
33.3%
하수도(분류식) 13
33.3%

Length

2024-03-30T09:02:53.251613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-30T09:02:53.603162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
상수도 13
33.3%
하수도(합류식 13
33.3%
하수도(분류식 13
33.3%

업종
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)10.3%
Missing0
Missing (%)0.0%
Memory size444.0 B
일반용
15 
대중탕용
12 
가정용
9 
산업용
3 

Length

Max length4
Median length3
Mean length3.3076923
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
일반용 15
38.5%
대중탕용 12
30.8%
가정용 9
23.1%
산업용 3
 
7.7%

Length

2024-03-30T09:02:54.066423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-30T09:02:54.550123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반용 15
38.5%
대중탕용 12
30.8%
가정용 9
23.1%
산업용 3
 
7.7%

단계
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)15.4%
Missing0
Missing (%)0.0%
Memory size444.0 B
1
9 
2
9 
3
9 
4
6 
5
3 

Length

Max length4
Median length1
Mean length1.2307692
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row2
3rd row3
4th row1
5th row2

Common Values

ValueCountFrequency (%)
1 9
23.1%
2 9
23.1%
3 9
23.1%
4 6
15.4%
5 3
 
7.7%
<NA> 3
 
7.7%

Length

2024-03-30T09:02:55.027932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-30T09:02:55.603784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 9
23.1%
2 9
23.1%
3 9
23.1%
4 6
15.4%
5 3
 
7.7%
na 3
 
7.7%

사용량(세제곱미터)
Categorical

HIGH CORRELATION 

Distinct12
Distinct (%)30.8%
Missing0
Missing (%)0.0%
Memory size444.0 B
2001이상
6 
1~20
3 
21~30
3 
31이상
3 
1~100
3 
Other values (7)
21 

Length

Max length9
Median length7
Mean length6.0769231
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1~20
2nd row21~30
3rd row31이상
4th row1~100
5th row101~300

Common Values

ValueCountFrequency (%)
2001이상 6
15.4%
1~20 3
7.7%
21~30 3
7.7%
31이상 3
7.7%
1~100 3
7.7%
101~300 3
7.7%
301~1000 3
7.7%
1001~2000 3
7.7%
1~1000 3
7.7%
1001~1500 3
7.7%
Other values (2) 6
15.4%

Length

2024-03-30T09:02:56.234067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2001이상 6
15.4%
1~20 3
7.7%
21~30 3
7.7%
31이상 3
7.7%
1~100 3
7.7%
101~300 3
7.7%
301~1000 3
7.7%
1001~2000 3
7.7%
1~1000 3
7.7%
1001~1500 3
7.7%
Other values (2) 6
15.4%

세제곱미터당금액(원)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1498.8974
Minimum497
Maximum2849
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size483.0 B
2024-03-30T09:02:56.737223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum497
5-th percentile620.4
Q11029
median1454
Q31959.5
95-th percentile2427.6
Maximum2849
Range2352
Interquartile range (IQR)930.5

Descriptive statistics

Standard deviation597.89855
Coefficient of variation (CV)0.39889223
Kurtosis-0.6590464
Mean1498.8974
Median Absolute Deviation (MAD)474
Skewness0.2699296
Sum58457
Variance357482.67
MonotonicityNot monotonic
2024-03-30T09:02:57.282670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%)
673 1
 
2.6%
812 1
 
2.6%
1352 1
 
2.6%
1628 1
 
2.6%
1960 1
 
2.6%
1049 1
 
2.6%
534 1
 
2.6%
950 1
 
2.6%
1365 1
 
2.6%
980 1
 
2.6%
Other values (29) 29
74.4%
ValueCountFrequency (%)
497 1
2.6%
534 1
2.6%
630 1
2.6%
673 1
2.6%
812 1
2.6%
883 1
2.6%
911 1
2.6%
950 1
2.6%
980 1
2.6%
1021 1
2.6%
ValueCountFrequency (%)
2849 1
2.6%
2649 1
2.6%
2403 1
2.6%
2235 1
2.6%
2228 1
2.6%
2213 1
2.6%
2107 1
2.6%
2032 1
2.6%
2017 1
2.6%
1960 1
2.6%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size444.0 B
강원특별자치도 강릉시 상하수도사업소
39 

Length

Max length19
Median length19
Mean length19
Min length19

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row강원특별자치도 강릉시 상하수도사업소
2nd row강원특별자치도 강릉시 상하수도사업소
3rd row강원특별자치도 강릉시 상하수도사업소
4th row강원특별자치도 강릉시 상하수도사업소
5th row강원특별자치도 강릉시 상하수도사업소

Common Values

ValueCountFrequency (%)
강원특별자치도 강릉시 상하수도사업소 39
100.0%

Length

2024-03-30T09:02:57.771400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-30T09:02:58.242835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
강원특별자치도 39
33.3%
강릉시 39
33.3%
상하수도사업소 39
33.3%

연락처
Categorical

CONSTANT 

Distinct1
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size444.0 B
033-640-5490
39 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row033-640-5490
2nd row033-640-5490
3rd row033-640-5490
4th row033-640-5490
5th row033-640-5490

Common Values

ValueCountFrequency (%)
033-640-5490 39
100.0%

Length

2024-03-30T09:02:58.608728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-30T09:02:58.928872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
033-640-5490 39
100.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size444.0 B
2024-03-20
39 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-03-20
2nd row2024-03-20
3rd row2024-03-20
4th row2024-03-20
5th row2024-03-20

Common Values

ValueCountFrequency (%)
2024-03-20 39
100.0%

Length

2024-03-30T09:02:59.209419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-30T09:02:59.543176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-03-20 39
100.0%

Interactions

2024-03-30T09:02:51.901767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-30T09:02:59.781189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분업종단계사용량(세제곱미터)세제곱미터당금액(원)
구분1.0000.0000.0000.0000.000
업종0.0001.0000.0000.9980.482
단계0.0000.0001.0000.9420.910
사용량(세제곱미터)0.0000.9980.9421.0000.766
세제곱미터당금액(원)0.0000.4820.9100.7661.000
2024-03-30T09:03:00.190101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단계구분업종사용량(세제곱미터)
단계1.0000.0000.0000.771
구분0.0001.0000.0000.000
업종0.0000.0001.0000.831
사용량(세제곱미터)0.7710.0000.8311.000
2024-03-30T09:03:00.532298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
세제곱미터당금액(원)구분업종단계사용량(세제곱미터)
세제곱미터당금액(원)1.0000.0000.2880.5670.449
구분0.0001.0000.0000.0000.000
업종0.2880.0001.0000.0000.831
단계0.5670.0000.0001.0000.771
사용량(세제곱미터)0.4490.0000.8310.7711.000

Missing values

2024-03-30T09:02:52.236234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-30T09:02:52.763753image/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

구분업종단계사용량(세제곱미터)세제곱미터당금액(원)관리기관연락처데이터기준일자
0상수도가정용11~20673강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
1상수도가정용221~30812강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
2상수도가정용331이상1037강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
3상수도일반용11~1001233강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
4상수도일반용2101~3001569강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
5상수도일반용3301~10001834강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
6상수도일반용41001~20002017강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
7상수도일반용52001이상2228강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
8상수도대중탕용11~10001540강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
9상수도대중탕용21001~15001863강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
구분업종단계사용량(세제곱미터)세제곱미터당금액(원)관리기관연락처데이터기준일자
29하수도(분류식)일반용11~100980강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
30하수도(분류식)일반용2101~3001514강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
31하수도(분류식)일반용3301~10001959강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
32하수도(분류식)일반용41001~20002403강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
33하수도(분류식)일반용52001이상2849강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
34하수도(분류식)대중탕용11~10001098강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
35하수도(분류식)대중탕용21001~15001454강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
36하수도(분류식)대중탕용31501~20001751강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
37하수도(분류식)대중탕용42001이상2107강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20
38하수도(분류식)산업용<NA>11128강원특별자치도 강릉시 상하수도사업소033-640-54902024-03-20