Overview

Dataset statistics

Number of variables6
Number of observations40
Missing cells9
Missing cells (%)3.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory52.3 B

Variable types

Numeric1
Categorical1
Text3
DateTime1

Dataset

Description"의약업소현황" 공공데이터는 구례 지역 내에서 운영되고 있는 의약업소에 관한 정보를 제공합니다.이 데이터는 주로 약국과 같은 의약업소들의 현황과 관련된 정보를 포함합니다.이 데이터를 통해 지역 주민들은 건강 관련 문제에 대한 의약품을 구입하거나 상담을 받을 수 있는 의약업소를 쉽게 찾을 수 있습니다.또한, 이 데이터는 보건 당국이 의약품 제공과 관련된 서비스를 관리하고 모니터링하는 데 사용됩니다.
Author전라남도 구례군
URLhttps://www.data.go.kr/data/3080253/fileData.do

Alerts

데이터 기준일 has constant value ""Constant
연번 is highly overall correlated with 구분High correlation
구분 is highly overall correlated with 연번High correlation
전화번호 has 9 (22.5%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-30 07:38:48.353872
Analysis finished2024-03-30 07:38:50.014247
Duration1.66 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct40
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20.5
Minimum1
Maximum40
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size492.0 B
2024-03-30T07:38:50.320061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.95
Q110.75
median20.5
Q330.25
95-th percentile38.05
Maximum40
Range39
Interquartile range (IQR)19.5

Descriptive statistics

Standard deviation11.690452
Coefficient of variation (CV)0.57026595
Kurtosis-1.2
Mean20.5
Median Absolute Deviation (MAD)10
Skewness0
Sum820
Variance136.66667
MonotonicityStrictly increasing
2024-03-30T07:38:51.064876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=40)
ValueCountFrequency (%)
1 1
 
2.5%
22 1
 
2.5%
24 1
 
2.5%
25 1
 
2.5%
26 1
 
2.5%
27 1
 
2.5%
28 1
 
2.5%
29 1
 
2.5%
30 1
 
2.5%
31 1
 
2.5%
Other values (30) 30
75.0%
ValueCountFrequency (%)
1 1
2.5%
2 1
2.5%
3 1
2.5%
4 1
2.5%
5 1
2.5%
6 1
2.5%
7 1
2.5%
8 1
2.5%
9 1
2.5%
10 1
2.5%
ValueCountFrequency (%)
40 1
2.5%
39 1
2.5%
38 1
2.5%
37 1
2.5%
36 1
2.5%
35 1
2.5%
34 1
2.5%
33 1
2.5%
32 1
2.5%
31 1
2.5%

구분
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)15.0%
Missing0
Missing (%)0.0%
Memory size452.0 B
의료기기 판매업
19 
약국
11 
안전상비의약품 판매업
5 
안경업소
3 
약방
 
1

Length

Max length11
Median length8
Mean length6.15
Min length2

Unique

Unique2 ?
Unique (%)5.0%

Sample

1st row안경업소
2nd row안경업소
3rd row안경업소
4th row약국
5th row약국

Common Values

ValueCountFrequency (%)
의료기기 판매업 19
47.5%
약국 11
27.5%
안전상비의약품 판매업 5
 
12.5%
안경업소 3
 
7.5%
약방 1
 
2.5%
한약방 1
 
2.5%

Length

2024-03-30T07:38:51.684082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-30T07:38:52.046660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
판매업 24
37.5%
의료기기 19
29.7%
약국 11
17.2%
안전상비의약품 5
 
7.8%
안경업소 3
 
4.7%
약방 1
 
1.6%
한약방 1
 
1.6%

명칭
Text

Distinct39
Distinct (%)97.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
2024-03-30T07:38:52.566710image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length10.5
Mean length6.175
Min length2

Characters and Unicode

Total characters247
Distinct characters91
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

Unique38 ?
Unique (%)95.0%

Sample

1st row밝은안경
2nd row안경나라
3rd row열린안경
4th row제일약국
5th row장약국
ValueCountFrequency (%)
구례봉동점 3
 
6.7%
세븐일레븐 2
 
4.4%
이마트24구례군청점 1
 
2.2%
구례자연드림점 1
 
2.2%
gs25구례중앙점 1
 
2.2%
중앙의료기 1
 
2.2%
현대전자 1
 
2.2%
하나로마트 1
 
2.2%
세븐일레븐터미널점 1
 
2.2%
gs25 1
 
2.2%
Other values (32) 32
71.1%
2024-03-30T07:38:53.638349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
례 14
 
5.7%
약 14
 
5.7%
구 14
 
5.7%
점 13
 
5.3%
국 11
 
4.5%
븐 8
 
3.2%
의 6
 
2.4%
6
 
2.4%
일 6
 
2.4%
기 6
 
2.4%
Other values (81) 149
60.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 217
87.9%
Uppercase Letter 12
 
4.9%
Decimal Number 10
 
4.0%
Space Separator 6
 
2.4%
Open Punctuation 1
 
0.4%
Close Punctuation 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
례 14
 
6.5%
약 14
 
6.5%
구 14
 
6.5%
점 13
 
