Overview

Dataset statistics

Number of variables4
Number of observations65
Missing cells47
Missing cells (%)18.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.2 KiB
Average record size in memory34.0 B

Variable types

Text3
DateTime1

Dataset

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

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 47 (72.3%) missing valuesMissing
업소명 has unique valuesUnique
소재지도로명주소 has unique valuesUnique

Reproduction

Analysis started2023-12-16 15:33:08.655492
Analysis finished2023-12-16 15:33:10.000224
Duration1.34 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업소명
Text

UNIQUE 

Distinct65
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size652.0 B
2023-12-16T15:33:10.461667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length9.5846154
Min length6

Characters and Unicode

Total characters623
Distinct characters111
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

Unique65 ?
Unique (%)100.0%

Sample

1st rowGS25 정읍법원점
2nd row씨유 정읍법원점
3rd row씨유 정읍연지사거리점
4th row씨유 정읍수성자매점
5th row씨유 정읍또와점
ValueCountFrequency (%)
씨유 20
 
17.2%
미니스톱 8
 
6.9%
gs25 7
 
6.0%
세븐일레븐 7
 
6.0%
cu 4
 
3.4%
정읍수성점 2
 
1.7%
정읍부영점 2
 
1.7%
정읍북면점 2
 
1.7%
정읍시기점 2
 
1.7%
정읍법원점 2
 
1.7%
Other values (60) 60
51.7%
2023-12-16T15:33:13.006189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 64
 
10.3%
정 55
 
8.8%
읍 55
 
8.8%
52
 
8.3%
유 24
 
3.9%
씨 24
 
3.9%
2 18
 
2.9%
5 16
 
2.6%
스 15
 
2.4%
븐 14
 
2.2%
Other values (101) 286
45.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 491
78.8%
Space Separator 52
 
8.3%
Uppercase Letter 39
 
6.3%
Decimal Number 34
 
5.5%
Close Punctuation 2
 
0.3%
Open Punctuation 2
 
0.3%
Lowercase Letter 2
 
0.3%
Modifier Symbol 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 64
 
13.0%
정 55
 
11.2%
읍 55
 
11.2%
유 24
 
4.9%
씨 24
 
4.9%
스 15
 
3.1%
븐 14
 
2.9%
미 12
 
2.4%
일 9
 
1.8%
니 8
 
1.6%
Other values (88) 211
43.0%
Uppercase Letter
ValueCountFrequency (%)
S 11
28.2%
G 11
28.2%
C 8
20.5%
U 7
17.9%
I 2
 
5.1%
Decimal Number
ValueCountFrequency (%)
2 18
52.9%
5 16
47.1%
Lowercase Letter
ValueCountFrequency (%)
s 1
50.0%
t 1
50.0%
Space Separator
ValueCountFrequency (%)
52
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 491
78.8%
Common 91
 
14.6%
Latin 41
 
6.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 64
 
13.0%
정 55
 
11.2%
읍 55
 
11.2%
유 24
 
4.9%
씨 24
 
4.9%
스 15
 
3.1%
븐 14
 
2.9%
미 12
 
2.4%
일 9
 
1.8%
니 8
 
1.6%
Other values (88) 211
43.0%
Latin
ValueCountFrequency (%)
S 11
26.8%
G 11
26.8%
C 8
19.5%
U 7
17.1%
I 2
 
4.9%
s 1
 
2.4%
t 1
 
2.4%
Common
ValueCountFrequency (%)
52
57.1%
2 18
 
19.8%
5 16
 
17.6%
) 2
 
