Overview

Dataset statistics

Number of variables6
Number of observations1561
Missing cells1561
Missing cells (%)16.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory76.3 KiB
Average record size in memory50.1 B

Variable types

Numeric1
Categorical3
Text1
Unsupported1

Dataset

Description상수도수용가정보를확인할수있는스마트검침시스템으로아산시스마트워터미터기의위치정보데이터를제공합니다
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=97&beforeMenuCd=DOM_000000201001001000&publicdatapk=15104186

Alerts

시도명 has constant value ""Constant
시군구명 has constant value ""Constant
데이터기준일 has constant value ""Constant
Unnamed: 5 has 1561 (100.0%) missing valuesMissing
연번 has unique valuesUnique
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-01-09 23:13:58.908539
Analysis finished2024-01-09 23:13:59.340834
Duration0.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct1561
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean781
Minimum1
Maximum1561
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size13.8 KiB
2024-01-10T08:13:59.412482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile79
Q1391
median781
Q31171
95-th percentile1483
Maximum1561
Range1560
Interquartile range (IQR)780

Descriptive statistics

Standard deviation450.7662
Coefficient of variation (CV)0.57716543
Kurtosis-1.2
Mean781
Median Absolute Deviation (MAD)390
Skewness0
Sum1219141
Variance203190.17
MonotonicityStrictly increasing
2024-01-10T08:13:59.551270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
1026 1
 
0.1%
1048 1
 
0.1%
1047 1
 
0.1%
1046 1
 
0.1%
1045 1
 
0.1%
1044 1
 
0.1%
1043 1
 
0.1%
1042 1
 
0.1%
1041 1
 
0.1%
Other values (1551) 1551
99.4%
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 (%)
1561 1
0.1%
1560 1
0.1%
1559 1
0.1%
1558 1
0.1%
1557 1
0.1%
1556 1
0.1%
1555 1
0.1%
1554 1
0.1%
1553 1
0.1%
1552 1
0.1%

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size12.3 KiB
충청남도
1561 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row충청남도
2nd row충청남도
3rd row충청남도
4th row충청남도
5th row충청남도

Common Values

ValueCountFrequency (%)
충청남도 1561
100.0%

Length

2024-01-10T08:13:59.683691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T08:13:59.774865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
충청남도 1561
100.0%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size12.3 KiB
아산시
1561 

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 (%)
아산시 1561
100.0%

Length

2024-01-10T08:13:59.872700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T08:13:59.968711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
아산시 1561
100.0%

도로명 주소
Text

Distinct1541
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size12.3 KiB
2024-01-10T08:14:00.187563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length64
Median length45
Mean length31.021781
Min length14

Characters and Unicode

Total characters48425
Distinct characters148
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1525 ?
Unique (%)97.7%

Sample

1st row충남 아산시 염치읍 석정길60
2nd row충남 아산시 염치읍 석정길21-15
3rd row충남 아산시 염치읍 쌍죽길179-7
4th row충남 아산시 염치읍 서원길238-22
5th row충남 아산시 배방읍 북수로 125
ValueCountFrequency (%)
아산시 1565
 
17.2%
충남 1524
 
16.8%
인주면 1490
 
16.4%
현대로 199
 
2.2%
아산만로 69
 
0.8%
공세길 58
 
0.6%
인주산단로 51
 
0.6%
아산만로1434번길 47
 
0.5%
걸매길 43
 
0.5%
도흥길 40
 
0.4%
Other values (2546) 4002
44.0%
2024-01-10T08:14:00.579589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7545
 
15.6%
1 2871
 
5.9%
산 2002
 
4.1%
2 1920
 
4.0%
아 1836
 
3.8%
인 1716
 
3.5%
- 1671
 
3.5%
주 1619
 
3.3%
남 1597
 
3.3%
시 1572
 
3.2%
Other values (138) 24076
49.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 23740
49.0%
Decimal Number 12562
25.9%
Space Separator 7545
 
15.6%
Dash Punctuation 1671
 
3.5%
Open Punctuation 1409
 
2.9%
Close Punctuation 1409
 
2.9%
Other Punctuation 73
 
0.2%
Uppercase Letter 16
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 2002
 
8.4%
아 1836
 
7.7%
인 1716
 
7.2%
주 1619
 
6.8%
남 1597
 
6.7%
시 1572
 
6.6%
충 1566
 
6.6%
면 1526
 
6.4%
리 1439
 
6.1%
길 1226
 
5.2%
Other values (120) 7641
32.2%
Decimal Number
ValueCountFrequency (%)
1 2871
22.9%
2 1920
15.3%
3 1410
11.2%
4 1224
9.7%
6 925
 
7.4%
5 906
 
7.2%
7 888
 
7.1%
8 873
 
