Overview

Dataset statistics

Number of variables4
Number of observations212
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.0 KiB
Average record size in memory33.6 B

Variable types

Numeric1
Text2
DateTime1

Dataset

Description해당 데이터는 경상북도 고령군에 설치된 스마트워터미터기 위치 주소 데이터 입니다. 현재는 2023년 8월 기준으로 등록되어 있습니다.
URLhttps://www.data.go.kr/data/15103207/fileData.do

Alerts

기준일자 has constant value ""Constant
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 17:14:42.820448
Analysis finished2023-12-12 17:14:43.105136
Duration0.28 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct212
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean106.5
Minimum1
Maximum212
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.0 KiB
2023-12-13T02:14:43.173518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile11.55
Q153.75
median106.5
Q3159.25
95-th percentile201.45
Maximum212
Range211
Interquartile range (IQR)105.5

Descriptive statistics

Standard deviation61.343296
Coefficient of variation (CV)0.57599339
Kurtosis-1.2
Mean106.5
Median Absolute Deviation (MAD)53
Skewness0
Sum22578
Variance3763
MonotonicityStrictly increasing
2023-12-13T02:14:43.307955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.5%
135 1
 
0.5%
137 1
 
0.5%
138 1
 
0.5%
139 1
 
0.5%
140 1
 
0.5%
141 1
 
0.5%
142 1
 
0.5%
143 1
 
0.5%
144 1
 
0.5%
Other values (202) 202
95.3%
ValueCountFrequency (%)
1 1
0.5%
2 1
0.5%
3 1
0.5%
4 1
0.5%
5 1
0.5%
6 1
0.5%
7 1
0.5%
8 1
0.5%
9 1
0.5%
10 1
0.5%
ValueCountFrequency (%)
212 1
0.5%
211 1
0.5%
210 1
0.5%
209 1
0.5%
208 1
0.5%
207 1
0.5%
206 1
0.5%
205 1
0.5%
204 1
0.5%
203 1
0.5%

주소
Text

Distinct206
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-13T02:14:43.563184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length15
Mean length11.169811
Min length7

Characters and Unicode

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

Unique

Unique200 ?
Unique (%)94.3%

Sample

1st row다산면 다산산단로10
2nd row다산면 다산산단로20
3rd row다산면 다산산단로30
4th row다산면 다산산단로38
5th row다산면 다산산단로50
ValueCountFrequency (%)
성산면 120
28.0%
다산면 62
 
14.5%
개진면 30
 
7.0%
기족1길23 2
 
0.5%
기족1길 2
 
0.5%
기족2길5 2
 
0.5%
개진산단길62 2
 
0.5%
기족길57 2
 
0.5%
기족리 2
 
0.5%
개진산단길40-21 2
 
0.5%
Other values (203) 203
47.3%
2023-12-13T02:14:43.977212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
325
13.7%
217
 
9.2%
212
 
9.0%
187
 
7.9%
1 136
 
5.7%
120
 
5.1%
120
 
5.1%
120
 
5.1%
119
 
5.0%
2 112
 
4.7%
Other values (25) 700
29.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1448
61.1%
Decimal Number 623
26.3%
Space Separator 217
 
9.2%
Dash Punctuation 78
 
3.3%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
325
22.4%
212
14.6%
187
12.9%
120
 
8.3%
120
 
8.3%
120
 
8.3%
119
 
8.2%
86
 
5.9%
59
 
4.1%
59
 
4.1%
Other values (11) 41
 
2.8%
Decimal Number
ValueCountFrequency (%)
1 136
21.8%
2 112
18.0%
4 64
10.3%
3 58
9.3%
0 56
9.0%
5 53
 
8.5%
7 47
 
7.5%
8 37
 
5.9%
6 34
 
5.5%
9 26
 
4.2%
Space Separator
ValueCountFrequency (%)
217
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 78
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1448
61.1%
Common 920
38.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
325
22.4%
212
14.6%
187
12.9%
120
 
8.3%
120
 
8.3%
120
 
8.3%
119
 
8.2%
86
 
5.9%
59
 
4.1%
59
 
4.1%
Other values (11) 41
 
2.8%
Common
ValueCountFrequency (%)
217
23.6%
1 136
14.8%
2 112
12.2%
- 78
 
8.5%
4 64
 
7.0%
3 58
 
6.3%
0 56
 
6.1%
5 53
 
5.8%
7 47
 
5.1%
8 37
 
4.0%
Other values (4) 62
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1448
61.1%
ASCII 920
38.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
325
22.4%
212
14.6%
187
12.9%
120
 
8.3%
120
 
8.3%
120
 
8.3%
119
 
8.2%
86
 
5.9%
59
 
4.1%
59
 
4.1%
Other values (11) 41
 
2.8%
ASCII
ValueCountFrequency (%)
217
23.6%
1 136
14.8%
2 112
12.2%
- 78
 
8.5%
4 64
 
7.0%
3 58
 
