Overview

Dataset statistics

Number of variables7
Number of observations1867
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory107.7 KiB
Average record size in memory59.1 B

Variable types

Numeric3
Categorical1
Text2
DateTime1

Dataset

Description스마트워터 미터기(원격검침기)가 설치되어 있는 수도관로(데이터 존재시), 수용가의 좌표(주소)데이터입니다.
Author충청북도 보은군
URLhttps://www.data.go.kr/data/15104072/fileData.do

Alerts

시군구 has constant value ""Constant
데이터기준일 has constant value ""Constant
순번 is highly overall correlated with 수용가 경도High correlation
수용가 경도 is highly overall correlated with 순번High correlation
순번 has unique valuesUnique
스마트워터 미터기 설치 수도관로 has unique valuesUnique

Reproduction

Analysis started2023-12-12 09:25:46.590863
Analysis finished2023-12-12 09:25:48.455871
Duration1.87 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct1867
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean934
Minimum1
Maximum1867
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size16.5 KiB
2023-12-12T18:25:48.529647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile94.3
Q1467.5
median934
Q31400.5
95-th percentile1773.7
Maximum1867
Range1866
Interquartile range (IQR)933

Descriptive statistics

Standard deviation539.10079
Coefficient of variation (CV)0.57719571
Kurtosis-1.2
Mean934
Median Absolute Deviation (MAD)467
Skewness0
Sum1743778
Variance290629.67
MonotonicityStrictly increasing
2023-12-12T18:25:48.720230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
1242 1
 
0.1%
1254 1
 
0.1%
1253 1
 
0.1%
1252 1
 
0.1%
1251 1
 
0.1%
1250 1
 
0.1%
1249 1
 
0.1%
1248 1
 
0.1%
1247 1
 
0.1%
Other values (1857) 1857
99.5%
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 (%)
1867 1
0.1%
1866 1
0.1%
1865 1
0.1%
1864 1
0.1%
1863 1
0.1%
1862 1
0.1%
1861 1
0.1%
1860 1
0.1%
1859 1
0.1%
1858 1
0.1%

시군구
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.7 KiB
보은군
1867 

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 (%)
보은군 1867
100.0%

Length

2023-12-12T18:25:48.908066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:25:49.011405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
보은군 1867
100.0%

스마트워터 미터기 설치 수도관로
Text

UNIQUE 

Distinct1867
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size14.7 KiB
2023-12-12T18:25:49.230999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length19
Mean length18.996786
Min length13

Characters and Unicode

Total characters35467
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

Unique1867 ?
Unique (%)100.0%

Sample

1st row211-200-00-00001-00
2nd row211-200-00-00002-00
3rd row211-200-00-00003-00
4th row211-200-00-00004-00
5th row211-200-00-00005-00
ValueCountFrequency (%)
211-200-00-00001-00 1
 
0.1%
512-200-00-00043-00 1
 
0.1%
512-200-00-00010-00 1
 
0.1%
512-200-00-00009-00 1
 
0.1%
512-200-00-00008-00 1
 
0.1%
512-200-00-00007-00 1
 
0.1%
512-200-00-00006-00 1
 
0.1%
512-200-00-00005-00 1
 
0.1%
512-200-00-00004-00 1
 
0.1%
512-200-00-00003-00 1
 
0.1%
Other values (1857) 1857
99.5%
2023-12-12T18:25:49.707218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 16998
47.9%
- 7467
21.1%
2 3591
 
10.1%
1 2957
 
8.3%
3 1209
 
3.4%
5 996
 
2.8%
4 538
 
1.5%
9 488
 
1.4%
7 487
 
1.4%
6 457
 
1.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 28000
78.9%
Dash Punctuation 7467
 
21.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 16998
60.7%
2 3591
 
12.8%
1 2957
 
10.6%
3 1209
 
4.3%
5 996
 
3.6%
4 538
 
1.9%
9 488
 
1.7%
7 487
 
1.7%
6 457
 
1.6%
8 279
 
