Overview

Dataset statistics

Number of variables5
Number of observations77
Missing cells15
Missing cells (%)3.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.1 KiB
Average record size in memory41.7 B

Variable types

Categorical2
Text3

Dataset

Description충청남도 부여군에 등록된 의약품 판매업소 현황에 대한 정보입니다. (업소이름, 분야, 위치, 전화번호, 데이터기준일자)
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=444&beforeMenuCd=DOM_000000201001001000&publicdatapk=3046035

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 15 (19.5%) missing valuesMissing
판매업소명 has unique valuesUnique
도로명주소 has unique valuesUnique

Reproduction

Analysis started2024-01-09 22:11:43.899490
Analysis finished2024-01-09 22:11:44.241815
Duration0.34 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

Distinct5
Distinct (%)6.5%
Missing0
Missing (%)0.0%
Memory size748.0 B
약국
33 
안전상비의약품판매업소
33 
한약업사
의약품도매상
 
2
한약국
 
1

Length

Max length11
Median length6
Mean length6.1818182
Min length2

Unique

Unique1 ?
Unique (%)1.3%

Sample

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

Common Values

ValueCountFrequency (%)
약국 33
42.9%
안전상비의약품판매업소 33
42.9%
한약업사 8
 
10.4%
의약품도매상 2
 
2.6%
한약국 1
 
1.3%

Length

2024-01-10T07:11:44.293262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:11:44.373848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 33
42.9%
안전상비의약품판매업소 33
42.9%
한약업사 8
 
10.4%
의약품도매상 2
 
2.6%
한약국 1
 
1.3%

판매업소명
Text

UNIQUE 

Distinct77
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size748.0 B
2024-01-10T07:11:44.597279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length14
Mean length7.025974
Min length3

Characters and Unicode

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

Unique

Unique77 ?
Unique (%)100.0%

Sample

1st row부여규암약국
2nd row외산약국
3rd row다정약국
4th row홍산종로약국
5th row홍산예약국
ValueCountFrequency (%)
씨유 4
 
4.3%
지에스(gs)25 3
 
3.3%
미니스톱 2
 
2.2%
gs25 2
 
2.2%
세븐일레븐 2
 
2.2%
부여규암약국 1
 
1.1%
부여중앙점 1
 
1.1%
지에스25(gs25)부여쌍북점 1
 
1.1%
구룡점 1
 
1.1%
부여 1
 
1.1%
Other values (74) 74
80.4%
2024-01-10T07:11:44.929322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
44
 
8.1%
38
 
7.0%
35
 
6.5%
34
 
6.3%
30
 
5.5%
17
 
3.1%
16
 
3.0%
15
 
2.8%
12
 
2.2%
2 10
 
1.8%
Other values (110) 290
53.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 468
86.5%
Decimal Number 20
 
3.7%
Uppercase Letter 18
 
3.3%
Space Separator 15
 
2.8%
Open Punctuation 10
 
1.8%
Close Punctuation 10
 
1.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
44
 
9.4%
38
 
8.1%
35
 
7.5%
34
 
7.3%
30
 
6.4%
17
 
3.6%
16
 
3.4%
12
 
2.6%
10
 
2.1%
9
 
1.9%
Other values (101) 223
47.6%
Uppercase Letter
ValueCountFrequency (%)
G 8
44.4%
S 8
44.4%
U 1
 
5.6%
C 1
 
5.6%
Decimal Number
ValueCountFrequency (%)
2 10
50.0%
5 10
50.0%
Space Separator
ValueCountFrequency (%)
15
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 468
86.5%
Common 55
 
10.2%
Latin 18
 
3.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
44
 
9.4%
38
 
8.1%
35
 
7.5%
34
 
7.3%
30
 
6.4%
17
 
3.6%
16
 
3.4%
12
 
2.6%
10
 
2.1%
9
 
1.9%
Other values (101) 223
47.6%
Common
ValueCountFrequency (%)
15
27.3%
2 10
18.2%
5 10
18.2%
( 10
18.2%
) 10
18.2%
Latin
ValueCountFrequency (%)
G 8
44.4%
S 8
44.4%
U 1
 
5.6%
C 1
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 468
86.5%
ASCII 73
 
13.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
44
 
9.4%
38
 
8.1%
35
 
7.5%
34
 
7.3%
30
 
6.4%
17
 
3.6%
16
 
3.4%
12
 
2.6%
10
 
2.1%
9
 
1.9%
Other values (101) 223
47.6%
ASCII
ValueCountFrequency (%)
15
20.5%
2 10
13.7%
5 10
13.7%
( 10
13.7%
) 10
13.7%
G 8
11.0%
S 8
11.0%
U 1
 
