Overview

Dataset statistics

Number of variables5
Number of observations108
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.5 KiB
Average record size in memory42.2 B

Variable types

Numeric1
Text3
Categorical1

Dataset

Description대구광역시 서구_약국현황_20240205
Author대구광역시 서구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=3071590&dataSetDetailId=30715901b1a9db952b05&provdMethod=FILE

Alerts

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

Reproduction

Analysis started2024-04-17 14:46:10.977911
Analysis finished2024-04-17 14:46:11.292305
Duration0.31 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct108
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean54.5
Minimum1
Maximum108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.1 KiB
2024-04-17T23:46:11.352047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile6.35
Q127.75
median54.5
Q381.25
95-th percentile102.65
Maximum108
Range107
Interquartile range (IQR)53.5

Descriptive statistics

Standard deviation31.32092
Coefficient of variation (CV)0.57469577
Kurtosis-1.2
Mean54.5
Median Absolute Deviation (MAD)27
Skewness0
Sum5886
Variance981
MonotonicityStrictly increasing
2024-04-17T23:46:11.462300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.9%
70 1
 
0.9%
81 1
 
0.9%
80 1
 
0.9%
79 1
 
0.9%
78 1
 
0.9%
77 1
 
0.9%
76 1
 
0.9%
75 1
 
0.9%
74 1
 
0.9%
Other values (98) 98
90.7%
ValueCountFrequency (%)
1 1
0.9%
2 1
0.9%
3 1
0.9%
4 1
0.9%
5 1
0.9%
6 1
0.9%
7 1
0.9%
8 1
0.9%
9 1
0.9%
10 1
0.9%
ValueCountFrequency (%)
108 1
0.9%
107 1
0.9%
106 1
0.9%
105 1
0.9%
104 1
0.9%
103 1
0.9%
102 1
0.9%
101 1
0.9%
100 1
0.9%
99 1
0.9%

약국명칭
Text

UNIQUE 

Distinct108
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size996.0 B
2024-04-17T23:46:11.685388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length4
Mean length4.5648148
Min length3

Characters and Unicode

Total characters493
Distinct characters121
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

Unique108 ?
Unique (%)100.0%

Sample

1st row스마트약국
2nd row소명약국
3rd row오늘약국
4th row홍약국
5th row남광약국
ValueCountFrequency (%)
메디팜 3
 
2.6%
달성약국 2
 
1.7%
서대구약국 2
 
1.7%
스마트약국 1
 
0.9%
하늘온누리약국 1
 
0.9%
아진약국 1
 
0.9%
뉴 1
 
0.9%
혜인약국 1
 
0.9%
북비산약국 1
 
0.9%
윤약국 1
 
0.9%
Other values (101) 101
87.8%
2024-04-17T23:46:11.997514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
국 109
22.1%
약 108
21.9%
리 10
 
2.0%
성 9
 
1.8%
온 8
 
1.6%
대 8
 
1.6%
디 7
 
1.4%
메 7
 
1.4%
명 7
 
1.4%
7
 
1.4%
Other values (111) 213
43.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 486
98.6%
Space Separator 7
 
1.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
국 109
22.4%
약 108
22.2%
리 10
 
2.1%
성 9
 
1.9%
온 8
 
1.6%
대 8
 
1.6%
디 7
 
1.4%
메 7
 
1.4%
명 7
 
1.4%
한 6
 
1.2%
Other values (110) 207
42.6%
Space Separator
ValueCountFrequency (%)
7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 486
98.6%
Common 7
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
국 109
22.4%
약 108
22.2%
리 10
 
2.1%
성 9
 
1.9%
온 8
 
1.6%
대 8
 
1.6%
디 7
 
1.4%
메 7
 
1.4%
명 7
 
1.4%
한 6
 
1.2%
Other values (110) 207
42.6%
Common
ValueCountFrequency (%)
7
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 486
98.6%
ASCII 7
 
1.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
국 109
22.4%
약 108
22.2%
리 10
 
2.1%
성 9
 
1.9%
온 8
 
1.6%
대 8
 
1.6%
디 7
 
1.4%
메 7
 
1.4%
명 7
 
1.4%
한 6
 
1.2%
Other values (110) 207
42.6%
ASCII
ValueCountFrequency (%)
7
100.0%

약국소재지(도로명)
Text

Distinct107
Distinct (%)99.1%
Missing0
Missing (%)0.0%
Memory size996.0 B
2024-04-17T23:46:12.246655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length43
Mean length25.898148
Min length21

