Overview

Dataset statistics

Number of variables5
Number of observations385
Missing cells9
Missing cells (%)0.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory15.5 KiB
Average record size in memory41.3 B

Variable types

Numeric1
Text3
Categorical1

Dataset

Description경기도 부천시 관내의 약국현황으로 약국명칭, 약국소재지주소(도로명), 소재지 전화번호 등의 정보를 제공하고 있습니다.
URLhttps://www.data.go.kr/data/15051087/fileData.do

Alerts

약국구분 is highly imbalanced (82.6%)Imbalance
약국전화번호 has 9 (2.3%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 06:43:03.815221
Analysis finished2023-12-12 06:43:04.501963
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct385
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean193
Minimum1
Maximum385
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.5 KiB
2023-12-12T15:43:04.598188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile20.2
Q197
median193
Q3289
95-th percentile365.8
Maximum385
Range384
Interquartile range (IQR)192

Descriptive statistics

Standard deviation111.28417
Coefficient of variation (CV)0.57660192
Kurtosis-1.2
Mean193
Median Absolute Deviation (MAD)96
Skewness0
Sum74305
Variance12384.167
MonotonicityStrictly increasing
2023-12-12T15:43:04.777989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
290 1
 
0.3%
264 1
 
0.3%
263 1
 
0.3%
262 1
 
0.3%
261 1
 
0.3%
260 1
 
0.3%
259 1
 
0.3%
258 1
 
0.3%
257 1
 
0.3%
Other values (375) 375
97.4%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
385 1
0.3%
384 1
0.3%
383 1
0.3%
382 1
0.3%
381 1
0.3%
380 1
0.3%
379 1
0.3%
378 1
0.3%
377 1
0.3%
376 1
0.3%

약국명칭
Text

Distinct378
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
2023-12-12T15:43:05.066971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length10
Mean length5.1844156
Min length3

Characters and Unicode

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

Unique

Unique371 ?
Unique (%)96.4%

Sample

1st row맑은약국
2nd row세븐약국
3rd row건강백세약국
4th row가까운약국
5th row이강약국
ValueCountFrequency (%)
굿모닝약국 2
 
0.5%
중앙약국 2
 
0.5%
하늘약국 2
 
0.5%
비타민약국 2
 
0.5%
한빛약국 2
 
0.5%
미소약국 2
 
0.5%
우리온누리약국 2
 
0.5%
로즈팜약국 1
 
0.3%
편한약국 1
 
0.3%
우정약국 1
 
0.3%
Other values (369) 369
95.6%
2023-12-12T15:43:05.481540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 391
19.6%
국 385
19.3%
리 55
 
2.8%
온 39
 
2.0%
누 39
 
2.0%
한 32
 
1.6%
동 31
 
1.6%
사 25
 
1.3%
메 25
 
1.3%
디 24
 
1.2%
Other values (227) 950
47.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1983
99.3%
Decimal Number 11
 
0.6%
Other Punctuation 1
 
0.1%
Space Separator 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 391
19.7%
국 385
19.4%
리 55
 
2.8%
온 39
 
2.0%
누 39
 
2.0%
한 32
 
1.6%
동 31
 
1.6%
사 25
 
1.3%
메 25
 
1.3%
디 24
 
1.2%
Other values (218) 937
47.3%
Decimal Number
ValueCountFrequency (%)
1 2
18.2%
0 2
18.2%
5 2
18.2%
3 2
18.2%
6 1
9.1%
9 1
9.1%
2 1
9.1%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1983
99.3%
Common 13
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 391
19.7%
국 385
19.4%
리 55
 
2.8%
온 39
 
2.0%
누 39
 
2.0%
한 32
 
1.6%
동 31
 
1.6%
사 25
 
1.3%
메 25
 
1.3%
디 24
 
1.2%
Other values (218) 937
47.3%
Common
ValueCountFrequency (%)
1 2
15.4%
0 2
15.4%
5 2
15.4%
3 2
15.4%
& 1
7.7%
6 1
7.7%
1
7.7%
9 1
7.7%
2 1
7.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1983
99.3%
ASCII 13
 
0.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 391
19.7%
국 385
19.4%
리 55
 
2.8%
온 39
 
2.0%
누 39
 
2.0%
한 32
 
1.6%
동 31
 
1.6%
사 25
 
1.3%
메 25
 
1.3%
디 24
 
1.2%
Other values (218) 937
47.3%
ASCII
ValueCountFrequency (%)
1 2
15.4%
0 2
15.4%
5 2
15.4%
3 2
15.4%
& 1
7.7%
6 1
7.7%
1
7.7%
9 1
7.7%
2 1
7.7%

약국전화번호
Text

MISSING 

Distinct376
Distinct (%)100.0%
Missing9
Missing (%)2.3%
Memory size3.1 KiB
2023-12-12T15:43:05.832163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.018617
Min length12

Characters and Unicode

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

Unique376 ?
Unique (%)100.0%

Sample

1st row032-325-2003
2nd row032-612-1203
3rd row032-678-8133
4th row032-322-8593
5th row032-342-2428
ValueCountFrequency (%)
032-715-9636 1
 
0.3%
032-343-7494 1
 
0.3%
032-323-4809 1
 
0.3%
032-661-5001 1
 
0.3%
032-661-8873 1
 
0.3%
032-524-2221 1
 
0.3%
032-683-7133 1
 
0.3%
032-351-4750 1
 
0.3%
032-683-5222 1
 
0.3%
032-612-6771 1
 
0.3%
Other values (366) 366
97.3%
2023-12-12T15:43:06.339982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 752
16.6%
3 740
16.4%
2 665
14.7%
0 595
13.2%
6 395
8.7%
1 290
 
6.4%
7 283
 
6.3%
5 229
 
5.1%
4 224
 
5.0%
8 206
 
4.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 3767
83.4%
Dash Punctuation 752
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 740
19.6%
2 665
17.7%
0 595
15.8%
6 395
10.5%
1 290
 
7.7%
7 283
 
7.5%
5 229
 
6.1%
4 224
 
5.9%
8 206
 
5.5%
9 140
 
3.7%
Dash Punctuation
ValueCountFrequency (%)
- 752
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 4519
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 752
16.6%
3 740
16.4%
2 665
14.7%
0 595
13.2%
6 395
8.7%
1 290
 
6.4%
7 283
 
6.3%
5 229
 
5.1%
4 224
 
5.0%
8 206
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4519
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 752
16.6%
3 740
16.4%
2 665
14.7%
0 595
13.2%
6 395
8.7%
1 290
 
6.4%
7 283
 
6.3%
5 229
 
5.1%
4 224
 
5.0%
8 206
 
4.6%

약국소재지(도로명)
Text

Distinct384
Distinct (%)99.7%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
2023-12-12T15:43:06.717475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length63
Median length41
Mean length29.241558
Min length19

Characters and Unicode

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

Unique

Unique383 ?
Unique (%)99.5%

Sample

1st row경기도 부천시 길주로 272 코스모폴리탄 5층 513호 (중동)
2nd row경기도 부천시 상동로 87 가나베스트타운 쓰리 7층 706호 (상동)
3rd row경기도 부천시 부천로 17 1층 (심곡동)
4th row경기도 부천시 수도로 202 은성프라자 1층 일부호 (도당동)
5th row경기도 부천시 석천로 171 중동프라자 1층 112호 (중동)
ValueCountFrequency (%)
경기도 385
 
15.7%
부천시 385
 
15.7%
1층 91
 
3.7%
중동 75
 
3.0%
상동 50
 
2.0%
소사로 36
 
1.5%
경인로 35
 
1.4%
원종동 33
 
1.3%
소사본동 29
 
1.2%
길주로 27
 
1.1%
Other values (619) 1314
53.4%
2023-12-12T15:43:07.259599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2447
21.7%
1 518
 
4.6%
부 491
 
4.4%
동 444
 
3.9%
경 434
 
3.9%
천 432
 
3.8%
도 403
 
3.6%
로 391
 
3.5%
시 389
 
3.5%
) 387
 
