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 
한약업사
8 
의약품도매상
 
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/

Most occurring characters

ValueCountFrequency (%)
- 123
16.6%
0 103
13.9%
8 90
12.1%
3 90
12.1%
4 87
11.7%
1 87
11.7%
5 53
7.2%
2 41
 
5.5%
7 26
 
3.5%
6 25
 
3.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 618
83.4%
Dash Punctuation 123
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 103
16.7%
8 90
14.6%
3 90
14.6%
4 87
14.1%
1 87
14.1%
5 53
8.6%
2 41
 
6.6%
7 26
 
4.2%
6 25
 
4.0%
9 16
 
2.6%
Dash Punctuation
ValueCountFrequency (%)
- 123
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 741
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 123
16.6%
0 103
13.9%
8 90
12.1%
3 90
12.1%
4 87
11.7%
1 87
11.7%
5 53
7.2%
2 41
 
5.5%
7 26
 
3.5%
6 25
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 741
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 123
16.6%
0 103
13.9%
8 90
12.1%
3 90
12.1%
4 87
11.7%
1 87
11.7%
5 53
7.2%
2 41
 
5.5%
7 26
 
3.5%
6 25
 
3.4%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size748.0 B
2022-08-31
77 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-08-31
2nd row2022-08-31
3rd row2022-08-31
4th row2022-08-31
5th row2022-08-31

Common Values

ValueCountFrequency (%)
2022-08-31 77
100.0%

Length

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

Common Values (Plot)

2024-01-10T07:11:46.185369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-08-31 77
100.0%

Correlations

2024-01-10T07:11:46.233949image/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

2024-01-10T07:11:44.136384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:11:44.213329image/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약국부여규암약국충청남도 부여군 규암면 흥수로 878, 218동 1층 106호 (부여센트럴휴엔하임)041-833-15302022-08-31
1약국외산약국충청남도 부여군 외산면 외산로 87, 1층041-836-50012022-08-31
2약국다정약국충청남도 부여군 부여읍 부여로 14-7041-835-88812022-08-31
3약국홍산종로약국충청남도 부여군 홍산면 홍산로 52-1041-835-91392022-08-31
4약국홍산예약국충청남도 부여군 홍산면 홍산로 49041-836-45202022-08-31
5약국현대약국충청남도 부여군 홍산면 홍산로 54-3041-836-28822022-08-31
6약국솔약국충청남도 부여군 부여읍 사비로99번길 8-2041-835-16002022-08-31
7약국부여약국충청남도 부여군 부여읍 중앙로 3041-835-27002022-08-31
8약국조은약국충청남도 부여군 부여읍 신동엽길 6041-835-91672022-08-31
9약국은혜약국충청남도 부여군 부여읍 사비로 61041-835-11302022-08-31
구분판매업소명도로명주소전화번호데이터기준일자
67안전상비의약품판매업소씨유뉴부여로터리점충청남도 부여군 부여읍 석목로 6041-834-58422022-08-31
68안전상비의약품판매업소지에스(GS)25부여궁남지충청남도 부여군 부여읍 궁남로 37080-855-55252022-08-31
69안전상비의약품판매업소GS25 부여사랑점충청남도 부여군 부여읍 사비로72번길 18041-834-23972022-08-31
70안전상비의약품판매업소부여백제(공주)휴게소충청남도 부여군 내산면 서천공주고속도로 26041-833-54002022-08-31
71안전상비의약품판매업소부여백제(서천)휴게소충청남도 부여군 내산면 서천공주고속도로 25041-834-56002022-08-31
72안전상비의약품판매업소세븐일레븐부여양지점충청남도 부여군 부여읍 성왕로 236041-835-71742022-08-31
73안전상비의약품판매업소씨유부여반산점충청남도 부여군 규암면 흥수로 885041-836-92282022-08-31
74안전상비의약품판매업소씨유부여동남점충청남도 부여군 부여읍 계백로 300041-832-84022022-08-31
75안전상비의약품판매업소코리아세븐부여부소산점충청남도 부여군 부여읍 성왕로 243041-832-31552022-08-31
76안전상비의약품판매업소씨유부여홍산점충청남도 부여군 홍산면 홍산로 47041-836-22382022-08-31