Overview

Dataset statistics

Number of variables5
Number of observations523
Missing cells4
Missing cells (%)0.2%
Duplicate rows3
Duplicate rows (%)0.6%
Total size in memory20.6 KiB
Average record size in memory40.2 B

Variable types

Categorical1
Text3
DateTime1

Dataset

Description경기도 성남시에 있는 약국 현황에 대한 데이터로, 약국에 대한 구분,명칭,소재지,전화번호 등의 항목을 제공하는 데이터입니다.
Author경기도 성남시
URLhttps://www.data.go.kr/data/15000848/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 3 (0.6%) duplicate rowsDuplicates

Reproduction

Analysis started2024-03-14 11:36:48.130608
Analysis finished2024-03-14 11:36:49.240212
Duration1.11 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구별
Categorical

Distinct3
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
분당구
274 
수정구
147 
중원구
102 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row수정구
2nd row수정구
3rd row수정구
4th row수정구
5th row수정구

Common Values

ValueCountFrequency (%)
분당구 274
52.4%
수정구 147
28.1%
중원구 102
 
19.5%

Length

2024-03-14T20:36:49.446547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T20:36:49.761328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
분당구 274
52.4%
수정구 147
28.1%
중원구 102
 
19.5%

약국명칭
Text

Distinct497
Distinct (%)95.0%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
2024-03-14T20:36:50.845662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length5.418738
Min length3

Characters and Unicode

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

Unique

Unique473 ?
Unique (%)90.4%

Sample

1st row산성메디칼약국
2nd row한사랑약국
3rd row더편한365모란약국
4th row위례일번약국
5th row오아시스약국
ValueCountFrequency (%)
약국 5
 
0.9%
광장약국 3
 
0.6%
튼튼약국 3
 
0.6%
우리약국 3
 
0.6%
한약국 3
 
0.6%
명약국 2
 
0.4%
사랑약국 2
 
0.4%
다원약국 2
 
0.4%
중앙약국 2
 
0.4%
알파약국 2
 
0.4%
Other values (492) 508
95.0%
2024-03-14T20:36:52.143649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 526
 
18.6%
국 523
 
18.5%
리 83
 
2.9%
온 53
 
1.9%
누 50
 
1.8%
한 30
 
1.1%
당 30
 
1.1%
이 30
 
1.1%
성 29
 
1.0%
스 27
 
1.0%
Other values (283) 1453
51.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2777
98.0%
Decimal Number 39
 
1.4%
Space Separator 12
 
0.4%
Uppercase Letter 2
 
0.1%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%
Letter Number 1
 
< 0.1%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 526
 
18.9%
국 523
 
18.8%
리 83
 
3.0%
온 53
 
1.9%
누 50
 
1.8%
한 30
 
1.1%
당 30
 
1.1%
이 30
 
1.1%
성 29
 
1.0%
스 27
 
1.0%
Other values (271) 1396
50.3%
Decimal Number
ValueCountFrequency (%)
5 11
28.2%
3 10
25.6%
6 8
20.5%
1 5
12.8%
2 5
12.8%
Uppercase Letter
ValueCountFrequency (%)
H 1
50.0%
J 1
50.0%
Space Separator
ValueCountFrequency (%)
12
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Letter Number
ValueCountFrequency (%)
Ⅲ 1
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2777
98.0%
Common 54
 
1.9%
Latin 3
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 526
 
18.9%
국 523
 
18.8%
리 83
 
3.0%
온 53
 
1.9%
누 50
 
1.8%
한 30
 
1.1%
당 30
 
1.1%
이 30
 
1.1%
성 29
 
1.0%
스 27
 
1.0%
Other values (271) 1396
50.3%
Common
ValueCountFrequency (%)
12
22.2%
5 11
20.4%
3 10
18.5%
6 8
14.8%
1 5
9.3%
2 5
9.3%
( 1
 
1.9%
) 1
 
1.9%
. 1
 
1.9%
Latin
ValueCountFrequency (%)
H 1
33.3%
Ⅲ 1
33.3%
J 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2777
98.0%
ASCII 56
 
