Overview

Dataset statistics

Number of variables3
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows1
Duplicate rows (%)3.3%
Total size in memory852.0 B
Average record size in memory28.4 B

Variable types

Text3

Dataset

Description경상남도 창녕군의 의료기관정보-약국 및 약방 현황에 대한 데이터로 해당 정보는 약국명, 주소, 연락처를 포함하고 있습니다.
Author경상남도 창녕군
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15054815

Alerts

Dataset has 1 (3.3%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-10 22:39:12.089081
Analysis finished2023-12-10 22:39:12.330901
Duration0.24 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct29
Distinct (%)96.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-11T07:39:12.442905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length8
Mean length4.7666667
Min length3

Characters and Unicode

Total characters143
Distinct characters59
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

Unique28 ?
Unique (%)93.3%

Sample

1st row새행복약국
2nd row참사랑약국
3rd row하나로약국
4th row부림약국
5th row군청약국
ValueCountFrequency (%)
창녕약국 2
 
6.2%
영산약국 1
 
3.1%
김약국 1
 
3.1%
이방약국 1
 
3.1%
보건약국 1
 
3.1%
명성약국 1
 
3.1%
아세아약국 1
 
3.1%
초록약국 1
 
3.1%
부곡종합약국 1
 
3.1%
신경남약국 1
 
3.1%
Other values (21) 21
65.6%
2023-12-11T07:39:12.721788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
30
21.0%
30
21.0%
4
 
2.8%
4
 
2.8%
4
 
2.8%
3
 
2.1%
3
 
2.1%
3
 
2.1%
2
 
1.4%
2
 
1.4%
Other values (49) 58
40.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 141
98.6%
Space Separator 2
 
1.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
30
21.3%
30
21.3%
4
 
2.8%
4
 
2.8%
4
 
2.8%
3
 
2.1%
3
 
2.1%
3
 
2.1%
2
 
1.4%
2
 
1.4%
Other values (48) 56
39.7%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 141
98.6%
Common 2
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
30
21.3%
30
21.3%
4
 
2.8%
4
 
2.8%
4
 
2.8%
3
 
2.1%
3
 
2.1%
3
 
2.1%
2
 
1.4%
2
 
1.4%
Other values (48) 56
39.7%
Common
ValueCountFrequency (%)
2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 141
98.6%
ASCII 2
 
1.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
30
21.3%
30
21.3%
4
 
2.8%
4
 
2.8%
4
 
2.8%
3
 
2.1%
3
 
2.1%
3
 
2.1%
2
 
1.4%
2
 
1.4%
Other values (48) 56
39.7%
ASCII
ValueCountFrequency (%)
2
100.0%
Distinct29
Distinct (%)96.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-11T07:39:12.913502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length29
Mean length21.8
Min length18

Characters and Unicode

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

Unique

Unique28 ?
Unique (%)93.3%

Sample

1st row경상남도 창녕군 영산면 영산중앙길 3, 102호
2nd row경상남도 창녕군 창녕읍 창녕대로 65
3rd row경상남도 창녕군 남지읍 낙동로 498-2, 2층
4th row경상남도 창녕군 창녕읍 당산1길 26-22, 부림빌딩
5th row경상남도 창녕군 창녕읍 군청길 18
ValueCountFrequency (%)
경상남도 30
19.4%
창녕군 30
19.4%
창녕읍 15
 
9.7%
남지읍 5
 
3.2%
영산면 5
 
3.2%
창녕시장길 4
 
2.6%
우포2로 3
 
1.9%
116 2
 
1.3%
낙동로 2
 
1.3%
영산계성로 2
 
1.3%
Other values (49) 57
36.8%
2023-12-11T07:39:13.219364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
125
19.1%
52
 
8.0%
51
 
7.8%
36
 
5.5%
31
 
4.7%
30
 
4.6%
30
 
4.6%
30
 
4.6%
1 28
 
4.3%
20
 
3.1%
Other values (55) 221
33.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 425
65.0%
Space Separator 125
 
19.1%
Decimal Number 90
 
13.8%
Dash Punctuation 7
 
1.1%
Other Punctuation 3
 
0.5%
Close Punctuation 2
 
0.3%
Open Punctuation 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
52
12.2%
51
12.0%
36
 
8.5%
31
 
7.3%
30
 
7.1%
30
 
7.1%
30
 
7.1%
20
 
4.7%
18
 
4.2%
12
 
2.8%
Other values (40) 115
27.1%
Decimal Number
ValueCountFrequency (%)
1 28
31.1%
2 16
17.8%
5 8
 
8.9%
6 7
 
7.8%
8 7
 
7.8%
3 6
 
6.7%
9 6
 
6.7%
7 4
 
4.4%
0 4
 
4.4%
4 4
 
4.4%
Space Separator
ValueCountFrequency (%)
125
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%
Other Punctuation
ValueCountFrequency (%)
, 3
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 425
65.0%
Common 229
35.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
52
12.2%
51
12.0%
36
 
8.5%
31
 
7.3%
30
 
7.1%
30
 
7.1%
30
 
7.1%
20
 
4.7%
18
 
4.2%
12
 
2.8%
Other values (40) 115
27.1%
Common
ValueCountFrequency (%)
125
54.6%
1 28
 
12.2%
2 16
 
7.0%
5 8
 
3.5%
6 7
 
3.1%
8 7
 
3.1%
- 7
 
3.1%
3 6
 
2.6%
9 6
 
2.6%
7 4
 
1.7%
Other values (5) 15
 
6.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 425
65.0%
ASCII 229
35.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
125
54.6%
1 28
 
12.2%
2 16
 
7.0%
5 8
 
3.5%
6 7
 
3.1%
8 7
 
3.1%
- 7
 
3.1%
3 6
 
2.6%
9 6
 
2.6%
7 4
 
1.7%
Other values (5) 15
 
6.6%
Hangul
ValueCountFrequency (%)
52
12.2%
51
12.0%
36
 
8.5%
31
 
7.3%
30
 
7.1%
30
 
7.1%
30
 
7.1%
20
 
4.7%
18
 
4.2%
12
 
2.8%
Other values (40) 115
27.1%
Distinct29
Distinct (%)96.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-11T07:39:13.415287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

Total characters360
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique28 ?
Unique (%)93.3%

Sample

1st row055-521-4518
2nd row055-786-8200
3rd row055-526-0447
4th row055-532-8047
5th row055-532-3544
ValueCountFrequency (%)
055-533-3360 2
 
6.2%
055-521-7577 1
 
3.1%
055-526-5362 1
 
3.1%
055-532-5511 1
 
3.1%
055-526-5753 1
 
3.1%
055-533-3784 1
 
3.1%
055-536-2875 1
 
3.1%
055-532-8166 1
 
3.1%
055-521-5115 1
 
3.1%
055-533-0604 1
 
3.1%
Other values (21) 21
65.6%
2023-12-11T07:39:13.692704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 104
28.9%
- 58
16.1%
0 51
14.2%
3 44
12.2%
2 25
 
6.9%
6 18
 
5.0%
7 16
 
4.4%
1 13
 
3.6%
8 12
 
3.3%
4 10
 
2.8%
Other values (2) 9
 
2.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 300
83.3%
Dash Punctuation 58
 
16.1%
Space Separator 2
 
0.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 104
34.7%
0 51
17.0%
3 44
14.7%
2 25
 
8.3%
6 18
 
6.0%
7 16
 
5.3%
1 13
 
4.3%
8 12
 
4.0%
4 10
 
3.3%
9 7
 
2.3%
Dash Punctuation
ValueCountFrequency (%)
- 58
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 360
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 104
28.9%
- 58
16.1%
0 51
14.2%
3 44
12.2%
2 25
 
6.9%
6 18
 
5.0%
7 16
 
4.4%
1 13
 
3.6%
8 12
 
3.3%
4 10
 
2.8%
Other values (2) 9
 
2.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 360
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 104
28.9%
- 58
16.1%
0 51
14.2%
3 44
12.2%
2 25
 
6.9%
6 18
 
5.0%
7 16
 
4.4%
1 13
 
3.6%
8 12
 
3.3%
4 10
 
2.8%
Other values (2) 9
 
2.5%

Correlations

2023-12-11T07:39:13.787426image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
약국명칭약국소재지(도로명)약국전화번호
약국명칭1.0001.0001.000
약국소재지(도로명)1.0001.0001.000
약국전화번호1.0001.0001.000

Missing values

2023-12-11T07:39:12.241021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T07:39:12.304619image/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새행복약국경상남도 창녕군 영산면 영산중앙길 3, 102호055-521-4518
1참사랑약국경상남도 창녕군 창녕읍 창녕대로 65055-786-8200
2하나로약국경상남도 창녕군 남지읍 낙동로 498-2, 2층055-526-0447
3부림약국경상남도 창녕군 창녕읍 당산1길 26-22, 부림빌딩055-532-8047
4군청약국경상남도 창녕군 창녕읍 군청길 18055-532-3544
5화왕산약국경상남도 창녕군 창녕읍 명덕로 66-1055-533-0990
6창녕약국경상남도 창녕군 창녕읍 창녕시장길 116055-533-3360
7대합곰약국경상남도 창녕군 대합면 창한로 105-1055-532-0213
8창녕약국경상남도 창녕군 창녕읍 창녕시장길 116055-533-3360
9비사벌약국경상남도 창녕군 창녕읍 창녕시장길 85055-533-9757
약국명칭약국소재지(도로명)약국전화번호
20온천온누리약국경상남도 창녕군 부곡면 원앙로 211055-536-5333
21새경남약국경상남도 창녕군 남지읍 낙동로 518055-526-2875
22신경남약국경상남도 창녕군 창녕읍 명덕로 45-1055-533-0604
23부곡종합약국경상남도 창녕군 부곡면 원앙로 237055-521-5115
24초록약국경상남도 창녕군 창녕읍 창녕대로 126055-532-8166
25아세아약국경상남도 창녕군 영산면 연지길 8055-536-2875
26명성약국경상남도 창녕군 창녕읍 옥만길 19055-533-3784
27보건약국경상남도 창녕군 남지읍 동포로 10055-526-5753
28이방약국경상남도 창녕군 이방면 이방로 955-1055-532-5511
29제일약국경상남도 창녕군 영산면 연지길 37-1055-536-7022

Duplicate rows

Most frequently occurring

약국명칭약국소재지(도로명)약국전화번호# duplicates
0창녕약국경상남도 창녕군 창녕읍 창녕시장길 116055-533-33602