Overview

Dataset statistics

Number of variables3
Number of observations3401
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory83.2 KiB
Average record size in memory25.0 B

Variable types

Numeric1
Text2

Dataset

Description2022년 7월말기준 청도군 관내에 설치된 스마트워터미터기(원격검침 계량기)의 위치에 대한 정보로 순번, 수용가번호, 주소로 구성되어 있습니다.
Author경상북도 청도군
URLhttps://www.data.go.kr/data/15102845/fileData.do

Alerts

순번 has unique valuesUnique
수용가번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 17:32:08.897928
Analysis finished2023-12-12 17:32:09.400381
Duration0.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct3401
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1701
Minimum1
Maximum3401
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size30.0 KiB
2023-12-13T02:32:09.489775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile171
Q1851
median1701
Q32551
95-th percentile3231
Maximum3401
Range3400
Interquartile range (IQR)1700

Descriptive statistics

Standard deviation981.92846
Coefficient of variation (CV)0.57726541
Kurtosis-1.2
Mean1701
Median Absolute Deviation (MAD)850
Skewness0
Sum5785101
Variance964183.5
MonotonicityStrictly increasing
2023-12-13T02:32:09.960243image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
2260 1
 
< 0.1%
2262 1
 
< 0.1%
2263 1
 
< 0.1%
2264 1
 
< 0.1%
2265 1
 
< 0.1%
2266 1
 
< 0.1%
2267 1
 
< 0.1%
2268 1
 
< 0.1%
2269 1
 
< 0.1%
Other values (3391) 3391
99.7%
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 (%)
3401 1
< 0.1%
3400 1
< 0.1%
3399 1
< 0.1%
3398 1
< 0.1%
3397 1
< 0.1%
3396 1
< 0.1%
3395 1
< 0.1%
3394 1
< 0.1%
3393 1
< 0.1%
3392 1
< 0.1%

수용가번호
Text

UNIQUE 

Distinct3401
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size26.7 KiB
2023-12-13T02:32:10.272501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length19
Mean length19
Min length19

Characters and Unicode

Total characters64619
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique3401 ?
Unique (%)100.0%

Sample

1st row250-021-001-0018-00
2nd row250-021-001-0069-05
3rd row250-021-001-0070-00
4th row250-022-002-0202-01
5th row250-022-003-0001-00
ValueCountFrequency (%)
250-021-001-0018-00 1
 
< 0.1%
340-042-001-0026-00 1
 
< 0.1%
340-040-001-0028-00 1
 
< 0.1%
340-040-001-0039-00 1
 
< 0.1%
340-040-001-0029-00 1
 
< 0.1%
340-040-001-0030-00 1
 
< 0.1%
340-040-001-0031-00 1
 
< 0.1%
340-040-001-0032-00 1
 
< 0.1%
340-040-001-0033-00 1
 
< 0.1%
340-040-001-0034-00 1
 
< 0.1%
Other values (3391) 3391
99.7%
2023-12-13T02:32:10.709993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 27070
41.9%
- 13604
21.1%
3 6377
 
9.9%
1 5121
 
7.9%
2 3665
 
5.7%
4 2647
 
4.1%
5 2167
 
3.4%
6 1086
 
1.7%
8 1058
 
1.6%
7 956
 
1.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 51015
78.9%
Dash Punctuation 13604
 
21.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 27070
53.1%
3 6377
 
12.5%
1 5121
 
10.0%
2 3665
 
7.2%
4 2647
 
5.2%
5 2167
 
4.2%
6 1086
 
2.1%
8 1058
 
2.1%
7 956
 
1.9%
9 868
 
1.7%
Dash Punctuation
ValueCountFrequency (%)
- 13604
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 64619
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 27070
41.9%
- 13604
21.1%
3 6377
 
9.9%
1 5121
 
7.9%
2 3665
 
5.7%
4 2647
 
4.1%
5 2167
 
3.4%
6 1086
 
1.7%
8 1058
 
1.6%
7 956
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 64619
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 27070
41.9%
- 13604
21.1%
3 6377
 
9.9%
1 5121
 
7.9%
2 3665
 
5.7%
4 2647
 
4.1%
5 2167
 
3.4%
6 1086
 
1.7%
8 1058
 
1.6%
7 956
 
1.5%

주소
Text

Distinct3377
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size26.7 KiB
2023-12-13T02:32:11.157064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length26
Mean length21.637166
Min length17

Characters and Unicode

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

Unique

Unique3354 ?
Unique (%)98.6%

Sample

1st row경상북도 청도군 화양읍 도주관로 168
2nd row경상북도 청도군 화양읍 동상리 168-1
3rd row경상북도 청도군 화양읍 동헌길 15
4th row경상북도 청도군 화양읍 도주관로 146
5th row경상북도 청도군 화양읍 도주관로 62
ValueCountFrequency (%)
청도군 3402
20.0%
경상북도 3401
20.0%
각북면 708
 
