Overview

Dataset statistics

Number of variables6
Number of observations42
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.1 KiB
Average record size in memory52.1 B

Variable types

Numeric1
Text3
Categorical1
DateTime1

Dataset

Description이 데이터는 2021년 9월 27일 기준으로 전라북도 남원시에 있는 약국에 대하여 약국명, 주소, 전화번호, 동물의약품취급여부 등에 대한 데이터 입니다.
Author전라북도 남원시
URLhttps://www.data.go.kr/data/15089943/fileData.do

Alerts

데이터 기준일자 has constant value ""Constant
동물의약품 is highly imbalanced (72.4%)Imbalance
연번 has unique valuesUnique
약국명 has unique valuesUnique
약국주소 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 11:53:16.925900
Analysis finished2023-12-12 11:53:17.630907
Duration0.71 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct42
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21.5
Minimum1
Maximum42
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size510.0 B
2023-12-12T20:53:17.769073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.05
Q111.25
median21.5
Q331.75
95-th percentile39.95
Maximum42
Range41
Interquartile range (IQR)20.5

Descriptive statistics

Standard deviation12.267844
Coefficient of variation (CV)0.5705974
Kurtosis-1.2
Mean21.5
Median Absolute Deviation (MAD)10.5
Skewness0
Sum903
Variance150.5
MonotonicityStrictly increasing
2023-12-12T20:53:17.964952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)
ValueCountFrequency (%)
1 1
 
2.4%
33 1
 
2.4%
25 1
 
2.4%
26 1
 
2.4%
27 1
 
2.4%
28 1
 
2.4%
29 1
 
2.4%
30 1
 
2.4%
31 1
 
2.4%
32 1
 
2.4%
Other values (32) 32
76.2%
ValueCountFrequency (%)
1 1
2.4%
2 1
2.4%
3 1
2.4%
4 1
2.4%
5 1
2.4%
6 1
2.4%
7 1
2.4%
8 1
2.4%
9 1
2.4%
10 1
2.4%
ValueCountFrequency (%)
42 1
2.4%
41 1
2.4%
40 1
2.4%
39 1
2.4%
38 1
2.4%
37 1
2.4%
36 1
2.4%
35 1
2.4%
34 1
2.4%
33 1
2.4%

약국명
Text

UNIQUE 

Distinct42
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size468.0 B
2023-12-12T20:53:18.321788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length7
Mean length5.2380952
Min length3

Characters and Unicode

Total characters220
Distinct characters82
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

Unique42 ?
Unique (%)100.0%

Sample

1st row위생약국
2nd row윤약국
3rd row삼진약국
4th row영진약국
5th row구세당약국
ValueCountFrequency (%)
위생약국 1
 
2.3%
남원종로약국 1
 
2.3%
온누리백제약국 1
 
2.3%
인월약국 1
 
2.3%
하나약국 1
 
2.3%
삼성약국 1
 
2.3%
터미널 1
 
2.3%
신약국 1
 
2.3%
평화약국 1
 
2.3%
새호남약국 1
 
2.3%
Other values (34) 34
77.3%
2023-12-12T20:53:18.851173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 42
19.1%
국 42
19.1%
백 6
 
2.7%
남 6
 
2.7%
리 6
 
2.7%
온 5
 
2.3%
제 5
 
2.3%
누 5
 
2.3%
한 4
 
1.8%
로 4
 
1.8%
Other values (72) 95
43.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 216
98.2%
Space Separator 2
 
0.9%
Decimal Number 2
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 42
19.4%
국 42
19.4%
백 6
 
2.8%
남 6
 
2.8%
리 6
 
2.8%
온 5
 
2.3%
제 5
 
2.3%
누 5
 
2.3%
한 4
 
1.9%
로 4
 
1.9%
Other values (70) 91
42.1%
Space Separator
ValueCountFrequency (%)
2
100.0%
Decimal Number
ValueCountFrequency (%)
2 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 216
98.2%
Common 4
 
1.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 42
19.4%
국 42
19.4%
백 6
 
2.8%
남 6
 
2.8%
리 6
 
2.8%
온 5
 
2.3%
제 5
 
2.3%
누 5
 
2.3%
한 4
 
1.9%
로 4
 
1.9%
Other values (70) 91
42.1%
Common
ValueCountFrequency (%)
2
50.0%
2 2
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 216
98.2%
ASCII 4
 
