Overview

Dataset statistics

Number of variables5
Number of observations249
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory10.1 KiB
Average record size in memory41.5 B

Variable types

Numeric1
Text3
Categorical1

Dataset

Description서울특별시 강서구 폐의약품(가정 내 불용 의약품) 수거 약국 현황 데이터
Author서울특별시 강서구
URLhttps://www.data.go.kr/data/15074907/fileData.do

Alerts

연번 has unique valuesUnique
약국명 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 22:29:29.912176
Analysis finished2023-12-12 22:29:30.415431
Duration0.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct249
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean125
Minimum1
Maximum249
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2023-12-13T07:29:30.485198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile13.4
Q163
median125
Q3187
95-th percentile236.6
Maximum249
Range248
Interquartile range (IQR)124

Descriptive statistics

Standard deviation72.024301
Coefficient of variation (CV)0.57619441
Kurtosis-1.2
Mean125
Median Absolute Deviation (MAD)62
Skewness0
Sum31125
Variance5187.5
MonotonicityStrictly increasing
2023-12-13T07:29:30.630744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
172 1
 
0.4%
159 1
 
0.4%
160 1
 
0.4%
161 1
 
0.4%
162 1
 
0.4%
163 1
 
0.4%
164 1
 
0.4%
165 1
 
0.4%
166 1
 
0.4%
Other values (239) 239
96.0%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
249 1
0.4%
248 1
0.4%
247 1
0.4%
246 1
0.4%
245 1
0.4%
244 1
0.4%
243 1
0.4%
242 1
0.4%
241 1
0.4%
240 1
0.4%

약국명
Text

UNIQUE 

Distinct249
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
2023-12-13T07:29:31.210356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length10
Mean length5.253012
Min length3

Characters and Unicode

Total characters1308
Distinct characters222
Distinct categories5 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique249 ?
Unique (%)100.0%

Sample

1st row자성당약국
2nd row월성약국
3rd row새은약국
4th row미동약국
5th row일심당약국
ValueCountFrequency (%)
자성당약국 1
 
0.4%
일신약국 1
 
0.4%
더건강약국 1
 
0.4%
우정약국 1
 
0.4%
한마음약국 1
 
0.4%
메디참사랑약국 1
 
0.4%
산소망약국 1
 
0.4%
메디팜사랑약국 1
 
0.4%
햇살온누리약국 1
 
0.4%
한빛약국 1
 
0.4%
Other values (241) 241
96.0%
2023-12-13T07:29:31.656915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
국 252
 
19.3%
약 249
 
19.0%
리 35
 
2.7%
온 27
 
2.1%
누 26
 
2.0%
메 20
 
1.5%
디 20
 
1.5%
곡 15
 
1.1%
강 15
 
1.1%
화 15
 
1.1%
Other values (212) 634
48.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1284
98.2%
Decimal Number 13
 
1.0%
Lowercase Letter 6
 
0.5%
Uppercase Letter 3
 
0.2%
Space Separator 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
국 252
19.6%
약 249
19.4%
리 35
 
2.7%
온 27
 
2.1%
누 26
 
2.0%
메 20
 
1.6%
디 20
 
1.6%
곡 15
 
1.2%
강 15
 
1.2%
화 15
 
1.2%
Other values (197) 610
47.5%
Decimal Number
ValueCountFrequency (%)
2 3
23.1%
3 3
23.1%
5 2
15.4%
1 2
15.4%
6 2
15.4%
9 1
 
7.7%
Lowercase Letter
ValueCountFrequency (%)
o 2
33.3%
r 1
16.7%
a 1
16.7%
h 1
16.7%
m 1
16.7%
Uppercase Letter
ValueCountFrequency (%)
P 1
33.3%
S 1
33.3%
C 1
33.3%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1284
98.2%
Common 15
 
1.1%
Latin 9
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
국 252
19.6%
약 249
19.4%
리 35
 
2.7%
온 27
 
2.1%
누 26
 
2.0%
메 20
 
1.6%
디 20
 
1.6%
곡 15
 
1.2%
강 15
 
1.2%
화 15
 
1.2%
Other values (197) 610
47.5%
Latin
ValueCountFrequency (%)
o 2
22.2%
r 1
11.1%
a 1
11.1%
h 1
11.1%
P 1
11.1%
S 1
11.1%
m 1
11.1%
C 1
11.1%
Common
ValueCountFrequency (%)
2 3
20.0%
3 3
20.0%
5 2
13.3%
1 2
13.3%
2
13.3%
6 2
13.3%
9 1
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1284
98.2%
ASCII 24
 
1.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
국 252
19.6%
약 249
19.4%
리 35
 
2.7%
온 27
 
2.1%
누 26
 
2.0%
메 20
 
1.6%
디 20
 
1.6%
곡 15
 
1.2%
강 15
 
1.2%
화 15
 
1.2%
Other values (197) 610
47.5%
ASCII
ValueCountFrequency (%)
2 3
12.5%
3 3
12.5%
5 2
 
8.3%
1 2
 
8.3%
2
 
8.3%
6 2
 
8.3%
o 2
 
8.3%
r 1
 
