Overview

Dataset statistics

Number of variables3
Number of observations1813
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory44.4 KiB
Average record size in memory25.1 B

Variable types

Numeric1
Text1
DateTime1

Dataset

Description상수도수용가정보를확인할수있는스마트검침시스템으로아산시스마트워터미터기의위치정보데이터를제공합니다
Author충청남도 아산시
URLhttps://www.data.go.kr/data/15104186/fileData.do

Alerts

데이터기준일 has constant value ""Constant
연번 has unique valuesUnique

Reproduction

Analysis started2024-04-21 02:13:02.508390
Analysis finished2024-04-21 02:13:03.236898
Duration0.73 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct1813
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean907
Minimum1
Maximum1813
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size16.1 KiB
2024-04-21T11:13:03.307682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile91.6
Q1454
median907
Q31360
95-th percentile1722.4
Maximum1813
Range1812
Interquartile range (IQR)906

Descriptive statistics

Standard deviation523.51234
Coefficient of variation (CV)0.57719111
Kurtosis-1.2
Mean907
Median Absolute Deviation (MAD)453
Skewness0
Sum1644391
Variance274065.17
MonotonicityStrictly increasing
2024-04-21T11:13:03.446603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
1192 1
 
0.1%
1218 1
 
0.1%
1217 1
 
0.1%
1216 1
 
0.1%
1215 1
 
0.1%
1214 1
 
0.1%
1213 1
 
0.1%
1212 1
 
0.1%
1211 1
 
0.1%
Other values (1803) 1803
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 (%)
1813 1
0.1%
1812 1
0.1%
1811 1
0.1%
1810 1
0.1%
1809 1
0.1%
1808 1
0.1%
1807 1
0.1%
1806 1
0.1%
1805 1
0.1%
1804 1
0.1%

도로명 주소
Text

Distinct1765
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size14.3 KiB
2024-04-21T11:13:03.735177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length52
Median length44
Mean length30.837286
Min length17

Characters and Unicode

Total characters55908
Distinct characters144
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

Unique1738 ?
Unique (%)95.9%

Sample

1st row충청남도 아산시 도고면 아산만로139번길 43(신언리485-6)
2nd row충청남도 아산시 도고면 덕암산로 150-20(석당리 166)
3rd row충청남도 아산시 선장면 서들북로39번길 30-8
4th row충청남도 아산시 도고면 아산만로139번길 40(신언리474-12)
5th row충청남도 아산시 도고면 아산만로 200-1(신언리150-6)
ValueCountFrequency (%)
아산시 1821
18.9%
충청남도 1820
18.9%
도고면 1278
 
13.3%
선장면 307
 
3.2%
아산만로 164
 
1.7%
영인면 100
 
1.0%
인주면 97
 
1.0%
기곡리 83
 
0.9%
신언리 66
 
0.7%
도고산로 51
 
0.5%
Other values (2194) 3853
40.0%
2024-04-21T11:13:04.158806image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
9642
 
17.2%
도 3460
 
6.2%
1 2899
 
5.2%
산 2707
 
4.8%
아 2296
 
4.1%
남 1971
 
3.5%
면 1911
 
3.4%
시 1841
 
3.3%
2 1835
 
3.3%
충 1823
 
3.3%
Other values (134) 25523
45.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 30060
53.8%
Decimal Number 12338
22.1%
Space Separator 9642
 
17.2%
Dash Punctuation 1768
 
3.2%
Close Punctuation 1029
 
1.8%
Open Punctuation 1029
 
1.8%
Other Punctuation 38
 
0.1%
Lowercase Letter 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 3460
 
11.5%
산 2707
 
9.0%
아 2296
 
7.6%
남 1971
 
6.6%
면 1911
 
6.4%
시 1841
 
6.1%
충 1823
 
6.1%
청 1820
 
6.1%
고 1697
 
5.6%
로 1391
 
4.6%
Other values (117) 9143
30.4%
Decimal Number
ValueCountFrequency (%)
1 2899
23.5%
2 1835
14.9%
3 1478
12.0%
4 1117
 
