Overview

Dataset statistics

Number of variables5
Number of observations47
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory43.8 B

Variable types

Numeric1
Text3
Categorical1

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:09.071716
Analysis finished2023-12-10 23:38:09.599428
Duration0.53 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct47
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24
Minimum1
Maximum47
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size555.0 B
2023-12-11T08:38:09.671937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.3
Q112.5
median24
Q335.5
95-th percentile44.7
Maximum47
Range46
Interquartile range (IQR)23

Descriptive statistics

Standard deviation13.711309
Coefficient of variation (CV)0.57130455
Kurtosis-1.2
Mean24
Median Absolute Deviation (MAD)12
Skewness0
Sum1128
Variance188
MonotonicityStrictly increasing
2023-12-11T08:38:09.813111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%)
1 1
 
2.1%
2 1
 
2.1%
27 1
 
2.1%
28 1
 
2.1%
29 1
 
2.1%
30 1
 
2.1%
31 1
 
2.1%
32 1
 
2.1%
33 1
 
2.1%
34 1
 
2.1%
Other values (37) 37
78.7%
ValueCountFrequency (%)
1 1
2.1%
2 1
2.1%
3 1
2.1%
4 1
2.1%
5 1
2.1%
6 1
2.1%
7 1
2.1%
8 1
2.1%
9 1
2.1%
10 1
2.1%
ValueCountFrequency (%)
47 1
2.1%
46 1
2.1%
45 1
2.1%
44 1
2.1%
43 1
2.1%
42 1
2.1%
41 1
2.1%
40 1
2.1%
39 1
2.1%
38 1
2.1%

약국명
Text

UNIQUE 

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

Length

Max length8
Median length4
Mean length4.4255319
Min length3

Characters and Unicode

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

Unique

Unique47 ?
Unique (%)100.0%

Sample

1st row강약국
2nd row건강약국
3rd row광제당약국
4th row규태약국
5th row단골약국
ValueCountFrequency (%)
강약국 1
 
2.1%
배약국 1
 
2.1%
튼튼약국 1
 
2.1%
안아약국 1
 
2.1%
예림약국 1
 
2.1%
오약국 1
 
2.1%
우리들약국 1
 
2.1%
우리약국 1
 
2.1%
제일약국 1
 
2.1%
조은약국 1
 
2.1%
Other values (38) 38
79.2%
2023-12-11T08:38:10.541701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
국 47
22.6%
약 47
22.6%
리 6
 
2.9%
랑 4
 
1.9%
제 4
 
1.9%
성 3
 
1.4%
밀 3
 
1.4%
수 3
 
1.4%
삼 3
 
1.4%
진 3
 
1.4%
Other values (68) 85
40.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 207
99.5%
Space Separator 1
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
국 47
22.7%
약 47
22.7%
리 6
 
2.9%
랑 4
 
1.9%
제 4
 
1.9%
성 3
 
1.4%
밀 3
 
1.4%
수 3
 
1.4%
삼 3
 
1.4%
진 3
 
1.4%
Other values (67) 84
40.6%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 207
99.5%
Common 1
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
국 47
22.7%
약 47
22.7%
리 6
 
2.9%
랑 4
 
1.9%
제 4
 
1.9%
성 3
 
1.4%
밀 3
 
1.4%
수 3
 
1.4%
삼 3
 
1.4%
진 3
 
1.4%
Other values (67) 84
40.6%
Common
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 207
99.5%
ASCII 1
 
0.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
국 47
22.7%
약 47
22.7%
리 6
 
2.9%
랑 4
 
1.9%
제 4
 
1.9%
성 3
 
1.4%
밀 3
 
1.4%
수 3
 
1.4%
삼 3
 
1.4%
진 3
 
1.4%
Other values (67) 84
40.6%
ASCII
ValueCountFrequency (%)
1
100.0%

주소
Text

UNIQUE 

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

Length

Max length26
Median length21
Mean length18.106383
Min length14

Characters and Unicode

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

