Overview

Dataset statistics

Number of variables4
Number of observations163
Missing cells163
Missing cells (%)25.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.4 KiB
Average record size in memory33.8 B

Variable types

Categorical1
Text2
Unsupported1

Dataset

Description전북특별자치도 완주군에 소재한 의료기기판매업소 현황(영업의 구분, 영업소명, 영업소 소재지)에 관한 데이터 입니다.
Author전북특별자치도 완주군
URLhttps://www.data.go.kr/data/3076587/fileData.do

Alerts

영업의구분 is highly imbalanced (85.6%)Imbalance
Unnamed: 3 has 163 (100.0%) missing valuesMissing
영업소명 has unique valuesUnique
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-04-21 02:50:30.569793
Analysis finished2024-04-21 02:50:31.222754
Duration0.65 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

영업의구분
Categorical

IMBALANCE 

Distinct3
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
판매업
158 
판매(임대)업
 
3
임대업
 
2

Length

Max length7
Median length3
Mean length3.0736196
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row판매업
2nd row판매업
3rd row판매업
4th row판매업
5th row판매업

Common Values

ValueCountFrequency (%)
판매업 158
96.9%
판매(임대)업 3
 
1.8%
임대업 2
 
1.2%

Length

2024-04-21T11:50:31.289647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T11:50:31.407338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
판매업 158
96.9%
판매(임대)업 3
 
1.8%
임대업 2
 
1.2%

영업소명
Text

UNIQUE 

Distinct163
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-04-21T11:50:31.613625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length18
Mean length8.9079755
Min length2

Characters and Unicode

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

Unique

Unique163 ?
Unique (%)100.0%

Sample

1st row지에스25 완주혁신행복점
2nd row제이비메디
3rd row제이
4th row주식회사 이커머스
5th row이마트24 완주봉동로점
ValueCountFrequency (%)
gs25 19
 
7.2%
씨유 15
 
5.7%
세븐일레븐 14
 
5.3%
주식회사 6
 
2.3%
이마트24 5
 
1.9%
유한회사 5
 
1.9%
cu 4
 
1.5%
지에스25 4
 
1.5%
완주용진점 3
 
1.1%
전주혁신점 2
 
0.8%
Other values (183) 187
70.8%
2024-04-21T11:50:31.952325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
101
 
7.0%
점 84
 
5.8%
주 74
 
5.1%
완 46
 
3.2%
이 42
 
2.9%
2 36
 
2.5%
븐 34
 
2.3%
5 30
 
2.1%
G 27
 
1.9%
S 27
 
1.9%
Other values (235) 951
65.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1171
80.6%
Space Separator 101
 
7.0%
Uppercase Letter 75
 
5.2%
Decimal Number 73
 
5.0%
Open Punctuation 13
 
0.9%
Close Punctuation 13
 
0.9%
Dash Punctuation 3
 
0.2%
Lowercase Letter 2
 
0.1%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 84
 
7.2%
주 74
 
6.3%
완 46
 
3.9%
이 42
 
3.6%
븐 34
 
2.9%
유 26
 
2.2%
씨 21
 
1.8%
세 20
 
1.7%
동 19
 
1.6%
봉 19
 
1.6%
Other values (214) 786
67.1%
Uppercase Letter
ValueCountFrequency (%)
G 27
36.0%
S 27
36.0%
C 9
 
12.0%
U 4
 
5.3%
I 3
 
4.0%
R 2
 
2.7%
H 1
 
1.3%
N 1
 
1.3%
K 1
 
1.3%
Decimal Number
ValueCountFrequency (%)
2 36
49.3%
5 30
41.1%
4 5
 
6.8%
1 1
 
1.4%
3 1
 
1.4%
Lowercase Letter
ValueCountFrequency (%)
y 1
50.0%
h 1
50.0%
Space Separator
ValueCountFrequency (%)
101
100.0%
Open Punctuation
ValueCountFrequency (%)
( 13
100.0%
Close Punctuation
ValueCountFrequency (%)
) 13
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1171
80.6%
Common 204
 
14.0%
Latin 77
 
5.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 84
 
7.2%
주 74
 
6.3%
완 46
 
3.9%
이 42
 
