Overview

Dataset statistics

Number of variables6
Number of observations29
Missing cells4
Missing cells (%)2.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.5 KiB
Average record size in memory53.6 B

Variable types

Numeric1
Categorical2
Text3

Dataset

Description충청남도 청양군의 관내 약국 현황에 대한 데이터로 업소명칭, 사업장소재지, 전화번호 등에 관한 정보를 나타냅니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=430&beforeMenuCd=DOM_000000201001001000&publicdatapk=3076209

Alerts

데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 종별High correlation
종별 is highly overall correlated with 연번High correlation
전화번호 has 4 (13.8%) missing valuesMissing
연번 has unique valuesUnique
업소명칭 has unique valuesUnique

Reproduction

Analysis started2024-01-09 20:24:19.681374
Analysis finished2024-01-09 20:24:20.151087
Duration0.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct29
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15
Minimum1
Maximum29
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size393.0 B
2024-01-10T05:24:20.206526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.4
Q18
median15
Q322
95-th percentile27.6
Maximum29
Range28
Interquartile range (IQR)14

Descriptive statistics

Standard deviation8.5146932
Coefficient of variation (CV)0.56764621
Kurtosis-1.2
Mean15
Median Absolute Deviation (MAD)7
Skewness0
Sum435
Variance72.5
MonotonicityStrictly increasing
2024-01-10T05:24:20.320460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
1 1
 
3.4%
2 1
 
3.4%
29 1
 
3.4%
28 1
 
3.4%
27 1
 
3.4%
26 1
 
3.4%
25 1
 
3.4%
24 1
 
3.4%
23 1
 
3.4%
22 1
 
3.4%
Other values (19) 19
65.5%
ValueCountFrequency (%)
1 1
3.4%
2 1
3.4%
3 1
3.4%
4 1
3.4%
5 1
3.4%
6 1
3.4%
7 1
3.4%
8 1
3.4%
9 1
3.4%
10 1
3.4%
ValueCountFrequency (%)
29 1
3.4%
28 1
3.4%
27 1
3.4%
26 1
3.4%
25 1
3.4%
24 1
3.4%
23 1
3.4%
22 1
3.4%
21 1
3.4%
20 1
3.4%

종별
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)13.8%
Missing0
Missing (%)0.0%
Memory size364.0 B
약국
13 
안전상비의약품판매업
10 
한약업사
4 
특수장소
2 

Length

Max length10
Median length4
Mean length5.1724138
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
약국 13
44.8%
안전상비의약품판매업 10
34.5%
한약업사 4
 
13.8%
특수장소 2
 
6.9%

Length

2024-01-10T05:24:20.448032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:24:20.555246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 13
44.8%
안전상비의약품판매업 10
34.5%
한약업사 4
 
13.8%
특수장소 2
 
6.9%

업소명칭
Text

UNIQUE 

Distinct29
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size364.0 B
2024-01-10T05:24:20.724997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length10
Mean length6.2413793
Min length4

Characters and Unicode

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

Unique

Unique29 ?
Unique (%)100.0%

Sample

1st row해남약국
2nd row우리약국
3rd row낙원약국
4th row종로온누리약국
5th row푸른약국
ValueCountFrequency (%)
gs25 2
 
6.1%
해남약국 1
 
3.0%
우리약국 1
 
3.0%
청양점 1
 
3.0%
씨유 1
 
3.0%
청양타운점 1
 
3.0%
청양의료원점 1
 
3.0%
청양초사랑점 1
 
3.0%
cu 1
 
3.0%
씨유청양읍내점 1
 
3.0%
Other values (22) 22
66.7%
2024-01-10T05:24:21.071218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 19
 
10.5%
국 15
 
8.3%
점 10
 
5.5%
양 9
 
5.0%
청 9
 
5.0%
한 5
 
2.8%
방 4
 
2.2%
정 4
 
2.2%
4
 
2.2%
유 4
 
2.2%
Other values (67) 98
54.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 161
89.0%
Uppercase Letter 10
 
5.5%
Decimal Number 6
 
3.3%
Space Separator 4
 
2.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 19
 
11.8%
국 15
 
9.3%
점 10
 
6.2%
양 9
 
5.6%
청 9
 
5.6%
한 5
 
3.1%
방 4
 
2.5%
정 4
 
2.5%
유 4
 
2.5%
씨 4
 
2.5%
Other values (60) 78
48.4%
Uppercase Letter
ValueCountFrequency (%)
S 3
30.0%
G 3
30.0%
C 2
20.0%
U 2
20.0%
Decimal Number
ValueCountFrequency (%)
5 3
50.0%
2 3
50.0%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 161
89.0%
Common 10
 
5.5%
Latin 10
 
5.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 19
 
11.8%
국 15
 
9.3%
점 10
 
6.2%
양 9
 
5.6%
청 9
 
5.6%
한 5
 
3.1%
방 4
 
2.5%
정 4
 
2.5%
유 4
 
2.5%
씨 4
 