6.0%
국 11
 
5.1%
븐 8
 
3.7%
의 6
 
2.8%
일 6
 
2.8%
기 6
 
2.8%
료 5
 
2.3%
Other values (71) 120
55.3%
Uppercase Letter
ValueCountFrequency (%)
S 4
33.3%
G 4
33.3%
C 2
16.7%
U 2
16.7%
Decimal Number
ValueCountFrequency (%)
2 5
50.0%
5 4
40.0%
4 1
 
10.0%
Space Separator
ValueCountFrequency (%)
6
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 217
87.9%
Common 18
 
7.3%
Latin 12
 
4.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
례 14
 
6.5%
약 14
 
6.5%
구 14
 
6.5%
점 13
 
6.0%
국 11
 
5.1%
븐 8
 
3.7%
의 6
 
2.8%
일 6
 
2.8%
기 6
 
2.8%
료 5
 
2.3%
Other values (71) 120
55.3%
Common
ValueCountFrequency (%)
6
33.3%
2 5
27.8%
5 4
22.2%
4 1
 
5.6%
( 1
 
5.6%
) 1
 
5.6%
Latin
ValueCountFrequency (%)
S 4
33.3%
G 4
33.3%
C 2
16.7%
U 2
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 217
87.9%
ASCII 30
 
12.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
례 14
 
6.5%
약 14
 
6.5%
구 14
 
6.5%
점 13
 
6.0%
국 11
 
5.1%
븐 8
 
3.7%
의 6
 
2.8%
일 6
 
2.8%
기 6
 
2.8%
료 5
 
2.3%
Other values (71) 120
55.3%
ASCII
ValueCountFrequency (%)
6
20.0%
2 5
16.7%
S 4
13.3%
5 4
13.3%
G 4
13.3%
C 2
 
6.7%
U 2
 
6.7%
4 1
 
3.3%
( 1
 
3.3%
) 1
 
3.3%

개설장소
Text

Distinct37
Distinct (%)92.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
2024-03-30T07:38:54.104970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length20
Mean length15.775
Min length9

Characters and Unicode

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

Unique

Unique34 ?
Unique (%)85.0%

Sample

1st row전라남도 구례군 구례읍 봉성로 79
2nd row전라남도 구례군 구례읍 봉성로 82
3rd row전라남도 구례군 구례읍 로터리길 19
4th row전라남도 구례군 구례읍 구례1길 40
5th row전라남도 구례군 구례읍 로터리길 13
ValueCountFrequency (%)
구례읍 36
21.7%
구례군 24
14.5%
전라남도 23
13.9%
봉성로 10
 
6.0%
로터리길 6
 
3.6%
2 4
 
2.4%
중앙로 4
 
2.4%
4 4
 
2.4%
봉동길 4
 
2.4%
동편제길 3
 
1.8%
Other values (39) 48
28.9%
2024-03-30T07:38:55.395659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
126
20.0%
구 62
 
9.8%
례 62
 
9.8%
읍 36
 
5.7%
로 24
 
3.8%
군 24
 
3.8%
전 23
 
3.6%
남 23
 
3.6%
도 23
 
3.6%
라 23
 
3.6%
Other values (35) 205
32.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 419
66.4%
Space Separator 126
 
20.0%
Decimal Number 81
 
12.8%
Dash Punctuation 5
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 62
14.8%
례 62
14.8%
읍 36
 
8.6%
로 24
 
5.7%
군 24
 
5.7%
전 23
 
5.5%
남 23
 
5.5%
도 23
 
5.5%
라 23
 
5.5%
길 22
 
5.3%
Other values (23) 97
23.2%
Decimal Number
ValueCountFrequency (%)
1 21
25.9%
7 10
12.3%
3 9
11.1%
2 9
11.1%
4 8
 
9.9%
9 7
 
8.6%
0 7
 
8.6%
6 5
 
6.2%
8 4
 
4.9%
5 1
 
1.2%
Space Separator
ValueCountFrequency (%)
126
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 419
66.4%
Common 212
33.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 62
14.8%
례 62
14.8%
읍 36
 
8.6%
로 24
 
5.7%
군 24
 
5.7%
전 23
 
5.5%
남 23
 
5.5%
도 23
 
5.5%
라 23
 
5.5%
길 22
 
5.3%
Other values (23) 97
23.2%
Common
ValueCountFrequency (%)
126
59.4%
1 21
 
9.9%
7 10
 
4.7%
3 9
 
4.2%
2 9
 
4.2%
4 8
 
3.8%
9 7
 
3.3%
0 7
 
3.3%
6 5
 
2.4%
- 5
 
2.4%
Other values (2) 5
 
2.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 419
66.4%
ASCII 212
33.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
126
59.4%
1 21
 
9.9%
7 10
 
4.7%
3 9
 
4.2%
2 9
 
4.2%
4 8
 
3.8%
9 7
 
3.3%
0 7
 
3.3%
6 5
 
2.4%
- 5
 
2.4%
Other values (2) 5
 
2.4%
Hangul
ValueCountFrequency (%)
구 62
14.8%
례 62
14.8%
읍 36
 
8.6%
로 24
 
