Overview

Dataset statistics

Number of variables5
Number of observations1056
Missing cells5
Missing cells (%)0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory44.5 KiB
Average record size in memory43.1 B

Variable types

Numeric3
Text2

Dataset

Description2022년 8월 8일 기준 영광군 관내에 설치된 스마트워터미터키(원격검침기)의 위치에 대한 정보로 순번, 도로명주소, 지번주소, 위도, 경도로 구성되어 있습니다.
Author전라남도 영광군
URLhttps://www.data.go.kr/data/15103379/fileData.do

Alerts

순번 is highly overall correlated with 경도High correlation
경도 is highly overall correlated with 순번High correlation
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 05:32:17.127700
Analysis finished2023-12-12 05:32:18.646573
Duration1.52 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct1056
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean528.5
Minimum1
Maximum1056
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size9.4 KiB
2023-12-12T14:32:18.749500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile53.75
Q1264.75
median528.5
Q3792.25
95-th percentile1003.25
Maximum1056
Range1055
Interquartile range (IQR)527.5

Descriptive statistics

Standard deviation304.98525
Coefficient of variation (CV)0.5770771
Kurtosis-1.2
Mean528.5
Median Absolute Deviation (MAD)264
Skewness0
Sum558096
Variance93016
MonotonicityStrictly increasing
2023-12-12T14:32:18.914065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
711 1
 
0.1%
697 1
 
0.1%
698 1
 
0.1%
699 1
 
0.1%
700 1
 
0.1%
701 1
 
0.1%
702 1
 
0.1%
703 1
 
0.1%
704 1
 
0.1%
Other values (1046) 1046
99.1%
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 (%)
1056 1
0.1%
1055 1
0.1%
1054 1
0.1%
1053 1
0.1%
1052 1
0.1%
1051 1
0.1%
1050 1
0.1%
1049 1
0.1%
1048 1
0.1%
1047 1
0.1%

도로명주소
Text

Distinct671
Distinct (%)63.8%
Missing5
Missing (%)0.5%
Memory size8.4 KiB
2023-12-12T14:32:19.313264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length23
Mean length21.548049
Min length18

Characters and Unicode

Total characters22647
Distinct characters70
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

Unique547 ?
Unique (%)52.0%

Sample

1st row전라남도 영광군 영광읍 물무로2길 57-24
2nd row전라남도 영광군 영광읍 물무로2길 73-1
3rd row전라남도 영광군 영광읍 중앙로 215-25
4th row전라남도 영광군 영광읍 중앙로 233
5th row전라남도 영광군 영광읍 중앙로 238-2
ValueCountFrequency (%)
전라남도 1051
20.0%
영광군 1051
20.0%
영광읍 1012
19.3%
신남로 134
 
2.5%
대하길 87
 
1.7%
옥당로 84
 
1.6%
대하길3길 77
 
1.5%
천년로11길 62
 
1.2%
천년로10길 54
 
1.0%
4 51
 
1.0%
Other values (498) 1592
30.3%
2023-12-12T14:32:19.845604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4204
18.6%
영 2063
 
9.1%
광 2063
 
9.1%
남 1278
 
5.6%
1 1120
 
4.9%
군 1059
 
4.7%
전 1051
 
4.6%
라 1051
 
4.6%
도 1051
 
4.6%
읍 1014
 
4.5%
Other values (60) 6693
29.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 14279
63.1%
Space Separator 4204
 
18.6%
Decimal Number 3707
 
16.4%
Dash Punctuation 457
 
2.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
영 2063
14.4%
광 2063
14.4%
남 1278
9.0%
군 1059
7.4%
전 1051
7.4%
라 1051
7.4%
도 1051
7.4%
읍 1014
7.1%
길 964
6.8%
로 681
 
4.8%
Other values (48) 2004
14.0%
Decimal Number
ValueCountFrequency (%)
1 1120
30.2%
2 530
14.3%
5 354
 
9.5%
3 351
 
9.5%
4 300
 
8.1%
9 260
 
7.0%
0 250
 
6.7%
7 225
 
6.1%
6 188
 
5.1%
8 129
 
