Overview

Dataset statistics

Number of variables4
Number of observations30
Missing cells11
Missing cells (%)9.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.1 KiB
Average record size in memory36.4 B

Variable types

Text4

Dataset

Description충청북도 영동군의 의약품 취급 업소 현황으로 업소명, 소재지도로명주소, 전화번호, 팩스번호가 있습니다.
Author충청북도 영동군
URLhttps://www.data.go.kr/data/3071344/fileData.do

Alerts

팩스번호 has 11 (36.7%) missing valuesMissing
업소명 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 15:55:35.849011
Analysis finished2023-12-12 15:55:36.469589
Duration0.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업소명
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-13T00:55:36.609820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length6.5
Mean length4.8
Min length3

Characters and Unicode

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

Unique

Unique30 ?
Unique (%)100.0%

Sample

1st row중앙약국
2nd row동산약국
3rd row서울약국
4th row새영동약국
5th row용산약국
ValueCountFrequency (%)
중앙약국 1
 
3.3%
동산약국 1
 
3.3%
인제당한약방 1
 
3.3%
영동한약방 1
 
3.3%
삼성약방 1
 
3.3%
금호약방 1
 
3.3%
정약국 1
 
3.3%
영동큰사랑약국 1
 
3.3%
일편단심약국 1
 
3.3%
가까운약국 1
 
3.3%
Other values (20) 20
66.7%
2023-12-13T00:55:37.027923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 30
20.8%
국 25
17.4%
동 6
 
4.2%
방 5
 
3.5%
영 5
 
3.5%
한 3
 
2.1%
울 3
 
2.1%
성 3
 
2.1%
서 3
 
2.1%
정 2
 
1.4%
Other values (55) 59
41.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 144
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 30
20.8%
국 25
17.4%
동 6
 
4.2%
방 5
 
3.5%
영 5
 
3.5%
한 3
 
2.1%
울 3
 
2.1%
성 3
 
2.1%
서 3
 
2.1%
정 2
 
1.4%
Other values (55) 59
41.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 144
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 30
20.8%
국 25
17.4%
동 6
 
4.2%
방 5
 
3.5%
영 5
 
3.5%
한 3
 
2.1%
울 3
 
2.1%
성 3
 
2.1%
서 3
 
2.1%
정 2
 
1.4%
Other values (55) 59
41.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 144
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 30
20.8%
국 25
17.4%
동 6
 
4.2%
방 5
 
3.5%
영 5
 
3.5%
한 3
 
2.1%
울 3
 
2.1%
성 3
 
2.1%
서 3
 
2.1%
정 2
 
1.4%
Other values (55) 59
41.0%

소재지도로명주소
Text

Distinct29
Distinct (%)96.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-13T00:55:37.272276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length25
Mean length20.633333
Min length15

Characters and Unicode

Total characters619
Distinct characters58
Distinct categories5 ?
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충청북도 영동군 추풍령면 추풍령로 480
2nd row충청북도 영동군 영동읍 중앙로 27-1
3rd row충청북도 영동군 상촌면 민주지산로 3026-1
4th row충청북도 영동군 영동읍 중앙로 31-1
5th row충청북도 영동군 용산면 용산로 333-1
ValueCountFrequency (%)
충청북도 30
19.5%
영동군 30
19.5%
영동읍 19
 
12.3%
중앙로 9
 
5.8%
계산로 4
 
2.6%
3길 2
 
1.3%
양산면 2
 
1.3%
추풍령면 2
 
1.3%
황간로 2
 
1.3%
학산영동로 2
 
1.3%
Other values (50) 52
33.8%
2023-12-13T00:55:37.659130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
124
20.0%
동 54
 
8.7%
영 53
 
8.6%
충 30
 
4.8%
군 30
 
4.8%
청 30
 
4.8%
도 30
 
4.8%
북 30
 
4.8%
로 27
 
4.4%
1 20
 
3.2%
Other values (48) 191
30.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 407
65.8%
Space Separator 124
 
20.0%
Decimal Number 79
 
12.8%
Dash Punctuation 8
 
1.3%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 54
13.3%
영 53
13.0%
충 30
 