Unique47 ?
Unique (%)100.0%

Sample

1st row밀양시 삼랑진읍 외송중앙길 3
2nd row밀양시 중앙로 450 (내이동)
3rd row밀양시 중앙로 349 (내일동)
4th row밀양시 삼문중앙로 36-4 (삼문동)
5th row밀양시 북성로 10, 1층 (내이동)
ValueCountFrequency (%)
밀양시 47
24.0%
중앙로 13
 
6.6%
내이동 12
 
6.1%
삼문동 11
 
5.6%
삼문중앙로 6
 
3.1%
1층 6
 
3.1%
내일동 6
 
3.1%
하남읍 5
 
2.6%
북성로 4
 
2.0%
삼랑진읍 4
 
2.0%
Other values (71) 82
41.8%
2023-12-11T08:38:11.202678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
149
17.5%
밀 49
 
5.8%
양 48
 
5.6%
시 48
 
5.6%
로 41
 
4.8%
1 37
 
4.3%
( 34
 
4.0%
) 34
 
4.0%
동 33
 
3.9%
중 24
 
2.8%
Other values (65) 354
41.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 476
55.9%
Space Separator 149
 
17.5%
Decimal Number 137
 
16.1%
Open Punctuation 34
 
4.0%
Close Punctuation 34
 
4.0%
Dash Punctuation 13
 
1.5%
Other Punctuation 8
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
밀 49
 
10.3%
양 48
 
10.1%
시 48
 
10.1%
로 41
 
8.6%
동 33
 
6.9%
중 24
 
5.0%
앙 24
 
5.0%
내 22
 
4.6%
삼 22
 
4.6%
문 18
 
3.8%
Other values (50) 147
30.9%
Decimal Number
ValueCountFrequency (%)
1 37
27.0%
3 22
16.1%
4 21
15.3%
2 11
 
8.0%
7 10
 
7.3%
8 10
 
7.3%
9 8
 
5.8%
0 6
 
4.4%
6 6
 
4.4%
5 6
 
4.4%
Space Separator
ValueCountFrequency (%)
149
100.0%
Open Punctuation
ValueCountFrequency (%)
( 34
100.0%
Close Punctuation
ValueCountFrequency (%)
) 34
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%
Other Punctuation
ValueCountFrequency (%)
, 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 476
55.9%
Common 375
44.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
밀 49
 
10.3%
양 48
 
10.1%
시 48
 
10.1%
로 41
 
8.6%
동 33
 
6.9%
중 24
 
5.0%
앙 24
 
5.0%
내 22
 
4.6%
삼 22
 
4.6%
문 18
 
3.8%
Other values (50) 147
30.9%
Common
ValueCountFrequency (%)
149
39.7%
1 37
 
9.9%
( 34
 
9.1%
) 34
 
9.1%
3 22
 
5.9%
4 21
 
5.6%
- 13
 
3.5%
2 11
 
2.9%
7 10
 
2.7%
8 10
 
2.7%
Other values (5) 34
 
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 476
55.9%
ASCII 375
44.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
149
39.7%
1 37
 
9.9%
( 34
 
9.1%
) 34
 
9.1%
3 22
 
5.9%
4 21
 
5.6%
- 13
 
3.5%
2 11
 
2.9%
7 10
 
2.7%
8 10
 
2.7%
Other values (5) 34
 
9.1%
Hangul
ValueCountFrequency (%)
밀 49
 
10.3%
양 48
 
10.1%
시 48
 
10.1%
로 41
 
8.6%
동 33
 
6.9%
중 24
 
5.0%
앙 24
 
5.0%
내 22
 
4.6%
삼 22
 
4.6%
문 18
 
3.8%
Other values (50) 147
30.9%

전화번호
Text

UNIQUE 

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

Length

Max length13
Median length8
Mean length8.106383
Min length8

Characters and Unicode

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

Unique47 ?
Unique (%)100.0%

Sample

