Overview

Dataset statistics

Number of variables4
Number of observations126
Missing cells3
Missing cells (%)0.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.2 KiB
Average record size in memory34.0 B

Variable types

Numeric1
Text3

Dataset

Description동구 관내 약국 현황에 대하여 2023. 3. 30. 기준으로 약국명, 도로명 주소, 전화번호의 내용을 안내드립니다.
URLhttps://www.data.go.kr/data/3081010/fileData.do

Alerts

약국전화번호 has 3 (2.4%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 18:18:14.188193
Analysis finished2023-12-12 18:18:14.632522
Duration0.44 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct126
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean63.5
Minimum1
Maximum126
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2023-12-13T03:18:14.696702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile7.25
Q132.25
median63.5
Q394.75
95-th percentile119.75
Maximum126
Range125
Interquartile range (IQR)62.5

Descriptive statistics

Standard deviation36.517119
Coefficient of variation (CV)0.57507274
Kurtosis-1.2
Mean63.5
Median Absolute Deviation (MAD)31.5
Skewness0
Sum8001
Variance1333.5
MonotonicityStrictly increasing
2023-12-13T03:18:14.818747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.8%
81 1
 
0.8%
94 1
 
0.8%
93 1
 
0.8%
92 1
 
0.8%
91 1
 
0.8%
90 1
 
0.8%
89 1
 
0.8%
88 1
 
0.8%
87 1
 
0.8%
Other values (116) 116
92.1%
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 (%)
126 1
0.8%
125 1
0.8%
124 1
0.8%
123 1
0.8%
122 1
0.8%
121 1
0.8%
120 1
0.8%
119 1
0.8%
118 1
0.8%
117 1
0.8%

약국명칭
Text

Distinct124
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-13T03:18:15.047721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length9
Mean length4.8253968
Min length3

Characters and Unicode

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

Unique

Unique122 ?
Unique (%)96.8%

Sample

1st row드림약국
2nd row역전약국
3rd row민정약국
4th row용운태평양약국
5th row백제당한약국
ValueCountFrequency (%)
굿모닝약국 2
 
1.6%
메디컬대동약국 2
 
1.6%
한사랑약국 1
 
0.8%
동대전약국 1
 
0.8%
마루약국 1
 
0.8%
하늘약국 1
 
0.8%
새시대약국 1
 
0.8%
노닐약국 1
 
0.8%
가오예시티약국 1
 
0.8%
삼성약국 1
 
0.8%
Other values (117) 117
90.7%
2023-12-13T03:18:15.415766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
국 128
21.1%
약 128
21.1%
한 15
 
2.5%
리 12
 
2.0%
대 12
 
2.0%
일 9
 
1.5%
우 7
 
1.2%
온 7
 
1.2%
동 7
 
1.2%
전 7
 
1.2%
Other values (134) 276
45.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 599
98.5%
Space Separator 3
 
0.5%
Open Punctuation 2
 
0.3%
Close Punctuation 2
 
0.3%
Uppercase Letter 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
국 128
21.4%
약 128
21.4%
한 15
 
2.5%
리 12
 
2.0%
대 12
 
2.0%
일 9
 
1.5%
우 7
 
1.2%
온 7
 
1.2%
동 7
 
1.2%
전 7
 
1.2%
Other values (129) 267
44.6%
Uppercase Letter
ValueCountFrequency (%)
O 1
50.0%
K 1
50.0%
Space Separator
ValueCountFrequency (%)
3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 599
98.5%
Common 7
 
1.2%
Latin 2
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
국 128
21.4%
약 128
21.4%
한 15
 
2.5%
리 12
 
2.0%
대 12
 
2.0%
일 9
 
1.5%
우 7
 
1.2%
온 7
 
1.2%
동 7
 
1.2%
전 7
 
1.2%
Other values (129) 267
44.6%
Common
ValueCountFrequency (%)
3
42.9%
( 2
28.6%
) 2
28.6%
Latin
ValueCountFrequency (%)
O 1
50.0%
K 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 599
98.5%
ASCII 9
 
1.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
국 128
21.4%
약 128
21.4%
한 15
 
2.5%
리 12
 
2.0%
대 12
 
2.0%
일 9
 
1.5%
우 7
 
1.2%
온 7
 
1.2%
동 7
 
1.2%
전 7
 
1.2%
Other values (129) 267
44.6%
ASCII
ValueCountFrequency (%)
3
33.3%
( 2
22.2%
) 2
22.2%
O 1
 
11.1%
K 1
 
11.1%

약국전화번호
Text

MISSING 

Distinct121
Distinct (%)98.4%
Missing3
Missing (%)2.4%
Memory size1.1 KiB
2023-12-13T03:18:15.641901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.01626
Min length12

Characters and Unicode

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

Unique119 ?
Unique (%)96.7%

Sample

1st row042-256-3731
2nd row042-282-6264
3rd row042-284-5554
4th row042-252-6336
5th row070-7636-9889
ValueCountFrequency (%)
042-273-9633 2
 
1.6%
042-271-8837 2
 
1.6%
042-625-8997 1
 
0.8%
042-625-2949 1
 
0.8%
042-286-2275 1
 
0.8%
042-624-3115 1
 
0.8%
042-622-5511 1
 
0.8%
042-286-2200 1
 
0.8%
042-631-6654 1
 
0.8%
042-257-3229 1
 
0.8%
Other values (111) 111
90.2%
2023-12-13T03:18:15.975625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 300
20.3%
- 246
16.6%
0 189
12.8%
4 158
10.7%
6 108
 
7.3%
7 104
 
7.0%
8 104
 
7.0%
3 93
 
6.3%
5 83
 
5.6%
1 47
 
3.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1232
83.4%
Dash Punctuation 246
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 300
24.4%
0 189
15.3%
4 158
12.8%
6 108
 
8.8%
7 104
 
8.4%
8 104
 
8.4%
3 93
 
7.5%
5 83
 
6.7%
1 47
 
3.8%
9 46
 
3.7%
Dash Punctuation
ValueCountFrequency (%)
- 246
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1478
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 300
20.3%
- 246
16.6%
0 189
12.8%
4 158
10.7%
6 108
 
7.3%
7 104
 
7.0%
8 104
 
7.0%
3 93
 
6.3%
5 83
 
5.6%
1 47
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1478
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 300
20.3%
- 246
16.6%
0 189
12.8%
4 158
10.7%
6 108
 
7.3%
7 104
 
7.0%
8 104
 
7.0%
3 93
 
6.3%
5 83
 
5.6%
1 47
 
3.2%

약국소재지(도로명)
Text

Distinct124
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-13T03:18:16.214628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length40
Mean length26.912698
Min length20

Characters and Unicode

Total characters3391
Distinct characters135
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

Unique122 ?
Unique (%)96.8%

Sample

1st row대전광역시 동구 동구청로 89-2, 제이타워 103호 (가오동)
2nd row대전광역시 동구 대전로 812, 1층 (정동)
3rd row대전광역시 동구 동대전로 72-1, 1층 (대동)
4th row대전광역시 동구 백룡로 145, 2층 (용운동)
5th row대전광역시 동구 대전로813번길 15, 1층 (중동)
ValueCountFrequency (%)
대전광역시 126
 
17.2%
동구 126
 
17.2%
1층 48
 
6.6%
계족로 16
 
2.2%
대전로 15
 
2.1%
용전동 14
 
1.9%
가오동 13
 
1.8%
동대전로 12
 
1.6%
가양동 11
 
1.5%
판암동 10
 
1.4%
Other values (208) 340
46.5%
2023-12-13T03:18:16.621178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
607
17.9%
동 297
 
8.8%
대 192
 
5.7%
전 184
 
5.4%
1 170
 
5.0%
구 130
 
3.8%
) 128
 
