Overview

Dataset statistics

Number of variables3
Number of observations2147
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory52.5 KiB
Average record size in memory25.1 B

Variable types

Numeric1
Text1
Categorical1

Dataset

Description경상남도 사천시의 스마트워터 미터기(원격검침기)가 설치되어 있는 수도관로 수용가의 좌표(주소)데이터입니다.
Author경상남도 사천시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15104030

Alerts

데이터기준일 has constant value ""Constant
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-10 23:47:26.195725
Analysis finished2023-12-10 23:47:26.538158
Duration0.34 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct2147
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1074
Minimum1
Maximum2147
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size19.0 KiB
2023-12-11T08:47:26.596041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile108.3
Q1537.5
median1074
Q31610.5
95-th percentile2039.7
Maximum2147
Range2146
Interquartile range (IQR)1073

Descriptive statistics

Standard deviation619.92983
Coefficient of variation (CV)0.57721586
Kurtosis-1.2
Mean1074
Median Absolute Deviation (MAD)537
Skewness0
Sum2305878
Variance384313
MonotonicityStrictly increasing
2023-12-11T08:47:26.697353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
1428 1
 
< 0.1%
1442 1
 
< 0.1%
1441 1
 
< 0.1%
1440 1
 
< 0.1%
1439 1
 
< 0.1%
1438 1
 
< 0.1%
1437 1
 
< 0.1%
1436 1
 
< 0.1%
1435 1
 
< 0.1%
Other values (2137) 2137
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 (%)
2147 1
< 0.1%
2146 1
< 0.1%
2145 1
< 0.1%
2144 1
< 0.1%
2143 1
< 0.1%
2142 1
< 0.1%
2141 1
< 0.1%
2140 1
< 0.1%
2139 1
< 0.1%
2138 1
< 0.1%

스마트워터미터기 설치주소
Text

Distinct2104
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Memory size16.9 KiB
2023-12-11T08:47:26.976446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length36
Mean length23.676758
Min length13

Characters and Unicode

Total characters50834
Distinct characters285
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

Unique2061 ?
Unique (%)96.0%

Sample

1st row경상남도 사천시 축동면 예동2길 42
2nd row경상남도 사천시 사천읍 선평길 50 (신진맨션)
3rd row경상남도 사천시 신수동길 26 (신수동)
4th row경상남도 사천시 사천읍 서재농청길 98 (신진아파트)
5th row경상남도 사천시 사천읍 서재농청길 98 (신진아파트)
ValueCountFrequency (%)
경상남도 2144
19.9%
사천시 2143
19.9%
송포동 420
 
3.9%
사천읍 202
 
1.9%
신수동 187
 
1.7%
신수서길 109
 
1.0%
동금동 108
 
1.0%
해안관광로 106
 
1.0%
실안동 101
 
0.9%
사남면 99
 
0.9%
Other values (1795) 5147
47.8%
2023-12-11T08:47:27.465591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
10533
20.7%
사 2545
 
5.0%
천 2491
 
4.9%
도 2395
 
4.7%
남 2375
 
4.7%
상 2173
 
4.3%
경 2162
 
4.3%
시 2161
 
4.3%
동 1934
 
3.8%
길 1679
 
3.3%
Other values (275) 20386
40.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 29725
58.5%
Space Separator 10533
 
20.7%
Decimal Number 6688
 
13.2%
Open Punctuation 1419
 
2.8%
Close Punctuation 1418
 
2.8%
Dash Punctuation 965
 
1.9%
Other Punctuation 86
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 2545
 
8.6%
천 2491
 
8.4%
도 2395
 
8.1%
남 2375
 
8.0%
상 2173
 
7.3%
경 2162
 
7.3%
시 2161
 
7.3%
동 1934
 
6.5%
길 1679
 
5.6%
포 728
 
2.4%
Other values (260) 9082
30.6%
Decimal Number
ValueCountFrequency (%)
1 1514
22.6%
2 1041
15.6%
3 832
12.4%
4 636
9.5%
5 552
 
