Overview

Dataset statistics

Number of variables5
Number of observations138
Missing cells1
Missing cells (%)0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.7 KiB
Average record size in memory41.9 B

Variable types

Numeric1
Categorical1
Text3

Dataset

Description전남 여수시 관내 약국, 한약국 정보 현황에 대한 데이터로 약국명, 약국 소재지, 약국 전화번호 등의 항목을 제공합니다.
Author전라남도 여수시
URLhttps://www.data.go.kr/data/3044056/fileData.do

Alerts

순번 is highly overall correlated with 약국구분High correlation
약국구분 is highly overall correlated with 순번High correlation
약국구분 is highly imbalanced (55.0%)Imbalance
순번 has unique valuesUnique

Reproduction

Analysis started2024-03-14 09:24:24.002882
Analysis finished2024-03-14 09:24:25.164187
Duration1.16 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct138
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean69.5
Minimum1
Maximum138
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2024-03-14T18:24:25.363887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile7.85
Q135.25
median69.5
Q3103.75
95-th percentile131.15
Maximum138
Range137
Interquartile range (IQR)68.5

Descriptive statistics

Standard deviation39.981246
Coefficient of variation (CV)0.57526972
Kurtosis-1.2
Mean69.5
Median Absolute Deviation (MAD)34.5
Skewness0
Sum9591
Variance1598.5
MonotonicityStrictly increasing
2024-03-14T18:24:25.808810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.7%
96 1
 
0.7%
90 1
 
0.7%
91 1
 
0.7%
92 1
 
0.7%
93 1
 
0.7%
94 1
 
0.7%
95 1
 
0.7%
97 1
 
0.7%
105 1
 
0.7%
Other values (128) 128
92.8%
ValueCountFrequency (%)
1 1
0.7%
2 1
0.7%
3 1
0.7%
4 1
0.7%
5 1
0.7%
6 1
0.7%
7 1
0.7%
8 1
0.7%
9 1
0.7%
10 1
0.7%
ValueCountFrequency (%)
138 1
0.7%
137 1
0.7%
136 1
0.7%
135 1
0.7%
134 1
0.7%
133 1
0.7%
132 1
0.7%
131 1
0.7%
130 1
0.7%
129 1
0.7%

약국구분
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
약국
125 
한약국
13 

Length

Max length3
Median length2
Mean length2.0942029
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
약국 125
90.6%
한약국 13
 
9.4%

Length

2024-03-14T18:24:26.243970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T18:24:26.454171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 125
90.6%
한약국 13
 
9.4%

약국명칭
Text

Distinct136
Distinct (%)98.6%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2024-03-14T18:24:27.491782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length4
Mean length4.8913043
Min length3

Characters and Unicode

Total characters675
Distinct characters163
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

Unique134 ?
Unique (%)97.1%

Sample

1st row세일약국
2nd row미평햇살약국
3rd row전일약국
4th row장원온누리약국
5th row데일리약국
ValueCountFrequency (%)
약국 3
 
2.0%
한약국 3
 
2.0%
아페약국 2
 
1.3%
백운약국 2
 
1.3%
여수바다약국 2
 
1.3%
유킹스파머시 2
 
1.3%
송이약국 1
 
0.7%
창성약국 1
 
0.7%
부부약국 1
 
0.7%
푸른약국 1
 
0.7%
Other values (133) 133
88.1%
2024-03-14T18:24:28.905284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 138
20.4%
국 138
20.4%
한 19
 
2.8%
수 15
 
2.2%
여 13
 
1.9%
13
 
1.9%
리 10
 
1.5%
일 9
 
1.3%
남 8
 
1.2%
당 8
 
1.2%
Other values (153) 304
45.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 656
97.2%
Space Separator 13
 
1.9%
Decimal Number 6
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 138
21.0%
국 138
21.0%
한 19
 
2.9%
수 15
 
2.3%
여 13
 
2.0%
리 10
 
1.5%
일 9
 
1.4%
남 8
 
1.2%
당 8
 
1.2%
세 7
 
1.1%
Other values (147) 291
44.4%
Decimal Number
ValueCountFrequency (%)
0 2
33.3%
1 1
16.7%
3 1
16.7%
5 1
16.7%
6 1
16.7%
Space Separator
ValueCountFrequency (%)
13
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 656
97.2%
Common 19
 
2.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 138
21.0%
국 138
21.0%
한 19
 
2.9%
수 15
 
2.3%
여 13
 
2.0%
리 10
 
1.5%
일 9
 
1.4%
남 8
 
1.2%
당 8
 
1.2%
세 7
 
