Overview

Dataset statistics

Number of variables3
Number of observations55
Missing cells17
Missing cells (%)10.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.4 KiB
Average record size in memory26.4 B

Variable types

Text3

Dataset

Description서울특별시 용산구 안경업소현황(안경업소명칭 안경업소사업장소재지(도로명) 안경업소전화번호)에 대한 데이터를 제공합니다
URLhttps://www.data.go.kr/data/3077896/fileData.do

Alerts

전화번호 has 17 (30.9%) missing valuesMissing
안경업소명칭 has unique valuesUnique

Reproduction

Analysis started2023-12-12 22:10:57.287551
Analysis finished2023-12-12 22:10:57.610460
Duration0.32 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

안경업소명칭
Text

UNIQUE 

Distinct55
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size572.0 B
2023-12-13T07:10:58.122176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length14
Mean length7.3272727
Min length3

Characters and Unicode

Total characters403
Distinct characters136
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

Unique55 ?
Unique (%)100.0%

Sample

1st row오호안경원
2nd row윤서울 한남점
3rd row갤러리원 안경원
4th row부부아이웨어
5th row마리안경
ValueCountFrequency (%)
안경원 3
 
4.4%
숙대점 2
 
2.9%
오렌즈 2
 
2.9%
용산아이파크몰점 2
 
2.9%
오호안경원 1
 
1.5%
안경마을 1
 
1.5%
파이안경점 1
 
1.5%
명동안경콘택트 1
 
1.5%
밝은안경콘택트 1
 
1.5%
아이포커스안경 1
 
1.5%
Other values (53) 53
77.9%
2023-12-13T07:10:58.457448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
경 42
 
10.4%
안 41
 
10.2%
원 24
 
6.0%
스 14
 
3.5%
이 14
 
3.5%
13
 
3.2%
점 9
 
2.2%
아 9
 
2.2%
( 7
 
1.7%
) 7
 
1.7%
Other values (126) 223
55.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 330
81.9%
Lowercase Letter 21
 
5.2%
Uppercase Letter 19
 
4.7%
Space Separator 13
 
3.2%
Open Punctuation 7
 
1.7%
Close Punctuation 7
 
1.7%
Other Punctuation 3
 
0.7%
Decimal Number 3
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
경 42
 
12.7%
안 41
 
12.4%
원 24
 
7.3%
스 14
 
4.2%
이 14
 
4.2%
점 9
 
2.7%
아 9
 
2.7%
트 7
 
2.1%
오 6
 
1.8%
리 6
 
1.8%
Other values (95) 158
47.9%
Uppercase Letter
ValueCountFrequency (%)
A 3
15.8%
U 2
10.5%
B 2
10.5%
S 2
10.5%
O 2
10.5%
G 1
 
5.3%
H 1
 
5.3%
I 1
 
5.3%
M 1
 
5.3%
L 1
 
5.3%
Other values (3) 3
15.8%
Lowercase Letter
ValueCountFrequency (%)
e 6
28.6%
o 3
14.3%
r 3
14.3%
l 2
 
9.5%
a 1
 
4.8%
v 1
 
4.8%
c 1
 
4.8%
i 1
 
4.8%
p 1
 
4.8%
d 1
 
4.8%
Decimal Number
ValueCountFrequency (%)
1 1
33.3%
0 1
33.3%
5 1
33.3%
Space Separator
ValueCountFrequency (%)
13
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%
Other Punctuation
ValueCountFrequency (%)
. 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 330
81.9%
Latin 40
 
9.9%
Common 33
 
8.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
경 42
 
12.7%
안 41
 
12.4%
원 24
 
7.3%
스 14
 
4.2%
이 14
 
4.2%
점 9
 
2.7%
아 9
 
2.7%
트 7
 
2.1%
오 6
 
1.8%
리 6
 
1.8%
Other values (95) 158
47.9%
Latin
ValueCountFrequency (%)
e 6
15.0%
o 3
 
7.5%
r 3
 
7.5%
A 3
 
7.5%
l 2
 
5.0%
U 2
 
5.0%
B 2
 
5.0%
S 2
 
5.0%
O 2
 
5.0%
a 1
 
2.5%
Other values (14) 14
35.0%
Common
ValueCountFrequency (%)
13
39.4%
( 7
21.2%
) 7
21.2%
. 3
 
9.1%
1 1
 
3.0%
0 1
 
3.0%
5 1
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 330
81.9%
ASCII 73
 
18.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
경 42
 
12.7%
안 41
 
12.4%
원 24
 
7.3%
스 14
 
4.2%
이 14
 
4.2%
점 9
 
2.7%
아 9
 
2.7%
트 7
 
2.1%
오 6
 
