Overview

Dataset statistics

Number of variables4
Number of observations231
Missing cells21
Missing cells (%)2.3%
Duplicate rows1
Duplicate rows (%)0.4%
Total size in memory7.3 KiB
Average record size in memory32.6 B

Variable types

Text3
DateTime1

Dataset

Description제주특별자치도 제주시 관내에 소재하고 있는 약국과 관련한 현황 데이터를 제공합니다.
Author제주특별자치도 제주시
URLhttps://www.data.go.kr/data/15056069/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 1 (0.4%) duplicate rowsDuplicates
전화번호 has 21 (9.1%) missing valuesMissing

Reproduction

Analysis started2023-12-12 00:26:35.791171
Analysis finished2023-12-12 00:26:36.232993
Duration0.44 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

명칭
Text

Distinct230
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2023-12-12T09:26:36.551047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length4
Mean length4.8354978
Min length3

Characters and Unicode

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

Unique

Unique229 ?
Unique (%)99.1%

Sample

1st row참사랑약국
2nd row더나은약국
3rd row초록약국
4th row동백약국
5th row가까운약국
ValueCountFrequency (%)
대동약국 2
 
0.9%
굿모닝약국 1
 
0.4%
하귀약국 1
 
0.4%
한결약국 1
 
0.4%
정약국 1
 
0.4%
조일약국 1
 
0.4%
정다운약국 1
 
0.4%
세브란스약국 1
 
0.4%
신제주대웅약국 1
 
0.4%
장수약국 1
 
0.4%
Other values (222) 222
95.3%
2023-12-12T09:26:37.055791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 231
20.7%
국 231
20.7%
리 30
 
2.7%
누 23
 
2.1%
한 23
 
2.1%
온 23
 
2.1%
동 14
 
1.3%
우 12
 
1.1%
주 12
 
1.1%
제 12
 
1.1%
Other values (206) 506
45.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1103
98.7%
Decimal Number 9
 
0.8%
Space Separator 2
 
0.2%
Lowercase Letter 2
 
0.2%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 231
20.9%
국 231
20.9%
리 30
 
2.7%
누 23
 
2.1%
한 23
 
2.1%
온 23
 
2.1%
동 14
 
1.3%
우 12
 
1.1%
주 12
 
1.1%
제 12
 
1.1%
Other values (199) 492
44.6%
Decimal Number
ValueCountFrequency (%)
6 3
33.3%
5 3
33.3%
3 3
33.3%
Lowercase Letter
ValueCountFrequency (%)
w 1
50.0%
e 1
50.0%
Space Separator
ValueCountFrequency (%)
2
100.0%
Uppercase Letter
ValueCountFrequency (%)
N 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1103
98.7%
Common 11
 
1.0%
Latin 3
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 231
20.9%
국 231
20.9%
리 30
 
2.7%
누 23
 
2.1%
한 23
 
2.1%
온 23
 
2.1%
동 14
 
1.3%
우 12
 
1.1%
주 12
 
1.1%
제 12
 
1.1%
Other values (199) 492
44.6%
Common
ValueCountFrequency (%)
6 3
27.3%
5 3
27.3%
3 3
27.3%
2
18.2%
Latin
ValueCountFrequency (%)
w 1
33.3%
e 1
33.3%
N 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1103
98.7%
ASCII 14
 
1.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 231
20.9%
국 231
20.9%
리 30
 
2.7%
누 23
 
2.1%
한 23
 
2.1%
온 23
 
2.1%
동 14
 
1.3%
우 12
 
1.1%
주 12
 
1.1%
제 12
 
1.1%
Other values (199) 492
44.6%
ASCII
ValueCountFrequency (%)
6 3
21.4%
5 3
21.4%
3 3
21.4%
2
14.3%
w 1
 
7.1%
e 1
 
7.1%
N 1
 
7.1%

소재지
Text

Distinct227
Distinct (%)98.3%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2023-12-12T09:26:37.518985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length25
Mean length20.025974
Min length17

Characters and Unicode

Total characters4626
Distinct characters108
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

Unique223 ?
Unique (%)96.5%

Sample

1st row제주특별자치도 제주시 동문로 70
2nd row제주특별자치도 제주시 승천로 75
3rd row제주특별자치도 제주시 수덕로 6
4th row제주특별자치도 제주시 애월읍 하귀9길 1
5th row제주특별자치도 제주시 원노형남1길 11
ValueCountFrequency (%)
제주특별자치도 231
24.0%
제주시 231
24.0%
중앙로 25
 
2.6%
서광로 19
 
2.0%
1 13
 
1.4%
일주동로 11
 
1.1%
한림읍 9
 
0.9%
동광로 9
 
0.9%
애월읍 8
 
0.8%
조천읍 8
 
0.8%
Other values (245) 397
41.3%
2023-12-12T09:26:38.078146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
841
18.2%
주 479
 
10.4%
제 462
 
10.0%
도 238
 
5.1%
자 233
 
5.0%
특 231
 
5.0%
별 231
 
5.0%
치 231
 
5.0%
시 231
 
5.0%
로 201
 
4.3%
Other values (98) 1248
27.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3157
68.2%
Space Separator 841
 
18.2%
Decimal Number 613
 
13.3%
Dash Punctuation 15
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 479
15.2%
제 462
14.6%
도 238
7.5%
자 233
7.4%
특 231
7.3%
별 231
7.3%
치 231
7.3%
시 231
7.3%
로 201
 
6.4%
길 43
 
1.4%
Other values (86) 577
18.3%
Decimal Number
ValueCountFrequency (%)
1 123
20.1%
3 86
14.0%
2 63
10.3%
7 60
9.8%
6 57
9.3%
5 53
8.6%
0 48
 