3.6%
븐 34
 
2.9%
유 26
 
2.2%
씨 21
 
1.8%
세 20
 
1.7%
동 19
 
1.6%
봉 19
 
1.6%
Other values (214) 786
67.1%
Latin
ValueCountFrequency (%)
G 27
35.1%
S 27
35.1%
C 9
 
11.7%
U 4
 
5.2%
I 3
 
3.9%
R 2
 
2.6%
y 1
 
1.3%
h 1
 
1.3%
H 1
 
1.3%
N 1
 
1.3%
Common
ValueCountFrequency (%)
101
49.5%
2 36
 
17.6%
5 30
 
14.7%
( 13
 
6.4%
) 13
 
6.4%
4 5
 
2.5%
- 3
 
1.5%
1 1
 
0.5%
& 1
 
0.5%
3 1
 
0.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1171
80.6%
ASCII 281
 
19.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
101
35.9%
2 36
 
12.8%
5 30
 
10.7%
G 27
 
9.6%
S 27
 
9.6%
( 13
 
4.6%
) 13
 
4.6%
C 9
 
3.2%
4 5
 
1.8%
U 4
 
1.4%
Other values (11) 16
 
5.7%
Hangul
ValueCountFrequency (%)
점 84
 
7.2%
주 74
 
6.3%
완 46
 
3.9%
이 42
 
3.6%
븐 34
 
2.9%
유 26
 
2.2%
씨 21
 
1.8%
세 20
 
1.7%
동 19
 
1.6%
봉 19
 
1.6%
Other values (214) 786
67.1%

영업소소재지(도로명)
Text

Distinct159
Distinct (%)97.5%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-04-21T11:50:32.291831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length60
Median length51
Mean length28.190184
Min length21

Characters and Unicode

Total characters4595
Distinct characters173
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

Unique155 ?
Unique (%)95.1%

Sample

1st row전북특별자치도 완주군 이서면 갈산1로 11
2nd row전북특별자치도 완주군 이서면 정농대농길 48, 1층
3rd row전북특별자치도 완주군 삼례읍 만경하서길 30, 1층 101호
4th row전북특별자치도 완주군 이서면 출판로 46-12, 54층 502호
5th row전북특별자치도 완주군 봉동읍 봉동로 326
ValueCountFrequency (%)
전북특별자치도 163
 
17.5%
완주군 163
 
17.5%
봉동읍 51
 
5.5%
이서면 39
 
4.2%
삼례읍 36
 
3.9%
1층 21
 
2.3%
소양면 11
 
1.2%
용진읍 10
 
1.1%
봉동동서로 9
 
1.0%
동학로 8
 
0.9%
Other values (274) 420
45.1%
2024-04-21T11:50:32.789653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
768
 
16.7%
1 192
 
4.2%
주 189
 
4.1%
완 181
 
3.9%
전 173
 
3.8%
북 167
 
3.6%
도 166
 
3.6%
치 165
 
3.6%
자 163
 
3.5%
별 163
 
3.5%
Other values (163) 2268
49.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3027
65.9%
Space Separator 768
 
16.7%
Decimal Number 664
 
14.5%
Other Punctuation 63
 
1.4%
Dash Punctuation 42
 
0.9%
Close Punctuation 15
 
0.3%
Open Punctuation 15
 
0.3%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 189
 
6.2%
완 181
 
6.0%
전 173
 
5.7%
북 167
 
5.5%
도 166
 
5.5%
치 165
 
5.5%
자 163
 
5.4%
별 163
 
5.4%
특 163
 
5.4%
군 163
 
5.4%
Other values (147) 1334
44.1%
Decimal Number
ValueCountFrequency (%)
1 192
28.9%
2 96
14.5%
3 87
13.1%
0 70
 
10.5%
4 50
 
7.5%
6 44
 
6.6%
7 42
 
6.3%
5 37
 
5.6%
9 25
 
3.8%
8 21
 
