Overview

Dataset statistics

Number of variables4
Number of observations199
Missing cells11
Missing cells (%)1.4%
Duplicate rows2
Duplicate rows (%)1.0%
Total size in memory6.3 KiB
Average record size in memory32.7 B

Variable types

Text3
DateTime1

Dataset

Description인천광역시 서구 내에 위치한 약국의 현황 (약국명, 소재지, 약국 전화번호 등의 정보) 에 관하여 데이터를 제공합니다.
Author공공데이터포털
URLhttps://www.data.go.kr/data/3044223/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 2 (1.0%) duplicate rowsDuplicates
전화번호 has 8 (4.0%) missing valuesMissing

Reproduction

Analysis started2024-04-17 11:12:17.021148
Analysis finished2024-04-17 11:12:17.456045
Duration0.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약국명
Text

Distinct195
Distinct (%)98.5%
Missing1
Missing (%)0.5%
Memory size1.7 KiB
2024-04-17T20:12:17.609304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length9
Mean length5.4141414
Min length3

Characters and Unicode

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

Unique

Unique192 ?
Unique (%)97.0%

Sample

1st row검단센트럴약국
2nd row수린온누리약국
3rd row소소약국
4th row루원봄약국
5th row365검단우리약국
ValueCountFrequency (%)
365검단우리약국 2
 
1.0%
행복한약국 2
 
1.0%
백제당약국 2
 
1.0%
조은약국 2
 
1.0%
이도온누리약국 1
 
0.5%
한샘약국 1
 
0.5%
원당우리약국 1
 
0.5%
한솔약국 1
 
0.5%
검단센트럴약국 1
 
0.5%
사랑온누리약국 1
 
0.5%
Other values (185) 185
93.0%
2024-04-17T20:12:17.930200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 199
 
18.6%
국 199
 
18.6%
리 29
 
2.7%
누 21
 
2.0%
온 20
 
1.9%
한 18
 
1.7%
라 16
 
1.5%
메 15
 
1.4%
디 15
 
1.4%
단 13
 
1.2%
Other values (179) 527
49.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1047
97.7%
Decimal Number 20
 
1.9%
Uppercase Letter 2
 
0.2%
Close Punctuation 1
 
0.1%
Space Separator 1
 
0.1%
Open Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 199
 
19.0%
국 199
 
19.0%
리 29
 
2.8%
누 21
 
2.0%
온 20
 
1.9%
한 18
 
1.7%
라 16
 
1.5%
메 15
 
1.4%
디 15
 
1.4%
단 13
 
1.2%
Other values (168) 502
47.9%
Decimal Number
ValueCountFrequency (%)
3 6
30.0%
6 5
25.0%
5 5
25.0%
0 2
 
10.0%
1 1
 
5.0%
4 1
 
5.0%
Uppercase Letter
ValueCountFrequency (%)
K 1
50.0%
S 1
50.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1047
97.7%
Common 23
 
2.1%
Latin 2
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 199
 
19.0%
국 199
 
19.0%
리 29
 
2.8%
누 21
 
2.0%
온 20
 
1.9%
한 18
 
1.7%
라 16
 
1.5%
메 15
 
1.4%
디 15
 
1.4%
단 13
 
1.2%
Other values (168) 502
47.9%
Common
ValueCountFrequency (%)
3 6
26.1%
6 5
21.7%
5 5
21.7%
0 2
 
8.7%
1 1
 
4.3%
) 1
 
4.3%
1
 
4.3%
4 1
 
4.3%
( 1
 
4.3%
Latin
ValueCountFrequency (%)
K 1
50.0%
S 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1047
97.7%
ASCII 25
 
2.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 199
 
19.0%
국 199
 
19.0%
리 29
 
2.8%
누 21
 
2.0%
온 20
 
1.9%
한 18
 
1.7%
라 16
 
1.5%
메 15
 
1.4%
디 15
 
1.4%
단 13
 
1.2%
Other values (168) 502
47.9%
ASCII
ValueCountFrequency (%)
3 6
24.0%
6 5
20.0%
5 5
20.0%
0 2
 
8.0%
1 1
 
4.0%
) 1
 
4.0%
1
 
4.0%
K 1
 
4.0%
S 1
 
4.0%
4 1
 
4.0%

소재지
Text

Distinct196
Distinct (%)99.0%
Missing1
Missing (%)0.5%
Memory size1.7 KiB
2024-04-17T20:12:18.177449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length57
Median length43
Mean length32.136364
Min length21

Characters and Unicode

Total characters6363
Distinct characters234
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

Unique194 ?
Unique (%)98.0%

Sample

1st row인천광역시 서구 이음3로 149, 위너스프라자 104호 (당하동)
2nd row인천광역시 서구 크리스탈로102번길 8-12, 수린빌딩 102,103호 (청라동)
3rd row인천광역시 서구 장고개로 285, 104호 (가좌동)
4th row인천광역시 서구 봉오대로 255, 104,105호 (가정동)
5th row인천광역시 서구 발산로5번길 12, 인천검단 엔젤리움1차 윈팰리스 107호 (원당동)
ValueCountFrequency (%)
인천광역시 198
 
