Overview

Dataset statistics

Number of variables4
Number of observations24
Missing cells5
Missing cells (%)5.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory900.0 B
Average record size in memory37.5 B

Variable types

Categorical1
Text3

Dataset

Description순창군 의약품 판매업소 현황
Author전라북도 순창군
URLhttps://www.data.go.kr/data/15055221/fileData.do

Alerts

Unnamed: 1 has 1 (4.2%) missing valuesMissing
Unnamed: 2 has 3 (12.5%) missing valuesMissing
Unnamed: 3 has 1 (4.2%) missing valuesMissing

Reproduction

Analysis started2023-12-12 18:02:11.450524
Analysis finished2023-12-12 18:02:12.090624
Duration0.64 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순창군 의약품 판매업소 현황(2014. 9월 현재)
Categorical

Distinct7
Distinct (%)29.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
약국
10 
한약업소(한약방)
5 
안전상비의약품판매업소
4 
특수장소지정소
2 
<NA>
 
1
Other values (2)
2 

Length

Max length11
Median length9
Mean length5.6666667
Min length2

Unique

Unique3 ?
Unique (%)12.5%

Sample

1st row<NA>
2nd row구분
3rd row약국
4th row약국
5th row약국

Common Values

ValueCountFrequency (%)
약국 10
41.7%
한약업소(한약방) 5
20.8%
안전상비의약품판매업소 4
 
16.7%
특수장소지정소 2
 
8.3%
<NA> 1
 
4.2%
구분 1
 
4.2%
약방(약업사) 1
 
4.2%

Length

