Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory556.6 KiB
Average record size in memory57.0 B

Variable types

Numeric1
Text1
Categorical3
DateTime1

Dataset

Description강원도 동해시에 설치된 스마트 워터 미터 위치 정보(도로명주소, 검침방식, 관할기관명, 관할기관전화번호)를 제공하여드립니다.
Author강원도 동해시
URLhttps://www.data.go.kr/data/15103864/fileData.do

Alerts

검침방식 has constant value ""Constant
관할기관명 has constant value ""Constant
관할기관전화번호 has constant value ""Constant
데이터기준일자 has constant value ""Constant
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 05:58:01.115988
Analysis finished2023-12-12 05:58:02.288010
Duration1.17 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5047.5946
Minimum1
Maximum10088
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T14:58:02.403178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile505.95
Q12529.75
median5051.5
Q37569.25
95-th percentile9582.05
Maximum10088
Range10087
Interquartile range (IQR)5039.5

Descriptive statistics

Standard deviation2910.8472
Coefficient of variation (CV)0.57668007
Kurtosis-1.1999089
Mean5047.5946
Median Absolute Deviation (MAD)2520
Skewness-0.0026469507
Sum50475946
Variance8473031.5
MonotonicityNot monotonic
2023-12-12T14:58:02.579772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
5700 1
 
< 0.1%
6895 1
 
< 0.1%
2871 1
 
< 0.1%
1745 1
 
< 0.1%
2683 1
 
< 0.1%
6601 1
 
< 0.1%
3576 1
 
< 0.1%
9645 1
 
< 0.1%
1936 1
 
< 0.1%
8290 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
11 1
< 0.1%
ValueCountFrequency (%)
10088 1
< 0.1%
10087 1
< 0.1%
10086 1
< 0.1%
10085 1
< 0.1%
10084 1
< 0.1%
10083 1
< 0.1%
10082 1
< 0.1%
10081 1
< 0.1%
10080 1
< 0.1%
10079 1
< 0.1%

도로명주소
Text

Distinct9777
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T14:58:02.865203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length35
Mean length22.7529
Min length12

Characters and Unicode

Total characters227529
Distinct characters810
Distinct categories12 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique9608 ?
Unique (%)96.1%

Sample

1st row강원도 동해시 발한동 시장안길6-1(각시방3층)
2nd row강원도 동해시 천곡동 감추로10
3rd row강원도 동해시 평릉동 평릉길30-4(좌1,1층 오븐마루)
4th row강원도 동해시 샘실3길25(천곡동 좌1 2층)
5th row강원도 동해시 한섬로61-9(천곡동 우2 지하보리밥)
ValueCountFrequency (%)
강원도 10000
27.3%
동해시 10000
27.3%
천곡동 887
 
2.4%
발한동 671
 
1.8%
망상동 557
 
1.5%
동호동 339
 
0.9%
좌2 177
 
0.5%
구호동 173
 
0.5%
부곡동 168
 
0.5%
좌1 161
 
0.4%
Other values (10489) 13494
36.8%
2023-12-12T14:58:03.292233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
26717
 
11.7%
동 21417
 
9.4%
해 10725
 
4.7%
원 10686
 
4.7%
시 10497
 
4.6%
도 10129
 
4.5%
강 10065
 
4.4%
1 9212
 
4.0%
( 7578
 
3.3%
) 7563
 
3.3%
Other values (800) 102940
45.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 141363
62.1%
Decimal Number 35843
 
15.8%
Space Separator 26717
 
11.7%
Open Punctuation 7579
 
3.3%
Close Punctuation 7564
 
3.3%
Dash Punctuation 4766
 
2.1%
Other Punctuation 3241
 
1.4%
Uppercase Letter 415
 
0.2%
Lowercase Letter 38
 
< 0.1%
Math Symbol 1
 
< 0.1%
Other values (2) 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 21417
15.2%
해 10725
 
7.6%
원 10686
 
7.6%
시 10497
 
7.4%
도 10129
 
7.2%
강 10065
 
7.1%
길 6121
 
4.3%
로 4283
 