6.9%
0 867
 
6.9%
9 678
 
5.4%
Uppercase Letter
ValueCountFrequency (%)
A 14
87.5%
T 1
 
6.2%
K 1
 
6.2%
Space Separator
ValueCountFrequency (%)
7545
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1671
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1409
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1409
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 73
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 24669
50.9%
Hangul 23740
49.0%
Latin 16
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 2002
 
8.4%
아 1836
 
7.7%
인 1716
 
7.2%
주 1619
 
6.8%
남 1597
 
6.7%
시 1572
 
6.6%
충 1566
 
6.6%
면 1526
 
6.4%
리 1439
 
6.1%
길 1226
 
5.2%
Other values (120) 7641
32.2%
Common
ValueCountFrequency (%)
7545
30.6%
1 2871
 
11.6%
2 1920
 
7.8%
- 1671
 
6.8%
3 1410
 
5.7%
( 1409
 
5.7%
) 1409
 
5.7%
4 1224
 
5.0%
6 925
 
3.7%
5 906
 
3.7%
Other values (5) 3379
13.7%
Latin
ValueCountFrequency (%)
A 14
87.5%
T 1
 
6.2%
K 1
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 24685
51.0%
Hangul 23740
49.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
7545
30.6%
1 2871
 
11.6%
2 1920
 
7.8%
- 1671
 
6.8%
3 1410
 
5.7%
( 1409
 
5.7%
) 1409
 
5.7%
4 1224
 
5.0%
6 925
 
3.7%
5 906
 
3.7%
Other values (8) 3395
13.8%
Hangul
ValueCountFrequency (%)
산 2002
 
8.4%
아 1836
 
7.7%
인 1716
 
7.2%
주 1619
 
6.8%
남 1597
 
6.7%
시 1572
 
6.6%
충 1566
 
6.6%
면 1526
 
6.4%
리 1439
 
6.1%
길 1226
 
5.2%
Other values (120) 7641
32.2%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size12.3 KiB
2022-08-11
1561 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-08-11
2nd row2022-08-11
3rd row2022-08-11
4th row2022-08-11
5th row2022-08-11

Common Values

ValueCountFrequency (%)
2022-08-11 1561
100.0%

Length

2024-01-10T08:14:00.704516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T08:14:00.796830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-08-11 1561
100.0%

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1561
Missing (%)100.0%
Memory size13.8 KiB

Interactions

2024-01-10T08:13:59.065094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2024-01-10T08:13:59.196729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T08:13:59.295817image/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

연번시도명시군구명도로명 주소데이터기준일Unnamed: 5
01충청남도아산시충남 아산시 염치읍 석정길602022-08-11<NA>
12충청남도아산시충남 아산시 염치읍 석정길21-152022-08-11<NA>
23충청남도아산시충남 아산시 염치읍 쌍죽길179-72022-08-11<NA>
34충청남도아산시충남 아산시 염치읍 서원길238-222022-08-11<NA>
45충청남도아산시충남 아산시 배방읍 북수로 1252022-08-11<NA>
56충청남도아산시충남 아산시 배방읍 휴대안길 78-112022-08-11<NA>
67충청남도아산시충남 아산시 배방읍 설화고길2번길 7-62022-08-11<NA>
78충청남도아산시충남 아산시 배방읍 휴대세교길43번길 27-192022-08-11<NA>
89충청남도아산시충남 아산시 배방읍 휴대세교길43번길 27-212022-08-11<NA>
910충청남도아산시충남 아산시 배방읍 휴대세교길 100-282022-08-11<NA>
연번시도명시군구명도로명 주소데이터기준일Unnamed: 5
15511552충청남도아산시충남 아산시 번영로 34 (실옥동183-108)2022-08-11<NA>
15521553충청남도아산시충남 아산시 번영로 31 (실옥동183-14)2022-08-11<NA>
15531554충청남도아산시충남 아산시 시민로 287-1(용화동 251-5)2022-08-11<NA>
15541555충청남도아산시충남 아산시 온화로 95 (용화동)2022-08-11<NA>
15551556충청남도아산시충남 아산시 용화고길 61-3 (용화동 1420)2022-08-11<NA>
15561557충청남도아산시충남 아산시 용화고길 61-3 (용화동 1420)2022-08-11<NA>
15571558충청남도아산시충남 아산시 용화고길79번길 13 (용화동1576)2022-08-11<NA>
15581559충청남도아산시충남 아산시 용화고길79번길 13 (용화동1576)2022-08-11<NA>
15591560충청남도아산시충남 아산시 용화고길79번길 6 (용화동 1619)2022-08-11<NA>
15601561충청남도아산시충남 아산시 용화고길79번길 6 (용화동 1619)2022-08-11<NA>