Overview

Dataset statistics

Number of variables5
Number of observations45
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.9 KiB
Average record size in memory43.9 B

Variable types

Numeric1
Text3
DateTime1

Dataset

Description경상남도 밀양시 약국 현황에 대한 자료로, 연번, 약국 명, 주소, 전화번호, 데이터 기준일자에 대한 정보를 제공합니다.
Author경상남도 밀양시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15103671

Alerts

데이터기준일자 has constant value ""Constant
연번 has unique valuesUnique
약국명 has unique valuesUnique
주소 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-10 23:38:13.341922
Analysis finished2023-12-10 23:38:14.129188
Duration0.79 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23
Minimum1
Maximum45
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size537.0 B
2023-12-11T08:38:14.222191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.2
Q112
median23
Q334
95-th percentile42.8
Maximum45
Range44
Interquartile range (IQR)22

Descriptive statistics

Standard deviation13.133926
Coefficient of variation (CV)0.57104024
Kurtosis-1.2
Mean23
Median Absolute Deviation (MAD)11
Skewness0
Sum1035
Variance172.5
MonotonicityStrictly increasing
2023-12-11T08:38:14.400908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
1 1
 
2.2%
35 1
 
2.2%
26 1
 
2.2%
27 1
 
2.2%
28 1
 
2.2%
29 1
 
2.2%
30 1
 
2.2%
31 1
 
2.2%
32 1
 
2.2%
33 1
 
2.2%
Other values (35) 35
77.8%
ValueCountFrequency (%)
1 1
2.2%
2 1
2.2%
3 1
2.2%
4 1
2.2%
5 1
2.2%
6 1
2.2%
7 1
2.2%
8 1
2.2%
9 1
2.2%
10 1
2.2%
ValueCountFrequency (%)
45 1
2.2%
44 1
2.2%
43 1
2.2%
42 1
2.2%
41 1
2.2%
40 1
2.2%
39 1
2.2%
38 1
2.2%
37 1
2.2%
36 1
2.2%

약국명
Text

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size492.0 B
2023-12-11T08:38:14.671285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length4
Mean length4.3777778
Min length3

Characters and Unicode

Total characters197
Distinct characters76
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

Unique45 ?
Unique (%)100.0%

Sample

1st row수성약국
2nd row삼랑진약국
3rd row하나약국
4th row세종셀메드약국
5th row삼성약국
ValueCountFrequency (%)
수성약국 1
 
2.2%
배약국 1
 
2.2%
안아약국 1
 
2.2%
명진약국 1
 
2.2%
우리들약국 1
 
2.2%
오약국 1
 
2.2%
소망약국 1
 
2.2%
예림약국 1
 
2.2%
행복약국 1
 
2.2%
새우리약국 1
 
2.2%
Other values (35) 35
77.8%
2023-12-11T08:38:15.040349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 45
22.8%
국 45
22.8%
제 4
 
2.0%
리 4
 
2.0%
수 3
 
1.5%
삼 3
 
1.5%
랑 3
 
1.5%
진 3
 
1.5%
밀 3
 
1.5%
일 3
 
1.5%
Other values (66) 81
41.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 197
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 45
22.8%
국 45
22.8%
제 4
 
2.0%
리 4
 
2.0%
수 3
 
1.5%
삼 3
 
1.5%
랑 3
 
1.5%
진 3
 
1.5%
밀 3
 
1.5%
일 3
 
1.5%
Other values (66) 81
41.1%

Most occurring scripts

ValueCountFrequency (%)
Hangul 197
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 45
22.8%
국 45
22.8%
제 4
 
2.0%
리 4
 
2.0%
수 3
 
1.5%
삼 3
 
1.5%
랑 3
 
1.5%
진 3
 
1.5%
밀 3
 
1.5%
일 3
 
1.5%
Other values (66) 81
41.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 197
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 45
22.8%
국 45
22.8%
제 4
 
2.0%
리 4
 
2.0%
수 3
 
1.5%
삼 3
 
1.5%
랑 3
 
1.5%
진 3
 
1.5%
밀 3
 
1.5%
일 3
 
1.5%
Other values (66) 81
41.1%

주소
Text

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size492.0 B
2023-12-11T08:38:15.289070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length23
Mean length19.022222
Min length15

