Overview

Dataset statistics

Number of variables4
Number of observations238
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.0 KiB
Average record size in memory34.6 B

Variable types

Numeric1
Text1
Categorical1
DateTime1

Dataset

Description경상북도 예천군 관내 스마트초음파계량기(수도미터기) 설치현황(순번, 설치주소, 구경, 기준일자)자료입니다.
Author경상북도 예천군
URLhttps://www.data.go.kr/data/15103206/fileData.do

Alerts

기준일자 has constant value ""Constant
구경 is highly imbalanced (95.1%)Imbalance
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 15:25:50.320169
Analysis finished2023-12-12 15:25:50.696163
Duration0.38 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct238
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean119.5
Minimum1
Maximum238
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.2 KiB
2023-12-13T00:25:50.772307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile12.85
Q160.25
median119.5
Q3178.75
95-th percentile226.15
Maximum238
Range237
Interquartile range (IQR)118.5

Descriptive statistics

Standard deviation68.848868
Coefficient of variation (CV)0.57614116
Kurtosis-1.2
Mean119.5
Median Absolute Deviation (MAD)59.5
Skewness0
Sum28441
Variance4740.1667
MonotonicityStrictly increasing
2023-12-13T00:25:50.936478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
165 1
 
0.4%
153 1
 
0.4%
154 1
 
0.4%
155 1
 
0.4%
156 1
 
0.4%
157 1
 
0.4%
158 1
 
0.4%
159 1
 
0.4%
160 1
 
0.4%
Other values (228) 228
95.8%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
238 1
0.4%
237 1
0.4%
236 1
0.4%
235 1
0.4%
234 1
0.4%
233 1
0.4%
232 1
0.4%
231 1
0.4%
230 1
0.4%
229 1
0.4%

주소
Text

Distinct221
Distinct (%)92.9%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2023-12-13T00:25:51.313908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length13
Mean length12.403361
Min length10

Characters and Unicode

Total characters2952
Distinct characters23
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique211 ?
Unique (%)88.7%

Sample

1st row풍양면 우망리 924
2nd row풍양면 청곡리 454-3
3rd row풍양면 청곡리 452-3
4th row풍양면 청곡리 454-1
5th row풍양면 청곡리 453-4
ValueCountFrequency (%)
풍양면 238
33.4%
우망리 121
17.0%
청곡리 109
15.3%
326-2 6
 
0.8%
오지리 6
 
0.8%
338-2 4
 
0.6%
334-1 4
 
0.6%
336-1 3
 
0.4%
332 3
 
0.4%
453 2
 
0.3%
Other values (206) 216
30.3%
2023-12-13T00:25:51.808461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
474
16.1%
풍 238
 
8.1%
면 238
 
8.1%
리 238
 
8.1%
양 238
 
8.1%
- 168
 
5.7%
3 165
 
5.6%
2 128
 
4.3%
우 123
 
4.2%
망 123
 
4.2%
Other values (13) 819
27.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1432
48.5%
Decimal Number 878
29.7%
Space Separator 474
 
16.1%
Dash Punctuation 168
 
5.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
풍 238
16.6%
면 238
16.6%
리 238
16.6%
양 238
16.6%
우 123
8.6%
망 123
8.6%
청 109
7.6%
곡 109
7.6%
오 6
 
0.4%
지 6
 
0.4%
Decimal Number
ValueCountFrequency (%)
3 165
18.8%
2 128
14.6%
1 105
12.0%
4 96
10.9%
6 85
9.7%
5 71
8.1%
8 65
 
7.4%
0 61
 
6.9%
7 54
 
6.2%
9 48
 
5.5%
Space Separator
ValueCountFrequency (%)
474
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 168
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1520
51.5%
Hangul 1432
48.5%

Most frequent character per script

Common
ValueCountFrequency (%)
474
31.2%
- 168
 
11.1%
3 165
 
10.9%
2 128
 
8.4%
1 105
 
6.9%
4 96
 
6.3%
6 85
 
5.6%
5 71
 
4.7%
8 65
 
4.3%
0 61
 
4.0%
Other values (2) 102
 
6.7%
Hangul
ValueCountFrequency (%)
풍 238
16.6%
면 238
16.6%
리 238
16.6%
양 238
16.6%
우 123
8.6%
망 123
8.6%
청 109
7.6%
곡 109
7.6%
오 6
 
0.4%
지 6
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1520
51.5%
Hangul 1432
48.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
474
31.2%
- 168
 
11.1%
3 165
 
10.9%
2 128
 
8.4%
1 105
 
6.9%
4 96
 
6.3%
6 85
 
5.6%
5 71
 
4.7%
8 65
 
4.3%
0 61
 
4.0%
Other values (2) 102
 
6.7%
Hangul
ValueCountFrequency (%)
풍 238
16.6%
면 238
16.6%
리 238
16.6%
양 238
16.6%
우 123
8.6%
망 123
8.6%
청 109
7.6%
곡 109
7.6%
오 6
 
0.4%
지 6
 
0.4%

구경
Categorical

IMBALANCE 

Distinct3
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
13
236 
20
 
1
15
 
1

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique2 ?
Unique (%)0.8%

Sample

1st row13
2nd row13
3rd row13
4th row13
5th row13

Common Values

ValueCountFrequency (%)
13 236
99.2%
20 1
 
0.4%
15 1
 
0.4%

Length

2023-12-13T00:25:51.943688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:25:52.053258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
13 236
99.2%
20 1
 
0.4%
15 1
 
0.4%

기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
Minimum2022-08-04 00:00:00
Maximum2022-08-04 00:00:00
2023-12-13T00:25:52.143796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:25:52.265614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T00:25:50.439063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T00:25:52.380156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번구경
순번1.0000.000
구경0.0001.000
2023-12-13T00:25:52.487238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번구경
순번1.0000.000
구경0.0001.000

Missing values

2023-12-13T00:25:50.552776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:25:50.657856image/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풍양면 우망리 924132022-08-04
12풍양면 청곡리 454-3132022-08-04
23풍양면 청곡리 452-3132022-08-04
34풍양면 청곡리 454-1132022-08-04
45풍양면 청곡리 453-4132022-08-04
56풍양면 청곡리 453132022-08-04
67풍양면 청곡리 277-1132022-08-04
78풍양면 청곡리 326132022-08-04
89풍양면 청곡리 332132022-08-04
910풍양면 청곡리 334-1132022-08-04
순번주소구경기준일자
228229풍양면 우망리 365132022-08-04
229230풍양면 우망리 863132022-08-04
230231풍양면 우망리 857-1132022-08-04
231232풍양면 우망리 347132022-08-04
232233풍양면 우망리 338-2132022-08-04
233234풍양면 우망리343132022-08-04
234235풍양면 우망리 359-4132022-08-04
235236풍양면 우망리 372132022-08-04
236237풍양면 우망리 898132022-08-04
237238풍양면 우망리 387-1132022-08-04