1.8%
리 6
 
1.8%
Other values (95) 158
47.9%
ASCII
ValueCountFrequency (%)
13
17.8%
( 7
 
9.6%
) 7
 
9.6%
e 6
 
8.2%
o 3
 
4.1%
. 3
 
4.1%
r 3
 
4.1%
A 3
 
4.1%
l 2
 
2.7%
U 2
 
2.7%
Other values (21) 24
32.9%

사업장소재지(도로명)
Text

Distinct51
Distinct (%)92.7%
Missing0
Missing (%)0.0%
Memory size572.0 B
2023-12-13T07:10:58.726045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length53
Median length37
Mean length28.381818
Min length22

Characters and Unicode

Total characters1561
Distinct characters107
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

Unique48 ?
Unique (%)87.3%

Sample

1st row서울특별시 용산구 독서당로 39, 101호 (한남동, 신성미소시티)
2nd row서울특별시 용산구 이태원로 234, 극동스푸링쿨라(주) 1층 (한남동)
3rd row서울특별시 용산구 서빙고로 17, 용산센트럴파크해링턴스퀘어 1층 33호 (한강로3가)
4th row서울특별시 용산구 백범로 313, 208동 지하3층 110호 (효창동, 용산 롯데캐슬 센터포레)
5th row서울특별시 용산구 청파로47길 42-1 (청파동2가)
ValueCountFrequency (%)
서울특별시 55
 
17.9%
용산구 55
 
17.9%
한강대로 8
 
2.6%
한남동 8
 
2.6%
한강로3가 7
 
2.3%
이태원동 5
 
1.6%
이촌로 5
 
1.6%
이촌동 4
 
1.3%
한강로2가 4
 
1.3%
1층 4
 
1.3%
Other values (110) 152
49.5%
2023-12-13T07:10:59.124696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
252
 
16.1%
로 69
 
4.4%
용 67
 
4.3%
산 66
 
4.2%
서 59
 
3.8%
시 59
 
3.8%
) 56
 
3.6%
( 56
 
3.6%
특 55
 
3.5%
구 55
 
3.5%
Other values (97) 767
49.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 948
60.7%
Space Separator 252
 
16.1%
Decimal Number 220
 
14.1%
Close Punctuation 56
 
3.6%
Open Punctuation 56
 
3.6%
Other Punctuation 20
 
1.3%
Dash Punctuation 8
 
0.5%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 69
 
7.3%
용 67
 
7.1%
산 66
 
7.0%
서 59
 
6.2%
시 59
 
6.2%
특 55
 
5.8%
구 55
 
5.8%
울 55
 
5.8%
별 55
 
5.8%
동 45
 
4.7%
Other values (81) 363
38.3%
Decimal Number
ValueCountFrequency (%)
1 41
18.6%
2 35
15.9%
3 34
15.5%
5 27
12.3%
7 19
8.6%
4 19
8.6%
0 17
7.7%
9 12
 
5.5%
8 11
 
5.0%
6 5
 
2.3%
Space Separator
ValueCountFrequency (%)
252
100.0%
Close Punctuation
ValueCountFrequency (%)
) 56
100.0%
Open Punctuation
ValueCountFrequency (%)
( 56
100.0%
Other Punctuation
ValueCountFrequency (%)
, 20
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 948
60.7%
Common 612
39.2%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 69
 
7.3%
용 67
 
7.1%
산 66
 
7.0%
서 59
 
6.2%
시 59
 
6.2%
특 55
 
5.8%
구 55
 
5.8%
울 55
 
5.8%
별 55
 
5.8%
동 45
 
4.7%
Other values (81) 363
38.3%
Common
ValueCountFrequency (%)
252
41.2%
) 56
 
9.2%
( 56
 
9.2%
1 41
 
6.7%
2 35
 
5.7%
3 34
 
5.6%
5 27
 
4.4%
, 20
 
3.3%
7 19
 
3.1%
4 19
 
3.1%
Other values (5) 53
 
8.7%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 948
60.7%
ASCII 613
39.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
252
41.1%
) 56
 
