Overview

Dataset statistics

Number of variables5
Number of observations70
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.9 KiB
Average record size in memory41.9 B

Variable types

Categorical1
Text3
DateTime1

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 unique valuesUnique
도로명주소 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2024-01-09 22:11:41.024987
Analysis finished2024-01-09 22:11:41.374859
Duration0.35 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

Distinct6
Distinct (%)8.6%
Missing0
Missing (%)0.0%
Memory size692.0 B
약국
35 
안전상비의약품판매업소
17 
한약업사
11 
의약품도매상
 
3
약업사
 
3

Length

Max length11
Median length8.5
Mean length4.7285714
Min length2

Unique

Unique1 ?
Unique (%)1.4%

Sample

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

Common Values

ValueCountFrequency (%)
약국 35
50.0%
안전상비의약품판매업소 17
24.3%
한약업사 11
 
15.7%
의약품도매상 3
 
4.3%
약업사 3
 
4.3%
한약국 1
 
1.4%

Length

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

Common Values (Plot)

2024-01-10T07:11:41.527174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 35
50.0%
안전상비의약품판매업소 17
24.3%
한약업사 11
 
15.7%
의약품도매상 3
 
4.3%
약업사 3
 
4.3%
한약국 1
 
1.4%

판매업소명
Text

UNIQUE 

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

Length

Max length14
Median length11
Mean length5.7571429
Min length3

Characters and Unicode

Total characters403
Distinct characters115
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

Unique70 ?
Unique (%)100.0%

Sample

1st row행복약국
2nd row홍산예약국
3rd row은혜약국
4th row홍산종로약국
5th row솔약국
ValueCountFrequency (%)
행복약국 1
 
1.4%
우리들약국 1
 
1.4%
광제한약방 1
 
1.4%
세창한약방 1
 
1.4%
대성당한약방 1
 
1.4%
동광한약방 1
 
1.4%
대생당한약방 1
 
1.4%
동산한약방 1
 
1.4%
장춘당한약방 1
 
1.4%
씨유부여로터리점 1
 
1.4%
Other values (62) 62
86.1%
2024-01-10T07:11:42.070531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 52
 
12.9%
국 36
 
8.9%
부 23
 
5.7%
여 20
 
5.0%
방 14
 
3.5%
점 14
 
3.5%
한 13
 
3.2%
산 9
 
2.2%
유 8
 
2.0%
씨 7
 
1.7%
Other values (105) 207
51.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 381
94.5%
Decimal Number 6
 
1.5%
Uppercase Letter 6
 
1.5%
Close Punctuation 4
 
1.0%
Open Punctuation 4
 
1.0%
Space Separator 2
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 52
 
13.6%
국 36
 
9.4%
부 23
 
6.0%
여 20
 
5.2%
방 14
 
3.7%
점 14
 
3.7%
한 13
 
3.4%
산 9
 
2.4%
유 8
 
2.1%
씨 7
 
1.8%
Other values (98) 185
48.6%
Decimal Number
ValueCountFrequency (%)
2 3
50.0%
5 3
50.0%
Uppercase Letter
ValueCountFrequency (%)
G 3
50.0%
S 3
50.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 381
94.5%
Common 16
 
4.0%
Latin 6
 
1.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 52
 
13.6%
국 36
 
9.4%
부 23
 
6.0%
여 20
 
5.2%
방 14
 
3.7%
점 14
 
3.7%
한 13
 
3.4%
산 9
 
2.4%
유 8
 
2.1%
씨 7
 