3.8%
( 128
 
3.8%
역 127
 
3.7%
시 127
 
3.7%
Other values (125) 1301
38.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1891
55.8%
Space Separator 607
 
17.9%
Decimal Number 544
 
16.0%
Close Punctuation 128
 
3.8%
Open Punctuation 128
 
3.8%
Other Punctuation 71
 
2.1%
Dash Punctuation 20
 
0.6%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 297
15.7%
대 192
 
10.2%
전 184
 
9.7%
구 130
 
6.9%
역 127
 
6.7%
시 127
 
6.7%
광 126
 
6.7%
로 126
 
6.7%
층 52
 
2.7%
가 26
 
1.4%
Other values (108) 504
26.7%
Decimal Number
ValueCountFrequency (%)
1 170
31.2%
2 58
 
10.7%
7 51
 
9.4%
0 47
 
8.6%
3 46
 
8.5%
8 42
 
7.7%
6 41
 
7.5%
5 34
 
6.2%
4 30
 
5.5%
9 25
 
4.6%
Uppercase Letter
ValueCountFrequency (%)
W 1
50.0%
E 1
50.0%
Space Separator
ValueCountFrequency (%)
607
100.0%
Close Punctuation
ValueCountFrequency (%)
) 128
100.0%
Open Punctuation
ValueCountFrequency (%)
( 128
100.0%
Other Punctuation
ValueCountFrequency (%)
, 71
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 20
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1891
55.8%
Common 1498
44.2%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 297
15.7%
대 192
 
10.2%
전 184
 
9.7%
구 130
 
6.9%
역 127
 
6.7%
시 127
 
6.7%
광 126
 
6.7%
로 126
 
6.7%
층 52
 
2.7%
가 26
 
1.4%
Other values (108) 504
26.7%
Common
ValueCountFrequency (%)
607
40.5%
1 170
 
11.3%
) 128
 
