Overview

Dataset statistics

Number of variables5
Number of observations147
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.9 KiB
Average record size in memory40.9 B

Variable types

Categorical2
Text3

Dataset

Description대전광역시 유성구 관내에 있는 약국현황으로 시도명, 시군구명, 약국명, 소재지도로명주소, 전화번호 등의 데이터를 제공합니다.
Author공공데이터포털
URLhttps://www.data.go.kr/data/15119292/fileData.do

Alerts

시도명 has constant value ""Constant
시군구명 has constant value ""Constant
약국명 has unique valuesUnique
소재지도로명주소 has unique valuesUnique

Reproduction

Analysis started2024-04-17 20:09:36.884405
Analysis finished2024-04-17 20:09:37.555309
Duration0.67 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
대전광역시
147 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대전광역시
2nd row대전광역시
3rd row대전광역시
4th row대전광역시
5th row대전광역시

Common Values

ValueCountFrequency (%)
대전광역시 147
100.0%

Length

2024-04-18T05:09:37.607944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T05:09:37.684617image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대전광역시 147
100.0%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
유성구
147 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row유성구
2nd row유성구
3rd row유성구
4th row유성구
5th row유성구

Common Values

ValueCountFrequency (%)
유성구 147
100.0%

Length

2024-04-18T05:09:37.774156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T05:09:37.846446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유성구 147
100.0%

약국명
Text

UNIQUE 

Distinct147
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2024-04-18T05:09:38.034852image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length8
Mean length5.2585034
Min length3

Characters and Unicode

Total characters773
Distinct characters186
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

Unique147 ?
Unique (%)100.0%

Sample

1st row우리약국
2nd row으뜸약국
3rd row유성대학약국
4th row셀메드큰사랑약국
5th row박진희약국
ValueCountFrequency (%)
약국 5
 
3.2%
한약국 2
 
1.3%
우리약국 1
 
0.6%
연화약국 1
 
0.6%
혜민온누리약국 1
 
0.6%
비타민태평양약국 1
 
0.6%
송강태평양약국 1
 
0.6%
미래약국 1
 
0.6%
행복한한약국 1
 
0.6%
코끼리901약국 1
 
0.6%
Other values (141) 141
90.4%
2024-04-18T05:09:38.353288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
국 148
 
19.1%
약 147
 
19.0%
한 19
 
2.5%
리 14
 
1.8%
성 14
 
1.8%
은 11
 
1.4%
평 10
 
1.3%
유 10
 
1.3%
온 9
 
1.2%
랑 9
 
1.2%
Other values (176) 382
49.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 754
97.5%
Space Separator 9
 
1.2%
Decimal Number 9
 
1.2%
Lowercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
국 148
19.6%
약 147
19.5%
한 19
 
2.5%
리 14
 
1.9%
성 14
 
1.9%
은 11
 
1.5%
평 10
 
1.3%
유 10
 
1.3%
온 9
 
1.2%
랑 9
 
1.2%
Other values (168) 363
48.1%
Decimal Number
ValueCountFrequency (%)
6 2
22.2%
5 2
22.2%
3 2
22.2%
9 1
11.1%
1 1
11.1%
0 1
11.1%
Space Separator
ValueCountFrequency (%)
9
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 754
97.5%
Common 18
 
2.3%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
국 148
19.6%
약 147
19.5%
한 19
 
2.5%
리 14
 
1.9%
성 14
 
1.9%
은 11
 
1.5%
평 10
 
1.3%
유 10
 
1.3%
온 9
 
1.2%
랑 9
 
1.2%
Other values (168) 363
48.1%
Common
ValueCountFrequency (%)
9
50.0%
6 2
 
11.1%
5 2
 
11.1%
3 2
 
11.1%
9 1
 
5.6%
1 1
 
5.6%
0 1
 
5.6%
Latin
ValueCountFrequency (%)
e 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 754
97.5%
ASCII 19
 
2.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
국 148
19.6%
약 147
19.5%
한 19
 
2.5%
리 14
 
1.9%
성 14
 
1.9%
은 11
 
1.5%
평 10
 
1.3%
유 10
 
1.3%
온 9
 
1.2%
랑 9
 
1.2%
Other values (168) 363
48.1%
ASCII
ValueCountFrequency (%)
9
47.4%
6 2
 
10.5%
5 2
 
10.5%
3 2
 
10.5%
9 1
 
5.3%
1 1
 
5.3%
0 1
 
5.3%
e 1
 
5.3%

소재지도로명주소
Text

UNIQUE 

