Overview

Dataset statistics

Number of variables9
Number of observations94
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.8 KiB
Average record size in memory74.4 B

Variable types

Numeric1
Text4
Categorical3
DateTime1

Dataset

Description경기도_양주시_약국 현황에 대한 데이터로 약국명칭, 개설자명, 주소, 전화번호, 구분, 의약분업 예외지역 여부 항목을 제공합니다.
URLhttps://www.data.go.kr/data/3079715/fileData.do

Alerts

약국구분 has constant value ""Constant
관리기관명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
순번 is highly overall correlated with 의약분업예외지역High correlation
의약분업예외지역 is highly overall correlated with 순번High correlation
의약분업예외지역 is highly imbalanced (51.1%)Imbalance
순번 has unique valuesUnique
개설자명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 00:03:57.656902
Analysis finished2023-12-12 00:03:58.429635
Duration0.77 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct94
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean47.5
Minimum1
Maximum94
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size978.0 B
2023-12-12T09:03:58.497332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5.65
Q124.25
median47.5
Q370.75
95-th percentile89.35
Maximum94
Range93
Interquartile range (IQR)46.5

Descriptive statistics

Standard deviation27.279418
Coefficient of variation (CV)0.57430354
Kurtosis-1.2
Mean47.5
Median Absolute Deviation (MAD)23.5
Skewness0
Sum4465
Variance744.16667
MonotonicityStrictly increasing
2023-12-12T09:03:58.629352image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.1%
61 1
 
1.1%
70 1
 
1.1%
69 1
 
1.1%
68 1
 
1.1%
67 1
 
1.1%
66 1
 
1.1%
65 1
 
1.1%
64 1
 
1.1%
63 1
 
1.1%
Other values (84) 84
89.4%
ValueCountFrequency (%)
1 1
1.1%
2 1
1.1%
3 1
1.1%
4 1
1.1%
5 1
1.1%
6 1
1.1%
7 1
1.1%
8 1
1.1%
9 1
1.1%
10 1
1.1%
ValueCountFrequency (%)
94 1
1.1%
93 1
1.1%
92 1
1.1%
91 1
1.1%
90 1
1.1%
89 1
1.1%
88 1
1.1%
87 1
1.1%
86 1
1.1%
85 1
1.1%
Distinct92
Distinct (%)97.9%
Missing0
Missing (%)0.0%
Memory size884.0 B
2023-12-12T09:03:58.858819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length8
Mean length4.9468085
Min length3

Characters and Unicode

Total characters465
Distinct characters126
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

Unique91 ?
Unique (%)96.8%

Sample

1st row레몬약국
2nd row옥정중앙약국
3rd row회천메디칼약국
4th row나무약국
5th row선암건강약국
ValueCountFrequency (%)
약국 5
 
5.0%
우리약국 3
 
3.0%
가까운약국 2
 
2.0%
다나약국 1
 
1.0%
중앙약국 1
 
1.0%
신양주종로약국 1
 
1.0%
아침향기약국 1
 
1.0%
미소약국 1
 
1.0%
녹십자약국 1
 
1.0%
다사랑 1
 
1.0%
Other values (83) 83
83.0%
2023-12-12T09:03:59.195992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
95
20.4%
95
20.4%
11
 
2.4%
11
 
2.4%
8
 
1.7%
7
 
1.5%
7
 
1.5%
7
 
1.5%
6
 
1.3%
6
 
1.3%
Other values (116) 212
45.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 456
98.1%
Space Separator 6
 
1.3%
Decimal Number 3
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
95
20.8%
95
20.8%
11
 
2.4%
11
 
2.4%
8
 
1.8%
7
 
1.5%
7
 
1.5%
7
 
1.5%
6
 
1.3%
6
 
1.3%
Other values (112) 203
44.5%
Decimal Number
ValueCountFrequency (%)
6 1
33.3%
5 1
33.3%
3 1
33.3%
Space Separator
ValueCountFrequency (%)
6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 456
98.1%
Common 9
 
1.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
95
20.8%
95
20.8%
11
 
2.4%
11
 
2.4%
8
 
1.8%
7
 
1.5%
7
 
1.5%
7
 
1.5%
6
 
1.3%
6
 
1.3%
Other values (112) 203
44.5%
Common
ValueCountFrequency (%)
6
66.7%
6 1
 
11.1%
5 1
 
11.1%
3 1
 
11.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 456
98.1%
ASCII 9
 