3.4%
Other values (245) 4922
43.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6055
53.8%
Space Separator 2447
21.7%
Decimal Number 1912
 
17.0%
Close Punctuation 387
 
3.4%
Open Punctuation 387
 
3.4%
Uppercase Letter 33
 
0.3%
Dash Punctuation 24
 
0.2%
Lowercase Letter 10
 
0.1%
Math Symbol 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
부 491
 
8.1%
동 444
 
7.3%
경 434
 
7.2%
천 432
 
7.1%
도 403
 
6.7%
로 391
 
6.5%
시 389
 
6.4%
기 385
 
6.4%
호 193
 
3.2%
층 127
 
2.1%
Other values (206) 2366
39.1%
Uppercase Letter
ValueCountFrequency (%)
A 5
15.2%
B 4
12.1%
T 3
 
9.1%
G 2
 
6.1%
R 2
 
6.1%
I 2
 
6.1%
N 2
 
6.1%
C 2
 
6.1%
V 2
 
6.1%
D 1
 
3.0%
Other values (8) 8
24.2%
Decimal Number
ValueCountFrequency (%)
1 518
27.1%
0 276
14.4%
2 260
13.6%
3 165
 
8.6%
4 144
 
7.5%
7 135
 
7.1%
5 120
 
6.3%
8 113
 
5.9%
9 96
 
5.0%
6 85
 
4.4%
Lowercase Letter
ValueCountFrequency (%)
n 3
30.0%
e 2
20.0%
o 2
20.0%
c 1
 
10.0%
t 1
 
10.0%
r 1
 
