Overview

Dataset statistics

Number of variables3
Number of observations283
Missing cells1
Missing cells (%)0.1%
Duplicate rows6
Duplicate rows (%)2.1%
Total size in memory6.8 KiB
Average record size in memory24.5 B

Variable types

Text3

Dataset

Description경기도 안양시 관내 약국( 안양시 관내 약국명칭, 안양시 관내 약국 소재지, 안양시 관내 약국 전화번호)데이터 현황 정보입니다.
URLhttps://www.data.go.kr/data/3079495/fileData.do

Alerts

Dataset has 6 (2.1%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 16:55:23.303036
Analysis finished2023-12-12 16:55:23.743341
Duration0.44 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약국명칭
Text

Distinct274
Distinct (%)96.8%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
2023-12-13T01:55:23.979853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length9
Mean length5.1590106
Min length3

Characters and Unicode

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

Unique

Unique265 ?
Unique (%)93.6%

Sample

1st row제일온누리약국
2nd row미담약국
3rd row여기약국
4th row늘편한약국
5th row햇살약국
ValueCountFrequency (%)
약국 7
 
2.3%
한약국 3
 
1.0%
다정약국 2
 
0.7%
미소지은온누리약국 2
 
0.7%
리본약국 2
 
0.7%
한소망약국 2
 
0.7%
오얏봉약국 2
 
0.7%
중앙약국 2
 
0.7%
새누리약국 2
 
0.7%
평촌제일약국 2
 
0.7%
Other values (273) 275
91.4%
2023-12-13T01:55:24.576157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 284
 
19.5%
국 283
 
19.4%
리 40
 
2.7%
누 26
 
1.8%
온 25
 
1.7%
한 23
 
1.6%
18
 
1.2%
평 18
 
1.2%
촌 17
 
1.2%
양 15
 
1.0%
Other values (233) 711
48.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1413
96.8%
Decimal Number 21
 
1.4%
Space Separator 18
 
1.2%
Lowercase Letter 3
 
0.2%
Uppercase Letter 3
 
0.2%
Close Punctuation 1
 
0.1%
Open Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 284
20.1%
국 283
20.0%
리 40
 
2.8%
누 26
 
1.8%
온 25
 
1.8%
한 23
 
1.6%
평 18
 
1.3%
촌 17
 
1.2%
양 15
 
1.1%
은 14
 
1.0%
Other values (217) 668
47.3%
Decimal Number
ValueCountFrequency (%)
6 4
19.0%
5 4
19.0%
1 3
14.3%
3 3
14.3%
2 2
9.5%
4 2
9.5%
0 2
9.5%
7 1
 
4.8%
Uppercase Letter
ValueCountFrequency (%)
T 1
33.3%
G 1
33.3%
L 1
33.3%
Lowercase Letter
ValueCountFrequency (%)
e 2
66.7%
h 1
33.3%
Space Separator
ValueCountFrequency (%)
18
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1412
96.7%
Common 41
 
2.8%
Latin 6
 
0.4%
Han 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 284
20.1%
국 283
20.0%
리 40
 
2.8%
누 26
 
1.8%
온 25
 
1.8%
한 23
 
1.6%
평 18
 
1.3%
촌 17
 
1.2%
양 15
 
1.1%
은 14
 
1.0%
Other values (216) 667
47.2%
Common
ValueCountFrequency (%)
18
43.9%
6 4
 
9.8%
5 4
 
9.8%
1 3
 
7.3%
3 3
 
7.3%
2 2
 
4.9%
4 2
 
4.9%
0 2
 
4.9%
) 1
 
