Overview

Dataset statistics

Number of variables4
Number of observations197
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.7 KiB
Average record size in memory34.6 B

Variable types

Numeric2
Text2

Dataset

Description서울특별시 광진구 관내 2024.2.8. 기준 약국현황으로 소재지, 약국명, 전화번호 등 정보제공하여 의약품 조제 및 구입에 용이하고자 함
Author서울특별시 광진구
URLhttps://www.data.go.kr/data/15052413/fileData.do

Alerts

순번 has unique valuesUnique

Reproduction

Analysis started2024-03-15 00:30:26.312733
Analysis finished2024-03-15 00:30:28.362151
Duration2.05 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct197
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean99
Minimum1
Maximum197
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2024-03-15T09:30:28.623001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile10.8
Q150
median99
Q3148
95-th percentile187.2
Maximum197
Range196
Interquartile range (IQR)98

Descriptive statistics

Standard deviation57.013156
Coefficient of variation (CV)0.57589047
Kurtosis-1.2
Mean99
Median Absolute Deviation (MAD)49
Skewness0
Sum19503
Variance3250.5
MonotonicityStrictly increasing
2024-03-15T09:30:29.147575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.5%
125 1
 
0.5%
127 1
 
0.5%
128 1
 
0.5%
129 1
 
0.5%
130 1
 
0.5%
131 1
 
0.5%
132 1
 
0.5%
133 1
 
0.5%
134 1
 
0.5%
Other values (187) 187
94.9%
ValueCountFrequency (%)
1 1
0.5%
2 1
0.5%
3 1
0.5%
4 1
0.5%
5 1
0.5%
6 1
0.5%
7 1
0.5%
8 1
0.5%
9 1
0.5%
10 1
0.5%
ValueCountFrequency (%)
197 1
0.5%
196 1
0.5%
195 1
0.5%
194 1
0.5%
193 1
0.5%
192 1
0.5%
191 1
0.5%
190 1
0.5%
189 1
0.5%
188 1
0.5%

약국명칭
Text

Distinct192
Distinct (%)97.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2024-03-15T09:30:30.629492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length9
Mean length5.3857868
Min length3

Characters and Unicode

Total characters1061
Distinct characters186
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

Unique187 ?
Unique (%)94.9%

Sample

1st row광진365플러스약국
2nd row라인약국
3rd row가원약국
4th row제일약국
5th row아차산봄약국
ValueCountFrequency (%)
건대지하철약국 2
 
1.0%
온누리강변프라자약국 2
 
1.0%
청구약국 2
 
1.0%
미소온누리약국 2
 
1.0%
태평양약국 2
 
1.0%
강변그랜드약국 1
 
0.5%
스마일약국 1
 
0.5%
광진백화점약국 1
 
0.5%
광진365플러스약국 1
 
0.5%
더샵스타시티약국 1
 
0.5%
Other values (182) 182
92.4%
2024-03-15T09:30:32.099410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 198
 
18.7%
국 197
 
18.6%
리 38
 
3.6%
온 32
 
3.0%
누 31
 
2.9%
자 17
 
1.6%
진 12
 
1.1%
대 11
 
1.0%
한 11
 
1.0%
사 10
 
0.9%
Other values (176) 504
47.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1053
99.2%
Decimal Number 8
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 198
 
18.8%
국 197
 
18.7%
리 38
 
3.6%
온 32
 
3.0%
누 31
 
2.9%
자 17
 
1.6%
진 12
 
1.1%
대 11
 
1.0%
한 11
 
1.0%
사 10
 
0.9%
Other values (171) 496
47.1%
Decimal Number
ValueCountFrequency (%)
6 2
25.0%
5 2
25.0%
3 2
25.0%
1 1
12.5%
2 1
12.5%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1053
99.2%
Common 8
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 198
 
18.8%
국 197
 
18.7%
리 38
 
3.6%
온 32
 
3.0%
누 31
 
2.9%
자 17
 
1.6%
진 12
 
1.1%
대 11
 
1.0%
한 11
 
1.0%
사 10
 
0.9%
Other values (171) 496
47.1%
Common
ValueCountFrequency (%)
6 2
25.0%
5 2
25.0%
3 2
25.0%
1 1
12.5%
2 1
12.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1053
99.2%
ASCII 8
 
0.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 198
 
18.8%
국 197
 
18.7%
리 38
 
3.6%
온 32
 
3.0%
누 31
 
2.9%
자 17
 
1.6%
진 12
 
1.1%
대 11
 
