Overview

Dataset statistics

Number of variables3
Number of observations117
Missing cells2
Missing cells (%)0.6%
Duplicate rows4
Duplicate rows (%)3.4%
Total size in memory2.9 KiB
Average record size in memory25.1 B

Variable types

Text3

Dataset

Description경기도 광주시 관내 약국 현황에 대한 데이터로 약국명칭, 전화번호, 약국소재지(도로명주소) 등의 항목을 제공합니다.
Author공공데이터포털
URLhttps://www.data.go.kr/data/15121628/fileData.do

Alerts

Dataset has 4 (3.4%) duplicate rowsDuplicates
약국전화번호 has 2 (1.7%) missing valuesMissing

Reproduction

Analysis started2024-04-21 14:49:25.618139
Analysis finished2024-04-21 14:49:26.537437
Duration0.92 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약국명칭
Text

Distinct113
Distinct (%)96.6%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2024-04-21T23:49:27.357466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length8
Mean length4.974359
Min length3

Characters and Unicode

Total characters582
Distinct characters150
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique109 ?
Unique (%)93.2%

Sample

1st row감초당약국
2nd row건강약국
3rd row건강온누리약국
4th row건강한 우리약국
5th row경기약국
ValueCountFrequency (%)
서울보룡약국 2
 
1.7%
바다약국 2
 
1.7%
오렌지약국 2
 
1.7%
약국 2
 
1.7%
늘품약국 2
 
1.7%
오포제일온누리약국 1
 
0.8%
오행당약국 1
 
0.8%
이화원약국 1
 
0.8%
이화약국 1
 
0.8%
이배재약국 1
 
0.8%
Other values (106) 106
87.6%
2024-04-21T23:49:28.775692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 117
20.1%
국 117
20.1%
리 15
 
2.6%
온 12
 
2.1%
누 11
 
1.9%
오 8
 
1.4%
광 7
 
1.2%
다 7
 
1.2%
한 6
 
1.0%
지 6
 
1.0%
Other values (140) 276
47.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 578
99.3%
Space Separator 4
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 117
20.2%
국 117
20.2%
리 15
 
2.6%
온 12
 
2.1%
누 11
 
1.9%
오 8
 
1.4%
광 7
 
1.2%
다 7
 
1.2%
한 6
 
1.0%
지 6
 
1.0%
Other values (139) 272
47.1%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 578
99.3%
Common 4
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 117
20.2%
국 117
20.2%
리 15
 
2.6%
온 12
 
2.1%
누 11
 
1.9%
오 8
 
1.4%
광 7
 
1.2%
다 7
 
1.2%
한 6
 
1.0%
지 6
 
1.0%
Other values (139) 272
47.1%
Common
ValueCountFrequency (%)
4
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 578
99.3%
ASCII 4
 
0.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 117
20.2%
국 117
20.2%
리 15
 
2.6%
온 12
 
2.1%
누 11
 
1.9%
오 8
 
1.4%
광 7
 
1.2%
다 7
 
1.2%
한 6
 
1.0%
지 6
 
1.0%
Other values (139) 272
47.1%
ASCII
ValueCountFrequency (%)
4
100.0%

약국전화번호
Text

MISSING 

Distinct111
Distinct (%)96.5%
Missing2
Missing (%)1.7%
Memory size1.0 KiB
2024-04-21T23:49:29.726741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.043478
Min length12

Characters and Unicode

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

Unique107 ?
Unique (%)93.0%

Sample

1st row031-761-2840
2nd row070-8714-0360
3rd row031-765-8925
4th row031-798-2888
5th row031-765-8562
ValueCountFrequency (%)
031-764-4498 2
 
1.7%
031-699-8118 2
 
1.7%
031-767-7611 2
 
1.7%
031-798-3360 2
 
1.7%
031-766-3057 1
 
0.9%
031-766-1334 1
 
0.9%
031-766-1318 1
 
0.9%
031-797-2408 1
 
0.9%
031-767-1900 1
 
0.9%
031-715-6169 1
 
