Overview

Dataset statistics

Number of variables5
Number of observations83
Missing cells3
Missing cells (%)0.7%
Duplicate rows3
Duplicate rows (%)3.6%
Total size in memory3.4 KiB
Average record size in memory41.6 B

Variable types

Categorical1
Text3
DateTime1

Dataset

Description경상남도 거제시 내의 의약업소의 명칭, 전화번호, 소재지 등의 현황을 제공하여 관광객의 편의 도모 및 지역경제 활성화 목적
Author경상남도 거제시
URLhttps://www.data.go.kr/data/3079321/fileData.do

Alerts

구분 has constant value ""Constant
기준일자 has constant value ""Constant
Dataset has 3 (3.6%) duplicate rowsDuplicates
전화번호 has 3 (3.6%) missing valuesMissing

Reproduction

Analysis started2023-12-12 19:23:17.736210
Analysis finished2023-12-12 19:23:18.244933
Duration0.51 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size796.0 B
약국
83 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row약국
2nd row약국
3rd row약국
4th row약국
5th row약국

Common Values

ValueCountFrequency (%)
약국 83
100.0%

Length

2023-12-13T04:23:18.338149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:23:18.450095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 83
100.0%

명칭
Text

Distinct80
Distinct (%)96.4%
Missing0
Missing (%)0.0%
Memory size796.0 B
2023-12-13T04:23:18.753263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length7
Mean length4.939759
Min length3

Characters and Unicode

Total characters410
Distinct characters116
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

Unique77 ?
Unique (%)92.8%

Sample

1st row드림약국
2nd row르네상스약국
3rd row일등약국
4th row아주약국
5th row진약국
ValueCountFrequency (%)
고은약국 2
 
2.4%
신세계약국 2
 
2.4%
미래약국 2
 
2.4%
맑은샘병원 1
 
1.2%
친절약국 1
 
1.2%
새조은약국 1
 
1.2%
건강약국 1
 
1.2%
수월온누리약국 1
 
1.2%
정다운약국 1
 
1.2%
경희당한약국 1
 
1.2%
Other values (70) 70
84.3%
2023-12-13T04:23:19.296247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 82
20.0%
국 82
20.0%
리 11
 
2.7%
누 9
 
2.2%
온 9
 
2.2%
은 6
 
1.5%
세 6
 
1.5%
한 5
 
1.2%
사 5
 
1.2%
다 5
 
1.2%
Other values (106) 190
46.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 409
99.8%
Lowercase Letter 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 82
20.0%
국 82
20.0%
리 11
 
2.7%
누 9
 
2.2%
온 9
 
2.2%
은 6
 
1.5%
세 6
 
1.5%
한 5
 
1.2%
사 5
 
1.2%
다 5
 
1.2%
Other values (105) 189
46.2%
Lowercase Letter
ValueCountFrequency (%)
i 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 409
99.8%
Latin 1
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 82
20.0%
국 82
20.0%
리 11
 
2.7%
누 9
 
2.2%
온 9
 
2.2%
은 6
 
1.5%
세 6
 
1.5%
한 5
 
1.2%
사 5
 
1.2%
다 5
 
1.2%
Other values (105) 189
46.2%
Latin
ValueCountFrequency (%)
i 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 409
99.8%
ASCII 1
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 82
20.0%
국 82
20.0%
리 11
 
2.7%
누 9
 
2.2%
온 9
 
2.2%
은 6
 
1.5%
세 6
 
1.5%
한 5
 
1.2%
사 5
 
1.2%
다 5
 
1.2%
Other values (105) 189
46.2%
ASCII
ValueCountFrequency (%)
i 1
100.0%

전화번호
Text

MISSING 

Distinct77
Distinct (%)96.2%
Missing3
Missing (%)3.6%
Memory size796.0 B
2023-12-13T04:23:19.605837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.0375
Min length12

Characters and Unicode

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

Unique74 ?
Unique (%)92.5%

Sample

1st row055-633-8810
2nd row055-634-0111
3rd row055-637-9723
4th row055-635-9855
5th row055-688-3238
ValueCountFrequency (%)
055-633-3375 2
 
2.5%
055-636-6888 2
 
2.5%
055-682-0801 2
 
2.5%
055-681-3199 1
 
1.2%
055-731-1240 1
 
1.2%
055-637-3589 1
 
1.2%
055-636-6248 1
 
1.2%
055-632-7323 1
 
