Overview

Dataset statistics

Number of variables3
Number of observations152
Missing cells1
Missing cells (%)0.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.7 KiB
Average record size in memory24.9 B

Variable types

Text3

Dataset

Description서울특별시 성동구에 위치한 약국에 대한 현황 정보입니다. 약국 이름, 전화번호, 도로명 주소 등의 정보를 포함하고 있습니다.
URLhttps://www.data.go.kr/data/15072701/fileData.do

Alerts

약국명칭 has unique valuesUnique
도로명주소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 10:02:29.222489
Analysis finished2023-12-12 10:02:29.575104
Duration0.35 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약국명칭
Text

UNIQUE 

Distinct152
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-12T19:02:29.789195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length4
Mean length4.9210526
Min length3

Characters and Unicode

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

Unique

Unique152 ?
Unique (%)100.0%

Sample

1st row다나을약국
2nd row보명약국
3rd row진로약국
4th row실로암약국
5th row옥수벽산약국
ValueCountFrequency (%)
다나을약국 1
 
0.7%
한진약국 1
 
0.7%
혜민약국 1
 
0.7%
신금호약국 1
 
0.7%
정문약국 1
 
0.7%
우인약국 1
 
0.7%
성수종로약국 1
 
0.7%
정은약국 1
 
0.7%
어울림온누리약국 1
 
0.7%
신수정약국 1
 
0.7%
Other values (142) 142
93.4%
2023-12-12T19:02:30.380281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
국 154
20.6%
약 153
20.5%
한 14
 
1.9%
리 14
 
1.9%
이 12
 
1.6%
수 12
 
1.6%
성 11
 
1.5%
메 9
 
1.2%
신 9
 
1.2%
대 9
 
1.2%
Other values (155) 351
46.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 745
99.6%
Decimal Number 3
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
국 154
20.7%
약 153
20.5%
한 14
 
1.9%
리 14
 
1.9%
이 12
 
1.6%
수 12
 
1.6%
성 11
 
1.5%
메 9
 
1.2%
신 9
 
1.2%
대 9
 
1.2%
Other values (153) 348
46.7%
Decimal Number
ValueCountFrequency (%)
1 2
66.7%
2 1
33.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 745
99.6%
Common 3
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
국 154
20.7%
약 153
20.5%
한 14
 
1.9%
리 14
 
1.9%
이 12
 
1.6%
수 12
 
1.6%
성 11
 
1.5%
메 9
 
1.2%
신 9
 
1.2%
대 9
 
1.2%
Other values (153) 348
46.7%
Common
ValueCountFrequency (%)
1 2
66.7%
2 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 745
99.6%
ASCII 3
 
0.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
국 154
20.7%
약 153
20.5%
한 14
 
1.9%
리 14
 
1.9%
이 12
 
1.6%
수 12
 
1.6%
성 11
 
1.5%
메 9
 
1.2%
신 9
 
1.2%
대 9
 
1.2%
Other values (153) 348
46.7%
ASCII
ValueCountFrequency (%)
1 2
66.7%
2 1
33.3%

전화번호
Text

Distinct151
Distinct (%)100.0%
Missing1
Missing (%)0.7%
Memory size1.3 KiB
2023-12-12T19:02:30.672524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.807947
Min length11

Characters and Unicode

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

Unique151 ?
Unique (%)100.0%

Sample

1st row02-2231-1703
2nd row02-2282-6236
3rd row02-469-0401
4th row02-2216-5360
5th row02-2299-9337
ValueCountFrequency (%)
02-2231-1703 1
 
0.7%
02-6015-2500 1
 
0.7%
02-2293-2729 1
 
0.7%
02-2282-5230 1
 
0.7%
02-2295-4825 1
 
0.7%
02-2297-1556 1
 
0.7%
02-469-4928 1
 
0.7%
02-2293-3961 1
 
0.7%
02-3395-8777 1
 
0.7%
02-3395-5368 1
 
0.7%
Other values (141) 141
93.4%
2023-12-12T19:02:31.131824image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 456
25.6%
- 302
16.9%
0 233
13.1%
9 136
 
