Overview

Dataset statistics

Number of variables4
Number of observations121
Missing cells4
Missing cells (%)0.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.0 KiB
Average record size in memory34.1 B

Variable types

Numeric1
Text3

Dataset

Description부산광역시 남구 약국 현황으로 약국명칭, 전화번호, 소재지가 있습니다. 2023.06.19.자로 등록한 데이터입니다.
URLhttps://www.data.go.kr/data/3034646/fileData.do

Alerts

약국전화번호 has 4 (3.3%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 00:07:08.671922
Analysis finished2023-12-12 00:07:09.113184
Duration0.44 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct121
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean61
Minimum1
Maximum121
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2023-12-12T09:07:09.188915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile7
Q131
median61
Q391
95-th percentile115
Maximum121
Range120
Interquartile range (IQR)60

Descriptive statistics

Standard deviation35.073732
Coefficient of variation (CV)0.57497921
Kurtosis-1.2
Mean61
Median Absolute Deviation (MAD)30
Skewness0
Sum7381
Variance1230.1667
MonotonicityStrictly increasing
2023-12-12T09:07:09.365778image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.8%
92 1
 
0.8%
90 1
 
0.8%
89 1
 
0.8%
88 1
 
0.8%
87 1
 
0.8%
86 1
 
0.8%
85 1
 
0.8%
84 1
 
0.8%
83 1
 
0.8%
Other values (111) 111
91.7%
ValueCountFrequency (%)
1 1
0.8%
2 1
0.8%
3 1
0.8%
4 1
0.8%
5 1
0.8%
6 1
0.8%
7 1
0.8%
8 1
0.8%
9 1
0.8%
10 1
0.8%
ValueCountFrequency (%)
121 1
0.8%
120 1
0.8%
119 1
0.8%
118 1
0.8%
117 1
0.8%
116 1
0.8%
115 1
0.8%
114 1
0.8%
113 1
0.8%
112 1
0.8%

약국명칭
Text

Distinct116
Distinct (%)95.9%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-12T09:07:09.677596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length4
Mean length4.7520661
Min length3

Characters and Unicode

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

Unique

Unique112 ?
Unique (%)92.6%

Sample

1st row참약사 평화약국
2nd row신성약국
3rd row성신약국
4th row신세명약국
5th row사거리약국
ValueCountFrequency (%)
우리약국 3
 
2.4%
희망약국 2
 
1.6%
고은약국 2
 
1.6%
한마음약국 2
 
1.6%
평화약국 2
 
1.6%
성모메디칼약국 1
 
0.8%
유한약국 1
 
0.8%
푸른약국 1
 
0.8%
소정약국 1
 
0.8%
일동약국 1
 
0.8%
Other values (107) 107
87.0%
2023-12-12T09:07:10.181040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 122
21.2%
국 121
21.0%
리 13
 
2.3%
대 12
 
2.1%
우 10
 
1.7%
한 9
 
1.6%
성 9
 
1.6%
신 7
 
1.2%
온 7
 
1.2%
사 7
 
1.2%
Other values (128) 258
44.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 566
98.4%
Uppercase Letter 4
 
0.7%
Decimal Number 3
 
0.5%
Space Separator 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 122
21.6%
국 121
21.4%
리 13
 
2.3%
대 12
 
2.1%
우 10
 
1.8%
한 9
 
1.6%
성 9
 
1.6%
신 7
 
1.2%
온 7
 
1.2%
사 7
 
1.2%
Other values (122) 249
44.0%
Decimal Number
ValueCountFrequency (%)
2 1
33.3%
1 1
33.3%
3 1
33.3%
Uppercase Letter
ValueCountFrequency (%)
L 2
50.0%
G 2
50.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 566
98.4%
Common 5
 
0.9%
Latin 4
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 122
21.6%
국 121
21.4%
리 13
 
2.3%
대 12
 
2.1%
우 10
 
1.8%
한 9
 
1.6%
성 9
 
1.6%
신 7
 
1.2%
온 7
 
1.2%
사 7
 
1.2%
Other values (122) 249
44.0%
Common
ValueCountFrequency (%)
2
40.0%
2 1
20.0%
1 1
20.0%
3 1
20.0%
Latin
ValueCountFrequency (%)
L 2
50.0%
G 2
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 566
98.4%
ASCII 9
 
1.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 122
21.6%
국 121
21.4%
리 13
 
2.3%
대 12
 
2.1%
우 10
 
1.8%
한 9
 
1.6%
성 9
 
1.6%
신 7
 
1.2%
온 7
 
1.2%
사 7
 
1.2%
Other values (122) 249
44.0%
ASCII
ValueCountFrequency (%)
L 2
22.2%
G 2
22.2%
2
22.2%
2 1
11.1%
1 1
11.1%
3 1
11.1%

약국전화번호
Text

MISSING 

Distinct117
Distinct (%)100.0%
Missing4
Missing (%)3.3%
Memory size1.1 KiB
2023-12-12T09:07:10.445781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.008547
Min length12

Characters and Unicode

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

Unique117 ?
Unique (%)100.0%

Sample

1st row051-628-0818
2nd row051-626-1007
3rd row051-626-7974
4th row051-612-0492
5th row051-611-0509
ValueCountFrequency (%)
051-625-7890 1
 
0.9%
051-627-6489 1
 
0.9%
051-646-8260 1
 
0.9%
051-622-8700 1
 
0.9%
051-627-6209 1
 
0.9%
051-632-6777 1
 
0.9%
051-622-2900 1
 
0.9%
051-647-0553 1
 
0.9%
051-624-4780 1
 
0.9%
051-627-1004 1
 
0.9%
Other values (107) 107
91.5%
2023-12-12T09:07:10.825901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 234
16.7%
1 199
14.2%
0 193
13.7%
5 177
12.6%
6 168
12.0%
2 138
9.8%
7 68
 
4.8%
8 66
 
4.7%
3 64
 
4.6%
4 62
 
4.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1171
83.3%
Dash Punctuation 234
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 199
17.0%
0 193
16.5%
5 177
15.1%
6 168
14.3%
2 138
11.8%
7 68
 
5.8%
8 66
 
5.6%
3 64
 
5.5%
4 62
 
5.3%
9 36
 
3.1%
Dash Punctuation
ValueCountFrequency (%)
- 234
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1405
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 234
16.7%
1 199
14.2%
0 193
13.7%
5 177
12.6%
6 168
12.0%
2 138
9.8%
7 68
 
4.8%
8 66
 
4.7%
3 64
 
4.6%
4 62
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1405
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 234
16.7%
1 199
14.2%
0 193
13.7%
5 177
12.6%
6 168
12.0%
2 138
9.8%
7 68
 
4.8%
8 66
 
4.7%
3 64
 
4.6%
4 62
 
4.4%

약국소재지(도로명)
Text

Distinct120
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-12T09:07:11.069803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length45
Mean length27.793388
Min length20

Characters and Unicode

Total characters3363
Distinct characters145
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

Unique119 ?
Unique (%)98.3%

Sample

1st row부산광역시 남구 양지골로 257(감만동)
2nd row부산광역시 남구 용호로42번길 75(용호동)
3rd row부산광역시 남구 용호로232번길 21, 성신약국 (용호동)
4th row부산광역시 남구 용호로 50, 1층 (용호동)
5th row부산광역시 남구 진남로 4, 1층 (대연동)
ValueCountFrequency (%)
부산광역시 121
17.0%
남구 121
17.0%
대연동 46
 
6.5%
용호동 45
 
6.3%
수영로 35
 
4.9%
1층 31
 
4.4%
용호로 20
 
2.8%
문현동 14
 
2.0%
분포로 11
 
1.5%
석포로 7
 
1.0%
Other values (199) 261
36.7%
2023-12-12T09:07:11.442942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
591
 
17.6%
1 154
 
4.6%
동 142
 
4.2%
로 129
 
3.8%
시 128
 
3.8%
남 125
 
3.7%
부 122
 
3.6%
( 122
 
3.6%
산 122
 
3.6%
) 122
 
3.6%
Other values (135) 1606
47.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1918
57.0%
Space Separator 591
 
17.6%
Decimal Number 505
 
15.0%
Open Punctuation 122
 
3.6%
Close Punctuation 122
 
3.6%
Other Punctuation 74
 
2.2%
Dash Punctuation 23
 
0.7%
Uppercase Letter 8
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 142
 
7.4%
로 129
 
6.7%
시 128
 
6.7%
남 125
 
6.5%
부 122
 
6.4%
산 122
 
6.4%
광 121
 
6.3%
역 121
 
6.3%
구 121
 
6.3%
호 98
 
5.1%
Other values (113) 689
35.9%
Decimal Number
ValueCountFrequency (%)
1 154
30.5%
2 77
15.2%
0 54
 
10.7%
3 45
 
8.9%
5 39
 
7.7%
4 36
 
7.1%
6 31
 
6.1%
9 25
 
5.0%
7 23
 
4.6%
8 21
 
4.2%
Uppercase Letter
ValueCountFrequency (%)
A 2
25.0%
B 2
25.0%
K 1
12.5%
S 1
12.5%
L 1
12.5%
G 1
12.5%
Other Punctuation
ValueCountFrequency (%)
, 72
97.3%
. 2
 
2.7%
Space Separator
ValueCountFrequency (%)
591
100.0%
Open Punctuation
ValueCountFrequency (%)
( 122
100.0%
Close Punctuation
ValueCountFrequency (%)
) 122
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 23
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1918
57.0%
Common 1437
42.7%
Latin 8
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 142
 
7.4%
로 129
 
6.7%
시 128
 
6.7%
남 125
 
6.5%
부 122
 
6.4%
산 122
 
6.4%
광 121
 
6.3%
역 121
 
6.3%
구 121
 
6.3%
호 98
 
5.1%
Other values (113) 689
35.9%
Common
ValueCountFrequency (%)
591
41.1%
1 154
 
10.7%
( 122
 
8.5%
) 122
 
8.5%
2 77
 
5.4%
, 72
 
5.0%
0 54
 
3.8%
3 45
 
3.1%
5 39
 
2.7%
4 36
 
2.5%
Other values (6) 125
 
8.7%
Latin
ValueCountFrequency (%)
A 2
25.0%
B 2
25.0%
K 1
12.5%
S 1
12.5%
L 1
12.5%
G 1
12.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1918
57.0%
ASCII 1445
43.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
591
40.9%
1 154
 
10.7%
( 122
 
8.4%
) 122
 
8.4%
2 77
 
5.3%
, 72
 
5.0%
0 54
 
3.7%
3 45
 
3.1%
5 39
 
2.7%
4 36
 
2.5%
Other values (12) 133
 
9.2%
Hangul
ValueCountFrequency (%)
동 142
 
7.4%
로 129
 
6.7%
시 128
 
6.7%
남 125
 
6.5%
부 122
 
6.4%
산 122
 
6.4%
광 121
 
6.3%
역 121
 
6.3%
구 121
 
6.3%
호 98
 
5.1%
Other values (113) 689
35.9%

Interactions

2023-12-12T09:07:08.862296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T09:07:08.974130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:07:09.073906image/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참약사 평화약국<NA>부산광역시 남구 양지골로 257(감만동)
12신성약국051-628-0818부산광역시 남구 용호로42번길 75(용호동)
23성신약국051-626-1007부산광역시 남구 용호로232번길 21, 성신약국 (용호동)
34신세명약국051-626-7974부산광역시 남구 용호로 50, 1층 (용호동)
45사거리약국051-612-0492부산광역시 남구 진남로 4, 1층 (대연동)
56다올약국<NA>부산광역시 남구 수영로 216, 미즈빌딩 1층 (대연동)
67오늘약국051-611-0509부산광역시 남구 분포로 115, 힐탑탑플레이스 A동 104호 (용호동)
78명륜당약국051-644-8423부산광역시 남구 수영로 30-1(문현동)
89건강약국051-611-1249부산광역시 남구 용호로 129, 두산빌딩 1층 (용호동)
910중앙약국051-626-5525부산광역시 남구 분포로 111, 1003동 302호 (용호동, 엘지메트로시티)
순번약국명칭약국전화번호약국소재지(도로명)
111112우석약국051-637-9935부산광역시 남구 진남로 206 (문현동)
112113건강한약국051-611-9559부산광역시 남구 수영로 195-2 (대연동)
113114문화약국051-624-0950부산광역시 남구 석포로 128 (대연동)
114115건민약국051-632-5267부산광역시 남구 우암로 72 (감만동)
115116일광약국051-636-3269부산광역시 남구 홍곡로 12 (감만동)
116117우정약국051-627-4441부산광역시 남구 수영로 196 (대연동)
117118대흥천보약국051-634-5810부산광역시 남구 고동골로 80 (문현동)
118119신중앙약국051-623-6900부산광역시 남구 용호로 144 (용호동)
119120사상오체사성당약국051-624-8875부산광역시 남구 신선로 333 (용당동)
120121명진약국051-623-6595부산광역시 남구 용소로7번길 75 (대연동)