3.0%
호 3253
 
2.3%
곡 2885
 
2.0%
Other values (731) 51302
36.3%
Uppercase Letter
ValueCountFrequency (%)
A 99
23.9%
B 87
21.0%
C 56
13.5%
E 26
 
6.3%
S 20
 
4.8%
G 18
 
4.3%
D 15
 
3.6%
L 11
 
2.7%
P 10
 
2.4%
T 9
 
2.2%
Other values (15) 64
15.4%
Lowercase Letter
ValueCountFrequency (%)
m 5
13.2%
u 4
10.5%
c 3
 
7.9%
a 3
 
7.9%
p 3
 
7.9%
n 3
 
7.9%
o 3
 
7.9%
y 2
 
5.3%
v 2
 
5.3%
k 2
 
5.3%
Other values (6) 8
21.1%
Decimal Number
ValueCountFrequency (%)
1 9212
25.7%
2 6490
18.1%
3 4559
12.7%
4 2951
 
8.2%
5 2638
 
7.4%
6 2538
 
7.1%
0 2335
 
6.5%
7 1897
 
5.3%
8 1731
 
4.8%
9 1492
 
4.2%
Other Punctuation
ValueCountFrequency (%)
, 3197
98.6%
@ 20
 
0.6%
/ 11
 
0.3%
& 8
 
0.2%
？ 1
 
< 0.1%
? 1
 
< 0.1%
＆ 1
 
< 0.1%
# 1
 
< 0.1%
: 1
 
< 0.1%
Open Punctuation
ValueCountFrequency (%)
( 7578
> 99.9%
[ 1
 
< 0.1%
Close Punctuation
ValueCountFrequency (%)
) 7563
> 99.9%
] 1
 
< 0.1%
Space Separator
ValueCountFrequency (%)
26717
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4766
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 141362
62.1%
Common 85712
37.7%
Latin 453
 
0.2%
Han 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 21417
15.2%
해 10725
 
7.6%
원 10686
 
7.6%
시 10497
 
7.4%
도 10129
 
7.2%
강 10065
 
7.1%
길 6121
 
4.3%
로 4283
 
3.0%
호 3253
 
2.3%
곡 2885
 
2.0%
Other values (730) 51301
36.3%
Latin
ValueCountFrequency (%)
A 99
21.9%
B 87
19.2%
C 56
12.4%
E 26
 
5.7%
S 20
 
4.4%
G 18
 
4.0%
D 15
 
3.3%
L 11
 
2.4%
P 10
 
2.2%
T 9
 
2.0%
Other values (31) 102
22.5%
Common
ValueCountFrequency (%)
26717
31.2%
1 9212
 
10.7%
( 7578
 
8.8%
) 7563
 
8.8%
2 6490
 
7.6%
- 4766
 
5.6%
3 4559
 
5.3%
, 3197
 
3.7%
4 2951
 
3.4%
5 2638
 
3.1%
Other values (17) 10041
 
11.7%
Han
ValueCountFrequency (%)
情 1
50.0%
氏 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 141361
62.1%
ASCII 86163
37.9%
None 3
 
< 0.1%
CJK 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
26717
31.0%
1 9212
 
10.7%
( 7578
 
8.8%
) 7563
 
8.8%
2 6490
 
7.5%
- 4766
 
5.5%
3 4559
 
5.3%
, 3197
 
3.7%
4 2951
 
3.4%
5 2638
 
3.1%
Other values (56) 10492
 
12.2%
Hangul
ValueCountFrequency (%)
동 21417
15.2%
해 10725
 
7.6%
원 10686
 
7.6%
시 10497
 
7.4%
도 10129
 
7.2%
강 10065
 
7.1%
길 6121
 
4.3%
로 4283
 
3.0%
호 3253
 
2.3%
곡 2885
 
2.0%
Other values (729) 51300
36.3%
None
ValueCountFrequency (%)
？ 1
33.3%
＆ 1
33.3%
㈜ 1
33.3%
CJK
ValueCountFrequency (%)
情 1
50.0%
氏 1
50.0%