7.4%
군 30
 
7.4%
청 30
 
7.4%
도 30
 
7.4%
북 30
 
7.4%
로 27
 
6.6%
읍 19
 
4.7%
산 13
 
3.2%
Other values (35) 91
22.4%
Decimal Number
ValueCountFrequency (%)
1 20
25.3%
3 13
16.5%
4 10
12.7%
2 10
12.7%
8 8
 
10.1%
0 5
 
6.3%
5 4
 
5.1%
9 3
 
3.8%
6 3
 
3.8%
7 3
 
3.8%
Space Separator
ValueCountFrequency (%)
124
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 407
65.8%
Common 212
34.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 54
13.3%
영 53
13.0%
충 30
 
7.4%
군 30
 
7.4%
청 30
 
7.4%
도 30
 
7.4%
북 30
 
7.4%
로 27
 
6.6%
읍 19
 
4.7%
산 13
 
3.2%
Other values (35) 91
22.4%
Common
ValueCountFrequency (%)
124
58.5%
1 20
 
9.4%
3 13
 
6.1%
4 10
 
4.7%
2 10
 
4.7%
- 8
 
3.8%
8 8
 
3.8%
0 5
 
2.4%
5 4
 
1.9%
9 3
 
1.4%
Other values (3) 7
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 407
65.8%
ASCII 212
34.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
124
58.5%
1 20
 
9.4%
3 13
 
6.1%
4 10
 
4.7%
2 10
 
4.7%
- 8
 
3.8%
8 8
 
3.8%
0 5
 
2.4%
5 4
 
1.9%
9 3
 
1.4%
Other values (3) 7
 
3.3%
Hangul
ValueCountFrequency (%)
동 54
13.3%
영 53
13.0%
충 30
 
7.4%
군 30
 
7.4%
청 30
 
7.4%
도 30
 
7.4%
북 30
 
7.4%
로 27
 
6.6%
읍 19
 
4.7%
산 13
 
3.2%
Other values (35) 91
22.4%

전화번호
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-13T00:55:37.953920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique30 ?
Unique (%)100.0%

Sample

1st row043-742-2545
2nd row043-742-1545
3rd row043-743-3671
4th row043-743-4806
5th row043-742-2669
ValueCountFrequency (%)
043-742-2545 1
 
3.3%
043-742-1545 1
 
3.3%
043-742-0394 1
 
3.3%
043-743-7154 1
 
3.3%
043-742-2519 1
 
3.3%
043-743-9028 1
 
3.3%
043-742-8275 1
 
3.3%
043-742-6900 1
 
3.3%
043-744-2360 1
 
3.3%
043-745-6390 1
 
3.3%
Other values (20) 20
66.7%
2023-12-13T00:55:38.469963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 72
20.0%
- 60
16.7%
0 48
13.3%
3 45
12.5%
7 37
10.3%
2 26
 
7.2%
5 25
 
6.9%
6 16
 
4.4%
1 13
 
3.6%
9 10
 
2.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 300
83.3%
Dash Punctuation 60
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 72
24.0%
0 48
16.0%
3 45
15.0%
7 37
12.3%
2 26
 
8.7%
5 25
 
8.3%
6 16
 
5.3%
1 13
 
4.3%
9 10
 
3.3%
8 8
 
2.7%
Dash Punctuation
ValueCountFrequency (%)
- 60
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 360
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 72
20.0%
- 60
16.7%
0 48
13.3%
3 45
12.5%
7 37
10.3%
2 26
 
7.2%
5 25
 
6.9%
6 16
 
4.4%
1 13
 
3.6%
9 10
 
2.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 360
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 72
20.0%
- 60
16.7%
0 48
13.3%
3 45
12.5%
7 37
10.3%
2 26
 
7.2%
5 25
 
6.9%
6 16
 
4.4%
1 13
 
3.6%
9 10
 
2.8%

팩스번호
Text

MISSING 

Distinct19
Distinct (%)100.0%
Missing11
Missing (%)36.7%
Memory size372.0 B
2023-12-13T00:55:38.724501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.947368
Min length11

Characters and Unicode

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

Unique19 ?
Unique (%)100.0%