3.2%
Space Separator
ValueCountFrequency (%)
768
100.0%
Other Punctuation
ValueCountFrequency (%)
, 63
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 42
100.0%
Close Punctuation
ValueCountFrequency (%)
) 15
100.0%
Open Punctuation
ValueCountFrequency (%)
( 15
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3027
65.9%
Common 1567
34.1%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 189
 
6.2%
완 181
 
6.0%
전 173
 
5.7%
북 167
 
5.5%
도 166
 
5.5%
치 165
 
5.5%
자 163
 
5.4%
별 163
 
5.4%
특 163
 
5.4%
군 163
 
5.4%
Other values (147) 1334
44.1%
Common
ValueCountFrequency (%)
768
49.0%
1 192
 
12.3%
2 96
 
6.1%
3 87
 
5.6%
0 70
 
4.5%
, 63
 
4.0%
4 50
 
3.2%
6 44
 
2.8%
7 42
 
2.7%
- 42
 
2.7%
Other values (5) 113
 
7.2%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3027
65.9%
ASCII 1568
34.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
768
49.0%
1 192
 
12.2%
2 96
 
6.1%
3 87
 
5.5%
0 70
 
4.5%
, 63
 
4.0%
4 50
 
3.2%
6 44
 
2.8%
7 42
 
2.7%
- 42
 
2.7%
Other values (6) 114
 
7.3%
Hangul
ValueCountFrequency (%)
주 189
 
6.2%
완 181
 
6.0%
전 173
 
5.7%
북 167
 
5.5%
도 166
 
5.5%
치 165
 
5.5%
자 163
 
5.4%
별 163
 
5.4%
특 163
 
5.4%
군 163
 
5.4%
Other values (147) 1334
44.1%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing163
Missing (%)100.0%
Memory size1.6 KiB

Missing values

2024-04-21T11:50:31.104276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T11:50:31.190065image/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

영업의구분영업소명영업소소재지(도로명)Unnamed: 3
0판매업지에스25 완주혁신행복점전북특별자치도 완주군 이서면 갈산1로 11<NA>
1판매업제이비메디전북특별자치도 완주군 이서면 정농대농길 48, 1층<NA>
2판매업제이전북특별자치도 완주군 삼례읍 만경하서길 30, 1층 101호<NA>
3판매업주식회사 이커머스전북특별자치도 완주군 이서면 출판로 46-12, 54층 502호<NA>
4판매업이마트24 완주봉동로점전북특별자치도 완주군 봉동읍 봉동로 326<NA>
5판매업유한회사 에스엠엔씨전북특별자치도 완주군 구이면 모악산길 111-21, 101동 3층 302호<NA>
6판매업CU 혁신중앙점전북특별자치도 완주군 이서면 오공로 11-19, 102호<NA>
7판매업(주)코리아세븐 완주이서혁신점전북특별자치도 완주군 이서면 콩쥐팥쥐로 1047<NA>
8판매업GS25 완주본점전북특별자치도 완주군 봉동읍 완주산단7로 65, 새벽농축산<NA>
9판매업GS25 완주모아미래도점전북특별자치도 완주군 용진읍 운곡4로 20, 상가동 B117, 118호 (모아미래도 센트럴시티 1차 아파트)<NA>
영업의구분영업소명영업소소재지(도로명)Unnamed: 3
153판매업첨단보청기전북특별자치도 완주군 봉동읍 둔산1로 130 (코아루아파트 2차상가 106호)<NA>
154판매업유한회사 장수하늘소전북특별자치도 완주군 이서면 콩쥐팥쥐로 1043-7<NA>
155판매업참사랑복지용구전북특별자치도 완주군 소양면 소양로 229<NA>
156판매업허브앤메디전북특별자치도 완주군 봉동읍 봉동동서로 173-12<NA>
157판매업영광메디칼전북특별자치도 완주군 소양면 전진로 1021, 2층<NA>
158판매업미래종합의료기상사전북특별자치도 완주군 봉동읍 봉동동서로 136<NA>
159판매업바이오세라전북특별자치도 완주군 봉동읍 만경강로 727-10<NA>
160판매업금강디지털보청기 완주봉동점전북특별자치도 완주군 봉동읍 봉동로 163, 1층<NA>
161판매업금강보청기전북특별자치도 완주군 삼례읍 동학로 32<NA>
162판매업동방메디텍전북특별자치도 완주군 삼례읍 원후동길 12-4<NA>