Overview

Dataset statistics

Number of variables6
Number of observations127
Missing cells2
Missing cells (%)0.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.2 KiB
Average record size in memory50.0 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=435&beforeMenuCd=DOM_000000201001001000&publicdatapk=3078534

Alerts

영업구분 has constant value ""Constant
순번 is highly overall correlated with 의약분업예외지역High correlation
의약분업예외지역 is highly overall correlated with 순번High correlation
의약분업예외지역 is highly imbalanced (69.2%)Imbalance
약국전화번호 has 2 (1.6%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2024-01-09 21:38:09.017320
Analysis finished2024-01-09 21:38:09.486794
Duration0.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct127
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean64
Minimum1
Maximum127
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2024-01-10T06:38:09.541962image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile7.3
Q132.5
median64
Q395.5
95-th percentile120.7
Maximum127
Range126
Interquartile range (IQR)63

Descriptive statistics

Standard deviation36.805797
Coefficient of variation (CV)0.57509057
Kurtosis-1.2
Mean64
Median Absolute Deviation (MAD)32
Skewness0
Sum8128
Variance1354.6667
MonotonicityStrictly increasing
2024-01-10T06:38:09.651591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.8%
2 1
 
0.8%
95 1
 
0.8%
94 1
 
0.8%
93 1
 
0.8%
92 1
 
0.8%
91 1
 
0.8%
90 1
 
0.8%
89 1
 
0.8%
88 1
 
0.8%
Other values (117) 117
92.1%
ValueCountFrequency (%)
1 1
0.8%
2 1
0.8%
3 1
0.8%
4 1
0.8%
5 1
0.8%
6 1
0.8%
7 1
0.8%
8 1
0.8%
9 1
0.8%
10 1
0.8%
ValueCountFrequency (%)
127 1
0.8%
126 1
0.8%
125 1
0.8%
124 1
0.8%
123 1
0.8%
122 1
0.8%
121 1
0.8%
120 1
0.8%
119 1
0.8%
118 1
0.8%

영업구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
영업중
127 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row영업중
2nd row영업중
3rd row영업중
4th row영업중
5th row영업중

Common Values

ValueCountFrequency (%)
영업중 127
100.0%

Length

2024-01-10T06:38:09.752780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T06:38:09.827500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업중 127
100.0%

약국명칭
Text

Distinct123
Distinct (%)96.9%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-01-10T06:38:10.021700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length8
Mean length5.0551181
Min length3

Characters and Unicode

Total characters642
Distinct characters151
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique119 ?
Unique (%)93.7%

Sample

1st row원광한약국
2nd row탕정우리약국
3rd row아산정약국
4th row시민약국
5th row시민약국
ValueCountFrequency (%)
아산프라자약국 2
 
1.5%
아산종합약국 2
 
1.5%
시민약국 2
 
1.5%
다모아약국 2
 
1.5%
미즈약국 1
 
0.8%
늘푸른약국 1
 
0.8%
마음약국 1
 
0.8%
샘약국 1
 
0.8%
신한얼약국 1
 
0.8%
탑약국 1
 
0.8%
Other values (117) 117
89.3%
2024-01-10T06:38:10.385535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 129
20.1%
국 127
19.8%
아 17
 
2.6%
산 17
 
2.6%
리 16
 
2.5%
온 11
 
1.7%
한 9
 
1.4%
정 9
 
1.4%
누 7
 
1.1%
신 6
 
0.9%
Other values (141) 294
45.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 634
98.8%
Space Separator 4
 
0.6%
Decimal Number 4
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 129
20.3%
국 127
20.0%
아 17
 
2.7%
산 17
 
2.7%
리 16
 
2.5%
온 11
 
1.7%
한 9
 
1.4%
정 9
 
1.4%
누 7
 
1.1%
신 6
 
0.9%
Other values (137) 286
45.1%
Decimal Number
ValueCountFrequency (%)
5 2
50.0%
3 1
25.0%
6 1
25.0%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 634
98.8%
Common 8
 
1.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 129
20.3%
국 127
20.0%
아 17
 
2.7%
산 17
 
2.7%
리 16
 
2.5%
온 11
 
1.7%
한 9
 
1.4%
정 9
 
1.4%
누 7
 
1.1%
신 6
 
0.9%
Other values (137) 286
45.1%
Common
ValueCountFrequency (%)
4
50.0%
5 2
25.0%
3 1
 
12.5%
6 1
 
12.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 634
98.8%
ASCII 8
 
1.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 129
20.3%
국 127
20.0%
아 17
 
2.7%
산 17
 
2.7%
리 16
 
2.5%
온 11
 
1.7%
한 9
 
1.4%
정 9
 
1.4%
누 7
 
1.1%
신 6
 
0.9%
Other values (137) 286
45.1%
ASCII
ValueCountFrequency (%)
4
50.0%
5 2
25.0%
3 1
 
12.5%
6 1
 
12.5%

약국전화번호
Text

MISSING 

Distinct121
Distinct (%)96.8%
Missing2
Missing (%)1.6%
Memory size1.1 KiB
2024-01-10T06:38:10.592292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique117 ?
Unique (%)93.6%

Sample

1st row041-541-1642
2nd row041-532-4408
3rd row041-533-5424
4th row041-545-2219
5th row041-545-2219
ValueCountFrequency (%)
041-547-6500 2
 
1.6%
041-533-0787 2
 
1.6%
041-545-2219 2
 
1.6%
041-533-0377 2
 
1.6%
041-903-0622 1
 
0.8%
041-541-2207 1
 
0.8%
041-541-8272 1
 
0.8%
041-546-6386 1
 
0.8%
041-533-1269 1
 
0.8%
041-549-0995 1
 
0.8%
Other values (111) 111
88.8%
2024-01-10T06:38:10.886691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 272
18.1%
- 250
16.7%
0 204
13.6%
1 197
13.1%
5 185
12.3%
3 112
7.5%
2 76
 
5.1%
6 56
 
3.7%
9 54
 
3.6%
7 50
 
3.3%

Most occurring categories

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

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 272
21.8%
0 204
16.3%
1 197
15.8%
5 185
14.8%
3 112
9.0%
2 76
 
6.1%
6 56
 
4.5%
9 54
 
4.3%
7 50
 
4.0%
8 44
 
3.5%
Dash Punctuation
ValueCountFrequency (%)
- 250
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1500
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 272
18.1%
- 250
16.7%
0 204
13.6%
1 197
13.1%
5 185
12.3%
3 112
7.5%
2 76
 
5.1%
6 56
 
3.7%
9 54
 
3.6%
7 50
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1500
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 272
18.1%
- 250
16.7%
0 204
13.6%
1 197
13.1%
5 185
12.3%
3 112
7.5%
2 76
 
5.1%
6 56
 
3.7%
9 54
 
3.6%
7 50
 
3.3%

약국소재지(도로명)
Text

Distinct123
Distinct (%)96.9%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-01-10T06:38:11.130421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length37
Mean length28.15748
Min length19

Characters and Unicode

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

Unique

Unique119 ?
Unique (%)93.7%

Sample

1st row충청남도 아산시 번영로217번길 25-9(모종동)
2nd row충청남도 아산시 탕정면 한들물빛도시로 88, 거산타워 108,109호
3rd row충청남도 아산시 모종남로12번길 8, 2층 (모종동)
4th row충청남도 아산시 시민로 394, 시민약국 (온천동)
5th row충청남도 아산시 시민로 394, 시민약국 (온천동)
ValueCountFrequency (%)
충청남도 127
 
16.5%
아산시 127
 
16.5%
1층 37
 
4.8%
온천동 30
 
3.9%
배방읍 24
 
3.1%
모종동 18
 
2.3%
온천대로 15
 
1.9%
충무로 11
 
1.4%
용화동 7
 
0.9%
둔포면 7
 
0.9%
Other values (252) 367
47.7%
2024-01-10T06:38:11.474290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
643
 
18.0%
1 175
 
4.9%
아 147
 
4.1%
시 147
 
4.1%
산 145
 
4.1%
충 139
 
3.9%
남 136
 
3.8%
도 131
 
3.7%
청 129
 
3.6%
로 117
 
3.3%
Other values (168) 1667
46.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2070
57.9%
Space Separator 643
 
18.0%
Decimal Number 577
 
16.1%
Open Punctuation 84
 
2.3%
Other Punctuation 84
 
2.3%
Close Punctuation 84
 
2.3%
Dash Punctuation 18
 
0.5%
Uppercase Letter 15
 
0.4%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
아 147
 
7.1%
시 147
 
7.1%
산 145
 
7.0%
충 139
 
6.7%
남 136
 
6.6%
도 131
 
6.3%
청 129
 
6.2%
로 117
 
5.7%
동 80
 
3.9%
온 51
 
2.5%
Other values (141) 848
41.0%
Uppercase Letter
ValueCountFrequency (%)
S 3
20.0%
D 2
13.3%
J 2
13.3%
U 1
 
6.7%
L 1
 
6.7%
C 1
 
6.7%
I 1
 
6.7%
T 1
 
6.7%
Y 1
 
6.7%
M 1
 
6.7%
Decimal Number
ValueCountFrequency (%)
1 175
30.3%
2 80
13.9%
0 63
 
10.9%
4 54
 
9.4%
3 51
 
8.8%
8 38
 
6.6%
9 33
 
5.7%
5 32
 
5.5%
6 26
 
4.5%
7 25
 
4.3%
Space Separator
ValueCountFrequency (%)
643
100.0%
Open Punctuation
ValueCountFrequency (%)
( 84
100.0%
Other Punctuation
ValueCountFrequency (%)
, 84
100.0%
Close Punctuation
ValueCountFrequency (%)
) 84
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2070
57.9%
Common 1491
41.7%
Latin 15
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
아 147
 
7.1%
시 147
 
7.1%
산 145
 
7.0%
충 139
 
6.7%
남 136
 
6.6%
도 131
 
6.3%
청 129
 
6.2%
로 117
 
5.7%
동 80
 
3.9%
온 51
 
2.5%
Other values (141) 848
41.0%
Common
ValueCountFrequency (%)
643
43.1%
1 175
 
11.7%
( 84
 
5.6%
, 84
 
5.6%
) 84
 
5.6%
2 80
 
5.4%
0 63
 
4.2%
4 54
 
3.6%
3 51
 
3.4%
8 38
 
2.5%
Other values (6) 135
 
9.1%
Latin
ValueCountFrequency (%)
S 3
20.0%
D 2
13.3%
J 2
13.3%
U 1
 
6.7%
L 1
 
6.7%
C 1
 
6.7%
I 1
 
6.7%
T 1
 
6.7%
Y 1
 
6.7%
M 1
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2070
57.9%
ASCII 1506
42.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
643
42.7%
1 175
 
11.6%
( 84
 
5.6%
, 84
 
5.6%
) 84
 
5.6%
2 80
 
5.3%
0 63
 
4.2%
4 54
 
3.6%
3 51
 
3.4%
8 38
 
2.5%
Other values (17) 150
 
10.0%
Hangul
ValueCountFrequency (%)
아 147
 
7.1%
시 147
 
7.1%
산 145
 
7.0%
충 139
 
6.7%
남 136
 
6.6%
도 131
 
6.3%
청 129
 
6.2%
로 117
 
5.7%
동 80
 
3.9%
온 51
 
2.5%
Other values (141) 848
41.0%

의약분업예외지역
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
<NA>
120 
유
 
7

Length

Max length4
Median length4
Mean length3.8346457
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 120
94.5%
유 7
 
5.5%

Length

2024-01-10T06:38:11.587922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T06:38:11.666487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 120
94.5%
유 7
 
5.5%

Interactions

2024-01-10T06:38:09.280666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T06:38:11.713974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번
순번1.000
2024-01-10T06:38:11.770482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번의약분업예외지역
순번1.0001.000
의약분업예외지역1.0001.000

Missing values

2024-01-10T06:38:09.371844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T06:38:09.454032image/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영업중원광한약국041-541-1642충청남도 아산시 번영로217번길 25-9(모종동)<NA>
12영업중탕정우리약국041-532-4408충청남도 아산시 탕정면 한들물빛도시로 88, 거산타워 108,109호<NA>
23영업중아산정약국041-533-5424충청남도 아산시 모종남로12번길 8, 2층 (모종동)<NA>
34영업중시민약국041-545-2219충청남도 아산시 시민로 394, 시민약국 (온천동)<NA>
45영업중시민약국041-545-2219충청남도 아산시 시민로 394, 시민약국 (온천동)<NA>
56영업중아산제일약국041-910-8010충청남도 아산시 시장길 28, 1층 108호 (온천동)<NA>
67영업중일등약국041-545-8439충청남도 아산시 배방읍 배방로13번길 9-4, 1층 105호<NA>
78영업중경희당약국<NA>충청남도 아산시 음봉면 연암율금로 32, 101호유
89영업중탕정온빛약국041-549-3649충청남도 아산시 탕정면 한들물빛도시로 85, 103호<NA>
910영업중시민로사거리약국041-548-5841충청남도 아산시 번영로 99, 시민로사거리약국 1층 (온천동)<NA>
순번영업구분약국명칭약국전화번호약국소재지(도로명)의약분업예외지역
117118영업중온양다나약국041-549-0216충청남도 아산시 시민로 292 (용화동)<NA>
118119영업중유정약국041-549-5315충청남도 아산시 남부로 353, 104호 (풍기동, 동일하이빌아파트상가)<NA>
119120영업중녹십자약국041-533-6080충청남도 아산시 충무로 22, 103호 (온천동, UL CITY)<NA>
120121영업중한미약국041-548-9664충청남도 아산시 고불로 669, 109호 (좌부동, 초원아파트2차상가)<NA>
121122영업중무성약국041-532-9770충청남도 아산시 외암로 1416 (읍내동)<NA>
122123영업중다모아약국041-533-0377충청남도 아산시 충무로 16 (온천동)<NA>
123124영업중다모아약국041-533-0377충청남도 아산시 충무로 16 (온천동)<NA>
124125영업중모산종로약국041-549-4131충청남도 아산시 배방읍 모산로 185<NA>
125126영업중음봉약국041-533-8075충청남도 아산시 음봉면 음봉로 805<NA>
126127영업중대동약국041-545-2089충청남도 아산시 시장남길 3 (온천동)<NA>