1.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 42
19.4%
국 42
19.4%
백 6
 
2.8%
남 6
 
2.8%
리 6
 
2.8%
온 5
 
2.3%
제 5
 
2.3%
누 5
 
2.3%
한 4
 
1.9%
로 4
 
1.9%
Other values (70) 91
42.1%
ASCII
ValueCountFrequency (%)
2
50.0%
2 2
50.0%

약국주소
Text

UNIQUE 

Distinct42
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size468.0 B
2023-12-12T20:53:19.160371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length21
Mean length16.595238
Min length14

Characters and Unicode

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

Unique

Unique42 ?
Unique (%)100.0%

Sample

1st row전라북도 남원시 광한서로 57
2nd row전라북도 남원시 의총로 67
3rd row전라북도 남원시 남문로 436-1
4th row전라북도 남원시 춘향로 32
5th row전라북도 남원시 남문로 425
ValueCountFrequency (%)
전라북도 41
23.3%
남원시 41
23.3%
남문로 9
 
5.1%
용성로 7
 
4.0%
의총로 4
 
2.3%
동림로 4
 
2.3%
인월면 3
 
1.7%
57 2
 
1.1%
인월로 2
 
1.1%
춘향로 2
 
1.1%
Other values (58) 61
34.7%
2023-12-12T20:53:19.604731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
134
19.2%
남 51
 
7.3%
시 45
 
6.5%
북 43
 
6.2%
전 42
 
6.0%
도 42
 
6.0%
라 41
 
5.9%
원 41
 
5.9%
로 37
 
5.3%
1 22
 
3.2%
Other values (51) 199
28.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 447
64.1%
Space Separator 134
 
19.2%
Decimal Number 110
 
15.8%
Dash Punctuation 5
 
0.7%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
남 51
11.4%
시 45
10.1%
북 43
9.6%
전 42
9.4%
도 42
9.4%
라 41
9.2%
원 41
9.2%
로 37
8.3%
문 12
 
2.7%
용 7
 
1.6%
Other values (38) 86
19.2%
Decimal Number
ValueCountFrequency (%)
1 22
20.0%
2 14
12.7%
3 14
12.7%
5 13
11.8%
4 12
10.9%
0 10
9.1%
6 9
8.2%
9 8
 
7.3%
7 4
 
3.6%
8 4
 
3.6%
Space Separator
ValueCountFrequency (%)
134
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 447
64.1%
Common 250
35.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
남 51
11.4%
시 45
10.1%
북 43
9.6%
전 42
9.4%
도 42
9.4%
라 41
9.2%
원 41
9.2%
로 37
8.3%
문 12
 
2.7%
용 7
 
1.6%
Other values (38) 86
19.2%
Common
ValueCountFrequency (%)
134
53.6%
1 22
 
8.8%
2 14
 
5.6%
3 14
 
5.6%
5 13
 
5.2%
4 12
 
4.8%
0 10
 
4.0%
6 9
 
3.6%
9 8
 
3.2%
- 5
 
2.0%
Other values (3) 9
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 447
64.1%
ASCII 250
35.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
134
53.6%
1 22
 
8.8%
2 14
 
5.6%
3 14
 
5.6%
5 13
 
5.2%
4 12
 
4.8%
0 10
 
4.0%
6 9
 
3.6%
9 8
 
3.2%
- 5
 
2.0%
Other values (3) 9
 
3.6%
Hangul
ValueCountFrequency (%)
남 51
11.4%
시 45
10.1%
북 43
9.6%
전 42
9.4%
도 42
9.4%
라 41
9.2%
원 41
9.2%
로 37
8.3%
문 12
 
2.7%
용 7
 
1.6%
Other values (38) 86
19.2%

전화번호
Text

UNIQUE 

Distinct42
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size468.0 B
2023-12-12T20:53:19.895495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique42 ?
Unique (%)100.0%

Sample

1st row063-625-2249
2nd row063-625-2721
3rd row063-625-4068
4th row063-625-2654
5th row063-625-2345
ValueCountFrequency (%)
063-625-2249 1
 
2.4%
063-633-1458 1
 
2.4%
063-625-9368 1
 
2.4%
063-632-7272 1
 
2.4%
063-632-1199 1
 
2.4%
063-625-1569 1
 
