Overview

Dataset statistics

Number of variables3
Number of observations2106
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory51.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
스마트워터미터기 설치주소 has unique valuesUnique

Reproduction

Analysis started2023-12-10 23:47:23.045593
Analysis finished2023-12-10 23:47:23.375362
Duration0.33 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct2106
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1053.5
Minimum1
Maximum2106
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size18.6 KiB
2023-12-11T08:47:23.439018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile106.25
Q1527.25
median1053.5
Q31579.75
95-th percentile2000.75
Maximum2106
Range2105
Interquartile range (IQR)1052.5

Descriptive statistics

Standard deviation608.09415
Coefficient of variation (CV)0.57721325
Kurtosis-1.2
Mean1053.5
Median Absolute Deviation (MAD)526.5
Skewness0
Sum2218671
Variance369778.5
MonotonicityStrictly increasing
2023-12-11T08:47:23.560683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
1416 1
 
< 0.1%
1414 1
 
< 0.1%
1413 1
 
< 0.1%
1412 1
 
< 0.1%
1411 1
 
< 0.1%
1410 1
 
< 0.1%
1409 1
 
< 0.1%
1408 1
 
< 0.1%
1407 1
 
< 0.1%
Other values (2096) 2096
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 (%)
2106 1
< 0.1%
2105 1
< 0.1%
2104 1
< 0.1%
2103 1
< 0.1%
2102 1
< 0.1%
2101 1
< 0.1%
2100 1
< 0.1%
2099 1
< 0.1%
2098 1
< 0.1%
2097 1
< 0.1%

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

UNIQUE 

Distinct2106
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.6 KiB
2023-12-11T08:47:23.886701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length36
Mean length23.65622
Min length13

Characters and Unicode

Total characters49820
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

Unique2106 ?
Unique (%)100.0%

Sample

1st row경상남도 사천시 축동면 예동2길 42
2nd row경상남도 사천시 사천읍 선평길 50 (신진맨션)
3rd row경상남도 사천시 신수동길 26 (신수동)
4th row경상남도 사천시 사천읍 서재농청길 98 (신진아파트)
5th row경상남도 사천시 사천읍 선인길 17 (전원맨션)
ValueCountFrequency (%)
경상남도 2103
19.9%
사천시 2102
19.9%
송포동 409
 
3.9%
사천읍 202
 
1.9%
신수동 179
 
1.7%
동금동 107
 
1.0%
신수서길 103
 
1.0%
해안관광로 99
 
0.9%
실안동 96
 
0.9%
사남면 95
 
0.9%
Other values (1798) 5063
48.0%
2023-12-11T08:47:24.558905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
10322
20.7%
사 2498
 
5.0%
천 2447
 
4.9%
도 2345
 
4.7%
남 2326
 
4.7%
상 2130
 
4.3%
경 2120
 
4.3%
시 2120
 
4.3%
동 1893
 
3.8%
길 1651
 
3.3%
Other values (275) 19968
40.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 29118
58.4%
Space Separator 10322
 
20.7%
Decimal Number 6575
 
13.2%
Open Punctuation 1387
 
2.8%
Close Punctuation 1386
 
2.8%
Dash Punctuation 950
 
1.9%
Other Punctuation 82
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 2498
 
8.6%
천 2447
 
8.4%
도 2345
 
8.1%
남 2326
 
8.0%
상 2130
 
7.3%
경 2120
 
7.3%
시 2120
 
7.3%
동 1893
 
6.5%
길 1651
 
5.7%
포 711
 
2.4%
Other values (260) 8877
30.5%
Decimal Number
ValueCountFrequency (%)
1 1487
22.6%
2 1024
15.6%
3 820
12.5%
4 625
9.5%
5 540
 
8.2%
7 473
 
7.2%
8 450
 
6.8%
6 429
 
6.5%
0 388
 
5.9%
9 339
 
5.2%
Space Separator
ValueCountFrequency (%)
10322
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1387
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1386
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 950
100.0%
Other Punctuation
ValueCountFrequency (%)
, 82
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 29118
58.4%
Common 20702
41.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 2498
 
8.6%
천 2447
 
8.4%
도 2345
 
8.1%
남 2326
 
8.0%
상 2130
 
7.3%
경 2120
 
7.3%
시 2120
 
7.3%
동 1893
 
6.5%
길 1651
 
5.7%
포 711
 
2.4%
Other values (260) 8877
30.5%
Common
ValueCountFrequency (%)
10322
49.9%
1 1487
 
7.2%
( 1387
 
6.7%
) 1386
 
6.7%
2 1024
 
4.9%
- 950
 
4.6%
3 820
 
4.0%
4 625
 
3.0%
5 540
 
2.6%
7 473
 
2.3%
Other values (5) 1688
 
8.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 29118
58.4%
ASCII 20702
41.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
10322
49.9%
1 1487
 
7.2%
( 1387
 
6.7%
) 1386
 
6.7%
2 1024
 
4.9%
- 950
 
4.6%
3 820
 
4.0%
4 625
 
3.0%
5 540
 
2.6%
7 473
 
2.3%
Other values (5) 1688
 
8.2%
Hangul
ValueCountFrequency (%)
사 2498
 
8.6%
천 2447
 
8.4%
도 2345
 
8.1%
남 2326
 
8.0%
상 2130
 
7.3%
경 2120
 
7.3%
시 2120
 
7.3%
동 1893
 
6.5%
길 1651
 
5.7%
포 711
 
2.4%
Other values (260) 8877
30.5%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.6 KiB
2023-10-31
2106 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-10-31
2nd row2023-10-31
3rd row2023-10-31
4th row2023-10-31
5th row2023-10-31

Common Values

ValueCountFrequency (%)
2023-10-31 2106
100.0%

Length

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

Common Values (Plot)

2023-12-11T08:47:24.769294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-10-31 2106
100.0%

Interactions

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

Missing values

2023-12-11T08:47:23.283686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T08:47:23.348994image/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길 422023-10-31
12경상남도 사천시 사천읍 선평길 50 (신진맨션)2023-10-31
23경상남도 사천시 신수동길 26 (신수동)2023-10-31
34경상남도 사천시 사천읍 서재농청길 98 (신진아파트)2023-10-31
45경상남도 사천시 사천읍 선인길 17 (전원맨션)2023-10-31
56경상남도 사천시 신수서길 47-7 (신수동)2023-10-31
67경상남도 사천시 신수서길 47-4 (신수동)2023-10-31
78경상남도 사천시 신수서길 51 (신수동)2023-10-31
89경상남도 사천시 삼천포대교로 325-33 (대방동)2023-10-31
910경상남도 사천시 사천읍 선인길 392023-10-31
순번스마트워터미터기 설치주소데이터기준일자
20962097경상남도 사천시 정동면 복상2길 642023-10-31
20972098경상남도 사천시 임내길 31 (죽림동, 라온빌)2023-10-31
20982099경상남도 사천시 사천읍 동문2길 1002023-10-31
20992100경상남도 사천시 사천읍 정의길 73-192023-10-31
21002101경상남도 사천시 사천읍 동문4길 1112023-10-31
21012102경상남도 사천시 구미1길 (송포동 산186-16)2023-10-31
21022103경상남도 사천시 삼천포대교로 911 (송포동)2023-10-31
21032104경상남도 사천시 사천읍 옥산로 50-27 (한빛타운)2023-10-31
21042105경상남도 사천시 곤양면 가리2길 72-182023-10-31
21052106경상남도 사천시 사천읍 수석1길 12-122023-10-31