Overview

Dataset statistics

Number of variables4
Number of observations194
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.2 KiB
Average record size in memory32.7 B

Variable types

Categorical1
Text2
DateTime1

Dataset

Description서울특별시 광진구 폐의약품 수거함 및 수집 참여 약국 현황(구분,명칭, 도로명주소,데이터기준일자)을 제공합니다.
Author서울특별시 광진구
URLhttps://www.data.go.kr/data/15075017/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
구분 is highly imbalanced (71.4%)Imbalance
명칭 has unique valuesUnique

Reproduction

Analysis started2023-12-12 20:36:59.043075
Analysis finished2023-12-12 20:36:59.868269
Duration0.83 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

IMBALANCE 

Distinct6
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
약국
170 
동주민센터
 
15
문화체육센터
 
4
보건소
 
3
복지관
 
1

Length

Max length6
Median length2
Mean length2.3556701
Min length2

Unique

Unique2 ?
Unique (%)1.0%

Sample

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

Common Values

ValueCountFrequency (%)
약국 170
87.6%
동주민센터 15
 
7.7%
문화체육센터 4
 
2.1%
보건소 3
 
1.5%
복지관 1
 
0.5%
시설관리공단 1
 
0.5%

Length

2023-12-13T05:37:00.009242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:37:00.197342image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 170
87.6%
동주민센터 15
 
7.7%
문화체육센터 4
 
2.1%
보건소 3
 
1.5%
복지관 1
 
0.5%
시설관리공단 1
 
0.5%

명칭
Text

UNIQUE 

Distinct194
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-12-13T05:37:00.510380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length9
Mean length5.5412371
Min length3

Characters and Unicode

Total characters1075
Distinct characters187
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

Unique194 ?
Unique (%)100.0%

Sample

1st row광진구 보건소
2nd row삼층약국
3rd row늘편한약국
4th row파크온누리약국
5th row원약국
ValueCountFrequency (%)
광진구 1
 
0.5%
중부고속약국 1
 
0.5%
예일약국 1
 
0.5%
그랜드약국 1
 
0.5%
신세계약국 1
 
0.5%
세란약국 1
 
0.5%
건대역약국 1
 
0.5%
뉴메디칼약국 1
 
0.5%
혜성약국 1
 
0.5%
금성약국 1
 
0.5%
Other values (185) 185
94.9%
2023-12-13T05:37:01.038451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
국 170
 
15.8%
약 170
 
15.8%
리 40
 
3.7%
온 33
 
3.1%
누 33
 
3.1%
동 20
 
1.9%
자 18
 
1.7%
센 18
 
1.7%
터 18
 
1.7%
주 16
 
1.5%
Other values (177) 539
50.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1061
98.7%
Decimal Number 13
 
1.2%
Space Separator 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
국 170
 
16.0%
약 170
 
16.0%
리 40
 
3.8%
온 33
 
3.1%
누 33
 
3.1%
동 20
 
1.9%
자 18
 
1.7%
센 18
 
1.7%
터 18
 
1.7%
주 16
 
1.5%
Other values (172) 525
49.5%
Decimal Number
ValueCountFrequency (%)
2 4
30.8%
1 4
30.8%
3 3
23.1%
4 2
15.4%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1061
98.7%
Common 14
 
1.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
국 170
 
16.0%
약 170
 
16.0%
리 40
 
3.8%
온 33
 
3.1%
누 33
 
3.1%
동 20
 
1.9%
자 18
 
1.7%
센 18
 
1.7%
터 18
 
1.7%
주 16
 
1.5%
Other values (172) 525
49.5%
Common
ValueCountFrequency (%)
2 4
28.6%
1 4
28.6%
3 3
21.4%
4 2
14.3%
1
 
7.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1061
98.7%
ASCII 14
 
1.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
국 170
 
16.0%
약 170
 
16.0%
리 40
 
3.8%
온 33
 
3.1%
누 33
 
3.1%
동 20
 
1.9%
자 18
 
1.7%
센 18
 
1.7%
터 18
 
1.7%
주 16
 
1.5%
Other values (172) 525
49.5%
ASCII
ValueCountFrequency (%)
2 4
28.6%
1 4
28.6%
3 3
21.4%
4 2
14.3%
1
 
7.1%

주소
Text

Distinct193
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-12-13T05:37:01.463423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length53
Median length45
Mean length27.386598
Min length16

Characters and Unicode

Total characters5313
Distinct characters155
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

Unique192 ?
Unique (%)99.0%

Sample

1st row서울시 광진구 자양로 117(자양동)
2nd row서울특별시 광진구 강변역로4길 10, 강변역지너스타워 303호일부 (구의동)
3rd row서울특별시 광진구 면목로 128, 1층 101호 (중곡동)
4th row서울특별시 광진구 천호대로 666, 그랜드파크오피스텔 지1층 B101호 (구의동)
5th row서울특별시 광진구 아차산로 229, 한림타워 1층 103호 (화양동)
ValueCountFrequency (%)
광진구 194
17.7%
서울특별시 193
17.6%
자양동 49
 
4.5%
1층 44
 
4.0%
중곡동 44
 
4.0%
구의동 37
 
3.4%
아차산로 20
 
1.8%
능동로 19
 
1.7%
자양로 19
 
1.7%
화양동 16
 
1.5%
Other values (304) 461
42.1%
2023-12-13T05:37:02.105883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
902
 
17.0%
구 239
 
4.5%
광 221
 
4.2%
동 206
 
3.9%
1 205
 
