Overview

Dataset statistics

Number of variables4
Number of observations150
Missing cells109
Missing cells (%)18.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.8 KiB
Average record size in memory32.9 B

Variable types

Text3
Categorical1

Dataset

Description전라북도 정읍시에서 제공하는 소재 의료기기 판매업소 현황 중(업소명, 소재지도로명주소, 전화번호)등의 자료를 제공합니다.
Author전라북도 정읍시
URLhttps://www.data.go.kr/data/3073951/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 109 (72.7%) missing valuesMissing
업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-16 15:37:40.513660
Analysis finished2023-12-16 15:37:42.194774
Duration1.68 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업소명
Text

UNIQUE 

Distinct150
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-16T15:37:42.837187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length14
Mean length8.1733333
Min length2

Characters and Unicode

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

Unique

Unique150 ?
Unique (%)100.0%

Sample

1st row송강교역
2nd row씨유정읍제일점
3rd row씨유 정읍법원점
4th rowGS25 정읍법원점
5th row태림산업
ValueCountFrequency (%)
gs25 14
 
6.2%
정읍점 8
 
3.6%
cu 7
 
3.1%
세븐일레븐 6
 
2.7%
씨유 5
 
2.2%
하나로마트 3
 
1.3%
정읍센터 3
 
1.3%
미니스톱 3
 
1.3%
정읍농협 3
 
1.3%
올리브영 2
 
0.9%
Other values (165) 170
75.9%
2023-12-16T15:37:44.485377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
74
 
6.0%
정 74
 
6.0%
읍 72
 
5.9%
점 72
 
5.9%
스 32
 
2.6%
기 29
 
2.4%
이 28
 
2.3%
유 20
 
1.6%
사 19
 
1.5%
씨 17
 
1.4%
Other values (235) 789
64.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1024
83.5%
Space Separator 74
 
6.0%
Uppercase Letter 59
 
4.8%
Decimal Number 31
 
2.5%
Lowercase Letter 12
 
1.0%
Close Punctuation 11
 
0.9%
Open Punctuation 11
 
0.9%
Other Punctuation 3
 
0.2%
Other Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
정 74
 
7.2%
읍 72
 
7.0%
점 72
 
7.0%
스 32
 
3.1%
기 29
 
2.8%
이 28
 
2.7%
유 20
 
2.0%
사 19
 
1.9%
씨 17
 
1.7%
의 16
 
1.6%
Other values (210) 645
63.0%
Uppercase Letter
ValueCountFrequency (%)
S 15
25.4%
G 15
25.4%
C 13
22.0%
U 12
20.3%
I 1
 
1.7%
L 1
 
1.7%
K 1
 
1.7%
H 1
 
1.7%
Lowercase Letter
ValueCountFrequency (%)
n 2
16.7%
u 2
16.7%
i 2
16.7%
c 2
16.7%
s 1
8.3%
l 1
8.3%
m 1
8.3%
a 1
8.3%
Decimal Number
ValueCountFrequency (%)
2 16
51.6%
5 14
45.2%
4 1
 
3.2%
Other Punctuation
ValueCountFrequency (%)
& 2
66.7%
. 1
33.3%
Space Separator
ValueCountFrequency (%)
74
100.0%
Close Punctuation
ValueCountFrequency (%)
) 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1025
83.6%
Common 130
 
10.6%
Latin 71
 
5.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
정 74
 
7.2%
읍 72
 
7.0%
점 72
 
7.0%
스 32
 
3.1%
기 29
 
2.8%
이 28
 
2.7%
유 20
 
2.0%
사 19
 
1.9%
씨 17
 
1.7%
의 16
 
1.6%
Other values (211) 646
63.0%
Latin
ValueCountFrequency (%)
S 15
21.1%
G 15
21.1%
C 13
18.3%
U 12
16.9%
n 2
 
2.8%
u 2
 
2.8%
i 2
 
2.8%
c 2
 
2.8%
I 1
 
1.4%
L 1
 
1.4%
Other values (6) 6
 
8.5%
Common
ValueCountFrequency (%)
74
56.9%
2 16
 
12.3%
5 14
 
10.8%
) 11
 
8.5%
( 11
 
8.5%
& 2
 
1.5%
. 1
 
0.8%
4 1
 
0.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1024
83.5%
ASCII 201
 
16.4%
None 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
74
36.8%
2 16
 
8.0%
S 15
 
7.5%
G 15
 
7.5%
5 14
 
7.0%
C 13
 
6.5%
U 12
 
6.0%
) 11
 
