Overview

Dataset statistics

Number of variables4
Number of observations490
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory16.4 KiB
Average record size in memory34.3 B

Variable types

Text1
Numeric2
DateTime1

Dataset

Description경상북도 김천시에서 제공하는 스마트 워터미터 설치 현황 정보로, 설치 주소(도로명주소), 설치 좌표 등의 정보를 제공합니다.
Author경상북도 김천시
URLhttps://www.data.go.kr/data/15102973/fileData.do

Alerts

데이터기준일자 has constant value ""Constant

Reproduction

Analysis started2024-04-21 09:45:43.759311
Analysis finished2024-04-21 09:45:45.549840
Duration1.79 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

스마트 워터미터 설치 주소(도로명)
Text

Distinct485
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
2024-04-21T18:45:46.327033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length13
Mean length7.7836735
Min length4

Characters and Unicode

Total characters3814
Distinct characters39
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique480 ?
Unique (%)98.0%

Sample

1st row송천리 1239-2
2nd row한지1길 28-16
3rd row아포순환로434
4th row송천리 1106
5th row아포순환로435
ValueCountFrequency (%)
대성지1길 13
 
2.5%
대성지2길 11
 
2.1%
예리 4
 
0.8%
송천리 4
 
0.8%
송선로110 2
 
0.4%
금계2길 2
 
0.4%
예1길37 2
 
0.4%
송선로118-2 2
 
0.4%
703 2
 
0.4%
금계2길13-3 2
 
0.4%
Other values (485) 485
91.7%
2024-04-21T18:45:47.743919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 511
13.4%
길 436
 
11.4%
2 320
 
8.4%
- 314
 
8.2%
3 211
 
5.5%
금 176
 
4.6%
7 175
 
4.6%
4 136
 
3.6%
6 132
 
3.5%
8 129
 
3.4%
Other values (29) 1274
33.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1977
51.8%
Other Letter 1483
38.9%
Dash Punctuation 314
 
8.2%
Space Separator 39
 
1.0%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
길 436
29.4%
금 176
11.9%
계 115
 
7.8%
예 101
 
6.8%
리 75
 
5.1%
천 65
 
4.4%
송 61
 
4.1%
명 47
 
3.2%
광 47
 
3.2%
로 44
 
3.0%
Other values (16) 316
21.3%
Decimal Number
ValueCountFrequency (%)
1 511
25.8%
2 320
16.2%
3 211
10.7%
7 175
 
8.9%
4 136
 
6.9%
6 132
 
6.7%
8 129
 
6.5%
5 129
 
6.5%
0 119
 
6.0%
9 115
 
5.8%
Dash Punctuation
ValueCountFrequency (%)
- 314
100.0%
Space Separator
ValueCountFrequency (%)
39
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2331
61.1%
Hangul 1483
38.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
길 436
29.4%
금 176
11.9%
계 115
 
7.8%
예 101
 
6.8%
리 75
 
5.1%
천 65
 
4.4%
송 61
 
4.1%
명 47
 
3.2%
광 47
 
3.2%
로 44
 
3.0%
Other values (16) 316
21.3%
Common
ValueCountFrequency (%)
1 511
21.9%
2 320
13.7%
- 314
13.5%
3 211
9.1%
7 175
 
7.5%
4 136
 
5.8%
6 132
 
5.7%
8 129
 
5.5%
5 129
 
5.5%
0 119
 
5.1%
Other values (3) 155
 
6.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2331
61.1%
Hangul 1482
38.9%
Compat Jamo 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 511
21.9%
2 320
13.7%
- 314
13.5%
3 211
9.1%
7 175
 
7.5%
4 136
 
5.8%
6 132
 
5.7%
8 129
 
5.5%
5 129
 
5.5%
0 119
 
5.1%
Other values (3) 155
 
6.6%
Hangul
ValueCountFrequency (%)
길 436
29.4%
금 176
11.9%
계 115
 
7.8%
예 101
 
6.8%
리 75
 
5.1%
천 65
 
4.4%
송 61
 
4.1%
명 47
 
3.2%
광 47
 
3.2%
로 44
 
3.0%
Other values (15) 315
21.3%
Compat Jamo
ValueCountFrequency (%)
ㅡ 1
100.0%

설치 좌표(위도)
Real number (ℝ)

Distinct459
Distinct (%)93.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36.147767
Minimum36.03543
Maximum36.194221
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.4 KiB
2024-04-21T18:45:48.152967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum36.03543
5-th percentile36.040348
Q136.148184
median36.150869
Q336.162185
95-th percentile36.192859
Maximum36.194221
Range0.158791
Interquartile range (IQR)0.01400075

Descriptive statistics

Standard deviation0.040001367
Coefficient of variation (CV)0.0011066069
Kurtosis2.4268899
Mean36.147767
Median Absolute Deviation (MAD)0.00746
Skewness-1.654864
Sum17712.406
Variance0.0016001093
MonotonicityNot monotonic
2024-04-21T18:45:48.614846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
36.148807 3
 