2.0%
Number Forms 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 526
 
18.9%
국 523
 
18.8%
리 83
 
3.0%
온 53
 
1.9%
누 50
 
1.8%
한 30
 
1.1%
당 30
 
1.1%
이 30
 
1.1%
성 29
 
1.0%
스 27
 
1.0%
Other values (271) 1396
50.3%
ASCII
ValueCountFrequency (%)
12
21.4%
5 11
19.6%
3 10
17.9%
6 8
14.3%
1 5
8.9%
2 5
8.9%
H 1
 
1.8%
( 1
 
1.8%
) 1
 
1.8%
. 1
 
1.8%
Number Forms
ValueCountFrequency (%)
Ⅲ 1
100.0%

약국전화번호
Text

Distinct515
Distinct (%)99.2%
Missing4
Missing (%)0.8%
Memory size4.2 KiB
2024-03-14T20:36:53.138278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.082852
Min length12

Characters and Unicode

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

Unique

Unique511 ?
Unique (%)98.5%

Sample

1st row070-8287-2387
2nd row031-741-0059
3rd row031-757-3652
4th row031-756-8863
5th row031-756-3206
ValueCountFrequency (%)
031-723-7488 2
 
0.4%
031-755-9810 2
 
0.4%
031-607-1300 2
 
0.4%
031-753-9828 2
 
0.4%
070-4256-8810 1
 
0.2%
031-703-8285 1
 
0.2%
031-8016-3535 1
 
0.2%
031-718-6312 1
 
0.2%
031-712-5756 1
 
0.2%
031-707-7990 1
 
0.2%
Other values (505) 505
97.3%
2024-03-14T20:36:54.578722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 1039
16.6%
0 961
15.3%
1 933
14.9%
3 854
13.6%
7 797
12.7%
5 399
 
6.4%
2 314
 
5.0%
8 258
 
4.1%
4 248
 
4.0%
6 241
 
3.8%
Other values (2) 227
 
3.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 5231
83.4%
Dash Punctuation 1039
 
16.6%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 961
18.4%
1 933
17.8%
3 854
16.3%
7 797
15.2%
5 399
7.6%
2 314
 
6.0%
8 258
 
4.9%
4 248
 
4.7%
6 241
 
4.6%
9 226
 
4.3%
Dash Punctuation
ValueCountFrequency (%)
- 1039
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 6271
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 1039
16.6%
0 961
15.3%
1 933
14.9%
3 854
13.6%
7 797
12.7%
5 399
 
6.4%
2 314
 
5.0%
8 258
 
4.1%
4 248
 
4.0%
6 241
 
3.8%
Other values (2) 227
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 6271
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 1039
16.6%
0 961
15.3%
1 933
14.9%
3 854
13.6%
7 797
12.7%
5 399
 
6.4%
2 314
 
5.0%
8 258
 
4.1%
4 248
 
4.0%
6 241
 
3.8%
Other values (2) 227
 
3.6%

약국소재지(도로명)
Text

Distinct519
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
2024-03-14T20:36:55.778373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length66
Median length50
Mean length37.917782
Min length23

Characters and Unicode

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

Unique

Unique515 ?
Unique (%)98.5%

Sample

1st row경기도 성남시 수정구 희망로 551, 산성역자이푸르지오 C1블럭 106호 (신흥동)
2nd row경기도 성남시 수정구 희망로 551, 산성역자이푸르지오 C1블록 101, 102호 (신흥동)
3rd row경기도 성남시 수정구 성남대로 1169, 남영빌딩 2층 (수진동)
4th row경기도 성남시 수정구 위례서일로 46, 위례엘포트한라비발디 107,109호 (창곡동)
5th row경기도 성남시 수정구 성남대로1221번길 6, 1층 일부호 (수진동)
ValueCountFrequency (%)
경기도 523
 
12.6%
성남시 523
 
12.6%
분당구 274
 
6.6%
1층 209
 
5.0%
수정구 147
 
3.5%
중원구 102
 
2.5%
서현동 54
 
1.3%
야탑동 46
 
1.1%
수정로 44
 
1.1%
태평동 43
 