1.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
95
20.8%
95
20.8%
11
 
2.4%
11
 
2.4%
8
 
1.8%
7
 
1.5%
7
 
1.5%
7
 
1.5%
6
 
1.3%
6
 
1.3%
Other values (112) 203
44.5%
ASCII
ValueCountFrequency (%)
6
66.7%
6 1
 
11.1%
5 1
 
11.1%
3 1
 
11.1%
Distinct93
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Memory size884.0 B
2023-12-12T09:03:59.408975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.06383
Min length12

Characters and Unicode

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

Unique92 ?
Unique (%)97.9%

Sample

1st row031-822-7742
2nd row031-858-8677
3rd row031-868-9936
4th row031-822-7414
5th row031-858-1358
ValueCountFrequency (%)
031-858-0064 2
 
2.1%
031-841-3351 1
 
1.1%
031-857-3354 1
 
1.1%
031-858-7227 1
 
1.1%
031-855-1400 1
 
1.1%
031-862-8575 1
 
1.1%
031-863-0824 1
 
1.1%
031-847-5393 1
 
1.1%
031-841-7700 1
 
1.1%
031-857-0667 1
 
1.1%
Other values (83) 83
88.3%
2023-12-12T09:03:59.744985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 186
16.4%
8 163
14.4%
1 151
13.3%
0 136
12.0%
3 133
11.7%
5 84
7.4%
7 75
6.6%
6 69
 
6.1%
2 50
 
4.4%
4 45
 
4.0%
Other values (2) 42
 
3.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 946
83.4%
Dash Punctuation 186
 
16.4%
Other Punctuation 2
 
0.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
8 163
17.2%
1 151
16.0%
0 136
14.4%
3 133
14.1%
5 84
8.9%
7 75
7.9%
6 69
7.3%
2 50
 
5.3%
4 45
 
4.8%
9 40
 
4.2%
Dash Punctuation
ValueCountFrequency (%)
- 186
100.0%
Other Punctuation
ValueCountFrequency (%)
. 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1134
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 186
16.4%
8 163
14.4%
1 151
13.3%
0 136
12.0%
3 133
11.7%
5 84
7.4%
7 75
6.6%
6 69
 
6.1%
2 50
 
4.4%
4 45
 
4.0%
Other values (2) 42
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1134
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 186
16.4%
8 163
14.4%
1 151
13.3%
0 136
12.0%
3 133
11.7%
5 84
7.4%
7 75
6.6%
6 69
 
6.1%
2 50
 
4.4%
4 45
 
4.0%
Other values (2) 42
 
3.7%
Distinct93
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Memory size884.0 B
2023-12-12T09:04:00.119216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length51
Median length39
Mean length27.468085
Min length17

Characters and Unicode

Total characters2582
Distinct characters130
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

Unique92 ?
Unique (%)97.9%

Sample

1st row경기도 양주시 회천중앙로 248, 스타프라자 108호 (덕계동)
2nd row경기도 양주시 옥정서로 221, 104호 (옥정동)
3rd row경기도 양주시 덕계로 140, 진산메디프라자 103호 (덕계동)
4th row경기도 양주시 옥정로 208, 선양프라자 109호 (옥정동)
5th row경기도 양주시 은현면 그루고개로 703, 1층 일부
ValueCountFrequency (%)
경기도 94
 
16.3%
양주시 94
 
16.3%
옥정동 17
 
3.0%
덕정동 16
 
2.8%
덕계동 14
 
2.4%
1층 14
 
2.4%
회정로 11
 
1.9%
백석읍 10
 
1.7%
평화로 8
 
1.4%
옥정로 8
 
1.4%
Other values (177) 289
50.3%
2023-12-12T09:04:01.003951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
485
 
18.8%
1 138
 
5.3%
106
 
4.1%
105
 
4.1%
96
 
3.7%
94
 
3.6%
94
 
3.6%
94
 
3.6%
85
 
3.3%
72
 
2.8%
Other values (120) 1213
47.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1440
55.8%
Space Separator 485
 
18.8%
Decimal Number 456
 
17.7%
Close Punctuation 65
 
2.5%
Open Punctuation 65
 
2.5%
Other Punctuation 64
 
2.5%
Dash Punctuation 6
 
0.2%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
106
 
7.4%
105
 
7.3%
96
 
6.7%
94
 
6.5%
94
 
6.5%
94
 
6.5%
85
 
5.9%
72
 
5.0%
65
 
