Overview

Dataset statistics

Number of variables3
Number of observations411
Missing cells221
Missing cells (%)17.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.8 KiB
Average record size in memory24.3 B

Variable types

Text3

Dataset

Description안정상비의약품판매업소 정보(의약품판매업소점포명, 의약품판매업소점포도로명, 의약품판매업소전화번호) 제공 데이터 정보입니다.
URLhttps://www.data.go.kr/data/15055318/fileData.do

Alerts

전화번호 has 221 (53.8%) missing valuesMissing
판매점포명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 20:36:04.029569
Analysis finished2023-12-12 20:36:04.401821
Duration0.37 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

판매점포명
Text

UNIQUE 

Distinct411
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2023-12-13T05:36:04.601940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length17
Mean length10.498783
Min length4

Characters and Unicode

Total characters4315
Distinct characters264
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique411 ?
Unique (%)100.0%

Sample

1st row지에스(GS25)안양현충로점
2nd row씨유 아르테자이점
3rd row씨유 석수마을점
4th row(주)코리아세븐 안양장내로점
5th row지에스25 안양래미안점
ValueCountFrequency (%)
씨유 69
 
10.4%
지에스25 52
 
7.8%
세븐일레븐 43
 
6.5%
gs25 35
 
5.3%
주)코리아세븐 19
 
2.9%
cu 11
 
1.7%
미니스톱 8
 
1.2%
지에스(gs)25 4
 
0.6%
동편마을점 3
 
0.5%
안양박달점 3
 
0.5%
Other values (403) 418
62.9%
2023-12-13T05:36:05.105620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 381
 
8.8%
254
 
5.9%
양 251
 
5.8%
안 242
 
5.6%
2 170
 
3.9%
5 162
 
3.8%
븐 154
 
3.6%
스 108
 
2.5%
유 99
 
2.3%
씨 99
 
2.3%
Other values (254) 2395
55.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3301
76.5%
Decimal Number 349
 
8.1%
Uppercase Letter 274
 
6.3%
Space Separator 254
 
5.9%
Close Punctuation 68
 
1.6%
Open Punctuation 68
 
1.6%
Other Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 381
 
11.5%
양 251
 
7.6%
안 242
 
7.3%
븐 154
 
4.7%
스 108
 
3.3%
유 99
 
3.0%
씨 99
 
3.0%
세 89
 
2.7%
에 85
 
2.6%
지 84
 
2.5%
Other values (232) 1709
51.8%
Uppercase Letter
ValueCountFrequency (%)
S 95
34.7%
G 94
34.3%
U 38
 
13.9%
C 38
 
13.9%
I 4
 
1.5%
K 1
 
0.4%
A 1
 
0.4%
T 1
 
0.4%
L 1
 
0.4%
R 1
 
0.4%
Decimal Number
ValueCountFrequency (%)
2 170
48.7%
5 162
46.4%
4 7
 
2.0%
6 4
 
1.1%
3 2
 
0.6%
1 2
 
0.6%
8 1
 
0.3%
9 1
 
0.3%
Space Separator
ValueCountFrequency (%)
254
100.0%
Close Punctuation
ValueCountFrequency (%)
) 68
100.0%
Open Punctuation
ValueCountFrequency (%)
( 68
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3302
76.5%
Common 739
 
17.1%
Latin 274
 
6.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 381
 
11.5%
양 251
 
7.6%
안 242
 
7.3%
븐 154
 
4.7%
스 108
 
3.3%
유 99
 
3.0%
씨 99
 
3.0%
세 89
 
2.7%
에 85
 
2.6%
지 84
 
2.5%
Other values (233) 1710
51.8%
Common
ValueCountFrequency (%)
254
34.4%
2 170
23.0%
5 162
21.9%
) 68
 
9.2%
( 68
 
9.2%
4 7
 
0.9%
6 4
 
0.5%
3 2
 
0.3%
1 2
 
0.3%
8 1
 
0.1%
Latin
ValueCountFrequency (%)
S 95
34.7%
G 94
34.3%
U 38
 
13.9%
C 38
 
13.9%
I 4
 
1.5%
K 1
 
0.4%
A 1
 
0.4%
T 1
 
0.4%
L 1
 
0.4%
R 1
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3301
76.5%
ASCII 1013
 
23.5%
None 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 381
 
11.5%
양 251
 
7.6%
안 242
 
7.3%
븐 154
 
4.7%
스 108
 
3.3%
유 99
 
3.0%
씨 99
 
3.0%
세 89
 
2.7%
에 85
 
2.6%
지 84
 
2.5%
Other values (232) 1709
51.8%
ASCII
ValueCountFrequency (%)
254
25.1%
2 170
16.8%
5 162
16.0%
S 95
 
9.4%
G 94
 
9.3%
) 68
 