8.3%
7 483
 
7.2%
8 457
 
6.8%
6 436
 
6.5%
0 392
 
5.9%
9 345
 
5.2%
Space Separator
ValueCountFrequency (%)
10533
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1419
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1418
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 965
100.0%
Other Punctuation
ValueCountFrequency (%)
, 86
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 29725
58.5%
Common 21109
41.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 2545
 
8.6%
천 2491
 
8.4%
도 2395
 
8.1%
남 2375
 
8.0%
상 2173
 
7.3%
경 2162
 
7.3%
시 2161
 
7.3%
동 1934
 
6.5%
길 1679
 
5.6%
포 728
 
2.4%
Other values (260) 9082
30.6%
Common
ValueCountFrequency (%)
10533
49.9%
1 1514
 
7.2%
( 1419
 
6.7%
) 1418
 
6.7%
2 1041
 
4.9%
- 965
 
4.6%
3 832
 
3.9%
4 636
 
3.0%
5 552
 
2.6%
7 483
 
2.3%
Other values (5) 1716
 
8.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 29725
58.5%
ASCII 21109
41.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
10533
49.9%
1 1514
 
7.2%
( 1419
 
6.7%
) 1418
 
6.7%
2 1041
 
4.9%
- 965
 
4.6%
3 832
 
3.9%
4 636
 
3.0%
5 552
 
2.6%
7 483
 
2.3%
Other values (5) 1716
 
8.1%
Hangul
ValueCountFrequency (%)
사 2545
 
8.6%
천 2491
 
8.4%
도 2395
 
8.1%
남 2375
 
8.0%
상 2173
 
7.3%
경 2162
 
7.3%
시 2161
 
7.3%
동 1934
 
6.5%
길 1679
 
5.6%
포 728
 
2.4%
Other values (260) 9082
30.6%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.9 KiB
2022-08-16
2147 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-08-16
2nd row2022-08-16
3rd row2022-08-16
4th row2022-08-16
5th row2022-08-16

Common Values

ValueCountFrequency (%)
2022-08-16 2147
100.0%

Length

2023-12-11T08:47:27.577437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:47:27.657725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-08-16 2147
100.0%

Interactions

2023-12-11T08:47:26.352475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-11T08:47:26.448784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T08:47:26.512085image/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길 422022-08-16
12경상남도 사천시 사천읍 선평길 50 (신진맨션)2022-08-16
23경상남도 사천시 신수동길 26 (신수동)2022-08-16
34경상남도 사천시 사천읍 서재농청길 98 (신진아파트)2022-08-16
45경상남도 사천시 사천읍 서재농청길 98 (신진아파트)2022-08-16
56경상남도 사천시 사천읍 선인길 17 (전원맨션)2022-08-16
67경상남도 사천시 신수서길 47-7 (신수동)2022-08-16
78경상남도 사천시 신수서길 47-4 (신수동)2022-08-16
89경상남도 사천시 신수서길 51 (신수동)2022-08-16
910경상남도 사천시 삼천포대교로 325-33 (대방동)2022-08-16
순번스마트워터미터기 설치주소데이터기준일
21372138경상남도 사천시 마도길 41-38 (마도동)2022-08-16
21382139경상남도 사천시 정동면 대곡1길 302022-08-16
21392140경상남도 사천시 숲뫼길 86-5 (향촌동)2022-08-16
21402141경상남도 사천시 정동면 복상2길 642022-08-16
21412142경상남도 사천시 임내길 31 (죽림동, 라온빌)2022-08-16
21422143경상남도 사천시 사천읍 동문2길 1002022-08-16
21432144경상남도 사천시 사천읍 정의길 73-192022-08-16
21442145경상남도 사천시 사천읍 동문4길 1112022-08-16
21452146경상남도 사천시 구미1길 (송포동 산186-16)2022-08-16
21462147경상남도 사천시 삼천포대교로 911 (송포동)2022-08-16