Overview

Dataset statistics

Number of variables7
Number of observations52
Missing cells18
Missing cells (%)4.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.0 KiB
Average record size in memory59.5 B

Variable types

Numeric1
Categorical1
Text4
DateTime1

Dataset

Description약사법 제20조에 의거 개설등록 한 업소로써 전라남도 나주시 관내 약국(한약국 포함) 현황(명칭, 소재지, 전화번호 등) 정보 제공
Author전라남도 나주시
URLhttps://www.data.go.kr/data/15082966/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
구분 is highly imbalanced (76.5%)Imbalance
약국소재지 has 8 (15.4%) missing valuesMissing
전화번호 has 9 (17.3%) missing valuesMissing
데이터기준일자 has 1 (1.9%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 20:04:41.490143
Analysis finished2023-12-12 20:04:42.351598
Duration0.86 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct52
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean26.5
Minimum1
Maximum52
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size600.0 B
2023-12-13T05:04:42.440579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.55
Q113.75
median26.5
Q339.25
95-th percentile49.45
Maximum52
Range51
Interquartile range (IQR)25.5

Descriptive statistics

Standard deviation15.154757
Coefficient of variation (CV)0.57187763
Kurtosis-1.2
Mean26.5
Median Absolute Deviation (MAD)13
Skewness0
Sum1378
Variance229.66667
MonotonicityStrictly increasing
2023-12-13T05:04:42.615054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.9%
28 1
 
1.9%
30 1
 
1.9%
31 1
 
1.9%
32 1
 
1.9%
33 1
 
1.9%
34 1
 
1.9%
35 1
 
1.9%
36 1
 
1.9%
37 1
 
1.9%
Other values (42) 42
80.8%
ValueCountFrequency (%)
1 1
1.9%
2 1
1.9%
3 1
1.9%
4 1
1.9%
5 1
1.9%
6 1
1.9%
7 1
1.9%
8 1
1.9%
9 1
1.9%
10 1
1.9%
ValueCountFrequency (%)
52 1
1.9%
51 1
1.9%
50 1
1.9%
49 1
1.9%
48 1
1.9%
47 1
1.9%
46 1
1.9%
45 1
1.9%
44 1
1.9%
43 1
1.9%

구분
Categorical

IMBALANCE 

Distinct2
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size548.0 B
약국
50 
한약국
 
2

Length

Max length3
Median length2
Mean length2.0384615
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
약국 50
96.2%
한약국 2
 
3.8%

Length

2023-12-13T05:04:42.814153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:04:42.923202image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 50
96.2%
한약국 2
 
3.8%
Distinct50
Distinct (%)96.2%
Missing0
Missing (%)0.0%
Memory size548.0 B
2023-12-13T05:04:43.151626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length8
Mean length5.1730769
Min length3

Characters and Unicode

Total characters269
Distinct characters90
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

Unique48 ?
Unique (%)92.3%

Sample

1st row강변약국
2nd row나주태평양약국
3rd row나주친절약국
4th row365 종로약국
5th row나주하나약국
ValueCountFrequency (%)
성모약국 2
 
3.4%
365 2
 
3.4%
종로약국 2
 
3.4%
농민약국 2
 
3.4%
건강약국 1
 
1.7%
한솔약국 1
 
1.7%
솔약국 1
 
1.7%
뉴욕약국 1
 
1.7%
신동아약국 1
 
1.7%
보건당약국 1
 
1.7%
Other values (44) 44
75.9%
2023-12-13T05:04:43.597237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
53
19.7%
52
19.3%
8
 
3.0%
6
 
2.2%
6
 
2.2%
6
 
2.2%
5
 
1.9%
5
 
1.9%
5
 
1.9%
4
 
1.5%
Other values (80) 119
44.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 257
95.5%
Space Separator 6
 
2.2%
Decimal Number 6
 
2.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
53
20.6%
52
20.2%
8
 
3.1%
6
 
2.3%
6
 
2.3%
5
 
1.9%
5
 
1.9%
5
 
1.9%
4
 
1.6%
4
 
1.6%
Other values (76) 109
42.4%
Decimal Number
ValueCountFrequency (%)
3 2
33.3%
6 2
33.3%
5 2
33.3%
Space Separator
ValueCountFrequency (%)
6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 257
95.5%
Common 12
 
4.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
53
20.6%
52
20.2%
8
 
3.1%
6
 
2.3%
6
 
2.3%
5
 
1.9%
5
 
1.9%
5
 
1.9%
4
 
1.6%
4
 
1.6%
Other values (76) 109
42.4%
Common
ValueCountFrequency (%)
6
50.0%
3 2
 
16.7%
6 2
 
16.7%
5 2
 
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 257
95.5%
ASCII 12
 
4.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
53
20.6%
52
20.2%
8
 
3.1%
6
 
2.3%
6
 
2.3%
5
 
1.9%
5
 
1.9%
5
 
1.9%
4
 
1.6%
4
 
1.6%
Other values (76) 109
42.4%
ASCII
ValueCountFrequency (%)
6
50.0%
3 2
 
16.7%
6 2
 
16.7%
5 2
 
16.7%

약국소재지
Text

MISSING 

Distinct42
Distinct (%)95.5%
Missing8
Missing (%)15.4%
Memory size548.0 B
2023-12-13T05:04:43.907058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length38
Median length31
Mean length21.204545
Min length12

Characters and Unicode

Total characters933
Distinct characters80
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

Unique40 ?
Unique (%)90.9%

Sample

1st row전라남도 나주시 남평읍 동사리 363-1
2nd row전라남도 나주시 중앙동 4-11
3rd row전라남도 나주시 성북동 138-18
4th row전라남도 나주시 대호동 1031-1
5th row전라남도 나주시 빛가람동 235번지 3호
ValueCountFrequency (%)
전라남도 44
20.3%
나주시 44
20.3%
성북동 7
 
3.2%
빛가람동 7
 
3.2%
1호 6
 
2.8%
남평읍 6
 
2.8%
중앙동 5
 
2.3%
남평리 4
 
1.8%
2호 4
 
1.8%
이창동 4
 
1.8%
Other values (70) 86
39.6%
2023-12-13T05:04:44.406871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
174
18.6%
55
 
5.9%
47
 
5.0%
44
 
4.7%
44
 
4.7%
44
 
4.7%
44
 
4.7%
44
 
4.7%
1 35
 
3.8%
32
 
3.4%
Other values (70) 370
39.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 622
66.7%
Space Separator 174
 
18.6%
Decimal Number 133
 
14.3%
Dash Punctuation 4
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
55
 
8.8%
47
 
7.6%
44
 
7.1%
44
 
7.1%
44
 
7.1%
44
 
7.1%
44
 
7.1%
32
 
5.1%
32
 
5.1%
31
 
5.0%
Other values (58) 205
33.0%
Decimal Number
ValueCountFrequency (%)
1 35
26.3%
3 20
15.0%
2 17
12.8%
8 12
 
9.0%
9 11
 
8.3%
4 11
 
8.3%
6 11
 
8.3%
7 8
 
6.0%
5 6
 
4.5%
0 2
 
1.5%
Space Separator
ValueCountFrequency (%)
174
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 622
66.7%
Common 311
33.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
55
 
8.8%
47
 
7.6%
44
 
7.1%
44
 
7.1%
44
 
7.1%
44
 
7.1%
44
 
7.1%
32
 
5.1%
32
 
5.1%
31
 
5.0%
Other values (58) 205
33.0%
Common
ValueCountFrequency (%)
174
55.9%
1 35
 
11.3%
3 20
 
6.4%
2 17
 
5.5%
8 12
 
3.9%
9 11
 
3.5%
4 11
 
3.5%
6 11
 
3.5%
7 8
 
2.6%
5 6
 
1.9%
Other values (2) 6
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 622
66.7%
ASCII 311
33.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
174
55.9%
1 35
 
11.3%
3 20
 
6.4%
2 17
 
5.5%
8 12
 
3.9%
9 11
 
3.5%
4 11
 
3.5%
6 11
 
3.5%
7 8
 
2.6%
5 6
 
1.9%
Other values (2) 6
 
1.9%
Hangul
ValueCountFrequency (%)
55
 
8.8%
47
 
7.6%
44
 
7.1%
44
 
7.1%
44
 
7.1%
44
 
7.1%
44
 
7.1%
32
 
5.1%
32
 
5.1%
31
 
5.0%
Other values (58) 205
33.0%
Distinct50
Distinct (%)96.2%
Missing0
Missing (%)0.0%
Memory size548.0 B
2023-12-13T05:04:44.789187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length37
Median length32
Mean length24.807692
Min length19

Characters and Unicode

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

Unique

Unique48 ?
Unique (%)92.3%

Sample

1st row전라남도 나주시 남평읍 강변2길 5-11, 102호
2nd row전라남도 나주시 나주로 197, 1층 (중앙동)
3rd row전라남도 나주시 영산로 5426, 1층 102호 (성북동)
4th row전라남도 나주시 대호길 85-1, 1층 (대호동)
5th row전라남도 나주시 정보화길 50, 103호 (빛가람동)
ValueCountFrequency (%)
전라남도 52
18.2%
나주시 52
18.2%
빛가람동 10
 
3.5%
나주로 10
 
3.5%
성북동 8
 
2.8%
남평읍 8
 
2.8%
1층 8
 
2.8%
중앙동 6
 
2.1%
남평1로 5
 
1.7%
이창동 5
 
1.7%
Other values (98) 122
42.7%
2023-12-13T05:04:45.637197image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
234
18.1%
69
 
5.3%
62
 
4.8%
62
 
4.8%
1 58
 
4.5%
57
 
4.4%
53
 
4.1%
53
 
4.1%
53
 
4.1%
41
 
3.2%
Other values (79) 548
42.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 748
58.0%
Space Separator 234
 
18.1%
Decimal Number 208
 
16.1%
Open Punctuation 33
 
2.6%
Close Punctuation 33
 
2.6%
Other Punctuation 24
 
1.9%
Dash Punctuation 8
 
0.6%
Math Symbol 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
69
 
9.2%
62
 
8.3%
62
 
8.3%
57
 
7.6%
53
 
7.1%
53
 
7.1%
53
 
7.1%
41
 
5.5%
37
 
4.9%
15
 
2.0%
Other values (63) 246
32.9%
Decimal Number
ValueCountFrequency (%)
1 58
27.9%
2 33
15.9%
0 26
12.5%
5 18
 
8.7%
3 15
 
7.2%
4 15
 
7.2%
9 12
 
5.8%
7 11
 
5.3%
8 10
 
4.8%
6 10
 
4.8%
Space Separator
ValueCountFrequency (%)
234
100.0%
Open Punctuation
ValueCountFrequency (%)
( 33
100.0%
Close Punctuation
ValueCountFrequency (%)
) 33
100.0%
Other Punctuation
ValueCountFrequency (%)
, 24
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 748
58.0%
Common 542
42.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
69
 
9.2%
62
 
8.3%
62
 
8.3%
57
 
7.6%
53
 
7.1%
53
 
7.1%
53
 
7.1%
41
 
5.5%
37
 
4.9%
15
 
2.0%
Other values (63) 246
32.9%
Common
ValueCountFrequency (%)
234
43.2%
1 58
 
10.7%
( 33
 
6.1%
2 33
 
6.1%
) 33
 
6.1%
0 26
 
4.8%
, 24
 
4.4%
5 18
 
3.3%
3 15
 
2.8%
4 15
 
2.8%
Other values (6) 53
 
9.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 748
58.0%
ASCII 542
42.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
234
43.2%
1 58
 
10.7%
( 33
 
6.1%
2 33
 
6.1%
) 33
 
6.1%
0 26
 
4.8%
, 24
 
4.4%
5 18
 
3.3%
3 15
 
2.8%
4 15
 
2.8%
Other values (6) 53
 
9.8%
Hangul
ValueCountFrequency (%)
69
 
9.2%
62
 
8.3%
62
 
8.3%
57
 
7.6%
53
 
7.1%
53
 
7.1%
53
 
7.1%
41
 
5.5%
37
 
4.9%
15
 
2.0%
Other values (63) 246
32.9%

전화번호
Text

MISSING 

Distinct43
Distinct (%)100.0%
Missing9
Missing (%)17.3%
Memory size548.0 B
2023-12-13T05:04:45.913367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.906977
Min length8

Characters and Unicode

Total characters512
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique43 ?
Unique (%)100.0%

Sample

1st row061-332-7577
2nd row061-334-3323
3rd row061-332-1119
4th row061-820-8484
5th row061-336-2025
ValueCountFrequency (%)
061-332-7577 1
 
2.2%
061-333-8773 1
 
2.2%
061-332-7585 1
 
2.2%
333-2146 1
 
2.2%
061-333-3350 1
 
2.2%
061-334-1688 1
 
2.2%
061-332-5505 1
 
2.2%
061-331-5225 1
 
2.2%
061-333-8275 1
 
2.2%
061-331-2235 1
 
2.2%
Other values (35) 35
77.8%
2023-12-13T05:04:46.321091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 107
20.9%
- 83
16.2%
1 63
12.3%
0 60
11.7%
6 56
10.9%
2 32
 
6.2%
5 32
 
6.2%
8 23
 
4.5%
7 22
 
4.3%
4 19
 
3.7%
Other values (2) 15
 
2.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 427
83.4%
Dash Punctuation 83
 
16.2%
Space Separator 2
 
0.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 107
25.1%
1 63
14.8%
0 60
14.1%
6 56
13.1%
2 32
 
7.5%
5 32
 
7.5%
8 23
 
5.4%
7 22
 
5.2%
4 19
 
4.4%
9 13
 
3.0%
Dash Punctuation
ValueCountFrequency (%)
- 83
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 512
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 107
20.9%
- 83
16.2%
1 63
12.3%
0 60
11.7%
6 56
10.9%
2 32
 
6.2%
5 32
 
6.2%
8 23
 
4.5%
7 22
 
4.3%
4 19
 
3.7%
Other values (2) 15
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 512
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 107
20.9%
- 83
16.2%
1 63
12.3%
0 60
11.7%
6 56
10.9%
2 32
 
6.2%
5 32
 
6.2%
8 23
 
4.5%
7 22
 
4.3%
4 19
 
3.7%
Other values (2) 15
 
2.9%

데이터기준일자
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)2.0%
Missing1
Missing (%)1.9%
Memory size548.0 B
Minimum2021-11-01 00:00:00
Maximum2021-11-01 00:00:00
2023-12-13T05:04:46.445793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:04:46.535277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T05:04:41.906568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:04:46.617588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번구분약국명칭약국소재지약국소재지(도로명)전화번호
순번1.0000.0001.0001.0001.0001.000
구분0.0001.0001.0001.0001.0001.000
약국명칭1.0001.0001.0001.0001.0001.000
약국소재지1.0001.0001.0001.0001.0001.000
약국소재지(도로명)1.0001.0001.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.0001.000
2023-12-13T05:04:46.751304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번구분
순번1.0000.000
구분0.0001.000

