Overview

Dataset statistics

Number of variables6
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.1 KiB
Average record size in memory52.3 B

Variable types

Numeric3
Categorical1
Text1
DateTime1

Dataset

Description경상북도 봉화군 스마트워터 미터기 위치데이터 제공 신청에 따라 스마트워터미터기 위치에 대한 데이터를 제공합니다.
URLhttps://www.data.go.kr/data/15102934/fileData.do

Alerts

구분 has constant value ""Constant
데이터기준일 has constant value ""Constant
순번 has unique valuesUnique
설치위치 has unique valuesUnique

Reproduction

Analysis started2023-12-12 10:06:47.300816
Analysis finished2023-12-12 10:06:48.889352
Duration1.59 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean50.5
Minimum1
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-12T19:06:49.007163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5.95
Q125.75
median50.5
Q375.25
95-th percentile95.05
Maximum100
Range99
Interquartile range (IQR)49.5

Descriptive statistics

Standard deviation29.011492
Coefficient of variation (CV)0.57448499
Kurtosis-1.2
Mean50.5
Median Absolute Deviation (MAD)25
Skewness0
Sum5050
Variance841.66667
MonotonicityStrictly increasing
2023-12-12T19:06:49.189871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.0%
65 1
 
1.0%
75 1
 
1.0%
74 1
 
1.0%
73 1
 
1.0%
72 1
 
1.0%
71 1
 
1.0%
70 1
 
1.0%
69 1
 
1.0%
68 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
1 1
1.0%
2 1
1.0%
3 1
1.0%
4 1
1.0%
5 1
1.0%
6 1
1.0%
7 1
1.0%
8 1
1.0%
9 1
1.0%
10 1
1.0%
ValueCountFrequency (%)
100 1
1.0%
99 1
1.0%
98 1
1.0%
97 1
1.0%
96 1
1.0%
95 1
1.0%
94 1
1.0%
93 1
1.0%
92 1
1.0%
91 1
1.0%

구분
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
원격검침
100 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row원격검침
2nd row원격검침
3rd row원격검침
4th row원격검침
5th row원격검침

Common Values

ValueCountFrequency (%)
원격검침 100
100.0%

Length

2023-12-12T19:06:49.357539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:06:49.490192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
원격검침 100
100.0%

설치위치
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-12T19:06:49.855238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length38
Median length29
Mean length22.18
Min length9

Characters and Unicode

Total characters2218
Distinct characters167
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

Unique100 ?
Unique (%)100.0%

Sample

1st row경상북도 물야면 귀이골길 86
2nd row경북 봉화군 물야면 말문이길 31-2
3rd row경북 봉화군 법전면 경체정길 10
4th row경북 봉화군 법전면 경체정길 18
5th row경북 봉화군 법전면 경체정길 20
ValueCountFrequency (%)
봉화군 74
 
15.8%
봉화읍 44
 
9.4%
경상남도 43
 
9.2%
경상북도 38
 
8.1%
물야면 22
 
4.7%
법전면 13
 
2.8%
구미길 9
 
1.9%
경북 7
 
1.5%
경체정길 7
 
1.5%
양계단지길 7
 
1.5%
Other values (158) 204
43.6%
2023-12-12T19:06:50.610239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
370
 
16.7%
봉 135
 
6.1%
화 130
 
5.9%
경 95
 
4.3%
1 89
 
4.0%
도 82
 
3.7%
상 81
 
3.7%
길 80
 
3.6%
군 74
 
3.3%
면 57
 
2.6%
Other values (157) 1025
46.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1385
62.4%
Space Separator 370
 
16.7%
Decimal Number 340
 
15.3%
Dash Punctuation 45
 
2.0%
Open Punctuation 38
 
1.7%
Close Punctuation 38
 
1.7%
Uppercase Letter 1
 
< 0.1%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
봉 135
 
9.7%
화 130
 
9.4%
경 95
 
6.9%
도 82
 
5.9%
상 81
 
5.8%
길 80
 
5.8%
군 74
 
5.3%
면 57
 
4.1%
북 45
 
3.2%
읍 44
 