Sample

1st row043-745-1545
2nd row043-744-5006
3rd row043-742-2669
4th row043-744-7203
5th row043-742-1618
ValueCountFrequency (%)
043-745-1545 1
 
5.3%
043-745-2110 1
 
5.3%
043-742-8270 1
 
5.3%
043-745-5033 1
 
5.3%
043-745-1882 1
 
5.3%
043-745-8821 1
 
5.3%
043-745-3224 1
 
5.3%
043-744-9260 1
 
5.3%
043-743-5333 1
 
5.3%
043-744-7666 1
 
5.3%
Other values (9) 9
47.4%
2023-12-13T00:55:39.174861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 49
21.6%
- 37
16.3%
3 29
12.8%
0 27
11.9%
7 25
11.0%
2 17
 
7.5%
5 14
 
6.2%
1 9
 
4.0%
6 9
 
4.0%
8 9
 
4.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 190
83.7%
Dash Punctuation 37
 
16.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 49
25.8%
3 29
15.3%
0 27
14.2%
7 25
13.2%
2 17
 
8.9%
5 14
 
7.4%
1 9
 
4.7%
6 9
 
4.7%
8 9
 
4.7%
9 2
 
1.1%
Dash Punctuation
ValueCountFrequency (%)
- 37
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 227
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 49
21.6%
- 37
16.3%
3 29
12.8%
0 27
11.9%
7 25
11.0%
2 17
 
7.5%
5 14
 
6.2%
1 9
 
4.0%
6 9
 
4.0%
8 9
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 227
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 49
21.6%
- 37
16.3%
3 29
12.8%
0 27
11.9%
7 25
11.0%
2 17
 
7.5%
5 14
 
6.2%
1 9
 
4.0%
6 9
 
4.0%
8 9
 
4.0%

Correlations

2023-12-13T00:55:39.300270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명소재지도로명주소전화번호팩스번호
업소명1.0001.0001.0001.000
소재지도로명주소1.0001.0001.0001.000
전화번호1.0001.0001.0001.000
팩스번호1.0001.0001.0001.000

Missing values

2023-12-13T00:55:36.353411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:55:36.435521image/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중앙약국충청북도 영동군 추풍령면 추풍령로 480043-742-2545<NA>
1동산약국충청북도 영동군 영동읍 중앙로 27-1043-742-1545043-745-1545
2서울약국충청북도 영동군 상촌면 민주지산로 3026-1043-743-3671<NA>
3새영동약국충청북도 영동군 영동읍 중앙로 31-1043-743-4806043-744-5006
4용산약국충청북도 영동군 용산면 용산로 333-1043-742-2669043-742-2669
5영동종로약국충청북도 영동군 영동읍 영동시장 3길 4043-744-7201043-744-7203
6영동프라자약국충청북도 영동군 영동읍 계산로 3043-742-1616043-742-1618
7하나약국충청북도 영동군 영동읍 중앙로 4길 8043-744-7785043-744-7785
8세정온누리약국충청북도 영동군 영동읍 계산로 31043-744-8255043-744-8252
9사라약국충청북도 영동군 영동읍 학산영동로 1244-1043-745-0966043-7454271
업소명소재지도로명주소전화번호팩스번호
20효성약국충청북도 영동군 영동읍 중앙로 18-1043-745-1004<NA>
21가까운약국충청북도 영동군 황간면 황간로 38043-745-6390043-742-8270
22일편단심약국충청북도 영동군 영동읍 계산로 91043-744-2360043-744-2361
23영동큰사랑약국충청북도 영동군 영동읍 중앙로 41043-742-6900<NA>
24정약국충청북도 영동군 주앙로 28043-742-8275<NA>
25금호약방충청북도 영동군 양산면 금강로 1505043-743-9028<NA>
26삼성약방충청북도 영동군 추풍령면 신안로 1670043-742-2519<NA>
27영동한약방충청북도 영동군 영동읍 동정로 79-1043-743-7154<NA>
28인제당한약방충청북도 영동군 양강면 학산영동로 882043-742-0394<NA>
29변한약방충청북도 영동군 양산면 가곡2길 40043-743-8500<NA>