Missing values

2023-12-13T05:04:42.033761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:04:42.163106image/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.
2023-12-13T05:04:42.277690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

순번구분약국명칭약국소재지약국소재지(도로명)전화번호데이터기준일자
01약국강변약국전라남도 나주시 남평읍 동사리 363-1전라남도 나주시 남평읍 강변2길 5-11, 102호<NA>2021-11-01
12약국나주태평양약국전라남도 나주시 중앙동 4-11전라남도 나주시 나주로 197, 1층 (중앙동)061-332-75772021-11-01
23약국나주친절약국전라남도 나주시 성북동 138-18전라남도 나주시 영산로 5426, 1층 102호 (성북동)061-334-33232021-11-01
34한약국365 종로약국전라남도 나주시 대호동 1031-1전라남도 나주시 대호길 85-1, 1층 (대호동)<NA>2021-11-01
45약국나주하나약국전라남도 나주시 빛가람동 235번지 3호전라남도 나주시 정보화길 50, 103호 (빛가람동)<NA>2021-11-01
56약국희망약국전라남도 나주시 빛가람동 194번지 2호전라남도 나주시 상야2길 22, 선도타워 1층 104호 (빛가람동)061-332-11192021-11-01
67약국빛가람포도약국전라남도 나주시 빛가람동 338번지 1호전라남도 나주시 중야2길 29, 103,104,105호 (빛가람동)061-820-84842021-11-01
78약국동강제일약국전라남도 나주시 동강면 월양리 311번지 2호 동강제일약국전라남도 나주시 동강면 동강로 590, 동강제일약국061-336-20252021-11-01
89약국새서울약국전라남도 나주시 금천면 오강리 249번지 1호전라남도 나주시 금천면 금영로 942061-331-71162021-11-01
910약국나주온누리약국전라남도 나주시 성북동 139번지 7호 한양타월인쇄전라남도 나주시 영산로 5422 (성북동)061-334-23982021-11-01
순번구분약국명칭약국소재지약국소재지(도로명)전화번호데이터기준일자
4243약국농민약국전라남도 나주시 이창동전라남도 나주시 예향로 3813 (이창동)061-332-04452021-11-01
4344약국농민약국전라남도 나주시 이창동전라남도 나주시 예향로 3813 (이창동)062-655-48102021-11-01
4445약국지리산약국전라남도 나주시 성북동전라남도 나주시 나주로 205 (성북동)061-332-75122021-11-01
4546약국목사골한국약국전라남도 나주시 성북동전라남도 나주시 나주로 204 (성북동)061-337-94492021-11-01
4647약국건강한약국전라남도 나주시 다시면 영동리 428번지전라남도 나주시 다시면 다시로 182061-335-75592021-11-01
4748약국건강약국전라남도 나주시 남평읍 대교리전라남도 나주시 남평읍 남평2로 14061-333-52102021-11-01
4849약국한솔약국전라남도 나주시 남평읍 남평리전라남도 나주시 남평읍 남평1로 55061-331-78892021-11-01
4950약국다시약국전라남도 나주시 다시면 월태리 611번지 58호전라남도 나주시 다시면 다시로 169061-336-86382021-11-01
5051약국종로약국전라남도 나주시 영산동전라남도 나주시 예향로 3873-2 (영산동)061-332-40042021-11-01
5152약국온누리백제약국전라남도 나주시 중앙동 3번지전라남도 나주시 동점문길 5 (중앙동)<NA><NA>