Overview

Dataset statistics

Number of variables3
Number of observations47
Missing cells2
Missing cells (%)1.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.2 KiB
Average record size in memory26.7 B

Variable types

Text3

Dataset

Description부산광역시_중구_약국현황_20221108
Author부산광역시 중구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15026388

Alerts

약국전화번호 has 2 (4.3%) missing valuesMissing
약국명칭 has unique valuesUnique
약국소재지(도로명) has unique valuesUnique

Reproduction

Analysis started2024-04-21 11:13:16.350098
Analysis finished2024-04-21 11:13:17.014526
Duration0.66 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약국명칭
Text

UNIQUE 

Distinct47
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size504.0 B
2024-04-21T20:13:17.669074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length7
Mean length4.8297872
Min length3

Characters and Unicode

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

Unique

Unique47 ?
Unique (%)100.0%

Sample

1st row신중앙약국
2nd row자갈치육일약국
3rd row호호약국
4th row자갈치홍약국
5th row오즈약국
ValueCountFrequency (%)
신중앙약국 1
 
2.1%
심약국 1
 
2.1%
밝은미래약국 1
 
2.1%
우리팜약국 1
 
2.1%
세명약국 1
 
2.1%
성모온누리약국 1
 
2.1%
미래약국 1
 
2.1%
금생약국 1
 
2.1%
참편한약국 1
 
2.1%
늘푸른약국 1
 
2.1%
Other values (37) 37
78.7%
2024-04-21T20:13:18.911572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
국 48
21.1%
약 47
20.7%
일 6
 
2.6%
한 6
 
2.6%
동 4
 
1.8%
새 4
 
1.8%
리 4
 
1.8%
미 3
 
1.3%
제 3
 
1.3%
대 3
 
1.3%
Other values (65) 99
43.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 227
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
국 48
21.1%
약 47
20.7%
일 6
 
2.6%
한 6
 
2.6%
동 4
 
1.8%
새 4
 
1.8%
리 4
 
1.8%
미 3
 
1.3%
제 3
 
1.3%
대 3
 
1.3%
Other values (65) 99
43.6%

Most occurring scripts

ValueCountFrequency (%)
Hangul 227
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
국 48
21.1%
약 47
20.7%
일 6
 
2.6%
한 6
 
2.6%
동 4
 
1.8%
새 4
 
1.8%
리 4
 
1.8%
미 3
 
1.3%
제 3
 
1.3%
대 3
 
1.3%
Other values (65) 99
43.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 227
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
국 48
21.1%
약 47
20.7%
일 6
 
2.6%
한 6
 
2.6%
동 4
 
1.8%
새 4
 
1.8%
리 4
 
1.8%
미 3
 
1.3%
제 3
 
1.3%
대 3
 
1.3%
Other values (65) 99
43.6%

약국소재지(도로명)
Text

UNIQUE 

Distinct47
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size504.0 B
2024-04-21T20:13:19.884365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length33
Mean length26.042553
Min length21

Characters and Unicode

Total characters1224
Distinct characters66
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

Unique47 ?
Unique (%)100.0%

Sample

1st row부산광역시 중구 중구로 113, 1-2층 (대청동4가)
2nd row부산광역시 중구 자갈치로37번길 4-1(남포동5가)
3rd row부산광역시 중구 구덕로 87-1, 2(L)층 (남포동6가)
4th row부산광역시 중구 구덕로 5, 1층 (남포동1가)
5th row부산광역시 중구 광복중앙로34번길 13, 1층 (대청동2가)
ValueCountFrequency (%)
부산광역시 47
18.4%
중구 47
18.4%
1층 9
 
3.5%
동광동5가 8
 
3.1%
대청로 7
 
2.7%
구덕로 6
 
2.4%
동영로 6
 
2.4%
흑교로 5
 
2.0%
부평동2가 4
 
1.6%
창선동2가 4
 
1.6%
Other values (84) 112
43.9%
2024-04-21T20:13:21.535605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
208
 
17.0%
광 63
 
5.1%
동 63
 
5.1%
중 58
 
4.7%
구 57
 
4.7%
부 52
 
4.2%
시 49
 
4.0%
( 48
 
3.9%
역 48
 
3.9%
) 48
 
3.9%
Other values (56) 530
43.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 712
58.2%
Space Separator 208
 
17.0%
Decimal Number 176
 
14.4%
Open Punctuation 48
 
3.9%
Close Punctuation 48
 
3.9%
Other Punctuation 18
 
1.5%
Dash Punctuation 13
 
1.1%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 63
 
8.8%
동 63
 
8.8%
중 58
 
8.1%
구 57
 
8.0%
부 52
 
7.3%
시 49
 
6.9%
역 48
 
6.7%
산 47
 
6.6%
로 44
 
6.2%
가 44
 
6.2%
Other values (40) 187
26.3%
Decimal Number
ValueCountFrequency (%)
1 45
25.6%
2 33
18.8%
3 24
13.6%
5 19
10.8%
4 15
 
8.5%
6 9
 
5.1%
8 9
 
5.1%
0 8
 
4.5%
9 7
 
4.0%
7 7
 
4.0%
Space Separator
ValueCountFrequency (%)
208
100.0%
Open Punctuation
ValueCountFrequency (%)
( 48
100.0%
Close Punctuation
ValueCountFrequency (%)
) 48
100.0%
Other Punctuation
ValueCountFrequency (%)
, 18
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%
Uppercase Letter
ValueCountFrequency (%)
L 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 712
58.2%
Common 511
41.7%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 63
 
8.8%
동 63
 
8.8%
중 58
 
8.1%
구 57
 
8.0%
부 52
 
7.3%
시 49
 
