Overview

Dataset statistics

Number of variables6
Number of observations31
Missing cells7
Missing cells (%)3.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory53.1 B

Variable types

Numeric1
Categorical2
Text3

Dataset

Description충청남도 청양군의 관내 약국 현황에 대한 데이터로 업소명칭, 사업장소재지, 전화번호 등에 관한 정보를 나타냅니다.
Author충청남도 청양군
URLhttps://www.data.go.kr/data/3076209/fileData.do

Alerts

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

Reproduction

Analysis started2024-03-14 14:05:55.482387
Analysis finished2024-03-14 14:05:56.621122
Duration1.14 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16
Minimum1
Maximum31
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size407.0 B
2024-03-14T23:05:56.808240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.5
Q18.5
median16
Q323.5
95-th percentile29.5
Maximum31
Range30
Interquartile range (IQR)15

Descriptive statistics

Standard deviation9.0921211
Coefficient of variation (CV)0.56825757
Kurtosis-1.2
Mean16
Median Absolute Deviation (MAD)8
Skewness0
Sum496
Variance82.666667
MonotonicityStrictly increasing
2024-03-14T23:05:57.209623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%)
1 1
 
3.2%
2 1
 
3.2%
31 1
 
3.2%
30 1
 
3.2%
29 1
 
3.2%
28 1
 
3.2%
27 1
 
3.2%
26 1
 
3.2%
25 1
 
3.2%
24 1
 
3.2%
Other values (21) 21
67.7%
ValueCountFrequency (%)
1 1
3.2%
2 1
3.2%
3 1
3.2%
4 1
3.2%
5 1
3.2%
6 1
3.2%
7 1
3.2%
8 1
3.2%
9 1
3.2%
10 1
3.2%
ValueCountFrequency (%)
31 1
3.2%
30 1
3.2%
29 1
3.2%
28 1
3.2%
27 1
3.2%
26 1
3.2%
25 1
3.2%
24 1
3.2%
23 1
3.2%
22 1
3.2%

종별
Categorical

HIGH CORRELATION 

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

Length

Max length10
Median length4
Mean length5.6774194
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
약국 13
41.9%
안전상비의약품판매업 13
41.9%
한약업사 3
 
9.7%
특수장소 2
 
6.5%

Length

2024-03-14T23:05:57.607931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:05:57.914075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 13
41.9%
안전상비의약품판매업 13
41.9%
한약업사 3
 
9.7%
특수장소 2
 
6.5%

업소명칭
Text

UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size376.0 B
2024-03-14T23:05:58.649614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length6.6774194
Min length4

Characters and Unicode

Total characters207
Distinct characters84
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique31 ?
Unique (%)100.0%

Sample

1st row해남약국
2nd row우리약국
3rd row낙원약국
4th row종로온누리약국
5th row푸른약국
ValueCountFrequency (%)
gs25 2
 
5.7%
해남약국 1
 
2.9%
청양의료원점 1
 
2.9%
청양고추점 1
 
2.9%
cu정산중앙점 1
 
2.9%
씨유청양주공점 1
 
2.9%
씨유청양읍내점 1
 
2.9%
씨유청양덕윤타워점 1
 
2.9%
청양타운점 1
 
2.9%
우리약국 1
 
2.9%
Other values (24) 24
68.6%
2024-03-14T23:05:59.875184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 18
 
8.7%
국 15
 
7.2%
청 12
 
5.8%
점 12
 
5.8%
양 12
 
5.8%
씨 8
 
3.9%
유 8
 
3.9%
정 4
 
1.9%
4
 
1.9%
한 4
 
1.9%
Other values (74) 110
53.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 184
88.9%
Uppercase Letter 10
 
4.8%
Decimal Number 6
 
2.9%
Space Separator 4
 
1.9%
Close Punctuation 1
 
0.5%
Open Punctuation 1
 
0.5%
Other Symbol 1
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 18
 
9.8%
국 15
 
8.2%
청 12
 
6.5%
점 12
 
6.5%
양 12
 
6.5%
씨 8
 
4.3%
유 8
 
4.3%
정 4
 
2.2%
한 4
 
2.2%
리 3
 
1.6%
Other values (64) 88
47.8%
Uppercase Letter
ValueCountFrequency (%)
G 3
30.0%
S 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%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 185
89.4%
Common 12
 
5.8%
Latin 10
 
4.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 18
 
9.7%
국 15
 
8.1%
청 12
 
6.5%
점 12
 
6.5%
양 12
 
6.5%
씨 8
 
4.3%
유 8
 
4.3%
정 4
 
2.2%
한 4
 
2.2%
리 3
 
1.6%
Other values (65) 89
48.1%
Common
ValueCountFrequency (%)
4
33.3%
5 3
25.0%
2 3
25.0%
) 1
 
