Overview

Dataset statistics

Number of variables4
Number of observations235
Missing cells9
Missing cells (%)1.0%
Duplicate rows6
Duplicate rows (%)2.6%
Total size in memory7.5 KiB
Average record size in memory32.6 B

Variable types

Text3
Categorical1

Dataset

Description서울특별시 관악구 약국업소현황(약국명, 소새지도로명 주소, 약국업소전화번호) 약사가 의약품을 조제 또는 판매를 주목적으로 하는 업소정보
URLhttps://www.data.go.kr/data/15048011/fileData.do

Alerts

데이터기준일 has constant value ""Constant
Dataset has 6 (2.6%) duplicate rowsDuplicates
전화번호 has 9 (3.8%) missing valuesMissing

Reproduction

Analysis started2023-12-12 07:57:59.496062
Analysis finished2023-12-12 07:57:59.883939
Duration0.39 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약국명
Text

Distinct229
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2023-12-12T16:58:00.140713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length9
Mean length5.187234
Min length3

Characters and Unicode

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

Unique

Unique223 ?
Unique (%)94.9%

Sample

1st row뿌리약국
2nd row해솔약국
3rd row구로행복약국
4th row조아약국
5th row샤로수약국
ValueCountFrequency (%)
라온온누리약국 2
 
0.8%
늘픔약국 2
 
0.8%
참조은약국 2
 
0.8%
왕약국 2
 
0.8%
약국 2
 
0.8%
호호약국 2
 
0.8%
고은약국 2
 
0.8%
녹원약국 1
 
0.4%
관악소망약국 1
 
0.4%
신지약국 1
 
0.4%
Other values (225) 225
93.0%
2023-12-12T16:58:00.682484image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 236
 
19.4%
국 236
 
19.4%
리 31
 
2.5%
온 28
 
2.3%
누 26
 
2.1%
한 16
 
1.3%
성 16
 
1.3%
이 13
 
1.1%
은 12
 
1.0%
라 11
 
0.9%
Other values (191) 594
48.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1196
98.1%
Decimal Number 15
 
1.2%
Space Separator 7
 
0.6%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 236
19.7%
국 236
19.7%
리 31
 
2.6%
온 28
 
2.3%
누 26
 
2.2%
한 16
 
1.3%
성 16
 
1.3%
이 13
 
1.1%
은 12
 
1.0%
라 11
 
0.9%
Other values (183) 571
47.7%
Decimal Number
ValueCountFrequency (%)
6 3
20.0%
5 3
20.0%
1 3
20.0%
2 2
13.3%
3 2
13.3%
4 2
13.3%
Space Separator
ValueCountFrequency (%)
7
100.0%
Uppercase Letter
ValueCountFrequency (%)
M 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1196
98.1%
Common 22
 
1.8%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 236
19.7%
국 236
19.7%
리 31
 
2.6%
온 28
 
2.3%
누 26
 
2.2%
한 16
 
1.3%
성 16
 
1.3%
이 13
 
1.1%
은 12
 
1.0%
라 11
 
0.9%
Other values (183) 571
47.7%
Common
ValueCountFrequency (%)
7
31.8%
6 3
13.6%
5 3
13.6%
1 3
13.6%
2 2
 
9.1%
3 2
 
9.1%
4 2
 
9.1%
Latin
ValueCountFrequency (%)
M 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1196
98.1%
ASCII 23
 
1.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 236
19.7%
국 236
19.7%
리 31
 
2.6%
온 28
 
2.3%
누 26
 
2.2%
한 16
 
1.3%
성 16
 
1.3%
이 13
 
1.1%
은 12
 
1.0%
라 11
 
0.9%
Other values (183) 571
47.7%
ASCII
ValueCountFrequency (%)
7
30.4%
6 3
13.0%
5 3
13.0%
1 3
13.0%
2 2
 
8.7%
3 2
 
8.7%
4 2
 
8.7%
M 1
 
4.3%

소재지도로명주소
Text

Distinct228
Distinct (%)97.0%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2023-12-12T16:58:00.932341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length41
Mean length29.165957
Min length21

Characters and Unicode

Total characters6854
Distinct characters168
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

Unique222 ?
Unique (%)94.5%

Sample

1st row서울특별시 관악구 난우길 14+ 1층 (신림동)
2nd row서울특별시 관악구 남부순환로 1733(봉천동)
3rd row서울특별시 관악구 조원로 20+ 101호 (신림동)
4th row서울특별시 관악구 봉천로 216+ 1층 (신림동)
5th row서울특별시 관악구 관악로 164+ 1층 110호 (봉천동+ 대우디오슈페리움1단지)
ValueCountFrequency (%)
서울특별시 235
16.7%
관악구 235
16.7%
신림동 115
 