1.0%
Dash Punctuation
ValueCountFrequency (%)
- 7467
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 35467
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 16998
47.9%
- 7467
21.1%
2 3591
 
10.1%
1 2957
 
8.3%
3 1209
 
3.4%
5 996
 
2.8%
4 538
 
1.5%
9 488
 
1.4%
7 487
 
1.4%
6 457
 
1.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 35467
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 16998
47.9%
- 7467
21.1%
2 3591
 
10.1%
1 2957
 
8.3%
3 1209
 
3.4%
5 996
 
2.8%
4 538
 
1.5%
9 488
 
1.4%
7 487
 
1.4%
6 457
 
1.3%

수용가 위도
Real number (ℝ)

Distinct1617
Distinct (%)86.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36.564462
Minimum36.391906
Maximum37.528564
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size16.5 KiB
2023-12-12T18:25:49.895053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum36.391906
5-th percentile36.396109
Q136.451818
median36.530353
Q336.55252
95-th percentile37.528476
Maximum37.528564
Range1.136658
Interquartile range (IQR)0.1007025

Descriptive statistics

Standard deviation0.25506125
Coefficient of variation (CV)0.0069756597
Kurtosis9.6541742
Mean36.564462
Median Absolute Deviation (MAD)0.048931
Skewness3.2628473
Sum68265.851
Variance0.065056239
MonotonicityNot monotonic
2023-12-12T18:25:50.070536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.528491 10
 
0.5%
37.528514 8
 
0.4%
37.528507 7
 
0.4%
37.528484 7
 
0.4%
37.528499 7
 
0.4%
37.528503 6
 
0.3%
37.528495 6
 
0.3%
37.528522 6
 
0.3%
36.530357 5
 
0.3%
37.528518 5
 
0.3%
Other values (1607) 1800
96.4%
ValueCountFrequency (%)
36.391906 1
0.1%
36.393722 1
0.1%
36.393943 1
0.1%
36.39397 1
0.1%
36.394195 1
0.1%
36.394287 1
0.1%
36.394321 1
0.1%
36.394332 1
0.1%
36.394355 1
0.1%
36.394367 1
0.1%
ValueCountFrequency (%)
37.528564 1
 
0.1%
37.52856 1
 
0.1%
37.528556 1
 
0.1%
37.528549 2
 
0.1%
37.528545 1
 
0.1%
37.528541 1
 
0.1%
37.528537 2
 
0.1%
37.528533 3
0.2%
37.52853 2
 
0.1%
37.528526 5
0.3%

수용가 경도
Real number (ℝ)

HIGH CORRELATION 

Distinct1488
Distinct (%)79.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.71907
Minimum127.16808
Maximum127.83561
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size16.5 KiB
2023-12-12T18:25:50.271681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.16808
5-th percentile127.16817
Q1127.67633
median127.73649
Q3127.8196
95-th percentile127.82254
Maximum127.83561
Range0.667534
Interquartile range (IQR)0.143269

Descriptive statistics

Standard deviation0.15335839
Coefficient of variation (CV)0.0012007478
Kurtosis7.3664376
Mean127.71907
Median Absolute Deviation (MAD)0.073227
Skewness-2.7651279
Sum238451.5
Variance0.023518795
MonotonicityNot monotonic
2023-12-12T18:25:50.459076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.168136 16
 
0.9%
127.168128 13
 
0.7%
127.168167 12
 
0.6%
127.168144 11
 
0.6%
127.168182 10
 
0.5%
127.168159 9
 
0.5%
127.168174 8
 
0.4%
127.821434 7
 
0.4%
127.168151 7
 
0.4%
127.821739 6
 
0.3%
Other values (1478) 1768
94.7%
ValueCountFrequency (%)
127.168075 1
 
0.1%
127.168083 2
 
0.1%
127.16809 1
 
0.1%
127.168098 2
 
0.1%
127.168106 5
 
0.3%
127.168113 4
 
0.2%
127.168121 5
 