8.3%
( 1
 
8.3%
Latin
ValueCountFrequency (%)
G 3
30.0%
S 3
30.0%
C 2
20.0%
U 2
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 184
88.9%
ASCII 22
 
10.6%
None 1
 
0.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 18
 
9.8%
국 15
 
8.2%
청 12
 
6.5%
점 12
 
6.5%
양 12
 
6.5%
씨 8
 
4.3%
유 8
 
4.3%
정 4
 
2.2%
한 4
 
2.2%
리 3
 
1.6%
Other values (64) 88
47.8%
ASCII
ValueCountFrequency (%)
4
18.2%
G 3
13.6%
5 3
13.6%
2 3
13.6%
S 3
13.6%
C 2
9.1%
U 2
9.1%
) 1
 
4.5%
( 1
 
4.5%
None
ValueCountFrequency (%)
㈜ 1
100.0%

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

Distinct30
Distinct (%)96.8%
Missing0
Missing (%)0.0%
Memory size376.0 B
2024-03-14T23:06:00.726740image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length24
Mean length21.193548
Min length19

Characters and Unicode

Total characters657
Distinct characters64
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

Unique29 ?
Unique (%)93.5%

Sample

1st row충청남도 청양군 정산면 정현길 43
2nd row충청남도 청양군 청양읍 중앙로 133
3rd row충청남도 청양군 청양읍 중앙로 126
4th row충청남도 청양군 청양읍 중앙로 130-1
5th row충청남도 청양군 청양읍 중앙로 178
ValueCountFrequency (%)
충청남도 31
19.6%
청양군 31
19.6%
청양읍 21
13.3%
중앙로 11
 
7.0%
정산면 4
 
2.5%
칠갑산로 3
 
1.9%
중앙로3길 2
 
1.3%
충절로 2
 
1.3%
칠갑산로7길 2
 
1.3%
정현길 2
 
1.3%
Other values (47) 49
31.0%
2024-03-14T23:06:02.012144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
127
19.3%
청 86
13.1%
양 54
 
8.2%
충 33
 
5.0%
남 33
 
5.0%
도 31
 
4.7%
군 31
 
4.7%
1 27
 
4.1%
로 26
 
4.0%
읍 21
 
3.2%
Other values (54) 188
28.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 429
65.3%
Space Separator 127
 
19.3%
Decimal Number 92
 
14.0%
Dash Punctuation 4
 
0.6%
Close Punctuation 2
 
0.3%
Open Punctuation 2
 
0.3%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 86
20.0%
양 54
12.6%
충 33
 
7.7%
남 33
 
7.7%
도 31
 
7.2%
군 31
 
7.2%
로 26
 
6.1%
읍 21
 
4.9%
앙 14
 
3.3%
중 14
 
3.3%
Other values (39) 86
20.0%
Decimal Number
ValueCountFrequency (%)
1 27
29.3%
2 13
14.1%
7 10
 
10.9%
3 10
 
10.9%
0 7
 
7.6%
4 6
 
6.5%
6 6
 
6.5%
8 6
 
6.5%
5 6
 
6.5%
9 1
 
1.1%
Space Separator
ValueCountFrequency (%)
127
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 429
65.3%
Common 228
34.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 86
20.0%
양 54
12.6%
충 33
 
7.7%
남 33
 
7.7%
도 31
 
7.2%
군 31
 
7.2%
로 26
 
6.1%
읍 21
 
4.9%
앙 14
 
3.3%
중 14
 
3.3%
Other values (39) 86
20.0%
Common
ValueCountFrequency (%)
127
55.7%
1 27
 
11.8%
2 13
 
5.7%
7 10
 
4.4%
3 10
 
4.4%
0 7
 
3.1%
4 6
 
2.6%
6 6
 
2.6%
8 6
 
2.6%
5 6
 
2.6%
Other values (5) 10
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 429
65.3%
ASCII 228
34.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
127
55.7%
1 27
 
11.8%
2 13
 
5.7%
7 10
 
4.4%
3 10
 
4.4%
0 7
 
3.1%
4 6
 
2.6%
6 6
 
2.6%
8 6
 
2.6%
5 6
 
2.6%
Other values (5) 10
 
4.4%
Hangul
ValueCountFrequency (%)
청 86
20.0%
양 54
12.6%
충 33
 
7.7%
남 33
 
7.7%
도 31
 
7.2%
군 31
 
7.2%
로 26
 
6.1%
읍 21
 
4.9%
앙 14
 
3.3%
중 14
 
3.3%
Other values (39) 86
20.0%

전화번호
Text

MISSING 

Distinct24
Distinct (%)100.0%
Missing7
Missing (%)22.6%
Memory size376.0 B
2024-03-14T23:06:02.813097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.125
Min length12

Characters and Unicode

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

Unique24 ?
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-943-3766 1
 
4.2%
041-942-2635 1
 
4.2%
041-942-1003 1
 
4.2%
041-943-2558 1
 
4.2%
041-942-5949 1
 
4.2%
070-7776-8736 1
 
4.2%
0507-1417-3328 1
 
4.2%
041-944-0927 1
 
4.2%
041-942-4007 1
 
4.2%
041-943-2383 1
 
4.2%
Other values (14) 14
58.3%
2024-03-14T23:06:04.042977image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 54
18.6%
- 48
16.5%
0 39
13.4%
9 29
10.0%
1 26
8.9%
2 24
8.2%
3 21
 
7.2%
7 20
 
6.9%
5 13
 
4.5%
8 10
 
3.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 243
83.5%
Dash Punctuation 48
 
16.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 54
22.2%
0 39
16.0%
9 29
11.9%
1 26
10.7%
2 24
9.9%
3 21
 
8.6%
7 20
 
8.2%
5 13
 
5.3%
8 10
 
4.1%
6 7
 
2.9%
Dash Punctuation
ValueCountFrequency (%)
- 48
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 291
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 54
18.6%
- 48
16.5%
0 39
13.4%
9 29
10.0%
1 26
8.9%
2 24
8.2%
3 21
 
7.2%
7 20
 
6.9%
5 13
 
4.5%
8 10
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 291
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 54
18.6%
- 48
16.5%
0 39
13.4%
9 29
10.0%
1 26
8.9%
2 24
8.2%
3 21
 
7.2%
7 20
 
6.9%
5 13
 
4.5%
8 10
 
3.4%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size376.0 B
2024-01-23
31 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-01-23
2nd row2024-01-23
3rd row2024-01-23
4th row2024-01-23
5th row2024-01-23

Common Values

ValueCountFrequency (%)
2024-01-23 31
100.0%

Length

2024-03-14T23:06:04.454142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:06:04.761321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-01-23 31
100.0%

Interactions

2024-03-14T23:05:55.784327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T23:06:04.940428image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번종별업소명칭사업장소재지(도로명)전화번호
연번1.0000.9661.0000.9451.000
종별0.9661.0001.0000.9321.000
업소명칭1.0001.0001.0001.0001.000
사업장소재지(도로명)0.9450.9321.0001.0001.000
전화번호1.0001.0001.0001.0001.000
2024-03-14T23:06:05.199628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번종별
연번1.0000.686
종별0.6861.000

Missing values

2024-03-14T23:05:56.118452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T23:05:56.475581image/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-00252024-01-23
12약국우리약국충청남도 청양군 청양읍 중앙로 133041-943-37662024-01-23
23약국낙원약국충청남도 청양군 청양읍 중앙로 126041-942-26352024-01-23
34약국종로온누리약국충청남도 청양군 청양읍 중앙로 130-1041-943-54102024-01-23
45약국푸른약국충청남도 청양군 청양읍 중앙로 178041-944-03462024-01-23
56약국명인약국충청남도 청양군 청양읍 중앙로3길 2041-943-88242024-01-23
67약국중앙약국충청남도 청양군 청양읍 중앙로 124041-943-94752024-01-23
78약국장수약국충청남도 청양군 정산면 정현길 57041-943-29902024-01-23
89약국정성약국충청남도 청양군 청양읍 칠갑산로7길 51041-942-75822024-01-23
910약국신세계약국충청남도 청양군 청양읍 중앙로 84, 1층041-943-82452024-01-23
연번종별업소명칭사업장소재지(도로명)전화번호데이터기준일자
2122안전상비의약품판매업씨유청양읍내점충청남도 청양군 청양읍 중앙로 122-10507-1417-33282024-01-23
2223안전상비의약품판매업씨유청양덕윤타워점충청남도 청양군 청양읍 중앙로12길 17<NA>2024-01-23
2324안전상비의약품판매업GS25 청양의료원점충청남도 청양군 청양읍 중앙로 182070-7776-87362024-01-23
2425안전상비의약품판매업GS25 청양타운점충청남도 청양군 청양읍 칠갑산로 245041-942-59492024-01-23
2526안전상비의약품판매업씨유 청양점충청남도 청양군 청양읍 칠갑산로 217041-943-25582024-01-23
2627안전상비의약품판매업GS25청양읍내점충청남도 청양군 청양읍 중앙로 83041-943-82592024-01-23
2728안전상비의약품판매업씨유청양운곡점충청남도 청양군 운곡면 청신로 671<NA>2024-01-23
2829안전상비의약품판매업씨유청양휴먼시아점충청남도 청양군 청양읍 중앙로3길 26<NA>2024-01-23
2930안전상비의약품판매업씨유청양벽천대로점충청남도 청양군 청양읍 충절로 1057<NA>2024-01-23
3031안전상비의약품판매업씨유(CU)청양비봉태경충청남도 청양군 비봉면 충절로 1603<NA>2024-01-23