Characters and Unicode

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

Unique

Unique45 ?
Unique (%)100.0%

Sample

1st row 밀양시 북성로 11-10 (내이동)
2nd row 밀양시 삼랑진읍 천태로 77
3rd row 밀양시 중앙로 227-1 (삼문동)
4th row 밀양시 삼문중앙로 49 (삼문동)
5th row 밀양시 북성로 11-2 (내이동)
ValueCountFrequency (%)
밀양시 45
23.8%
내이동 13
 
6.9%
중앙로 11
 
5.8%
삼문동 11
 
5.8%
삼문중앙로 6
 
3.2%
1층 6
 
3.2%
내일동 5
 
2.6%
하남읍 5
 
2.6%
삼랑진읍 4
 
2.1%
북성로 4
 
2.1%
Other values (68) 79
41.8%
2023-12-11T08:38:15.696856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
189
22.1%
밀 47
 
5.5%
양 46
 
5.4%
시 46
 
5.4%
로 39
 
4.6%
1 32
 
3.7%
( 32
 
3.7%
) 32
 
3.7%
동 31
 
3.6%
앙 22
 
2.6%
Other values (65) 340
39.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 457
53.4%
Space Separator 189
22.1%
Decimal Number 128
 
15.0%
Open Punctuation 32
 
3.7%
Close Punctuation 32
 
3.7%
Dash Punctuation 11
 
1.3%
Other Punctuation 7
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
밀 47
 
10.3%
양 46
 
10.1%
시 46
 
10.1%
로 39
 
8.5%
동 31
 
6.8%
앙 22
 
4.8%
중 22
 
4.8%
삼 22
 
4.8%
내 21
 
4.6%
문 18
 
3.9%
Other values (50) 143
31.3%
Decimal Number
ValueCountFrequency (%)
1 32
25.0%
3 21
16.4%
4 20
15.6%
7 10
 
7.8%
8 10
 
7.8%
2 10
 
7.8%
9 8
 
6.2%
6 6
 
4.7%
0 6
 
4.7%
5 5
 
3.9%
Space Separator
ValueCountFrequency (%)
189
100.0%
Open Punctuation
ValueCountFrequency (%)
( 32
100.0%
Close Punctuation
ValueCountFrequency (%)
) 32
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 11
100.0%
Other Punctuation
ValueCountFrequency (%)
, 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 457
53.4%
Common 399
46.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
밀 47
 
10.3%
양 46
 
10.1%
시 46
 
10.1%
로 39
 
8.5%
동 31
 
6.8%
앙 22
 
4.8%
중 22
 
4.8%
삼 22
 
4.8%
내 21
 
4.6%
문 18
 
3.9%
Other values (50) 143
31.3%
Common
ValueCountFrequency (%)
189
47.4%
1 32
 
8.0%
( 32
 
8.0%
) 32
 
8.0%
3 21
 
5.3%
4 20
 
5.0%
- 11
 
2.8%
7 10
 
2.5%
8 10
 
2.5%
2 10
 
2.5%
Other values (5) 32
 
8.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 457
53.4%
ASCII 399
46.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
189
47.4%
1 32
 
8.0%
( 32
 
8.0%
) 32
 
8.0%
3 21
 
5.3%
4 20
 
5.0%
- 11
 
2.8%
7 10
 
2.5%
8 10
 
2.5%
2 10
 
2.5%
Other values (5) 32
 
8.0%
Hangul
ValueCountFrequency (%)
밀 47
 
10.3%
양 46
 
10.1%
시 46
 
10.1%
로 39
 
8.5%
동 31
 
6.8%
앙 22
 
4.8%
중 22
 
4.8%
삼 22
 
4.8%
내 21
 
4.6%
문 18
 
3.9%
Other values (50) 143
31.3%

전화번호
Text

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size492.0 B
2023-12-11T08:38:15.995240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.022222
Min length12

Characters and Unicode

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

Unique45 ?
Unique (%)100.0%

Sample

1st row055-356-4356
2nd row055-351-1237
3rd row055-352-6540
4th row055-354-2704
5th row055-354-2304
ValueCountFrequency (%)
055-356-4356 1
 