2.5%
Other values (60) 78
48.4%
Latin
ValueCountFrequency (%)
S 3
30.0%
G 3
30.0%
C 2
20.0%
U 2
20.0%
Common
ValueCountFrequency (%)
4
40.0%
5 3
30.0%
2 3
30.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 161
89.0%
ASCII 20
 
11.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 19
 
11.8%
국 15
 
9.3%
점 10
 
6.2%
양 9
 
5.6%
청 9
 
5.6%
한 5
 
3.1%
방 4
 
2.5%
정 4
 
2.5%
유 4
 
2.5%
씨 4
 
2.5%
Other values (60) 78
48.4%
ASCII
ValueCountFrequency (%)
4
20.0%
5 3
15.0%
S 3
15.0%
G 3
15.0%
2 3
15.0%
C 2
10.0%
U 2
10.0%

사업장소재지(도로명)
Text

Distinct28
Distinct (%)96.6%
Missing0
Missing (%)0.0%
Memory size364.0 B
2024-01-10T05:24:21.248614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length30
Mean length21.931034
Min length19

Characters and Unicode

Total characters636
Distinct characters57
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

Unique27 ?
Unique (%)93.1%

Sample

1st row충청남도 청양군 정산면 정현길 43
2nd row충청남도 청양군 청양읍 중앙로 133
3rd row충청남도 청양군 청양읍 중앙로 126
4th row충청남도 청양군 청양읍 중앙로 130-1
5th row충청남도 청양군 청양읍 중앙로 178
ValueCountFrequency (%)
충청남도 29
19.2%
청양군 29
19.2%
청양읍 20
13.2%
중앙로 11
 
7.3%
정산면 5
 
3.3%
효자길 3
 
2.0%
칠갑산로 3
 
2.0%
칠갑산로7길 2
 
1.3%
남양면 2
 
1.3%
1층 2
 
1.3%
Other values (42) 45
29.8%
2024-01-10T05:24:21.540932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
122
19.2%
청 80
12.6%
양 53
 
8.3%
남 33
 
5.2%
충 29
 
4.6%
도 29
 
4.6%
군 29
 
4.6%
1 27
 
4.2%
로 24
 
3.8%
읍 20
 
3.1%
Other values (47) 190
29.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 411
64.6%
Space Separator 122
 
19.2%
Decimal Number 88
 
13.8%
Dash Punctuation 6
 
0.9%
Close Punctuation 3
 
0.5%
Other Punctuation 3
 
0.5%
Open Punctuation 3
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 80
19.5%
양 53
12.9%
남 33
 
8.0%
충 29
 
7.1%
도 29
 
7.1%
군 29
 
7.1%
로 24
 
5.8%
읍 20
 
4.9%
중 13
 
3.2%
앙 13
 
3.2%
Other values (32) 88
21.4%
Decimal Number
ValueCountFrequency (%)
1 27
30.7%
2 12
13.6%
4 9
 
10.2%
3 9
 
10.2%
6 6
 
6.8%
7 6
 
6.8%
8 6
 
6.8%
0 6
 
6.8%
5 5
 
5.7%
9 2
 
2.3%
Space Separator
ValueCountFrequency (%)
122
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Other Punctuation
ValueCountFrequency (%)
, 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 411
64.6%
Common 225
35.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 80
19.5%
양 53
12.9%
남 33
 
8.0%
충 29
 
7.1%
도 29
 
7.1%
군 29
 
7.1%
로 24
 
5.8%
읍 20
 
4.9%
중 13
 
3.2%
앙 13
 
3.2%
Other values (32) 88
21.4%
Common
ValueCountFrequency (%)
122
54.2%
1 27
 
12.0%
2 12
 
5.3%
4 9
 
4.0%
3 9
 
4.0%
6 6
 
2.7%
- 6
 
2.7%
7 6
 
2.7%
8 6
 
2.7%
0 6
 
2.7%
Other values (5) 16
 
7.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 411
64.6%
ASCII 225
35.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
122
54.2%
1 27
 
12.0%
2 12
 
5.3%
4 9
 
4.0%
3 9
 
4.0%
6 6
 
2.7%
- 6
 
2.7%
7 6
 
2.7%
8 6
 
2.7%
0 6
 
2.7%
Other values (5) 16
 
7.1%
Hangul
ValueCountFrequency (%)
청 80
19.5%
양 53
12.9%
남 33
 
8.0%
충 29
 
7.1%
도 29
 
7.1%
군 29
 
7.1%
로 24
 
5.8%
읍 20
 
4.9%
중 13
 
3.2%
앙 13
 
3.2%
Other values (32) 88
21.4%

전화번호
Text

MISSING 

Distinct25
Distinct (%)100.0%
Missing4
Missing (%)13.8%
Memory size364.0 B
2024-01-10T05:24:21.705695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique25 ?
Unique (%)100.0%

Sample

1st row041-942-0025
2nd row041-943-3766
3rd row041-942-2635
4th row041-943-5410
5th row041-944-0346
ValueCountFrequency (%)
041-942-0025 1
 
