Overview

Dataset statistics

Number of variables4
Number of observations119
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부산광역시남구약국현황_20220615
Author부산광역시 남구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=3034646

Alerts

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

Reproduction

Analysis started2023-12-10 16:10:26.785147
Analysis finished2023-12-10 16:10:27.106247
Duration0.32 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct119
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean60
Minimum1
Maximum119
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2023-12-11T01:10:27.161657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile6.9
Q130.5
median60
Q389.5
95-th percentile113.1
Maximum119
Range118
Interquartile range (IQR)59

Descriptive statistics

Standard deviation34.496377
Coefficient of variation (CV)0.57493961
Kurtosis-1.2
Mean60
Median Absolute Deviation (MAD)30
Skewness0
Sum7140
Variance1190
MonotonicityStrictly increasing
2023-12-11T01:10:27.281289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.8%
2 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%
82 1
 
0.8%
Other values (109) 109
91.6%
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 (%)
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%
111 1
0.8%
110 1
0.8%
Distinct114
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-11T01:10:27.513529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length4
Mean length4.7394958
Min length3

Characters and Unicode

Total characters564
Distinct characters139
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

Unique110 ?
Unique (%)92.4%

Sample

1st row새봄약국
2nd row남천제일약국
3rd row곰약국
4th row마음애약국
5th row성모정문약국
ValueCountFrequency (%)
우리약국 3
 
2.5%
한마음약국 2
 
1.7%
희망약국 2
 
1.7%
고은약국 2
 
1.7%
새봄약국 1
 
0.8%
lg참약국 1
 
0.8%
21세기우리네약국 1
 
0.8%
신성약국 1
 
0.8%
대지약국 1
 
0.8%
싱싱약국 1
 
0.8%
Other values (105) 105
87.5%
2023-12-11T01:10:27.849615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
119
21.1%
119
21.1%
12
 
2.1%
12
 
2.1%
10
 
1.8%
10
 
1.8%
9
 
1.6%
7
 
1.2%
7
 
1.2%
6
 
1.1%
Other values (129) 253
44.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 556
98.6%
Uppercase Letter 4
 
0.7%
Decimal Number 3
 
0.5%
Space Separator 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
119
21.4%
119
21.4%
12
 
2.2%
12
 
2.2%
10
 
1.8%
10
 
1.8%
9
 
1.6%
7
 
1.3%
7
 
1.3%
6
 
1.1%
Other values (123) 245
44.1%
Decimal Number
ValueCountFrequency (%)
1 1
33.3%
2 1
33.3%
3 1
33.3%
Uppercase Letter
ValueCountFrequency (%)
L 2
50.0%
G 2
50.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 556
98.6%
Latin 4
 
0.7%
Common 4
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
119
21.4%
119
21.4%
12
 
2.2%
12
 
2.2%
10
 
1.8%
10
 
1.8%
9
 
1.6%
7
 
1.3%
7
 
1.3%
6
 
1.1%
Other values (123) 245
44.1%
Common
ValueCountFrequency (%)
1 1
25.0%
2 1
25.0%
1
25.0%
3 1
25.0%
Latin
ValueCountFrequency (%)
L 2
50.0%
G 2
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 556
98.6%
ASCII 8
 
1.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
119
21.4%
119
21.4%
12
 
2.2%
12
 
2.2%
10
 
1.8%
10
 
1.8%
9
 
1.6%
7
 
1.3%
7
 
1.3%
6
 
1.1%
Other values (123) 245
44.1%
ASCII
ValueCountFrequency (%)
L 2
25.0%
G 2
25.0%
1 1
12.5%
2 1
12.5%
1
12.5%
3 1
12.5%

약국전화번호
Text

MISSING 

Distinct115
Distinct (%)100.0%
Missing4
Missing (%)3.4%
Memory size1.1 KiB
2023-12-11T01:10:28.068137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.008696
Min length12

Characters and Unicode

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

Unique115 ?
Unique (%)100.0%

Sample

