Overview

Dataset statistics

Number of variables4
Number of observations214
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.0 KiB
Average record size in memory33.6 B

Variable types

Numeric1
Text3

Dataset

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

Alerts

순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 06:49:35.112838
Analysis finished2023-12-12 06:49:35.659264
Duration0.55 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct214
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean107.5
Minimum1
Maximum214
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.0 KiB
2023-12-12T15:49:35.735937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile11.65
Q154.25
median107.5
Q3160.75
95-th percentile203.35
Maximum214
Range213
Interquartile range (IQR)106.5

Descriptive statistics

Standard deviation61.920648
Coefficient of variation (CV)0.57600603
Kurtosis-1.2
Mean107.5
Median Absolute Deviation (MAD)53.5
Skewness0
Sum23005
Variance3834.1667
MonotonicityStrictly increasing
2023-12-12T15:49:35.878370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.5%
136 1
 
0.5%
138 1
 
0.5%
139 1
 
0.5%
140 1
 
0.5%
141 1
 
0.5%
142 1
 
0.5%
143 1
 
0.5%
144 1
 
0.5%
145 1
 
0.5%
Other values (204) 204
95.3%
ValueCountFrequency (%)
1 1
0.5%
2 1
0.5%
3 1
0.5%
4 1
0.5%
5 1
0.5%
6 1
0.5%
7 1
0.5%
8 1
0.5%
9 1
0.5%
10 1
0.5%
ValueCountFrequency (%)
214 1
0.5%
213 1
0.5%
212 1
0.5%
211 1
0.5%
210 1
0.5%
209 1
0.5%
208 1
0.5%
207 1
0.5%
206 1
0.5%
205 1
0.5%

약국명칭
Text

Distinct212
Distinct (%)99.1%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-12T15:49:36.162266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length5.271028
Min length3

Characters and Unicode

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

Unique

Unique210 ?
Unique (%)98.1%

Sample

1st rowK마트약국
2nd row혜인온누리약국
3rd row푸른약국
4th row수정약국
5th row옵티마 건강을그리는약국
ValueCountFrequency (%)
약국 4
 
1.8%
사랑약국 2
 
0.9%
하나약국 2
 
0.9%
청학약국 1
 
0.5%
엄마마음약국 1
 
0.5%
365지안약국 1
 
0.5%
우정약국 1
 
0.5%
호호온누리약국 1
 
0.5%
k마트약국 1
 
0.5%
365약국 1
 
0.5%
Other values (205) 205
93.2%
2023-12-12T15:49:36.544474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 215
 
19.1%
국 214
 
19.0%
리 28
 
2.5%
마 22
 
2.0%
누 17
 
1.5%
온 17
 
1.5%
한 16
 
1.4%
내 15
 
1.3%
이 11
 
1.0%
평 11
 
1.0%
Other values (189) 562
49.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1099
97.4%
Decimal Number 18
 
1.6%
Space Separator 6
 
0.5%
Other Punctuation 2
 
0.2%
Uppercase Letter 1
 
0.1%
Dash Punctuation 1
 
0.1%
Lowercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 215
19.6%
국 214
19.5%
리 28
 
2.5%
마 22
 
2.0%
누 17
 
1.5%
온 17
 
1.5%
한 16
 
1.5%
내 15
 
1.4%
이 11
 
1.0%
평 11
 
1.0%
Other values (179) 533
48.5%
Decimal Number
ValueCountFrequency (%)
3 6
33.3%
5 4
22.2%
6 4
22.2%
2 2
 
11.1%
1 2
 
11.1%
Space Separator
ValueCountFrequency (%)
6
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%
Uppercase Letter
ValueCountFrequency (%)
K 1
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1099
97.4%
Common 27
 
2.4%
Latin 2
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 215
19.6%
국 214
19.5%
리 28
 
2.5%
마 22
 
2.0%
누 17
 
1.5%
온 17
 
1.5%
한 16
 
1.5%
내 15
 
1.4%
이 11
 
1.0%
평 11
 
1.0%
Other values (179) 533
48.5%
Common
ValueCountFrequency (%)
3 6
22.2%
6
22.2%
5 4
14.8%
6 4
14.8%
2 2
 
7.4%
1 2
 
7.4%
, 2
 
7.4%
- 1
 
3.7%
Latin
ValueCountFrequency (%)
K 1
50.0%
e 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1099
97.4%
ASCII 29
 
2.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 215
19.6%
국 214
19.5%
리 28
 
2.5%
마 22
 
2.0%
누 17
 