4.5%
46
 
3.2%
Other values (104) 583
40.5%
Decimal Number
ValueCountFrequency (%)
1 138
30.3%
0 63
13.8%
2 46
 
10.1%
3 46
 
10.1%
4 44
 
9.6%
8 31
 
6.8%
5 29
 
6.4%
6 22
 
4.8%
7 20
 
4.4%
9 17
 
3.7%
Space Separator
ValueCountFrequency (%)
485
100.0%
Close Punctuation
ValueCountFrequency (%)
) 65
100.0%
Open Punctuation
ValueCountFrequency (%)
( 65
100.0%
Other Punctuation
ValueCountFrequency (%)
, 64
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1440
55.8%
Common 1141
44.2%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
106
 
7.4%
105
 
7.3%
96
 
6.7%
94
 
6.5%
94
 
6.5%
94
 
6.5%
85
 
5.9%
72
 
5.0%
65
 
4.5%
46
 
3.2%
Other values (104) 583
40.5%
Common
ValueCountFrequency (%)
485
42.5%
1 138
 
12.1%
) 65
 
5.7%
( 65
 
5.7%
, 64
 
5.6%
0 63
 
5.5%
2 46
 
4.0%
3 46
 
4.0%
4 44
 
3.9%
8 31
 
2.7%
Other values (5) 94
 
8.2%
Latin
ValueCountFrequency (%)
e 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1440
55.8%
ASCII 1142
44.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
485
42.5%
1 138
 
12.1%
) 65
 