6.9%
역 48
 
6.7%
산 47
 
6.6%
로 44
 
6.2%
가 44
 
6.2%
Other values (40) 187
26.3%
Common
ValueCountFrequency (%)
208
40.7%
( 48
 
9.4%
) 48
 
9.4%
1 45
 
8.8%
2 33
 
6.5%
3 24
 
4.7%
5 19
 
3.7%
, 18
 
3.5%
4 15
 
2.9%
- 13
 
2.5%
Other values (5) 40
 
7.8%
Latin
ValueCountFrequency (%)
L 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 712
58.2%
ASCII 512
41.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
208
40.6%
( 48
 
9.4%
) 48
 
9.4%
1 45
 
8.8%
2 33
 
6.4%
3 24
 
4.7%
5 19
 
3.7%
, 18
 
3.5%
4 15
 
2.9%
- 13
 
2.5%
Other values (6) 41
 
8.0%
Hangul
ValueCountFrequency (%)
광 63
 
8.8%
동 63
 
8.8%
중 58
 
8.1%
구 57
 
8.0%
부 52
 
7.3%
시 49
 
6.9%
역 48
 
6.7%
산 47
 
6.6%
로 44
 
6.2%
가 44
 
6.2%
Other values (40) 187
26.3%

약국전화번호
Text

MISSING 

Distinct45
Distinct (%)100.0%
Missing2
Missing (%)4.3%
Memory size504.0 B
2024-04-21T20:13:22.382108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.022222
Min length12

Characters and Unicode

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

Unique45 ?
Unique (%)100.0%

Sample

1st row051-255-6149
2nd row051-245-3155
3rd row051-714-1366
4th row051-253-2005
5th row051-462-6205
ValueCountFrequency (%)
051-244-3650 1
 
2.2%
051-246-1100 1
 
2.2%
051-231-5898 1
 
2.2%
051-257-8305 1
 
2.2%
051-245-1081 1
 
2.2%
051-466-8009 1
 
2.2%
051-256-6667 1
 
2.2%
051-245-5777 1
 
2.2%
051-241-0095 1
 
2.2%
051-254-3526 1
 
2.2%
Other values (35) 35
77.8%
2024-04-21T20:13:23.602926image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 94
17.4%
- 90
16.6%
0 74
13.7%
1 71
13.1%
4 56
10.4%
2 52
9.6%
6 36
 
6.7%
3 18
 
3.3%
8 18
 
3.3%
9 16
 
3.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 451
83.4%
Dash Punctuation 90
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 94
20.8%
0 74
16.4%
1 71
15.7%
4 56
12.4%
2 52
11.5%
6 36
 
8.0%
3 18
 
4.0%
8 18
 
4.0%
9 16
 
3.5%
7 16
 
3.5%
Dash Punctuation
ValueCountFrequency (%)
- 90
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 541
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 94
17.4%
- 90
16.6%
0 74
13.7%
1 71
13.1%
4 56
10.4%
2 52
9.6%
6 36
 
6.7%
3 18
 
3.3%
8 18
 
3.3%
9 16
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 541
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 94
17.4%
- 90
16.6%
0 74
13.7%
1 71
13.1%
4 56
10.4%
2 52
9.6%
6 36
 
6.7%
3 18
 
3.3%
8 18
 
3.3%
9 16
 
3.0%

Correlations

2024-04-21T20:13:23.861268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
약국명칭약국소재지(도로명)약국전화번호
약국명칭1.0001.0001.000
약국소재지(도로명)1.0001.0001.000
약국전화번호1.0001.0001.000

Missing values

2024-04-21T20:13:16.673389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T20:13:16.916003image/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신중앙약국부산광역시 중구 중구로 113, 1-2층 (대청동4가)<NA>
1자갈치육일약국부산광역시 중구 자갈치로37번길 4-1(남포동5가)051-255-6149
2호호약국부산광역시 중구 구덕로 87-1, 2(L)층 (남포동6가)051-245-3155
3자갈치홍약국부산광역시 중구 구덕로 5, 1층 (남포동1가)051-714-1366
4오즈약국부산광역시 중구 광복중앙로34번길 13, 1층 (대청동2가)051-253-2005
5남포약국부산광역시 중구 구덕로 지하 12, 도시철도 남포역 39호 (남포동1가)<NA>
6새중앙약국부산광역시 중구 해관로 69 (중앙동4가)051-462-6205
7새한솔약국부산광역시 중구 동영로 4, 2층 (동광동5가)051-442-0911
8다정한약국부산광역시 중구 대청로53번길 7, 1층 (보수동1가)051-242-2257
9동명당약국부산광역시 중구 중구로 59, 1층 (보수동1가)051-255-1445
약국명칭약국소재지(도로명)약국전화번호
37한일사약국부산광역시 중구 광복로 31 (창선동2가)051-242-9954
38영주약국부산광역시 중구 대영로 219 (영주동)051-464-0075
39굿모닝약국부산광역시 중구 흑교로52번길 6-1, 1층 (보수동1가)051-253-1963
40메리놀약국부산광역시 중구 동영로 9-2 (동광동5가)051-441-8275
41새부산약국부산광역시 중구 광복로 31-1 (창선동2가)051-245-5265
42해양약국부산광역시 중구 충장대로9번길 52, 102호 (중앙동4가, 마린센터빌딩)051-469-4389
43천우사약국부산광역시 중구 흑교로 20 (부평동2가)051-245-2365
44중앙약국부산광역시 중구 광복중앙로 35 (대청동2가)051-245-9401
45부평약국부산광역시 중구 흑교로 34 (부평동2가)051-245-5885
46동서약국부산광역시 중구 동광길 88 (중앙동4가)051-469-4142