1.5%
온 17
 
1.5%
한 16
 
1.5%
내 15
 
1.4%
이 11
 
1.0%
평 11
 
1.0%
Other values (179) 533
48.5%
ASCII
ValueCountFrequency (%)
3 6
20.7%
6
20.7%
5 4
13.8%
6 4
13.8%
2 2
 
6.9%
1 2
 
6.9%
, 2
 
6.9%
K 1
 
3.4%
- 1
 
3.4%
e 1
 
3.4%

약국전화번호
Text

Distinct213
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-12T15:49:36.802070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.037383
Min length12

Characters and Unicode

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

Unique212 ?
Unique (%)99.1%

Sample

1st row031-595-4703
2nd row031-521-4646
3rd row031-523-2088
4th row031-592-5288
5th row031-591-3675
ValueCountFrequency (%)
031-527-0081 2
 
0.9%
031-595-3999 1
 
0.5%
031-574-7639 1
 
0.5%
031-527-9284 1
 
0.5%
031-528-5783 1
 
0.5%
031-572-1155 1
 
0.5%
031-528-7273 1
 
0.5%
070-4413-2767 1
 
0.5%
031-574-0088 1
 
0.5%
031-574-9557 1
 
0.5%
Other values (203) 203
94.9%
2023-12-12T15:49:37.188250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 428
16.6%
1 351
13.6%
5 348
13.5%
0 318
12.3%
3 311
12.1%
7 231
9.0%
2 150
 
5.8%
9 131
 
5.1%
8 120
 
4.7%
4 105
 
4.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2148
83.4%
Dash Punctuation 428
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 351
16.3%
5 348
16.2%
0 318
14.8%
3 311
14.5%
7 231
10.8%
2 150
7.0%
9 131
 
6.1%
8 120
 
5.6%
4 105
 
4.9%
6 83
 
3.9%
Dash Punctuation
ValueCountFrequency (%)
- 428
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2576
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 428
16.6%
1 351
13.6%
5 348
13.5%
0 318
12.3%
3 311
12.1%
7 231
9.0%
2 150
 
5.8%
9 131
 
5.1%
8 120
 
4.7%
4 105
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2576
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 428
16.6%
1 351
13.6%
5 348
13.5%
0 318
12.3%
3 311
12.1%
7 231
9.0%
2 150
 
5.8%
9 131
 
5.1%
8 120
 
4.7%
4 105
 
4.1%

약국소재지(도로명)
Text

Distinct213
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-12T15:49:37.530733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length40
Mean length29.82243
Min length19

Characters and Unicode

Total characters6382
Distinct characters191
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

Unique212 ?
Unique (%)99.1%

Sample

1st row경기도 남양주시 늘을1로 286, 107호 (호평동)
2nd row경기도 남양주시 와부읍 덕소로97번길 15-3
3rd row경기도 남양주시 화도읍 비룡로 341
4th row경기도 남양주시 경춘로 986 (금곡동)
5th row경기도 남양주시 경춘로양골1길 13 (금곡동)
ValueCountFrequency (%)
경기도 214
 
16.2%
남양주시 214
 
16.2%
진접읍 39
 
3.0%
1층 31
 
2.3%
화도읍 30
 
2.3%
와부읍 22
 
1.7%
다산동 19
 
1.4%
오남읍 19
 
1.4%
별내동 16
 
1.2%
진건오남로 16
 
1.2%
Other values (362) 700
53.0%
2023-12-12T15:49:38.042031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1108
 
17.4%
1 314
 
4.9%
도 256
 
4.0%
남 254
 
4.0%
경 238
 
3.7%
양 221
 
3.5%
시 221
 
3.5%
로 219
 
3.4%
주 218
 
3.4%
기 214
 
3.4%
Other values (181) 3119
48.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3688
57.8%
Space Separator 1108
 
17.4%
Decimal Number 1102
 
17.3%
Other Punctuation 194
 
3.0%
Close Punctuation 121
 
1.9%
Open Punctuation 121
 
1.9%
Dash Punctuation 41
 
0.6%
Uppercase Letter 7
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 256
 
6.9%
남 254
 
6.9%
경 238
 
6.5%
양 221
 
6.0%
시 221
 
6.0%
로 219
 
5.9%
주 218
 
5.9%
기 214
 
5.8%
호 132
 
3.6%
읍 120
 
3.3%
Other values (161) 1595
43.2%
Decimal Number
ValueCountFrequency (%)
1 314
28.5%
0 141
12.8%
2 129
11.7%
3 108
 
9.8%
4 89
 
