Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory498.0 KiB
Average record size in memory51.0 B

Variable types

Numeric3
Text1
DateTime1

Dataset

Description경상남도 진주시 스마트워터미터기(수도사용량 원격검침기) 설치 현황내역이며, 검침원이 직접 방문하지 않고 원격으로 수도 사용량을 확인 가능한 스마트워터미터기 주소 및 위치정보 자료입니다.
Author경상남도 진주시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15103321

Alerts

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

Reproduction

Analysis started2023-12-11 00:52:54.389449
Analysis finished2023-12-11 00:52:55.943696
Duration1.55 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%
Mean10469.413
Minimum1
Maximum20952
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T09:52:56.008293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1066.9
Q15207.75
median10428.5
Q315753.25
95-th percentile19887.1
Maximum20952
Range20951
Interquartile range (IQR)10545.5

Descriptive statistics

Standard deviation6057.1821
Coefficient of variation (CV)0.57855985
Kurtosis-1.2049759
Mean10469.413
Median Absolute Deviation (MAD)5271
Skewness0.003513748
Sum1.0469413 × 108
Variance36689455
MonotonicityNot monotonic
2023-12-11T09:52:56.116392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
11207 1
 
< 0.1%
9035 1
 
< 0.1%
10266 1
 
< 0.1%
17165 1
 
< 0.1%
19836 1
 
< 0.1%
10210 1
 
< 0.1%
11372 1
 
< 0.1%
5592 1
 
< 0.1%
15367 1
 
< 0.1%
1830 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
9 1
< 0.1%
11 1
< 0.1%
14 1
< 0.1%
18 1
< 0.1%
20 1
< 0.1%
ValueCountFrequency (%)
20952 1
< 0.1%
20950 1
< 0.1%
20949 1
< 0.1%
20947 1
< 0.1%
20946 1
< 0.1%
20942 1
< 0.1%
20940 1
< 0.1%
20937 1
< 0.1%
20935 1
< 0.1%
20933 1
< 0.1%

도로명주소
Text

Distinct9910
Distinct (%)99.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T09:52:56.377308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length59
Median length46
Mean length26.4439
Min length14

Characters and Unicode

Total characters264439
Distinct characters521
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique9822 ?
Unique (%)98.2%

Sample

1st row경상남도 진주시 집현면 지내리 168-8 (농막)
2nd row경상남도 진주시 이반성면 진마대로2498번길 9-31
3rd row경상남도 진주시 문산읍 정자천로 269-6 (안전리)
4th row경상남도 진주시 사봉면 사군로55번길 14 (사곡리)
5th row경상남도 진주시 돗골로9번길 13
ValueCountFrequency (%)
진주시 10006
 
18.7%
경상남도 10001
 
18.7%
문산읍 1146
 
2.1%
정촌면 682
 
1.3%
상평동 673
 
1.3%
금곡면 652
 
1.2%
일반성면 632
 
1.2%
수곡면 606
 
1.1%
진성면 606
 
1.1%
이반성면 562
 
1.1%
Other values (5385) 27816
52.1%
2023-12-11T09:52:57.004649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
43819
 
16.6%
진 11665
 
4.4%
경 11077
 
4.2%
상 11041
 
4.2%
남 10992
 
4.2%
주 10767
 
4.1%
도 10084
 
3.8%
시 10071
 
3.8%
1 9814
 
3.7%
길 8840
 
3.3%
Other values (511) 126269
47.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 157136
59.4%
Decimal Number 44725
 
16.9%
Space Separator 43819
 
16.6%
Open Punctuation 6401
 
2.4%
Close Punctuation 6400
 
2.4%
Dash Punctuation 4900
 
1.9%
Other Punctuation 925
 
0.3%
Uppercase Letter 128
 
< 0.1%
Lowercase Letter 3
 
< 0.1%
Math Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
진 11665
 
7.4%
경 11077
 
7.0%
상 11041
 
7.0%
남 10992
 
7.0%
주 10767
 
6.9%
도 10084
 
6.4%
시 10071
 
6.4%
길 8840
 
5.6%
로 6945
 
4.4%
번 6062
 
3.9%
Other values (467) 59592
37.9%
Uppercase Letter
ValueCountFrequency (%)
C 23
18.0%
E 16
12.5%
T 15
11.7%
I 15
11.7%
H 14
10.9%
A 7
 
5.5%
S 6
 
4.7%
L 6
 
4.7%
B 6
 
4.7%
G 4
 
3.1%
Other values (10) 16
12.5%
Decimal Number
ValueCountFrequency (%)
1 9814
21.9%
2 5728
12.8%
3 4640
10.4%
5 4300
9.6%
4 3942
8.8%
9 3690
 
8.3%
6 3627
 
