Overview

Dataset statistics

Number of variables5
Number of observations160
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.8 KiB
Average record size in memory43.8 B

Variable types

Numeric3
Text1
Categorical1

Dataset

Description2022.7.31.기준일자 안동시 스마트워터미터기(수도사용량 원격검침기) 설치 현황내역이며, 검침원이 직접 방문하지 않고 원격으로 수도 사용량을 확인 가능한 스마트워터미터기 주소 및 위치정보 자료입니다.
Author경상북도 안동시
URLhttps://www.data.go.kr/data/15103650/fileData.do

Alerts

데이터기준일 has constant value ""Constant
경도 is highly overall correlated with 위도High correlation
위도 is highly overall correlated with 경도High correlation
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 00:20:48.940741
Analysis finished2023-12-12 00:20:50.302840
Duration1.36 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct160
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean80.5
Minimum1
Maximum160
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-12T09:20:50.370150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile8.95
Q140.75
median80.5
Q3120.25
95-th percentile152.05
Maximum160
Range159
Interquartile range (IQR)79.5

Descriptive statistics

Standard deviation46.332134
Coefficient of variation (CV)0.57555446
Kurtosis-1.2
Mean80.5
Median Absolute Deviation (MAD)40
Skewness0
Sum12880
Variance2146.6667
MonotonicityStrictly increasing
2023-12-12T09:20:50.497533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
82 1
 
0.6%
104 1
 
0.6%
105 1
 
0.6%
106 1
 
0.6%
107 1
 
0.6%
108 1
 
0.6%
109 1
 
0.6%
110 1
 
0.6%
111 1
 
0.6%
Other values (150) 150
93.8%
ValueCountFrequency (%)
1 1
0.6%
2 1
0.6%
3 1
0.6%
4 1
0.6%
5 1
0.6%
6 1
0.6%
7 1
0.6%
8 1
0.6%
9 1
0.6%
10 1
0.6%
ValueCountFrequency (%)
160 1
0.6%
159 1
0.6%
158 1
0.6%
157 1
0.6%
156 1
0.6%
155 1
0.6%
154 1
0.6%
153 1
0.6%
152 1
0.6%
151 1
0.6%

주소
Text

Distinct158
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-12T09:20:50.783710image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length32
Mean length27.9875
Min length20

Characters and Unicode

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

Unique

Unique156 ?
Unique (%)97.5%

Sample

1st row경상북도 안동시 녹전면 서삼길 403(서삼리 107)
2nd row경상북도 안동시 녹전면 송두안길 22-3(사신리 259-2)
3rd row경상북도 안동시 녹전면 송두안길 22(사신리 257-5)
4th row경상북도 안동시 녹전면 송두안길 25(사신리 264-1)
5th row경상북도 안동시 녹전면 송두안길 27(사신리 264-6)
ValueCountFrequency (%)
경상북도 160
19.1%
안동시 160
19.1%
와룡면 40
 
4.8%
녹전면 40
 
4.8%
서동골길 19
 
2.3%
광석1길 16
 
1.9%
녹전로 16
 
1.9%
와룡탯골길 15
 
1.8%
대안로 9
 
1.1%
송두안길 9
 
1.1%
Other values (286) 353
42.2%
2023-12-12T09:20:51.231196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
677
 
15.1%
동 264
 
5.9%
1 198
 
4.4%
안 186
 
4.2%
경 164
 
3.7%
시 164
 
3.7%
- 162
 
3.6%
도 160
 
3.6%
북 160
 
