Overview

Dataset statistics

Number of variables5
Number of observations61
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.5 KiB
Average record size in memory42.2 B

Variable types

Text3
DateTime1
Categorical1

Dataset

Description전라북도 정읍시 에서 제공하는 약국 현황중(약국명칭, 소재지도로명주소, 전화번호, 등록일자)등의 정보를 제공합니다.
Author전라북도 정읍시
URLhttps://www.data.go.kr/data/15054353/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
약국명칭 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-16 15:09:11.033272
Analysis finished2023-12-16 15:09:13.893323
Duration2.86 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약국명칭
Text

UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-16T15:09:14.625952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length4
Mean length4.6721311
Min length3

Characters and Unicode

Total characters285
Distinct characters96
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique61 ?
Unique (%)100.0%

Sample

1st row서울약국
2nd row대한약국
3rd row정읍보은약국
4th row건강온누리약국
5th row미소약국
ValueCountFrequency (%)
서울약국 1
 
1.6%
신태인약국 1
 
1.6%
태인약국 1
 
1.6%
아산약국 1
 
1.6%
동천약국 1
 
1.6%
정읍백제약국 1
 
1.6%
명동약국 1
 
1.6%
강약국 1
 
1.6%
내장산약국 1
 
1.6%
농민약국 1
 
1.6%
Other values (52) 52
83.9%
2023-12-16T15:09:16.376215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
국 62
21.8%
약 61
21.4%
종 5
 
1.8%
강 5
 
1.8%
서 4
 
1.4%
건 4
 
1.4%
합 4
 
1.4%
로 4
 
1.4%
동 4
 
1.4%
리 4
 
1.4%
Other values (86) 128
44.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 284
99.6%
Space Separator 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
국 62
21.8%
약 61
21.5%
종 5
 
1.8%
강 5
 
1.8%
서 4
 
1.4%
건 4
 
1.4%
합 4
 
1.4%
로 4
 
1.4%
동 4
 
1.4%
리 4
 
1.4%
Other values (85) 127
44.7%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 284
99.6%
Common 1
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
국 62
21.8%
약 61
21.5%
종 5
 
1.8%
강 5
 
1.8%
서 4
 
1.4%
건 4
 
1.4%
합 4
 
1.4%
로 4
 
1.4%
동 4
 
1.4%
리 4
 
1.4%
Other values (85) 127
44.7%
Common
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 284
99.6%
ASCII 1
 
0.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
국 62
21.8%
약 61
21.5%
종 5
 
1.8%
강 5
 
1.8%
서 4
 
1.4%
건 4
 
1.4%
합 4
 
1.4%
로 4
 
1.4%
동 4
 
1.4%
리 4
 
1.4%
Other values (85) 127
44.7%
ASCII
ValueCountFrequency (%)
1
100.0%

소재지도로명주소
Text

Distinct60
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-16T15:09:17.195834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length32
Mean length24.311475
Min length19

Characters and Unicode

Total characters1483
Distinct characters113
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

Unique59 ?
Unique (%)96.7%

Sample

1st row전라북도 정읍시 남북로 35, 서울약국 (수성동)
2nd row전라북도 정읍시 서부산업도로 425-16, 1층 (농소동)
3rd row전라북도 정읍시 서부로 53, 1층 (연지동)
4th row전라북도 정읍시 중앙3길 2, 대건 빌딩 1층 (수성동)
5th row전라북도 정읍시 수성로 43, 그린빌딩 (수성동)
ValueCountFrequency (%)
전라북도 61
18.5%
정읍시 61
18.5%
수성동 17
 
5.2%
시기동 15
 
4.6%
중앙로 10
 
3.0%
남북로 8
 
2.4%
연지동 8
 
2.4%
충정로 8
 
2.4%
우암로 7
 
2.1%
상동 6
 
1.8%
Other values (108) 128
38.9%
2023-12-16T15:09:18.752437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
268
18.1%
시 77
 
5.2%
정 75
 
5.1%
북 71
 
4.8%
읍 69
 
4.7%
도 62
 
4.2%
라 62
 