4.2%
a 1
 
4.2%
h 1
 
4.2%
Other values (5) 5
20.8%

소재지
Text

Distinct246
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
2023-12-13T07:29:32.047835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length32
Mean length18.959839
Min length7

Characters and Unicode

Total characters4721
Distinct characters179
Distinct categories11 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique243 ?
Unique (%)97.6%

Sample

1st row방화대로21길 76 (공항동)
2nd row강서로17길 141 (화곡동)
3rd row양천로 601 (염창동)
4th row월정로30길 52 (화곡동)
5th row강서로7길 90 (화곡동)
ValueCountFrequency (%)
화곡동 70
 
8.1%
강서로 39
 
4.5%
양천로 28
 
3.3%
등촌동 25
 
2.9%
화곡로 22
 
2.6%
방화동 21
 
2.4%
1층 20
 
2.3%
공항대로 19
 
2.2%
내발산동 14
 
1.6%
가양동 13
 
1.5%
Other values (408) 588
68.5%
2023-12-13T07:29:32.604608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
612
 
13.0%
1 287
 
6.1%
동 255
 
5.4%
로 253
 
5.4%
( 241
 
5.1%
) 241
 
5.1%
, 173
 
3.7%
곡 166
 
3.5%
화 166
 
3.5%
2 123
 
2.6%
Other values (169) 2204
46.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2270
48.1%
Decimal Number 1130
23.9%
Space Separator 612
 
13.0%
Open Punctuation 241
 
5.1%
Close Punctuation 241
 
5.1%
Other Punctuation 173
 
3.7%
Dash Punctuation 31
 
0.7%
Uppercase Letter 11
 
0.2%
Math Symbol 9
 
0.2%
Letter Number 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 255
 
11.2%
로 253
 
11.1%
곡 166
 
7.3%
화 166
 
7.3%
호 81
 
3.6%
길 76
 
3.3%
서 66
 
2.9%
양 65
 
2.9%
강 64
 
2.8%
마 52
 
2.3%
Other values (142) 1026
45.2%
Decimal Number
ValueCountFrequency (%)
1 287
25.4%
2 123
10.9%
6 116
10.3%
3 114
 
10.1%
0 111
 
9.8%
4 98
 
8.7%
7 96
 
8.5%
5 94
 
8.3%
9 47
 
4.2%
8 44
 
3.9%
Uppercase Letter
ValueCountFrequency (%)
A 3
27.3%
L 1
 
9.1%
K 1
 
9.1%
I 1
 
9.1%
E 1
 
9.1%
W 1
 
9.1%
S 1
 
9.1%
V 1
 
9.1%
B 1
 
9.1%
Space Separator
ValueCountFrequency (%)
612
100.0%
Open Punctuation
ValueCountFrequency (%)
( 241
100.0%
Close Punctuation
ValueCountFrequency (%)
) 241
100.0%
Other Punctuation
ValueCountFrequency (%)
, 173
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 31
100.0%
Math Symbol
ValueCountFrequency (%)
~ 9
100.0%
Letter Number
ValueCountFrequency (%)
Ⅰ 2
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2437
51.6%
Hangul 2270
48.1%
Latin 14
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 255
 
11.2%
로 253
 
11.1%
곡 166
 
7.3%
화 166
 
7.3%
호 81
 
3.6%
길 76
 
3.3%
서 66
 
2.9%
양 65
 
2.9%
강 64
 
2.8%
마 52
 
2.3%
Other values (142) 1026
45.2%
Common
ValueCountFrequency (%)
612
25.1%
1 287
11.8%
( 241
 
9.9%
) 241
 
9.9%
, 173
 
7.1%
2 123
 
5.0%
6 116
 
4.8%
3 114
 
4.7%
0 111
 
4.6%
4 98
 
4.0%
Other values (6) 321
13.2%
Latin
ValueCountFrequency (%)
A 3
21.4%
Ⅰ 2
14.3%
L 1
 
7.1%
K 1
 
7.1%
e 1
 
7.1%
I 1
 
7.1%
E 1
 
7.1%
W 1
 
7.1%
S 1
 
7.1%
V 1
 
7.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2449
51.9%
Hangul 2270
48.1%
Number Forms 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
612
25.0%
1 287
11.7%
( 241
 
9.8%
) 241
 
9.8%
, 173
 
7.1%
2 123
 
5.0%
6 116
 
4.7%
3 114
 
4.7%
0 111
 
4.5%
4 98
 
4.0%
Other values (16) 333
13.6%
Hangul
ValueCountFrequency (%)
동 255
 
11.2%
로 253
 
11.1%
곡 166
 
7.3%
화 166
 
7.3%
호 81
 
3.6%
길 76
 
3.3%
서 66
 
2.9%
양 65
 
2.9%
강 64
 
2.8%
마 52
 
2.3%
Other values (142) 1026
45.2%
Number Forms
ValueCountFrequency (%)
Ⅰ 2
100.0%

전화번호
Text

UNIQUE 

Distinct249
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
2023-12-13T07:29:32.918561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length9
Mean length9.0963855
Min length8

Characters and Unicode

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

Unique249 ?
Unique (%)100.0%