8.1%
7 3211
 
7.2%
0 2912
 
6.5%
8 2861
 
6.4%
Other Punctuation
ValueCountFrequency (%)
, 569
61.5%
/ 304
32.9%
. 50
 
5.4%
: 2
 
0.2%
Lowercase Letter
ValueCountFrequency (%)
t 1
33.3%
h 1
33.3%
e 1
33.3%
Open Punctuation
ValueCountFrequency (%)
( 6308
98.5%
[ 93
 
1.5%
Close Punctuation
ValueCountFrequency (%)
) 6307
98.5%
] 93
 
1.5%
Space Separator
ValueCountFrequency (%)
43819
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4900
100.0%
Math Symbol
ValueCountFrequency (%)
> 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 157136
59.4%
Common 107172
40.5%
Latin 131
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
진 11665
 
7.4%
경 11077
 
7.0%
상 11041
 
7.0%
남 10992
 
7.0%
주 10767
 
6.9%
도 10084
 
6.4%
시 10071
 
6.4%
길 8840
 
5.6%
로 6945
 
4.4%
번 6062
 
3.9%
Other values (467) 59592
37.9%
Latin
ValueCountFrequency (%)
C 23
17.6%
E 16
12.2%
T 15
11.5%
I 15
11.5%
H 14
10.7%
A 7
 
5.3%
S 6
 
4.6%
L 6
 
4.6%
B 6
 
4.6%
G 4
 
3.1%
Other values (13) 19
14.5%
Common
ValueCountFrequency (%)
43819
40.9%
1 9814
 
9.2%
( 6308
 
5.9%
) 6307
 
5.9%
2 5728
 
5.3%
- 4900
 
4.6%
3 4640
 
4.3%
5 4300
 
4.0%
4 3942
 
3.7%
9 3690
 
3.4%
Other values (11) 13724
 
12.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 157136
59.4%
ASCII 107303
40.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
43819
40.8%
1 9814
 
9.1%
( 6308
 
5.9%
) 6307
 
5.9%
2 5728
 
5.3%
- 4900
 
4.6%
3 4640
 
4.3%
5 4300
 
4.0%
4 3942
 
3.7%
9 3690
 
3.4%
Other values (34) 13855
 
12.9%
Hangul
ValueCountFrequency (%)
진 11665
 
7.4%
경 11077
 
7.0%
상 11041
 
7.0%
남 10992
 
7.0%
주 10767
 
6.9%
도 10084
 
6.4%
시 10071
 
6.4%
길 8840
 
5.6%
로 6945
 
4.4%
번 6062
 
3.9%
Other values (467) 59592
37.9%

위도
Real number (ℝ)

Distinct9796
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.173291
Minimum35.06928
Maximum35.324388
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T09:52:57.132124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum35.06928
5-th percentile35.115968
Q135.162897
median35.174842
Q335.185677
95-th percentile35.232431
Maximum35.324388
Range0.25510807
Interquartile range (IQR)0.02277956

Descriptive statistics

Standard deviation0.031716362
Coefficient of variation (CV)0.00090171719
Kurtosis1.4230393
Mean35.173291
Median Absolute Deviation (MAD)0.01096115
Skewness-0.17708379
Sum351732.91
Variance0.0010059276
MonotonicityNot monotonic
2023-12-11T09:52:57.256613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
35.20021725 8
 
0.1%
35.17087608 6
 
0.1%
35.10877207 6
 
0.1%
35.15913092 4
 
< 0.1%
35.17311381 4
 
< 0.1%
35.17111611 3
 
< 0.1%
35.12876344 3
 
< 0.1%
35.20055552 3
 
< 0.1%
35.23192817 3
 
< 0.1%
35.17299338 3
 
< 0.1%
Other values (9786) 9957
99.6%
ValueCountFrequency (%)
35.06927991 1
< 0.1%
35.06946004 1
< 0.1%
35.06954157 1
< 0.1%
35.06960628 1
< 0.1%
35.06966806 1
< 0.1%
35.06982139 1
< 0.1%
35.06983104 1
< 0.1%
35.06986563 1
< 0.1%
35.06992953 1
< 0.1%
35.06994799 1
< 0.1%
ValueCountFrequency (%)
35.32438798 1
< 0.1%
35.31374748 1
< 0.1%
35.30691247 1
< 0.1%
35.29343331 1
< 0.1%
35.29145157 1
< 0.1%
35.28745458 1
< 0.1%
35.28729362 1
< 0.1%
35.28685137 1
< 0.1%
35.28670742 1
< 0.1%
35.28649126 1
< 0.1%

경도
Real number (ℝ)