1.0%
한 11
 
1.0%
사 10
 
0.9%
Other values (171) 496
47.1%
ASCII
ValueCountFrequency (%)
6 2
25.0%
5 2
25.0%
3 2
25.0%
1 1
12.5%
2 1
12.5%

약국우편번호(도로명)
Real number (ℝ)

Distinct101
Distinct (%)51.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5012.9949
Minimum4902
Maximum5119
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2024-03-15T09:30:32.359136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4902
5-th percentile4910
Q14954
median5019
Q35066
95-th percentile5116
Maximum5119
Range217
Interquartile range (IQR)112

Descriptive statistics

Standard deviation65.722942
Coefficient of variation (CV)0.013110514
Kurtosis-1.1787873
Mean5012.9949
Median Absolute Deviation (MAD)53
Skewness-0.13319406
Sum987560
Variance4319.5051
MonotonicityNot monotonic
2024-03-15T09:30:32.714303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
5030 7
 
3.6%
4985 6
 
3.0%
4910 6
 
3.0%
5116 5
 
2.5%
5056 4
 
2.0%
4911 4
 
2.0%
4953 4
 
2.0%
4974 4
 
2.0%
5044 4
 
2.0%
5117 4
 
2.0%
Other values (91) 149
75.6%
ValueCountFrequency (%)
4902 2
 
1.0%
4903 1
 
0.5%
4904 1
 
0.5%
4905 1
 
0.5%
4908 2
 
1.0%
4909 1
 
0.5%
4910 6
3.0%
4911 4
2.0%
4918 1
 
0.5%
4919 4
2.0%
ValueCountFrequency (%)
5119 3
1.5%
5118 1
 
0.5%
5117 4
2.0%
5116 5
2.5%
5112 3
1.5%
5103 2
 
1.0%
5102 1
 
0.5%
5101 1
 
0.5%
5098 2
 
1.0%
5096 2
 
1.0%

약국소재지(도로명)
Text

Distinct192
Distinct (%)97.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2024-03-15T09:30:33.986704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length52
Median length45
Mean length30.091371
Min length22

Characters and Unicode

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

Unique

Unique187 ?
Unique (%)94.9%

Sample

1st row서울특별시 광진구 천호대로 566, 동우빌딩 1층 (능동)
2nd row서울특별시 광진구 아차산로 375, 크레신타워3차 1층 107호 (구의동)
3rd row서울특별시 광진구 천호대로 575, 1층 (중곡동)
4th row서울특별시 광진구 자양로15길 26, 1층 (자양동)
5th row서울특별시 광진구 천호대로 670, 썬-타워빌딩 1층 102호 (구의동)
ValueCountFrequency (%)
서울특별시 197
 
16.1%
광진구 197
 
16.1%
1층 80
 
6.5%
자양동 59
 
4.8%
중곡동 48
 
3.9%
구의동 42
 
3.4%
아차산로 26
 
2.1%
능동로 22
 
1.8%
화양동 20
 
1.6%
자양로 20
 
1.6%
Other values (319) 512
41.9%
2024-03-15T09:30:35.422080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1026
 
17.3%
1 254
 
4.3%
구 249
 
4.2%
동 236
 
4.0%
광 227
 
3.8%
진 204
 
3.4%
시 202
 
3.4%
서 198
 
3.3%
울 198
 
3.3%
특 197
 
3.3%
Other values (165) 2937
49.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3467
58.5%
Space Separator 1026
 
17.3%
Decimal Number 858
 
14.5%
Close Punctuation 197
 
3.3%
Open Punctuation 197
 
3.3%
Other Punctuation 151
 
2.5%
Dash Punctuation 17
 
0.3%
Uppercase Letter 13
 
0.2%
Math Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 249
 
7.2%
동 236
 
6.8%
광 227
 
6.5%
진 204
 
5.9%
시 202
 
5.8%
서 198
 
5.7%
울 198
 
5.7%
특 197
 
5.7%
별 197
 
5.7%
로 197
 
5.7%
Other values (142) 1362
39.3%
Decimal Number
ValueCountFrequency (%)
1 254
29.6%
2 96
 
11.2%
5 88
 
10.3%
0 85
 
9.9%
3 77
 
9.0%
4 66
 
7.7%
6 63
 
7.3%
7 45
 
5.2%
8 43
 
5.0%
9 41
 
4.8%
Uppercase Letter
ValueCountFrequency (%)
B 4
30.8%
A 2
15.4%
C 2
15.4%
D 2
15.4%
I 1
 
