Overview

Dataset statistics

Number of variables5
Number of observations80
Missing cells25
Missing cells (%)6.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.3 KiB
Average record size in memory41.6 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 25 (31.2%) missing valuesMissing
판매업소명 has unique valuesUnique
도로명주소 has unique valuesUnique

Reproduction

Analysis started2024-01-09 22:11:46.783633
Analysis finished2024-01-09 22:11:47.172347
Duration0.39 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

Distinct4
Distinct (%)5.0%
Missing0
Missing (%)0.0%
Memory size772.0 B
안전상비의약품판매업소
36 
약국
34 
한약업사
8 
의약품도매상
 
2

Length

Max length11
Median length6
Mean length6.35
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
안전상비의약품판매업소 36
45.0%
약국 34
42.5%
한약업사 8
 
10.0%
의약품도매상 2
 
2.5%

Length

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

Common Values (Plot)

2024-01-10T07:11:47.337682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
안전상비의약품판매업소 36
45.0%
약국 34
42.5%
한약업사 8
 
10.0%
의약품도매상 2
 
2.5%

판매업소명
Text

UNIQUE 

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

Length

Max length17
Median length15
Mean length7.225
Min length3

Characters and Unicode

Total characters578
Distinct characters124
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

Unique80 ?
Unique (%)100.0%

Sample

1st row부여규암약국
2nd row외산약국
3rd row다정약국
4th row홍산종로약국
5th row홍산예약국
ValueCountFrequency (%)
씨유 5
 
5.3%
지에스(gs)25 3
 
3.2%
세븐일레븐 3
 
3.2%
gs25 2
 
2.1%
부여규암약국 1
 
1.1%
지에스25(gs25)부여쌍북점 1
 
1.1%
구룡점 1
 
1.1%
부여 1
 
1.1%
씨유부여외산점 1
 
1.1%
부여타운점 1
 
1.1%
Other values (76) 76
80.0%
2024-01-10T07:11:47.805842image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 44
 
7.6%
부 40
 
6.9%
여 37
 
6.4%
국 34
 
5.9%
점 33
 
5.7%
유 19
 
3.3%
씨 18
 
3.1%
15
 
2.6%
2 13
 
2.2%
산 12
 
2.1%
Other values (114) 313
54.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 494
85.5%
Decimal Number 26
 
4.5%
Uppercase Letter 21
 
3.6%
Space Separator 15
 
2.6%
Close Punctuation 11
 
1.9%
Open Punctuation 11
 
1.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 44
 
8.9%
부 40
 
8.1%
여 37
 
7.5%
국 34
 
6.9%
점 33
 
6.7%
유 19
 
3.8%
씨 18
 
3.6%
산 12
 
2.4%
지 11
 
2.2%
븐 10
 
2.0%
Other values (103) 236
47.8%
Uppercase Letter
ValueCountFrequency (%)
G 9
42.9%
S 9
42.9%
U 1
 
4.8%
R 1
 
4.8%
C 1
 
4.8%
Decimal Number
ValueCountFrequency (%)
2 13
50.0%
5 12
46.2%
4 1
 
3.8%
Space Separator
ValueCountFrequency (%)
15
100.0%
Close Punctuation
ValueCountFrequency (%)
) 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 494
85.5%
Common 63
 
10.9%
Latin 21
 
3.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 44
 
8.9%
부 40
 
8.1%
여 37
 
7.5%
국 34
 
6.9%
점 33
 
6.7%
유 19
 
3.8%
씨 18
 
3.6%
산 12
 
2.4%
지 11
 
2.2%
븐 10
 
