Overview

Dataset statistics

Number of variables2
Number of observations183
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.0 KiB
Average record size in memory16.7 B

Variable types

Text2

Dataset

Description폐의약품 수거 참여 약국 현황입니다.
Author서울특별시 송파구
URLhttps://www.data.go.kr/data/15077652/fileData.do

Alerts

약국명칭 has unique valuesUnique
약국소재지(도로명) has unique valuesUnique

Reproduction

Analysis started2023-12-12 07:21:18.379425
Analysis finished2023-12-12 07:21:18.724582
Duration0.35 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약국명칭
Text

UNIQUE 

Distinct183
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-12-12T16:21:18.987695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length10
Mean length5.3333333
Min length3

Characters and Unicode

Total characters976
Distinct characters196
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

Unique183 ?
Unique (%)100.0%

Sample

1st row3층메디칼약국
2nd row3층하나약국
3rd row가까운이화약국
4th row가든파이브약국
5th row가락온누리약국
ValueCountFrequency (%)
3층메디칼약국 1
 
0.5%
왕약국 1
 
0.5%
오층조은약국 1
 
0.5%
온누리건강약국 1
 
0.5%
온누리대웅약국 1
 
0.5%
온누리배명약국 1
 
0.5%
온누리봄빛약국 1
 
0.5%
온누리엄마손약국 1
 
0.5%
온누리옥산약국 1
 
0.5%
올리브약국 1
 
0.5%
Other values (175) 175
94.6%
2023-12-12T16:21:19.518499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 183
 
18.8%
국 183
 
18.8%
리 33
 
3.4%
누 20
 
2.0%
온 19
 
1.9%
파 13
 
1.3%
이 11
 
1.1%
새 11
 
1.1%
송 10
 
1.0%
라 9
 
0.9%
Other values (186) 484
49.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 967
99.1%
Decimal Number 6
 
0.6%
Space Separator 2
 
0.2%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 183
 
18.9%
국 183
 
18.9%
리 33
 
3.4%
누 20
 
2.1%
온 19
 
2.0%
파 13
 
1.3%
이 11
 
1.1%
새 11
 
1.1%
송 10
 
1.0%
라 9
 
0.9%
Other values (181) 475
49.1%
Decimal Number
ValueCountFrequency (%)
3 3
50.0%
0 2
33.3%
1 1
 
16.7%
Space Separator
ValueCountFrequency (%)
2
100.0%
Uppercase Letter
ValueCountFrequency (%)
M 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 967
99.1%
Common 8
 
0.8%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 183
 
18.9%
국 183
 
18.9%
리 33
 
3.4%
누 20
 
2.1%
온 19
 
2.0%
파 13
 
1.3%
이 11
 
1.1%
새 11
 
1.1%
송 10
 
1.0%
라 9
 
0.9%
Other values (181) 475
49.1%
Common
ValueCountFrequency (%)
3 3
37.5%
2
25.0%
0 2
25.0%
1 1
 
12.5%
Latin
ValueCountFrequency (%)
M 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 967
99.1%
ASCII 9
 
0.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 183
 
18.9%
국 183
 
18.9%
리 33
 
3.4%
누 20
 
2.1%
온 19
 
2.0%
파 13
 
1.3%
이 11
 
1.1%
새 11
 
1.1%
송 10
 
1.0%
라 9
 
0.9%
Other values (181) 475
49.1%
ASCII
ValueCountFrequency (%)
3 3
33.3%
2
22.2%
0 2
22.2%
1 1
 
11.1%
M 1
 
11.1%

약국소재지(도로명)
Text

UNIQUE 

Distinct183
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-12-12T16:21:19.873690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length56
Median length44
Mean length32.120219
Min length22

Characters and Unicode

Total characters5878
Distinct characters180
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

Unique183 ?
Unique (%)100.0%

Sample

1st row서울특별시 송파구 양재대로 1222, 올림픽프라자 23-1,23호 (방이동)
2nd row서울특별시 송파구 올림픽로35길 112 (신천동, 장미B상가 315호)
3rd row서울특별시 송파구 강동대로 74, 잠실올림픽아이파크상가 1층 108호, 지층 B103호 (풍납동)
4th row서울특별시 송파구 충민로 66, 1층 F-1001호 (문정동, 가든파이브라이프 1층, F-1001호)
5th row서울특별시 송파구 동남로 207 (가락동)
ValueCountFrequency (%)
서울특별시 183
 
15.5%
송파구 183
 
15.5%
1층 55
 
4.7%
방이동 22
 
1.9%
가락동 20
 
1.7%
풍납동 19
 
1.6%
마천동 18
 
1.5%
송파대로 18
 
1.5%
문정동 17
 
1.4%
백제고분로 16
 
1.4%
Other values (342) 627
53.2%
2023-12-12T16:21:20.449072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
995
 
16.9%
1 247
 
4.2%
파 240
 
4.1%
동 229
 
3.9%
송 224
 
3.8%
시 188
 
3.2%
구 185
 
3.1%
서 184
 
3.1%
( 184
 
3.1%
) 184
 
3.1%
Other values (170) 3018
51.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3414
58.1%
Space Separator 995
 
16.9%
Decimal Number 884
 
15.0%
Open Punctuation 184
 