1.4%
C 1
 
1.4%

도로명주소
Text

UNIQUE 

Distinct77
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size748.0 B
2024-01-10T07:11:45.178190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length38
Mean length21.701299
Min length18

Characters and Unicode

Total characters1671
Distinct characters92
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique77 ?
Unique (%)100.0%

Sample

1st row충청남도 부여군 규암면 흥수로 878, 218동 1층 106호 (부여센트럴휴엔하임)
2nd row충청남도 부여군 외산면 외산로 87, 1층
3rd row충청남도 부여군 부여읍 부여로 14-7
4th row충청남도 부여군 홍산면 홍산로 52-1
5th row충청남도 부여군 홍산면 홍산로 49
ValueCountFrequency (%)
충청남도 77
19.2%
부여군 77
19.2%
부여읍 49
 
12.2%
성왕로 10
 
2.5%
규암면 6
 
1.5%
부여로 6
 
1.5%
홍산면 5
 
1.2%
중앙로 5
 
1.2%
1층 5
 
1.2%
충의로 5
 
1.2%
Other values (115) 157
39.1%
2024-01-10T07:11:45.509725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
328
19.6%
136
 
8.1%
133
 
8.0%
82
 
4.9%
81
 
4.8%
81
 
4.8%
77
 
4.6%
77
 
4.6%
76
 
4.5%
1 57
 
3.4%
Other values (82) 543
32.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1079
64.6%
Space Separator 328
 
19.6%
Decimal Number 234
 
14.0%
Dash Punctuation 18
 
1.1%
Other Punctuation 9
 
0.5%
Uppercase Letter 1
 
0.1%
Open Punctuation 1
 
0.1%
Close Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
136
12.6%
133
12.3%
82
 
7.6%
81
 
7.5%
81
 
7.5%
77
 
7.1%
77
 
7.1%
76
 
7.0%
49
 
4.5%
28
 
2.6%
Other values (66) 259
24.0%
Decimal Number
ValueCountFrequency (%)
1 57
24.4%
6 26
11.1%
2 26
11.1%
7 23
9.8%
3 22
 
9.4%
8 21
 
9.0%
4 17
 
7.3%
0 15
 
6.4%
9 15
 
6.4%
5 12
 
5.1%
Space Separator
ValueCountFrequency (%)
328
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%
Other Punctuation
ValueCountFrequency (%)
, 9
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1079
64.6%
Common 591
35.4%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
136
12.6%
133
12.3%
82
 
7.6%
81
 
7.5%
81
 
7.5%
77
 
7.1%
77
 
7.1%
76
 
7.0%
49
 
4.5%
28
 
2.6%
Other values (66) 259
24.0%
Common
ValueCountFrequency (%)
328
55.5%
1 57
 
9.6%
6 26
 
4.4%
2 26
 
4.4%
7 23
 
3.9%
3 22
 
3.7%
8 21
 
3.6%
- 18
 
3.0%
4 17
 
2.9%
0 15
 
2.5%
Other values (5) 38
 
6.4%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1078
64.5%
ASCII 592
35.4%
Compat Jamo 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
328
55.4%
1 57
 
9.6%
6 26
 
4.4%
2 26
 
4.4%
7 23
 
3.9%
3 22
 
3.7%
8 21
 
3.5%
- 18
 
3.0%
4 17
 
2.9%
0 15
 
2.5%
Other values (6) 39
 
6.6%
Hangul
ValueCountFrequency (%)
136
12.6%
133
12.3%
82
 
7.6%
81
 
7.5%
81
 
7.5%
77
 
7.1%
77
 
7.1%
76
 
7.1%
49
 
4.5%
28
 
2.6%
Other values (65) 258
23.9%
Compat Jamo
ValueCountFrequency (%)
1
100.0%

전화번호
Text

MISSING 

Distinct62
Distinct (%)100.0%
Missing15
Missing (%)19.5%
Memory size748.0 B
2024-01-10T07:11:45.708174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.951613
Min length9

Characters and Unicode

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

Unique62 ?
Unique (%)100.0%

Sample

1st row041-833-1530
2nd row041-836-5001
3rd row041-835-8881
4th row041-835-9139
5th row041-836-4520
ValueCountFrequency (%)
041-835-3680 1
 
1.6%
041-835-2726 1
 
1.6%
041-834-5824 1
 
1.6%
041-832-5131 1
 
1.6%
041-832-8599 1
 
1.6%
041-832-4188 1
 
1.6%
041-832-3636 1
 
1.6%
041-833-2694 1
 
1.6%
041-832-6101 1
 
1.6%
041-835-4728 1
 
1.6%
Other values (52) 52
83.9%
2024-01-10T07:11:46.008125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/