0.6%
36.148746 2
 
0.4%
36.15874 2
 
0.4%
36.03989 2
 
0.4%
36.150684 2
 
0.4%
36.158508 2
 
0.4%
36.150173 2
 
0.4%
36.149414 2
 
0.4%
36.14928 2
 
0.4%
36.11658 2
 
0.4%
Other values (449) 469
95.7%
ValueCountFrequency (%)
36.03543 1
0.2%
36.035465 1
0.2%
36.035587 1
0.2%
36.036098 1
0.2%
36.036228 1
0.2%
36.03656 1
0.2%
36.036712 1
0.2%
36.03672 1
0.2%
36.036796 1
0.2%
36.036838 1
0.2%
ValueCountFrequency (%)
36.194221 1
0.2%
36.194042 1
0.2%
36.19403 1
0.2%
36.193996 1
0.2%
36.193969 1
0.2%
36.193733 1
0.2%
36.193721 1
0.2%
36.193656 1
0.2%
36.193641 1
0.2%
36.193622 1
0.2%

설치 좌표(경도)
Real number (ℝ)

Distinct427
Distinct (%)87.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.2556
Minimum128.07068
Maximum128.29128
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.4 KiB
2024-04-21T18:45:49.059086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum128.07068
5-th percentile128.07277
Q1128.26445
median128.27376
Q3128.28088
95-th percentile128.28903
Maximum128.29128
Range0.220597
Interquartile range (IQR)0.01642625

Descriptive statistics

Standard deviation0.060153147
Coefficient of variation (CV)0.0004690099
Kurtosis5.3062864
Mean128.2556
Median Absolute Deviation (MAD)0.0077285
Skewness-2.6622842
Sum62845.245
Variance0.0036184011
MonotonicityNot monotonic
2024-04-21T18:45:49.499079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
128.276336 3
 
0.6%
128.271362 3
 
0.6%
128.262329 3
 
0.6%
128.280685 2
 
0.4%
128.261398 2
 
0.4%
128.276275 2
 
0.4%
128.262222 2
 
0.4%
128.262435 2
 
0.4%
128.279861 2
 
0.4%
128.274322 2
 
0.4%
Other values (417) 467
95.3%
ValueCountFrequency (%)
128.070678 1
0.2%
128.070861 1
0.2%
128.070877 1
0.2%
128.071304 1
0.2%
128.071411 1
0.2%
128.071624 1
0.2%
128.071884 1
0.2%
128.071929 1
0.2%
128.071975 1
0.2%
128.072006 1
0.2%
ValueCountFrequency (%)
128.291275 2
0.4%
128.290817 1
0.2%
128.290283 1
0.2%
128.290252 1
0.2%
128.290222 1
0.2%
128.290145 1
0.2%
128.29013 1
0.2%
128.290084 1
0.2%
128.290008 1
0.2%
128.289993 1
0.2%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
Minimum2022-07-27 00:00:00
Maximum2022-07-27 00:00:00
2024-04-21T18:45:49.843306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T18:45:50.139622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-04-21T18:45:44.371863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T18:45:43.919679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T18:45:44.631181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T18:45:44.153997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T18:45:50.340120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치 좌표(위도)설치 좌표(경도)
설치 좌표(위도)1.0000.890
설치 좌표(경도)0.8901.000
2024-04-21T18:45:50.568398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치 좌표(위도)설치 좌표(경도)
설치 좌표(위도)1.000-0.166
설치 좌표(경도)-0.1661.000

Missing values

2024-04-21T18:45:45.141482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T18:45:45.431481image/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

스마트 워터미터 설치 주소(도로명)설치 좌표(위도)설치 좌표(경도)데이터기준일자
0송천리 1239-236.1538128.2662962022-07-27
1한지1길 28-1636.159534128.2609552022-07-27
2아포순환로43436.155139128.2692412022-07-27
3송천리 110636.155025128.2689812022-07-27
4아포순환로43536.154956128.2689512022-07-27
5아포순환로41536.153926128.2693322022-07-27
6금계길162-5136.15356128.270052022-07-27
7금계길162-1436.152404128.2714692022-07-27
8금계길17436.151531128.2715912022-07-27
9금계길17636.151473128.2713922022-07-27
스마트 워터미터 설치 주소(도로명)설치 좌표(위도)설치 좌표(경도)데이터기준일자
480광명3길275-2836.043647128.0743252022-07-27
481광명3길275-3236.043552128.0741422022-07-27
482광명3길275-5236.043586128.0738372022-07-27
483광명3길275-7236.044063128.0737452022-07-27
484광명3길275-8036.044044128.0735622022-07-27
485광명3길275-4136.04393128.0731652022-07-27
486광명3길281-3636.04483128.0752412022-07-27
487광명3길281-4036.044929128.0750422022-07-27
488광명3길281-4136.044975128.0748292022-07-27
489광명3길281-3536.044673128.0751342022-07-27