2.0%
Other values (103) 236
47.8%
Common
ValueCountFrequency (%)
15
23.8%
2 13
20.6%
5 12
19.0%
) 11
17.5%
( 11
17.5%
4 1
 
1.6%
Latin
ValueCountFrequency (%)
G 9
42.9%
S 9
42.9%
U 1
 
4.8%
R 1
 
4.8%
C 1
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 494
85.5%
ASCII 84
 
14.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 44
 
8.9%
부 40
 
8.1%
여 37
 
7.5%
국 34
 
6.9%
점 33
 
6.7%
유 19
 
3.8%
씨 18
 
3.6%
산 12
 
2.4%
지 11
 
2.2%
븐 10
 
2.0%
Other values (103) 236
47.8%
ASCII
ValueCountFrequency (%)
15
17.9%
2 13
15.5%
5 12
14.3%
) 11
13.1%
( 11
13.1%
G 9
10.7%
S 9
10.7%
U 1
 
1.2%
R 1
 
1.2%
4 1
 
1.2%

도로명주소
Text

UNIQUE 

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

Length

Max length46
Median length40
Mean length21.825
Min length18

Characters and Unicode

Total characters1746
Distinct characters93
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

Unique80 ?
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 (%)
충청남도 80
19.1%
부여군 80
19.1%
부여읍 50
 
11.9%
성왕로 11
 
2.6%
규암면 7
 
1.7%
1층 6
 
1.4%
홍산면 6
 
1.4%
은산면 5
 
1.2%
중앙로 5
 
1.2%
홍산로 5
 
1.2%
Other values (118) 164
39.1%
2024-01-10T07:11:48.399733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
341
19.5%
부 141
 
8.1%
여 138
 
7.9%
충 85
 
4.9%
남 84
 
4.8%
도 84
 
4.8%
군 80
 
4.6%
청 80
 
4.6%
로 79
 
4.5%
1 60
 
3.4%
Other values (83) 574
32.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1128
64.6%
Space Separator 341
 
19.5%
Decimal Number 245
 
14.0%
Dash Punctuation 17
 
1.0%
Other Punctuation 11
 
0.6%
Close Punctuation 2
 
0.1%
Open Punctuation 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
부 141
12.5%
여 138
12.2%
충 85
 
7.5%
남 84
 
7.4%
도 84
 
7.4%
군 80
 
7.1%
청 80
 
7.1%
로 79
 
7.0%
읍 50
 
4.4%
면 30
 
2.7%
Other values (68) 277
24.6%
Decimal Number
ValueCountFrequency (%)
1 60
24.5%
2 28
11.4%
6 26
10.6%
7 24
 
9.8%
3 22
 
9.0%
8 21
 
8.6%
9 18
 
7.3%
4 17
 
6.9%
0 16
 
6.5%
5 13
 
5.3%
Space Separator
ValueCountFrequency (%)
341
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%
Other Punctuation
ValueCountFrequency (%)
, 11
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1128
64.6%
Common 618
35.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
부 141
12.5%
여 138
12.2%
충 85
 
7.5%
남 84
 
7.4%
도 84
 
7.4%
군 80
 
7.1%
청 80
 
7.1%
로 79
 
7.0%
읍 50
 
4.4%
면 30
 
2.7%
Other values (68) 277
24.6%
Common
ValueCountFrequency (%)
341
55.2%
1 60
 
9.7%
2 28
 
4.5%
6 26
 
4.2%
7 24
 
3.9%
3 22
 
3.6%
8 21
 
3.4%
9 18
 
2.9%
4 17
 
2.8%
- 17
 
2.8%
Other values (5) 44
 
7.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1128
64.6%
ASCII 618
35.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
341
55.2%
1 60
 
9.7%
2 28
 
4.5%
6 26
 
4.2%
7 24
 
3.9%
3 22
 
3.6%
8 21
 
3.4%
9 18
 
2.9%
4 17
 
2.8%
- 17
 
2.8%
Other values (5) 44
 
7.1%
Hangul
ValueCountFrequency (%)
부 141
12.5%
여 138
12.2%
충 85
 
7.5%
남 84
 
7.4%
도 84
 
7.4%
군 80
 
7.1%
청 80
 
7.1%
로 79
 
7.0%
읍 50
 
4.4%
면 30
 
2.7%
Other values (68) 277
24.6%

전화번호
Text

MISSING 

Distinct54
Distinct (%)98.2%
Missing25
Missing (%)31.2%
Memory size772.0 B
2024-01-10T07:11:48.614858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique53 ?
Unique (%)96.4%

Sample

1st row041-833-1530
2nd row041-836-5001
3rd row041-835-8881
4th row041-835-9139
5th row041-836-4520
ValueCountFrequency (%)
041-834-5600 2
 
3.6%
041-833-2694 1
 
1.8%
041-832-3155 1
 
1.8%
041-833-1530 1
 
1.8%
041-835-4728 1
 
1.8%
041-833-2045 1
 
1.8%
041-835-2308 1
 
1.8%
041-835-3115 1
 
1.8%
041-835-2726 1
 
1.8%
041-837-6004 1
 
1.8%
Other values (44) 44
80.0%
2024-01-10T07:11:48.900238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 110
16.7%
0 93
14.1%
3 82
12.4%
1 79
12.0%
8 79
12.0%
4 78
11.8%
5 43
 
6.5%
2 34
 
5.2%
6 25
 
3.8%
7 24
 
3.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 550
83.3%
Dash Punctuation 110
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 93
16.9%
3 82
14.9%
1 79
14.4%
8 79
14.4%
4 78
14.2%
5 43
7.8%
2 34
 
6.2%
6 25
 
4.5%
7 24
 
4.4%
9 13
 
2.4%
Dash Punctuation
ValueCountFrequency (%)
- 110
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 660
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 110
16.7%
0 93
14.1%
3 82
12.4%
1 79
12.0%
8 79
12.0%
4 78
11.8%
5 43
 
6.5%
2 34
 
5.2%
6 25
 
3.8%
7 24
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 660
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 110
16.7%
0 93
14.1%
3 82
12.4%
1 79
12.0%
8 79
12.0%
4 78
11.8%
5 43
 
6.5%
2 34
 
5.2%
6 25
 
3.8%
7 24
 
3.6%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size772.0 B
2023-10-31
80 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-10-31
2nd row2023-10-31
3rd row2023-10-31
4th row2023-10-31
5th row2023-10-31

Common Values

ValueCountFrequency (%)
2023-10-31 80
100.0%

Length

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

Common Values (Plot)

2024-01-10T07:11:49.080292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-10-31 80
100.0%

Correlations

2024-01-10T07:11:49.126020image/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:47.039136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:11:47.134776image/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-15302023-10-31
1약국외산약국충청남도 부여군 외산면 외산로 87, 1층041-836-50012023-10-31
2약국다정약국충청남도 부여군 부여읍 부여로 14-7041-835-88812023-10-31
3약국홍산종로약국충청남도 부여군 홍산면 홍산로 52-1041-835-91392023-10-31
4약국홍산예약국충청남도 부여군 홍산면 홍산로 49041-836-45202023-10-31
5약국현대약국충청남도 부여군 홍산면 홍산로 54-3041-836-28822023-10-31
6약국나을약국충청남도 부여군 홍산면 홍산로 55, 1층041-834-49552023-10-31
7약국솔약국충청남도 부여군 부여읍 사비로99번길 8-2041-835-16002023-10-31
8약국부여약국충청남도 부여군 부여읍 중앙로 3041-835-27002023-10-31
9약국조은약국충청남도 부여군 부여읍 신동엽길 6041-835-91672023-10-31
구분판매업소명도로명주소전화번호데이터기준일자
70안전상비의약품판매업소씨유뉴부여로터리점충청남도 부여군 부여읍 석목로 6<NA>2023-10-31
71안전상비의약품판매업소지에스(GS)25부여궁남지충청남도 부여군 부여읍 궁남로 37<NA>2023-10-31
72안전상비의약품판매업소GS25 부여사랑점충청남도 부여군 부여읍 사비로72번길 18041-834-23972023-10-31
73안전상비의약품판매업소부여백제(공주)휴게소충청남도 부여군 내산면 서천공주고속도로 26041-834-56002023-10-31
74안전상비의약품판매업소부여백제(서천)휴게소충청남도 부여군 내산면 서천공주고속도로 25041-834-56002023-10-31
75안전상비의약품판매업소세븐일레븐부여양지점충청남도 부여군 부여읍 성왕로 236041-835-71742023-10-31
76안전상비의약품판매업소씨유부여반산점충청남도 부여군 규암면 흥수로 885041-836-92282023-10-31
77안전상비의약품판매업소씨유부여동남점충청남도 부여군 부여읍 계백로 300<NA>2023-10-31
78안전상비의약품판매업소코리아세븐부여부소산점충청남도 부여군 부여읍 성왕로 243041-832-31552023-10-31
79안전상비의약품판매업소씨유부여홍산점충청남도 부여군 홍산면 홍산로 47041-836-22382023-10-31