5.5%
( 11
 
5.5%
n 2
 
1.0%
Other values (14) 18
 
9.0%
Hangul
ValueCountFrequency (%)
정 74
 
7.2%
읍 72
 
7.0%
점 72
 
7.0%
스 32
 
3.1%
기 29
 
2.8%
이 28
 
2.7%
유 20
 
2.0%
사 19
 
1.9%
씨 17
 
1.7%
의 16
 
1.6%
Other values (210) 645
63.0%
None
ValueCountFrequency (%)
㈜ 1
100.0%

소재지도로명주소
Text

Distinct148
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-16T15:37:45.884847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length37
Mean length24.766667
Min length15

Characters and Unicode

Total characters3715
Distinct characters152
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

Unique146 ?
Unique (%)97.3%

Sample

1st row전라북도 정읍시 샘골로 82-1, 2층 201호 (수성동)
2nd row전라북도 정읍시 수성택지7길 30, 1층 (수성동)
3rd row전라북도 정읍시 수성로 107, 1층 (수성동)
4th row전라북도 정읍시 수성5로 23, 1층 (수성동)
5th row전라북도 정읍시 연지시장3길 13(연지동)
ValueCountFrequency (%)
전라북도 150
19.0%
정읍시 150
19.0%
수성동 27
 
3.4%
1층 27
 
3.4%
연지동 25
 
3.2%
중앙로 23
 
2.9%
충정로 18
 
2.3%
시기동 17
 
2.1%
상동 14
 
1.8%
서부산업도로 12
 
1.5%
Other values (241) 328
41.5%
2023-12-16T15:37:47.936653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
642
 
17.3%
정 183
 
4.9%
시 177
 
4.8%
읍 167
 
4.5%
도 162
 
4.4%
북 158
 
4.3%
라 151
 
4.1%
전 150
 
4.0%
1 146
 
3.9%
동 136
 
3.7%
Other values (142) 1643
44.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2190
59.0%
Space Separator 642
 
17.3%
Decimal Number 523
 
14.1%
Open Punctuation 125
 
3.4%
Close Punctuation 125
 
3.4%
Other Punctuation 69
 
1.9%
Dash Punctuation 39
 
1.0%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
정 183
 
8.4%
시 177
 
8.1%
읍 167
 
7.6%
도 162
 
7.4%
북 158
 
7.2%
라 151
 
6.9%
전 150
 
6.8%
동 136
 
6.2%
로 120
 
5.5%
성 54
 
2.5%
Other values (125) 732
33.4%
Decimal Number
ValueCountFrequency (%)
1 146
27.9%
3 67
12.8%
2 67
12.8%
6 43
 
8.2%
4 40
 
7.6%
0 38
 
7.3%
5 36
 
6.9%
8 34
 
6.5%
9 28
 
5.4%
7 24
 
4.6%
Uppercase Letter
ValueCountFrequency (%)
A 1
50.0%
S 1
50.0%
Space Separator
ValueCountFrequency (%)
642
100.0%
Open Punctuation
ValueCountFrequency (%)
( 125
100.0%
Close Punctuation
ValueCountFrequency (%)
) 125
100.0%
Other Punctuation
ValueCountFrequency (%)
, 69
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 39
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2190
59.0%
Common 1523
41.0%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
정 183
 
8.4%
시 177
 
8.1%
읍 167
 
7.6%
도 162
 
7.4%
북 158
 
7.2%
라 151
 
6.9%
전 150
 
6.8%
동 136
 
6.2%
로 120
 
5.5%
성 54
 
2.5%
Other values (125) 732
33.4%
Common
ValueCountFrequency (%)
642
42.2%
1 146
 
9.6%
( 125
 
8.2%
) 125
 
8.2%
, 69
 
4.5%
3 67
 
4.4%
2 67
 
4.4%
6 43
 
2.8%
4 40
 
2.6%
- 39
 
2.6%
Other values (5) 160
 
10.5%
Latin
ValueCountFrequency (%)
A 1
50.0%
S 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2190
59.0%
ASCII 1525
41.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
642
42.1%
1 146
 
9.6%
( 125
 
8.2%
) 125
 
8.2%
, 69
 
4.5%
3 67
 
4.4%
2 67
 
4.4%
6 43
 
2.8%
4 40
 
2.6%
- 39
 
2.6%
Other values (7) 162
 
10.6%
Hangul
ValueCountFrequency (%)
정 183
 
8.4%
시 177
 
8.1%
읍 167
 
7.6%
도 162
 
7.4%
북 158
 
7.2%
라 151
 
6.9%
전 150
 
6.8%
동 136
 
6.2%
로 120
 
5.5%
성 54
 
2.5%
Other values (125) 732
33.4%

전화번호
Text

MISSING 

Distinct41
Distinct (%)100.0%
Missing109
Missing (%)72.7%
Memory size1.3 KiB
2023-12-16T15:37:49.151786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique41 ?
Unique (%)100.0%

Sample

1st row063-533-4663
2nd row063-533-5113
3rd row063-533-9111
4th row063-533-9266
5th row063-537-1151
ValueCountFrequency (%)
063-535-0074 1
 
2.4%
063-571-2100 1
 
2.4%
063-538-8611 1
 
2.4%
063-533-5958 1
 
2.4%
063-537-4516 1
 
2.4%
063-532-5500 1
 
2.4%
063-571-1326 1
 
2.4%
063-537-3641 1
 
2.4%
063-538-2555 1
 
2.4%
063-537-9700 1
 
2.4%
Other values (31) 31
75.6%
2023-12-16T15:37:50.743152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 102
20.7%
- 82
16.7%
0 65
13.2%
6 65
13.2%
5 65
13.2%
1 29
 
5.9%
8 20
 
4.1%
9 18
 
3.7%
7 17
 
3.5%
2 17
 
3.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 410
83.3%
Dash Punctuation 82
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 102
24.9%
0 65
15.9%
6 65
15.9%
5 65
15.9%
1 29
 
7.1%
8 20
 
4.9%
9 18
 
4.4%
7 17
 
4.1%
2 17
 
4.1%
4 12
 
2.9%
Dash Punctuation
ValueCountFrequency (%)
- 82
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 492
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 102
20.7%
- 82
16.7%
0 65
13.2%
6 65
13.2%
5 65
13.2%
1 29
 
5.9%
8 20
 
4.1%
9 18
 
3.7%
7 17
 
3.5%
2 17
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 492
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 102
20.7%
- 82
16.7%
0 65
13.2%
6 65
13.2%
5 65
13.2%
1 29
 
5.9%
8 20
 
4.1%
9 18
 
3.7%
7 17
 
3.5%
2 17
 
3.5%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-13
150 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-12-13
2nd row2023-12-13
3rd row2023-12-13
4th row2023-12-13
5th row2023-12-13

Common Values

ValueCountFrequency (%)
2023-12-13 150
100.0%

Length

2023-12-16T15:37:51.817643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:37:52.626356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12-13 150
100.0%

Missing values

2023-12-16T15:37:41.537606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-16T15:37:41.991874image/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송강교역전라북도 정읍시 샘골로 82-1, 2층 201호 (수성동)<NA>2023-12-13
1씨유정읍제일점전라북도 정읍시 수성택지7길 30, 1층 (수성동)<NA>2023-12-13
2씨유 정읍법원점전라북도 정읍시 수성로 107, 1층 (수성동)<NA>2023-12-13
3GS25 정읍법원점전라북도 정읍시 수성5로 23, 1층 (수성동)<NA>2023-12-13
4태림산업전라북도 정읍시 연지시장3길 13(연지동)<NA>2023-12-13
5정읍의료기전라북도 정읍시 남산5길 11(시기동)<NA>2023-12-13
6섬기는 요양센터전라북도 정읍시 남산5길 19-9, 201호 (시기동, 유창파크맨션1차)<NA>2023-12-13
7씨유 신태인중앙점전라북도 정읍시 신태인읍 정신로 1160, 씨유 신태인중앙점<NA>2023-12-13
8CU 정읍2산단점전라북도 정읍시 서부산업도로 607(하북동)<NA>2023-12-13
9세븐일레븐 정읍태인점전라북도 정읍시 태인면 태용신길 3<NA>2023-12-13
업소명소재지도로명주소전화번호데이터기준일자
140바디닥터 정읍대리점전라북도 정읍시 초산로 83063-533-97622023-12-13
141세븐일레븐 정읍미소중앙점전라북도 정읍시 중앙로 286<NA>2023-12-13
142GS25 정읍문화원점전라북도 정읍시 벚꽃로 131<NA>2023-12-13
143GS25 정읍상동점전라북도 정읍시 충정로 59<NA>2023-12-13
144정읍역 스토리웨이편의점전라북도 정읍시 서부산업도로 305063-839-83062023-12-13
145GS25 정읍남로점전라북도 정읍시 정읍남로 1327080-999-54252023-12-13
146CU 정읍성암점전라북도 정읍시 연지동 46-12<NA>2023-12-13
147CU 정읍상동영무점전라북도 정읍시 학산로 89-96<NA>2023-12-13
148세븐일레븐 정읍사랑점전라북도 정읍시 남북로 34(수성동)<NA>2023-12-13
149메가유통전라북도 정읍시 벚꽃로 478063-538-15532023-12-13