Overview

Dataset statistics

Number of variables5
Number of observations172
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.0 KiB
Average record size in memory41.8 B

Variable types

Numeric1
Text3
Categorical1

Dataset

Description경기도 김포시 약국 현황 정보에 대한 데이터로 약국명, 전화번호, 소재지주소, 데이터기준일자 등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15036626/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 21:31:21.834803
Analysis finished2023-12-12 21:31:22.289676
Duration0.45 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct172
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean86.5
Minimum1
Maximum172
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2023-12-13T06:31:22.354302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile9.55
Q143.75
median86.5
Q3129.25
95-th percentile163.45
Maximum172
Range171
Interquartile range (IQR)85.5

Descriptive statistics

Standard deviation49.796252
Coefficient of variation (CV)0.57567921
Kurtosis-1.2
Mean86.5
Median Absolute Deviation (MAD)43
Skewness0
Sum14878
Variance2479.6667
MonotonicityStrictly increasing
2023-12-13T06:31:22.477418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
120 1
 
0.6%
112 1
 
0.6%
113 1
 
0.6%
114 1
 
0.6%
115 1
 
0.6%
116 1
 
0.6%
117 1
 
0.6%
118 1
 
0.6%
119 1
 
0.6%
Other values (162) 162
94.2%
ValueCountFrequency (%)
1 1
0.6%
2 1
0.6%
3 1
0.6%
4 1
0.6%
5 1
0.6%
6 1
0.6%
7 1
0.6%
8 1
0.6%
9 1
0.6%
10 1
0.6%
ValueCountFrequency (%)
172 1
0.6%
171 1
0.6%
170 1
0.6%
169 1
0.6%
168 1
0.6%
167 1
0.6%
166 1
0.6%
165 1
0.6%
164 1
0.6%
163 1
0.6%

약국명칭
Text

Distinct167
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2023-12-13T06:31:22.776789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length9
Mean length5.2267442
Min length3

Characters and Unicode

Total characters899
Distinct characters175
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique162 ?
Unique (%)94.2%

Sample

1st row봄빛약국
2nd row주연메디칼약국
3rd row걸포솔약국
4th row좋은우리약국
5th row감사약국
ValueCountFrequency (%)
착한약국 2
 
1.2%
이화약국 2
 
1.2%
한마음약국 2
 
1.2%
사우프라자약국 2
 
1.2%
행복약국 2
 
1.2%
김포홈플러스약국 1
 
0.6%
솔약국 1
 
0.6%
건강프라자약국 1
 
0.6%
김포도담약국 1
 
0.6%
드림약국 1
 
0.6%
Other values (157) 157
91.3%
2023-12-13T06:31:23.200783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 173
19.2%
국 172
 
19.1%
리 25
 
2.8%
온 20
 
2.2%
누 18
 
2.0%
한 15
 
1.7%
메 13
 
1.4%
디 12
 
1.3%
우 11
 
1.2%
사 10
 
1.1%
Other values (165) 430
47.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 899
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 173
19.2%
국 172
 
19.1%
리 25
 
2.8%
온 20
 
2.2%
누 18
 
2.0%
한 15
 
1.7%
메 13
 
1.4%
디 12
 
1.3%
우 11
 
1.2%
사 10
 
1.1%
Other values (165) 430
47.8%

Most occurring scripts

ValueCountFrequency (%)
Hangul 899
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 173
19.2%
국 172
 
19.1%
리 25
 
2.8%
온 20
 
2.2%
누 18
 
2.0%
한 15
 
1.7%
메 13
 
1.4%
디 12
 
1.3%
우 11
 
1.2%
사 10
 
1.1%
Other values (165) 430
47.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 899
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 173
19.2%
국 172
 
19.1%
리 25
 
2.8%
온 20
 
2.2%
누 18
 
2.0%
한 15
 
1.7%
메 13
 
1.4%
디 12
 
1.3%
우 11
 
1.2%
사 10
 
1.1%
Other values (165) 430
47.8%

약국전화번호
Text

Distinct167
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2023-12-13T06:31:23.484773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.081395
Min length12

Characters and Unicode

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

Unique162 ?
Unique (%)94.2%

Sample

1st row031-996-2386
2nd row031-983-9799
3rd row031-988-7750
4th row031-987-7718
5th row031-997-3722
ValueCountFrequency (%)
031-998-7518 2
 
