Overview

Dataset statistics

Number of variables5
Number of observations25
Missing cells5
Missing cells (%)4.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.1 KiB
Average record size in memory45.3 B

Variable types

Categorical2
Text3

Dataset

Description순창군 관내 의약품 판매업소 현황(2015. 1월 현재)
Author전라북도 순창군
URLhttps://www.data.go.kr/data/15055222/fileData.do

Alerts

순창군 의약품 판매업소 현황(2015. 1월 현재) is highly overall correlated with Unnamed: 1High correlation
Unnamed: 1 is highly overall correlated with 순창군 의약품 판매업소 현황(2015. 1월 현재)High correlation
Unnamed: 2 has 1 (4.0%) missing valuesMissing
Unnamed: 3 has 3 (12.0%) missing valuesMissing
Unnamed: 4 has 1 (4.0%) missing valuesMissing

Reproduction

Analysis started2023-12-12 18:26:08.555284
Analysis finished2023-12-12 18:26:09.260626
Duration0.71 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

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

HIGH CORRELATION 

Distinct9
Distinct (%)36.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
순창읍
16 
구림면
2 
<NA>
 
1
읍면명
 
1
동계면
 
1
Other values (4)
4 

Length

Max length4
Median length3
Mean length3.04
Min length3

Unique

Unique7 ?
Unique (%)28.0%

Sample

1st row<NA>
2nd row읍면명
3rd row순창읍
4th row순창읍
5th row순창읍

Common Values

ValueCountFrequency (%)
순창읍 16
64.0%
구림면 2
 
8.0%
<NA> 1
 
4.0%
읍면명 1
 
4.0%
동계면 1
 
4.0%
복흥면 1
 
4.0%
쌍치면 1
 
4.0%
유등면 1
 
4.0%
팔덕면 1
 
4.0%

Length

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

Common Values (Plot)

2023-12-13T03:26:09.524400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
순창읍 16
64.0%
구림면 2
 
8.0%
na 1
 
4.0%
읍면명 1
 
4.0%
동계면 1
 
4.0%
복흥면 1
 
4.0%
쌍치면 1
 
4.0%
유등면 1
 
4.0%
팔덕면 1
 
4.0%

Unnamed: 1
Categorical

HIGH CORRELATION 

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

Length

Max length11
Median length9
Mean length5.52
Min length2

Unique

Unique3 ?
Unique (%)12.0%

Sample

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

Common Values

ValueCountFrequency (%)
약국 11
44.0%
한약업소(한약방) 5
20.0%
안전상비의약품판매업소 4
 
16.0%
특수장소지정소 2
 
8.0%
<NA> 1
 
4.0%
구분 1
 
4.0%
약방(약업사) 1
 
4.0%

Length

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

Common Values (Plot)