6.7%
( 68
 
6.7%
U 38
 
3.8%
C 38
 
3.8%
4 7
 
0.7%
Other values (11) 19
 
1.9%
None
ValueCountFrequency (%)
㈜ 1
100.0%

전화번호
Text

MISSING 

Distinct185
Distinct (%)97.4%
Missing221
Missing (%)53.8%
Memory size3.3 KiB
2023-12-13T05:36:05.386451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.963158
Min length9

Characters and Unicode

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

Unique181 ?
Unique (%)95.3%

Sample

1st row02-1577-8007
2nd row031-446-4186
3rd row031-441-7110
4th row031-443-2040
5th row031-445-4533
ValueCountFrequency (%)
1577-0711 3
 
1.6%
02-1577-8007 2
 
1.1%
031-424-8553 2
 
1.1%
031-466-9334 2
 
1.1%
031-454-1101 1
 
0.5%
031-383-5511 1
 
0.5%
031-385-5274 1
 
0.5%
031-425-4232 1
 
0.5%
031-423-5095 1
 
0.5%
031-446-8967 1
 
0.5%
Other values (175) 175
92.1%
2023-12-13T05:36:05.931687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 377
16.6%
3 324
14.3%
1 322
14.2%
0 289
12.7%
4 279
12.3%
2 135
 
5.9%
7 129
 
5.7%
5 116
 
5.1%
6 103
 
4.5%
8 101
 
4.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1896
83.4%
Dash Punctuation 377
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 324
17.1%
1 322
17.0%
0 289
15.2%
4 279
14.7%
2 135
7.1%
7 129
 
6.8%
5 116
 
6.1%
6 103
 
5.4%
8 101
 
5.3%
9 98
 
5.2%
Dash Punctuation
ValueCountFrequency (%)
- 377
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2273
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 377
16.6%
3 324
14.3%
1 322
14.2%
0 289
12.7%
4 279
12.3%
2 135
 
5.9%
7 129
 
5.7%
5 116
 
5.1%
6 103
 
4.5%
8 101
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2273
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 377
16.6%
3 324
14.3%
1 322
14.2%
0 289
12.7%
4 279
12.3%
2 135
 
5.9%
7 129
 
5.7%
5 116
 
5.1%
6 103
 
4.5%
8 101
 
4.4%

소재지(도로명)
Text

Distinct409
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2023-12-13T05:36:06.326302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length58
Median length49
Mean length35.625304
Min length23

Characters and Unicode

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

Unique

Unique407 ?
Unique (%)99.0%

Sample

1st row경기도 안양시 만안구 현충로 14, 1층 (안양동)
2nd row경기도 안양시 만안구 경수대로1166번길 9, 201동 1층 112, 113호 (안양동, 아르테자이)
3rd row경기도 안양시 만안구 연현로79번길 41, 석수 엘지 빌리지 상가동 104,105,106호 (석수동)
4th row경기도 안양시 만안구 장내로 52, 101호 (안양동)
5th row경기도 안양시 만안구 안양천서로 177, 상가 2동 1층 (안양동, 래미안 안양 메가트리아)
ValueCountFrequency (%)
경기도 411
 
13.2%
안양시 411
 
13.2%
동안구 230
 
7.4%
만안구 181
 
5.8%
1층 165
 
5.3%
안양동 125
 
4.0%
관양동 88
 
2.8%
호계동 73
 
2.3%
101호 54
 
1.7%
비산동 49
 
1.6%
Other values (658) 1321
42.5%
2023-12-13T05:36:06.900914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2697
18.4%
안 1079
 
7.4%
1 807
 
5.5%
동 735
 
5.0%
양 707
 
4.8%
경 457
 
3.1%
시 440
 
3.0%
기 414
 
2.8%
) 413
 
2.8%
, 413
 
2.8%
Other values (252) 6480
44.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8285
56.6%
Space Separator 2697
 
18.4%
Decimal Number 2374
 
16.2%
Close Punctuation 413
 
2.8%
Other Punctuation 413
 
2.8%
Open Punctuation 413
 
2.8%
Dash Punctuation 24
 
0.2%
Uppercase Letter 14
 
0.1%
Lowercase Letter 7
 
< 0.1%
Math Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
안 1079
 
13.0%
동 735
 
8.9%
양 707
 
8.5%
경 457
 
5.5%
시 440
 
5.3%
기 414
 
5.0%
로 413
 
5.0%
구 412
 
5.0%
도 412
 
5.0%
호 272
 
3.3%
Other values (224) 2944
35.5%
Decimal Number
ValueCountFrequency (%)
1 807
34.0%
0 307
 
12.9%
2 257
 
10.8%
3 209
 
8.8%
4 170
 
7.2%
5 150
 
6.3%
7 129
 
5.4%
6 129
 
5.4%
8 110
 
4.6%
9 106
 
4.5%
Uppercase Letter
ValueCountFrequency (%)
I 5
35.7%
B 3
21.4%
Z 2
 
14.3%
G 1
 
7.1%
M 1
 
7.1%
W 1
 
7.1%
R 1
 
