Overview

Dataset statistics

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

Variable types

Categorical2
Text3

Dataset

Description경상남도 거제시 내의 의약업소의 명칭, 전화번호, 소재지 등의 현황을 제공하여 관광객의 편의 도모 및 지역경제 활성화 목적
Author경상남도 거제시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=3079321

Alerts

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

Reproduction

Analysis started2024-04-18 05:18:46.776268
Analysis finished2024-04-18 05:18:49.171394
Duration2.4 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size812.0 B
약국
85 

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 (%)
약국 85
100.0%

Length

2024-04-18T14:18:49.230509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T14:18:49.326188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 85
100.0%

명칭
Text

Distinct82
Distinct (%)96.5%
Missing0
Missing (%)0.0%
Memory size812.0 B
2024-04-18T14:18:49.552083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length7
Mean length4.8823529
Min length3

Characters and Unicode

Total characters415
Distinct characters119
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

Unique79 ?
Unique (%)92.9%

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 (72) 72
84.7%
2024-04-18T14:18:49.954694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 84
20.2%
국 84
20.2%
리 10
 
2.4%
누 8
 
1.9%
온 8
 
1.9%
은 6
 
1.4%
세 6
 
1.4%
제 5
 
1.2%
대 5
 
1.2%
한 5
 
1.2%
Other values (109) 194
46.7%

Most occurring categories

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

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 84
20.3%
국 84
20.3%
리 10
 
2.4%
누 8
 
1.9%
온 8
 
1.9%
은 6
 
1.4%
세 6
 
1.4%
제 5
 
1.2%
대 5
 
1.2%
한 5
 
1.2%
Other values (108) 193
46.6%
Lowercase Letter
ValueCountFrequency (%)
i 1
100.0%

Most occurring scripts

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

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 84
20.3%
국 84
20.3%
리 10
 
2.4%
누 8
 
1.9%
온 8
 
1.9%
은 6
 
1.4%
세 6
 
1.4%
제 5
 
1.2%
대 5
 
1.2%
한 5
 
1.2%
Other values (108) 193
46.6%
Latin
ValueCountFrequency (%)
i 1
100.0%

Most occurring blocks

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

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 84
20.3%
국 84
20.3%
리 10
 
2.4%
누 8
 
1.9%
온 8
 
1.9%
은 6
 
1.4%
세 6
 
1.4%
제 5
 
1.2%
대 5
 
1.2%
한 5
 
1.2%
Other values (108) 193
46.6%
ASCII
ValueCountFrequency (%)
i 1
100.0%

전화번호
Text

MISSING 

Distinct79
Distinct (%)96.3%
Missing3
Missing (%)3.5%
Memory size812.0 B
2024-04-18T14:18:50.190489image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.036585
Min length12

Characters and Unicode

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

Unique76 ?
Unique (%)92.7%

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.4%
055-636-6888 2
 
2.4%
055-682-0801 2
 
2.4%
055-633-4178 1
 
1.2%
055-633-8810 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%
055-681-5180 1
 
1.2%
Other values (69) 69
84.1%
2024-04-18T14:18:50.570915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 198
20.1%
- 164
16.6%
0 127
12.9%
6 110
11.1%
3 92
9.3%
8 92
9.3%
2 52
 
5.3%
7 50
 
5.1%
1 44
 
4.5%
4 31
 
3.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 823
83.4%
Dash Punctuation 164
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 198
24.1%
0 127
15.4%
6 110
13.4%
3 92
11.2%
8 92
11.2%
2 52
 
6.3%
7 50
 
6.1%
1 44
 
5.3%
4 31
 
3.8%
9 27
 
3.3%
Dash Punctuation
ValueCountFrequency (%)
- 164
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 987
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 198
20.1%
- 164
16.6%
0 127
12.9%
6 110
11.1%
3 92
9.3%
8 92
9.3%
2 52
 
5.3%
7 50
 
5.1%
1 44
 
4.5%
4 31
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 987
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 198
20.1%
- 164
16.6%
0 127
12.9%
6 110
11.1%
3 92
9.3%
8 92
9.3%
2 52
 
5.3%
7 50
 
5.1%
1 44
 
4.5%
4 31
 
3.1%

소재지(도로명)
Text

Distinct82
Distinct (%)96.5%
Missing0
Missing (%)0.0%
Memory size812.0 B
2024-04-18T14:18:50.853943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length58
Median length37
Mean length25.305882
Min length19

Characters and Unicode

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

Unique79 ?
Unique (%)92.9%

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 (%)
경상남도 85
19.4%
거제시 85
19.4%
고현동 28
 
6.4%
거제중앙로 15
 
3.4%
옥포동 13
 
3.0%
옥포로 8
 
1.8%
상동동 6
 
1.4%
12 4
 
0.9%
서문로 4
 
0.9%
거제대로 4
 
0.9%
Other values (138) 186
42.5%
2024-04-18T14:18:51.260741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
353
 
16.4%
제 112
 
5.2%
거 111
 
5.2%
상 98
 
4.6%
동 91
 
4.2%
1 90
 
4.2%
남 87
 
4.0%
경 86
 
4.0%
도 86
 
4.0%
시 85
 
4.0%
Other values (86) 952
44.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1290
60.0%
Space Separator 353
 
16.4%
Decimal Number 312
 
14.5%
Open Punctuation 74
 
3.4%
Close Punctuation 74
 
3.4%
Other Punctuation 37
 