1.2%
055-632-7870 1
 
1.2%
055-637-2177 1
 
1.2%
Other values (67) 67
83.8%
2023-12-13T04:23:20.108821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 194
20.1%
- 160
16.6%
0 123
12.8%
6 110
11.4%
3 93
9.7%
8 88
9.1%
2 50
 
5.2%
7 49
 
5.1%
1 40
 
4.2%
4 29
 
3.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 803
83.4%
Dash Punctuation 160
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 194
24.2%
0 123
15.3%
6 110
13.7%
3 93
11.6%
8 88
11.0%
2 50
 
6.2%
7 49
 
6.1%
1 40
 
5.0%
4 29
 
3.6%
9 27
 
3.4%
Dash Punctuation
ValueCountFrequency (%)
- 160
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 963
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 194
20.1%
- 160
16.6%
0 123
12.8%
6 110
11.4%
3 93
9.7%
8 88
9.1%
2 50
 
5.2%
7 49
 
5.1%
1 40
 
4.2%
4 29
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 963
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 194
20.1%
- 160
16.6%
0 123
12.8%
6 110
11.4%
3 93
9.7%
8 88
9.1%
2 50
 
5.2%
7 49
 
5.1%
1 40
 
4.2%
4 29
 
3.0%

소재지(도로명)
Text

Distinct80
Distinct (%)96.4%
Missing0
Missing (%)0.0%
Memory size796.0 B
2023-12-13T04:23:20.492240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length58
Median length37
Mean length25.421687
Min length19

Characters and Unicode

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

Unique

Unique77 ?
Unique (%)92.8%

Sample

1st row경상남도 거제시 거제중앙로 1893，1층 (고현동)
2nd row경상남도 거제시 거제중앙로 1894，1층 (고현동)
3rd row경상남도 거제시 서문로3길 26，윤석빌딩 1층 (고현동)
4th row경상남도 거제시 아주1로2길 62，명주빌딩 1층 (아주동)
5th row경상남도 거제시 수양로 458，1층 (수월동)
ValueCountFrequency (%)
경상남도 83
19.3%
거제시 83
19.3%
고현동 28
 
6.5%
거제중앙로 15
 
3.5%
옥포동 11
 
2.6%
옥포로 8
 
1.9%
상동동 6
 
1.4%
거제대로 5
 
1.2%
아주동 4
 
0.9%
1층 4
 
0.9%
Other values (136) 183
42.6%
2023-12-13T04:23:21.050675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
347
 
16.4%
제 111
 
5.3%
거 110
 
5.2%
상 96
 
4.5%
1 90
 
4.3%
동 88
 
4.2%
남 85
 
4.0%
경 84
 
4.0%
도 83
 
3.9%
시 83
 
3.9%
Other values (86) 933
44.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1263
59.9%
Space Separator 347
 
16.4%
Decimal Number 310
 
14.7%
Open Punctuation 71
 
3.4%
Close Punctuation 71
 
3.4%
Other Punctuation 38
 
1.8%
Dash Punctuation 10
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
제 111
 
8.8%
거 110
 
8.7%
상 96
 
7.6%
동 88
 
7.0%
남 85
 
6.7%
경 84
 
6.7%
도 83
 
6.6%
시 83
 
6.6%
로 75
 
5.9%
고 39
 
3.1%
Other values (70) 409
32.4%
Decimal Number
ValueCountFrequency (%)
1 90
29.0%
2 46
14.8%
8 31
 
10.0%
4 30
 
9.7%
5 22
 
7.1%
3 22
 
7.1%
0 20
 
6.5%
9 19
 
6.1%
6 17
 
5.5%
7 13
 
4.2%
Other Punctuation
ValueCountFrequency (%)
， 37
97.4%
. 1
 
2.6%
Space Separator
ValueCountFrequency (%)
347
100.0%
Open Punctuation
ValueCountFrequency (%)
( 71
100.0%
Close Punctuation
ValueCountFrequency (%)
) 71
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1263
59.9%
Common 847
40.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
제 111
 
8.8%
거 110
 
8.7%
상 96
 
7.6%
동 88
 
7.0%
남 85
 
6.7%
경 84
 
6.7%
도 83
 
6.6%
시 83
 
6.6%
로 75
 
5.9%
고 39
 
3.1%
Other values (70) 409
32.4%
Common
ValueCountFrequency (%)
347
41.0%
1 90
 