8.5%
( 128
 
8.5%
, 71
 
4.7%
2 58
 
3.9%
7 51
 
3.4%
0 47
 
3.1%
3 46
 
3.1%
8 42
 
2.8%
Other values (5) 150
 
10.0%
Latin
ValueCountFrequency (%)
W 1
50.0%
E 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1891
55.8%
ASCII 1500
44.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
607
40.5%
1 170
 
11.3%
) 128
 
8.5%
( 128
 
8.5%
, 71
 
4.7%
2 58
 
3.9%
7 51
 
3.4%
0 47
 
3.1%
3 46
 
3.1%
8 42
 
2.8%
Other values (7) 152
 
10.1%
Hangul
ValueCountFrequency (%)
동 297
15.7%
대 192
 
10.2%
전 184
 
9.7%
구 130
 
6.9%
역 127
 
6.7%
시 127
 
6.7%
광 126
 
6.7%
로 126
 
6.7%
층 52
 
2.7%
가 26
 
1.4%
Other values (108) 504
26.7%

Interactions

2023-12-13T03:18:14.385842image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-13T03:18:14.525507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:18:14.604046image/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>대전광역시 동구 동구청로 89-2, 제이타워 103호 (가오동)
12역전약국042-256-3731대전광역시 동구 대전로 812, 1층 (정동)
23민정약국042-282-6264대전광역시 동구 동대전로 72-1, 1층 (대동)
34용운태평양약국042-284-5554대전광역시 동구 백룡로 145, 2층 (용운동)
45백제당한약국042-252-6336대전광역시 동구 대전로813번길 15, 1층 (중동)
56예손약국070-7636-9889대전광역시 동구 계족로 63, 동대전농협 1층 (인동)
67봄약국042-624-7800대전광역시 동구 동대전로 161-1, 1층 (자양동)
78맑은샘약국042-286-2777대전광역시 동구 은어송로 55, 그린타워 1층 102호 (가오동)
89다온약국042-627-5678대전광역시 동구 홍도로 7, 1층 (홍도동)
910밝은우리약국042-273-3075대전광역시 동구 새들2길 30, 1층 104호 (신흥동)
순번약국명칭약국전화번호약국소재지(도로명)
116117신독일약국042-635-2300대전광역시 동구 우암로 310 (가양동)
117118대성당약국042-626-6388대전광역시 동구 계족로 324 (성남동)
118119신유약국042-625-0172대전광역시 동구 동서대로1748번길 82, 1층 (가양동)
119120동춘약국042-273-2244대전광역시 동구 대전로 788 (중동)
120121구일약국042-282-9108대전광역시 동구 대전로 646, 상가동 1층 101호 (효동, 효동현대아파트)
121122유신약국042-257-5054대전광역시 동구 대흥로 211-1 (원동)
122123버들온누리약국042-622-0036대전광역시 동구 동산초교로23번길 5 (홍도동)
123124남정약국042-623-1688대전광역시 동구 동대전로 59 (대동)
124125성모약국042-672-9707대전광역시 동구 동대전로 200 (자양동)
125126진문약국042-283-4238대전광역시 동구 충무로 193 (인동)