1.0%
Other values (916) 2182
52.6%
2024-03-14T20:36:57.401612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3625
 
18.3%
1 1004
 
5.1%
, 714
 
3.6%
성 678
 
3.4%
남 623
 
3.1%
동 573
 
2.9%
구 554
 
2.8%
시 548
 
2.8%
도 541
 
2.7%
로 533
 
2.7%
Other values (304) 10438
52.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 11157
56.3%
Space Separator 3625
 
18.3%
Decimal Number 3149
 
15.9%
Other Punctuation 719
 
3.6%
Close Punctuation 525
 
2.6%
Open Punctuation 525
 
2.6%
Dash Punctuation 73
 
0.4%
Uppercase Letter 51
 
0.3%
Math Symbol 5
 
< 0.1%
Letter Number 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
성 678
 
6.1%
남 623
 
5.6%
동 573
 
5.1%
구 554
 
5.0%
시 548
 
4.9%
도 541
 
4.8%
로 533
 
4.8%
경 526
 
4.7%
기 523
 
4.7%
호 344
 
3.1%
Other values (269) 5714
51.2%
Uppercase Letter
ValueCountFrequency (%)
A 9
17.6%
C 7
13.7%
B 6
11.8%
R 5
9.8%
S 5
9.8%
I 5
9.8%
Y 3
 
5.9%
M 2
 
3.9%
D 2
 
3.9%
K 2
 
3.9%
Other values (5) 5
9.8%
Decimal Number
ValueCountFrequency (%)
1 1004
31.9%
0 405
12.9%
2 370
 
11.7%
3 350
 
11.1%
4 226
 
7.2%
6 190
 
6.0%
5 175
 
5.6%
7 153
 
4.9%
9 142
 
4.5%
8 134
 
4.3%
Other Punctuation
ValueCountFrequency (%)
, 714
99.3%
. 4
 
0.6%
' 1
 
0.1%
Letter Number
ValueCountFrequency (%)
Ⅲ 1
50.0%
Ⅱ 1
50.0%
Space Separator
ValueCountFrequency (%)
3625
100.0%
Close Punctuation
ValueCountFrequency (%)
) 525
100.0%
Open Punctuation
ValueCountFrequency (%)
( 525
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 73
100.0%
Math Symbol
ValueCountFrequency (%)
~ 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 11157
56.3%
Common 8621
43.5%
Latin 53
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
성 678
 
6.1%
남 623
 
5.6%
동 573
 
5.1%
구 554
 
5.0%
시 548
 
4.9%
도 541
 
4.8%
로 533
 
4.8%
경 526
 
4.7%
기 523
 
4.7%
호 344
 
3.1%
Other values (269) 5714
51.2%
Common
ValueCountFrequency (%)
3625
42.0%
1 1004
 
11.6%
, 714
 
8.3%
) 525
 
6.1%
( 525
 
6.1%
0 405
 
4.7%
2 370
 
4.3%
3 350
 
4.1%
4 226
 
2.6%
6 190
 
2.2%
Other values (8) 687
 
8.0%
Latin
ValueCountFrequency (%)
A 9
17.0%
C 7
13.2%
B 6
11.3%
R 5
9.4%
S 5
9.4%
I 5
9.4%
Y 3
 
5.7%
M 2
 
3.8%
D 2
 
3.8%
K 2
 
3.8%
Other values (7) 7
13.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 11157
56.3%
ASCII 8672
43.7%
Number Forms 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3625
41.8%
1 1004
 
11.6%
, 714
 
8.2%
) 525
 