2.2%
( 2
 
2.2%
` 1
 
1.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 491
78.8%
ASCII 132
 
21.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 64
 
13.0%
정 55
 
11.2%
읍 55
 
11.2%
유 24
 
4.9%
씨 24
 
4.9%
스 15
 
3.1%
븐 14
 
2.9%
미 12
 
2.4%
일 9
 
1.8%
니 8
 
1.6%
Other values (88) 211
43.0%
ASCII
ValueCountFrequency (%)
52
39.4%
2 18
 
13.6%
5 16
 
12.1%
S 11
 
8.3%
G 11
 
8.3%
C 8
 
6.1%
U 7
 
5.3%
) 2
 
1.5%
( 2
 
1.5%
I 2
 
1.5%
Other values (3) 3
 
2.3%

소재지도로명주소
Text

UNIQUE 

Distinct65
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size652.0 B
2023-12-16T15:33:14.326042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length34
Mean length25.292308
Min length20

Characters and Unicode

Total characters1644
Distinct characters135
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

Unique65 ?
Unique (%)100.0%

Sample

1st row전라북도 정읍시 수성5로 23, 1층 (수성동)
2nd row전라북도 정읍시 수성로 107, 1층 (수성동)
3rd row전라북도 정읍시 충정로 372(연지동)
4th row전라북도 정읍시 수성5로 61-2, 중앙마트 (수성동)
5th row전라북도 정읍시 하신경9길 14-18(상동)
ValueCountFrequency (%)
전라북도 65
18.5%
정읍시 65
18.5%
수성동 15
 
4.3%
상동 13
 
3.7%
시기동 8
 
2.3%
중앙로 7
 
2.0%
북면 6
 
1.7%
연지동 5
 
1.4%
학산로 5
 
1.4%
충정로 5
 
1.4%
Other values (123) 157
44.7%
2023-12-16T15:33:17.365247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
286
 
17.4%
북 78
 
4.7%
시 78
 
4.7%
정 76
 
4.6%
읍 70
 
4.3%
도 68
 
4.1%
전 66
 
4.0%
라 66
 
4.0%
동 60
 
3.6%
) 57
 
3.5%
Other values (125) 739
45.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 953
58.0%
Space Separator 286
 
17.4%
Decimal Number 216
 
13.1%
Close Punctuation 57
 
3.5%
Open Punctuation 57
 
3.5%
Lowercase Letter 26
 
1.6%
Other Punctuation 24
 
1.5%
Dash Punctuation 16
 
1.0%
Uppercase Letter 9
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
북 78
 
8.2%
시 78
 
8.2%
정 76
 
8.0%
읍 70
 
7.3%
도 68
 
7.1%
전 66
 
6.9%
라 66
 
6.9%
동 60
 
6.3%
로 53
 
5.6%
수 32
 
3.4%
Other values (96) 306
32.1%
Decimal Number
ValueCountFrequency (%)
1 56
25.9%
2 31
14.4%
3 28
13.0%
4 20
 
9.3%
0 19
 
8.8%
5 17
 
7.9%
6 16
 
7.4%
7 11
 
5.1%
9 11
 
5.1%
8 7
 
3.2%
Lowercase Letter
ValueCountFrequency (%)
a 6
23.1%
m 4
15.4%
t 3
11.5%
r 3
11.5%
y 3
11.5%
l 3
11.5%
i 3
11.5%
f 1
 
3.8%
Uppercase Letter
ValueCountFrequency (%)
F 2
22.2%
M 2
22.2%
B 2
22.2%
K 1
11.1%
C 1
11.1%
P 1
11.1%
Space Separator
ValueCountFrequency (%)
286
100.0%
Close Punctuation
ValueCountFrequency (%)
) 57
100.0%
Open Punctuation
ValueCountFrequency (%)
( 57
100.0%
Other Punctuation
ValueCountFrequency (%)
, 24
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 16
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 953
58.0%
Common 656
39.9%
Latin 35
 
2.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
북 78
 
8.2%
시 78
 
8.2%
정 76
 
8.0%
읍 70
 
7.3%
도 68
 
7.1%
전 66
 
6.9%
라 66
 
6.9%
동 60
 
6.3%
로 53
 
5.6%
수 32
 
3.4%
Other values (96) 306
32.1%
Common
ValueCountFrequency (%)
286
43.6%
) 57
 
8.7%
( 57
 
8.7%
1 56
 
8.5%
2 31
 
4.7%
3 28
 
4.3%
, 24
 
3.7%
4 20
 
3.0%
0 19
 
2.9%
5 17
 
2.6%
Other values (5) 61
 
9.3%
Latin
ValueCountFrequency (%)
a 6
17.1%
m 4
11.4%
t 3
8.6%
r 3
8.6%
y 3
8.6%
l 3
8.6%
i 3
8.6%
F 2
 
5.7%
M 2
 
5.7%
B 2
 
5.7%
Other values (4) 4
11.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 953
58.0%
ASCII 691
42.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
286
41.4%
) 57
 
8.2%
( 57
 
8.2%
1 56
 
8.1%
2 31
 
4.5%
3 28
 
4.1%
, 24
 
3.5%
4 20
 
2.9%
0 19
 
2.7%
5 17
 
2.5%
Other values (19) 96
 
13.9%
Hangul
ValueCountFrequency (%)
북 78
 
8.2%
시 78
 
8.2%
정 76
 
8.0%
읍 70
 
7.3%
도 68
 
7.1%
전 66
 
6.9%
라 66
 
6.9%
동 60
 
6.3%
로 53
 
5.6%
수 32
 
3.4%
Other values (96) 306
32.1%

전화번호
Text

MISSING 

Distinct18
Distinct (%)100.0%
Missing47
Missing (%)72.3%
Memory size652.0 B
2023-12-16T15:33:18.436654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique18 ?
Unique (%)100.0%

Sample

1st row063-533-5270
2nd row063-532-4668
3rd row063-536-8872
4th row063-533-5871
5th row063-537-5323
ValueCountFrequency (%)
063-533-5270 1
 
5.6%
063-532-4668 1
 
5.6%
063-535-4047 1
 
5.6%
063-536-7638 1
 
5.6%
063-927-7638 1
 
5.6%
063-535-3346 1
 
5.6%
063-535-3393 1
 
5.6%
063-532-6065 1
 
5.6%
063-532-1198 1
 
5.6%
063-538-8516 1
 
5.6%
Other values (8) 8
44.4%
2023-12-16T15:33:20.188509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 50
23.1%
- 36
16.7%
6 30
13.9%
5 29
13.4%
0 24
11.1%
2 11
 
5.1%
7 10
 
4.6%
8 9
 
4.2%
1 7
 
3.2%
4 6
 
2.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 180
83.3%
Dash Punctuation 36
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 50
27.8%
6 30
16.7%
5 29
16.1%
0 24
13.3%
2 11
 
6.1%
7 10
 
5.6%
8 9
 
5.0%
1 7
 
3.9%
4 6
 
3.3%
9 4
 
2.2%
Dash Punctuation
ValueCountFrequency (%)
- 36
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 216
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 50
23.1%
- 36
16.7%
6 30
13.9%
5 29
13.4%
0 24
11.1%
2 11
 
5.1%
7 10
 
4.6%
8 9
 
4.2%
1 7
 
3.2%
4 6
 
2.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 216
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 50
23.1%
- 36
16.7%
6 30
13.9%
5 29
13.4%
0 24
11.1%
2 11
 
5.1%
7 10
 
4.6%
8 9
 
4.2%
1 7
 
3.2%
4 6
 
2.8%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size652.0 B
Minimum2022-12-13 00:00:00
Maximum2022-12-13 00:00:00
2023-12-16T15:33:20.755683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:33:21.189083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-16T15:33:21.587732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명소재지도로명주소전화번호
업소명1.0001.0001.000
소재지도로명주소1.0001.0001.000
전화번호1.0001.0001.000

Missing values

2023-12-16T15:33:09.541541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-16T15:33:09.848720image/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

업소명소재지도로명주소전화번호데이터기준일자
0GS25 정읍법원점전라북도 정읍시 수성5로 23, 1층 (수성동)<NA>2022-12-13
1씨유 정읍법원점전라북도 정읍시 수성로 107, 1층 (수성동)<NA>2022-12-13
2씨유 정읍연지사거리점전라북도 정읍시 충정로 372(연지동)<NA>2022-12-13
3씨유 정읍수성자매점전라북도 정읍시 수성5로 61-2, 중앙마트 (수성동)<NA>2022-12-13
4씨유 정읍또와점전라북도 정읍시 하신경9길 14-18(상동)<NA>2022-12-13
5세븐일레븐 정읍그린점전라북도 정읍시 대흥3길 21-16(시기동)<NA>2022-12-13
6씨유 정읍수성점전라북도 정읍시 수성로 40, Family Mart (수성동)<NA>2022-12-13
7지에스25 수성마을점전라북도 정읍시 수성택지4길 6-1(수성동)<NA>2022-12-13
8씨유 정읍내장하늘점전라북도 정읍시 내장산로 334(부전동)<NA>2022-12-13
9지에스25정읍수성로점전라북도 정읍시 수성4로 37-12(수성동)<NA>2022-12-13
업소명소재지도로명주소전화번호데이터기준일자
55GS25 상동대로점전라북도 정읍시 상신경1길 1 (상동)063-538-85162022-12-13
56씨유 호남점전라북도 정읍시 초산로 21 (시기동)<NA>2022-12-13
57씨유 정읍상동2호점전라북도 정읍시 상신경2길 1 (상동)063-532-11982022-12-13
58씨유 정읍인네점전라북도 정읍시 조곡천1길 60 (시기동)063-532-60652022-12-13
59씨유 정읍제일점전라북도 정읍시 수성택지7길 30 (수성동, Family Mart)063-535-33932022-12-13
60씨유 정읍2산단점전라북도 정읍시 서부산업도로 603 (하북동)063-535-33462022-12-13
61씨유 정읍역점전라북도 정읍시 서부산업도로 302 (연지동)063-927-76382022-12-13
62씨유 정읍북면점전라북도 정읍시 북면 정읍북로 631063-536-76382022-12-13
63미니스톱 정읍부영점전라북도 정읍시 수성5로 50 (수성동)063-535-40472022-12-13
64씨유 신태인중앙점전라북도 정읍시 신태인읍 정신로 1160063-571-56512022-12-13