7.7%
M 1
 
7.7%
K 1
 
7.7%
Space Separator
ValueCountFrequency (%)
1026
100.0%
Close Punctuation
ValueCountFrequency (%)
) 197
100.0%
Open Punctuation
ValueCountFrequency (%)
( 197
100.0%
Other Punctuation
ValueCountFrequency (%)
, 151
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3467
58.5%
Common 2448
41.3%
Latin 13
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 249
 
7.2%
동 236
 
6.8%
광 227
 
6.5%
진 204
 
5.9%
시 202
 
5.8%
서 198
 
5.7%
울 198
 
5.7%
특 197
 
5.7%
별 197
 
5.7%
로 197
 
5.7%
Other values (142) 1362
39.3%
Common
ValueCountFrequency (%)
1026
41.9%
1 254
 
10.4%
) 197
 
8.0%
( 197
 
8.0%
, 151
 
6.2%
2 96
 
3.9%
5 88
 
3.6%
0 85
 
3.5%
3 77
 
3.1%
4 66
 
2.7%
Other values (6) 211
 
8.6%
Latin
ValueCountFrequency (%)
B 4
30.8%
A 2
15.4%
C 2
15.4%
D 2
15.4%
I 1
 
7.7%
M 1
 
7.7%
K 1
 
7.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3467
58.5%
ASCII 2461
41.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1026
41.7%
1 254
 
10.3%
) 197
 
8.0%
( 197
 
8.0%
, 151
 
6.1%
2 96
 
3.9%
5 88
 
3.6%
0 85
 
3.5%
3 77
 
3.1%
4 66
 
2.7%
Other values (13) 224
 
9.1%
Hangul
ValueCountFrequency (%)
구 249
 
7.2%
동 236
 
6.8%
광 227
 
6.5%
진 204
 
5.9%
시 202
 
5.8%
서 198
 
5.7%
울 198
 
5.7%
특 197
 
5.7%
별 197
 
5.7%
로 197
 
5.7%
Other values (142) 1362
39.3%

Interactions

2024-03-15T09:30:27.296338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T09:30:26.700564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T09:30:27.577954image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T09:30:26.981717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T09:30:35.578033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번약국우편번호(도로명)
순번1.0000.295
약국우편번호(도로명)0.2951.000
2024-03-15T09:30:35.720097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번약국우편번호(도로명)
순번1.000-0.046
약국우편번호(도로명)-0.0461.000

Missing values

2024-03-15T09:30:27.929536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T09:30:28.255761image/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광진365플러스약국4985서울특별시 광진구 천호대로 566, 동우빌딩 1층 (능동)
12라인약국5044서울특별시 광진구 아차산로 375, 크레신타워3차 1층 107호 (구의동)
23가원약국4930서울특별시 광진구 천호대로 575, 1층 (중곡동)
34제일약국5055서울특별시 광진구 자양로15길 26, 1층 (자양동)
45아차산봄약국4992서울특별시 광진구 천호대로 670, 썬-타워빌딩 1층 102호 (구의동)
56온누리강변프라자약국5119서울특별시 광진구 광나루로56길 63, 프라임프라자 107~109호 (구의동)
67온누리강변프라자약국5119서울특별시 광진구 광나루로56길 63, 프라임프라자 107~109호 (구의동)
78노르웨이약국4971서울특별시 광진구 아차산로 552, 상가동 1층 102호 (광장동, 광장극동아파트)
89프라자사랑약국4919서울특별시 광진구 능동로 315, DM빌딩 1층 (중곡동)
910구의사랑약국5032서울특별시 광진구 광나루로 542, 1층 (구의동)
순번약국명칭약국우편번호(도로명)약국소재지(도로명)
187188연진약국5018서울특별시 광진구 아차산로29길 12 (화양동)
188189성동약국5093서울특별시 광진구 자양번영로 11 (자양동)
189190광해약국4985서울특별시 광진구 능동로 298 (능동)
190191성진약국4902서울특별시 광진구 면목로 203 (중곡동)
191192용상약국4969서울특별시 광진구 아차산로 626 (광장동)
192193조광옵티마약국4910서울특별시 광진구 긴고랑로9길 29 (중곡동)
193194진명약국4998서울특별시 광진구 군자로 144 (군자동)
194195기호약국5012서울특별시 광진구 군자로 25 (화양동)
195196용마약국4991서울특별시 광진구 자양로 201, 항석빌딩 1층 (구의동)
196197진약국4994서울특별시 광진구 동일로60길 14 (군자동)