7.1%
Lowercase Letter
ValueCountFrequency (%)
e 3
42.9%
c 1
 
14.3%
s 1
 
14.3%
p 1
 
14.3%
a 1
 
14.3%
Space Separator
ValueCountFrequency (%)
2697
100.0%
Close Punctuation
ValueCountFrequency (%)
) 413
100.0%
Other Punctuation
ValueCountFrequency (%)
, 413
100.0%
Open Punctuation
ValueCountFrequency (%)
( 413
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 24
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8285
56.6%
Common 6336
43.3%
Latin 21
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
안 1079
 
13.0%
동 735
 
8.9%
양 707
 
8.5%
경 457
 
5.5%
시 440
 
5.3%
기 414
 
5.0%
로 413
 
5.0%
구 412
 
5.0%
도 412
 
5.0%
호 272
 
3.3%
Other values (224) 2944
35.5%
Common
ValueCountFrequency (%)
2697
42.6%
1 807
 
12.7%
) 413
 
6.5%
, 413
 
6.5%
( 413
 
6.5%
0 307
 
4.8%
2 257
 
4.1%
3 209
 
3.3%
4 170
 
2.7%
5 150
 
2.4%
Other values (6) 500
 
7.9%
Latin
ValueCountFrequency (%)
I 5
23.8%
e 3
14.3%
B 3
14.3%
Z 2
 
9.5%
G 1
 
4.8%
M 1
 
4.8%
W 1
 
4.8%
c 1
 
4.8%
s 1
 
4.8%
p 1
 
4.8%
Other values (2) 2
 
9.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8285
56.6%
ASCII 6357
43.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2697
42.4%
1 807
 
12.7%
) 413
 
6.5%
, 413
 
6.5%
( 413
 
6.5%
0 307
 
4.8%
2 257
 
4.0%
3 209
 
3.3%
4 170
 
2.7%
5 150
 
2.4%
Other values (18) 521
 
8.2%
Hangul
ValueCountFrequency (%)
안 1079
 
13.0%
동 735
 
8.9%
양 707
 
8.5%
경 457
 
5.5%
시 440
 
5.3%
기 414
 
5.0%
로 413
 
5.0%
구 412
 
5.0%
도 412
 
5.0%
호 272
 
3.3%
Other values (224) 2944
35.5%

Missing values

2023-12-13T05:36:04.301684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:36:04.369386image/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지에스(GS25)안양현충로점<NA>경기도 안양시 만안구 현충로 14, 1층 (안양동)
1씨유 아르테자이점<NA>경기도 안양시 만안구 경수대로1166번길 9, 201동 1층 112, 113호 (안양동, 아르테자이)
2씨유 석수마을점<NA>경기도 안양시 만안구 연현로79번길 41, 석수 엘지 빌리지 상가동 104,105,106호 (석수동)
3(주)코리아세븐 안양장내로점<NA>경기도 안양시 만안구 장내로 52, 101호 (안양동)
4지에스25 안양래미안점<NA>경기도 안양시 만안구 안양천서로 177, 상가 2동 1층 (안양동, 래미안 안양 메가트리아)
5(주)코리아세븐 박달한신점<NA>경기도 안양시 만안구 박달로497번길 62, 104호 (박달동)
6씨유 안양아트점02-1577-8007경기도 안양시 만안구 안양로 125, 1층 (안양동)
7씨유 안양믿음점<NA>경기도 안양시 만안구 안양로369번길 43, 1층 (안양동)
8지에스25 안양삼막타운점<NA>경기도 안양시 만안구 삼막로 34, 삼막뜰 1층 (석수동)
9지에스25 안양메가트리아031-446-4186경기도 안양시 만안구 안양천서로 177, 상가3동 2호 (안양동, 래미안 안양 메가트리아)
판매점포명전화번호소재지(도로명)
401지에스25호계으뜸점031-399-2369경기도 안양시 동안구 갈산로 16 (호계동)
402세븐일레븐 안양호계현대점031-452-9298경기도 안양시 동안구 시민대로136번길 32 (호계동)
403씨유호계대로점031-455-0930경기도 안양시 동안구 엘에스로 51 (호계동)
404씨유안양평촌점031-382-1185경기도 안양시 동안구 평촌대로223번길 49 (호계동)
405GS25뉴호계월드점031-456-1332경기도 안양시 동안구 흥안대로109번길 8, 102호 (호계동)
406씨유안양운동장점031-385-5274경기도 안양시 동안구 평촌대로 401 (비산동)
407지에스25평촌타워031-381-0866경기도 안양시 동안구 시민대로 187 (비산동)
408씨유꿈에그린점031-441-3188경기도 안양시 동안구 경수대로883번길 56 (비산동)
409씨유인덕원신한점031-422-0090경기도 안양시 동안구 안양판교로 20 (관양동)
410세븐일레븐안양관양본점031-426-4808경기도 안양시 동안구 관악대로 436 (관양동)