1.7%
Dash Punctuation 11
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
제 112
 
8.7%
거 111
 
8.6%
상 98
 
7.6%
동 91
 
7.1%
남 87
 
6.7%
경 86
 
6.7%
도 86
 
6.7%
시 85
 
6.6%
로 76
 
5.9%
고 39
 
3.0%
Other values (71) 419
32.5%
Decimal Number
ValueCountFrequency (%)
1 90
28.8%
2 46
14.7%
8 31
 
9.9%
4 29
 
9.3%
3 24
 
7.7%
5 22
 
7.1%
9 21
 
6.7%
0 20
 
6.4%
6 16
 
5.1%
7 13
 
4.2%
Space Separator
ValueCountFrequency (%)
353
100.0%
Open Punctuation
ValueCountFrequency (%)
( 74
100.0%
Close Punctuation
ValueCountFrequency (%)
) 74
100.0%
Other Punctuation
ValueCountFrequency (%)
， 37
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1290
60.0%
Common 861
40.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
제 112
 
8.7%
거 111
 
8.6%
상 98
 
7.6%
동 91
 
7.1%
남 87
 
6.7%
경 86
 
6.7%
도 86
 
6.7%
시 85
 
6.6%
로 76
 
5.9%
고 39
 
3.0%
Other values (71) 419
32.5%
Common
ValueCountFrequency (%)
353
41.0%
1 90
 
10.5%
( 74
 
8.6%
) 74
 
8.6%
2 46
 
5.3%
， 37
 
4.3%
8 31
 
3.6%
4 29
 
3.4%
3 24
 
2.8%
5 22
 
2.6%
Other values (5) 81
 
9.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1290
60.0%
ASCII 824
38.3%
None 37
 
1.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
353
42.8%
1 90
 
10.9%
( 74
 
9.0%
) 74
 
9.0%
2 46
 
5.6%
8 31
 
3.8%
4 29
 
3.5%
3 24
 
2.9%
5 22
 
2.7%
9 21
 
2.5%
Other values (4) 60
 
7.3%
Hangul
ValueCountFrequency (%)
제 112
 
8.7%
거 111
 
8.6%
상 98
 
7.6%
동 91
 
7.1%
남 87
 
6.7%
경 86
 
6.7%
도 86
 
6.7%
시 85
 
6.6%
로 76
 
5.9%
고 39
 
3.0%
Other values (71) 419
32.5%
None
ValueCountFrequency (%)
， 37
100.0%

기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size812.0 B
2022-11-15
85 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-11-15
2nd row2022-11-15
3rd row2022-11-15
4th row2022-11-15
5th row2022-11-15

Common Values

ValueCountFrequency (%)
2022-11-15 85
100.0%

Length

2024-04-18T14:18:51.391167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T14:18:51.491565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-11-15 85
100.0%

Correlations

2024-04-18T14:18:51.555686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
명칭전화번호소재지(도로명)
명칭1.0001.0001.000
전화번호1.0001.0001.000
소재지(도로명)1.0001.0001.000

Missing values

2024-04-18T14:18:49.133798image/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층 (고현동)2022-11-15
1약국르네상스약국055-634-0111경상남도 거제시 거제중앙로 1894，1층 (고현동)2022-11-15
2약국일등약국<NA>경상남도 거제시 서문로3길 26，윤석빌딩 1층 (고현동)2022-11-15
3약국아주약국<NA>경상남도 거제시 아주1로2길 62，명주빌딩 1층 (아주동)2022-11-15
4약국진약국055-637-9723경상남도 거제시 수양로 458，1층 (수월동)2022-11-15
5약국사곡조제약국055-635-9855경상남도 거제시 사등면 두동로 142022-11-15
6약국옥포로약국055-688-3238경상남도 거제시 옥포로 232 (옥포동)2022-11-15
7약국미리내약국055-633-7903경상남도 거제시 상동5길 79，1층 4호 (상동동)2022-11-15
8약국아주조은약국055-682-0854경상남도 거제시 아주2로 45，1층 (아주동)2022-11-15
9약국튼튼i약국<NA>경상남도 거제시 장평1로 7，거제 장평 유림노르웨이숲 상가동 215호 (장평동，거제 장평 유림노르웨이숲)2022-11-15
구분명칭전화번호소재지(도로명)기준일자
75약국바다온누리약국055-635-4800경상남도 거제시 계룡로5길 12-1 (상동동)2022-11-15
76약국시민약국055-633-4036경상남도 거제시 거제면 읍내로2길 302022-11-15
77약국희보약국055-681-2441경상남도 거제시 능포로 134 (능포동)2022-11-15
78약국모범약국055-687-2431경상남도 거제시 옥포대첩로 33 (옥포동)2022-11-15
79약국대우약국055-681-2695경상남도 거제시 장승포로1길 4 (장승포동)2022-11-15
80약국옥수당약국055-682-1616경상남도 거제시 옥수로10길 40 (능포동)2022-11-15
81약국고현약국055-635-2125경상남도 거제시 거제중앙로 1867 (고현동)2022-11-15
82약국삼성약국055-635-2408경상남도 거제시 중곡로 45 (고현동)2022-11-15
83약국우리약국055-633-4178경상남도 거제시 거제면 읍내로2길 282022-11-15
84약국맑은샘병원055-731-1240경상남도 거제시 연초면 거제대로 44772022-11-15

Duplicate rows

Most frequently occurring

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