9.1%
( 56
 
9.1%
1 41
 
6.7%
2 35
 
5.7%
3 34
 
5.5%
5 27
 
4.4%
, 20
 
3.3%
7 19
 
3.1%
4 19
 
3.1%
Other values (6) 54
 
8.8%
Hangul
ValueCountFrequency (%)
로 69
 
7.3%
용 67
 
7.1%
산 66
 
7.0%
서 59
 
6.2%
시 59
 
6.2%
특 55
 
5.8%
구 55
 
5.8%
울 55
 
5.8%
별 55
 
5.8%
동 45
 
4.7%
Other values (81) 363
38.3%

전화번호
Text

MISSING 

Distinct38
Distinct (%)100.0%
Missing17
Missing (%)30.9%
Memory size572.0 B
2023-12-13T07:10:59.388442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length10.973684
Min length8

Characters and Unicode

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

Unique38 ?
Unique (%)100.0%

Sample

1st row02-6953-4371
2nd row02-790-5677
3rd row02-6052-1533
4th row02-704-0326
5th row02-797-9339
ValueCountFrequency (%)
02-704-8587 1
 
2.6%
02-2012-1266 1
 
2.6%
02-717-2181 1
 
2.6%
02-795-2086 1
 
2.6%
02-796-5934 1
 
2.6%
02-3443-1015 1
 
2.6%
02-3273-6368 1
 
2.6%
02-796-6006 1
 
2.6%
02-790-7884 1
 
2.6%
02-797-2030 1
 
2.6%
Other values (28) 28
73.7%
2023-12-13T07:10:59.766739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 71
17.0%
0 69
16.5%
2 60
14.4%
7 53
12.7%
9 30
7.2%
1 27
 
6.5%
3 26
 
6.2%
4 23
 
5.5%
8 21
 
5.0%
6 21
 
5.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 346
83.0%
Dash Punctuation 71
 
17.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 69
19.9%
2 60
17.3%
7 53
15.3%
9 30
8.7%
1 27
 
7.8%
3 26
 
7.5%
4 23
 
6.6%
8 21
 
6.1%
6 21
 
6.1%
5 16
 
4.6%
Dash Punctuation
ValueCountFrequency (%)
- 71
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 417
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 71
17.0%
0 69
16.5%
2 60
14.4%
7 53
12.7%
9 30
7.2%
1 27
 
6.5%
3 26
 
6.2%
4 23
 
5.5%
8 21
 
5.0%
6 21
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 417
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 71
17.0%
0 69
16.5%
2 60
14.4%
7 53
12.7%
9 30
7.2%
1 27
 
6.5%
3 26
 
6.2%
4 23
 
5.5%
8 21
 
5.0%
6 21
 
5.0%

Correlations

2023-12-13T07:10:59.894939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
안경업소명칭사업장소재지(도로명)전화번호
안경업소명칭1.0001.0001.000
사업장소재지(도로명)1.0001.0001.000
전화번호1.0001.0001.000

Missing values

2023-12-13T07:10:57.510722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:10:57.581265image/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오호안경원서울특별시 용산구 독서당로 39, 101호 (한남동, 신성미소시티)<NA>
1윤서울 한남점서울특별시 용산구 이태원로 234, 극동스푸링쿨라(주) 1층 (한남동)02-6953-4371
2갤러리원 안경원서울특별시 용산구 서빙고로 17, 용산센트럴파크해링턴스퀘어 1층 33호 (한강로3가)02-790-5677
3부부아이웨어서울특별시 용산구 백범로 313, 208동 지하3층 110호 (효창동, 용산 롯데캐슬 센터포레)02-6052-1533
4마리안경서울특별시 용산구 청파로47길 42-1 (청파동2가)02-704-0326
5열린안경마트서울특별시 용산구 보광로 17 (보광동)02-797-9339
6오렌즈 용산아이파크몰점서울특별시 용산구 한강대로23길 55, 용산역 4층 (한강로3가)02-2012-4420
7ALO안경 용산아이파크몰점서울특별시 용산구 한강대로23길 55, 용산역 (한강로3가)02-2012-4633
8경희안경원서울특별시 용산구 이태원로 22 (용산동3가)<NA>
9뉴에덴안경서울특별시 용산구 한강대로 277, 1층 (갈월동)<NA>
안경업소명칭사업장소재지(도로명)전화번호
45엘리트안경원서울특별시 용산구 효창원로 104 (용문동)02-703-3415
46뉴한양안경서울특별시 용산구 보광로21길 3 (보광동)02-794-4858
47이석환안경원서울특별시 용산구 후암로 50 (후암동)02-752-4519
48일공공일안경콘택트서울특별시 용산구 대사관로 72 (한남동)02-792-8370
49신동아안경원서울특별시 용산구 이촌로 352 (용산동6가)02-793-0161
50뉴이태리안경서울특별시 용산구 이태원로 152-1 (이태원동)02-795-4888
51선샤인안경원서울특별시 용산구 한강대로 92 (한강로2가)02-794-5927
52성원안경원서울특별시 용산구 한강대로77길 4-1 (갈월동)02-714-7953
53불란서안경원서울특별시 용산구 이촌로 280 (이촌동)<NA>
54박안경서울특별시 용산구 한강대로 288-1 (남영동)02-797-6967