Overview

Dataset statistics

Number of variables4
Number of observations612
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory19.3 KiB
Average record size in memory32.2 B

Variable types

Text2
Categorical1
DateTime1

Dataset

Description제주특별자치도 제주시 관내 안전상비 의약품 판매업 관련 현황 데이터를 제공합니다.
Author제주특별자치도 제주시
URLhttps://www.data.go.kr/data/15056177/fileData.do

Alerts

담당부서 has constant value ""Constant
데이터기준일자 has constant value ""Constant
판매점포명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 12:56:47.047631
Analysis finished2023-12-12 12:56:47.499229
Duration0.45 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

판매점포명
Text

UNIQUE 

Distinct612
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
2023-12-12T21:56:47.770495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length16
Mean length9.9166667
Min length4

Characters and Unicode

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

Unique

Unique612 ?
Unique (%)100.0%

Sample

1st row세븐일레븐오라사거리점
2nd row씨유제주연문로점
3rd row씨유외도일주점
4th row씨유제주월성로점
5th row세븐일레븐제주더테라스점
ValueCountFrequency (%)
씨유 88
 
10.1%
gs25 56
 
6.4%
세븐일레븐 48
 
5.5%
주)코리아세븐 35
 
4.0%
레몬비 9
 
1.0%
지에스25 7
 
0.8%
cu 4
 
0.5%
제주삼무점 3
 
0.3%
제주진군점 2
 
0.2%
제주문예회관점 2
 
0.2%
Other values (603) 617
70.8%
2023-12-12T21:56:48.316324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
598
 
9.9%
502
 
8.3%
457
 
7.5%
259
 
4.3%
253
 
4.2%
251
 
4.1%
244
 
4.0%
2 173
 
2.9%
5 172
 
2.8%
149
 
2.5%
Other values (288) 3011
49.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5101
84.1%
Decimal Number 349
 
5.8%
Uppercase Letter 269
 
4.4%
Space Separator 259
 
4.3%
Close Punctuation 45
 
0.7%
Open Punctuation 43
 
0.7%
Other Punctuation 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
598
 
11.7%
502
 
9.8%
457
 
9.0%
253
 
5.0%
251
 
4.9%
244
 
4.8%
149
 
2.9%
125
 
2.5%
120
 
2.4%
89
 
1.7%
Other values (268) 2313
45.3%
Uppercase Letter
ValueCountFrequency (%)
S 116
43.1%
G 114
42.4%
C 15
 
5.6%
U 14
 
5.2%
L 3
 
1.1%
H 2
 
0.7%
A 2
 
0.7%
B 1
 
0.4%
K 1
 
0.4%
J 1
 
0.4%
Decimal Number
ValueCountFrequency (%)
2 173
49.6%
5 172
49.3%
8 1
 
0.3%
6 1
 
0.3%
1 1
 
0.3%
7 1
 
0.3%
Space Separator
ValueCountFrequency (%)
259
100.0%
Close Punctuation
ValueCountFrequency (%)
) 45
100.0%
Open Punctuation
ValueCountFrequency (%)
( 43
100.0%
Other Punctuation
ValueCountFrequency (%)
. 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5101
84.1%
Common 699
 
11.5%
Latin 269
 
4.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
598
 
11.7%
502
 
9.8%
457
 
9.0%
253
 
5.0%
251
 
4.9%
244
 
4.8%
149
 
2.9%
125
 
2.5%
120
 
2.4%
89
 
1.7%
Other values (268) 2313
45.3%
Common
ValueCountFrequency (%)
259
37.1%
2 173
24.7%
5 172
24.6%
) 45
 
6.4%
( 43
 
6.2%
. 3
 
0.4%
8 1
 
0.1%
6 1
 
0.1%
1 1
 
0.1%
7 1
 
0.1%
Latin
ValueCountFrequency (%)
S 116
43.1%
G 114
42.4%
C 15
 
5.6%
U 14
 
5.2%
L 3
 
1.1%
H 2
 
0.7%
A 2
 
0.7%
B 1
 
0.4%
K 1
 
0.4%
J 1
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5101
84.1%
ASCII 968
 
15.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
598
 
11.7%
502
 
9.8%
457
 
9.0%
253
 
5.0%
251
 
4.9%
244
 
4.8%
149
 
2.9%
125
 
2.5%
120
 
2.4%
89
 
1.7%
Other values (268) 2313
45.3%
ASCII
ValueCountFrequency (%)
259
26.8%
2 173
17.9%
5 172
17.8%
S 116
12.0%
G 114
11.8%
) 45
 