3.5%
Space Separator
ValueCountFrequency (%)
4204
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 457
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 14279
63.1%
Common 8368
36.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
영 2063
14.4%
광 2063
14.4%
남 1278
9.0%
군 1059
7.4%
전 1051
7.4%
라 1051
7.4%
도 1051
7.4%
읍 1014
7.1%
길 964
6.8%
로 681
 
4.8%
Other values (48) 2004
14.0%
Common
ValueCountFrequency (%)
4204
50.2%
1 1120
 
13.4%
2 530
 
6.3%
- 457
 
5.5%
5 354
 
4.2%
3 351
 
4.2%
4 300
 
3.6%
9 260
 
3.1%
0 250
 
3.0%
7 225
 
2.7%
Other values (2) 317
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 14279
63.1%
ASCII 8368
36.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4204
50.2%
1 1120
 
13.4%
2 530
 
6.3%
- 457
 
5.5%
5 354
 
4.2%
3 351
 
4.2%
4 300
 
3.6%
9 260
 
3.1%
0 250
 
3.0%
7 225
 
2.7%
Other values (2) 317
 
3.8%
Hangul
ValueCountFrequency (%)
영 2063
14.4%
광 2063
14.4%
남 1278
9.0%
군 1059
7.4%
전 1051
7.4%
라 1051
7.4%
도 1051
7.4%
읍 1014
7.1%
길 964
6.8%
로 681
 
4.8%
Other values (48) 2004
14.0%

지번주소
Text

Distinct649
Distinct (%)61.5%
Missing0
Missing (%)0.0%
Memory size8.4 KiB
2023-12-12T14:32:20.130747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length22
Mean length21.755682
Min length18

Characters and Unicode

Total characters22974
Distinct characters58
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

Unique511 ?
Unique (%)48.4%

Sample

1st row전라남도 영광군 영광읍 무령리 180-3
2nd row전라남도 영광군 영광읍 무령리 223-11
3rd row전라남도 영광군 영광읍 무령리 282
4th row전라남도 영광군 영광읍 무령리 280-7
5th row전라남도 영광군 영광읍 무령리 256-6
ValueCountFrequency (%)
전라남도 1056
20.0%
영광군 1056
20.0%
영광읍 1017
19.3%
신하리 506
9.6%
단주리 252
 
4.8%
교촌리 71
 
1.3%
남천리 63
 
1.2%
녹사리 56
 
1.1%
530 43
 
0.8%
도동리 31
 
0.6%
Other values (663) 1131
21.4%
2023-12-12T14:32:20.493126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4231
18.4%
영 2073
 
9.0%
광 2073
 
9.0%
남 1125
 
4.9%
도 1088
 
4.7%
군 1061
 
4.6%
전 1056
 
4.6%
리 1056
 
4.6%
라 1056
 
4.6%
읍 1019
 
4.4%
Other values (48) 7136
31.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 13730
59.8%
Space Separator 4231
 
18.4%
Decimal Number 4174
 
18.2%
Dash Punctuation 839
 
3.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
영 2073
15.1%
광 2073
15.1%
남 1125
8.2%
도 1088
7.9%
군 1061
7.7%
전 1056
7.7%
리 1056
7.7%
라 1056
7.7%
읍 1019
7.4%
신 507
 
3.7%
Other values (36) 1616
11.8%
Decimal Number
ValueCountFrequency (%)
2 670
16.1%
8 616
14.8%
1 594
14.2%
3 593
14.2%
6 397
9.5%
4 309
7.4%
0 297
7.1%
5 264
 
6.3%
9 231
 
5.5%
7 203
 
4.9%
Space Separator
ValueCountFrequency (%)
4231
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 839
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 13730
59.8%
Common 9244
40.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
영 2073
15.1%
광 2073
15.1%
남 1125
8.2%
도 1088
7.9%
군 1061
7.7%
전 1056
7.7%
리 1056
7.7%
라 1056
7.7%
읍 1019
7.4%
신 507
 
3.7%
Other values (36) 1616
11.8%
Common
ValueCountFrequency (%)
4231
45.8%
- 839
 
9.1%
2 670
 