2023-12-13T03:02:12.173540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:02:12.315120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 10
41.7%
한약업소(한약방 5
20.8%
안전상비의약품판매업소 4
 
16.7%
특수장소지정소 2
 
8.3%
na 1
 
4.2%
구분 1
 
4.2%
약방(약업사 1
 
4.2%

Unnamed: 1
Text

MISSING 

Distinct23
Distinct (%)100.0%
Missing1
Missing (%)4.2%
Memory size324.0 B
2023-12-13T03:02:12.563437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length5.9565217
Min length3

Characters and Unicode

Total characters137
Distinct characters62
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

Unique23 ?
Unique (%)100.0%

Sample

1st row업소명
2nd row제일약국
3rd row백제약국
4th row순창약국
5th row다나약국
ValueCountFrequency (%)
세븐일레븐 2
 
7.4%
순창터미널점 2
 
7.4%
성제당한약방 1
 
3.7%
광명당한약방 1
 
3.7%
순화당한약방 1
 
3.7%
제일한약방 1
 
3.7%
강천산지정소 1
 
3.7%
외이리지정소 1
 
3.7%
전북순창점 1
 
3.7%
순창중앙병원점 1
 
3.7%
Other values (15) 15
55.6%
2023-12-13T03:02:12.969082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 16
 
11.7%
국 10
 
7.3%
순 7
 
5.1%
창 6
 
4.4%
방 6
 
4.4%
한 5
 
3.6%
븐 4
 
2.9%
점 4
 
2.9%
당 4
 
2.9%
일 4
 
2.9%
Other values (52) 71
51.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 131
95.6%
Space Separator 4
 
2.9%
Uppercase Letter 2
 
1.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 16
 
12.2%
국 10
 
7.6%
순 7
 
5.3%
창 6
 
4.6%
방 6
 
4.6%
한 5
 
3.8%
븐 4
 
3.1%
점 4
 
3.1%
당 4
 
3.1%
일 4
 
3.1%
Other values (49) 65
49.6%
Uppercase Letter
ValueCountFrequency (%)
U 1
50.0%
C 1
50.0%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 131
95.6%
Common 4
 
2.9%
Latin 2
 
1.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 16
 
12.2%
국 10
 
7.6%
순 7
 
5.3%
창 6
 
4.6%
방 6
 
4.6%
한 5
 
3.8%
븐 4
 
3.1%
점 4
 
3.1%
당 4
 
3.1%
일 4
 
3.1%
Other values (49) 65
49.6%
Latin
ValueCountFrequency (%)
U 1
50.0%
C 1
50.0%
Common
ValueCountFrequency (%)
4
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 131
95.6%
ASCII 6
 
4.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 16
 
12.2%
국 10
 
7.6%
순 7
 
5.3%
창 6
 
4.6%
방 6
 
4.6%
한 5
 
3.8%
븐 4
 
3.1%
점 4
 
3.1%
당 4
 
3.1%
일 4
 
3.1%
Other values (49) 65
49.6%
ASCII
ValueCountFrequency (%)
4
66.7%
U 1
 
16.7%
C 1
 
16.7%

Unnamed: 2
Text

MISSING 

Distinct21
Distinct (%)100.0%
Missing3
Missing (%)12.5%
Memory size324.0 B
2023-12-13T03:02:13.232163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length9.7142857
Min length4

Characters and Unicode

Total characters204
Distinct characters16
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

Unique21 ?
Unique (%)100.0%

Sample

1st row전화번호
2nd row 653-2712
3rd row 653-2233
4th row 653-4144
5th row 653-7526
ValueCountFrequency (%)
전화번호 1
 
4.8%
652-8419 1
 
4.8%
652-6038 1
 
4.8%
652-3364 1
 
4.8%
653-2495 1
 
4.8%
652-4794 1
 
4.8%
653-0773 1
 
4.8%
653-9569 1
 
4.8%
653-4775 1
 
4.8%
653-8711 1
 
4.8%
Other values (11) 11
52.4%
2023-12-13T03:02:13.556746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
40
19.6%
5 28
13.7%
6 26
12.7%
3 25
12.3%
- 20
9.8%
2 14
 
6.9%
4 10
 
4.9%
7 9
 
4.4%
1 7
 
3.4%
8 7
 
3.4%
Other values (6) 18
8.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 140
68.6%
Space Separator 40
 
19.6%
Dash Punctuation 20
 
9.8%
Other Letter 4
 
2.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 28
20.0%
6 26
18.6%
3 25
17.9%
2 14
10.0%
4 10
 
7.1%
7 9
 
6.4%
1 7
 
5.0%
8 7
 
5.0%
9 7
 
5.0%
0 7
 
5.0%
Other Letter
ValueCountFrequency (%)
전 1
25.0%
화 1
25.0%
번 1
25.0%
호 1
25.0%
Space Separator
ValueCountFrequency (%)
40
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 20
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 200
98.0%
Hangul 4
 
2.0%

Most frequent character per script

Common
ValueCountFrequency (%)
40
20.0%
5 28
14.0%
6 26
13.0%
3 25
12.5%
- 20
10.0%
2 14
 
7.0%
4 10
 
5.0%
7 9
 
4.5%
1 7
 
3.5%
8 7
 
3.5%
Other values (2) 14
 
7.0%
Hangul
ValueCountFrequency (%)
전 1
25.0%
화 1
25.0%
번 1
25.0%
호 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 200
98.0%
Hangul 4
 
2.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
40
20.0%
5 28
14.0%
6 26
13.0%
3 25
12.5%
- 20
10.0%
2 14
 
7.0%
4 10
 
5.0%
7 9
 
4.5%
1 7
 
3.5%
8 7
 
3.5%
Other values (2) 14
 
7.0%
Hangul
ValueCountFrequency (%)
전 1
25.0%
화 1
25.0%
번 1
25.0%
호 1
25.0%

Unnamed: 3
Text

MISSING 

Distinct21
Distinct (%)91.3%
Missing1
Missing (%)4.2%
Memory size324.0 B
2023-12-13T03:02:13.732869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length13
Mean length12.73913
Min length3

Characters and Unicode

Total characters293
Distinct characters46
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

Unique20 ?
Unique (%)87.0%

Sample

1st row소재지
2nd row 순창읍 순창로 232
3rd row 순창읍 순창로 229
4th row 순창읍 순창로 228
5th row 순창읍 장류로 333
ValueCountFrequency (%)
순창읍 16
23.9%
장류로 6
 
9.0%
순창로 4
 
6.0%
남계로 3
 
4.5%
355 3
 
4.5%
구림면 2
 
3.0%
17 2
 
3.0%
산내길 1
 
1.5%
78 1
 
1.5%
외이3길 1
 
1.5%
Other values (28) 28
41.8%
2023-12-13T03:02:14.291717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
88
30.0%
창 22
 
7.5%
순 22
 
7.5%
읍 16
 
5.5%
로 14
 
4.8%
3 12
 
4.1%
2 12
 
4.1%
1 12
 
4.1%
길 8
 
2.7%
5 7
 
2.4%
Other values (36) 80
27.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 136
46.4%
Space Separator 88
30.0%
Decimal Number 65
22.2%
Dash Punctuation 4
 
1.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
창 22
16.2%
순 22
16.2%
읍 16
11.8%
로 14
10.3%
길 8
 
5.9%
장 6
 
4.4%
면 6
 
4.4%
류 6
 
4.4%
산 4
 
2.9%
계 3
 
2.2%
Other values (24) 29
21.3%
Decimal Number
ValueCountFrequency (%)
3 12
18.5%
2 12
18.5%
1 12
18.5%
5 7
10.8%
9 6
9.2%
6 4
 
6.2%
7 3
 
4.6%
0 3
 
4.6%
4 3
 
4.6%
8 3
 
4.6%
Space Separator
ValueCountFrequency (%)
88
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 157
53.6%
Hangul 136
46.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
창 22
16.2%
순 22
16.2%
읍 16
11.8%
로 14
10.3%
길 8
 
5.9%
장 6
 
4.4%
면 6
 
4.4%
류 6
 
4.4%
산 4
 
2.9%
계 3
 
2.2%
Other values (24) 29
21.3%
Common
ValueCountFrequency (%)
88
56.1%
3 12
 
7.6%
2 12
 
7.6%
1 12
 
7.6%
5 7
 
4.5%
9 6
 
3.8%
- 4
 
2.5%
6 4
 
2.5%
7 3
 
1.9%
0 3
 
1.9%
Other values (2) 6
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 157
53.6%
Hangul 136
46.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
88
56.1%
3 12
 
7.6%
2 12
 
7.6%
1 12
 
7.6%
5 7
 
4.5%
9 6
 
3.8%
- 4
 
2.5%
6 4
 
2.5%
7 3
 
1.9%
0 3
 
1.9%
Other values (2) 6
 
3.8%
Hangul
ValueCountFrequency (%)
창 22
16.2%
순 22
16.2%
읍 16
11.8%
로 14
10.3%
길 8
 
5.9%
장 6
 
4.4%
면 6
 
4.4%
류 6
 
4.4%
산 4
 
2.9%
계 3
 
2.2%
Other values (24) 29
21.3%

Correlations

2023-12-13T03:02:14.373782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순창군 의약품 판매업소 현황(2014. 9월 현재)Unnamed: 1Unnamed: 2Unnamed: 3
순창군 의약품 판매업소 현황(2014. 9월 현재)1.0001.0001.0000.951
Unnamed: 11.0001.0001.0001.000
Unnamed: 21.0001.0001.0001.000
Unnamed: 30.9511.0001.0001.000

Missing values

2023-12-13T03:02:11.727279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:02:11.866220image/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.
2023-12-13T03:02:12.004278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

순창군 의약품 판매업소 현황(2014. 9월 현재)Unnamed: 1Unnamed: 2Unnamed: 3
0<NA><NA><NA><NA>
1구분업소명전화번호소재지
2약국제일약국653-2712순창읍 순창로 232
3약국백제약국653-2233순창읍 순창로 229
4약국순창약국653-4144순창읍 순창로 228
5약국다나약국653-7526순창읍 장류로 333
6약국그린약국653-1256순창읍 옥천로 56
7약국사랑약국653-8894순창읍 남계로 91
8약국순창솔약국653-2053순창읍 장류로 364-1
9약국장인약국653-5508순창읍 장류로 355
순창군 의약품 판매업소 현황(2014. 9월 현재)Unnamed: 1Unnamed: 2Unnamed: 3
14안전상비의약품판매업소CU마트 순창터미널점653-4775순창읍 장류로 355
15안전상비의약품판매업소미니스톱 순창중앙병원점653-9569순창읍 순창로 101
16안전상비의약품판매업소세븐일레븐 전북순창점653-0773순창읍 장류로 380
17특수장소지정소외이리지정소<NA>유등면 외이3길 22-3
18특수장소지정소강천산지정소652-4794팔덕면 강천산길 78
19한약업소(한약방)제일한약방653-2495순창읍 순창10길 11-12
20한약업소(한약방)순화당한약방652-3364순창읍 순창2길 17
21한약업소(한약방)광명당한약방652-6038순창읍 남계로 94
22한약업소(한약방)성제당한약방653-0363순창읍 남계로 69
23한약업소(한약방)우리한약방<NA>구림면 산내길 263-94