Overview

Dataset statistics

Number of variables7
Number of observations29
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.8 KiB
Average record size in memory62.6 B

Variable types

Categorical4
Numeric2
Text1

Dataset

Description전북특별자치도 장수군 상하수도 요금정보(구분, 업종, 단계, 사용량, 금액, 관리기관, 연락처)에 대한 데이터를 제공하고자 합니다
Author전북특별자치도 장수군
URLhttps://www.data.go.kr/data/15092272/fileData.do

Alerts

관리기관 has constant value ""Constant
연락처 is highly overall correlated with 세제곱미터당 금액(원) and 1 other fieldsHigh correlation
구분 is highly overall correlated with 세제곱미터당 금액(원) and 1 other fieldsHigh correlation
세제곱미터당 금액(원) is highly overall correlated with 구분 and 2 other fieldsHigh correlation
업종 is highly overall correlated with 세제곱미터당 금액(원)High correlation

Reproduction

Analysis started2024-04-06 08:29:36.599186
Analysis finished2024-04-06 08:29:38.693292
Duration2.09 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)6.9%
Missing0
Missing (%)0.0%
Memory size364.0 B
하수도
15 
상수도
14 

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 (%)
하수도 15
51.7%
상수도 14
48.3%

Length

2024-04-06T17:29:38.814677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:29:38.993791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
하수도 15
51.7%
상수도 14
48.3%

업종
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)13.8%
Missing0
Missing (%)0.0%
Memory size364.0 B
가정용
9 
일반용
9 
욕탕용
8 
산업용
3 

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 (%)
가정용 9
31.0%
일반용 9
31.0%
욕탕용 8
27.6%
산업용 3
 
10.3%

Length

2024-04-06T17:29:39.247572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:29:39.435549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가정용 9
31.0%
일반용 9
31.0%
욕탕용 8
27.6%
산업용 3
 
10.3%

단계
Real number (ℝ)

Distinct6
Distinct (%)20.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.6896552
Minimum1
Maximum6
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size393.0 B
2024-04-06T17:29:39.627857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median3
Q34
95-th percentile5
Maximum6
Range5
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.391388
Coefficient of variation (CV)0.51731093
Kurtosis-0.39201323
Mean2.6896552
Median Absolute Deviation (MAD)1
Skewness0.51744044
Sum78
Variance1.9359606
MonotonicityNot monotonic
2024-04-06T17:29:39.848736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
1 7
24.1%
2 7
24.1%
3 7
24.1%
4 5
17.2%
5 2
 
6.9%
6 1
 
3.4%
ValueCountFrequency (%)
1 7
24.1%
2 7
24.1%
3 7
24.1%
4 5
17.2%
5 2
 
6.9%
6 1
 
3.4%
ValueCountFrequency (%)
6 1
 
3.4%
5 2
 
6.9%
4 5
17.2%
3 7
24.1%
2 7
24.1%
1 7
24.1%

사용량(세제곱미터)
Text

Distinct24
Distinct (%)82.8%
Missing0
Missing (%)0.0%
Memory size364.0 B
2024-04-06T17:29:40.163756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length7
Mean length5.4827586
Min length4

Characters and Unicode

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

Unique

Unique19 ?
Unique (%)65.5%

Sample

1st row0~20
2nd row21~30
3rd row31이상
4th row0~50
5th row51~100
ValueCountFrequency (%)
51~100 2
 
6.9%
21~30 2
 
6.9%
1001이상 2
 
6.9%
101~300 2
 
6.9%
301이상 2
 
6.9%
41~50 1
 
3.4%
0~20 1
 
3.4%
11~20 1
 
3.4%
501~700 1
 
3.4%
1~500 1
 
3.4%
Other values (14) 14
48.3%
2024-04-06T17:29:40.994070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 54
34.0%
1 35
22.0%
~ 22
13.8%
5 12
 
7.5%
3 10
 
6.3%
2 8
 
5.0%
이 7
 
4.4%
상 7
 
4.4%
4 2
 
1.3%
7 2
 
1.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 123
77.4%
Math Symbol 22
 
13.8%
Other Letter 14
 
8.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 54
43.9%
1 35
28.5%
5 12
 
9.8%
3 10
 
8.1%
2 8
 
6.5%
4 2
 
1.6%
7 2
 
1.6%
Other Letter
ValueCountFrequency (%)
이 7
50.0%
상 7
50.0%
Math Symbol
ValueCountFrequency (%)
~ 22
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 145
91.2%
Hangul 14
 
8.8%

Most frequent character per script

Common
ValueCountFrequency (%)
0 54
37.2%
1 35
24.1%
~ 22
15.2%
5 12
 
8.3%
3 10
 
6.9%
2 8
 
5.5%
4 2
 
1.4%
7 2
 
1.4%
Hangul
ValueCountFrequency (%)
이 7
50.0%
상 7
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 145
91.2%
Hangul 14
 
8.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 54
37.2%
1 35
24.1%
~ 22
15.2%
5 12
 
8.3%
3 10
 
6.9%
2 8
 
5.5%
4 2
 
1.4%
7 2
 
1.4%
Hangul
ValueCountFrequency (%)
이 7
50.0%
상 7
50.0%

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

HIGH CORRELATION 