4.2%
전 61
 
4.1%
로 55
 
3.7%
동 53
 
3.6%
Other values (103) 630
42.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 898
60.6%
Space Separator 268
 
18.1%
Decimal Number 175
 
11.8%
Close Punctuation 50
 
3.4%
Open Punctuation 50
 
3.4%
Other Punctuation 20
 
1.3%
Dash Punctuation 17
 
1.1%
Lowercase Letter 4
 
0.3%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 77
 
8.6%
정 75
 
8.4%
북 71
 
7.9%
읍 69
 
7.7%
도 62
 
6.9%
라 62
 
6.9%
전 61
 
6.8%
로 55
 
6.1%
동 53
 
5.9%
수 21
 
2.3%
Other values (84) 292
32.5%
Decimal Number
ValueCountFrequency (%)
1 38
21.7%
2 22
12.6%
4 21
12.0%
3 21
12.0%
5 18
10.3%
0 16
9.1%
6 15
 
8.6%
8 12
 
6.9%
9 6
 
3.4%
7 6
 
3.4%
Lowercase Letter
ValueCountFrequency (%)
c 2
50.0%
i 1
25.0%
p 1
25.0%
Space Separator
ValueCountFrequency (%)
268
100.0%
Close Punctuation
ValueCountFrequency (%)
) 50
100.0%
Open Punctuation
ValueCountFrequency (%)
( 50
100.0%
Other Punctuation
ValueCountFrequency (%)
, 20
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%
Uppercase Letter
ValueCountFrequency (%)
N 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 898
60.6%
Common 580
39.1%
Latin 5
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 77
 
8.6%
정 75
 
8.4%
북 71
 
7.9%
읍 69
 
7.7%
도 62
 
6.9%
라 62
 
6.9%
전 61
 
6.8%
로 55
 
6.1%
동 53
 
5.9%
수 21
 
2.3%
Other values (84) 292
32.5%
Common
ValueCountFrequency (%)
268
46.2%
) 50
 
8.6%
( 50
 
8.6%
1 38
 
6.6%
2 22
 
3.8%
4 21
 
3.6%
3 21
 
3.6%
, 20
 
3.4%
5 18
 
3.1%
- 17
 
2.9%
Other values (5) 55
 
9.5%
Latin
ValueCountFrequency (%)
c 2
40.0%
N 1
20.0%
i 1
20.0%
p 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 898
60.6%
ASCII 585
39.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
268
45.8%
) 50
 