3.9%
진 199
 
3.7%
시 198
 
3.7%
서 196
 
3.7%
울 196
 
3.7%
로 194
 
3.7%
Other values (145) 2557
48.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3176
59.8%
Space Separator 902
 
17.0%
Decimal Number 766
 
14.4%
Open Punctuation 171
 
3.2%
Close Punctuation 171
 
3.2%
Other Punctuation 104
 
2.0%
Dash Punctuation 17
 
0.3%
Uppercase Letter 6
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 239
 
7.5%
광 221
 
7.0%
동 206
 
6.5%
진 199
 
6.3%
시 198
 
6.2%
서 196
 
6.2%
울 196
 
6.2%
로 194
 
6.1%
특 193
 
6.1%
별 193
 
6.1%
Other values (126) 1141
35.9%
Decimal Number
ValueCountFrequency (%)
1 205
26.8%
2 86
11.2%
5 84
11.0%
3 70
 
9.1%
0 66
 
8.6%
4 64
 
8.4%
6 60
 
7.8%
8 48
 
6.3%
7 46
 
6.0%
9 37
 
4.8%
Uppercase Letter
ValueCountFrequency (%)
B 3
50.0%
I 1
 
16.7%
A 1
 
16.7%
D 1
 
16.7%
Space Separator
ValueCountFrequency (%)
902
100.0%
Open Punctuation
ValueCountFrequency (%)
( 171
100.0%
Close Punctuation
ValueCountFrequency (%)
) 171
100.0%
Other Punctuation
ValueCountFrequency (%)
, 104
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3176
59.8%
Common 2131
40.1%
Latin 6
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 239
 
7.5%
광 221
 
7.0%
동 206
 
6.5%
진 199
 
6.3%
시 198
 
6.2%
서 196
 
6.2%
울 196
 
6.2%
로 194
 
6.1%
특 193
 
6.1%
별 193
 
6.1%
Other values (126) 1141
35.9%
Common
ValueCountFrequency (%)
902
42.3%
1 205
 
9.6%
( 171
 
8.0%
) 171
 
8.0%
, 104
 
4.9%
2 86
 
4.0%
5 84
 
3.9%
3 70
 
3.3%
0 66
 
3.1%
4 64
 
3.0%
Other values (5) 208
 
9.8%
Latin
ValueCountFrequency (%)
B 3
50.0%
I 1
 
16.7%
A 1
 
16.7%
D 1
 
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3176
59.8%
ASCII 2137
40.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
902
42.2%
1 205
 
9.6%
( 171
 
8.0%
) 171
 
8.0%
, 104
 
4.9%
2 86
 
4.0%
5 84
 
3.9%
3 70
 
3.3%
0 66
 
3.1%
4 64
 
3.0%
Other values (9) 214
 
10.0%
Hangul
ValueCountFrequency (%)
구 239
 
7.5%
광 221
 
7.0%
동 206
 
6.5%
진 199
 
6.3%
시 198
 
6.2%
서 196
 
6.2%
울 196
 
6.2%
로 194
 
6.1%
특 193
 
6.1%
별 193
 
6.1%
Other values (126) 1141
35.9%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
Minimum2022-01-21 00:00:00
Maximum2022-01-21 00:00:00
2023-12-13T05:37:02.249254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:37:02.347929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2023-12-13T05:36:59.627453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:36:59.773852image/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

구분명칭주소데이터기준일자
0보건소광진구 보건소서울시 광진구 자양로 117(자양동)2022-01-21
1약국삼층약국서울특별시 광진구 강변역로4길 10, 강변역지너스타워 303호일부 (구의동)2022-01-21
2약국늘편한약국서울특별시 광진구 면목로 128, 1층 101호 (중곡동)2022-01-21
3약국파크온누리약국서울특별시 광진구 천호대로 666, 그랜드파크오피스텔 지1층 B101호 (구의동)2022-01-21
4약국원약국서울특별시 광진구 아차산로 229, 한림타워 1층 103호 (화양동)2022-01-21
5약국신성온누리약국서울특별시 광진구 면목로 127, 1층 (중곡동, 신성그랜드타워)2022-01-21
6약국조은우리약국서울특별시 광진구 자양로 109, 104호 (자양동)2022-01-21
7약국새봄약국서울특별시 광진구 뚝섬로 503, 1층 (자양동)2022-01-21
8약국화양백화점약국서울특별시 광진구 광나루로 351, 1층 (군자동)2022-01-21
9약국더나은약국서울특별시 광진구 천호대로 570, 1층 101호 (능동)2022-01-21
구분명칭주소데이터기준일자
184동주민센터자양3동주민센터서울특별시 광진구 뚝섬로 5682022-01-21
185동주민센터자양4동주민센터서울특별시 광진구 뚝섬로26길 582022-01-21
186보건소중곡보건지소서울특별시 광진구 긴고랑로 1102022-01-21
187보건소자양보건지소서울특별시 광진구 아차산로24길 172022-01-21
188복지관광진노인종합복지관서울특별시 광진구 군자로 882022-01-21
189시설관리공단광진시설관리공단서울특별시 광진구 능동로 762022-01-21
190문화체육센터광진구민체육센터서울특별시 광진구 구천면로 22022-01-21
191문화체육센터중곡문화체육센터서울특별시 광진구 능동로 4332022-01-21
192문화체육센터광진문화원서울특별시 광진구 광나루로56길 672022-01-21
193문화체육센터자양체육관서울특별시 광진구 뚝섬로52길 662022-01-21