7.2%
8 616
 
6.7%
1 594
 
6.4%
3 593
 
6.4%
6 397
 
4.3%
4 309
 
3.3%
0 297
 
3.2%
5 264
 
2.9%
Other values (2) 434
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 13730
59.8%
ASCII 9244
40.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4231
45.8%
- 839
 
9.1%
2 670
 
7.2%
8 616
 
6.7%
1 594
 
6.4%
3 593
 
6.4%
6 397
 
4.3%
4 309
 
3.3%
0 297
 
3.2%
5 264
 
2.9%
Other values (2) 434
 
4.7%
Hangul
ValueCountFrequency (%)
영 2073
15.1%
광 2073
15.1%
남 1125
8.2%
도 1088
7.9%
군 1061
7.7%
전 1056
7.7%
리 1056
7.7%
라 1056
7.7%
읍 1019
7.4%
신 507
 
3.7%
Other values (36) 1616
11.8%

위도
Real number (ℝ)

Distinct674
Distinct (%)63.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.276747
Minimum35.211468
Maximum35.392177
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size9.4 KiB
2023-12-12T14:32:20.615677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum35.211468
5-th percentile35.268346
Q135.273572
median35.274962
Q335.276526
95-th percentile35.279673
Maximum35.392177
Range0.18070871
Interquartile range (IQR)0.0029536051

Descriptive statistics

Standard deviation0.015126802
Coefficient of variation (CV)0.00042880378
Kurtosis27.421165
Mean35.276747
Median Absolute Deviation (MAD)0.0014219799
Skewness4.7750824
Sum37252.245
Variance0.00022882015
MonotonicityNot monotonic
2023-12-12T14:32:20.739630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
35.2725098896 43
 
4.1%
35.270710554 27
 
2.6%
35.2775039305 17
 
1.6%
35.2744458854 16
 
1.5%
35.2739863593 15
 
1.4%
35.2736702431 13
 
1.2%
35.2747284879 12
 
1.1%
35.2771469986 10
 
0.9%
35.2743897403 9
 
0.9%
35.2759565955 9
 
0.9%
Other values (664) 885
83.8%
ValueCountFrequency (%)
35.2114683523 1
 
0.1%
35.2313556082 1
 
0.1%
35.2327263751 1
 
0.1%
35.2360823125 3
0.3%
35.2371132231 1
 
0.1%
35.2396704244 1
 
0.1%
35.2399779192 1
 
0.1%
35.2401729614 1
 
0.1%
35.2404414608 1
 
0.1%
35.2645716593 1
 
0.1%
ValueCountFrequency (%)
35.3921770632 1
0.1%
35.3711093229 1
0.1%
35.3709124281 1
0.1%
35.3659985577 1
0.1%
35.3654625884 1
0.1%
35.365120383 1
0.1%
35.3641341097 1
0.1%
35.3638349235 1
0.1%
35.3635221263 1
0.1%
35.363457068 1
0.1%

경도
Real number (ℝ)

HIGH CORRELATION 

Distinct674
Distinct (%)63.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.49841
Minimum126.30282
Maximum126.51639
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size9.4 KiB
2023-12-12T14:32:20.861819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.30282
5-th percentile126.49172
Q1126.49769
median126.4992
Q3126.50187
95-th percentile126.51577
Maximum126.51639
Range0.21357426
Interquartile range (IQR)0.0041758121

Descriptive statistics

Standard deviation0.017696014
Coefficient of variation (CV)0.00013989119
Kurtosis62.286047
Mean126.49841
Median Absolute Deviation (MAD)0.0018480791
Skewness-6.6934841
Sum133582.32
Variance0.00031314889
MonotonicityNot monotonic
2023-12-12T14:32:20.981332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.5157650949 43
 
4.1%
126.5127328606 27
 
2.6%
126.4971700882 17
 
1.6%
126.4979489066 16
 
1.5%
126.5156294721 15
 
1.4%
126.5163907159 13
 
1.2%
126.49354591 12
 
1.1%
126.5037390889 10
 
0.9%
126.4992338808 9
 
0.9%
126.4987723879 9
 
