Overview

Dataset statistics

Number of variables3
Number of observations682
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory16.8 KiB
Average record size in memory25.2 B

Variable types

Numeric1
Text2

Dataset

Description전라남도 순천시 상하수도 스마트워터 미터기 및 단말기를 부착해 원격으로 검침이 가능한 원격검침 대상 수용가에 대한 성명과 주소에 대한 데이터입니다.
URLhttps://www.data.go.kr/data/15104255/fileData.do

Alerts

순번 has unique valuesUnique
수용가번호 has unique valuesUnique

Reproduction

Analysis started2023-12-11 23:30:09.026547
Analysis finished2023-12-11 23:30:09.519947
Duration0.49 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct682
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean341.5
Minimum1
Maximum682
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.1 KiB
2023-12-12T08:30:09.601447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile35.05
Q1171.25
median341.5
Q3511.75
95-th percentile647.95
Maximum682
Range681
Interquartile range (IQR)340.5

Descriptive statistics

Standard deviation197.02073
Coefficient of variation (CV)0.57692746
Kurtosis-1.2
Mean341.5
Median Absolute Deviation (MAD)170.5
Skewness0
Sum232903
Variance38817.167
MonotonicityStrictly increasing
2023-12-12T08:30:09.773751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
459 1
 
0.1%
451 1
 
0.1%
452 1
 
0.1%
453 1
 
0.1%
454 1
 
0.1%
455 1
 
0.1%
456 1
 
0.1%
457 1
 
0.1%
458 1
 
0.1%
Other values (672) 672
98.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 (%)
682 1
0.1%
681 1
0.1%
680 1
0.1%
679 1
0.1%
678 1
0.1%
677 1
0.1%
676 1
0.1%
675 1
0.1%
674 1
0.1%
673 1
0.1%

수용가번호
Text

UNIQUE 

Distinct682
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size5.5 KiB
2023-12-12T08:30:10.028405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length15
Mean length15
Min length15

Characters and Unicode

Total characters10230
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique682 ?
Unique (%)100.0%

Sample

1st row102-010-0135-00
2nd row102-010-0152-00
3rd row102-020-0080-00
4th row102-020-0146-00
5th row102-020-0351-00
ValueCountFrequency (%)
102-010-0135-00 1
 
0.1%
218-010-3264-00 1
 
0.1%
218-010-2963-00 1
 
0.1%
218-010-2974-00 1
 
0.1%
219-010-0548-00 1
 
0.1%
218-010-3001-00 1
 
0.1%
218-010-3010-00 1
 
0.1%
218-010-3064-00 1
 
0.1%
218-010-3093-00 1
 
0.1%
218-010-3139-00 1
 
0.1%
Other values (672) 672
98.5%
2023-12-12T08:30:10.469290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 3801
37.2%
- 2046
20.0%
1 1557
15.2%
2 833
 
8.1%
3 390
 
3.8%
6 324
 
3.2%
9 303
 
3.0%
5 278
 
2.7%
4 269
 
2.6%
8 222
 
2.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 8184
80.0%
Dash Punctuation 2046
 
20.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 3801
46.4%
1 1557
19.0%
2 833
 
10.2%
3 390
 
4.8%
6 324
 
4.0%
9 303
 
3.7%
5 278
 
3.4%
4 269
 
3.3%
8 222
 
2.7%
7 207
 
2.5%
Dash Punctuation
ValueCountFrequency (%)
- 2046
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 10230
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 3801
37.2%
- 2046
20.0%
1 1557
15.2%
2 833
 
8.1%
3 390
 
3.8%
6 324
 
3.2%
9 303
 
3.0%
5 278
 
2.7%
4 269
 
2.6%
8 222
 
2.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 10230
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 3801
37.2%
- 2046
20.0%
1 1557
15.2%
2 833
 
8.1%
3 390
 
3.8%
6 324
 
3.2%
9 303
 
3.0%
5 278
 
2.7%
4 269
 
2.6%
8 222
 
2.2%

주소
Text

Distinct663
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Memory size5.5 KiB
2023-12-12T08:30:10.898510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length37
Mean length23.891496
Min length16

Characters and Unicode

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

Unique

Unique644 ?
Unique (%)94.4%

Sample

1st row전라남도 순천시 호남길 63(영동)
2nd row전라남도 순천시 향교길 25, 104호(영동, 건양맨션)(영동)
3rd row전라남도 순천시 옥천길 100(옥천동)
4th row전라남도 순천시 옥천길 131(옥천동)
5th row전라남도 순천시 옥천1길 79(옥천동)
ValueCountFrequency (%)
전라남도 682
21.5%
순천시 682
21.5%
해룡면 93
 
2.9%
주암면 85
 
2.7%
서면 65
 
2.0%
별량면 54
 
1.7%
환선로 21
 
0.7%
주공아파트 17
 
0.5%
132 17
 
0.5%
백강로 17
 
0.5%
Other values (1006) 1446
45.5%
2023-12-12T08:30:11.426144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2499
 
15.3%
남 747
 
4.6%
천 743
 
4.6%
전 729
 
4.5%
도 697
 