2.4%
063-632-7306 1
 
2.4%
063-634-3023 1
 
2.4%
063-634-7770 1
 
2.4%
063-636-2017 1
 
2.4%
Other values (32) 32
76.2%
2023-12-12T20:53:20.404130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 104
20.6%
3 97
19.2%
- 84
16.7%
0 61
12.1%
2 44
8.7%
1 23
 
4.6%
5 22
 
4.4%
9 20
 
4.0%
7 20
 
4.0%
4 15
 
3.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 420
83.3%
Dash Punctuation 84
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 104
24.8%
3 97
23.1%
0 61
14.5%
2 44
10.5%
1 23
 
5.5%
5 22
 
5.2%
9 20
 
4.8%
7 20
 
4.8%
4 15
 
3.6%
8 14
 
3.3%
Dash Punctuation
ValueCountFrequency (%)
- 84
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 504
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
6 104
20.6%
3 97
19.2%
- 84
16.7%
0 61
12.1%
2 44
8.7%
1 23
 
4.6%
5 22
 
4.4%
9 20
 
4.0%
7 20
 
4.0%
4 15
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 504
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 104
20.6%
3 97
19.2%
- 84
16.7%
0 61
12.1%
2 44
8.7%
1 23
 
4.6%
5 22
 
4.4%
9 20
 
4.0%
7 20
 
4.0%
4 15
 
3.0%

동물의약품
Categorical

IMBALANCE 

Distinct2
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size468.0 B
X
40 
O
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowX
2nd rowX
3rd rowX
4th rowX
5th rowX

Common Values

ValueCountFrequency (%)
X 40
95.2%
O 2
 
4.8%

Length

2023-12-12T20:53:20.595395image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:53:20.750745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
x 40
95.2%
o 2
 
4.8%

데이터 기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size468.0 B
Minimum2021-09-27 00:00:00
Maximum2021-09-27 00:00:00
2023-12-12T20:53:20.861831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:53:21.027627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T20:53:17.250990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T20:53:21.160006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번약국명약국주소전화번호동물의약품
연번1.0001.0001.0001.0000.000
약국명1.0001.0001.0001.0001.000
약국주소1.0001.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.000
동물의약품0.0001.0001.0001.0001.000
2023-12-12T20:53:21.330034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번동물의약품
연번1.0000.000
동물의약품0.0001.000

Missing values

2023-12-12T20:53:17.404311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:53:17.568300image/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위생약국전라북도 남원시 광한서로 57063-625-2249X2021-09-27
12윤약국전라북도 남원시 의총로 67063-625-2721X2021-09-27
23삼진약국전라북도 남원시 남문로 436-1063-625-4068X2021-09-27
34영진약국전라북도 남원시 춘향로 32063-625-2654X2021-09-27
45구세당약국전라북도 남원시 남문로 425063-625-2345X2021-09-27
56만인약국전라북도 남원시 동림로 105063-632-1698X2021-09-27
67길남약국전라북도 남원시 동문로 13-4063-633-3868X2021-09-27
78남원백제약국전라북도 남운시 용성로 102063-633-1233X2021-09-27
89서남온누리약국전라북도 남원시 시청로 59063-632-2488X2021-09-27
910남원종로약국전라북도 남원시 용성로 222063-636-8287X2021-09-27
연번약국명약국주소전화번호동물의약품데이터 기준일자
3233시장종로약국전라북도 남원시 의총로 43063-632-9913X2021-09-27
3334이백백제약국전라북도 남원시 이백면 문화안길 3063-635-2121X2021-09-27
3435운봉백제약국전라북도 남원시 운봉읍 운봉로 696063-634-7000X2021-09-27
3536지리산약국전라북도 남원시 시청로 5063-636-3007X2021-09-27
3637수온누리약국전라북도 남원시 남문로 401063-634-2461X2021-09-27
3738녹십자온누리약국전라북도 남원시 용성로 121063-635-8295X2021-09-27
3839소담 한약국전라북도 남원시 당산길 52063-636-0168X2021-09-27
3940참조은약국전라북도 남원시 용성로 114063-635-7593X2021-09-27
404122세기약국전라북도 남원시 춘향로 96, 롯데마트 1층063-625-9368X2021-09-27
4142본초한약국전라북도 남원시 남문로 400063-632-6263X2021-09-27