5.7%
( 65
 
5.7%
, 64
 
5.6%
0 63
 
5.5%
2 46
 
4.0%
3 46
 
4.0%
4 44
 
3.9%
8 31
 
2.7%
Other values (6) 95
 
8.3%
Hangul
ValueCountFrequency (%)
106
 
7.4%
105
 
7.3%
96
 
6.7%
94
 
6.5%
94
 
6.5%
94
 
6.5%
85
 
5.9%
72
 
5.0%
65
 
4.5%
46
 
3.2%
Other values (104) 583
40.5%

약국구분
Categorical

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size884.0 B
약국
94 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
약국 94
100.0%

Length

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

Common Values (Plot)

2023-12-12T09:04:01.253952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 94
100.0%

의약분업예외지역
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size884.0 B
<NA>
84 
10 

Length

Max length4
Median length4
Mean length3.6808511
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row

Common Values

ValueCountFrequency (%)
<NA> 84
89.4%
10
 
10.6%

Length

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

Common Values (Plot)

2023-12-12T09:04:01.466492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 84
89.4%
10
 
10.6%

개설자명
Text

UNIQUE 

Distinct94
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size884.0 B
2023-12-12T09:04:01.791055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.9787234
Min length2

Characters and Unicode

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

Unique

Unique94 ?
Unique (%)100.0%

Sample

1st row정민영
2nd row연성진
3rd row주찬양
4th row이유나
5th row이홍성
ValueCountFrequency (%)
정민영 1
 
1.1%
장명래 1
 
1.1%
이길범 1
 
1.1%
박종휘 1
 
1.1%
이종구 1
 
1.1%
윤상권 1
 
1.1%
정신한 1
 
1.1%
김유준 1
 
1.1%
박묘양 1
 
1.1%
이유희 1
 
1.1%
Other values (84) 84
89.4%
2023-12-12T09:04:02.233202image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
18
 
6.4%
18
 
6.4%
18
 
6.4%
11
 
3.9%
7
 
2.5%
7
 
2.5%
6
 
2.1%
6
 
2.1%
6
 
2.1%
6
 
2.1%
Other values (87) 177
63.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 280
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
18
 
6.4%
18
 
6.4%
18
 
6.4%
11
 
3.9%
7
 
2.5%
7
 
2.5%
6
 
2.1%
6
 
2.1%
6
 
2.1%
6
 
2.1%
Other values (87) 177
63.2%

Most occurring scripts

ValueCountFrequency (%)
Hangul 280
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
18
 
6.4%
18
 
6.4%
18
 
6.4%
11
 
3.9%
7
 
2.5%
7
 
2.5%
6
 
2.1%
6
 
2.1%
6
 
2.1%
6
 
2.1%
Other values (87) 177
63.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 280
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
18
 
6.4%
18
 
6.4%
18
 
6.4%
11
 
3.9%
7
 
2.5%
7
 
2.5%
6
 
2.1%
6
 
2.1%
6
 
2.1%
6
 
2.1%
Other values (87) 177
63.2%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size884.0 B
양주시 보건행정과
94 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row양주시 보건행정과
2nd row양주시 보건행정과
3rd row양주시 보건행정과
4th row양주시 보건행정과
5th row양주시 보건행정과

Common Values

ValueCountFrequency (%)
양주시 보건행정과 94
100.0%

Length

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

Common Values (Plot)

2023-12-12T09:04:02.462777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양주시 94
50.0%
보건행정과 94
50.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size884.0 B
Minimum2023-06-12 00:00:00
Maximum2023-06-12 00:00:00
2023-12-12T09:04:02.530788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:04:02.607468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T09:03:58.132713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T09:04:02.681887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번약국명칭약국전화번호약국소재지(도로명)개설자명
순번1.0000.9481.0001.0001.000
약국명칭0.9481.0001.0001.0001.000
약국전화번호1.0001.0001.0001.0001.000
약국소재지(도로명)1.0001.0001.0001.0001.000
개설자명1.0001.0001.0001.0001.000
2023-12-12T09:04:02.770879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번의약분업예외지역
순번1.0001.000
의약분업예외지역1.0001.000

Missing values

2023-12-12T09:03:58.233079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:03:58.381157image/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레몬약국031-822-7742경기도 양주시 회천중앙로 248, 스타프라자 108호 (덕계동)약국<NA>정민영양주시 보건행정과2023-06-12
12옥정중앙약국031-858-8677경기도 양주시 옥정서로 221, 104호 (옥정동)약국<NA>연성진양주시 보건행정과2023-06-12
23회천메디칼약국031-868-9936경기도 양주시 덕계로 140, 진산메디프라자 103호 (덕계동)약국<NA>주찬양양주시 보건행정과2023-06-12
34나무약국031-822-7414경기도 양주시 옥정로 208, 선양프라자 109호 (옥정동)약국<NA>이유나양주시 보건행정과2023-06-12
45선암건강약국031-858-1358경기도 양주시 은현면 그루고개로 703, 1층 일부약국이홍성양주시 보건행정과2023-06-12
56호수약국031-867-5111경기도 양주시 옥정동로 193 (옥정동)약국<NA>김란양주시 보건행정과2023-06-12
67백석사랑약국031-877-1388경기도 양주시 백석읍 양주산성로 573, 103호약국<NA>임수연양주시 보건행정과2023-06-12
78탄탄약국031-864-0888경기도 양주시 회천중앙로 252, 106호 (덕계동)약국<NA>최정희양주시 보건행정과2023-06-12
89성지 가까운약국070-8287-3555경기도 양주시 남면 개나리길 120약국<NA>전주현양주시 보건행정과2023-06-12
910오산약국031-829-9165경기도 양주시 백석읍 권율로 1345-1약국서수정양주시 보건행정과2023-06-12
순번약국명칭약국전화번호약국소재지(도로명)약국구분의약분업예외지역개설자명관리기관명데이터기준일자
8485명성약국031-855-7078경기도 양주시 백석읍 양주산성로 564약국<NA>김윤경양주시 보건행정과2023-06-12
8586가나약국031-879-3163경기도 양주시 백석읍 부흥로 1172-2약국이혜정양주시 보건행정과2023-06-12
8687삼성당약국031-855-2506경기도 양주시 백석읍 꿈나무로 4약국김채란양주시 보건행정과2023-06-12
8788은약국031-868-3273경기도 양주시 은현면 은현로 54약국박정대양주시 보건행정과2023-06-12
8889청춘약국031-859-7575경기도 양주시 화합로 1339 (덕정동)약국<NA>유규현양주시 보건행정과2023-06-12
8990송약국031-866-2218경기도 양주시 평화로1435번길 1 (덕계동)약국<NA>송치우양주시 보건행정과2023-06-12
9091양주약국031-840-1188경기도 양주시 은현면 은현로 508, 1층 105호약국양정규양주시 보건행정과2023-06-12
9192온누리약국031-861-1435경기도 양주시 남면 개나리11길 2약국<NA>홍정기양주시 보건행정과2023-06-12
9293가래비약국031-836-3882경기도 양주시 광적면 가래비길 87약국<NA>김문호양주시 보건행정과2023-06-12
9394감초당약국031-859-2219경기도 양주시 화합로 1357 (덕정동)약국<NA>조정행양주시 보건행정과2023-06-12