Overview

Dataset statistics

Number of variables4
Number of observations166
Missing cells6
Missing cells (%)0.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.5 KiB
Average record size in memory33.8 B

Variable types

Numeric1
Text3

Dataset

Description약국현황_20200622
Author부산광역시 해운대구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=3075588

Alerts

전화번호 has 6 (3.6%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-10 16:51:08.659308
Analysis finished2023-12-10 16:51:09.402453
Duration0.74 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct166
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean83.5
Minimum1
Maximum166
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2023-12-11T01:51:09.513524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile9.25
Q142.25
median83.5
Q3124.75
95-th percentile157.75
Maximum166
Range165
Interquartile range (IQR)82.5

Descriptive statistics

Standard deviation48.064193
Coefficient of variation (CV)0.57561908
Kurtosis-1.2
Mean83.5
Median Absolute Deviation (MAD)41.5
Skewness0
Sum13861
Variance2310.1667
MonotonicityStrictly increasing
2023-12-11T01:51:09.782707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
106 1
 
0.6%
108 1
 
0.6%
109 1
 
0.6%
110 1
 
0.6%
111 1
 
0.6%
112 1
 
0.6%
113 1
 
0.6%
114 1
 
0.6%
115 1
 
0.6%
Other values (156) 156
94.0%
ValueCountFrequency (%)
1 1
0.6%
2 1
0.6%
3 1
0.6%
4 1
0.6%
5 1
0.6%
6 1
0.6%
7 1
0.6%
8 1
0.6%
9 1
0.6%
10 1
0.6%
ValueCountFrequency (%)
166 1
0.6%
165 1
0.6%
164 1
0.6%
163 1
0.6%
162 1
0.6%
161 1
0.6%
160 1
0.6%
159 1
0.6%
158 1
0.6%
157 1
0.6%

약국명칭
Text

Distinct156
Distinct (%)94.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-11T01:51:10.315818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length8
Mean length4.8795181
Min length3

Characters and Unicode

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

Unique

Unique146 ?
Unique (%)88.0%

Sample

1st row소나무약국
2nd row해운메디약국
3rd row하늘온누리약국
4th row새열린약국
5th row메이플약국
ValueCountFrequency (%)
초록약국 2
 
1.2%
아름약국 2
 
1.2%
참사랑약국 2
 
1.2%
미술관옆약국 2
 
1.2%
성심약국 2
 
1.2%
화목2층약국 2
 
1.2%
장산약국 2
 
1.2%
하나약국 2
 
1.2%
행복한약국 2
 
1.2%
센텀중앙약국 2
 
1.2%
Other values (149) 149
88.2%
2023-12-11T01:51:11.080626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 167
20.6%
국 167
20.6%
리 15
 
1.9%
센 13
 
1.6%
텀 12
 
1.5%
한 11
 
1.4%
동 10
 
1.2%
온 10
 
1.2%
인 9
 
1.1%
신 9
 
1.1%
Other values (164) 387
47.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 803
99.1%
Decimal Number 4
 
0.5%
Space Separator 3
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 167
20.8%
국 167
20.8%
리 15
 
1.9%
센 13
 
1.6%
텀 12
 
1.5%
한 11
 
1.4%
동 10
 
1.2%
온 10
 
1.2%
인 9
 
1.1%
신 9
 
1.1%
Other values (161) 380
47.3%
Decimal Number
ValueCountFrequency (%)
1 2
50.0%
2 2
50.0%
Space Separator
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 803
99.1%
Common 7
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 167
20.8%
국 167
20.8%
리 15
 
1.9%
센 13
 
1.6%
텀 12
 
1.5%
한 11
 
1.4%
동 10
 
1.2%
온 10
 
1.2%
인 9
 
1.1%
신 9
 
1.1%
Other values (161) 380
47.3%
Common
ValueCountFrequency (%)
3
42.9%
1 2
28.6%
2 2
28.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 803
99.1%
ASCII 7
 
0.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 167
20.8%
국 167
20.8%
리 15
 
1.9%
센 13
 
1.6%
텀 12
 
1.5%
한 11
 
1.4%
동 10
 
1.2%
온 10
 
1.2%
인 9
 
1.1%
신 9
 
1.1%
Other values (161) 380
47.3%
ASCII
ValueCountFrequency (%)
3
42.9%
1 2
28.6%
2 2
28.6%

소재지(도로명)
Text

Distinct162
Distinct (%)97.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-11T01:51:11.503718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length53
Median length41
Mean length33.036145
Min length21

Characters and Unicode

Total characters5484
Distinct characters181
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

Unique158 ?
Unique (%)95.2%

Sample

1st row부산광역시 해운대구 해운대로 133 (재송동)
2nd row부산광역시 해운대구 해운대로 602, 102호 (우동)
3rd row부산광역시 해운대구 재반로 221-1, 1층 (반여동)
4th row부산광역시 해운대구 좌동순환로 275, 상가동 106호 (좌동, 대우2차아파트)
5th row부산광역시 해운대구 해운대로 814, 세종월드프라자 B동 428호 (좌동)
ValueCountFrequency (%)
부산광역시 166
 
16.1%
해운대구 166
 
16.1%
우동 38
 
3.7%
좌동 38
 
3.7%
반여동 30
 
2.9%
재송동 23
 
2.2%
해운대로 22
 
2.1%
반송동 20
 
1.9%
1층 19
 
1.8%
재반로 18
 
1.7%
Other values (301) 492
47.7%
2023-12-11T01:51:12.203982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
866
 
15.8%
1 234
 
4.3%
동 221
 
4.0%
대 218
 
4.0%
운 211
 
3.8%
해 210
 
3.8%
시 177
 
3.2%
산 174
 
3.2%
구 173
 
3.2%
부 170
 
3.1%
Other values (171) 2830
51.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3290
60.0%
Space Separator 866
 
15.8%
Decimal Number 803
 
14.6%
Open Punctuation 166
 
3.0%
Other Punctuation 166
 
3.0%
Close Punctuation 166
 
3.0%
Dash Punctuation 18
 
0.3%
Uppercase Letter 6
 
0.1%
Lowercase Letter 2
 
< 0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 221
 
6.7%
대 218
 
6.6%
운 211
 
6.4%
해 210
 
6.4%
시 177
 
5.4%
산 174
 
5.3%
구 173
 
5.3%
부 170
 
5.2%
광 167
 
5.1%
역 166
 
5.0%
Other values (148) 1403
42.6%
Decimal Number
ValueCountFrequency (%)
1 234
29.1%
2 112
13.9%
0 111
13.8%
3 68
 
8.5%
4 62
 
7.7%
6 52
 
6.5%
7 45
 
5.6%
5 43
 
5.4%
9 42
 
5.2%
8 34
 
4.2%
Uppercase Letter
ValueCountFrequency (%)
B 2
33.3%
I 1
16.7%
S 1
16.7%
F 1
16.7%
A 1
16.7%
Lowercase Letter
ValueCountFrequency (%)
i 1
50.0%
s 1
50.0%
Space Separator
ValueCountFrequency (%)
866
100.0%
Open Punctuation
ValueCountFrequency (%)
( 166
100.0%
Other Punctuation
ValueCountFrequency (%)
, 166
100.0%
Close Punctuation
ValueCountFrequency (%)
) 166
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3290
60.0%
Common 2186
39.9%
Latin 8
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 221
 
6.7%
대 218
 
6.6%
운 211
 
6.4%
해 210
 
6.4%
시 177
 
5.4%
산 174
 
5.3%
구 173
 
5.3%
부 170
 
5.2%
광 167
 
5.1%
역 166
 
5.0%
Other values (148) 1403
42.6%
Common
ValueCountFrequency (%)
866
39.6%
1 234
 
10.7%
( 166
 
7.6%
, 166
 
7.6%
) 166
 
7.6%
2 112
 
5.1%
0 111
 
5.1%
3 68
 
3.1%
4 62
 
2.8%
6 52
 
2.4%
Other values (6) 183
 
8.4%
Latin
ValueCountFrequency (%)
B 2
25.0%
I 1
12.5%
S 1
12.5%
i 1
12.5%
s 1
12.5%
F 1
12.5%
A 1
12.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3290
60.0%
ASCII 2194
40.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
866
39.5%
1 234
 
10.7%
( 166
 
7.6%
, 166
 
7.6%
) 166
 
7.6%
2 112
 
5.1%
0 111
 
5.1%
3 68
 
3.1%
4 62
 
2.8%
6 52
 
2.4%
Other values (13) 191
 
8.7%
Hangul
ValueCountFrequency (%)
동 221
 
6.7%
대 218
 
6.6%
운 211
 
6.4%
해 210
 
6.4%
시 177
 
5.4%
산 174
 
5.3%
구 173
 
5.3%
부 170
 
5.2%
광 167
 
5.1%
역 166
 
5.0%
Other values (148) 1403
42.6%

전화번호
Text

MISSING 

Distinct155
Distinct (%)96.9%
Missing6
Missing (%)3.6%
Memory size1.4 KiB
2023-12-11T01:51:12.726228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique151 ?
Unique (%)94.4%

Sample

1st row051-784-8999
2nd row051-746-8831
3rd row051-912-4242
4th row051-704-7533
5th row051-703-2684
ValueCountFrequency (%)
051-744-7275 3
 
1.9%
051-701-8608 2
 
1.2%
051-744-5501 2
 
1.2%
051-529-7515 2
 
1.2%
051-781-0079 1
 
0.6%
051-744-2028 1
 
0.6%
051-526-1109 1
 
0.6%
051-469-8727 1
 
0.6%
051-544-2694 1
 
0.6%
051-747-3783 1
 
0.6%
Other values (145) 145
90.6%
2023-12-11T01:51:13.328058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 320
16.7%
0 298
15.5%
5 277
14.4%
1 261
13.6%
7 182
9.5%
4 161
8.4%
2 103
 
5.4%
8 102
 
5.3%
3 80
 
4.2%
6 71
 
3.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1600
83.3%
Dash Punctuation 320
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 298
18.6%
5 277
17.3%
1 261
16.3%
7 182
11.4%
4 161
10.1%
2 103
 
6.4%
8 102
 
6.4%
3 80
 
5.0%
6 71
 
4.4%
9 65
 
4.1%
Dash Punctuation
ValueCountFrequency (%)
- 320
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1920
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 320
16.7%
0 298
15.5%
5 277
14.4%
1 261
13.6%
7 182
9.5%
4 161
8.4%
2 103
 
5.4%
8 102
 
5.3%
3 80
 
4.2%
6 71
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1920
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 320
16.7%
0 298
15.5%
5 277
14.4%
1 261
13.6%
7 182
9.5%
4 161
8.4%
2 103
 
5.4%
8 102
 
5.3%
3 80
 
4.2%
6 71
 
3.7%

Interactions

2023-12-11T01:51:09.009507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-11T01:51:09.200719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:51:09.342454image/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소나무약국부산광역시 해운대구 해운대로 133 (재송동)051-784-8999
12해운메디약국부산광역시 해운대구 해운대로 602, 102호 (우동)051-746-8831
23하늘온누리약국부산광역시 해운대구 재반로 221-1, 1층 (반여동)051-912-4242
34새열린약국부산광역시 해운대구 좌동순환로 275, 상가동 106호 (좌동, 대우2차아파트)051-704-7533
45메이플약국부산광역시 해운대구 해운대로 814, 세종월드프라자 B동 428호 (좌동)051-703-2684
56화인약국부산광역시 해운대구 해운대로 802, 웅신시네아트 415호 (좌동)<NA>
67가까운약국부산광역시 해운대구 구남로8번길 77 (우동)051-731-1088
78행복한약국부산광역시 해운대구 해운대로 313, 1층 (우동)051-746-3373
89큰솔약국부산광역시 해운대구 해운대로 600, 1층 (우동)051-791-1190
910동백메디컬약국부산광역시 해운대구 해운대로 540, 104동 103호 (우동, 해운대 동백 두산위브더제니스)<NA>
순번약국명칭소재지(도로명)전화번호
156157성심약국부산광역시 해운대구 우동1로20번길 63 (우동)051-743-3158
157158친절한약국부산광역시 해운대구 아랫반송로 57 (반송동)051-544-8063
158159영진약국부산광역시 해운대구 윗반송로51번길 112 (반송동)051-542-4401
159160성심약국부산광역시 해운대구 반송로924번길 14 (반송동)051-542-9000
160161유민약국부산광역시 해운대구 윗반송로51번길 178 (반송동)051-542-8290
161162대우약국부산광역시 해운대구 선수촌로165번길 7 (반여동)051-523-0634
162163동신약국부산광역시 해운대구 중동1로 16 (우동)051-746-2782
163164수도약국부산광역시 해운대구 우동2로 58 (우동)051-742-3646
164165세영약국부산광역시 해운대구 구남로 3 (우동)051-746-8453
165166효원약국부산광역시 해운대구 재반로256번길 15 (반여동)051-783-1180