1.8%
Other values (98) 185
48.6%
Common
ValueCountFrequency (%)
) 4
25.0%
( 4
25.0%
2 3
18.8%
5 3
18.8%
2
12.5%
Latin
ValueCountFrequency (%)
G 3
50.0%
S 3
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 381
94.5%
ASCII 22
 
5.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 52
 
13.6%
국 36
 
9.4%
부 23
 
6.0%
여 20
 
5.2%
방 14
 
3.7%
점 14
 
3.7%
한 13
 
3.4%
산 9
 
2.4%
유 8
 
2.1%
씨 7
 
1.8%
Other values (98) 185
48.6%
ASCII
ValueCountFrequency (%)
) 4
18.2%
( 4
18.2%
2 3
13.6%
G 3
13.6%
S 3
13.6%
5 3
13.6%
2
9.1%

도로명주소
Text

UNIQUE 

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

Length

Max length45
Median length27
Mean length21.628571
Min length19

Characters and Unicode

Total characters1514
Distinct characters79
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

Unique70 ?
Unique (%)100.0%

Sample

1st row충청남도 부여군 임천면 성흥로 91-1
2nd row충청남도 부여군 홍산면 홍산로 49
3rd row충청남도 부여군 부여읍 사비로 61
4th row충청남도 부여군 홍산면 홍산로 52-1
5th row충청남도 부여군 부여읍 사비로99번길 8-2
ValueCountFrequency (%)
충청남도 70
19.9%
부여군 70
19.9%
부여읍 43
 
12.3%
성왕로 8
 
2.3%
부여로 7
 
2.0%
홍산면 6
 
1.7%
사비로 6
 
1.7%
중앙로 5
 
1.4%
홍산로 4
 
1.1%
은산면 4
 
1.1%
Other values (99) 128
36.5%
2024-01-10T07:11:42.624047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
346
22.9%
부 122
 
8.1%
여 120
 
7.9%
충 75
 
5.0%
남 74
 
4.9%
도 74
 
4.9%
군 70
 
4.6%
청 70
 
4.6%
로 68
 
4.5%
읍 43
 
2.8%
Other values (69) 452
29.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 953
62.9%
Space Separator 346
 
22.9%
Decimal Number 194
 
12.8%
Dash Punctuation 18
 
1.2%
Close Punctuation 1
 
0.1%
Other Punctuation 1
 
0.1%
Open Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
부 122
12.8%
여 120
12.6%
충 75
 
7.9%
남 74
 
7.8%
도 74
 
7.8%
군 70
 
7.3%
청 70
 
7.3%
로 68
 
7.1%
읍 43
 
4.5%
면 27
 
2.8%
Other values (54) 210
22.0%
Decimal Number
ValueCountFrequency (%)
1 39
20.1%
6 24
12.4%
2 23
11.9%
8 18
9.3%
3 17
8.8%
7 16
8.2%
9 16
8.2%
0 15
 
7.7%
5 14
 
7.2%
4 12
 
6.2%
Space Separator
ValueCountFrequency (%)
346
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 953
62.9%
Common 561
37.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
부 122
12.8%
여 120
12.6%
충 75
 
7.9%
남 74
 
7.8%
도 74
 
7.8%
군 70
 
7.3%
청 70
 
7.3%
로 68
 
7.1%
읍 43
 
4.5%
면 27
 
2.8%
Other values (54) 210
22.0%
Common
ValueCountFrequency (%)
346
61.7%
1 39
 
7.0%
6 24
 
4.3%
2 23
 
4.1%
- 18
 
3.2%
8 18
 
3.2%
3 17
 
3.0%
7 16
 
2.9%
9 16
 
2.9%
0 15
 
2.7%
Other values (5) 29
 
5.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 953
62.9%
ASCII 561
37.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
346
61.7%
1 39
 
7.0%
6 24
 
4.3%
2 23
 
4.1%
- 18
 
3.2%
8 18
 
3.2%
3 17
 
3.0%
7 16
 
2.9%
9 16
 
2.9%
0 15
 
2.7%
Other values (5) 29
 
5.2%
Hangul
ValueCountFrequency (%)
부 122
12.8%
여 120
12.6%
충 75
 
7.9%
남 74
 
7.8%
도 74
 
7.8%
군 70
 
7.3%
청 70
 
7.3%
로 68
 
7.1%
읍 43
 
4.5%
면 27
 
2.8%
Other values (54) 210
22.0%

전화번호
Text

UNIQUE 

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

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique70 ?
Unique (%)100.0%

Sample

1st row041-832-1363
2nd row041-836-4520
3rd row041-835-1130
4th row041-835-9139
5th row041-835-1600
ValueCountFrequency (%)
041-832-1363 1
 
1.4%
041-836-3777 1
 
1.4%
041-833-0135 1
 
1.4%
041-835-4728 1
 
1.4%
041-832-6101 1
 
1.4%
041-832-3636 1
 
1.4%
041-833-2694 1
 
1.4%
041-834-5842 1
 
1.4%
041-832-3010 1
 
1.4%
041-835-5116 1
 
1.4%
Other values (60) 60
85.7%
2024-01-10T07:11:43.137726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 140
16.7%
0 115
13.7%
3 106
12.6%
1 102
12.1%
8 99
11.8%
4 96
11.4%
5 52
 
6.2%
2 49
 
5.8%
7 33
 
3.9%
6 29
 
3.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 700
83.3%
Dash Punctuation 140
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 115
16.4%
3 106
15.1%
1 102
14.6%
8 99
14.1%
4 96
13.7%
5 52
7.4%
2 49
7.0%
7 33
 
4.7%
6 29
 
4.1%
9 19
 
2.7%
Dash Punctuation
ValueCountFrequency (%)
- 140
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 840
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 140
16.7%
0 115
13.7%
3 106
12.6%
1 102
12.1%
8 99
11.8%
4 96
11.4%
5 52
 
6.2%
2 49
 
5.8%
7 33
 
3.9%
6 29
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 840
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 140
16.7%
0 115
13.7%
3 106
12.6%
1 102
12.1%
8 99
11.8%
4 96
11.4%
5 52
 
6.2%
2 49
 
5.8%
7 33
 
3.9%
6 29
 
3.5%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size692.0 B
Minimum2021-09-24 00:00:00
Maximum2021-09-24 00:00:00
2024-01-10T07:11:43.230984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:11:43.302570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2024-01-10T07:11:43.355804image/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:41.268533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:11:41.345689image/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약국행복약국충청남도 부여군 임천면 성흥로 91-1041-832-13632021-09-24
1약국홍산예약국충청남도 부여군 홍산면 홍산로 49041-836-45202021-09-24
2약국은혜약국충청남도 부여군 부여읍 사비로 61041-835-11302021-09-24
3약국홍산종로약국충청남도 부여군 홍산면 홍산로 52-1041-835-91392021-09-24
4약국솔약국충청남도 부여군 부여읍 사비로99번길 8-2041-835-16002021-09-24
5약국석초약국충청남도 부여군 석성면 왕릉로 714041-835-00752021-09-24
6약국한샘약국충청남도 부여군 홍산면 홍산로 54-3041-836-28822021-09-24
7약국부여종로약국충청남도 부여군 부여읍 사비로 94041-833-22182021-09-24
8약국우리들약국충청남도 부여군 부여읍 중앙로 9041-837-27802021-09-24
9약국고려약국충청남도 부여군 부여읍 성왕로 183041-835-66702021-09-24
구분판매업소명도로명주소전화번호데이터기준일자
60안전상비의약품판매업소씨유부여중앙점충청남도 부여군 부여읍 중앙로 8041-835-89952021-09-24
61안전상비의약품판매업소바이더웨이충남부여점충청남도 부여군 부여읍 사비로100번길 4041-832-18202021-09-24
62안전상비의약품판매업소세븐일레븐부여양지점충청남도 부여군 부여읍 성왕로 236041-835-71742021-09-24
63안전상비의약품판매업소씨유부여반산점충청남도 부여군 규암면 흥수로 885041-836-92282021-09-24
64안전상비의약품판매업소씨유부여동남점충청남도 부여군 부여읍 계백로 300041-832-84022021-09-24
65안전상비의약품판매업소코리아세븐부여부소산점충청남도 부여군 부여읍 성왕로 243041-832-31552021-09-24
66안전상비의약품판매업소GS25부여터미널점충청남도 부여군 부여읍 부여로 5-8041-837-36392021-09-24
67안전상비의약품판매업소코리아세븐부여홍선점충청남도 부여군 부여읍 성왕로328번길 18-7 (홍선아파트상가105,106호)041-834-77992021-09-24
68안전상비의약품판매업소씨유부여홍산점충청남도 부여군 홍산면 홍산로 47041-836-22382021-09-24
69안전상비의약품판매업소세븐일레븐부여제일점충청남도 부여군 부여읍 중앙로5번길 26041-835-28732021-09-24