7.8%
8 45
 
7.3%
4 44
 
7.2%
9 34
 
5.5%
Space Separator
ValueCountFrequency (%)
841
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 15
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3157
68.2%
Common 1469
31.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 479
15.2%
제 462
14.6%
도 238
7.5%
자 233
7.4%
특 231
7.3%
별 231
7.3%
치 231
7.3%
시 231
7.3%
로 201
 
6.4%
길 43
 
1.4%
Other values (86) 577
18.3%
Common
ValueCountFrequency (%)
841
57.2%
1 123
 
8.4%
3 86
 
5.9%
2 63
 
4.3%
7 60
 
4.1%
6 57
 
3.9%
5 53
 
3.6%
0 48
 
3.3%
8 45
 
3.1%
4 44
 
3.0%
Other values (2) 49
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3157
68.2%
ASCII 1469
31.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
841
57.2%
1 123
 
8.4%
3 86
 
5.9%
2 63
 
4.3%
7 60
 
4.1%
6 57
 
3.9%
5 53
 
3.6%
0 48
 
3.3%
8 45
 
3.1%
4 44
 
3.0%
Other values (2) 49
 
3.3%
Hangul
ValueCountFrequency (%)
주 479
15.2%
제 462
14.6%
도 238
7.5%
자 233
7.4%
특 231
7.3%
별 231
7.3%
치 231
7.3%
시 231
7.3%
로 201
 
6.4%
길 43
 
1.4%
Other values (86) 577
18.3%

전화번호
Text

MISSING 

Distinct209
Distinct (%)99.5%
Missing21
Missing (%)9.1%
Memory size1.9 KiB
2023-12-12T09:26:38.318527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique208 ?
Unique (%)99.0%

Sample

1st row064-752-8875
2nd row064-756-1231
3rd row064-713-7337
4th row064-904-1102
5th row064-745-6188
ValueCountFrequency (%)
064-799-8808 2
 
1.0%
064-783-2360 1
 
0.5%
064-783-1959 1
 
0.5%
064-752-8875 1
 
0.5%
064-744-3236 1
 
0.5%
064-747-0828 1
 
0.5%
064-796-2051 1
 
0.5%
064-711-8995 1
 
0.5%
064-784-8434 1
 
0.5%
064-713-0033 1
 
0.5%
Other values (199) 199
94.8%
2023-12-12T09:26:38.688255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 420
16.7%
0 327
13.0%
4 326
12.9%
7 315
12.5%
6 302
12.0%
2 217
8.6%
5 145
 
5.8%
3 145
 
5.8%
8 120
 
4.8%
1 118
 
4.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2100
83.3%
Dash Punctuation 420
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 327
15.6%
4 326
15.5%
7 315
15.0%
6 302
14.4%
2 217
10.3%
5 145
6.9%
3 145
6.9%
8 120
 
5.7%
1 118
 
5.6%
9 85
 
4.0%
Dash Punctuation
ValueCountFrequency (%)
- 420
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2520
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 420
16.7%
0 327
13.0%
4 326
12.9%
7 315
12.5%
6 302
12.0%
2 217
8.6%
5 145
 
5.8%
3 145
 
5.8%
8 120
 
4.8%
1 118
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2520
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 420
16.7%
0 327
13.0%
4 326
12.9%
7 315
12.5%
6 302
12.0%
2 217
8.6%
5 145
 
5.8%
3 145
 
5.8%
8 120
 
4.8%
1 118
 
4.7%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
Minimum2021-08-30 00:00:00
Maximum2021-08-30 00:00:00
2023-12-12T09:26:38.824510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:26:38.932284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2023-12-12T09:26:36.058231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:26:36.181066image/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참사랑약국제주특별자치도 제주시 동문로 70064-752-88752021-08-30
1더나은약국제주특별자치도 제주시 승천로 75064-756-12312021-08-30
2초록약국제주특별자치도 제주시 수덕로 6064-713-73372021-08-30
3동백약국제주특별자치도 제주시 애월읍 하귀9길 1064-904-11022021-08-30
4가까운약국제주특별자치도 제주시 원노형남1길 11064-745-61882021-08-30
5참약국제주특별자치도 제주시 서광로 294064-753-65412021-08-30
6삼양온누리약국제주특별자치도 제주시 일주동로 393<NA>2021-08-30
7새중앙약국제주특별자치도 제주시 중앙로 61064-725-06552021-08-30
8희망약국제주특별자치도 제주시 연북로 76064-744-06552021-08-30
9마음약국제주특별자치도 제주시 도령로 73064-900-40572021-08-30
명칭소재지전화번호데이터기준일자
221새우리약국제주특별자치도 제주시 서사로 36064-757-51492021-08-30
222동보약국제주특별자치도 제주시 오현길 78064-757-58332021-08-30
223제일약국제주특별자치도 제주시 구좌읍 구좌로 47064-783-20102021-08-30
224새한온누리약국제주특별자치도 제주시 신대로 128064-742-13482021-08-30
225보림약국제주특별자치도 제주시 동문로 35064-722-37882021-08-30
226신한당약국제주특별자치도 제주시 조천읍 신북로 530064-783-80872021-08-30
227인수당건재약국제주특별자치도 제주시 관덕로 54-2064-722-30302021-08-30
228정민당약국제주특별자치도 제주시 중앙로 127064-722-33372021-08-30
229광제약국제주특별자치도 제주시 중앙로 61064-722-66342021-08-30
230위생약국제주특별자치도 제주시 동문로 40064-753-26302021-08-30

Duplicate rows

Most frequently occurring

명칭소재지전화번호데이터기준일자# duplicates
0대동약국제주특별자치도 제주시 애월읍 곽지7길 1064-799-88082021-08-302