Characters and Unicode

Total characters2797
Distinct characters77
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

Unique106 ?
Unique (%)98.1%

Sample

1st row대구광역시 서구 달구벌대로 1691, 4층 411호 (내당동)
2nd row대구광역시 서구 문화로 230, 상가 301동 108호 (평리동, 서대구역반도유보라센텀)
3rd row대구광역시 서구 국채보상로 223, 대원빌딩 106호 (평리동)
4th row대구광역시 서구 국채보상로 294, 1층 (평리동)
5th row대구광역시 서구 팔달로 152, 101호 (비산동)
ValueCountFrequency (%)
대구광역시 108
18.4%
서구 108
18.4%
비산동 36
 
6.1%
평리동 35
 
6.0%
내당동 21
 
3.6%
1층 20
 
3.4%
국채보상로 19
 
3.2%
달서로 14
 
2.4%
달구벌대로 10
 
1.7%
중리동 9
 
1.5%
Other values (147) 208
35.4%
2024-04-17T23:46:12.606453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
482
17.2%
구 241
 
8.6%
대 143
 
5.1%
서 137
 
4.9%
1 118
 
4.2%
동 113
 
4.0%
역 110
 
3.9%
시 108
 
3.9%
로 108
 
3.9%
( 108
 
3.9%
Other values (67) 1129
40.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1622
58.0%
Space Separator 482
 
17.2%
Decimal Number 429
 
15.3%
Open Punctuation 108
 
3.9%
Close Punctuation 108
 
3.9%
Other Punctuation 38
 
1.4%
Dash Punctuation 9
 
0.3%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 241
14.9%
대 143
 
8.8%
서 137
 
8.4%
동 113
 
7.0%
역 110
 
6.8%
시 108
 
6.7%
로 108
 
6.7%
광 108
 
6.7%
리 57
 
3.5%
평 48
 
3.0%
Other values (51) 449
27.7%
Decimal Number
ValueCountFrequency (%)
1 118
27.5%
3 47
 
11.0%
2 44
 
10.3%
6 38
 
8.9%
4 38
 
8.9%
0 35
 
8.2%
5 31
 
7.2%
7 30
 
7.0%
8 28
 
6.5%
9 20
 
4.7%
Space Separator
ValueCountFrequency (%)
482
100.0%
Open Punctuation
ValueCountFrequency (%)
( 108
100.0%
Close Punctuation
ValueCountFrequency (%)
) 108
100.0%
Other Punctuation
ValueCountFrequency (%)
, 38
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%
Uppercase Letter
ValueCountFrequency (%)
M 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1622
58.0%
Common 1174
42.0%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 241
14.9%
대 143
 
8.8%
서 137
 
8.4%
동 113
 
7.0%
역 110
 
6.8%
시 108
 
6.7%
로 108
 
6.7%
광 108
 
6.7%
리 57
 
3.5%
평 48
 
3.0%
Other values (51) 449
27.7%
Common
ValueCountFrequency (%)
482
41.1%
1 118
 
10.1%
( 108
 
9.2%
) 108
 
9.2%
3 47
 
4.0%
2 44
 
3.7%
6 38
 
3.2%
, 38
 
3.2%
4 38
 
3.2%
0 35
 
3.0%
Other values (5) 118
 
10.1%
Latin
ValueCountFrequency (%)
M 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1622
58.0%
ASCII 1175
42.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
482
41.0%
1 118
 
10.0%
( 108
 
9.2%
) 108
 
9.2%
3 47
 
4.0%
2 44
 
3.7%
6 38
 
3.2%
, 38
 
3.2%
4 38
 
3.2%
0 35
 
3.0%
Other values (6) 119
 
10.1%
Hangul
ValueCountFrequency (%)
구 241
14.9%
대 143
 
8.8%
서 137
 
8.4%
동 113
 
7.0%
역 110
 
6.8%
시 108
 
6.7%
로 108
 
6.7%
광 108
 
6.7%
리 57
 
3.5%
평 48
 
3.0%
Other values (51) 449
27.7%

전화번호
Text

UNIQUE 

Distinct108
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size996.0 B
2024-04-17T23:46:12.829188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.009259
Min length12

Characters and Unicode

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

Unique108 ?
Unique (%)100.0%

Sample

1st row070-4833-7401
2nd row053-567-3129
3rd row053-557-5577
4th row053-557-0112
5th row053-352-8377
ValueCountFrequency (%)
070-4833-7401 1
 
0.9%
053-555-1275 1
 
0.9%
053-553-5047 1
 
0.9%
053-562-9959 1
 
0.9%
053-355-7582 1
 
0.9%
053-551-4020 1
 
0.9%
053-553-5793 1
 
0.9%
053-563-1717 1
 
0.9%
053-352-0660 1
 
0.9%
053-522-4398 1
 
0.9%
Other values (98) 98
90.7%
2024-04-17T23:46:13.148927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 318
24.5%
- 216
16.7%
3 182
14.0%
0 164
12.6%
7 88
 
6.8%
2 82
 
6.3%
6 64
 
4.9%
1 58
 
4.5%
4 49
 
3.8%
8 44
 
3.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1081
83.3%
Dash Punctuation 216
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 318
29.4%
3 182
16.8%
0 164
15.2%
7 88
 
8.1%
2 82
 
7.6%
6 64
 
5.9%
1 58
 
5.4%
4 49
 
4.5%
8 44
 
4.1%
9 32
 
3.0%
Dash Punctuation
ValueCountFrequency (%)
- 216
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1297
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 318
24.5%
- 216
16.7%
3 182
14.0%
0 164
12.6%
7 88
 
6.8%
2 82
 
6.3%
6 64
 
4.9%
1 58
 
4.5%
4 49
 
3.8%
8 44
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1297
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 318
24.5%
- 216
16.7%
3 182
14.0%
0 164
12.6%
7 88
 
6.8%
2 82
 
6.3%
6 64
 
4.9%
1 58
 
4.5%
4 49
 
3.8%
8 44
 
3.4%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size996.0 B
2024-02-05
108 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-02-05
2nd row2024-02-05
3rd row2024-02-05
4th row2024-02-05
5th row2024-02-05

Common Values

ValueCountFrequency (%)
2024-02-05 108
100.0%

Length

2024-04-17T23:46:13.258914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T23:46:13.329553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-02-05 108
100.0%

Interactions

2024-04-17T23:46:11.110597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2024-04-17T23:46:11.188051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-17T23:46:11.262254image/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스마트약국대구광역시 서구 달구벌대로 1691, 4층 411호 (내당동)070-4833-74012024-02-05
12소명약국대구광역시 서구 문화로 230, 상가 301동 108호 (평리동, 서대구역반도유보라센텀)053-567-31292024-02-05
23오늘약국대구광역시 서구 국채보상로 223, 대원빌딩 106호 (평리동)053-557-55772024-02-05
34홍약국대구광역시 서구 국채보상로 294, 1층 (평리동)053-557-01122024-02-05
45남광약국대구광역시 서구 팔달로 152, 101호 (비산동)053-352-83772024-02-05
56명문약국대구광역시 서구 달구벌대로361길 1, 109, 110호 (내당동)053-555-55672024-02-05
67사랑약국대구광역시 서구 북비산로 355 (비산동)053-562-44892024-02-05
78이노약국대구광역시 서구 달서로 187, 1층 (비산동)053-555-85582024-02-05
89중리효성약국대구광역시 서구 국채보상로 147, 1층 (평리동)053-555-34002024-02-05
910라라약국대구광역시 서구 원대로 33, 1층 (원대동1가)053-357-71002024-02-05
순번약국명칭약국소재지(도로명)전화번호데이터기준일자
9899유창약국대구광역시 서구 서대구로 304 (비산동)053-357-04632024-02-05
99100건강당약국대구광역시 서구 문화로 300-1 (평리동)053-553-50072024-02-05
100101우성약국대구광역시 서구 북비산로 319-1 (비산동)053-552-75512024-02-05
101102동화약국대구광역시 서구 평리로55길 17 (평리동)053-567-48842024-02-05
102103천우당약국대구광역시 서구 달서로 76 (비산동)053-571-03902024-02-05
103104보성약국대구광역시 서구 북비산로74길 46 (비산동)053-554-36432024-02-05
104105희온누리약국대구광역시 서구 평리로 236, 111호 (내당동)053-556-00792024-02-05
105106경명약국대구광역시 서구 달서천로49길 15 (비산동)053-355-72552024-02-05
106107세일약국대구광역시 서구 달서천로41길 66-4 (비산동)053-357-12792024-02-05
107108봉산약국대구광역시 서구 북비산로74길 8-1 (비산동)053-554-65982024-02-05