9.1%
5 1014
 
8.2%
6 905
 
7.3%
9 801
 
6.5%
0 789
 
6.4%
8 752
 
6.1%
7 748
 
6.1%
Other Punctuation
ValueCountFrequency (%)
: 22
57.9%
, 16
42.1%
Space Separator
ValueCountFrequency (%)
9642
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1768
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1029
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1029
100.0%
Lowercase Letter
ValueCountFrequency (%)
m 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 30060
53.8%
Common 25844
46.2%
Latin 4
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 3460
 
11.5%
산 2707
 
9.0%
아 2296
 
7.6%
남 1971
 
6.6%
면 1911
 
6.4%
시 1841
 
6.1%
충 1823
 
6.1%
청 1820
 
6.1%
고 1697
 
5.6%
로 1391
 
4.6%
Other values (117) 9143
30.4%
Common
ValueCountFrequency (%)
9642
37.3%
1 2899
 
11.2%
2 1835
 
7.1%
- 1768
 
6.8%
3 1478
 
5.7%
4 1117
 
4.3%
) 1029
 
4.0%
( 1029
 
4.0%
5 1014
 
3.9%
6 905
 
3.5%
Other values (6) 3128
 
12.1%
Latin
ValueCountFrequency (%)
m 4
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 30060
53.8%
ASCII 25848
46.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
9642
37.3%
1 2899
 
11.2%
2 1835
 
7.1%
- 1768
 
6.8%
3 1478
 
5.7%
4 1117
 
4.3%
) 1029
 
4.0%
( 1029
 
4.0%
5 1014
 
3.9%
6 905
 
3.5%
Other values (7) 3132
 
12.1%
Hangul
ValueCountFrequency (%)
도 3460
 
11.5%
산 2707
 
9.0%
아 2296
 
7.6%
남 1971
 
6.6%
면 1911
 
6.4%
시 1841
 
6.1%
충 1823
 
6.1%
청 1820
 
6.1%
고 1697
 
5.6%
로 1391
 
4.6%
Other values (117) 9143
30.4%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.3 KiB
Minimum2024-04-04 00:00:00
Maximum2024-04-04 00:00:00
2024-04-21T11:13:04.275954image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T11:13:04.368608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-04-21T11:13:02.977792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2024-04-21T11:13:03.110424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T11:13:03.196089image/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

연번도로명 주소데이터기준일
01충청남도 아산시 도고면 아산만로139번길 43(신언리485-6)2024-04-04
12충청남도 아산시 도고면 덕암산로 150-20(석당리 166)2024-04-04
23충청남도 아산시 선장면 서들북로39번길 30-82024-04-04
34충청남도 아산시 도고면 아산만로139번길 40(신언리474-12)2024-04-04
45충청남도 아산시 도고면 아산만로 200-1(신언리150-6)2024-04-04
56충청남도 아산시 도고면 기곡로62번길 6-82024-04-04
67충청남도 아산시 도고면 온천대로207번길21(금산리15-1)2024-04-04
78충청남도 아산시 도고면 도고면로 179(기곡리 270-7)2024-04-04
89충청남도 아산시 인주면 밀두리 149-132024-04-04
910충청남도 아산시 도고면 아산만로198번길 31(신언리188)2024-04-04
연번도로명 주소데이터기준일
18031804충청남도 아산시 선장면 서들남로159번길 14-12024-04-04
18041805충청남도 아산시 선장면 서들남로159번길 17-172024-04-04
18051806충청남도 아산시 선장면 서들남로159번길142024-04-04
18061807충청남도 아산시 선장면 서들남로159번길 162024-04-04
18071808충청남도 아산시 선장면 서들남로159번길 17-102024-04-04
18081809충청남도 아산시 선장면 서들남로159번길 6-42024-04-04
18091810충청남도 아산시 선장면 서들남로159번길 102024-04-04
18101811충청남도 아산시 선장면 서들남로159번길 169-72024-04-04
18111812충청남도 아산시 선장면 서들남로159번길 32-112024-04-04
18121813충청남도 아산시 선장면 서들남로159번길32-132024-04-04