4.3%
시 692
 
4.2%
순 690
 
4.2%
라 684
 
4.2%
( 612
 
3.8%
) 612
 
3.8%
Other values (228) 7589
46.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 10190
62.5%
Space Separator 2499
 
15.3%
Decimal Number 2111
 
13.0%
Open Punctuation 612
 
3.8%
Close Punctuation 612
 
3.8%
Dash Punctuation 154
 
0.9%
Other Punctuation 102
 
0.6%
Uppercase Letter 14
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
남 747
 
7.3%
천 743
 
7.3%
전 729
 
7.2%
도 697
 
6.8%
시 692
 
6.8%
순 690
 
6.8%
라 684
 
6.7%
길 557
 
5.5%
동 414
 
4.1%
면 315
 
3.1%
Other values (205) 3922
38.5%
Decimal Number
ValueCountFrequency (%)
1 471
22.3%
2 355
16.8%
3 247
11.7%
4 203
9.6%
0 178
 
8.4%
5 170
 
8.1%
6 155
 
7.3%
7 125
 
5.9%
8 113
 
5.4%
9 94
 
4.5%
Uppercase Letter
ValueCountFrequency (%)
A 3
21.4%
B 3
21.4%
S 3
21.4%
N 1
 
7.1%
D 1
 
7.1%
R 1
 
7.1%
P 1
 
7.1%
M 1
 
7.1%
Space Separator
ValueCountFrequency (%)
2499
100.0%
Open Punctuation
ValueCountFrequency (%)
( 612
100.0%
Close Punctuation
ValueCountFrequency (%)
) 612
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 154
100.0%
Other Punctuation
ValueCountFrequency (%)
, 102
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 10190
62.5%
Common 6090
37.4%
Latin 14
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
남 747
 
7.3%
천 743
 
7.3%
전 729
 
7.2%
도 697
 
6.8%
시 692
 
6.8%
순 690
 
6.8%
라 684
 
6.7%
길 557
 
5.5%
동 414
 
4.1%
면 315
 
3.1%
Other values (205) 3922
38.5%
Common
ValueCountFrequency (%)
2499
41.0%
( 612
 
10.0%
) 612
 
10.0%
1 471
 
7.7%
2 355
 
5.8%
3 247
 
4.1%
4 203
 
3.3%
0 178
 
2.9%
5 170
 
2.8%
6 155
 
2.5%
Other values (5) 588
 
9.7%
Latin
ValueCountFrequency (%)
A 3
21.4%
B 3
21.4%
S 3
21.4%
N 1
 
7.1%
D 1
 
7.1%
R 1
 
7.1%
P 1
 
7.1%
M 1
 
7.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 10190
62.5%
ASCII 6104
37.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2499
40.9%
( 612
 
10.0%
) 612
 
10.0%
1 471
 
7.7%
2 355
 
5.8%
3 247
 
4.0%
4 203
 
3.3%
0 178
 
2.9%
5 170
 
2.8%
6 155
 
2.5%
Other values (13) 602
 
9.9%
Hangul
ValueCountFrequency (%)
남 747
 
7.3%
천 743
 
7.3%
전 729
 
7.2%
도 697
 
6.8%
시 692
 
6.8%
순 690
 
6.8%
라 684
 
6.7%
길 557
 
5.5%
동 414
 
4.1%
면 315
 
3.1%
Other values (205) 3922
38.5%

Interactions

2023-12-12T08:30:09.189599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T08:30:09.354147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T08:30:09.474835image/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

순번수용가번호주소
01102-010-0135-00전라남도 순천시 호남길 63(영동)
12102-010-0152-00전라남도 순천시 향교길 25, 104호(영동, 건양맨션)(영동)
23102-020-0080-00전라남도 순천시 옥천길 100(옥천동)
34102-020-0146-00전라남도 순천시 옥천길 131(옥천동)
45102-020-0351-00전라남도 순천시 옥천1길 79(옥천동)
56102-020-0357-00전라남도 순천시 옥천1길 65(옥천동)
67102-020-0383-00전라남도 순천시 산행길 33(옥천동)
78102-020-0414-00전라남도 순천시 서문교길 29(옥천동)
89102-020-0442-00전라남도 순천시 옥천길 271(옥천동)
910102-020-0561-00전라남도 순천시 금옥길 196(옥천동)
순번수용가번호주소
672673320-010-0017-00전라남도 순천시 황전면 수평길 21
673674323-010-0006-00전라남도 순천시 송광면 쌍향수길 1169
674675325-010-0001-00전라남도 순천시 외서면 반월로 6
675676325-010-0002-00전라남도 순천시 외서면 쌍향수길 471
676677325-010-0003-00전라남도 순천시 외서면 쌍향수길 476
677678325-010-0004-00전라남도 순천시 외서면 쌍향수길 440
678679325-010-0005-00전라남도 순천시 외서면 쌍향수길 440
679680325-010-0006-00전라남도 순천시 외서면 읍성로 53
680681327-010-0001-00전라남도 순천시 월등면 월평2길 21
681682327-010-0002-00전라남도 순천시 월등면 백야중길 30