Overview

Dataset statistics

Number of variables4
Number of observations22
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory836.0 B
Average record size in memory38.0 B

Variable types

Categorical1
Text3

Dataset

Description순창군 의약품 판매업소 현황(구분, 업소명, 전화번호, 소재지) 입니다.
Author전라북도 순창군
URLhttps://www.data.go.kr/data/15055224/fileData.do

Alerts

업소명 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 15:32:20.619500
Analysis finished2023-12-12 15:32:20.936415
Duration0.32 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

Distinct5
Distinct (%)22.7%
Missing0
Missing (%)0.0%
Memory size308.0 B
약국
11 
한약업소(한약방)
5 
안전상비의약품판매업소
4 
약방(약업사)
 
1
특수장소지정소
 
1

Length

Max length11
Median length10
Mean length5.6818182
Min length2

Unique

Unique2 ?
Unique (%)9.1%

Sample

1st row약국
2nd row약국
3rd row약국
4th row약국
5th row약국

Common Values

ValueCountFrequency (%)
약국 11
50.0%
한약업소(한약방) 5
22.7%
안전상비의약품판매업소 4
 
18.2%
약방(약업사) 1
 
4.5%
특수장소지정소 1
 
4.5%

Length

2023-12-13T00:32:21.009002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:32:21.124417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 11
50.0%
한약업소(한약방 5
22.7%
안전상비의약품판매업소 4
 
18.2%
약방(약업사 1
 
4.5%
특수장소지정소 1
 
4.5%

업소명
Text

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size308.0 B
2023-12-13T00:32:21.307804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length6
Min length4

Characters and Unicode

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

Unique

Unique22 ?
Unique (%)100.0%

Sample

1st row제일약국
2nd row백제약국
3rd row순창약국
4th row다나약국
5th row그린약국
ValueCountFrequency (%)
세븐일레븐 2
 
7.7%
순창터미널점 2
 
7.7%
백제약국 1
 
3.8%
성제당한약방 1
 
3.8%
광명당한약방 1
 
3.8%
순화당한약방 1
 
3.8%
제일한약방 1
 
3.8%
강천산지정소 1
 
3.8%
전북순창점 1
 
3.8%
순창중앙병원점 1
 
3.8%
Other values (14) 14
53.8%
2023-12-13T00:32:21.646739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 17
 
12.9%
국 11
 
8.3%
순 7
 
5.3%
창 6
 
4.5%
방 6
 
4.5%
한 5
 
3.8%
제 4
 
3.0%
4
 
3.0%
븐 4
 
3.0%
일 4
 
3.0%
Other values (51) 64
48.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 126
95.5%
Space Separator 4
 
3.0%
Uppercase Letter 2
 
1.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 17
 
13.5%
국 11
 
8.7%
순 7
 
5.6%
창 6
 
4.8%
방 6
 
4.8%
한 5
 
4.0%
제 4
 
3.2%
븐 4
 
3.2%
일 4
 
3.2%
당 4
 
3.2%
Other values (48) 58
46.0%
Uppercase Letter
ValueCountFrequency (%)
C 1
50.0%
U 1
50.0%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 126
95.5%
Common 4
 
3.0%
Latin 2
 
1.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 17
 
13.5%
국 11
 
8.7%
순 7
 
5.6%
창 6
 
4.8%
방 6
 
4.8%
한 5
 
4.0%
제 4
 
3.2%
븐 4
 
3.2%
일 4
 
3.2%
당 4
 
3.2%
Other values (48) 58
46.0%
Latin
ValueCountFrequency (%)
C 1
50.0%
U 1
50.0%
Common
ValueCountFrequency (%)
4
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 126
95.5%
ASCII 6
 
4.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 17
 
13.5%
국 11
 
8.7%
순 7
 
5.6%
창 6
 
4.8%
방 6
 
4.8%
한 5
 
4.0%
제 4
 
3.2%
븐 4
 
3.2%
일 4
 
3.2%
당 4
 
3.2%
Other values (48) 58
46.0%
ASCII
ValueCountFrequency (%)
4
66.7%
C 1
 
16.7%
U 1
 
16.7%

전화번호
Text

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size308.0 B
2023-12-13T00:32:21.859021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique22 ?
Unique (%)100.0%

Sample

1st row063-653-2712
2nd row063-653-2233
3rd row063-653-4144
4th row063-653-7526
5th row063-653-1256
ValueCountFrequency (%)
063-653-2712 1
 
4.5%
063-653-2233 1
 
4.5%
063-653-0363 1
 
4.5%
063-652-6038 1
 
4.5%
063-652-3364 1
 
4.5%
063-653-2495 1
 
4.5%
063-652-4794 1
 
4.5%
063-653-0773 1
 
4.5%
063-653-9569 1
 
4.5%
063-653-4775 1
 
4.5%
Other values (12) 12
54.5%
2023-12-13T00:32:22.186802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 52
19.7%
3 49
18.6%
- 44
16.7%
5 31
11.7%
0 29
11.0%
2 15
 
5.7%
4 12
 
4.5%
7 10
 
3.8%
8 8
 
3.0%
1 7
 
2.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 220
83.3%
Dash Punctuation 44
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 52
23.6%
3 49
22.3%
5 31
14.1%
0 29
13.2%
2 15
 
6.8%
4 12
 
5.5%
7 10
 
4.5%
8 8
 
3.6%
1 7
 
3.2%
9 7
 
3.2%
Dash Punctuation
ValueCountFrequency (%)
- 44
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 264
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
6 52
19.7%
3 49
18.6%
- 44
16.7%
5 31
11.7%
0 29
11.0%
2 15
 
5.7%
4 12
 
4.5%
7 10
 
3.8%
8 8
 
3.0%
1 7
 
2.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 264
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 52
19.7%
3 49
18.6%
- 44
16.7%
5 31
11.7%
0 29
11.0%
2 15
 
5.7%
4 12
 
4.5%
7 10
 
3.8%
8 8
 
3.0%
1 7
 
2.7%

소재지
Text

Distinct20
Distinct (%)90.9%
Missing0
Missing (%)0.0%
Memory size308.0 B
2023-12-13T00:32:22.376427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length18
Mean length18.045455
Min length16

Characters and Unicode

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

Unique

Unique19 ?
Unique (%)86.4%

Sample

1st row전라북도 순창읍 순창로 232
2nd row전라북도 순창읍 순창로 229
3rd row전라북도 순창읍 순창로 228
4th row전라북도 순창읍 장류로 333
5th row전라북도 순창읍 옥천로 56
ValueCountFrequency (%)
전라북도 22
25.0%
순창읍 16
18.2%
장류로 6
 
6.8%
순창로 4
 
4.5%
남계로 3
 
3.4%
355 3
 
3.4%
구림면 2
 
2.3%
17 2
 
2.3%
산내길 1
 
1.1%
연산2길 1
 
1.1%
Other values (28) 28
31.8%
2023-12-13T00:32:22.705795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
110
27.7%
전 22
 
5.5%
북 22
 
5.5%
도 22
 
5.5%
순 22
 
5.5%
창 22
 
5.5%
라 22
 
5.5%
읍 16
 
4.0%
로 15
 
3.8%
1 12
 
3.0%
Other values (34) 112
28.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 221
55.7%
Space Separator 110
27.7%
Decimal Number 63
 
15.9%
Dash Punctuation 3
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 22
10.0%
북 22
10.0%
도 22
10.0%
순 22
10.0%
창 22
10.0%
라 22
10.0%
읍 16
 
7.2%
로 15
 
6.8%
길 7
 
3.2%
면 6
 
2.7%
Other values (22) 45
20.4%
Decimal Number
ValueCountFrequency (%)
1 12
19.0%
3 10
15.9%
2 10
15.9%
5 7
11.1%
9 6
9.5%
4 5
7.9%
6 4
 
6.3%
0 3
 
4.8%
7 3
 
4.8%
8 3
 
4.8%
Space Separator
ValueCountFrequency (%)
110
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 221
55.7%
Common 176
44.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 22
10.0%
북 22
10.0%
도 22
10.0%
순 22
10.0%
창 22
10.0%
라 22
10.0%
읍 16
 
7.2%
로 15
 
6.8%
길 7
 
3.2%
면 6
 
2.7%
Other values (22) 45
20.4%
Common
ValueCountFrequency (%)
110
62.5%
1 12
 
6.8%
3 10
 
5.7%
2 10
 
5.7%
5 7
 
4.0%
9 6
 
3.4%
4 5
 
2.8%
6 4
 
2.3%
0 3
 
1.7%
- 3
 
1.7%
Other values (2) 6
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 221
55.7%
ASCII 176
44.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
110
62.5%
1 12
 
6.8%
3 10
 
5.7%
2 10
 
5.7%
5 7
 
4.0%
9 6
 
3.4%
4 5
 
2.8%
6 4
 
2.3%
0 3
 
1.7%
- 3
 
1.7%
Other values (2) 6
 
3.4%
Hangul
ValueCountFrequency (%)
전 22
10.0%
북 22
10.0%
도 22
10.0%
순 22
10.0%
창 22
10.0%
라 22
10.0%
읍 16
 
7.2%
로 15
 
6.8%
길 7
 
3.2%
면 6
 
2.7%
Other values (22) 45
20.4%

Correlations

2023-12-13T00:32:22.805386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분업소명전화번호소재지
구분1.0001.0001.0000.965
업소명1.0001.0001.0001.000
전화번호1.0001.0001.0001.000
소재지0.9651.0001.0001.000

Missing values

2023-12-13T00:32:20.809849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:32:20.903985image/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약국제일약국063-653-2712전라북도 순창읍 순창로 232
1약국백제약국063-653-2233전라북도 순창읍 순창로 229
2약국순창약국063-653-4144전라북도 순창읍 순창로 228
3약국다나약국063-653-7526전라북도 순창읍 장류로 333
4약국그린약국063-653-1256전라북도 순창읍 옥천로 56
5약국사랑약국063-653-8894전라북도 순창읍 남계로 91
6약국순창솔약국063-653-2053전라북도 순창읍 장류로 364-1
7약국장인약국063-653-5508전라북도 순창읍 장류로 355
8약국동네약국063-652-3474전라북도 동계면 동계로 44
9약국복흥건강약국063-652-3001전라북도 복흥면 정산1길 9
구분업소명전화번호소재지
12안전상비의약품판매업소세븐일레븐 순창터미널점063-653-8711전라북도 순창읍 장류로 355
13안전상비의약품판매업소CU마트 순창터미널점063-653-4775전라북도 순창읍 장류로 355
14안전상비의약품판매업소미니스톱 순창중앙병원점063-653-9569전라북도 순창읍 순창로 101
15안전상비의약품판매업소세븐일레븐 전북순창점063-653-0773전라북도 순창읍 장류로 380
16특수장소지정소강천산지정소063-652-4794전라북도 팔덕면 강천산길 78
17한약업소(한약방)제일한약방063-653-2495전라북도 순창읍 순창10길 11-12
18한약업소(한약방)순화당한약방063-652-3364전라북도 순창읍 순창2길 17
19한약업소(한약방)광명당한약방063-652-6038전라북도 순창읍 남계로 94
20한약업소(한약방)성제당한약방063-653-0363전라북도 순창읍 남계로 69
21한약업소(한약방)우리한약방063-653-6685전라북도 구림면 산내길 263-94