8.1%
5 75
 
6.8%
6 68
 
6.2%
9 65
 
5.9%
8 57
 
5.2%
7 56
 
5.1%
Uppercase Letter
ValueCountFrequency (%)
A 2
28.6%
H 2
28.6%
C 2
28.6%
M 1
14.3%
Other Punctuation
ValueCountFrequency (%)
, 193
99.5%
. 1
 
0.5%
Space Separator
ValueCountFrequency (%)
1108
100.0%
Close Punctuation
ValueCountFrequency (%)
) 121
100.0%
Open Punctuation
ValueCountFrequency (%)
( 121
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 41
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3688
57.8%
Common 2687
42.1%
Latin 7
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 256
 
6.9%
남 254
 
6.9%
경 238
 
6.5%
양 221
 
6.0%
시 221
 
6.0%
로 219
 
5.9%
주 218
 
5.9%
기 214
 
5.8%
호 132
 
3.6%
읍 120
 
3.3%
Other values (161) 1595
43.2%
Common
ValueCountFrequency (%)
1108
41.2%
1 314
 
11.7%
, 193
 
7.2%
0 141
 
5.2%
2 129
 
4.8%
) 121
 
4.5%
( 121
 
4.5%
3 108
 
4.0%
4 89
 
3.3%
5 75
 
2.8%
Other values (6) 288
 
10.7%
Latin
ValueCountFrequency (%)
A 2
28.6%
H 2
28.6%
C 2
28.6%
M 1
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3688
57.8%
ASCII 2694
42.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1108
41.1%
1 314
 
11.7%
, 193
 
7.2%
0 141
 
5.2%
2 129
 
4.8%
) 121
 
4.5%
( 121
 
4.5%
3 108
 
4.0%
4 89
 
3.3%
5 75
 
2.8%
Other values (10) 295
 
11.0%
Hangul
ValueCountFrequency (%)
도 256
 
6.9%
남 254
 
6.9%
경 238
 
6.5%
양 221
 
6.0%
시 221
 
6.0%
로 219
 
5.9%
주 218
 
5.9%
기 214
 
5.8%
호 132
 
3.6%
읍 120
 
3.3%
Other values (161) 1595
43.2%

Interactions

2023-12-12T15:49:35.395334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T15:49:35.520252image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T15:49:35.614992image/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

순번약국명칭약국전화번호약국소재지(도로명)
01K마트약국031-595-4703경기도 남양주시 늘을1로 286, 107호 (호평동)
12혜인온누리약국031-521-4646경기도 남양주시 와부읍 덕소로97번길 15-3
23푸른약국031-523-2088경기도 남양주시 화도읍 비룡로 341
34수정약국031-592-5288경기도 남양주시 경춘로 986 (금곡동)
45옵티마 건강을그리는약국031-591-3675경기도 남양주시 경춘로양골1길 13 (금곡동)
56덕소우리약국031-577-7852경기도 남양주시 와부읍 덕소로97번길 2 (동산빌딩)
67메디약국031-593-1902경기도 남양주시 경춘로 1511 (호평동, 메디피아클리닉)
78아이파크 온누리 약국031-577-0575경기도 남양주시 와부읍 덕소로97번길 80 (덕소아이파크)
89월산약국031-593-7275경기도 남양주시 화도읍 경춘로2248번길 15, 103호 (남양주월산사랑으로부영1단지)
910정다운약국031-511-7092경기도 남양주시 화도읍 경춘로 1943-6, 1층
순번약국명칭약국전화번호약국소재지(도로명)
204205청학e-조은약국031-847-4954경기도 남양주시 별내면 청학로68번길 13 (삼화빌딩 1층)
205206온누리양지약국031-574-2878경기도 남양주시 오남읍 진건오남로 792
206207대학약국031-574-3069경기도 남양주시 진접읍 광릉내로 108
207208오남현대약국031-573-8022경기도 남양주시 오남읍 진건오남로 664
20820921세기청학보건당약국031-821-1653경기도 남양주시 별내면 청학로중앙길 9 (청화빌딩 1층)
209210청학약국031-841-0554경기도 남양주시 별내면 청학로114번길 10
210211내각리연세약국031-572-9100경기도 남양주시 진접읍 내각1로 59
211212소리약국031-527-2261경기도 남양주시 진접읍 금강로 1445, 1층
212213에스온누리약국031-528-9873경기도 남양주시 진접읍 금강로 1524, 1층
213214별내종로약국031-527-0081경기도 남양주시 별내중앙로 63, 106호 (별내동, 예스프라자)