0.9%
Other values (664) 885
83.8%
ValueCountFrequency (%)
126.302816452 3
0.3%
126.3042209586 1
 
0.1%
126.3615963066 1
 
0.1%
126.3735606703 1
 
0.1%
126.430064652 1
 
0.1%
126.4339189662 1
 
0.1%
126.4367127815 1
 
0.1%
126.4370395091 1
 
0.1%
126.4407697322 1
 
0.1%
126.4407811191 1
 
0.1%
ValueCountFrequency (%)
126.5163907159 13
 
1.2%
126.5158100369 1
 
0.1%
126.5157650949 43
4.1%
126.5156294721 15
 
1.4%
126.5152825804 1
 
0.1%
126.5150383349 1
 
0.1%
126.5148796726 1
 
0.1%
126.5147305277 1
 
0.1%
126.5133327253 1
 
0.1%
126.512979753 1
 
0.1%

Interactions

2023-12-12T14:32:18.011251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:32:17.362052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:32:17.664487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:32:18.133084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:32:17.455714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:32:17.789029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:32:18.276966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:32:17.560597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:32:17.905113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T14:32:21.051630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번위도경도
순번1.0000.4200.588
위도0.4201.0000.826
경도0.5880.8261.000
2023-12-12T14:32:21.124141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번위도경도
순번1.000-0.179-0.694
위도-0.1791.000-0.338
경도-0.694-0.3381.000

Missing values

2023-12-12T14:32:18.447678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:32:18.599075image/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전라남도 영광군 영광읍 물무로2길 57-24전라남도 영광군 영광읍 무령리 180-335.27822126.510942
12전라남도 영광군 영광읍 물무로2길 73-1전라남도 영광군 영광읍 무령리 223-1135.278731126.512092
23전라남도 영광군 영광읍 중앙로 215-25전라남도 영광군 영광읍 무령리 28235.279108126.512901
34전라남도 영광군 영광읍 중앙로 233전라남도 영광군 영광읍 무령리 280-735.279626126.51298
45전라남도 영광군 영광읍 중앙로 238-2전라남도 영광군 영광읍 무령리 256-635.280026126.513333
56전라남도 영광군 영광읍 중앙로 191-2전라남도 영광군 영광읍 백학리 10-235.276116126.511949
67전라남도 영광군 영광읍 중앙로 189-1전라남도 영광군 영광읍 백학리 12-235.276006126.511887
78전라남도 영광군 영광읍 중앙로 189전라남도 영광군 영광읍 백학리 1335.275962126.511859
89전라남도 영광군 영광읍 현암길 63전라남도 영광군 영광읍 백학리 18-235.275769126.511589
910전라남도 영광군 영광읍 현암길 55-6전라남도 영광군 영광읍 백학리 27-135.276096126.510842
순번도로명주소지번주소위도경도
10461047전라남도 영광군 법성면 연우로3길 9전라남도 영광군 법성면 법성리 94535.371109126.440781
10471048전라남도 영광군 법성면 연우로3길 3-2전라남도 영광군 법성면 법성리 94835.370912126.441043
10481049전라남도 영광군 법성면 굴비로2길 11-8전라남도 영광군 법성면 법성리 622-235.361741126.446839
10491050전라남도 영광군 법성면 굴비로2길 12-1전라남도 영광군 법성면 법성리 602-2935.361325126.446996
10501051전라남도 영광군 법성면 진굴비길 46전라남도 영광군 법성면 법성리 602-2135.360105126.447378
10511052전라남도 영광군 법성면 진굴비길 21전라남도 영광군 법성면 법성리 650-11935.35805126.447477
10521053전라남도 영광군 법성면 진굴비길 30-6전라남도 영광군 법성면 법성리 653-935.358603126.447899
10531054전라남도 영광군 법성면 진굴비길 34전라남도 영광군 법성면 법성리 652-235.35905126.447664
10541055전라남도 영광군 법성면 굴비로 37전라남도 영광군 법성면 법성리 650-335.359697126.446816
10551056전라남도 영광군 법성면 연우로1길 3전라남도 영광군 법성면 법성리 79535.364134126.443841