1.1%
Other values (147) 291
44.4%
Common
ValueCountFrequency (%)
13
68.4%
0 2
 
10.5%
1 1
 
5.3%
3 1
 
5.3%
5 1
 
5.3%
6 1
 
5.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 656
97.2%
ASCII 19
 
2.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 138
21.0%
국 138
21.0%
한 19
 
2.9%
수 15
 
2.3%
여 13
 
2.0%
리 10
 
1.5%
일 9
 
1.4%
남 8
 
1.2%
당 8
 
1.2%
세 7
 
1.1%
Other values (147) 291
44.4%
ASCII
ValueCountFrequency (%)
13
68.4%
0 2
 
10.5%
1 1
 
5.3%
3 1
 
5.3%
5 1
 
5.3%
6 1
 
5.3%

약국소재지(도로명)
Text

Distinct135
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2024-03-14T18:24:30.209350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length43
Median length31
Mean length23.07971
Min length19

Characters and Unicode

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

Unique

Unique132 ?
Unique (%)95.7%

Sample

1st row전라남도 여수시 통제영2길 8 (교동)
2nd row전라남도 여수시 미평로 58 (미평동)
3rd row전라남도 여수시 문수로 86 (문수동)
4th row전라남도 여수시 중앙로 29-1, 1층 (충무동)
5th row전라남도 여수시 시청로 15, 1층 (학동)
ValueCountFrequency (%)
전라남도 138
 
19.0%
여수시 138
 
19.0%
학동 24
 
3.3%
1층 14
 
1.9%
여서동 13
 
1.8%
중앙로 12
 
1.7%
신월로 12
 
1.7%
서교동 10
 
1.4%
교동 10
 
1.4%
시청로 9
 
1.2%
Other values (198) 345
47.6%
2024-03-14T18:24:31.689758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
587
18.4%
여 164
 
5.1%
수 160
 
5.0%
시 149
 
4.7%
남 143
 
4.5%
동 142
 
4.5%
라 141
 
4.4%
도 140
 
4.4%
전 138
 