4.0%
041-942-6077 1
 
4.0%
041-943-3766 1
 
4.0%
041-943-2558 1
 
4.0%
041-942-5949 1
 
4.0%
070-776-8736 1
 
4.0%
041-942-9421 1
 
4.0%
041-944-0927 1
 
4.0%
041-942-4007 1
 
4.0%
041-943-2383 1
 
4.0%
Other values (15) 15
60.0%
2024-01-10T05:24:22.240789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 58
19.3%
- 50
16.7%
0 41
13.7%
9 32
10.7%
1 27
9.0%
2 27
9.0%
3 20
 
6.7%
7 17
 
5.7%
5 12
 
4.0%
8 9
 
3.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 250
83.3%
Dash Punctuation 50
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 58
23.2%
0 41
16.4%
9 32
12.8%
1 27
10.8%
2 27
10.8%
3 20
 
8.0%
7 17
 
6.8%
5 12
 
4.8%
8 9
 
3.6%
6 7
 
2.8%
Dash Punctuation
ValueCountFrequency (%)
- 50
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 300
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 58
19.3%
- 50
16.7%
0 41
13.7%
9 32
10.7%
1 27
9.0%
2 27
9.0%
3 20
 
6.7%
7 17
 
5.7%
5 12
 
4.0%
8 9
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 300
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 58
19.3%
- 50
16.7%
0 41
13.7%
9 32
10.7%
1 27
9.0%
2 27
9.0%
3 20
 
6.7%
7 17
 
5.7%
5 12
 
4.0%
8 9
 
3.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Memory size364.0 B
2023-02-01
29 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-02-01
2nd row2023-02-01
3rd row2023-02-01
4th row2023-02-01
5th row2023-02-01

Common Values

ValueCountFrequency (%)
2023-02-01 29
100.0%

Length

2024-01-10T05:24:22.358606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:24:22.439113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-02-01 29
100.0%

Interactions

2024-01-10T05:24:19.871040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T05:24:22.487052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번종별업소명칭사업장소재지(도로명)전화번호
연번1.0000.8591.0000.8841.000
종별0.8591.0001.0000.9521.000
업소명칭1.0001.0001.0001.0001.000
사업장소재지(도로명)0.8840.9521.0001.0001.000
전화번호1.0001.0001.0001.0001.000
2024-01-10T05:24:22.577958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번종별
연번1.0000.728
종별0.7281.000

Missing values

2024-01-10T05:24:19.984068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:24:20.102978image/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

연번종별업소명칭사업장소재지(도로명)전화번호데이터기준일자
01약국해남약국충청남도 청양군 정산면 정현길 43041-942-00252023-02-01
12약국우리약국충청남도 청양군 청양읍 중앙로 133041-943-37662023-02-01
23약국낙원약국충청남도 청양군 청양읍 중앙로 126041-942-26352023-02-01
34약국종로온누리약국충청남도 청양군 청양읍 중앙로 130-1041-943-54102023-02-01
45약국푸른약국충청남도 청양군 청양읍 중앙로 178041-944-03462023-02-01
56약국명인약국충청남도 청양군 청양읍 중앙로3길 2041-943-88242023-02-01
67약국중앙약국충청남도 청양군 청양읍 중앙로 124041-943-94752023-02-01
78약국장수약국충청남도 청양군 정산면 정현길 57041-943-29902023-02-01
89약국정성약국충청남도 청양군 청양읍 칠갑산로7길 51041-942-75822023-02-01
910약국신세계약국충청남도 청양군 청양읍 중앙로 84, 1층041-943-82452023-02-01
연번종별업소명칭사업장소재지(도로명)전화번호데이터기준일자
1920안전상비의약품판매업씨유청양무지개점충청남도 청양군 청양읍 칠갑산로3길 14, 1층<NA>2023-02-01
2021안전상비의약품판매업미니스톱청양고추점충청남도 청양군 청양읍 중앙로 68<NA>2023-02-01
2122안전상비의약품판매업CU정산중앙점충청남도 청양군 정산면 효자길 10<NA>2023-02-01
2223안전상비의약품판매업씨유청양주공점충청남도 청양군 청양읍 칠갑산로4길 37041-944-09272023-02-01
2324안전상비의약품판매업씨유청양읍내점충청남도 청양군 청양읍 중앙로 122-1<NA>2023-02-01
2425안전상비의약품판매업CU 청양초사랑점충청남도 청양군 청양읍 중앙로12길 16, 명랑슈퍼041-942-94212023-02-01
2526안전상비의약품판매업GS25 청양의료원점충청남도 청양군 청양읍 중앙로 182070-776-87362023-02-01
2627안전상비의약품판매업GS25 청양타운점충청남도 청양군 청양읍 칠갑산로 245041-942-59492023-02-01
2728안전상비의약품판매업씨유 청양점충청남도 청양군 청양읍 칠갑산로 217041-943-25582023-02-01
2829안전상비의약품판매업GS25청양읍내점충청남도 청양군 청양읍 중앙로 83041-943-82592023-02-01