0.9%
Other values (101) 101
87.8%
2024-04-21T23:49:30.775654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 230
16.6%
1 186
13.4%
7 182
13.1%
0 173
12.5%
3 158
11.4%
6 139
10.0%
8 81
 
5.8%
9 70
 
5.1%
2 66
 
4.8%
5 52
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1155
83.4%
Dash Punctuation 230
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 186
16.1%
7 182
15.8%
0 173
15.0%
3 158
13.7%
6 139
12.0%
8 81
7.0%
9 70
 
6.1%
2 66
 
5.7%
5 52
 
4.5%
4 48
 
4.2%
Dash Punctuation
ValueCountFrequency (%)
- 230
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1385
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 230
16.6%
1 186
13.4%
7 182
13.1%
0 173
12.5%
3 158
11.4%
6 139
10.0%
8 81
 
5.8%
9 70
 
5.1%
2 66
 
4.8%
5 52
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1385
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 230
16.6%
1 186
13.4%
7 182
13.1%
0 173
12.5%
3 158
11.4%
6 139
10.0%
8 81
 
5.8%
9 70
 
5.1%
2 66
 
4.8%
5 52
 
3.8%

약국소재지(도로명)
Text

Distinct113
Distinct (%)96.6%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2024-04-21T23:49:31.855714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length36
Mean length23.495726
Min length14

Characters and Unicode

Total characters2749
Distinct characters134
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

Unique109 ?
Unique (%)93.2%

Sample

1st row경기도 광주시 경안로 20 (경안동)
2nd row경기도 광주시 양벌로 197
3rd row경기도 광주시 퇴촌면 광동로 75-1
4th row경기도 광주시 초월읍 산수로 568, A동
5th row경기도 광주시 고불로 58 (중대동)
ValueCountFrequency (%)
경기도 117
18.0%
광주시 117
18.0%
1층 33
 
5.1%
중앙로 19
 
2.9%
경안동 19
 
2.9%
초월읍 14
 
2.2%
태전동 12
 
1.8%
곤지암읍 11
 
1.7%
신현로 9
 
1.4%
경충대로 8
 
1.2%
Other values (193) 290
44.7%
2024-04-21T23:49:33.202431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
533
19.4%
경 150
 
5.5%
1 134
 
4.9%
광 128
 
4.7%
주 125
 
4.5%
도 120
 
4.4%
시 118
 
4.3%
기 117
 
4.3%
로 108
 
3.9%
동 68
 
2.5%
Other values (124) 1148
41.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1570
57.1%
Space Separator 533
 
19.4%
Decimal Number 441
 
16.0%
Close Punctuation 61
 
2.2%
Open Punctuation 61
 
2.2%
Other Punctuation 57
 
2.1%
Dash Punctuation 19
 
0.7%
Uppercase Letter 7
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
경 150
 
9.6%
광 128
 
8.2%
주 125
 
8.0%
도 120
 
7.6%
시 118
 
7.5%
기 117
 
7.5%
로 108
 
6.9%
동 68
 
4.3%
층 35
 
2.2%
읍 31
 
2.0%
Other values (105) 570
36.3%
Decimal Number
ValueCountFrequency (%)
1 134
30.4%
0 58
13.2%
3 47
 
10.7%
2 45
 
10.2%
5 34
 
7.7%
4 34
 
7.7%
6 27
 
6.1%
9 22
 
5.0%
8 21
 
4.8%
7 19
 
4.3%
Uppercase Letter
ValueCountFrequency (%)
A 3
42.9%
B 2
28.6%
C 1
 
14.3%
M 1
 
14.3%
Space Separator
ValueCountFrequency (%)
533
100.0%
Close Punctuation
ValueCountFrequency (%)
) 61
100.0%
Open Punctuation
ValueCountFrequency (%)
( 61
100.0%
Other Punctuation
ValueCountFrequency (%)
, 57
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 19
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1570
57.1%
Common 1172
42.6%
Latin 7
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
경 150
 
9.6%
광 128
 
8.2%
주 125
 
8.0%
도 120
 
7.6%
시 118
 
7.5%
기 117
 
7.5%
로 108
 
6.9%
동 68
 
4.3%
층 35
 
2.2%
읍 31
 
2.0%
Other values (105) 570
36.3%
Common
ValueCountFrequency (%)
533
45.5%
1 134
 
11.4%
) 61
 