2023-12-13T03:26:09.896629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 11
44.0%
한약업소(한약방 5
20.0%
안전상비의약품판매업소 4
 
16.0%
특수장소지정소 2
 
8.0%
na 1
 
4.0%
구분 1
 
4.0%
약방(약업사 1
 
4.0%

Unnamed: 2
Text

MISSING 

Distinct24
Distinct (%)100.0%
Missing1
Missing (%)4.0%
Memory size332.0 B
2023-12-13T03:26:10.124862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length5.875
Min length3

Characters and Unicode

Total characters141
Distinct characters64
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

Unique24 ?
Unique (%)100.0%

Sample

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

Most occurring characters

ValueCountFrequency (%)
약 17
 
12.1%
국 11
 
7.8%
순 7
 
5.0%
방 6
 
4.3%
창 6
 
4.3%
한 5
 
3.5%
븐 4
 
2.8%
4
 
2.8%
당 4
 
2.8%
제 4
 
2.8%
Other values (54) 73
51.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 135
95.7%
Space Separator 4
 
2.8%
Uppercase Letter 2
 
1.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 17
 
12.6%
국 11
 
8.1%
순 7
 
5.2%
방 6
 
4.4%
창 6
 
4.4%
한 5
 
3.7%
븐 4
 
3.0%
당 4
 
3.0%
제 4
 
3.0%
일 4
 
3.0%
Other values (51) 67
49.6%
Uppercase Letter
ValueCountFrequency (%)
U 1
50.0%
C 1
50.0%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 135
95.7%
Common 4
 
2.8%
Latin 2
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 17
 
12.6%
국 11
 
8.1%
순 7
 
5.2%
방 6
 
4.4%
창 6
 
4.4%
한 5
 
3.7%
븐 4
 
3.0%
당 4
 
3.0%
제 4
 
3.0%
일 4
 
3.0%
Other values (51) 67
49.6%
Latin
ValueCountFrequency (%)
U 1
50.0%
C 1
50.0%
Common
ValueCountFrequency (%)
4
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 135
95.7%
ASCII 6
 
4.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 17
 
12.6%
국 11
 
8.1%
순 7
 
5.2%
방 6
 
4.4%
창 6
 
4.4%
한 5
 
3.7%
븐 4
 
3.0%
당 4
 
3.0%
제 4
 
3.0%
일 4
 
3.0%
Other values (51) 67
49.6%
ASCII
ValueCountFrequency (%)
4
66.7%
U 1
 
16.7%
C 1
 
16.7%

Unnamed: 3
Text

MISSING 

Distinct22
Distinct (%)100.0%
Missing3
Missing (%)12.0%
Memory size332.0 B
2023-12-13T03:26:10.757436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length9.7272727
Min length4

Characters and Unicode

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

Unique22 ?
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.5%
653-2712 1
 
4.5%
652-6038 1
 
4.5%
652-3364 1
 
4.5%
653-2495 1
 
4.5%
652-4794 1
 
4.5%
653-0773 1
 
4.5%
653-9569 1
 
4.5%
653-4775 1
 
4.5%
653-8711 1
 
4.5%
Other values (12) 12
54.5%
2023-12-13T03:26:11.134626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
42
19.6%
5 29
13.6%
6 27
12.6%
3 26
12.1%
- 21
9.8%
2 15
 
7.0%
4 12
 
5.6%
7 10
 
4.7%
1 7
 
3.3%
8 7
 
3.3%
Other values (6) 18
8.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 147
68.7%
Space Separator 42
 
19.6%
Dash Punctuation 21
 
9.8%
Other Letter 4
 
1.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 29
19.7%
6 27
18.4%
3 26
17.7%
2 15
10.2%
4 12
8.2%
7 10
 
6.8%
1 7
 
4.8%
8 7
 
4.8%
9 7
 
4.8%
0 7
 
4.8%
Other Letter
ValueCountFrequency (%)
전 1
25.0%
화 1
25.0%
번 1
25.0%
호 1
25.0%
Space Separator
ValueCountFrequency (%)
42
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 21
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 210
98.1%
Hangul 4
 
1.9%

Most frequent character per script

Common
ValueCountFrequency (%)
42
20.0%
5 29
13.8%
6 27
12.9%
3 26
12.4%
- 21
10.0%
2 15
 
7.1%
4 12
 
5.7%
7 10
 
4.8%
1 7
 
3.3%
8 7
 
3.3%
Other values (2) 14
 
6.7%
Hangul
ValueCountFrequency (%)
전 1
25.0%
화 1
25.0%
번 1
25.0%
호 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 210
98.1%
Hangul 4
 
1.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
42
20.0%
5 29
13.8%
6 27
12.9%
3 26
12.4%
- 21
10.0%
2 15
 
7.1%
4 12
 
5.7%
7 10
 
4.8%
1 7
 
3.3%
8 7
 
3.3%
Other values (2) 14
 
6.7%
Hangul
ValueCountFrequency (%)
전 1
25.0%
화 1
25.0%
번 1
25.0%
호 1
25.0%

Unnamed: 4
Text

MISSING 

Distinct22
Distinct (%)91.7%
Missing1
Missing (%)4.0%
Memory size332.0 B
2023-12-13T03:26:11.368247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length16.5
Mean length12.708333
Min length3

Characters and Unicode

Total characters305
Distinct characters47
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 (%)87.5%

Sample

1st row소재지
2nd row 순창읍 순창로 232
3rd row 순창읍 순창로 229
4th row 순창읍 순창로 228
5th row 순창읍 장류로 333
ValueCountFrequency (%)
순창읍 16
22.9%
장류로 6
 
8.6%
순창로 4
 
5.7%
355 3
 
4.3%
남계로 3
 
4.3%
17 2
 
2.9%
구림면 2
 
2.9%
232 1
 
1.4%
11-12 1
 
1.4%
외이3길 1
 
1.4%
Other values (31) 31
44.3%
2023-12-13T03:26:11.767221image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
92
30.2%
창 22
 
7.2%
순 22
 
7.2%
읍 16
 
5.2%
로 15
 
4.9%
3 12
 
3.9%
2 12
 
3.9%
1 12
 
3.9%
길 8
 
2.6%
5 7
 
2.3%
Other values (37) 87
28.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 142
46.6%
Space Separator 92
30.2%
Decimal Number 67
22.0%
Dash Punctuation 4
 
1.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
창 22
15.5%
순 22
15.5%
읍 16
11.3%
로 15
10.6%
길 8
 
5.6%
면 7
 
4.9%
장 6
 
4.2%
류 6
 
4.2%
계 5
 
3.5%
산 4
 
2.8%
Other values (25) 31
21.8%
Decimal Number
ValueCountFrequency (%)
3 12
17.9%
2 12
17.9%
1 12
17.9%
5 7
10.4%
9 6
9.0%
4 5
7.5%
6 4
 
6.0%
8 3
 
4.5%
0 3
 
4.5%
7 3
 
4.5%
Space Separator
ValueCountFrequency (%)
92
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 163
53.4%
Hangul 142
46.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
창 22
15.5%
순 22
15.5%
읍 16
11.3%
로 15
10.6%
길 8
 
5.6%
면 7
 
4.9%
장 6
 
4.2%
류 6
 
4.2%
계 5
 
3.5%
산 4
 
2.8%
Other values (25) 31
21.8%
Common
ValueCountFrequency (%)
92
56.4%
3 12
 
7.4%
2 12
 
7.4%
1 12
 
7.4%
5 7
 
4.3%
9 6
 
3.7%
4 5
 
3.1%
- 4
 
2.5%
6 4
 
2.5%
8 3
 
1.8%
Other values (2) 6
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 163
53.4%
Hangul 142
46.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
92
56.4%
3 12
 
7.4%
2 12
 
7.4%
1 12
 
7.4%
5 7
 
4.3%
9 6
 
3.7%
4 5
 
3.1%
- 4
 
2.5%
6 4
 
2.5%
8 3
 
1.8%
Other values (2) 6
 
3.7%
Hangul
ValueCountFrequency (%)
창 22
15.5%
순 22
15.5%
읍 16
11.3%
로 15
10.6%
길 8
 
5.6%
면 7
 
4.9%
장 6
 
4.2%
류 6
 
4.2%
계 5
 
3.5%
산 4
 
2.8%
Other values (25) 31
21.8%

Correlations

2023-12-13T03:26:11.863478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순창군 의약품 판매업소 현황(2015. 1월 현재)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4
순창군 의약품 판매업소 현황(2015. 1월 현재)1.0000.7851.0001.0001.000
Unnamed: 10.7851.0001.0001.0000.944
Unnamed: 21.0001.0001.0001.0001.000
Unnamed: 31.0001.0001.0001.0001.000
Unnamed: 41.0000.9441.0001.0001.000
2023-12-13T03:26:11.986902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순창군 의약품 판매업소 현황(2015. 1월 현재)Unnamed: 1
순창군 의약품 판매업소 현황(2015. 1월 현재)1.0000.546
Unnamed: 10.5461.000
2023-12-13T03:26:12.095668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순창군 의약품 판매업소 현황(2015. 1월 현재)Unnamed: 1
순창군 의약품 판매업소 현황(2015. 1월 현재)1.0000.546
Unnamed: 10.5461.000

Missing values

2023-12-13T03:26:08.880505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:26:09.008149image/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:26:09.167401image/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

순창군 의약품 판매업소 현황(2015. 1월 현재)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4
0<NA><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
순창군 의약품 판매업소 현황(2015. 1월 현재)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4
15순창읍안전상비의약품판매업소CU마트 순창터미널점653-4775순창읍 장류로 355
16순창읍안전상비의약품판매업소미니스톱 순창중앙병원점653-9569순창읍 순창로 101
17순창읍안전상비의약품판매업소세븐일레븐 전북순창점653-0773순창읍 장류로 380
18유등면특수장소지정소외이리지정소<NA>유등면 외이3길 22-3
19팔덕면특수장소지정소강천산지정소652-4794팔덕면 강천산길 78
20순창읍한약업소(한약방)제일한약방653-2495순창읍 순창10길 11-12
21순창읍한약업소(한약방)순화당한약방652-3364순창읍 순창2길 17
22순창읍한약업소(한약방)광명당한약방652-6038순창읍 남계로 94
23순창읍한약업소(한약방)성제당한약방653-0363순창읍 남계로 69
24구림면한약업소(한약방)우리한약방<NA>구림면 산내길 263-94