8.2%
봉천동 108
 
7.7%
1층 104
 
7.4%
남부순환로 51
 
3.6%
신림로 27
 
1.9%
난곡로 26
 
1.8%
관악로 21
 
1.5%
봉천로 11
 
0.8%
Other values (350) 476
33.8%
2023-12-12T16:58:01.354112image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1174
 
17.1%
1 323
 
4.7%
관 271
 
4.0%
악 270
 
3.9%
동 241
 
3.5%
시 239
 
3.5%
서 237
 
3.5%
구 237
 
3.5%
울 236
 
3.4%
별 235
 
3.4%
Other values (158) 3391
49.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4022
58.7%
Space Separator 1174
 
17.1%
Decimal Number 978
 
14.3%
Close Punctuation 235
 
3.4%
Open Punctuation 235
 
3.4%
Math Symbol 195
 
2.8%
Dash Punctuation 10
 
0.1%
Uppercase Letter 5
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
관 271
 
6.7%
악 270
 
6.7%
동 241
 
6.0%
시 239
 
5.9%
서 237
 
5.9%
구 237
 
5.9%
울 236
 
5.9%
별 235
 
5.8%
특 235
 
5.8%
로 204
 
5.1%
Other values (140) 1617
40.2%
Decimal Number
ValueCountFrequency (%)
1 323
33.0%
2 120
 
12.3%
0 91
 
9.3%
3 89
 
9.1%
5 76
 
7.8%
6 65
 
6.6%
4 62
 
6.3%
8 52
 
5.3%
9 52
 
5.3%
7 48
 
4.9%
Uppercase Letter
ValueCountFrequency (%)
S 2
40.0%
K 2
40.0%
A 1
20.0%
Space Separator
ValueCountFrequency (%)
1174
100.0%
Close Punctuation
ValueCountFrequency (%)
) 235
100.0%
Open Punctuation
ValueCountFrequency (%)
( 235
100.0%
Math Symbol
ValueCountFrequency (%)
+ 195
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4022
58.7%
Common 2827
41.2%
Latin 5
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
관 271
 
6.7%
악 270
 
6.7%
동 241
 
6.0%
시 239
 
5.9%
서 237
 
5.9%
구 237
 
5.9%
울 236
 
5.9%
별 235
 
5.8%
특 235
 
5.8%
로 204
 
5.1%
Other values (140) 1617
40.2%
Common
ValueCountFrequency (%)
1174
41.5%
1 323
 
11.4%
) 235
 
8.3%
( 235
 
8.3%
+ 195
 
6.9%
2 120
 
4.2%
0 91
 
3.2%
3 89
 
3.1%
5 76
 
2.7%
6 65
 
2.3%
Other values (5) 224
 
7.9%
Latin
ValueCountFrequency (%)
S 2
40.0%
K 2
40.0%
A 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4022
58.7%
ASCII 2832
41.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1174
41.5%
1 323
 
11.4%
) 235
 