Distinct147
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2024-04-18T05:09:38.566074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length56
Median length42
Mean length30.387755
Min length19

Characters and Unicode

Total characters4467
Distinct characters171
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

Unique147 ?
Unique (%)100.0%

Sample

1st row대전광역시 유성구 북유성대로 87 (지족동)
2nd row대전광역시 유성구 학하로 104 102호 (학하동)
3rd row대전광역시 유성구 북유성대로 89(지족동)
4th row대전광역시 유성구 문지로 291 효성프라자 1층 108호 (문지동)
5th row대전광역시 유성구 지족로 355 월드프라자 1층 104호 (지족동)
ValueCountFrequency (%)
대전광역시 147
 
15.9%
유성구 147
 
15.9%
1층 49
 
5.3%
봉명동 29
 
3.1%
지족동 20
 
2.2%
104호 13
 
1.4%
관평동 12
 
1.3%
계룡로 12
 
1.3%
102호 10
 
1.1%
송강동 10
 
1.1%
Other values (289) 477
51.5%
2024-04-18T05:09:38.895899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
779
 
17.4%
1 244
 
5.5%
대 206
 
4.6%
성 171
 
3.8%
동 165
 
3.7%
구 162
 
3.6%
유 162
 
3.6%
전 160
 
3.6%
시 151
 
3.4%
역 147
 
3.3%
Other values (161) 2120
47.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2607
58.4%
Space Separator 779
 
17.4%
Decimal Number 751
 
16.8%
Open Punctuation 147
 
3.3%
Close Punctuation 147
 
3.3%
Dash Punctuation 18
 
0.4%
Uppercase Letter 16
 
0.4%
Lowercase Letter 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 206
 
7.9%
성 171
 
6.6%
동 165
 
6.3%
구 162
 
6.2%
유 162
 
6.2%
전 160
 
6.1%
시 151
 
5.8%
역 147
 
5.6%
로 147
 
5.6%
광 147
 
5.6%
Other values (134) 989
37.9%
Uppercase Letter
ValueCountFrequency (%)
B 4
25.0%
Y 2
12.5%
C 2
12.5%
A 1
 
6.2%
J 1
 
6.2%
U 1
 
6.2%
N 1
 
6.2%
X 1
 
6.2%
K 1
 
6.2%
L 1
 
6.2%
Decimal Number
ValueCountFrequency (%)
1 244
32.5%
2 92
 
12.3%
0 88
 
11.7%
4 62
 
8.3%
7 54
 
7.2%
3 53
 
7.1%
5 50
 
6.7%
8 43
 
5.7%
6 36
 
4.8%
9 29
 
3.9%
Lowercase Letter
ValueCountFrequency (%)
c 1
50.0%
j 1
50.0%
Space Separator
ValueCountFrequency (%)
779
100.0%
Open Punctuation
ValueCountFrequency (%)
( 147
100.0%
Close Punctuation
ValueCountFrequency (%)
) 147
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2607
58.4%
Common 1842
41.2%
Latin 18
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 206
 
7.9%
성 171
 
6.6%
동 165
 
6.3%
구 162
 
6.2%
유 162
 
6.2%
전 160
 
6.1%
시 151
 
5.8%
역 147
 
5.6%
로 147
 
5.6%
광 147
 
5.6%
Other values (134) 989
37.9%
Common
ValueCountFrequency (%)
779
42.3%
1 244
 
13.2%
( 147
 
8.0%
) 147
 
8.0%
2 92
 
5.0%
0 88
 
4.8%
4 62
 
3.4%
7 54
 
2.9%
3 53
 
2.9%
5 50
 
2.7%
Other values (4) 126
 
6.8%
Latin
ValueCountFrequency (%)
B 4
22.2%
Y 2
11.1%
C 2
11.1%
A 1
 
5.6%
c 1
 
5.6%
j 1
 
5.6%
J 1
 
5.6%
U 1
 
5.6%
N 1
 
5.6%
X 1
 
5.6%
Other values (3) 3
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2607
58.4%
ASCII 1860
41.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
779
41.9%
1 244
 
13.1%
( 147
 
7.9%
) 147
 
7.9%
2 92
 
4.9%
0 88
 
4.7%
4 62
 
3.3%
7 54
 
2.9%
3 53
 
2.8%
5 50
 
2.7%
Other values (17) 144
 
7.7%
Hangul
ValueCountFrequency (%)
대 206
 
7.9%
성 171
 
6.6%
동 165
 
6.3%
구 162
 
6.2%
유 162
 
6.2%
전 160
 
6.1%
시 151
 
5.8%
역 147
 
5.6%
로 147
 