Distinct9783
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.14884
Minimum127.89418
Maximum128.35643
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T09:52:57.387316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.89418
5-th percentile127.94938
Q1128.0879
median128.13437
Q3128.22497
95-th percentile128.31242
Maximum128.35643
Range0.4622541
Interquartile range (IQR)0.13706105

Descriptive statistics

Standard deviation0.1005094
Coefficient of variation (CV)0.00078431771
Kurtosis-0.21302323
Mean128.14884
Median Absolute Deviation (MAD)0.0517211
Skewness-0.18503597
Sum1281488.4
Variance0.01010214
MonotonicityNot monotonic
2023-12-11T09:52:57.541162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
128.1312427 8
 
0.1%
128.2827601 6
 
0.1%
128.1875673 6
 
0.1%
128.100349 4
 
< 0.1%
127.953958 4
 
< 0.1%
128.1107578 3
 
< 0.1%
128.2762391 3
 
< 0.1%
128.1041365 3
 
< 0.1%
128.2764375 3
 
< 0.1%
128.2100322 3
 
< 0.1%
Other values (9773) 9957
99.6%
ValueCountFrequency (%)
127.8941805 1
< 0.1%
127.8942454 1
< 0.1%
127.8943667 1
< 0.1%
127.8944104 1
< 0.1%
127.8944655 1
< 0.1%
127.8945827 1
< 0.1%
127.8946051 1
< 0.1%
127.8949885 1
< 0.1%
127.8951758 1
< 0.1%
127.8951762 1
< 0.1%
ValueCountFrequency (%)
128.3564346 1
< 0.1%
128.3560897 1
< 0.1%
128.3558147 1
< 0.1%
128.3557497 1
< 0.1%
128.3555943 1
< 0.1%
128.3555644 1
< 0.1%
128.3555074 1
< 0.1%
128.355373 1
< 0.1%
128.3553709 1
< 0.1%
128.3553657 1
< 0.1%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-08-07 00:00:00
Maximum2022-08-07 00:00:00
2023-12-11T09:52:57.641885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:52:57.715683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-11T09:52:55.574011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:52:55.038990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:52:55.302907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:52:55.650159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:52:55.123817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:52:55.403550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:52:55.733351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:52:55.206861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:52:55.494567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T09:52:57.774496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번위도경도
연번1.0000.8520.908
위도0.8521.0000.709
경도0.9080.7091.000
2023-12-11T09:52:57.847566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번위도경도
연번1.0000.448-0.470
위도0.4481.000-0.177
경도-0.470-0.1771.000

Missing values

2023-12-11T09:52:55.822021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T09:52:55.902870image/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

연번도로명주소위도경도데이터기준일
1120611207경상남도 진주시 집현면 지내리 168-8 (농막)35.24311128.0893612022-08-07
78377838경상남도 진주시 이반성면 진마대로2498번길 9-3135.146325128.3240722022-08-07
17981799경상남도 진주시 문산읍 정자천로 269-6 (안전리)35.140998128.1938422022-08-07
95919592경상남도 진주시 사봉면 사군로55번길 14 (사곡리)35.187721128.2642842022-08-07
1718717188경상남도 진주시 돗골로9번길 1335.168858128.1114752022-08-07
71647165경상남도 진주시 일반성면 개암길 2535.169505128.2942822022-08-07
1732317324경상남도 진주시 대신로 108, 팔복정비 (상평동)35.169879128.1186242022-08-07
1557615577경상남도 진주시 망경남길43번길 935.200217128.1312432022-08-07
1754717548경상남도 진주시 남강로1239번길 9, 남강상회 (상평동)35.172459128.1251592022-08-07
27242725경상남도 진주시 정촌면 내동로 284-5 (화개리)35.147652128.0954442022-08-07
연번도로명주소위도경도데이터기준일
1198411985경상남도 진주시 수곡면 사곡로 42735.233929127.9145632022-08-07
1375713758경상남도 진주시 봉수대길 4135.180413128.0792012022-08-07
55885589경상남도 진주시 진성면 대사길 2835.147795128.2522572022-08-07
98789879경상남도 진주시 사봉면 모곡길 65 (봉곡리)35.198119128.2933542022-08-07
27162717경상남도 진주시 정촌면 진주대로379번길 30 (화개리)35.142674128.0983472022-08-07
418419경상남도 진주시 문산읍 소문길53번길 14 (소문리)35.171605128.1676442022-08-07
2039820399경상남도 진주시 영천강로119번길 20-8 (충무공동)35.173907128.136922022-08-07
2047520476경상남도 진주시 범골로25번길 12-20 (충무공동)35.168417128.128822022-08-07
771772경상남도 진주시 문산읍 동부로 664-1 (삼곡리)35.170301128.1718352022-08-07
26352636경상남도 진주시 정촌면 화개길 320 (화개리)35.140343128.1043692022-08-07