0.3%
127.168128 13
0.7%
127.168136 16
0.9%
127.168144 11
0.6%
ValueCountFrequency (%)
127.835609 1
0.1%
127.834411 1
0.1%
127.833488 1
0.1%
127.831863 1
0.1%
127.827842 1
0.1%
127.827781 1
0.1%
127.82756 1
0.1%
127.827003 1
0.1%
127.826942 1
0.1%
127.826354 1
0.1%

스마트워터 미터기 설치된 수용가 주소
Text

Distinct1839
Distinct (%)98.5%
Missing0
Missing (%)0.0%
Memory size14.7 KiB
2023-12-12T18:25:50.814211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length27
Mean length14.13819
Min length9

Characters and Unicode

Total characters26396
Distinct characters369
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

Unique1811 ?
Unique (%)97.0%

Sample

1st row속리산면 사내1길 105-1 (하이퍼)
2nd row속리산면 사내1길 103
3rd row속리산면 사내1길 101-1
4th row속리산면 사내1길 101
5th row속리산면 사내1길 99
ValueCountFrequency (%)
속리산면 691
 
12.7%
삼승면 496
 
9.1%
내북면 461
 
8.5%
장안면 165
 
3.0%
사내1길 106
 
2.0%
남부로 73
 
1.3%
동산도원길 71
 
1.3%
장안2길 64
 
1.2%
원남로 57
 
1.1%
장안로 54
 
1.0%
Other values (1659) 3184
58.7%
2023-12-12T18:25:51.336280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3556
 
13.5%
면 1867
 
7.1%
1 1419
 
5.4%
길 1220
 
4.6%
산 977
 
3.7%
2 976
 
3.7%
- 969
 
3.7%
내 949
 
3.6%
리 885
 
3.4%
속 771
 
2.9%
Other values (359) 12807
48.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 14777
56.0%
Decimal Number 6196
23.5%
Space Separator 3556
 
13.5%
Dash Punctuation 969
 
3.7%
Open Punctuation 446
 
1.7%
Close Punctuation 442
 
1.7%
Uppercase Letter 8
 
< 0.1%
Other Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
면 1867
 
12.6%
길 1220
 
8.3%
산 977
 
6.6%
내 949
 
6.4%
리 885
 
6.0%
속 771
 
5.2%
로 682
 
4.6%
사 570
 
3.9%
삼 566
 
3.8%
승 560
 
3.8%
Other values (337) 5730
38.8%
Decimal Number
ValueCountFrequency (%)
1 1419
22.9%
2 976
15.8%
3 735
11.9%
6 577
9.3%
5 550
 
8.9%
4 540
 
8.7%
7 397
 
6.4%
9 375
 
6.1%
0 315
 
5.1%
8 312
 
5.0%
Uppercase Letter
ValueCountFrequency (%)
B 2
25.0%
Q 1
12.5%
A 1
12.5%
C 1
12.5%
O 1
12.5%
K 1
12.5%
U 1
12.5%
Space Separator
ValueCountFrequency (%)
3556
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 969
100.0%
Open Punctuation
ValueCountFrequency (%)
( 446
100.0%
Close Punctuation
ValueCountFrequency (%)
) 442
100.0%
Other Punctuation
ValueCountFrequency (%)
. 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 14777
56.0%
Common 11611
44.0%
Latin 8
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
면 1867
 
12.6%
길 1220
 
8.3%
산 977
 
6.6%
내 949
 
6.4%
리 885
 
6.0%
속 771
 
5.2%
로 682
 
4.6%
사 570
 
3.9%
삼 566
 
3.8%
승 560
 
3.8%
Other values (337) 5730
38.8%
Common
ValueCountFrequency (%)
3556
30.6%
1 1419
 
12.2%
2 976
 
8.4%
- 969
 
8.3%
3 735
 
6.3%
6 577
 
5.0%
5 550
 
4.7%
4 540
 
4.7%
( 446
 
3.8%
) 442
 
3.8%
Other values (5) 1401
 