5.2%
( 61
 
5.2%
0 58
 
4.9%
, 57
 
4.9%
3 47
 
4.0%
2 45
 
3.8%
5 34
 
2.9%
4 34
 
2.9%
Other values (5) 108
 
9.2%
Latin
ValueCountFrequency (%)
A 3
42.9%
B 2
28.6%
C 1
 
14.3%
M 1
 
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1570
57.1%
ASCII 1179
42.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
533
45.2%
1 134
 
11.4%
) 61
 
5.2%
( 61
 
5.2%
0 58
 
4.9%
, 57
 
4.8%
3 47
 
4.0%
2 45
 
3.8%
5 34
 
2.9%
4 34
 
2.9%
Other values (9) 115
 
9.8%
Hangul
ValueCountFrequency (%)
경 150
 
9.6%
광 128
 
8.2%
주 125
 
8.0%
도 120
 
7.6%
시 118
 
7.5%
기 117
 
7.5%
로 108
 
6.9%
동 68
 
4.3%
층 35
 
2.2%
읍 31
 
2.0%
Other values (105) 570
36.3%

Missing values

2024-04-21T23:49:26.204278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T23:49:26.439512image/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감초당약국031-761-2840경기도 광주시 경안로 20 (경안동)
1건강약국070-8714-0360경기도 광주시 양벌로 197
2건강온누리약국031-765-8925경기도 광주시 퇴촌면 광동로 75-1
3건강한 우리약국031-798-2888경기도 광주시 초월읍 산수로 568, A동
4경기약국031-765-8562경기도 광주시 고불로 58 (중대동)
5경안약국031-761-4144경기도 광주시 중앙로 156 (경안동)
6곤지암약국031-763-0678경기도 광주시 곤지암읍 곤지암로 42
7광주온누리약국031-761-2229경기도 광주시 중앙로 110, 1층 (경안동)
8광주종로약국031-766-6663경기도 광주시 고불로 113, 1층 (태전동)
9광주태평양약국031-798-6240경기도 광주시 중앙로 101, 클리닉빌딩 제1층 103,104호 (경안동)
약국명칭약국전화번호약국소재지(도로명)
107평화약국031-768-5952경기도 광주시 중앙로 85, 1층 (역동, 신흥빌딩)
108푸른약국031-798-0326경기도 광주시 이배재로 120 (회덕동, 신주빌딩)
109하나약국031-765-0199경기도 광주시 경충대로1422번길 12-1, 104호 (쌍령동, 동성CMA상가)
110하늘약국031-765-9152경기도 광주시 양벌로 332, 1층
111하얀약국031-766-0711경기도 광주시 광주대로 49-21 (경안동)
112한결약국031-797-6109경기도 광주시 중앙로 340 (송정동)
113한빛약국031-762-0039경기도 광주시 초월읍 경충대로 926, 1층
114한솔약국031-766-6822경기도 광주시 초월읍 경충대로 1260
115한아람약국031-8028-4059경기도 광주시 태전중앙로 20, 101호 (태전동)
116햇살약국031-797-2184경기도 광주시 태봉로 51, 313호 (태전동, 성원프라자)

Duplicate rows

Most frequently occurring

약국명칭약국전화번호약국소재지(도로명)# duplicates
0늘품약국031-699-8118경기도 광주시 경충대로1480번길 5, 1층 101호 (쌍령동)2
1바다약국031-767-7611경기도 광주시 초월읍 현산로 902
2서울보룡약국031-764-4498경기도 광주시 중앙로 113 (경안동)2
3오렌지약국031-798-3360경기도 광주시 중앙로 95-3 (역동)2