3.2%
Other values (141) 562
40.6%
Decimal Number
ValueCountFrequency (%)
1 89
26.2%
2 49
14.4%
3 35
 
10.3%
4 31
 
9.1%
5 29
 
8.5%
7 29
 
8.5%
8 25
 
7.4%
0 23
 
6.8%
9 15
 
4.4%
6 15
 
4.4%
Space Separator
ValueCountFrequency (%)
370
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 45
100.0%
Open Punctuation
ValueCountFrequency (%)
( 38
100.0%
Close Punctuation
ValueCountFrequency (%)
) 38
100.0%
Uppercase Letter
ValueCountFrequency (%)
D 1
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1385
62.4%
Common 832
37.5%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
봉 135
 
9.7%
화 130
 
9.4%
경 95
 
6.9%
도 82
 
5.9%
상 81
 
5.8%
길 80
 
5.8%
군 74
 
5.3%
면 57
 
4.1%
북 45
 
3.2%
읍 44
 
3.2%
Other values (141) 562
40.6%
Common
ValueCountFrequency (%)
370
44.5%
1 89
 
10.7%
2 49
 
5.9%
- 45
 
5.4%
( 38
 
4.6%
) 38
 
4.6%
3 35
 
4.2%
4 31
 
3.7%
5 29
 
3.5%
7 29
 
3.5%
Other values (5) 79
 
9.5%
Latin
ValueCountFrequency (%)
D 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1385
62.4%
ASCII 833
37.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
370
44.4%
1 89
 
10.7%
2 49
 
5.9%
- 45
 
5.4%
( 38
 
4.6%
) 38
 
4.6%
3 35
 
4.2%
4 31
 
3.7%
5 29
 
3.5%
7 29
 
3.5%
Other values (6) 80
 
9.6%
Hangul
ValueCountFrequency (%)
봉 135
 
9.7%
화 130
 
9.4%
경 95
 
6.9%
도 82
 
5.9%
상 81
 
5.8%
길 80
 
5.8%
군 74
 
5.3%
면 57
 
4.1%
북 45
 
3.2%
읍 44
 
3.2%
Other values (141) 562
40.6%

위도
Real number (ℝ)

Distinct98
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36.943161
Minimum36.781543
Maximum39.960892
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-12T19:06:50.808633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum36.781543
5-th percentile36.813441
Q136.882269
median36.908083
Q336.954524
95-th percentile37.005599
Maximum39.960892
Range3.179349
Interquartile range (IQR)0.072255

Descriptive statistics

Standard deviation0.30911599
Coefficient of variation (CV)0.00836734
Kurtosis94.393259
Mean36.943161
Median Absolute Deviation (MAD)0.0273515
Skewness9.5820739
Sum3694.3161
Variance0.095552697
MonotonicityNot monotonic
2023-12-12T19:06:50.969192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
36.958295 2
 
2.0%
36.881899 2
 
2.0%
36.975406 1
 
1.0%
36.890909 1
 
1.0%
36.932221 1
 
1.0%
36.919949 1
 
1.0%
36.910994 1
 
1.0%
36.909758 1
 
1.0%
36.924499 1
 
1.0%
36.911013 1
 
1.0%
Other values (88) 88
88.0%
ValueCountFrequency (%)
36.781543 1
1.0%
36.796418 1
1.0%
36.801382 1
1.0%
36.805706 1
1.0%
36.807592 1
1.0%
36.813749 1
1.0%
36.835562 1
1.0%
36.865985 1
1.0%
36.86624 1
1.0%
36.876021 1
1.0%
ValueCountFrequency (%)
39.960892 1
1.0%
37.054457 1
1.0%
37.047594 1
1.0%
37.047217 1
1.0%
37.045257 1
1.0%
37.003512 1
1.0%
36.988047 1
1.0%
36.977257 1
1.0%
36.977249 1
1.0%
36.975887 1
1.0%

경도
Real number (ℝ)

Distinct99
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.7833
Minimum128.66283
Maximum129.06602
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-12T19:06:51.187567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum128.66283
5-th percentile128.66458
Q1128.70392
median128.73697
Q3128.87566
95-th percentile129.01685
Maximum129.06602
Range0.403183
Interquartile range (IQR)0.17174475