10.6%
( 71
 
8.4%
) 71
 
8.4%
2 46
 
5.4%
， 37
 
4.4%
8 31
 
3.7%
4 30
 
3.5%
5 22
 
2.6%
3 22
 
2.6%
Other values (6) 80
 
9.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1263
59.9%
ASCII 810
38.4%
None 37
 
1.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
347
42.8%
1 90
 
11.1%
( 71
 
8.8%
) 71
 
8.8%
2 46
 
5.7%
8 31
 
3.8%
4 30
 
3.7%
5 22
 
2.7%
3 22
 
2.7%
0 20
 
2.5%
Other values (5) 60
 
7.4%
Hangul
ValueCountFrequency (%)
제 111
 
8.8%
거 110
 
8.7%
상 96
 
7.6%
동 88
 
7.0%
남 85
 
6.7%
경 84
 
6.7%
도 83
 
6.6%
시 83
 
6.6%
로 75
 
5.9%
고 39
 
3.1%
Other values (70) 409
32.4%
None
ValueCountFrequency (%)
， 37
100.0%

기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size796.0 B
Minimum2023-11-08 00:00:00
Maximum2023-11-08 00:00:00
2023-12-13T04:23:21.204621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:23:21.330341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-13T04:23:21.441357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
명칭전화번호소재지(도로명)
명칭1.0001.0001.000
전화번호1.0001.0001.000
소재지(도로명)1.0001.0001.000

Missing values

2023-12-13T04:23:18.074657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T04:23:18.189977image/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약국드림약국055-633-8810경상남도 거제시 거제중앙로 1893，1층 (고현동)2023-11-08
1약국르네상스약국055-634-0111경상남도 거제시 거제중앙로 1894，1층 (고현동)2023-11-08
2약국일등약국<NA>경상남도 거제시 서문로3길 26，윤석빌딩 1층 (고현동)2023-11-08
3약국아주약국<NA>경상남도 거제시 아주1로2길 62，명주빌딩 1층 (아주동)2023-11-08
4약국진약국055-637-9723경상남도 거제시 수양로 458，1층 (수월동)2023-11-08
5약국사곡조제약국055-635-9855경상남도 거제시 사등면 두동로 142023-11-08
6약국옥포로약국055-688-3238경상남도 거제시 옥포로 232 (옥포동)2023-11-08
7약국미리내약국055-633-7903경상남도 거제시 상동5길 79，1층 4호 (상동동)2023-11-08
8약국아주조은약국055-682-0854경상남도 거제시 아주2로 45，1층 (아주동)2023-11-08
9약국튼튼i약국<NA>경상남도 거제시 장평1로 7，거제 장평 유림노르웨이숲 상가동 215호 (장평동，거제 장평 유림노르웨이숲)2023-11-08
구분명칭전화번호소재지(도로명)기준일자
73약국김약국055-632-1194경상남도 거제시 거제중앙로 1878-1，104호 (고현동，제원빌딩)2023-11-08
74약국바다온누리약국055-635-4800경상남도 거제시 계룡로5길 12-1 (상동동)2023-11-08
75약국시민약국055-633-4036경상남도 거제시 거제면 읍내로2길 302023-11-08
76약국대우약국055-681-2695경상남도 거제시 장승포로1길 4 (장승포동)2023-11-08
77약국옥수당약국055-682-1616경상남도 거제시 옥수로10길 40 (능포동)2023-11-08
78약국고현약국055-635-2125경상남도 거제시 거제중앙로 1867 (고현동)2023-11-08
79약국삼성약국055-635-2408경상남도 거제시 중곡로 45 (고현동)2023-11-08
80약국우리약국055-633-4178경상남도 거제시 거제면 읍내로2길 282023-11-08
81약국맑은샘병원055-731-1240경상남도 거제시 연초면 거제대로 44772023-11-08
82약국사랑온누리약국055-632-4663경상남도 거제시 연초면 거제대로 4463 . 1층2023-11-08

Duplicate rows

Most frequently occurring

구분명칭전화번호소재지(도로명)기준일자# duplicates
0약국고은약국055-633-3375경상남도 거제시 고현로 88 (고현동)2023-11-082
1약국미래약국055-682-0801경상남도 거제시 두모길 15 (두모동)2023-11-082
2약국신세계약국055-636-6888경상남도 거제시 거제중앙로 1908 (고현동)2023-11-082