3.6%
( 160
 
3.6%
Other values (59) 2183
48.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2370
52.9%
Decimal Number 945
 
21.1%
Space Separator 677
 
15.1%
Dash Punctuation 162
 
3.6%
Open Punctuation 160
 
3.6%
Close Punctuation 160
 
3.6%
Other Punctuation 4
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 264
 
11.1%
안 186
 
7.8%
경 164
 
6.9%
시 164
 
6.9%
도 160
 
6.8%
북 160
 
6.8%
상 160
 
6.8%
길 116
 
4.9%
면 80
 
3.4%
리 80
 
3.4%
Other values (44) 836
35.3%
Decimal Number
ValueCountFrequency (%)
1 198
21.0%
2 136
14.4%
3 112
11.9%
4 96
10.2%
7 89
9.4%
5 70
 
7.4%
6 64
 
6.8%
8 63
 
6.7%
9 63
 
6.7%
0 54
 
5.7%
Space Separator
ValueCountFrequency (%)
677
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 162
100.0%
Open Punctuation
ValueCountFrequency (%)
( 160
100.0%
Close Punctuation
ValueCountFrequency (%)
) 160
100.0%
Other Punctuation
ValueCountFrequency (%)
, 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2370
52.9%
Common 2108
47.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 264
 
11.1%
안 186
 
7.8%
경 164
 
6.9%
시 164
 
6.9%
도 160
 
6.8%
북 160
 
6.8%
상 160
 
6.8%
길 116
 
4.9%
면 80
 
3.4%
리 80
 
3.4%
Other values (44) 836
35.3%
Common
ValueCountFrequency (%)
677
32.1%
1 198
 
9.4%
- 162
 
7.7%
( 160
 
7.6%
) 160
 
7.6%
2 136
 
6.5%
3 112
 
5.3%
4 96
 
4.6%
7 89
 
4.2%
5 70
 
3.3%
Other values (5) 248
 
11.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2370
52.9%
ASCII 2108
47.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
677
32.1%
1 198
 
9.4%
- 162
 
7.7%
( 160
 
7.6%
) 160
 
7.6%
2 136
 
6.5%
3 112
 
5.3%
4 96
 
4.6%
7 89
 
4.2%
5 70
 
3.3%
Other values (5) 248
 
11.8%
Hangul
ValueCountFrequency (%)
동 264
 
11.1%
안 186
 
7.8%
경 164
 
6.9%
시 164
 
6.9%
도 160
 
6.8%
북 160
 
6.8%
상 160
 
6.8%
길 116
 
4.9%
면 80
 
3.4%
리 80
 
3.4%
Other values (44) 836
35.3%

경도
Real number (ℝ)

HIGH CORRELATION 

Distinct157
Distinct (%)98.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.74387
Minimum128.71965
Maximum128.78304
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-12T09:20:51.380181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum128.71965
5-th percentile128.72122
Q1128.72229
median128.7378
Q3128.76683
95-th percentile128.77544
Maximum128.78304
Range0.0633965
Interquartile range (IQR)0.04453665

Descriptive statistics

Standard deviation0.022553362
Coefficient of variation (CV)0.00017518008
Kurtosis-1.6749953
Mean128.74387
Median Absolute Deviation (MAD)0.0165507
Skewness0.23947797
Sum20599.019
Variance0.00050865412
MonotonicityNot monotonic
2023-12-12T09:20:51.539268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
128.7227908 2
 
1.2%
128.7214992 2
 
1.2%
128.7212068 2
 
1.2%
128.7214173 1
 
0.6%
128.7214955 1
 
0.6%
128.7215301 1
 
0.6%
128.7217416 1
 
0.6%
128.7228021 1
 
0.6%
128.7226391 1
 
0.6%
128.7214652 1
 
0.6%
Other values (147) 147
91.9%
ValueCountFrequency (%)
128.7196481 1
0.6%
128.7210054 1
0.6%
128.721014 1
0.6%
128.7210308 1
0.6%
128.7210711 1
0.6%
128.7211584 1
0.6%
128.7212068 2
1.2%
128.721217 1
0.6%
128.7212739 1
0.6%
128.7212833 1
0.6%
ValueCountFrequency (%)
128.7830446 1
0.6%
128.782521 1
0.6%
128.7822804 1
0.6%
128.7820681 1
0.6%
128.7818237 1
0.6%
128.7809234 1
0.6%
128.7793338 1
0.6%
128.7756832 1
0.6%
128.7754231 1
0.6%
128.7750019 1
0.6%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct157
Distinct (%)98.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36.614003
Minimum36.557649
Maximum36.744604
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-12T09:20:51.683069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum36.557649
5-th percentile36.560768
Q136.564991
median36.586952
Q336.65839
95-th percentile36.742968
Maximum36.744604
Range0.18695415
Interquartile range (IQR)0.093398108

Descriptive statistics

Standard deviation0.062430339
Coefficient of variation (CV)0.0017050946
Kurtosis-0.68326223
Mean36.614003
Median Absolute Deviation (MAD)0.02516853
Skewness0.90728668
Sum5858.2405
Variance0.0038975473
MonotonicityNot monotonic
2023-12-12T09:20:51.818522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
36.56642621 2
 
1.2%
36.56568604 2
 
1.2%
36.56548955 2
 
1.2%
36.56529902 1
 
0.6%
36.56529855 1
 
0.6%
36.56541549 1
 
0.6%
36.56532409 1
 
0.6%
36.56523654 1
 
0.6%
36.56572419 1
 
0.6%
36.56083773 1
 
0.6%
Other values (147) 147
91.9%
ValueCountFrequency (%)
36.55764943 1
0.6%
36.55969177 1
0.6%
36.56000574 1
0.6%
36.56012167 1
0.6%
36.5601737 1
0.6%
36.56044513 1
0.6%
36.56052447 1
0.6%
36.56061136 1
0.6%
36.56077634 1
0.6%
36.56082615 1
0.6%
ValueCountFrequency (%)
36.74460358 1
0.6%
36.74344453 1
0.6%
36.74332629 1
0.6%
36.74323515 1
0.6%
36.74312432 1
0.6%
36.74308623 1
0.6%
36.74300725 1
0.6%
36.74299451 1
0.6%
36.74296682 1
0.6%
36.74280396 1
0.6%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2022-07-31
160 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-07-31
2nd row2022-07-31
3rd row2022-07-31
4th row2022-07-31
5th row2022-07-31

Common Values

ValueCountFrequency (%)
2022-07-31 160
100.0%

Length

2023-12-12T09:20:51.939690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:20:52.024416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-07-31 160
100.0%

Interactions

2023-12-12T09:20:49.622677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:20:49.087780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:20:49.360224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:20:49.716641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:20:49.176133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:20:49.455949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:20:49.814667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:20:49.268343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:20:49.532305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T09:20:52.076948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번경도위도
순번1.0000.7420.735
경도0.7421.0000.970
위도0.7350.9701.000
2023-12-12T09:20:52.153227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번경도위도
순번1.000-0.196-0.156
경도-0.1961.0000.837
위도-0.1560.8371.000

Missing values

2023-12-12T09:20:50.177635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:20:50.261651image/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경상북도 안동시 녹전면 서삼길 403(서삼리 107)128.76622936.6893662022-07-31
12경상북도 안동시 녹전면 송두안길 22-3(사신리 259-2)128.77126936.6965792022-07-31
23경상북도 안동시 녹전면 송두안길 22(사신리 257-5)128.7715336.6969562022-07-31
34경상북도 안동시 녹전면 송두안길 25(사신리 264-1)128.77161736.6966852022-07-31
45경상북도 안동시 녹전면 송두안길 27(사신리 264-6)128.77181636.6964232022-07-31
56경상북도 안동시 녹전면 송두안길 34(사신리 262)128.77182236.6959542022-07-31
67경상북도 안동시 녹전면 송두안길 17-6(사신리 266-4)128.7722936.6968792022-07-31
78경상북도 안동시 녹전면 송내길 57(사신리 188)128.77568336.6981822022-07-31
89경상북도 안동시 녹전면 송두안길 21(사신리 265-1)128.77174236.6968742022-07-31
910경상북도 안동시 녹전면 송두안길 21-4(사신리 265)128.77170736.6967752022-07-31
순번주소경도위도데이터기준일
150151경상북도 안동시 영호4길 45(옥야동)128.72222336.5630052022-07-31
151152경상북도 안동시 경동로 592(옥야동)128.72243636.5631212022-07-31
152153경상북도 안동시 영호5길 6(옥야동)128.72275936.5629752022-07-31
153154경상북도 안동시 영호5길 8(옥야동)128.72274636.5628582022-07-31
154155경상북도 안동시 중앙시장2길 18(옥야동 300-9)128.7227936.5638852022-07-31
155156경상북도 안동시 경동로 591-1(옥야동)128.72255236.5635982022-07-31
156157경상북도 안동시 중앙시장2길 8(옥야동)128.72227636.5639242022-07-31
157158경상북도 안동시 제비원로 132(옥야동)128.72101436.5639772022-07-31
158159경상북도 안동시 제비원로 134-1(옥야동 91-12)128.72100536.5642562022-07-31
159160경상북도 안동시 중앙시장2길 46, 8호(옥야동)128.72349336.5638622022-07-31