4.6%
( 43
 
4.4%
C 15
 
1.5%
U 14
 
1.4%
L 3
 
0.3%
Other values (10) 14
 
1.4%
Distinct607
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
2023-12-12T21:56:48.781092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length26
Mean length20.004902
Min length17

Characters and Unicode

Total characters12243
Distinct characters157
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

Unique602 ?
Unique (%)98.4%

Sample

1st row제주특별자치도 제주시 오라남로 14-14
2nd row제주특별자치도 제주시 연문2길 3
3rd row제주특별자치도 제주시 일주서로 7269
4th row제주특별자치도 제주시 월성로 31
5th row제주특별자치도 제주시 연동6길 5
ValueCountFrequency (%)
제주특별자치도 612
24.0%
제주시 612
24.0%
애월읍 32
 
1.3%
조천읍 25
 
1.0%
중앙로 21
 
0.8%
한림읍 21
 
0.8%
구좌읍 17
 
0.7%
일주서로 17
 
0.7%
1 13
 
0.5%
2 13
 
0.5%
Other values (581) 1164
45.7%
2023-12-12T21:56:49.333600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1935
15.8%
1256
 
10.3%
1226
 
10.0%
632
 
5.2%
613
 
5.0%
612
 
5.0%
612
 
5.0%
612
 
5.0%
612
 
5.0%
469
 
3.8%
Other values (147) 3664
29.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8556
69.9%
Space Separator 1935
 
15.8%
Decimal Number 1705
 
13.9%
Dash Punctuation 47
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1256
14.7%
1226
14.3%
632
 
7.4%
613
 
7.2%
612
 
7.2%
612
 
7.2%
612
 
7.2%
612
 
7.2%
469
 
5.5%
252
 
2.9%
Other values (135) 1660
19.4%
Decimal Number
ValueCountFrequency (%)
1 366
21.5%
2 254
14.9%
3 183
10.7%
4 168
9.9%
7 144
 
8.4%
5 141
 
8.3%
6 141
 
8.3%
8 108
 
6.3%
0 104
 
6.1%
9 96
 
5.6%
Space Separator
ValueCountFrequency (%)
1935
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 47
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8556
69.9%
Common 3687
30.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1256
14.7%
1226
14.3%
632
 
7.4%
613
 
7.2%
612
 
7.2%
612
 
7.2%
612
 
7.2%
612
 
7.2%
469
 
5.5%
252
 
2.9%
Other values (135) 1660
19.4%
Common
ValueCountFrequency (%)
1935
52.5%
1 366
 
9.9%
2 254
 
6.9%
3 183
 
5.0%
4 168
 
4.6%
7 144
 
3.9%
5 141
 
3.8%
6 141
 
3.8%
8 108
 
2.9%
0 104
 
2.8%
Other values (2) 143
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8556
69.9%
ASCII 3687
30.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1935
52.5%
1 366
 
9.9%
2 254
 
6.9%
3 183
 
5.0%
4 168
 
4.6%
7 144
 
3.9%
5 141
 
3.8%
6 141
 
3.8%
8 108
 
2.9%
0 104
 
2.8%
Other values (2) 143
 
3.9%
Hangul
ValueCountFrequency (%)
1256
14.7%
1226
14.3%
632
 
7.4%
613
 
7.2%
612
 
7.2%
612
 
7.2%
612
 
7.2%
612
 
7.2%
469
 
5.5%
252
 
2.9%
Other values (135) 1660
19.4%

담당부서
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
제주보건소
612 

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 (%)
제주보건소 612
100.0%

Length

2023-12-12T21:56:49.474619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:56:49.587969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제주보건소 612
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
Minimum2021-08-23 00:00:00
Maximum2021-08-23 00:00:00
2023-12-12T21:56:49.667168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:56:49.761244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2023-12-12T21:56:47.374233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:56:47.459643image/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세븐일레븐오라사거리점제주특별자치도 제주시 오라남로 14-14제주보건소2021-08-23
1씨유제주연문로점제주특별자치도 제주시 연문2길 3제주보건소2021-08-23
2씨유외도일주점제주특별자치도 제주시 일주서로 7269제주보건소2021-08-23
3씨유제주월성로점제주특별자치도 제주시 월성로 31제주보건소2021-08-23
4세븐일레븐제주더테라스점제주특별자치도 제주시 연동6길 5제주보건소2021-08-23
5씨유제주이도남광점제주특별자치도 제주시 오복4길 30제주보건소2021-08-23
6지에스25제주중앙여고점제주특별자치도 제주시 남광로2길 39제주보건소2021-08-23
7지에스25도련희망점제주특별자치도 제주시 도련길 22제주보건소2021-08-23
8씨유제주용천점제주특별자치도 제주시 신광로10길 30제주보건소2021-08-23
9지에스25일도연수중길점제주특별자치도 제주시 연수중길 16제주보건소2021-08-23
판매점포명소재지담당부서데이터기준일자
602CU씨앤블루점제주특별자치도 제주시 애월읍 애월해안로 576제주보건소2021-08-23
603GS25한림오일장점제주특별자치도 제주시 한림읍 한수풀로 56제주보건소2021-08-23
604CU제주한림항점제주특별자치도 제주시 한림읍 한림해안로 160제주보건소2021-08-23
605GS25한림뉴월드점제주특별자치도 제주시 한림읍 한림북동길 26제주보건소2021-08-23
606CU한림점제주특별자치도 제주시 한림읍 한림로 698제주보건소2021-08-23
607CU한림중앙점제주특별자치도 제주시 한림읍 한림중앙로 23제주보건소2021-08-23
608CU제주애월점제주특별자치도 제주시 애월읍 애월로 121제주보건소2021-08-23
609CU제주하귀점제주특별자치도 제주시 애월읍 하귀로 35제주보건소2021-08-23
610CU하귀대성점제주특별자치도 제주시 애월읍 하귀로 74제주보건소2021-08-23
611씨유한림고림동점제주특별자치도 제주시 한림읍 중산간서로 4512제주보건소2021-08-23