2.4%
( 1
 
2.4%
Latin
ValueCountFrequency (%)
e 2
33.3%
h 1
16.7%
T 1
16.7%
G 1
16.7%
L 1
16.7%
Han
ValueCountFrequency (%)
美 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1412
96.7%
ASCII 47
 
3.2%
CJK 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 284
20.1%
국 283
20.0%
리 40
 
2.8%
누 26
 
1.8%
온 25
 
1.8%
한 23
 
1.6%
평 18
 
1.3%
촌 17
 
1.2%
양 15
 
1.1%
은 14
 
1.0%
Other values (216) 667
47.2%
ASCII
ValueCountFrequency (%)
18
38.3%
6 4
 
8.5%
5 4
 
8.5%
1 3
 
6.4%
3 3
 
6.4%
2 2
 
4.3%
4 2
 
4.3%
e 2
 
4.3%
0 2
 
4.3%
h 1
 
2.1%
Other values (6) 6
 
12.8%
CJK
ValueCountFrequency (%)
美 1
100.0%

약국전화번호
Text

Distinct276
Distinct (%)97.9%
Missing1
Missing (%)0.4%
Memory size2.3 KiB
2023-12-13T01:55:24.876544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.078014
Min length12

Characters and Unicode

Total characters3406
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique270 ?
Unique (%)95.7%

Sample

1st row070-7633-3870
2nd row031-468-8697
3rd row031-465-0675
4th row031-466-1237
5th row031-360-7753
ValueCountFrequency (%)
031-466-5669 2
 
0.7%
031-385-8856 2
 
0.7%
031-382-1748 2
 
0.7%
031-388-3212 2
 
0.7%
031-422-8272 2
 
0.7%
031-421-8777 2
 
0.7%
031-421-3707 1
 
0.4%
031-387-5335 1
 
0.4%
031-381-7786 1
 
0.4%
031-442-9905 1
 
0.4%
Other values (266) 266
94.3%
2023-12-13T01:55:25.344517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 564
16.6%
3 503
14.8%
1 448
13.2%
0 421
12.4%
4 356
10.5%
2 220
 
6.5%
8 211
 
6.2%
7 199
 
5.8%
6 181
 
5.3%
5 180
 
5.3%
Other values (3) 123
 
3.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2839
83.4%
Dash Punctuation 564
 
16.6%
Math Symbol 2
 
0.1%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 503
17.7%
1 448
15.8%
0 421
14.8%
4 356
12.5%
2 220
7.7%
8 211
7.4%
7 199
 
7.0%
6 181
 
6.4%
5 180
 
6.3%
9 120
 
4.2%
Dash Punctuation
ValueCountFrequency (%)
- 564
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3406
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 564
16.6%
3 503
14.8%
1 448
13.2%
0 421
12.4%
4 356
10.5%
2 220
 
6.5%
8 211
 
6.2%
7 199
 
5.8%
6 181
 
5.3%
5 180
 
5.3%
Other values (3) 123
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3406
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 564
16.6%
3 503
14.8%
1 448
13.2%
0 421
12.4%
4 356
10.5%
2 220
 
6.5%
8 211
 
6.2%
7 199
 
5.8%
6 181
 
5.3%
5 180
 
5.3%
Other values (3) 123
 
3.6%

약국소재지(도로명)
Text

Distinct277
Distinct (%)97.9%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
2023-12-13T01:55:25.750372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length57
Median length50
Mean length35.487633
Min length23

Characters and Unicode

Total characters10043
Distinct characters246
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

Unique271 ?
Unique (%)95.8%

Sample

1st row경기도 안양시 만안구 안양로 407, 102호 (안양동)
2nd row경기도 안양시 만안구 태평로52번길 31, 1층 102호 (안양동)
3rd row경기도 안양시 만안구 박달로 476, 대원빌딩 102-1호 (박달동)
4th row경기도 안양시 만안구 안양로 307, 금상타워 103호 (안양동)
5th row경기도 안양시 만안구 병목안로130번길 4, 101호 (안양동)
ValueCountFrequency (%)
경기도 283
 
13.2%
안양시 283
 
13.2%
동안구 173
 
8.1%
만안구 110
 
5.1%
1층 84
 
3.9%
안양동 80
 
3.7%
호계동 60
 
2.8%
관양동 58
 
2.7%
안양로 43
 
2.0%
비산동 34
 
1.6%
Other values (497) 932
43.6%
2023-12-13T01:55:26.334138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1857
18.5%
안 768
 
7.6%
양 501
 
5.0%
동 492
 
4.9%
1 465
 
4.6%
, 320
 
3.2%
경 314
 
3.1%
시 306
 
3.0%
도 284
 
2.8%
로 284
 
2.8%
Other values (236) 4452
44.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5681
56.6%
Space Separator 1857
 
18.5%
Decimal Number 1556
 
15.5%
Other Punctuation 322
 
3.2%
Close Punctuation 283
 
2.8%
Open Punctuation 283
 
2.8%
Uppercase Letter 32
 
0.3%
Dash Punctuation 21
 
0.2%
Lowercase Letter 7
 
0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
안 768
 
13.5%
양 501
 
8.8%
동 492
 
8.7%
경 314
 
5.5%
시 306
 
5.4%
도 284
 
5.0%
로 284
 
5.0%
구 283
 
5.0%
기 283
 
5.0%
호 220
 
3.9%
Other values (199) 1946
34.3%
Uppercase Letter
ValueCountFrequency (%)
A 5
15.6%
T 4
12.5%
B 3
9.4%
C 3
9.4%
W 2
 
6.2%
E 2
 
6.2%
J 2
 
6.2%
O 2
 
6.2%
R 2
 
6.2%
K 2
 
6.2%
Other values (5) 5
15.6%
Decimal Number
ValueCountFrequency (%)
1 465
29.9%
0 203
13.0%
2 199
12.8%
3 172
 
11.1%
4 129
 
8.3%
5 103
 
6.6%
7 94
 
6.0%
6 78
 
5.0%
8 69
 
4.4%
9 44
 
2.8%
Lowercase Letter
ValueCountFrequency (%)
e 3
42.9%
r 1
 
14.3%
t 1
 
14.3%
n 1
 
14.3%
c 1
 
14.3%
Other Punctuation
ValueCountFrequency (%)
, 320
99.4%
. 2
 
0.6%
Space Separator
ValueCountFrequency (%)
1857
100.0%
Close Punctuation
ValueCountFrequency (%)
) 283
100.0%
Open Punctuation
ValueCountFrequency (%)
( 283
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 21
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5681
56.6%
Common 4323
43.0%
Latin 39
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
안 768
 
13.5%
양 501
 
8.8%
동 492
 
8.7%
경 314
 
5.5%
시 306
 
5.4%
도 284
 
5.0%
로 284
 
5.0%
구 283
 
5.0%
기 283
 
5.0%
호 220
 
3.9%
Other values (199) 1946
34.3%
Latin
ValueCountFrequency (%)
A 5
12.8%
T 4
 
10.3%
e 3
 
7.7%
B 3
 
7.7%
C 3
 
7.7%
W 2
 
5.1%
E 2
 
5.1%
J 2
 
5.1%
O 2
 
5.1%
R 2
 
5.1%
Other values (10) 11
28.2%
Common
ValueCountFrequency (%)
1857
43.0%
1 465
 
10.8%
, 320
 
7.4%
) 283
 