10.0%
Space Separator
ValueCountFrequency (%)
2447
100.0%
Close Punctuation
ValueCountFrequency (%)
) 387
100.0%
Open Punctuation
ValueCountFrequency (%)
( 387
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 24
100.0%
Math Symbol
ValueCountFrequency (%)
~ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6055
53.8%
Common 5160
45.8%
Latin 43
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
부 491
 
8.1%
동 444
 
7.3%
경 434
 
7.2%
천 432
 
7.1%
도 403
 
6.7%
로 391
 
6.5%
시 389
 
6.4%
기 385
 
6.4%
호 193
 
3.2%
층 127
 
2.1%
Other values (206) 2366
39.1%
Latin
ValueCountFrequency (%)
A 5
 
11.6%
B 4
 
9.3%
T 3
 
7.0%
n 3
 
7.0%
G 2
 
4.7%
R 2
 
4.7%
I 2
 
4.7%
N 2
 
4.7%
C 2
 
4.7%
e 2
 
4.7%
Other values (14) 16
37.2%
Common
ValueCountFrequency (%)
2447
47.4%
1 518
 
10.0%
) 387
 
7.5%
( 387
 
7.5%
0 276
 
5.3%
2 260
 
5.0%
3 165
 
3.2%
4 144
 
2.8%
7 135
 
2.6%
5 120
 
2.3%
Other values (5) 321
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6055
53.8%
ASCII 5203
46.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2447
47.0%
1 518
 
10.0%
) 387
 
7.4%
( 387
 
7.4%
0 276
 
5.3%
2 260
 
5.0%
3 165
 
3.2%
4 144
 
2.8%
7 135
 
2.6%
5 120
 
2.3%
Other values (29) 364
 
7.0%
Hangul
ValueCountFrequency (%)
부 491
 
8.1%
동 444
 
7.3%
경 434
 
7.2%
천 432
 
7.1%
도 403
 
6.7%
로 391
 
6.5%
시 389
 
6.4%
기 385
 
6.4%
호 193
 
3.2%
층 127
 
2.1%
Other values (206) 2366
39.1%

약국구분
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
약국
375 
한약국
 
10

Length

Max length3
Median length2
Mean length2.025974
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row약국
2nd row약국
3rd row약국
4th row약국
5th row약국

Common Values

ValueCountFrequency (%)
약국 375
97.4%
한약국 10
 
2.6%

Length

2023-12-12T15:43:07.422552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:43:07.517995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 375
97.4%
한약국 10
 
2.6%

Interactions

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

Correlations

2023-12-12T15:43:07.576266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번약국구분
순번1.0000.000
약국구분0.0001.000
2023-12-12T15:43:07.650198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번약국구분
순번1.0000.000
약국구분0.0001.000

Missing values

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

순번약국명칭약국전화번호약국소재지(도로명)약국구분
01맑은약국032-325-2003경기도 부천시 길주로 272 코스모폴리탄 5층 513호 (중동)약국
12세븐약국<NA>경기도 부천시 상동로 87 가나베스트타운 쓰리 7층 706호 (상동)약국
23건강백세약국032-612-1203경기도 부천시 부천로 17 1층 (심곡동)약국
34가까운약국032-678-8133경기도 부천시 수도로 202 은성프라자 1층 일부호 (도당동)약국
45이강약국032-322-8593경기도 부천시 석천로 171 중동프라자 1층 112호 (중동)약국
56솔약국032-342-2428경기도 부천시 범안로 117 현대리치모아 3층 306호 일부호 (범박동)약국
67힐스우리약국032-719-4700경기도 부천시 길주로 234 203동 1층 1032호 (중동 힐스테이트 중동)약국
78건강돌봄약국032-323-6709경기도 부천시 상동로 81 센타프라자 1층 103호 (상동)약국
89도원온누리약국032-710-9095경기도 부천시 경인로 65 혜영빌딩 1층 일부호 (송내동)약국
910센트럴시티약국032-321-6185경기도 부천시 길주로 181 골든벨타워 1층 101호 (중동)약국
순번약국명칭약국전화번호약국소재지(도로명)약국구분
375376디에스팜약국032-675-2984경기도 부천시 부흥로373번길 6 (심곡동)약국
376377선한약국032-676-5381경기도 부천시 부천로 364 (도당동)약국
377378온누리양지약국032-651-5594경기도 부천시 성주로 74 1층 (송내동)약국
378379신한약국032-664-8203경기도 부천시 성주로 241-2 (심곡본동)약국
379380성신약국032-674-5041경기도 부천시 삼작로 98 (내동)약국
380381김약국032-349-2177경기도 부천시 호현로 444 (소사본동)약국
381382보건약국032-675-4609경기도 부천시 옥산로 156 (도당동)약국
382383명소약국032-651-8468경기도 부천시 경인로 258 (심곡본동)약국
383384우신약국032-651-6524경기도 부천시 원미로 77 1층 1호 (원미동)약국
384385중앙약국032-651-5118경기도 부천시 부천로 124 (원미동)약국