Overview

Dataset statistics

Number of variables8
Number of observations46
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.1 KiB
Average record size in memory68.9 B

Variable types

Categorical5
Numeric2
Text1

Dataset

Description2020년 영월군 상하수도 요금 정보 데이터로 상하수도 구분, 업종, 사용량, 금액, 관리기관, 연락처 등을 공개합니다.
Author강원도 영월군
URLhttps://www.data.go.kr/data/15093665/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

Reproduction

Analysis started2023-12-12 10:26:44.617290
Analysis finished2023-12-12 10:26:45.336172
Duration0.72 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size500.0 B
상수도
24 
하수도
22 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
상수도 24
52.2%
하수도 22
47.8%

Length

2023-12-12T19:26:45.401748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:26:45.493593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
상수도 24
52.2%
하수도 22
47.8%

업종
Categorical

Distinct6
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Memory size500.0 B
가정용
10 
업무용
10 
영업용
8 
욕탕1종
8 
욕탕2종
8 

Length

Max length4
Median length3
Mean length3.3478261
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
가정용 10
21.7%
업무용 10
21.7%
영업용 8
17.4%
욕탕1종 8
17.4%
욕탕2종 8
17.4%
산업용 2
 
4.3%

Length

2023-12-12T19:26:45.590966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:26:45.714584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가정용 10
21.7%
업무용 10
21.7%
영업용 8
17.4%
욕탕1종 8
17.4%
욕탕2종 8
17.4%
산업용 2
 
4.3%

단계
Real number (ℝ)

Distinct6
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.673913
Minimum1
Maximum6
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size546.0 B
2023-12-12T19:26:45.854770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11.25
median3
Q34
95-th percentile5
Maximum6
Range5
Interquartile range (IQR)2.75

Descriptive statistics

Standard deviation1.3671438
Coefficient of variation (CV)0.51128955
Kurtosis-0.75746674
Mean2.673913
Median Absolute Deviation (MAD)1
Skewness0.35344603
Sum123
Variance1.8690821
MonotonicityNot monotonic
2023-12-12T19:26:46.259317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
1 12
26.1%
2 10
21.7%
3 10
21.7%
4 10
21.7%
5 3
 
6.5%
6 1
 
2.2%
ValueCountFrequency (%)
1 12
26.1%
2 10
21.7%
3 10
21.7%
4 10
21.7%
5 3
 
6.5%
6 1
 
2.2%
ValueCountFrequency (%)
6 1
 
2.2%
5 3
 
6.5%
4 10
21.7%
3 10
21.7%
2 10
21.7%
1 12
26.1%

사용량(세제곱미터)
Text

Distinct25
Distinct (%)54.3%
Missing0
Missing (%)0.0%
Memory size500.0 B
2023-12-12T19:26:46.436006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length7
Mean length5.5217391
Min length2

Characters and Unicode

Total characters254
Distinct characters12
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique8 ?
Unique (%)17.4%

Sample

1st row0~10
2nd row11~20
3rd row21~30
4th row31~40
5th row41~50
ValueCountFrequency (%)
이상 10
17.9%
1~200 4
 
7.1%
51~100 4
 
7.1%
21~50 2
 
3.6%
31~50 2
 
3.6%
301 2
 
3.6%
501 2
 
3.6%
301~500 2
 
3.6%
101 2
 
3.6%
1001 2
 
3.6%
Other values (16) 24
42.9%
2023-12-12T19:26:46.782613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 76
29.9%
1 58
22.8%
~ 34
13.4%
5 20
 
7.9%
3 16
 
6.3%
2 14
 
5.5%
10
 
3.9%
이 10
 
3.9%
상 10
 
3.9%
톤 2
 
0.8%
Other values (2) 4
 
1.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 186
73.2%
Math Symbol 34
 
13.4%
Other Letter 24
 
9.4%
Space Separator 10
 
3.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 76
40.9%
1 58
31.2%
5 20
 
10.8%
3 16
 
8.6%
2 14
 
7.5%
4 2
 
1.1%
Other Letter
ValueCountFrequency (%)
이 10
41.7%
상 10
41.7%
톤 2
 
8.3%
당 2
 
8.3%
Math Symbol
ValueCountFrequency (%)
~ 34
100.0%
Space Separator
ValueCountFrequency (%)
10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 230
90.6%
Hangul 24
 
9.4%

Most frequent character per script

Common
ValueCountFrequency (%)
0 76
33.0%
1 58
25.2%
~ 34
14.8%
5 20
 
8.7%
3 16
 
7.0%
2 14
 
6.1%
10
 
4.3%
4 2
 
0.9%
Hangul
ValueCountFrequency (%)
이 10
41.7%
상 10
41.7%
톤 2
 
8.3%
당 2
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 230
90.6%
Hangul 24
 
9.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 76
33.0%
1 58
25.2%
~ 34
14.8%
5 20
 
8.7%
3 16
 
7.0%
2 14
 
6.1%
10
 
4.3%
4 2
 
0.9%
Hangul
ValueCountFrequency (%)
이 10
41.7%
상 10
41.7%
톤 2
 
8.3%
당 2
 
8.3%

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

HIGH CORRELATION 