6.1%
( 525
 
6.1%
0 405
 
4.7%
2 370
 
4.3%
3 350
 
4.0%
4 226
 
2.6%
6 190
 
2.2%
Other values (23) 738
 
8.5%
Hangul
ValueCountFrequency (%)
성 678
 
6.1%
남 623
 
5.6%
동 573
 
5.1%
구 554
 
5.0%
시 548
 
4.9%
도 541
 
4.8%
로 533
 
4.8%
경 526
 
4.7%
기 523
 
4.7%
호 344
 
3.1%
Other values (269) 5714
51.2%
Number Forms
ValueCountFrequency (%)
Ⅲ 1
50.0%
Ⅱ 1
50.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
Minimum2024-02-28 00:00:00
Maximum2024-02-28 00:00:00
2024-03-14T20:36:57.594578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T20:36:57.766291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2024-03-14T20:36:48.771192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T20:36:49.107975image/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-8287-2387경기도 성남시 수정구 희망로 551, 산성역자이푸르지오 C1블럭 106호 (신흥동)2024-02-28
1수정구한사랑약국031-741-0059경기도 성남시 수정구 희망로 551, 산성역자이푸르지오 C1블록 101, 102호 (신흥동)2024-02-28
2수정구더편한365모란약국031-757-3652경기도 성남시 수정구 성남대로 1169, 남영빌딩 2층 (수진동)2024-02-28
3수정구위례일번약국031-756-8863경기도 성남시 수정구 위례서일로 46, 위례엘포트한라비발디 107,109호 (창곡동)2024-02-28
4수정구오아시스약국031-756-3206경기도 성남시 수정구 성남대로1221번길 6, 1층 일부호 (수진동)2024-02-28
5수정구성남햇살약국<NA>경기도 성남시 수정구 수정로171번길 7-1, 우일프라자 2층 일부호 (태평동)2024-02-28
6수정구봄봄약국031-753-5450경기도 성남시 수정구 위례광장로 5, 남위례역아이파크 111호 (창곡동)2024-02-28
7수정구365수정메디약국031-758-3650경기도 성남시 수정구 수정로 128, 1층 일부호 (수진동)2024-02-28
8수정구위례나은약국031-755-7375경기도 성남시 수정구 위례광장로 328, 우성위례타워 2층 206호 (창곡동)2024-02-28
9수정구참사랑약국031-607-1300경기도 성남시 수정구 수정로 106, 수진동 SR프라자 115호 (수진동)2024-02-28
구별약국명칭약국전화번호약국소재지(도로명)데이터기준일자
513분당구십자약국031-716-9006경기도 성남시 분당구 내정로107번길 2, 1층 (정자동)2024-02-28
514분당구명수약국031-717-2064경기도 성남시 분당구 미금로 184, 103호 (구미동, 대우,롯데, 선경 A상가)2024-02-28
515분당구한약국031-704-0738경기도 성남시 분당구 판교로 700, 110호 (야탑동, 아파트형공장)2024-02-28
516분당구은정약국031-711-9260경기도 성남시 분당구 느티로 71, 106호 (정자동, 현대프라자 )2024-02-28
517분당구한솔약국031-705-3715경기도 성남시 분당구 야탑로69번길 24-8, 102호 (야탑동, 분당종합상가)2024-02-28
518분당구문약국031-702-4029경기도 성남시 분당구 불정로376번길 37, 1-2호 (서현동, 범한프라자)2024-02-28
519분당구삼보당온누리약국031-701-4927경기도 성남시 분당구 분당로263번길 24, 101호 (분당동, 건영종합상가)2024-02-28
520분당구기린약국031-711-4771경기도 성남시 분당구 미금로 48, 111,112호 (구미동, 오성프라자)2024-02-28
521분당구보람온누리약국031-717-8532경기도 성남시 분당구 성남대로 170, 303호 (금곡동, 한국프라자)2024-02-28
522분당구엄마손약국031-728-2331경기도 성남시 분당구 돌마로 80, 2층 (구미동, 분당현대벤처빌,85~90.119~124호)2024-02-28

Duplicate rows

Most frequently occurring

구별약국명칭약국전화번호약국소재지(도로명)데이터기준일자# duplicates
0수정구김구약국031-753-9828경기도 성남시 수정구 수정로 115-1 (태평동, 주민신협행복빌딩)2024-02-282
1수정구위례광장약국031-723-7488경기도 성남시 수정구 위례광장로 9-9, 위례우남역 퍼스트푸르지오시티 1층 112호 (창곡동)2024-02-282
2수정구코끼리약국031-755-9810경기도 성남시 수정구 수정로 116 (수진동)2024-02-282