Sample

1st row2662-3231
2nd row2602-0774
3rd row3665-1370
4th row2602-4054
5th row2602-0856
ValueCountFrequency (%)
2662-3231 1
 
0.4%
3664-0319 1
 
0.4%
2699-2275 1
 
0.4%
2690-2025 1
 
0.4%
2652-6692 1
 
0.4%
3663-7133 1
 
0.4%
6335-1113 1
 
0.4%
2601-8498 1
 
0.4%
2699-6314 1
 
0.4%
2658-7371 1
 
0.4%
Other values (239) 239
96.0%
2023-12-13T07:29:33.357131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 448
19.8%
2 353
15.6%
- 255
11.3%
0 201
8.9%
5 188
8.3%
3 166
 
7.3%
1 160
 
7.1%
7 133
 
5.9%
8 132
 
5.8%
4 116
 
5.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2010
88.7%
Dash Punctuation 255
 
11.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 448
22.3%
2 353
17.6%
0 201
10.0%
5 188
9.4%
3 166
 
8.3%
1 160
 
8.0%
7 133
 
6.6%
8 132
 
6.6%
4 116
 
5.8%
9 113
 
5.6%
Dash Punctuation
ValueCountFrequency (%)
- 255
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2265
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
6 448
19.8%
2 353
15.6%
- 255
11.3%
0 201
8.9%
5 188
8.3%
3 166
 
7.3%
1 160
 
7.1%
7 133
 
5.9%
8 132
 
5.8%
4 116
 
5.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2265
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 448
19.8%
2 353
15.6%
- 255
11.3%
0 201
8.9%
5 188
8.3%
3 166
 
7.3%
1 160
 
7.1%
7 133
 
5.9%
8 132
 
5.8%
4 116
 
5.1%

행정동
Categorical

Distinct22
Distinct (%)8.8%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
발산1동
30 
화곡1동
28 
가양1동
20 
등촌3동
18 
방화1동
18 
Other values (17)
135 

Length

Max length5
Median length4
Mean length3.8955823
Min length3

Unique

Unique1 ?
Unique (%)0.4%

Sample

1st row공항동
2nd row화곡1동
3rd row염창동
4th row화곡1동
5th row화곡1동

Common Values

ValueCountFrequency (%)
발산1동 30
12.0%
화곡1동 28
 
11.2%
가양1동 20
 
8.0%
등촌3동 18
 
7.2%
방화1동 18
 
7.2%
염창동 15
 
6.0%
우장산동 12
 
4.8%
공항동 12
 
4.8%
등촌1동 12
 
4.8%
화곡본동 12
 
4.8%
Other values (12) 72
28.9%

Length

2023-12-13T07:29:33.521400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
발산1동 30
12.0%
화곡1동 28
 
11.2%
가양1동 20
 
8.0%
방화1동 19
 
7.6%
등촌3동 18
 
7.2%
염창동 15
 
6.0%
우장산동 12
 
4.8%
공항동 12
 
4.8%
등촌1동 12
 
4.8%
화곡본동 12
 
4.8%
Other values (11) 71
28.5%

Interactions

2023-12-13T07:29:30.188931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T07:29:33.602161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번행정동
연번1.0000.383
행정동0.3831.000
2023-12-13T07:29:33.693464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번행정동
연번1.0000.152
행정동0.1521.000

Missing values

2023-12-13T07:29:30.292739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:29:30.378958image/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자성당약국방화대로21길 76 (공항동)2662-3231공항동
12월성약국강서로17길 141 (화곡동)2602-0774화곡1동
23새은약국양천로 601 (염창동)3665-1370염창동
34미동약국월정로30길 52 (화곡동)2602-4054화곡1동
45일심당약국강서로7길 90 (화곡동)2602-0856화곡1동
56영보약국양천로57길 16 (가양동)3664-0552가양2동
67혜성약국까치산로 43 (화곡동)2602-6126화곡본동
78동산온누리약국양천로 606 (등촌동)3663-7953등촌1동
89영일약국양천길658 (염창동)3661-2954염창동
910조광약국방화동로 45(방화동)2666-1282방화2동
연번약국명소재지전화번호행정동
239240정성가득한약국화곡로 301, 103호(화곡동)2604-0901화곡6동
240241가양누리약국허준로 198, 104~105호(가양동)3663-8013가양1동
241242벼리약국허준로 12, 103호(가양동)3662-0072염창동
242243지하철정문약국공항대로 지하 267, 발산역 515-106호(마곡동)0507-1369-6006가양1동
243244밝은온누리약국등촌로 177, 101동 102호(등촌동)2645-4288등촌1동
244245발산역지하철약국공항대로 267 515-107호(마곡동)0507-1333-3954가양1동
245246마곡나루약국마곡서로 157, 스프링파크타워 208-2호(마곡동)070-4352-4547가양1동
246247힐스테이트솔약국강서로 242, 151호(화곡동, 강서힐스테이트)2695-6121화곡1동
247248메디팜21세기약국화곡로 162, 1층(화곡동)2603-4569화곡1동
248249더나은약국공항대로 271, 이천이프라자 1층 103호(마곡동)3663-1335가양1동