Descriptive statistics

Standard deviation0.11726394
Coefficient of variation (CV)0.00091055237
Kurtosis-0.21585186
Mean128.7833
Median Absolute Deviation (MAD)0.065562
Skewness1.0003708
Sum12878.33
Variance0.013750832
MonotonicityNot monotonic
2023-12-12T19:06:51.392148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
128.666442 2
 
2.0%
128.709137 1
 
1.0%
128.700969 1
 
1.0%
128.742035 1
 
1.0%
128.805215 1
 
1.0%
128.793317 1
 
1.0%
128.877564 1
 
1.0%
128.877712 1
 
1.0%
128.889584 1
 
1.0%
128.875415 1
 
1.0%
Other values (89) 89
89.0%
ValueCountFrequency (%)
128.662834 1
1.0%
128.66342 1
1.0%
128.66354 1
1.0%
128.663847 1
1.0%
128.663894 1
1.0%
128.664612 1
1.0%
128.665315 1
1.0%
128.665429 1
1.0%
128.665795 1
1.0%
128.666418 1
1.0%
ValueCountFrequency (%)
129.066017 1
1.0%
129.063916 1
1.0%
129.063868 1
1.0%
129.060515 1
1.0%
129.02021 1
1.0%
129.016675 1
1.0%
129.005192 1
1.0%
129.005189 1
1.0%
129.003168 1
1.0%
128.990879 1
1.0%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2023-07-24 00:00:00
Maximum2023-07-24 00:00:00
2023-12-12T19:06:51.564043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:06:51.690991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T19:06:48.255586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:06:47.559745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:06:47.910277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:06:48.381127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:06:47.672990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:06:48.012533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:06:48.511410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:06:47.792432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:06:48.109352image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T19:06:51.789912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번설치위치위도경도
순번1.0001.0000.0410.806
설치위치1.0001.0001.0001.000
위도0.0411.0001.0000.000
경도0.8061.0000.0001.000
2023-12-12T19:06:51.914159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번위도경도
순번1.0000.2250.351
위도0.2251.0000.136
경도0.3510.1361.000

Missing values

2023-12-12T19:06:48.711965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:06:48.838316image/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원격검침경상북도 물야면 귀이골길 8636.970336128.7091372023-07-24
12원격검침경북 봉화군 물야면 말문이길 31-239.960892128.6943292023-07-24
23원격검침경북 봉화군 법전면 경체정길 1036.909941128.8756562023-07-24
34원격검침경북 봉화군 법전면 경체정길 1836.909108128.8756412023-07-24
45원격검침경북 봉화군 법전면 경체정길 2036.908818128.8756462023-07-24
56원격검침경북 봉화군 법전면 경체정길 22-136.908654128.8756842023-07-24
67원격검침경북 봉화군 법전면 경체정길 24-636.908414128.8757042023-07-24
78원격검침경북 봉화군 법전면 경체정길 24-836.908261128.8752632023-07-24
89원격검침경상남도 봉화군 물야면 말문이길 3236.96111128.694622023-07-24
910원격검침경상남도 봉화군 물야면 조양1길 25-236.975887128.700692023-07-24
순번구분설치위치위도경도데이터기준일
9091원격검침물야면 문수로 988-136.975263128.736512023-07-24
9192원격검침봉화읍 교촌길 41(D동주계량기)(102호)36.899594128.732482023-07-24
9293원격검침봉화읍 내성로3길 7(세현목욕탕)36.888212128.7400092023-07-24
9394원격검침봉화읍 문수로 836.897615128.7374342023-07-24
9495원격검침봉화읍 봉화로 1121(3층가정)36.891483128.7326952023-07-24
9596원격검침봉화읍 신시장길 (2시장 공용화장실)36.977257128.7349112023-07-24
9697원격검침소천면 임기로 827-2436.932936129.0051892023-07-24
9798원격검침춘양면 운곡길 108-336.941486128.9255032023-07-24
9899원격검침춘양면 의양리 198-1(의양리 201-5 의양리 198-1)36.941035128.9179612023-07-24
99100원격검침춘양면 학산길 35-3936.939255128.909912023-07-24