8.3%
( 235
 
8.3%
+ 195
 
6.9%
2 120
 
4.2%
0 91
 
3.2%
3 89
 
3.1%
5 76
 
2.7%
6 65
 
2.3%
Other values (8) 229
 
8.1%
Hangul
ValueCountFrequency (%)
관 271
 
6.7%
악 270
 
6.7%
동 241
 
6.0%
시 239
 
5.9%
서 237
 
5.9%
구 237
 
5.9%
울 236
 
5.9%
별 235
 
5.8%
특 235
 
5.8%
로 204
 
5.1%
Other values (140) 1617
40.2%

전화번호
Text

MISSING 

Distinct220
Distinct (%)97.3%
Missing9
Missing (%)3.8%
Memory size2.0 KiB
2023-12-12T16:58:01.719973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length11
Mean length11.110619
Min length11

Characters and Unicode

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

Unique214 ?
Unique (%)94.7%

Sample

1st row02-864-2395
2nd row02-2625-0026
3rd row02-868-1653
4th row02-6267-4002
5th row02-877-4559
ValueCountFrequency (%)
02-877-6995 2
 
0.9%
02-877-1333 2
 
0.9%
02-889-8876 2
 
0.9%
02-872-8722 2
 
0.9%
02-888-7888 2
 
0.9%
02-882-2633 2
 
0.9%
02-871-8432 1
 
0.4%
070-4607-5784 1
 
0.4%
02-876-3304 1
 
0.4%
02-875-1711 1
 
0.4%
Other values (210) 210
92.9%
2023-12-12T16:58:02.206892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 452
18.0%
8 422
16.8%
2 360
14.3%
0 351
14.0%
7 222
8.8%
5 180
 
7.2%
3 118
 
4.7%
6 117
 
4.7%
9 111
 
4.4%
4 94
 
3.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2059
82.0%
Dash Punctuation 452
 
18.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
8 422
20.5%
2 360
17.5%
0 351
17.0%
7 222
10.8%
5 180
8.7%
3 118
 
5.7%
6 117
 
5.7%
9 111
 
5.4%
4 94
 
4.6%
1 84
 
4.1%
Dash Punctuation
ValueCountFrequency (%)
- 452
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2511
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 452
18.0%
8 422
16.8%
2 360
14.3%
0 351
14.0%
7 222
8.8%
5 180
 
7.2%
3 118
 
4.7%
6 117
 
4.7%
9 111
 
4.4%
4 94
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2511
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 452
18.0%
8 422
16.8%
2 360
14.3%
0 351
14.0%
7 222
8.8%
5 180
 
7.2%
3 118
 
4.7%
6 117
 
4.7%
9 111
 
4.4%
4 94
 
3.7%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2023-07-31
235 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-07-31
2nd row2023-07-31
3rd row2023-07-31
4th row2023-07-31
5th row2023-07-31

Common Values

ValueCountFrequency (%)
2023-07-31 235
100.0%

Length

2023-12-12T16:58:02.367657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:58:02.476712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-07-31 235
100.0%

Missing values

2023-12-12T16:57:59.752469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:57:59.840457image/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뿌리약국서울특별시 관악구 난우길 14+ 1층 (신림동)02-864-23952023-07-31
1해솔약국서울특별시 관악구 남부순환로 1733(봉천동)02-2625-00262023-07-31
2구로행복약국서울특별시 관악구 조원로 20+ 101호 (신림동)02-868-16532023-07-31
3조아약국서울특별시 관악구 봉천로 216+ 1층 (신림동)02-6267-40022023-07-31
4샤로수약국서울특별시 관악구 관악로 164+ 1층 110호 (봉천동+ 대우디오슈페리움1단지)02-877-45592023-07-31
5육당약국서울특별시 관악구 난우길 10+ 101호+102호 (신림동)<NA>2023-07-31
6스마일약국서울특별시 관악구 중앙길 5+ 1층 (봉천동)<NA>2023-07-31
7새로이약국서울특별시 관악구 난곡로 197+ 남강빌딩 지1층 (신림동)<NA>2023-07-31
8명진팜약국서울특별시 관악구 남부순환로 2064+ 102호 (남현동)<NA>2023-07-31
9삼성웰약국서울특별시 관악구 남부순환로 1932+ 1층 (봉천동)<NA>2023-07-31
약국명소재지도로명주소전화번호데이터기준일
225온누리대산약국서울특별시 관악구 시흥대로 560+ 1층 (신림동)02-853-49672023-07-31
226태창온누리약국서울특별시 관악구 쑥고개로 126-1 (봉천동)02-878-99052023-07-31
227건강약국서울특별시 관악구 남부순환로 1539 (신림동)02-855-28832023-07-31
228삼성약국서울특별시 관악구 신원로 21 (신림동)02-855-41582023-07-31
229한국생약국서울특별시 관악구 쑥고개로 71 (봉천동)02-878-27432023-07-31
230대학당약국서울특별시 관악구 원신길 2-1 (신림동)02-878-74972023-07-31
231새시민약국서울특별시 관악구 난우길 4 (신림동)02-856-42722023-07-31
232대성약국서울특별시 관악구 청림길 8 (봉천동)02-877-30242023-07-31
233제정약국서울특별시 관악구 신림로 383+ 1층 (신림동)02-878-43602023-07-31
234인제약국서울특별시 관악구 원신2길 17+ 인제약국 (신림동)02-877-85972023-07-31

Duplicate rows

Most frequently occurring

약국명소재지도로명주소전화번호데이터기준일# duplicates
0고은약국서울특별시 관악구 신림로 339+ 1층 (신림동)02-888-78882023-07-312
1늘픔약국서울특별시 관악구 남부순환로 1635+ 1층 (신림동)02-877-69952023-07-312
2라온온누리약국서울특별시 관악구 신림로 344+ SK허브그린 107+108호 (신림동)02-889-88762023-07-312
3왕약국서울특별시 관악구 대학5길 17 (신림동)02-877-13332023-07-312
4참조은약국서울특별시 관악구 남부순환로 1814+ 대연빌딩 1층 (봉천동)02-872-87222023-07-312
5호호약국서울특별시 관악구 남부순환로 1595+ 1층 (신림동)02-882-26332023-07-312