검침방식
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
원격검침
10000 

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 (%)
원격검침 10000
100.0%

Length

2023-12-12T14:58:03.435176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:58:03.529567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
원격검침 10000
100.0%

관할기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
동해시 상하수도사업소
10000 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row동해시 상하수도사업소
2nd row동해시 상하수도사업소
3rd row동해시 상하수도사업소
4th row동해시 상하수도사업소
5th row동해시 상하수도사업소

Common Values

ValueCountFrequency (%)
동해시 상하수도사업소 10000
100.0%

Length

2023-12-12T14:58:03.630353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:58:03.779099image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동해시 10000
50.0%
상하수도사업소 10000
50.0%

관할기관전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
033-539-2452
10000 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row033-539-2452
2nd row033-539-2452
3rd row033-539-2452
4th row033-539-2452
5th row033-539-2452

Common Values

ValueCountFrequency (%)
033-539-2452 10000
100.0%

Length

2023-12-12T14:58:03.948195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:58:04.089683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
033-539-2452 10000
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-08-10 00:00:00
Maximum2022-08-10 00:00:00
2023-12-12T14:58:04.202311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:58:04.315435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T14:58:01.991162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T14:58:02.106226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:58:02.222291image/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

연번도로명주소검침방식관할기관명관할기관전화번호데이터기준일자
56995700강원도 동해시 발한동 시장안길6-1(각시방3층)원격검침동해시 상하수도사업소033-539-24522022-08-10
24662467강원도 동해시 천곡동 감추로10원격검침동해시 상하수도사업소033-539-24522022-08-10
278279강원도 동해시 평릉동 평릉길30-4(좌1,1층 오븐마루)원격검침동해시 상하수도사업소033-539-24522022-08-10
243244강원도 동해시 샘실3길25(천곡동 좌1 2층)원격검침동해시 상하수도사업소033-539-24522022-08-10
196197강원도 동해시 한섬로61-9(천곡동 우2 지하보리밥)원격검침동해시 상하수도사업소033-539-24522022-08-10
85708571강원도 동해시 공단3로35원격검침동해시 상하수도사업소033-539-24522022-08-10
85248525강원도 동해시 공단6로17(구호동, 대아)원격검침동해시 상하수도사업소033-539-24522022-08-10
24712472강원도 동해시 천곡동 감추로12(좌2)원격검침동해시 상하수도사업소033-539-24522022-08-10
27422743강원도 동해시 감추4길8(천곡동, 2층원룸)원격검침동해시 상하수도사업소033-539-24522022-08-10
1008110082강원도 동해시 삼화로37(삼화동)원격검침동해시 상하수도사업소033-539-24522022-08-10
연번도로명주소검침방식관할기관명관할기관전화번호데이터기준일자
88328833강원도 동해시 대진동15-2원격검침동해시 상하수도사업소033-539-24522022-08-10
21762177강원도 동해시 천곡동 동굴로126(동해세차장)원격검침동해시 상하수도사업소033-539-24522022-08-10
819820강원도 동해시 평원4길2-1(평릉동 1층상가)원격검침동해시 상하수도사업소033-539-24522022-08-10
10651066강원도 동해시 항골1길10-5(천곡동)원격검침동해시 상하수도사업소033-539-24522022-08-10
89808981강원도 동해시 망상동 동해대로6271(경일마트)원격검침동해시 상하수도사업소033-539-24522022-08-10
24822483강원도 동해시 감추로18(천곡동)원격검침동해시 상하수도사업소033-539-24522022-08-10
19421943강원도 동해시 천곡동 충혼길5 (산야초백숙,우측)원격검침동해시 상하수도사업소033-539-24522022-08-10
36843685강원도 동해시 효가동 동해대로5023(지하,숲속노래궁)원격검침동해시 상하수도사업소033-539-24522022-08-10
53725373강원도 동해시 향로복개로103-1(발한동)원격검침동해시 상하수도사업소033-539-24522022-08-10
90899090강원도 동해시 망상동 터일길168-10원격검침동해시 상하수도사업소033-539-24522022-08-10