Distinct38
Distinct (%)82.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean932.82609
Minimum237
Maximum3150
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size546.0 B
2023-12-12T19:26:46.928110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum237
5-th percentile293
Q1417
median729.5
Q31250
95-th percentile2267.5
Maximum3150
Range2913
Interquartile range (IQR)833

Descriptive statistics

Standard deviation672.77255
Coefficient of variation (CV)0.7212197
Kurtosis1.9000069
Mean932.82609
Median Absolute Deviation (MAD)355
Skewness1.445737
Sum42910
Variance452622.9
MonotonicityNot monotonic
2023-12-12T19:26:47.069392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=38)
ValueCountFrequency (%)
407 3
 
6.5%
492 3
 
6.5%
370 3
 
6.5%
448 2
 
4.3%
940 2
 
4.3%
800 1
 
2.2%
237 1
 
2.2%
260 1
 
2.2%
286 1
 
2.2%
314 1
 
2.2%
Other values (28) 28
60.9%
ValueCountFrequency (%)
237 1
 
2.2%
260 1
 
2.2%
286 1
 
2.2%
314 1
 
2.2%
337 1
 
2.2%
369 1
 
2.2%
370 3
6.5%
407 3
6.5%
447 1
 
2.2%
448 2
4.3%
ValueCountFrequency (%)
3150 1
2.2%
2580 1
2.2%
2270 1
2.2%
2260 1
2.2%
1860 1
2.2%
1640 1
2.2%
1630 1
2.2%
1560 1
2.2%
1510 1
2.2%
1340 1
2.2%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size500.0 B
강원도 영월군청
46 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row강원도 영월군청
2nd row강원도 영월군청
3rd row강원도 영월군청
4th row강원도 영월군청
5th row강원도 영월군청

Common Values

ValueCountFrequency (%)
강원도 영월군청 46
100.0%

Length

2023-12-12T19:26:47.182565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:26:47.273358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
강원도 46
50.0%
영월군청 46
50.0%

연락처
Categorical

CONSTANT 

Distinct1
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size500.0 B
033-370-2772
46 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row033-370-2772
2nd row033-370-2772
3rd row033-370-2772
4th row033-370-2772
5th row033-370-2772

Common Values

ValueCountFrequency (%)
033-370-2772 46
100.0%

Length

2023-12-12T19:26:47.393846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:26:47.506185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
033-370-2772 46
100.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size500.0 B
2021-10-27
46 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-10-27
2nd row2021-10-27
3rd row2021-10-27
4th row2021-10-27
5th row2021-10-27

Common Values

ValueCountFrequency (%)
2021-10-27 46
100.0%

Length

2023-12-12T19:26:47.611493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:26:47.709667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-10-27 46
100.0%

Interactions

2023-12-12T19:26:44.984288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:26:44.818634image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:26:45.069548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:26:44.898367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T19:26:47.775305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분업종단계사용량(세제곱미터)세제곱미터당 금액(원)
구분1.0000.0000.0000.0000.853
업종0.0001.0000.0000.9780.000
단계0.0000.0001.0000.9740.000
사용량(세제곱미터)0.0000.9780.9741.0000.000
세제곱미터당 금액(원)0.8530.0000.0000.0001.000
2023-12-12T19:26:47.886771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분업종
구분1.0000.000
업종0.0001.000
2023-12-12T19:26:47.974131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단계세제곱미터당 금액(원)구분업종
단계1.0000.3460.0000.000
세제곱미터당 금액(원)0.3461.0000.8140.000
구분0.0000.8141.0000.000
업종0.0000.0000.0001.000

Missing values

2023-12-12T19:26:45.183634image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:26:45.288489image/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상수도가정용10~10720강원도 영월군청033-370-27722021-10-27
1상수도가정용211~20830강원도 영월군청033-370-27722021-10-27
2상수도가정용321~30940강원도 영월군청033-370-27722021-10-27
3상수도가정용431~401080강원도 영월군청033-370-27722021-10-27
4상수도가정용541~501300강원도 영월군청033-370-27722021-10-27
5상수도가정용651 이상1510강원도 영월군청033-370-27722021-10-27
6상수도업무용11~20630강원도 영월군청033-370-27722021-10-27
7상수도업무용221~50740강원도 영월군청033-370-27722021-10-27
8상수도업무용351~100940강원도 영월군청033-370-27722021-10-27
9상수도업무용4101~3001220강원도 영월군청033-370-27722021-10-27
구분업종단계사용량(세제곱미터)세제곱미터당 금액(원)관리기관연락처데이터기준일자
36하수도영업용4101 이상492강원도 영월군청033-370-27722021-10-27
37하수도욕탕1종11~200370강원도 영월군청033-370-27722021-10-27
38하수도욕탕1종2201~300407강원도 영월군청033-370-27722021-10-27
39하수도욕탕1종3301~500448강원도 영월군청033-370-27722021-10-27
40하수도욕탕1종4501 이상492강원도 영월군청033-370-27722021-10-27
41하수도욕탕2종11~200555강원도 영월군청033-370-27722021-10-27
42하수도욕탕2종2201~500611강원도 영월군청033-370-27722021-10-27
43하수도욕탕2종3501~1000672강원도 영월군청033-370-27722021-10-27
44하수도욕탕2종41001 이상739강원도 영월군청033-370-27722021-10-27
45하수도산업용1톤당369강원도 영월군청033-370-27722021-10-27