3.1%
Close Punctuation 184
 
3.1%
Other Punctuation 174
 
3.0%
Uppercase Letter 26
 
0.4%
Dash Punctuation 17
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
파 240
 
7.0%
동 229
 
6.7%
송 224
 
6.6%
시 188
 
5.5%
구 185
 
5.4%
서 184
 
5.4%
별 183
 
5.4%
울 183
 
5.4%
특 183
 
5.4%
로 181
 
5.3%
Other values (148) 1434
42.0%
Decimal Number
ValueCountFrequency (%)
1 247
27.9%
2 142
16.1%
0 100
11.3%
3 91
 
10.3%
4 80
 
9.0%
5 66
 
7.5%
7 51
 
5.8%
6 46
 
5.2%
8 39
 
4.4%
9 22
 
2.5%
Uppercase Letter
ValueCountFrequency (%)
A 11
42.3%
B 7
26.9%
C 2
 
7.7%
J 2
 
7.7%
F 2
 
7.7%
K 1
 
3.8%
N 1
 
3.8%
Space Separator
ValueCountFrequency (%)
995
100.0%
Open Punctuation
ValueCountFrequency (%)
( 184
100.0%
Close Punctuation
ValueCountFrequency (%)
) 184
100.0%
Other Punctuation
ValueCountFrequency (%)
, 174
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3414
58.1%
Common 2438
41.5%
Latin 26
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
파 240
 
7.0%
동 229
 
6.7%
송 224
 
6.6%
시 188
 
5.5%
구 185
 
5.4%
서 184
 
5.4%
별 183
 
5.4%
울 183
 
5.4%
특 183
 
5.4%
로 181
 
5.3%
Other values (148) 1434
42.0%
Common
ValueCountFrequency (%)
995
40.8%
1 247
 
10.1%
( 184
 
7.5%
) 184
 
7.5%
, 174
 
7.1%
2 142
 
5.8%
0 100
 
4.1%
3 91
 
3.7%
4 80
 
3.3%
5 66
 
2.7%
Other values (5) 175
 
7.2%
Latin
ValueCountFrequency (%)
A 11
42.3%
B 7
26.9%
C 2
 
7.7%
J 2
 
7.7%
F 2
 
7.7%
K 1
 
3.8%
N 1
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3414
58.1%
ASCII 2464
41.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
995
40.4%
1 247
 
10.0%
( 184
 
7.5%
) 184
 
7.5%
, 174
 
7.1%
2 142
 
5.8%
0 100
 
4.1%
3 91
 
3.7%
4 80
 
3.2%
5 66
 
2.7%
Other values (12) 201
 
8.2%
Hangul
ValueCountFrequency (%)
파 240
 
7.0%
동 229
 
6.7%
송 224
 
6.6%
시 188
 
5.5%
구 185
 
5.4%
서 184
 
5.4%
별 183
 
5.4%
울 183
 
5.4%
특 183
 
5.4%
로 181
 
5.3%
Other values (148) 1434
42.0%

Missing values

2023-12-12T16:21:18.607153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:21:18.695233image/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

약국명칭약국소재지(도로명)
03층메디칼약국서울특별시 송파구 양재대로 1222, 올림픽프라자 23-1,23호 (방이동)
13층하나약국서울특별시 송파구 올림픽로35길 112 (신천동, 장미B상가 315호)
2가까운이화약국서울특별시 송파구 강동대로 74, 잠실올림픽아이파크상가 1층 108호, 지층 B103호 (풍납동)
3가든파이브약국서울특별시 송파구 충민로 66, 1층 F-1001호 (문정동, 가든파이브라이프 1층, F-1001호)
4가락온누리약국서울특별시 송파구 동남로 207 (가락동)
5가장큰현대아산약국서울특별시 송파구 강동대로 67 (풍납동)
6가장편한대영약국서울특별시 송파구 강동대로 74, 108동 101,102,지하102호 (풍납동)
7감초당약국서울특별시 송파구 백제고분로41길 11 (송파동)
8갤러리약국서울특별시 송파구 올림픽로 212 (잠실동, 갤러리아팰리스)
9거여서울약국서울특별시 송파구 오금로 505 (거여동, 101호)
약국명칭약국소재지(도로명)
173해오름약국서울특별시 송파구 올림픽로35길 124, 4층 7호 (신천동, 장미아파트 에이상가)
174해피홈약국서울특별시 송파구 오금로 512, 207호 (거여동, 거여역2차쌍용아파트 207호)
175햇살약국서울특별시 송파구 위례성대로20길 31, 1층 (오금동)
176행복약국서울특별시 송파구 양산로 42 (거여동)
177행복한우리약국서울특별시 송파구 풍성로25길 41, 백원빌딩 (풍납동)
178헬리오메디칼약국서울특별시 송파구 송파대로 345, 1A동 2023호 (가락동, 헬리오시티)
179화인약국서울특별시 송파구 중대로 80 (문정동, 롯데마트 3층)
180황제약국서울특별시 송파구 백제고분로 381, 우성빌딩 (송파동)
181후생약국서울특별시 송파구 마천로45길 15 (마천동)
182훼미리약국서울특별시 송파구 중대로 68 (문정동, 훼미리샤르망 106호)