4.3%
( 127
 
4.0%
Other values (119) 1294
40.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1878
59.0%
Space Separator 587
 
18.4%
Decimal Number 400
 
12.6%
Open Punctuation 127
 
4.0%
Close Punctuation 127
 
4.0%
Dash Punctuation 34
 
1.1%
Other Punctuation 31
 
1.0%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
여 164
 
8.7%
수 160
 
8.5%
시 149
 
7.9%
남 143
 
7.6%
동 142
 
7.6%
라 141
 
7.5%
도 140
 
7.5%
전 138
 
7.3%
로 113
 
6.0%
서 36
 
1.9%
Other values (103) 552
29.4%
Decimal Number
ValueCountFrequency (%)
1 119
29.8%
2 57
14.2%
3 40
 
10.0%
6 39
 
9.8%
5 35
 
8.8%
4 29
 
7.2%
7 28
 
7.0%
0 23
 
5.8%
8 17
 
4.2%
9 13
 
3.2%
Space Separator
ValueCountFrequency (%)
587
100.0%
Open Punctuation
ValueCountFrequency (%)
( 127
100.0%
Close Punctuation
ValueCountFrequency (%)
) 127
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 34
100.0%
Other Punctuation
ValueCountFrequency (%)
, 31
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1878
59.0%
Common 1306
41.0%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
여 164
 
8.7%
수 160
 
8.5%
시 149
 
7.9%
남 143
 
7.6%
동 142
 
7.6%
라 141
 
7.5%
도 140
 
7.5%
전 138
 
7.3%
로 113
 
6.0%
서 36
 
1.9%
Other values (103) 552
29.4%
Common
ValueCountFrequency (%)
587
44.9%
( 127
 
9.7%
) 127
 
9.7%
1 119
 
9.1%
2 57
 
4.4%
3 40
 
3.1%
6 39
 
3.0%
5 35
 
2.7%
- 34
 
2.6%
, 31
 
2.4%
Other values (5) 110
 
8.4%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1878
59.0%
ASCII 1307
41.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
587
44.9%
( 127
 
9.7%
) 127
 
9.7%
1 119
 
9.1%
2 57
 
4.4%
3 40
 
3.1%
6 39
 
3.0%
5 35
 
2.7%
- 34
 
2.6%
, 31
 
2.4%
Other values (6) 111
 
8.5%
Hangul
ValueCountFrequency (%)
여 164
 
8.7%
수 160
 
8.5%
시 149
 
7.9%
남 143
 
7.6%
동 142
 
7.6%
라 141
 
7.5%
도 140
 
7.5%
전 138
 
7.3%
로 113
 
6.0%
서 36
 
1.9%
Other values (103) 552
29.4%

전화번호
Text

Distinct133
Distinct (%)97.1%
Missing1
Missing (%)0.7%
Memory size1.2 KiB
2024-03-14T18:24:32.661718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.021898
Min length12

Characters and Unicode

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

Unique129 ?
Unique (%)94.2%

Sample

1st row061-661-0634
2nd row061-663-7538
3rd row061-654-3150
4th row061-662-3170
5th row061-685-3557
ValueCountFrequency (%)
061-655-2999 2
 
1.5%
061-691-2125 2
 
1.5%
061-663-4389 2
 
1.5%
061-683-7781 2
 
1.5%
061-642-8522 1
 
0.7%
061-642-8355 1
 
0.7%
061-691-5249 1
 
0.7%
061-665-2468 1
 
0.7%
061-684-6118 1
 
0.7%
061-664-0315 1
 
0.7%
Other values (123) 123
89.8%
2024-03-14T18:24:34.086173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 342
20.8%
- 274
16.6%
0 230
14.0%
1 210
12.8%
5 121
 
7.3%
8 102
 
6.2%
2 95
 
5.8%
4 89
 
5.4%
3 79
 
4.8%
7 65
 
3.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1373
83.4%
Dash Punctuation 274
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 342
24.9%
0 230
16.8%
1 210
15.3%
5 121
 
8.8%
8 102
 
7.4%
2 95
 
6.9%
4 89
 
6.5%
3 79
 
5.8%
7 65
 
4.7%
9 40
 
2.9%
Dash Punctuation
ValueCountFrequency (%)
- 274
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1647
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
6 342
20.8%
- 274
16.6%
0 230
14.0%
1 210
12.8%
5 121
 
7.3%
8 102
 
6.2%
2 95
 
5.8%
4 89
 
5.4%
3 79
 
4.8%
7 65
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1647
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 342
20.8%
- 274
16.6%
0 230
14.0%
1 210
12.8%
5 121
 
7.3%
8 102
 
6.2%
2 95
 
5.8%
4 89
 
5.4%
3 79
 
4.8%
7 65
 
3.9%

Interactions

2024-03-14T18:24:24.368283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T18:24:34.295187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번약국구분
순번1.0000.998
약국구분0.9981.000
2024-03-14T18:24:34.431432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번약국구분
순번1.0000.928
약국구분0.9281.000

Missing values

2024-03-14T18:24:24.707785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T18:24:25.037762image/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약국세일약국전라남도 여수시 통제영2길 8 (교동)061-661-0634
12약국미평햇살약국전라남도 여수시 미평로 58 (미평동)061-663-7538
23약국전일약국전라남도 여수시 문수로 86 (문수동)061-654-3150
34약국장원온누리약국전라남도 여수시 중앙로 29-1, 1층 (충무동)061-662-3170
45약국데일리약국전라남도 여수시 시청로 15, 1층 (학동)061-685-3557
56약국이마트약국전라남도 여수시 좌수영로 277, 이마트 1층 (오림동)061-654-4376
67약국신풍애양약국전라남도 여수시 율촌면 구암1길 53-1061-683-7781
78약국정담은약국전라남도 여수시 둔덕2길 6-4(미평동)061-682-5660
89약국일번지약국전라남도 여수시 좌수영로 1, 1층 (서교동)0507-1477-6699
910약국센트럴약국전라남도 여수시 둔덕2길 6-1(미평동)061-652-2580
순번약국구분약국명칭약국소재지(도로명)전화번호
128129한약국남도한약국전라남도 여수시 웅천7길 33 (웅천동)061-662-0432
129130한약국행림당한약국전라남도 여수시 동문로 107 (공화동)061-663-3050
130131한약국회춘당 한약국전라남도 여수시 교동시장3길 1 (교동)061-664-6900
131132한약국맑은 수 한약국전라남도 여수시 웅천로 83, 2316호 (웅천동)061-643-3037
132133한약국서정한약국전라남도 여수시 중앙로 24, 2층 (교동)061-662-6554
133134한약국한성당한약국전라남도 여수시 충무5길 11-1 (충무동)061-663-4389
134135한약국지성당한약국전라남도 여수시 신기남3길 22-2 (신기동)061-682-5557
135136한약국금강당한약국전라남도 여수시 문수로 152 (문수동)061-652-1687
136137한약국동인당한약국전라남도 여수시 미평로 10-1 (미평동)061-654-5236
137138한약국공한약국전라남도 여수시 충무5길 14 (충무동)061-663-4389