7.6%
4 114
 
6.4%
5 102
 
5.7%
6 97
 
5.4%
8 92
 
5.2%
7 87
 
4.9%
1 84
 
4.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1481
83.1%
Dash Punctuation 302
 
16.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 456
30.8%
0 233
15.7%
9 136
 
9.2%
4 114
 
7.7%
5 102
 
6.9%
6 97
 
6.5%
8 92
 
6.2%
7 87
 
5.9%
1 84
 
5.7%
3 80
 
5.4%
Dash Punctuation
ValueCountFrequency (%)
- 302
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1783
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 456
25.6%
- 302
16.9%
0 233
13.1%
9 136
 
7.6%
4 114
 
6.4%
5 102
 
5.7%
6 97
 
5.4%
8 92
 
5.2%
7 87
 
4.9%
1 84
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1783
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 456
25.6%
- 302
16.9%
0 233
13.1%
9 136
 
7.6%
4 114
 
6.4%
5 102
 
5.7%
6 97
 
5.4%
8 92
 
5.2%
7 87
 
4.9%
1 84
 
4.7%

도로명주소
Text

UNIQUE 

Distinct152
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-12T19:02:31.420545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length54
Median length44.5
Mean length31.289474
Min length21

Characters and Unicode

Total characters4756
Distinct characters162
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

Unique152 ?
Unique (%)100.0%

Sample

1st row서울특별시 성동구 장터1길 2 (금호동3가)
2nd row서울특별시 성동구 독서당로 280-7 (금호동4가)
3rd row서울특별시 성동구 성덕정길 106, 1층 (성수동2가)
4th row서울특별시 성동구 용답중앙15길 11 (용답동)
5th row서울특별시 성동구 한림말길 56, 1층 (옥수동, 벽산빌라트)
ValueCountFrequency (%)
서울특별시 152
 
16.4%
성동구 152
 
16.4%
1층 40
 
4.3%
왕십리로 26
 
2.8%
행당동 25
 
2.7%
성수동2가 18
 
1.9%
하왕십리동 17
 
1.8%
독서당로 15
 
1.6%
2층 10
 
1.1%
옥수동 9
 
1.0%
Other values (286) 461
49.8%
2023-12-12T19:02:32.007718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
773
 
16.3%
동 330
 
6.9%
성 204
 
4.3%
1 198
 
4.2%
서 170
 
3.6%
울 155
 
3.3%
( 154
 
3.2%
) 154
 
3.2%
시 153
 
3.2%
특 152
 
3.2%
Other values (152) 2313
48.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2796
58.8%
Space Separator 773
 
16.3%
Decimal Number 705
 
14.8%
Open Punctuation 154
 
3.2%
Close Punctuation 154
 
3.2%
Other Punctuation 132
 
2.8%
Dash Punctuation 28
 
0.6%
Uppercase Letter 14
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 330
 
11.8%
성 204
 
7.3%
서 170
 
6.1%
울 155
 
5.5%
시 153
 
5.5%
특 152
 
5.4%
별 152
 
5.4%
구 152
 
5.4%
로 115
 
4.1%
호 81
 
2.9%
Other values (130) 1132
40.5%
Decimal Number
ValueCountFrequency (%)
1 198
28.1%
2 128
18.2%
3 98
13.9%
0 76
 
10.8%
4 51
 
7.2%
7 34
 
4.8%
5 33
 
4.7%
9 32
 
4.5%
8 29
 
4.1%
6 26
 
3.7%
Uppercase Letter
ValueCountFrequency (%)
L 6
42.9%
A 2
 
14.3%
B 2
 
14.3%
V 1
 
7.1%
D 1
 
7.1%
O 1
 
7.1%
G 1
 
7.1%
Space Separator
ValueCountFrequency (%)
773
100.0%
Open Punctuation
ValueCountFrequency (%)
( 154
100.0%
Close Punctuation
ValueCountFrequency (%)
) 154
100.0%
Other Punctuation
ValueCountFrequency (%)
, 132
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 28
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2796
58.8%
Common 1946
40.9%
Latin 14
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 330
 