6.5%
( 283
 
6.5%
0 203
 
4.7%
2 199
 
4.6%
3 172
 
4.0%
4 129
 
3.0%
5 103
 
2.4%
Other values (7) 309
 
7.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5681
56.6%
ASCII 4362
43.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1857
42.6%
1 465
 
10.7%
, 320
 
7.3%
) 283
 
6.5%
( 283
 
6.5%
0 203
 
4.7%
2 199
 
4.6%
3 172
 
3.9%
4 129
 
3.0%
5 103
 
2.4%
Other values (27) 348
 
8.0%
Hangul
ValueCountFrequency (%)
안 768
 
13.5%
양 501
 
8.8%
동 492
 
8.7%
경 314
 
5.5%
시 306
 
5.4%
도 284
 
5.0%
로 284
 
5.0%
구 283
 
5.0%
기 283
 
5.0%
호 220
 
3.9%
Other values (199) 1946
34.3%

Missing values

2023-12-13T01:55:23.624587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T01:55:23.712162image/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제일온누리약국070-7633-3870경기도 안양시 만안구 안양로 407, 102호 (안양동)
1미담약국031-468-8697경기도 안양시 만안구 태평로52번길 31, 1층 102호 (안양동)
2여기약국031-465-0675경기도 안양시 만안구 박달로 476, 대원빌딩 102-1호 (박달동)
3늘편한약국031-466-1237경기도 안양시 만안구 안양로 307, 금상타워 103호 (안양동)
4햇살약국031-360-7753경기도 안양시 만안구 병목안로130번길 4, 101호 (안양동)
5세은약국031-468-8253경기도 안양시 만안구 박달로 500, 1층 (박달동)
6다정약국031-464-7588경기도 안양시 만안구 안양로 119, 계양빌딩 1층 (안양동)
7올리브약국031-443-7569경기도 안양시 만안구 안양로 142, 부성빌딩 1층 1호 (안양동)
8참튼튼약국031-444-4640경기도 안양시 만안구 안양로 370, 광순빌딩 2층 (안양동)
9효자당약국031-447-5956경기도 안양시 만안구 장내로 125, 1층 제5호 (안양동)
약국명칭약국전화번호약국소재지(도로명)
273고약국031-455-7861경기도 안양시 동안구 경수대로 529, 1층 (호계동)
274해맑은약국031-456-3134경기도 안양시 동안구 엘에스로 45, 110호 (호계동, 대영골든타워)
275기원약국031-454-9902경기도 안양시 동안구 시민대로327번길 6, 111호 (관양동, W에이스타워)
276피영약국031-388-5900경기도 안양시 동안구 평촌대로 371, 1층 (비산동)
277대한약국031-458-3248경기도 안양시 동안구 흥안대로223번길 43, 121호 (호계동, 대우한양아파트상가)
278한독약국031-452-3127경기도 안양시 동안구 경수대로 707 (호계동)
279세명약국031-421-7623경기도 안양시 동안구 흥안대로 313 (평촌동)
280아름약국031-388-0557경기도 안양시 동안구 학의로 282, 금강펜테리움IT타워 1층 123호 (관양동)
281우성약국031-452-7731경기도 안양시 동안구 경수대로544번길 16 (호계동)
282유림약국031-421-3973경기도 안양시 동안구 흥안대로 502 (관양동)

Duplicate rows

Most frequently occurring

약국명칭약국전화번호약국소재지(도로명)# duplicates
0미소지은온누리약국031-466-5669경기도 안양시 동안구 관악대로 103, 103에비뉴 6층 610, 611호 (비산동)2
1새누리약국031-382-1748경기도 안양시 동안구 동안로 120, 평촌스포츠센타 301호 (호계동)2
2오얏봉약국031-388-3212경기도 안양시 동안구 관평로170번길 33, 107호 (관양동, 평촌주공공이)2
3주민약국031-422-8272경기도 안양시 동안구 관악대로 456, 1층 (관양동)2
4평촌제일약국031-385-8856경기도 안양시 동안구 평촌대로223번길 64, 제일빌딩 307-1호 (호계동)2
5한소망약국031-421-8777경기도 안양시 동안구 흥안대로 378, 101호 (평촌동, 서울안과빌딩)2