1.2%
031-983-2111 2
 
1.2%
031-984-7666 2
 
1.2%
031-989-8764 2
 
1.2%
031-997-2847 2
 
1.2%
031-998-7250 1
 
0.6%
031-983-4996 1
 
0.6%
031-998-0295 1
 
0.6%
031-987-5936 1
 
0.6%
031-989-1547 1
 
0.6%
Other values (157) 157
91.3%
2023-12-13T06:31:23.819844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 344
16.6%
9 288
13.9%
0 265
12.8%
3 257
12.4%
1 250
12.0%
8 233
11.2%
7 125
 
6.0%
6 89
 
4.3%
5 87
 
4.2%
2 76
 
3.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1734
83.4%
Dash Punctuation 344
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
9 288
16.6%
0 265
15.3%
3 257
14.8%
1 250
14.4%
8 233
13.4%
7 125
7.2%
6 89
 
5.1%
5 87
 
5.0%
2 76
 
4.4%
4 64
 
3.7%
Dash Punctuation
ValueCountFrequency (%)
- 344
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2078
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 344
16.6%
9 288
13.9%
0 265
12.8%
3 257
12.4%
1 250
12.0%
8 233
11.2%
7 125
 
6.0%
6 89
 
4.3%
5 87
 
4.2%
2 76
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2078
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 344
16.6%
9 288
13.9%
0 265
12.8%
3 257
12.4%
1 250
12.0%
8 233
11.2%
7 125
 
6.0%
6 89
 
4.3%
5 87
 
4.2%
2 76
 
3.7%

약국소재지(도로명)
Text

Distinct165
Distinct (%)95.9%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2023-12-13T06:31:24.072245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length56
Median length40
Mean length31.656977
Min length18

Characters and Unicode

Total characters5445
Distinct characters201
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

Unique159 ?
Unique (%)92.4%

Sample

1st row경기도 김포시 김포한강8로 172, 104호 (마산동)
2nd row경기도 김포시 중봉로 9, 1층 (감정동)
3rd row경기도 김포시 걸포2로 21, 110호 (걸포동)
4th row경기도 김포시 감암로 7 (걸포동)
5th row경기도 김포시 고촌읍 김포대로 340, 김포뉴시티 1층 104호
ValueCountFrequency (%)
경기도 172
 
15.2%
김포시 172
 
15.2%
1층 35
 
3.1%
장기동 32
 
2.8%
구래동 23
 
2.0%
김포대로 20
 
1.8%
풍무동 17
 
1.5%
103호 16
 
1.4%
사우동 15
 
1.3%
102호 15
 
1.3%
Other values (355) 613
54.2%
2023-12-13T06:31:24.465558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
960
 
17.6%
1 292
 
5.4%
포 273
 
5.0%
김 262
 
4.8%
기 210
 
3.9%
, 182
 
3.3%
시 179
 
3.3%
도 175
 
3.2%
로 174
 
3.2%
경 173
 
3.2%
Other values (191) 2565
47.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3051
56.0%
Decimal Number 975
 
17.9%
Space Separator 960
 
17.6%
Other Punctuation 182
 
3.3%
Close Punctuation 130
 
2.4%
Open Punctuation 130
 
2.4%
Dash Punctuation 13
 
0.2%
Uppercase Letter 3
 
0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
포 273
 
8.9%
김 262
 
8.6%
기 210
 
6.9%
시 179
 
5.9%
도 175
 
5.7%
로 174
 
5.7%
경 173
 
5.7%
동 141
 
4.6%
호 110
 
3.6%
한 67
 
2.2%
Other values (172) 1287
42.2%
Decimal Number
ValueCountFrequency (%)
1 292
29.9%
0 138
14.2%
2 126
12.9%
3 105
 
10.8%
8 74
 
7.6%
4 67
 
6.9%
5 55
 
5.6%
7 50
 
5.1%
9 37
 
3.8%
6 31
 