Distinct25
Distinct (%)86.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean541.86207
Minimum73
Maximum1460
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size393.0 B
2024-04-06T17:29:41.295844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum73
5-th percentile93.6
Q1144
median215
Q31050
95-th percentile1288
Maximum1460
Range1387
Interquartile range (IQR)906

Descriptive statistics

Standard deviation469.57038
Coefficient of variation (CV)0.86658654
Kurtosis-1.3013762
Mean541.86207
Median Absolute Deviation (MAD)142
Skewness0.59418242
Sum15714
Variance220496.34
MonotonicityNot monotonic
2024-04-06T17:29:41.653089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%)
510 3
 
10.3%
120 2
 
6.9%
166 2
 
6.9%
670 1
 
3.4%
146 1
 
3.4%
128 1
 
3.4%
215 1
 
3.4%
189 1
 
3.4%
143 1
 
3.4%
130 1
 
3.4%
Other values (15) 15
51.7%
ValueCountFrequency (%)
73 1
3.4%
76 1
3.4%
120 2
6.9%
128 1
3.4%
130 1
3.4%
143 1
3.4%
144 1
3.4%
146 1
3.4%
166 2
6.9%
167 1
3.4%
ValueCountFrequency (%)
1460 1
3.4%
1360 1
3.4%
1180 1
3.4%
1150 1
3.4%
1110 1
3.4%
1090 1
3.4%
1060 1
3.4%
1050 1
3.4%
1020 1
3.4%
860 1
3.4%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Memory size364.0 B
전북특별자치도 장수군청
29 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전북특별자치도 장수군청
2nd row전북특별자치도 장수군청
3rd row전북특별자치도 장수군청
4th row전북특별자치도 장수군청
5th row전북특별자치도 장수군청

Common Values

ValueCountFrequency (%)
전북특별자치도 장수군청 29
100.0%

Length

2024-04-06T17:29:42.016396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:29:42.296882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전북특별자치도 29
50.0%
장수군청 29
50.0%

연락처
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)6.9%
Missing0
Missing (%)0.0%
Memory size364.0 B
063-350-2902
15 
063-350-2893
14 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row063-350-2893
2nd row063-350-2893
3rd row063-350-2893
4th row063-350-2893
5th row063-350-2893

Common Values

ValueCountFrequency (%)
063-350-2902 15
51.7%
063-350-2893 14
48.3%

Length

2024-04-06T17:29:42.576803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:29:42.835136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
063-350-2902 15
51.7%
063-350-2893 14
48.3%

Interactions

2024-04-06T17:29:37.868125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:29:37.323857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:29:38.061873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:29:37.591715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-06T17:29:42.965139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분업종단계사용량(세제곱미터)세제곱미터당 금액(원)연락처
구분1.0000.3060.0000.0001.0000.994
업종0.3061.0000.0000.9680.8940.306
단계0.0000.0001.0000.5140.0000.000
사용량(세제곱미터)0.0000.9680.5141.0000.0000.000
세제곱미터당 금액(원)1.0000.8940.0000.0001.0001.000
연락처0.9940.3060.0000.0001.0001.000
2024-04-06T17:29:43.159415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연락처구분업종
연락처1.0000.9280.187
구분0.9281.0000.187
업종0.1870.1871.000
2024-04-06T17:29:43.331034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단계세제곱미터당 금액(원)구분업종연락처
단계1.0000.1420.0000.0000.000
세제곱미터당 금액(원)0.1421.0000.8820.5350.882
구분0.0000.8821.0000.1870.928
업종0.0000.5350.1871.0000.187
연락처0.0000.8820.9280.1871.000

Missing values

2024-04-06T17:29:38.323462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:29:38.599179image/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~20670전북특별자치도 장수군청063-350-2893
1상수도가정용221~30860전북특별자치도 장수군청063-350-2893
2상수도가정용331이상1090전북특별자치도 장수군청063-350-2893
3상수도일반용10~501060전북특별자치도 장수군청063-350-2893
4상수도일반용251~1001150전북특별자치도 장수군청063-350-2893
5상수도일반용3101~3001360전북특별자치도 장수군청063-350-2893
6상수도일반용4301이상1460전북특별자치도 장수군청063-350-2893
7상수도욕탕용10~2001020전북특별자치도 장수군청063-350-2893
8상수도욕탕용2201~3001050전북특별자치도 장수군청063-350-2893
9상수도욕탕용3301~5001110전북특별자치도 장수군청063-350-2893
구분업종단계사용량(세제곱미터)세제곱미터당 금액(원)관리기관연락처
19하수도가정용651이상191전북특별자치도 장수군청063-350-2902
20하수도일반용11~20130전북특별자치도 장수군청063-350-2902
21하수도일반용221~50143전북특별자치도 장수군청063-350-2902
22하수도일반용351~100166전북특별자치도 장수군청063-350-2902
23하수도일반용4101~300189전북특별자치도 장수군청063-350-2902
24하수도일반용5301이상215전북특별자치도 장수군청063-350-2902
25하수도욕탕용11~500120전북특별자치도 장수군청063-350-2902
26하수도욕탕용2501~700128전북특별자치도 장수군청063-350-2902
27하수도욕탕용3701~1000146전북특별자치도 장수군청063-350-2902
28하수도욕탕용41001이상166전북특별자치도 장수군청063-350-2902