4.2%
풍각면 538
 
3.2%
청도읍 488
 
2.9%
운문면 454
 
2.7%
각남면 353
 
2.1%
화양읍 260
 
1.5%
이서면 245
 
1.4%
매전면 236
 
1.4%
Other values (2171) 6923
40.7%
2023-12-13T02:32:11.715339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
15235
20.7%
도 7309
 
9.9%
북 4275
 
5.8%
청 3974
 
5.4%
상 3492
 
4.7%
경 3426
 
4.7%
군 3402
 
4.6%
1 2905
 
3.9%
길 2688
 
3.7%
면 2653
 
3.6%
Other values (128) 24229
32.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 44662
60.7%
Space Separator 15235
 
20.7%
Decimal Number 11840
 
16.1%
Dash Punctuation 1850
 
2.5%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 7309
16.4%
북 4275
 
9.6%
청 3974
 
8.9%
상 3492
 
7.8%
경 3426
 
7.7%
군 3402
 
7.6%
길 2688
 
6.0%
면 2653
 
5.9%
각 1620
 
3.6%
읍 750
 
1.7%
Other values (115) 11073
24.8%
Decimal Number
ValueCountFrequency (%)
1 2905
24.5%
2 1780
15.0%
3 1571
13.3%
4 1172
9.9%
5 918
 
7.8%
6 849
 
7.2%
0 694
 
5.9%
8 688
 
5.8%
7 643
 
5.4%
9 620
 
5.2%
Space Separator
ValueCountFrequency (%)
15235
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1850
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 44662
60.7%
Common 28926
39.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 7309
16.4%
북 4275
 
9.6%
청 3974
 
8.9%
상 3492
 
7.8%
경 3426
 
7.7%
군 3402
 
7.6%
길 2688
 
6.0%
면 2653
 
5.9%
각 1620
 
3.6%
읍 750
 
1.7%
Other values (115) 11073
24.8%
Common
ValueCountFrequency (%)
15235
52.7%
1 2905
 
10.0%
- 1850
 
6.4%
2 1780
 
6.2%
3 1571
 
5.4%
4 1172
 
4.1%
5 918
 
3.2%
6 849
 
2.9%
0 694
 
2.4%
8 688
 
2.4%
Other values (3) 1264
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 44662
60.7%
ASCII 28926
39.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
15235
52.7%
1 2905
 
10.0%
- 1850
 
6.4%
2 1780
 
6.2%
3 1571
 
5.4%
4 1172
 
4.1%
5 918
 
3.2%
6 849
 
2.9%
0 694
 
2.4%
8 688
 
2.4%
Other values (3) 1264
 
4.4%
Hangul
ValueCountFrequency (%)
도 7309
16.4%
북 4275
 
9.6%
청 3974
 
8.9%
상 3492
 
7.8%
경 3426
 
7.7%
군 3402
 
7.6%
길 2688
 
6.0%
면 2653
 
5.9%
각 1620
 
3.6%
읍 750
 
1.7%
Other values (115) 11073
24.8%

Interactions

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

Missing values

2023-12-13T02:32:09.253666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:32:09.356436image/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

순번수용가번호주소
01250-021-001-0018-00경상북도 청도군 화양읍 도주관로 168
12250-021-001-0069-05경상북도 청도군 화양읍 동상리 168-1
23250-021-001-0070-00경상북도 청도군 화양읍 동헌길 15
34250-022-002-0202-01경상북도 청도군 화양읍 도주관로 146
45250-022-003-0001-00경상북도 청도군 화양읍 도주관로 62
56250-022-003-0003-01경상북도 청도군 화양읍 도주관로 32
67250-024-005-0027-01경상북도 청도군 화양읍 교촌리 37
78250-024-005-0028-15경상북도 청도군 화양읍 동천3길 67
89250-025-006-0006-00경상북도 청도군 화양읍 도주관로 179
910250-025-006-0009-01경상북도 청도군 화양읍 도주관로 176
순번수용가번호주소
33913392350-042-002-0044-00경상북도 청도군 운문면 마일3길 11
33923393350-042-002-0045-00경상북도 청도군 운문면 마일3길 13
33933394350-042-002-0046-00경상북도 청도군 운문면 운북로 695-14
33943395350-048-001-0042-00경상북도 청도군 운문면 동경길 41
33953396350-048-001-0043-00경상북도 청도군 운문면 동경길 43
33963397350-048-001-0044-00경상북도 청도군 운문면 동경길 45-3
33973398350-048-001-0045-00경상북도 청도군 운문면 동경길 45-5
33983399350-048-001-0046-00경상북도 청도군 운문면 동경길 57
33993400350-048-001-0047-00경상북도 청도군 운문면 동경길 55
34003401360-035-002-0005-00경상북도 청도군 금천면 소천리 525