6.3%
0 56
 
6.1%
5 53
 
5.8%
7 47
 
5.1%
8 37
 
4.0%
Other values (4) 62
 
6.7%
Distinct198
Distinct (%)93.4%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-13T02:14:44.310822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length13
Mean length11.599057
Min length9

Characters and Unicode

Total characters2459
Distinct characters32
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

Unique184 ?
Unique (%)86.8%

Sample

1st row다산면 송곡리 1043
2nd row다산면 송곡리 1042
3rd row다산면 송곡리 1394
4th row다산면 송곡리 1395
5th row다산면 송곡리 1395-1
ValueCountFrequency (%)
성산면 120
18.9%
기족리 116
18.3%
다산면 62
 
9.8%
송곡리 57
 
9.0%
개진면 30
 
4.7%
신안리 20
 
3.2%
양전리 10
 
1.6%
기산리 4
 
0.6%
192 2
 
0.3%
상곡리 2
 
0.3%
Other values (194) 211
33.3%
2023-12-13T02:14:44.749372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
422
17.2%
212
 
8.6%
212
 
8.6%
187
 
7.6%
1 171
 
7.0%
120
 
4.9%
120
 
4.9%
116
 
4.7%
3 95
 
3.9%
2 94
 
3.8%
Other values (22) 710
28.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1275
51.9%
Decimal Number 712
29.0%
Space Separator 422
 
17.2%
Dash Punctuation 50
 
2.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
212
16.6%
212
16.6%
187
14.7%
120
9.4%
120
9.4%
116
9.1%
62
 
4.9%
61
 
4.8%
57
 
4.5%
30
 
2.4%
Other values (10) 98
7.7%
Decimal Number
ValueCountFrequency (%)
1 171
24.0%
3 95
13.3%
2 94
13.2%
4 71
10.0%
0 63
 
8.8%
5 49
 
6.9%
8 48
 
6.7%
9 44
 
6.2%
7 40
 
5.6%
6 37
 
5.2%
Space Separator
ValueCountFrequency (%)
422
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 50
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1275
51.9%
Common 1184
48.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
212
16.6%
212
16.6%
187
14.7%
120
9.4%
120
9.4%
116
9.1%
62
 
4.9%
61
 
4.8%
57
 
4.5%
30
 
2.4%
Other values (10) 98
7.7%
Common
ValueCountFrequency (%)
422
35.6%
1 171
14.4%
3 95
 
8.0%
2 94
 
7.9%
4 71
 
6.0%
0 63
 
5.3%
- 50
 
4.2%
5 49
 
4.1%
8 48
 
4.1%
9 44
 
3.7%
Other values (2) 77
 
6.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1275
51.9%
ASCII 1184
48.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
422
35.6%
1 171
14.4%
3 95
 
8.0%
2 94
 
7.9%
4 71
 
6.0%
0 63
 
5.3%
- 50
 
4.2%
5 49
 
4.1%
8 48
 
4.1%
9 44
 
3.7%
Other values (2) 77
 
6.5%
Hangul
ValueCountFrequency (%)
212
16.6%
212
16.6%
187
14.7%
120
9.4%
120
9.4%
116
9.1%
62
 
4.9%
61
 
4.8%
57
 
4.5%
30
 
2.4%
Other values (10) 98
7.7%

기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
Minimum2023-08-18 00:00:00
Maximum2023-08-18 00:00:00
2023-12-13T02:14:44.861141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:14:44.954072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T02:14:42.907428image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-13T02:14:42.998227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:14:43.072793image/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다산면 다산산단로10다산면 송곡리 10432023-08-18
12다산면 다산산단로20다산면 송곡리 10422023-08-18
23다산면 다산산단로30다산면 송곡리 13942023-08-18
34다산면 다산산단로38다산면 송곡리 13952023-08-18
45다산면 다산산단로50다산면 송곡리 1395-12023-08-18
56다산면 다산산단로60다산면 송곡리 10272023-08-18
67다산면 다산산단로70다산면 송곡리 10232023-08-18
78다산면 다산산단로76다산면 송곡리 1018-12023-08-18
89다산면 다산산단로82다산면 송곡리 10182023-08-18
910다산면 다산산단로88다산면 송곡리 10172023-08-18
연번주소지번주소기준일자
202203개진면 개진산단길73개진면 신안리 212023-08-18
203204개진면 개진산단길79개진면 신안리 202023-08-18
204205개진면 개진산단길84개진면 신안리 11-12023-08-18
205206개진면 개진산단길93개진면 신안리 152023-08-18
206207개진면 개진산단길93-6개진면 신안리 982023-08-18
207208다산면 상곡길28다산면 상곡리 162-72023-08-18
208209다산면 평리6길30다산면 곽촌리 129-112023-08-18
209210다산면 상곡길85다산면 상곡리 532023-08-18
210211다산면 상곡1길17다산면 상곡리3582023-08-18
211212다산면 상곡3길28다산면 상곡리3582023-08-18