5.6%
광 147
 
5.6%
Other values (134) 989
37.9%

전화번호
Text

Distinct141
Distinct (%)95.9%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2024-04-18T05:09:39.096690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.013605
Min length12

Characters and Unicode

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

Unique140 ?
Unique (%)95.2%

Sample

1st row042-000-0000
2nd row042-335-0715
3rd row042-000-0000
4th row042-000-0000
5th row042-721-2355
ValueCountFrequency (%)
042-000-0000 7
 
4.8%
042-863-0675 1
 
0.7%
042-935-3007 1
 
0.7%
042-825-0706 1
 
0.7%
042-825-0822 1
 
0.7%
042-671-6678 1
 
0.7%
042-826-8533 1
 
0.7%
042-931-6375 1
 
0.7%
042-826-2276 1
 
0.7%
042-825-0030 1
 
0.7%
Other values (131) 131
89.1%
2024-04-18T05:09:39.391323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 303
17.2%
- 294
16.6%
0 272
15.4%
4 208
11.8%
8 159
9.0%
3 123
7.0%
5 107
 
6.1%
6 92
 
5.2%
7 92
 
5.2%
1 59
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1472
83.4%
Dash Punctuation 294
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 303
20.6%
0 272
18.5%
4 208
14.1%
8 159
10.8%
3 123
8.4%
5 107
 
7.3%
6 92
 
6.2%
7 92
 
6.2%
1 59
 
4.0%
9 57
 
3.9%
Dash Punctuation
ValueCountFrequency (%)
- 294
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1766
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 303
17.2%
- 294
16.6%
0 272
15.4%
4 208
11.8%
8 159
9.0%
3 123
7.0%
5 107
 
6.1%
6 92
 
5.2%
7 92
 
5.2%
1 59
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1766
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 303
17.2%
- 294
16.6%
0 272
15.4%
4 208
11.8%
8 159
9.0%
3 123
7.0%
5 107
 
6.1%
6 92
 
5.2%
7 92
 
5.2%
1 59
 
3.3%

Missing values

2024-04-18T05:09:37.523237image/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대전광역시유성구우리약국대전광역시 유성구 북유성대로 87 (지족동)042-000-0000
1대전광역시유성구으뜸약국대전광역시 유성구 학하로 104 102호 (학하동)042-335-0715
2대전광역시유성구유성대학약국대전광역시 유성구 북유성대로 89(지족동)042-000-0000
3대전광역시유성구셀메드큰사랑약국대전광역시 유성구 문지로 291 효성프라자 1층 108호 (문지동)042-000-0000
4대전광역시유성구박진희약국대전광역시 유성구 지족로 355 월드프라자 1층 104호 (지족동)042-721-2355
5대전광역시유성구예손약국대전광역시 유성구 대정로 23 홈플러스서대전점 1층 X4 YB호 (대정동)070-8648-2707
6대전광역시유성구유성건강약국대전광역시 유성구 계룡로155번길 26-12 1층 (봉명동)042-822-7627
7대전광역시유성구김약국대전광역시 유성구 봉산로 27 송강프라자 2층 209(일부)호 (송강동)042-933-7983
8대전광역시유성구올바른약국대전광역시 유성구 계룡로 142 지상1층 101호 (봉명동)042-822-5503
9대전광역시유성구유성365약국대전광역시 유성구 대학로 44 1층 111 112호 (봉명동)042-822-5548
시도명시군구명약국명소재지도로명주소전화번호
137대전광역시유성구한솔약국대전광역시 유성구 송강로 24 (송강동)042-933-5465
138대전광역시유성구엑스포약국대전광역시 유성구 엑스포로 488 (전민동)042-862-8230
139대전광역시유성구송강 솔약국대전광역시 유성구 봉산로 27 (송강동)042-936-7983
140대전광역시유성구성실약국대전광역시 유성구 유성대로 1728 (전민동)042-863-4407
141대전광역시유성구한빛약국대전광역시 유성구 어은로 57 (어은동 한빛아파트상가)042-862-0110
142대전광역시유성구나은약국대전광역시 유성구 원내로 57 1층 (원내동)042-541-1856
143대전광역시유성구명문약국대전광역시 유성구 계룡로 47 (봉명동)042-822-5422
144대전광역시유성구서울온누리약국대전광역시 유성구 장대로 30 (장대동)042-822-2187
145대전광역시유성구청주약국대전광역시 유성구 반석로 7 (반석동 애니빌프라자1층 104호)042-822-5433
146대전광역시유성구유성약국대전광역시 유성구 유성대로 740 (장대동)042-822-2926