3.2%
Uppercase Letter
ValueCountFrequency (%)
M 1
33.3%
S 1
33.3%
H 1
33.3%
Space Separator
ValueCountFrequency (%)
960
100.0%
Other Punctuation
ValueCountFrequency (%)
, 182
100.0%
Close Punctuation
ValueCountFrequency (%)
) 130
100.0%
Open Punctuation
ValueCountFrequency (%)
( 130
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3051
56.0%
Common 2390
43.9%
Latin 4
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
포 273
 
8.9%
김 262
 
8.6%
기 210
 
6.9%
시 179
 
5.9%
도 175
 
5.7%
로 174
 
5.7%
경 173
 
5.7%
동 141
 
4.6%
호 110
 
3.6%
한 67
 
2.2%
Other values (172) 1287
42.2%
Common
ValueCountFrequency (%)
960
40.2%
1 292
 
12.2%
, 182
 
7.6%
0 138
 
5.8%
) 130
 
5.4%
( 130
 
5.4%
2 126
 
5.3%
3 105
 
4.4%
8 74
 
3.1%
4 67
 
2.8%
Other values (5) 186
 
7.8%
Latin
ValueCountFrequency (%)
M 1
25.0%
S 1
25.0%
H 1
25.0%
e 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3051
56.0%
ASCII 2394
44.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
960
40.1%
1 292
 
12.2%
, 182
 
7.6%
0 138
 
5.8%
) 130
 
5.4%
( 130
 
5.4%
2 126
 
5.3%
3 105
 
4.4%
8 74
 
3.1%
4 67
 
2.8%
Other values (9) 190
 
7.9%
Hangul
ValueCountFrequency (%)
포 273
 
8.9%
김 262
 
8.6%
기 210
 
6.9%
시 179
 
5.9%
도 175
 
5.7%
로 174
 
5.7%
경 173
 
5.7%
동 141
 
4.6%
호 110
 
3.6%
한 67
 
2.2%
Other values (172) 1287
42.2%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2023-06-15
172 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-06-15
2nd row2023-06-15
3rd row2023-06-15
4th row2023-06-15
5th row2023-06-15

Common Values

ValueCountFrequency (%)
2023-06-15 172
100.0%

Length

2023-12-13T06:31:24.602073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:31:24.695218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-06-15 172
100.0%

Interactions

2023-12-13T06:31:22.050916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-13T06:31:22.163073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:31:22.252897image/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봄빛약국031-996-2386경기도 김포시 김포한강8로 172, 104호 (마산동)2023-06-15
12주연메디칼약국031-983-9799경기도 김포시 중봉로 9, 1층 (감정동)2023-06-15
23걸포솔약국031-988-7750경기도 김포시 걸포2로 21, 110호 (걸포동)2023-06-15
34좋은우리약국031-987-7718경기도 김포시 감암로 7 (걸포동)2023-06-15
45감사약국031-997-3722경기도 김포시 고촌읍 김포대로 340, 김포뉴시티 1층 104호2023-06-15
56사랑약국031-987-5775경기도 김포시 김포한강9로 109, 제1층 102호 (구래동)2023-06-15
67고촌가을약국031-982-2577경기도 김포시 고촌읍 태리로 285, 103호2023-06-15
78한별서울약국031-989-8853경기도 김포시 김포대로 847, 중앙프라자 1층 102호 일부호 (사우동)2023-06-15
89킹콩약국031-985-5353경기도 김포시 김포한강4로 129, 하나프라자 103호 (장기동)2023-06-15
910햇살약국031-998-6230경기도 김포시 솔터로 22, 301동 1층 148호 (구래동, 메트로타워 예미지)2023-06-15
순번약국명칭약국전화번호약국소재지(도로명)데이터기준일자
162163풍무우리들약국031-996-4321경기도 김포시 유현로238번길 31, 웅신타워 3층 301호 (풍무동)2023-06-15
163164미성약국031-982-6858경기도 김포시 청송로 26, 1층 103호 (장기동, 청송현대쇼핑센터)2023-06-15
164165한미약국031-989-5612경기도 김포시 통진읍 김포대로2230번길 24, 1층2023-06-15
165166연세한아름약국031-985-3011경기도 김포시 고촌읍 장차로 1, 101호2023-06-15
166167마송서울약국031-987-1016경기도 김포시 통진읍 조강로 49-12023-06-15
167168보원약국031-982-1047경기도 김포시 김포대로 835 (사우동)2023-06-15
168169고촌약국031-986-3312경기도 김포시 고촌읍 장차로 102023-06-15
169170시장약국031-988-5317경기도 김포시 통진읍 서암로 842023-06-15
170171해정약국031-982-0634경기도 김포시 북변중로 38-1 (북변동)2023-06-15
171172김포약국031-984-2029경기도 김포시 북변중로 70 (북변동)2023-06-15