11.8%
성 204
 
7.3%
서 170
 
6.1%
울 155
 
5.5%
시 153
 
5.5%
특 152
 
5.4%
별 152
 
5.4%
구 152
 
5.4%
로 115
 
4.1%
호 81
 
2.9%
Other values (130) 1132
40.5%
Common
ValueCountFrequency (%)
773
39.7%
1 198
 
10.2%
( 154
 
7.9%
) 154
 
7.9%
, 132
 
6.8%
2 128
 
6.6%
3 98
 
5.0%
0 76
 
3.9%
4 51
 
2.6%
7 34
 
1.7%
Other values (5) 148
 
7.6%
Latin
ValueCountFrequency (%)
L 6
42.9%
A 2
 
14.3%
B 2
 
14.3%
V 1
 
7.1%
D 1
 
7.1%
O 1
 
7.1%
G 1
 
7.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2796
58.8%
ASCII 1960
41.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
773
39.4%
1 198
 
10.1%
( 154
 
7.9%
) 154
 
7.9%
, 132
 
6.7%
2 128
 
6.5%
3 98
 
5.0%
0 76
 
3.9%
4 51
 
2.6%
7 34
 
1.7%
Other values (12) 162
 
8.3%
Hangul
ValueCountFrequency (%)
동 330
 
11.8%
성 204
 
7.3%
서 170
 
6.1%
울 155
 
5.5%
시 153
 
5.5%
특 152
 
5.4%
별 152
 
5.4%
구 152
 
5.4%
로 115
 
4.1%
호 81
 
2.9%
Other values (130) 1132
40.5%

Missing values

2023-12-12T19:02:29.446384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:02:29.541219image/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다나을약국02-2231-1703서울특별시 성동구 장터1길 2 (금호동3가)
1보명약국02-2282-6236서울특별시 성동구 독서당로 280-7 (금호동4가)
2진로약국02-469-0401서울특별시 성동구 성덕정길 106, 1층 (성수동2가)
3실로암약국02-2216-5360서울특별시 성동구 용답중앙15길 11 (용답동)
4옥수벽산약국02-2299-9337서울특별시 성동구 한림말길 56, 1층 (옥수동, 벽산빌라트)
5지안약국02-2200-1577서울특별시 성동구 왕십리광장로 17, 왕십리민자역사 4층 OV3-1호 (행당동)
6성수햇살약국02-463-5657서울특별시 성동구 아차산로 120, 베델 플레이스 3층 302호 (성수동2가)
7유연약국02-2297-9733서울특별시 성동구 왕십리로 410, 상가 L동 3층 318호 (하왕십리동, 센트라스)
8유명한약국02-2237-5875서울특별시 성동구 독서당로 295, 1층 (금호동3가)
9허브약국02-2297-0999서울특별시 성동구 금호로 158-2, 지1층 (금호동1가)
약국명칭전화번호도로명주소
142자연온누리약국02-464-0649서울특별시 성동구 뚝섬로 400(성수동2가)
143하이온누리약국02-2297-5408서울특별시 성동구 행당로 87, 107호 (행당동, 행당동 대림아파트)
144신성림약국02-2292-3015서울특별시 성동구 마조로 24(행당동)
145화생약국02-2293-4858서울특별시 성동구 행당로 1, 103호 (금호동1가)
146비타민약국02-2299-3226서울특별시 성동구 고산자로 253, 401호 (도선동)
147비트플렉스약국02-2200-1549서울특별시 성동구 왕십리광장로 17 (행당동, 비트플랙스내 2층 A05,06)
148바른약국02-2281-3200서울특별시 성동구 왕십리로 410, G동 204호 (하왕십리동, 센트라스)
149신세계약국0504-258-8457서울특별시 성동구 성덕정길 127, 1층 (성수동2가)
150성수약국<NA>서울특별시 성동구 아차산로 116, 1층 (성수동2가)
1511층이화약국070-7798-1281서울특별시 성동구 왕십리로 410, L동 128-1호 (하왕십리동, 센트라스)