8.5%
( 50
 
8.5%
1 38
 
6.5%
2 22
 
3.8%
4 21
 
3.6%
3 21
 
3.6%
, 20
 
3.4%
5 18
 
3.1%
- 17
 
2.9%
Other values (9) 60
 
10.3%
Hangul
ValueCountFrequency (%)
시 77
 
8.6%
정 75
 
8.4%
북 71
 
7.9%
읍 69
 
7.7%
도 62
 
6.9%
라 62
 
6.9%
전 61
 
6.8%
로 55
 
6.1%
동 53
 
5.9%
수 21
 
2.3%
Other values (84) 292
32.5%

전화번호
Text

UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-16T15:09:19.943871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique61 ?
Unique (%)100.0%

Sample

1st row063-535-3058
2nd row063-531-7800
3rd row063-535-2842
4th row063-537-3931
5th row063-535-4271
ValueCountFrequency (%)
063-535-3058 1
 
1.6%
063-538-0222 1
 
1.6%
063-531-8575 1
 
1.6%
063-538-5300 1
 
1.6%
063-538-0700 1
 
1.6%
063-538-7755 1
 
1.6%
063-535-8133 1
 
1.6%
063-535-3831 1
 
1.6%
063-535-7582 1
 
1.6%
063-536-9500 1
 
1.6%
Other values (51) 51
83.6%
2023-12-16T15:09:21.597225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 164
22.4%
- 122
16.7%
5 113
15.4%
0 98
13.4%
6 81
11.1%
8 36
 
4.9%
7 34
 
4.6%
1 29
 
4.0%
2 29
 
4.0%
4 14
 
1.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 610
83.3%
Dash Punctuation 122
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 164
26.9%
5 113
18.5%
0 98
16.1%
6 81
13.3%
8 36
 
5.9%
7 34
 
5.6%
1 29
 
4.8%
2 29
 
4.8%
4 14
 
2.3%
9 12
 
2.0%
Dash Punctuation
ValueCountFrequency (%)
- 122
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 732
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 164
22.4%
- 122
16.7%
5 113
15.4%
0 98
13.4%
6 81
11.1%
8 36
 
4.9%
7 34
 
4.6%
1 29
 
4.0%
2 29
 
4.0%
4 14
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 732
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 164
22.4%
- 122
16.7%
5 113
15.4%
0 98
13.4%
6 81
11.1%
8 36
 
4.9%
7 34
 
4.6%
1 29
 
4.0%
2 29
 
4.0%
4 14
 
1.9%

등록일자
Date

Distinct60
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size620.0 B
Minimum1965-12-06 00:00:00
Maximum2022-11-28 00:00:00
2023-12-16T15:09:22.253523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:09:22.896406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-13
61 

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 61
100.0%

Length

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

Common Values (Plot)

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

Correlations

2023-12-16T15:09:24.356898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
약국명칭소재지도로명주소전화번호등록일자
약국명칭1.0001.0001.0001.000
소재지도로명주소1.0001.0001.0000.998
전화번호1.0001.0001.0001.000
등록일자1.0000.9981.0001.000

Missing values

2023-12-16T15:09:13.228529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-16T15:09:13.727981image/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서울약국전라북도 정읍시 남북로 35, 서울약국 (수성동)063-535-30582022-11-282023-12-13
1대한약국전라북도 정읍시 서부산업도로 425-16, 1층 (농소동)063-531-78002022-08-312023-12-13
2정읍보은약국전라북도 정읍시 서부로 53, 1층 (연지동)063-535-28422021-09-032023-12-13
3건강온누리약국전라북도 정읍시 중앙3길 2, 대건 빌딩 1층 (수성동)063-537-39312021-04-092023-12-13
4미소약국전라북도 정읍시 수성로 43, 그린빌딩 (수성동)063-535-42712020-11-112023-12-13
5상동약국전라북도 정읍시 충정로 99 (상동)063-536-04632020-09-182023-12-13
6열린약국전라북도 정읍시 중앙2길 13-6, 제일항장외과의원 (수성동)063-535-26332019-06-132023-12-13
7상록수온누리약국전라북도 정읍시 충정로 58, 정읍농협상동지점 (상동)063-533-01552019-05-172023-12-13
8큰사랑약국전라북도 정읍시 남북로 39, 큰사랑약국 (수성동)063-535-52682019-04-012023-12-13
9하나로약국전라북도 정읍시 중앙로 160, 정읍하나로약국 (시기동)063-536-85752019-03-062023-12-13
약국명칭소재지도로명주소전화번호등록일자데이터기준일자
51도운약국전라북도 정읍시 충정로 606-20 (용계동)063-531-72822001-06-302023-12-13
52우리약국전라북도 정읍시 조곡천2길 5 (수성동)063-533-77292001-04-302023-12-13
53새불란서약국전라북도 정읍시 덕천면 태고로 677063-534-56002000-07-032023-12-13
54동서약국전라북도 정읍시 중앙로 41 (연지동)063-531-56351998-04-022023-12-13
55채약국전라북도 정읍시 학산로 103-4 (상동)063-533-80301997-08-162023-12-13
56정화약국전라북도 정읍시 충정로 70 (상동)063-533-73881984-01-252023-12-13
57성모약국전라북도 정읍시 중앙로 10 (연지동)063-535-23841974-10-222023-12-13
58종로종합약국전라북도 정읍시 중앙로 24 (연지동, Nic pc방)063-533-04441972-10-072023-12-13
59향토약국전라북도 정읍시 중앙로 65 (연지동)063-535-38281972-05-162023-12-13
60신우약국전라북도 정읍시 태인면 태인로 27-3063-534-40531965-12-062023-12-13