12.1%
Latin
ValueCountFrequency (%)
B 2
25.0%
Q 1
12.5%
A 1
12.5%
C 1
12.5%
O 1
12.5%
K 1
12.5%
U 1
12.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 14777
56.0%
ASCII 11619
44.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3556
30.6%
1 1419
 
12.2%
2 976
 
8.4%
- 969
 
8.3%
3 735
 
6.3%
6 577
 
5.0%
5 550
 
4.7%
4 540
 
4.6%
( 446
 
3.8%
) 442
 
3.8%
Other values (12) 1409
 
12.1%
Hangul
ValueCountFrequency (%)
면 1867
 
12.6%
길 1220
 
8.3%
산 977
 
6.6%
내 949
 
6.4%
리 885
 
6.0%
속 771
 
5.2%
로 682
 
4.6%
사 570
 
3.9%
삼 566
 
3.8%
승 560
 
3.8%
Other values (337) 5730
38.8%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.7 KiB
Minimum2022-08-05 00:00:00
Maximum2022-08-05 00:00:00
2023-12-12T18:25:51.480897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:25:51.592492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T18:25:47.874012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:25:47.117056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:25:47.519419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:25:47.998361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:25:47.245913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:25:47.645830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:25:48.093565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:25:47.380385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:25:47.751144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T18:25:51.678635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번수용가 위도수용가 경도
순번1.0000.7660.924
수용가 위도0.7661.0000.844
수용가 경도0.9240.8441.000
2023-12-12T18:25:51.800226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번수용가 위도수용가 경도
순번1.0000.144-0.723
수용가 위도0.1441.000-0.294
수용가 경도-0.723-0.2941.000

Missing values

2023-12-12T18:25:48.251078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:25:48.393736image/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보은군211-200-00-00001-0036.534446127.822517속리산면 사내1길 105-1 (하이퍼)2022-08-05
12보은군211-200-00-00002-0036.534263127.82257속리산면 사내1길 1032022-08-05
23보은군211-200-00-00003-0036.534072127.822525속리산면 사내1길 101-12022-08-05
34보은군211-200-00-00004-0036.534046127.82241속리산면 사내1길 1012022-08-05
45보은군211-200-00-00005-0036.534008127.822319속리산면 사내1길 992022-08-05
56보은군211-200-00-00006-0036.533859127.822456속리산면 사내1길 97 (사내골막국수)2022-08-05
67보은군211-200-00-00007-0036.533523127.82238속리산면 사내1길 95 (대중식당)2022-08-05
78보은군211-200-00-00008-0036.533645127.822235속리산면 사내1길 93-62022-08-05
89보은군211-200-00-00009-0036.533576127.822059속리산면 사내1길 93-5 (광명철학관)2022-08-05
910보은군211-200-00-00010-0036.533557127.821945속리산면 사내1길 93-32022-08-05
순번시군구스마트워터 미터기 설치 수도관로수용가 위도수용가 경도스마트워터 미터기 설치된 수용가 주소데이터기준일
18571858보은군917-200-00-00027-0036.480201127.800788장안면 장안로 222-7(청솔가든)2022-08-05
18581859보은군917-200-00-00028-0036.48138127.801933장안면 장안로 222-47(서원펜션)2022-08-05
18591860보은군917-200-00-00029-0036.482116127.803138장안면 장안로 222-602022-08-05
18601861보은군917-200-00-00030-0036.481918127.802986장안면 장안로 222-582022-08-05
18611862보은군917-200-00-00031-0036.475673127.801322장안면 장안로 172-122022-08-05
18621863보은군918-200-00-00001-0036.466426127.787178장안면 보청대로 10632022-08-05
18631864보은군918-200-00-00002-0036.465839127.787216장안면 황곡길 82022-08-05
18641865보은군918-200-00-00003-0036.466148127.7873장안면 황곡길 22022-08-05
18651866보은군918-200-00-00004-0036.465625127.78688장안면 황곡길 12-42022-08-05
18661867보은군918-200-00-00005-0036.465496127.786575장안면 황곡길 12-62022-08-05