1st row051-611-2284
2nd row051-625-7890
3rd row051-628-6283
4th row051-626-7974
5th row051-715-6377
ValueCountFrequency (%)
051-627-0882 1
 
0.9%
051-637-0329 1
 
0.9%
051-621-8042 1
 
0.9%
051-637-9417 1
 
0.9%
051-612-1472 1
 
0.9%
051-646-8260 1
 
0.9%
051-628-0818 1
 
0.9%
051-622-8700 1
 
0.9%
051-627-6209 1
 
0.9%
051-632-6777 1
 
0.9%
Other values (105) 105
91.3%
2023-12-11T01:10:28.379493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 230
16.7%
1 192
13.9%
0 185
13.4%
5 174
12.6%
6 168
12.2%
2 129
9.3%
7 75
 
5.4%
3 69
 
5.0%
8 64
 
4.6%
4 63
 
4.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1151
83.3%
Dash Punctuation 230
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 192
16.7%
0 185
16.1%
5 174
15.1%
6 168
14.6%
2 129
11.2%
7 75
 
6.5%
3 69
 
6.0%
8 64
 
5.6%
4 63
 
5.5%
9 32
 
2.8%
Dash Punctuation
ValueCountFrequency (%)
- 230
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1381
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 230
16.7%
1 192
13.9%
0 185
13.4%
5 174
12.6%
6 168
12.2%
2 129
9.3%
7 75
 
5.4%
3 69
 
5.0%
8 64
 
4.6%
4 63
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1381
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 230
16.7%
1 192
13.9%
0 185
13.4%
5 174
12.6%
6 168
12.2%
2 129
9.3%
7 75
 
5.4%
3 69
 
5.0%
8 64
 
4.6%
4 63
 
4.6%
Distinct117
Distinct (%)98.3%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-11T01:10:28.609898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length45
Mean length27.218487
Min length20

Characters and Unicode

Total characters3239
Distinct characters144
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

Unique115 ?
Unique (%)96.6%

Sample

1st row부산광역시 남구 용호로 56, 1층 (용호동)
2nd row부산광역시 남구 수영로 260, 1층 (대연동)
3rd row부산광역시 남구 석포로 74, 1층 (대연동)
4th row부산광역시 남구 용호로 64, 중앙해수월드 1층 일부호 (용호동)
5th row부산광역시 남구 용호로 267, 1층 (용호동)
ValueCountFrequency (%)
부산광역시 119
17.3%
남구 119
17.3%
용호동 44
 
6.4%
대연동 44
 
6.4%
수영로 33
 
4.8%
1층 26
 
3.8%
용호로 20
 
2.9%
문현동 15
 
2.2%
감만동 9
 
1.3%
분포로 9
 
1.3%
Other values (192) 249
36.2%
2023-12-11T01:10:28.945088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
568
 
17.5%
136
 
4.2%
1 135
 
4.2%
126
 
3.9%
125
 
3.9%
122
 
3.8%
120
 
3.7%
) 120
 
3.7%
( 120
 
3.7%
120
 
3.7%
Other values (134) 1547
47.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1864
57.5%
Space Separator 568
 
17.5%
Decimal Number 475
 
14.7%
Close Punctuation 120
 
3.7%
Open Punctuation 120
 
3.7%
Other Punctuation 65
 
2.0%
Dash Punctuation 22
 
0.7%
Uppercase Letter 5
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
136
 
7.3%
126
 
6.8%
125
 
6.7%
122
 
6.5%
120
 
6.4%
120
 
6.4%
119
 
6.4%
119
 
6.4%
119
 
6.4%
91
 
4.9%
Other values (113) 667
35.8%
Decimal Number
ValueCountFrequency (%)
1 135
28.4%
2 78
16.4%
0 48
 
10.1%
3 42
 
8.8%
5 40
 
8.4%
4 33
 
6.9%
6 30
 
6.3%
9 25
 
5.3%
7 23
 
4.8%
8 21
 
4.4%
Uppercase Letter
ValueCountFrequency (%)
L 1
20.0%
G 1
20.0%
S 1
20.0%
K 1
20.0%
A 1
20.0%
Other Punctuation
ValueCountFrequency (%)
, 63
96.9%
. 2
 
3.1%
Space Separator
ValueCountFrequency (%)
568
100.0%
Close Punctuation
ValueCountFrequency (%)
) 120
100.0%
Open Punctuation
ValueCountFrequency (%)
( 120
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 22
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1864
57.5%
Common 1370
42.3%
Latin 5
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
136
 
7.3%
126
 
6.8%
125
 
6.7%
122
 
6.5%
120
 
6.4%
120
 
6.4%
119
 
6.4%
119
 
6.4%
119
 
6.4%
91
 
4.9%
Other values (113) 667
35.8%
Common
ValueCountFrequency (%)
568
41.5%
1 135
 
9.9%
) 120
 