15.4%
서구 198
 
15.4%
1층 33
 
2.6%
가좌동 27
 
2.1%
가정로 27
 
2.1%
석남동 25
 
2.0%
청라동 22
 
1.7%
가정동 20
 
1.6%
당하동 16
 
1.2%
원당동 14
 
1.1%
Other values (400) 702
54.8%
2024-04-17T20:12:18.585402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1084
 
17.0%
1 309
 
4.9%
, 220
 
3.5%
서 217
 
3.4%
로 210
 
3.3%
동 207
 
3.3%
시 205
 
3.2%
인 204
 
3.2%
천 203
 
3.2%
) 198
 
3.1%
Other values (224) 3306
52.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3507
55.1%
Space Separator 1084
 
17.0%
Decimal Number 1077
 
16.9%
Other Punctuation 223
 
3.5%
Close Punctuation 198
 
3.1%
Open Punctuation 198
 
3.1%
Uppercase Letter 35
 
0.6%
Dash Punctuation 20
 
0.3%
Lowercase Letter 18
 
0.3%
Math Symbol 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 217
 
6.2%
로 210
 
6.0%
동 207
 
5.9%
시 205
 
5.8%
인 204
 
5.8%
천 203
 
5.8%
구 198
 
5.6%
광 198
 
5.6%
역 198
 
5.6%
호 124
 
3.5%
Other values (191) 1543
44.0%
Uppercase Letter
ValueCountFrequency (%)
S 6
17.1%
B 5
14.3%
K 4
11.4%
E 4
11.4%
L 3
8.6%
V 3
8.6%
I 3
8.6%
W 3
8.6%
M 2
 
5.7%
A 1
 
2.9%
Decimal Number
ValueCountFrequency (%)
1 309
28.7%
0 162
15.0%
3 110
 
10.2%
2 97
 
9.0%
4 76
 
7.1%
8 71
 
6.6%
5 71
 
6.6%
7 69
 
6.4%
6 59
 
5.5%
9 53
 
4.9%
Lowercase Letter
ValueCountFrequency (%)
e 6
33.3%
a 3
16.7%
d 3
16.7%
s 3
16.7%
r 3
16.7%
Other Punctuation
ValueCountFrequency (%)
, 220
98.7%
' 3
 
1.3%
Space Separator
ValueCountFrequency (%)
1084
100.0%
Close Punctuation
ValueCountFrequency (%)
) 198
100.0%
Open Punctuation
ValueCountFrequency (%)
( 198
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 20
100.0%
Math Symbol
ValueCountFrequency (%)
~ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3507
55.1%
Common 2803
44.1%
Latin 53
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 217
 
6.2%
로 210
 
6.0%
동 207
 
5.9%
시 205
 
5.8%
인 204
 
5.8%
천 203
 
5.8%
구 198
 
5.6%
광 198
 
5.6%
역 198
 
5.6%
호 124
 
3.5%
Other values (191) 1543
44.0%
Common
ValueCountFrequency (%)
1084
38.7%
1 309
 
11.0%
, 220
 
7.8%
) 198
 
7.1%
( 198
 
7.1%
0 162
 
5.8%
3 110
 
3.9%
2 97
 
3.5%
4 76
 
2.7%
8 71
 
2.5%
Other values (7) 278
 
9.9%
Latin
ValueCountFrequency (%)
e 6
11.3%
S 6
11.3%
B 5
 
9.4%
K 4
 
7.5%
E 4
 
7.5%
L 3
 
5.7%
a 3
 
5.7%
d 3
 
5.7%
s 3
 
5.7%
V 3
 
5.7%
Other values (6) 13
24.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3507
55.1%
ASCII 2856
44.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1084
38.0%
1 309
 
10.8%
, 220
 
7.7%
) 198
 