2.2%
055-352-1314 1
 
2.2%
055-356-8091 1
 
2.2%
055-352-3524 1
 
2.2%
055-356-2914 1
 
2.2%
055-354-8607 1
 
2.2%
055-351-2193 1
 
2.2%
055-355-6004 1
 
2.2%
070-4388-0013 1
 
2.2%
055-391-6116 1
 
2.2%
Other values (35) 35
77.8%
2023-12-11T08:38:16.410460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 147
27.2%
- 87
16.1%
0 76
14.0%
3 64
11.8%
2 35
 
6.5%
4 29
 
5.4%
1 26
 
4.8%
6 25
 
4.6%
7 21
 
3.9%
9 17
 
3.1%
Other values (2) 14
 
2.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 451
83.4%
Dash Punctuation 87
 
16.1%
Close Punctuation 3
 
0.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 147
32.6%
0 76
16.9%
3 64
14.2%
2 35
 
7.8%
4 29
 
6.4%
1 26
 
5.8%
6 25
 
5.5%
7 21
 
4.7%
9 17
 
3.8%
8 11
 
2.4%
Dash Punctuation
ValueCountFrequency (%)
- 87
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 541
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 147
27.2%
- 87
16.1%
0 76
14.0%
3 64
11.8%
2 35
 
6.5%
4 29
 
5.4%
1 26
 
4.8%
6 25
 
4.6%
7 21
 
3.9%
9 17
 
3.1%
Other values (2) 14
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 541
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 147
27.2%
- 87
16.1%
0 76
14.0%
3 64
11.8%
2 35
 
6.5%
4 29
 
5.4%
1 26
 
4.8%
6 25
 
4.6%
7 21
 
3.9%
9 17
 
3.1%
Other values (2) 14
 
2.6%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size492.0 B
Minimum2023-08-21 00:00:00
Maximum2023-08-21 00:00:00
2023-12-11T08:38:16.536958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:38:16.638469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-11T08:38:13.581454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T08:38:16.709189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번약국명주소전화번호
연번1.0001.0001.0001.000
약국명1.0001.0001.0001.000
주소1.0001.0001.0001.000
전화번호1.0001.0001.0001.000

Missing values

2023-12-11T08:38:13.981442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T08:38:14.084875image/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수성약국밀양시 북성로 11-10 (내이동)055-356-43562023-08-21
12삼랑진약국밀양시 삼랑진읍 천태로 77055-351-12372023-08-21
23하나약국밀양시 중앙로 227-1 (삼문동)055-352-65402023-08-21
34세종셀메드약국밀양시 삼문중앙로 49 (삼문동)055-354-27042023-08-21
45삼성약국밀양시 북성로 11-2 (내이동)055-354-23042023-08-21
56규태약국밀양시 삼문중앙로 36-4 (삼문동)055-355-80122023-08-21
67햇살약국밀양시 미리벌중앙로 67, 1층 (삼문동)055-355-63312023-08-21
78보명약국밀양시 중앙로 119-1 (가곡동)055-354-32662023-08-21
89새봄약국밀양시 하남읍 초하로 746 (행복한마을아파트)055-391-17102023-08-21
910건강약국밀양시 중앙로 450 (내이동)055-352-02612023-08-21
연번약국명주소전화번호데이터기준일자
3536한사랑약국밀양시 하남읍 수산중앙로 17055-391-33492023-08-21
3637중앙약국밀양시 삼문중앙로 43 (삼문동)055-354-02422023-08-21
3738현대약국밀양시 삼문중앙로 37 (삼문동)055-354-20402023-08-21
3839푸른약국밀양시 밀성로 14 (내이동)055-354-99272023-08-21
3940밀양제일약국밀양시 중앙로 403 (내이동)055-356-77222023-08-21
4041하늘약국밀양시 무안면 사명로 480055-352-17822023-08-21
4142우리약국밀양시 상남면 상남로 792055-353-00792023-08-21
4243문조약국밀양시 삼문중앙로 32 (삼문동)055-802-80152023-08-21
4344삼랑진사거리약국밀양시 삼랑진읍 천태로 13, 1층055-352-92932023-08-21
4445행운약국밀양시 삼랑진읍 천태로 48055-353-37702023-08-21