8.8%
( 120
 
8.8%
2 78
 
5.7%
, 63
 
4.6%
0 48
 
3.5%
3 42
 
3.1%
5 40
 
2.9%
4 33
 
2.4%
Other values (6) 123
 
9.0%
Latin
ValueCountFrequency (%)
L 1
20.0%
G 1
20.0%
S 1
20.0%
K 1
20.0%
A 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1864
57.5%
ASCII 1375
42.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
568
41.3%
1 135
 
9.8%
) 120
 
8.7%
( 120
 
8.7%
2 78
 
5.7%
, 63
 
4.6%
0 48
 
3.5%
3 42
 
3.1%
5 40
 
2.9%
4 33
 
2.4%
Other values (11) 128
 
9.3%
Hangul
ValueCountFrequency (%)
136
 
7.3%
126
 
6.8%
125
 
6.7%
122
 
6.5%
120
 
6.4%
120
 
6.4%
119
 
6.4%
119
 
6.4%
119
 
6.4%
91
 
4.9%
Other values (113) 667
35.8%

Interactions

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

Missing values

2023-12-11T01:10:27.017007image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:10:27.079777image/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새봄약국051-611-2284부산광역시 남구 용호로 56, 1층 (용호동)
12남천제일약국<NA>부산광역시 남구 수영로 260, 1층 (대연동)
23곰약국051-625-7890부산광역시 남구 석포로 74, 1층 (대연동)
34마음애약국<NA>부산광역시 남구 용호로 64, 중앙해수월드 1층 일부호 (용호동)
45성모정문약국051-628-6283부산광역시 남구 용호로 267, 1층 (용호동)
56신세명약국051-626-7974부산광역시 남구 용호로 50, 1층 (용호동)
67정류장약국051-715-6377부산광역시 남구 용호로 127, 1층 (용호동)
78우리들약국<NA>부산광역시 남구 용호로 207 (용호동)
89대연시장약국051-626-2356부산광역시 남구 수영로266번길 36, 1층 (대연동)
910포미약국051-924-4242부산광역시 남구 용소로 15, 로티보이까페 1층 (대연동)
순번약국명칭약국전화번호약국소재지(도로명)
109110우석약국051-637-9935부산광역시 남구 진남로 206 (문현동)
110111건강한약국051-611-9559부산광역시 남구 수영로 195-2 (대연동)
111112문화약국051-624-0950부산광역시 남구 석포로 128 (대연동)
112113건민약국051-632-5267부산광역시 남구 우암로 72 (감만동)
113114일광약국051-636-3269부산광역시 남구 홍곡로 12 (감만동)
114115우정약국051-627-4441부산광역시 남구 수영로 196 (대연동)
115116대흥천보약국051-634-5810부산광역시 남구 고동골로 80 (문현동)
116117신중앙약국051-623-6900부산광역시 남구 용호로 144 (용호동)
117118사상오체사성당약국051-624-8875부산광역시 남구 신선로 333 (용당동)
118119명진약국051-623-6595부산광역시 남구 용소로7번길 75 (대연동)