6.9%
( 198
 
6.9%
0 162
 
5.7%
3 110
 
3.9%
2 97
 
3.4%
4 76
 
2.7%
8 71
 
2.5%
Other values (23) 331
 
11.6%
Hangul
ValueCountFrequency (%)
서 217
 
6.2%
로 210
 
6.0%
동 207
 
5.9%
시 205
 
5.8%
인 204
 
5.8%
천 203
 
5.8%
구 198
 
5.6%
광 198
 
5.6%
역 198
 
5.6%
호 124
 
3.5%
Other values (191) 1543
44.0%

전화번호
Text

MISSING 

Distinct190
Distinct (%)99.5%
Missing8
Missing (%)4.0%
Memory size1.7 KiB
2024-04-17T20:12:18.784315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.031414
Min length9

Characters and Unicode

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

Unique189 ?
Unique (%)99.0%

Sample

1st row070-4848-4866
2nd row032-572-0525
3rd row032-563-1486
4th row032-561-3633
5th row032-568-8591
ValueCountFrequency (%)
032-562-3049 2
 
1.0%
032-572-7633 1
 
0.5%
032-567-0344 1
 
0.5%
032-568-5706 1
 
0.5%
032-577-6245 1
 
0.5%
032-563-0605 1
 
0.5%
032-569-7535 1
 
0.5%
032-565-8106 1
 
0.5%
032-562-8050 1
 
0.5%
032-565-3419 1
 
0.5%
Other values (180) 180
94.2%
2024-04-17T20:12:19.116889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 381
16.6%
5 297
12.9%
0 288
12.5%
2 285
12.4%
3 268
11.7%
6 197
8.6%
7 188
8.2%
8 125
 
5.4%
1 109
 
4.7%
9 88
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1917
83.4%
Dash Punctuation 381
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 297
15.5%
0 288
15.0%
2 285
14.9%
3 268
14.0%
6 197
10.3%
7 188
9.8%
8 125
6.5%
1 109
 
5.7%
9 88
 
4.6%
4 72
 
3.8%
Dash Punctuation
ValueCountFrequency (%)
- 381
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2298
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 381
16.6%
5 297
12.9%
0 288
12.5%
2 285
12.4%
3 268
11.7%
6 197
8.6%
7 188
8.2%
8 125
 
5.4%
1 109
 
4.7%
9 88
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2298
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 381
16.6%
5 297
12.9%
0 288
12.5%
2 285
12.4%
3 268
11.7%
6 197
8.6%
7 188
8.2%
8 125
 
5.4%
1 109
 
4.7%
9 88
 
3.8%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing1
Missing (%)0.5%
Memory size1.7 KiB
Minimum2023-08-01 00:00:00
Maximum2023-08-01 00:00:00
2024-04-17T20:12:19.219793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T20:12:19.296218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2024-04-17T20:12:17.262538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-17T20:12:17.330149image/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.
2024-04-17T20:12:17.408660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

약국명소재지전화번호데이터기준일자
0검단센트럴약국인천광역시 서구 이음3로 149, 위너스프라자 104호 (당하동)070-4848-48662023-08-01
1수린온누리약국인천광역시 서구 크리스탈로102번길 8-12, 수린빌딩 102,103호 (청라동)<NA>2023-08-01
2소소약국인천광역시 서구 장고개로 285, 104호 (가좌동)032-572-05252023-08-01
3루원봄약국인천광역시 서구 봉오대로 255, 104,105호 (가정동)032-563-14862023-08-01
4365검단우리약국인천광역시 서구 발산로5번길 12, 인천검단 엔젤리움1차 윈팰리스 107호 (원당동)<NA>2023-08-01
5365검단우리약국인천광역시 서구 발산로5번길 12, 인천검단 엔젤리움1차 윈팰리스 107호 (원당동)<NA>2023-08-01
6시티약국인천광역시 서구 발산로 6, 아인시티 주차타워 113호 (원당동)032-561-36332023-08-01
7박하향약국인천광역시 서구 이음대로 392, 메트로시티 106,107호 (원당동)032-568-85912023-08-01
8루원참조은약국인천광역시 서구 가정로 406, A동 304호 (가정동, 루원지웰시티푸르지오)032-575-77272023-08-01
9튼튼한약국인천광역시 서구 이음대로 479, 104호 (당하동)032-567-12552023-08-01
약국명소재지전화번호데이터기준일자
189한국약국인천광역시 서구 서달로163번길 9 (석남동)032-581-92972023-08-01
190보건약국인천광역시 서구 거북로 104 (석남동, 한승빌딩)032-582-27612023-08-01
191옥신온누리약국인천광역시 서구 고래울로 29 (가좌동)032-577-89632023-08-01
192사랑의약국인천광역시 서구 원적로 96 (가좌동)032-577-42412023-08-01
193청우약국인천광역시 서구 가정로 202 (석남동)032-571-24552023-08-01
194가좌약국인천광역시 서구 건지로318번길 32 (가좌동)032-571-31832023-08-01
195명성약국인천광역시 서구 신진말로 37-1 (가좌동)032-577-65582023-08-01
196자생약국인천광역시 서구 거북로 74-1 (석남동)032-571-60662023-08-01
197늘봄약국인천광역시 서구 길주로136번길 32-1, 1층 (석남동)032-573-60122023-08-01
198<NA><NA><NA><NA>

Duplicate rows

Most frequently occurring

약국명소재지전화번호데이터기준일자# duplicates
0365검단우리약국인천광역시 서구 발산로5번길 12, 인천검단 엔젤리움1차 윈팰리스 107호 (원당동)<NA>2023-08-012
1백제당약국인천광역시 서구 연희로 12, 1층 (연희동)032-562-30492023-08-012