1st row352-9955
2nd row352-0261
3rd row354-7686
4th row355-8012
5th row354-1578
ValueCountFrequency (%)
352-9955 1
 
2.1%
356-4356 1
 
2.1%
356-8091 1
 
2.1%
355-6004 1
 
2.1%
354-8607 1
 
2.1%
356-2914 1
 
2.1%
353-0079 1
 
2.1%
352-0056 1
 
2.1%
352-5554 1
 
2.1%
356-5570 1
 
2.1%
Other values (37) 37
78.7%
2023-12-11T08:38:11.821615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 69
18.1%
5 64
16.8%
- 48
12.6%
2 36
9.4%
0 35
9.2%
4 29
7.6%
1 25
 
6.6%
6 25
 
6.6%
7 21
 
5.5%
9 17
 
4.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 333
87.4%
Dash Punctuation 48
 
12.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 69
20.7%
5 64
19.2%
2 36
10.8%
0 35
10.5%
4 29
8.7%
1 25
 
7.5%
6 25
 
7.5%
7 21
 
6.3%
9 17
 
5.1%
8 12
 
3.6%
Dash Punctuation
ValueCountFrequency (%)
- 48
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 381
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 69
18.1%
5 64
16.8%
- 48
12.6%
2 36
9.4%
0 35
9.2%
4 29
7.6%
1 25
 
6.6%
6 25
 
6.6%
7 21
 
5.5%
9 17
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 381
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 69
18.1%
5 64
16.8%
- 48
12.6%
2 36
9.4%
0 35
9.2%
4 29
7.6%
1 25
 
6.6%
6 25
 
6.6%
7 21
 
5.5%
9 17
 
4.5%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size508.0 B
2022-08-01
47 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-08-01
2nd row2022-08-01
3rd row2022-08-01
4th row2022-08-01
5th row2022-08-01

Common Values

ValueCountFrequency (%)
2022-08-01 47
100.0%

Length

2023-12-11T08:38:11.974725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:38:12.071826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-08-01 47
100.0%

Interactions

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

Correlations

2023-12-11T08:38:12.149438image/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:09.456530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T08:38:09.556485image/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강약국밀양시 삼랑진읍 외송중앙길 3352-99552022-08-01
12건강약국밀양시 중앙로 450 (내이동)352-02612022-08-01
23광제당약국밀양시 중앙로 349 (내일동)354-76862022-08-01
34규태약국밀양시 삼문중앙로 36-4 (삼문동)355-80122022-08-01
45단골약국밀양시 북성로 10, 1층 (내이동)354-15782022-08-01
56메디팜 세종약국밀양시 삼문중앙로 49 (삼문동)354-27042022-08-01
67명진약국밀양시 중앙로 339, 1층 (내일동)352-35242022-08-01
78문조약국밀양시 삼문중앙로 32 (삼문동)802-80152022-08-01
89미래약국밀양시 삼문강변로 344-6 (삼문동)352-47722022-08-01
910밀성메디칼약국밀양시 중앙로 381 (내이동)356-49502022-08-01
연번약국명주소전화번호데이터기준일자
3738푸른약국밀양시 밀성로 14 (내이동)354-99272022-08-01
3839하나약국밀양시 중앙로 227-1 (삼문동)352-65402022-08-01
3940하늘약국밀양시 무안면 사명로 480352-17822022-08-01
4041한사랑약국밀양시 하남읍 수산중앙로 17391-33492022-08-01
4142햇살약국밀양시 미리벌중앙로 67, 1층 (삼문동)355-63312022-08-01
4243행복약국밀양시 노상하4길 5 (내이동)070-4388-00132022-08-01
4344행운약국밀양시 삼랑진읍 천태로 48353-37072022-08-01
4445현대약국밀양시 삼문중앙로 37 (삼문동)354-20402022-08-01
4546소망약국밀양시 내이2길 28, 1층(내이동)351-21932022-08-01
4647아리랑약국밀양시 중앙로 114-1(가곡동)353-75382022-08-01