5.7%
군 24
 
5.7%
전 23
 
5.5%
남 23
 
5.5%
도 23
 
5.5%
라 23
 
5.5%
길 22
 
5.3%
Other values (23) 97
23.2%

전화번호
Text

MISSING 

Distinct27
Distinct (%)87.1%
Missing9
Missing (%)22.5%
Memory size452.0 B
2024-03-30T07:38:56.161025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique23 ?
Unique (%)74.2%

Sample

1st row061-782-2714
2nd row061-782-5359
3rd row061-783-7879
4th row061-782-2219
5th row061-782-2298
ValueCountFrequency (%)
061-783-1171 2
 
6.5%
061-781-8582 2
 
6.5%
061-782-2714 2
 
6.5%
061-783-5446 2
 
6.5%
061-781-1603 1
 
3.2%
061-782-5359 1
 
3.2%
061-783-8575 1
 
3.2%
061-896-6129 1
 
3.2%
061-783-3300 1
 
3.2%
061-782-7373 1
 
3.2%
Other values (17) 17
54.8%
2024-03-30T07:38:57.311408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 62
16.7%
1 56
15.1%
7 47
12.6%
8 47
12.6%
0 40
10.8%
6 39
10.5%
2 26
7.0%
3 22
 
5.9%
4 13
 
3.5%
5 11
 
3.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 310
83.3%
Dash Punctuation 62
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 56
18.1%
7 47
15.2%
8 47
15.2%
0 40
12.9%
6 39
12.6%
2 26
8.4%
3 22
 
7.1%
4 13
 
4.2%
5 11
 
3.5%
9 9
 
2.9%
Dash Punctuation
ValueCountFrequency (%)
- 62
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 372
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 62
16.7%
1 56
15.1%
7 47
12.6%
8 47
12.6%
0 40
10.8%
6 39
10.5%
2 26
7.0%
3 22
 
5.9%
4 13
 
3.5%
5 11
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 372
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 62
16.7%
1 56
15.1%
7 47
12.6%
8 47
12.6%
0 40
10.8%
6 39
10.5%
2 26
7.0%
3 22
 
5.9%
4 13
 
3.5%
5 11
 
3.0%

데이터 기준일
Date

CONSTANT 

Distinct1
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
Minimum2024-02-28 00:00:00
Maximum2024-02-28 00:00:00
2024-03-30T07:38:57.645905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-30T07:38:58.109287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-03-30T07:38:48.910542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-30T07:38:58.690646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분명칭개설장소전화번호
연번1.0000.8570.9320.9290.951
구분0.8571.0000.9230.8680.932
명칭0.9320.9231.0001.0001.000
개설장소0.9290.8681.0001.0001.000
전화번호0.9510.9321.0001.0001.000
2024-03-30T07:38:58.996313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분
연번1.0000.633
구분0.6331.000

Missing values

2024-03-30T07:38:49.429665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-30T07:38:49.880527image/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안경업소밝은안경전라남도 구례군 구례읍 봉성로 79061-782-27142024-02-28
12안경업소안경나라전라남도 구례군 구례읍 봉성로 82061-782-53592024-02-28
23안경업소열린안경전라남도 구례군 구례읍 로터리길 19061-783-78792024-02-28
34약국제일약국전라남도 구례군 구례읍 구례1길 40061-782-22192024-02-28
45약국장약국전라남도 구례군 구례읍 로터리길 13061-782-22982024-02-28
56약국부부약국전라남도 구례군 구례읍 북문길 4061-782-20412024-02-28
67약국광주약국전라남도 구례군 구례읍 중앙로 36061-782-69652024-02-28
78약국현대약국전라남도 구례군 구례읍 봉성로 110-1061-783-27112024-02-28
89약국백제약국전라남도 구례군 구례읍 구례1길 50061-782-54482024-02-28
910약국섬지약국전라남도 구례군 구례읍 동편제길 4061-782-33822024-02-28
연번구분명칭개설장소전화번호데이터 기준일
3031의료기기 판매업이마트24구례군청점구례읍 봉성로 12<NA>2024-02-28
3132의료기기 판매업세븐일레븐구례점구례읍 서시천로 72<NA>2024-02-28
3233의료기기 판매업문가약손구례읍 봉성로 87<NA>2024-02-28
3334의료기기 판매업세븐일레븐 구례봉동점구례읍 봉성산길 2<NA>2024-02-28
3435의료기기 판매업이룸구례읍 서신천로 7<NA>2024-02-28
3536안전상비의약품 판매업GS25구례 중앙점전라남도 구례군 구례읍 중앙초등길 2061-783-85752024-02-28
3637안전상비의약품 판매업세븐일레븐 구례봉동점구례읍 봉성산길 2061-783-11712024-02-28
3738안전상비의약품 판매업GS25구례봉동점전라남도 구례군 구례읍 봉동길 46061-783-54462024-02-28
3839안전상비의약품 판매업CU구례정원점전라남도 구례군 구례읍 서시천로 9061-783-11712024-02-28
3940안전상비의약품 판매업CU구례중앙점전라남도 구례군 구례읍 중앙로 4061-783-24782024-02-28