Overview

Dataset statistics

Number of variables4
Number of observations249
Missing cells16
Missing cells (%)1.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.2 KiB
Average record size in memory33.5 B

Variable types

Numeric1
Text3

Dataset

Description부평구 약국 현황(순번 ,약국명칭,소재지,약국전화번호)예)2,착한약국,인천광역시 부평구 길주남로 157, 태성프라자 101호 (부개동),070-7788-7582
Author인천광역시 부평구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=3045123&srcSe=7661IVAWM27C61E190

Alerts

약국전화번호 has 16 (6.4%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2024-03-18 02:04:58.939122
Analysis finished2024-03-18 02:04:59.643029
Duration0.7 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
2024-03-18T11:04:59.706984image/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
2024-03-18T11:04:59.821826image/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

Distinct243
Distinct (%)97.6%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
2024-03-18T11:05:00.086778image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length10
Mean length5.0562249
Min length3

Characters and Unicode

Total characters1259
Distinct characters199
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

Unique237 ?
Unique (%)95.2%

Sample

1st row부개바른약국
2nd row부개하늘약국
3rd row휴베이스 가정약국
4th row갈산종로약국
5th row도담약국
ValueCountFrequency (%)
수보당약국 2
 
0.8%
경인약국 2
 
0.8%
신생약국 2
 
0.8%
현대메디칼약국 2
 
0.8%
노벨약국 2
 
0.8%
엘림약국 2
 
0.8%
한아름온누리약국 1
 
0.4%
성모메디칼약국 1
 
0.4%
일신약국 1
 
0.4%
명성온누리약국 1
 
0.4%
Other values (234) 234
93.6%
2024-03-18T11:05:00.459044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 249
19.8%
국 249
19.8%
부 31
 
2.5%
평 26
 
2.1%
한 24
 
1.9%
리 24
 
1.9%
온 16
 
1.3%
누 16
 
1.3%
동 13
 
1.0%
나 13
 
1.0%
Other values (189) 598
47.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1246
99.0%
Decimal Number 12
 
1.0%
Space Separator 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 249
20.0%
국 249
20.0%
부 31
 
2.5%
평 26
 
2.1%
한 24
 
1.9%
리 24
 
1.9%
온 16
 
1.3%
누 16
 
1.3%
동 13
 
1.0%
나 13
 
1.0%
Other values (182) 585
47.0%
Decimal Number
ValueCountFrequency (%)
3 3
25.0%
6 3
25.0%
5 3
25.0%
1 1
 
8.3%
2 1
 
8.3%
4 1
 
8.3%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1246
99.0%
Common 13
 
1.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 249
20.0%
국 249
20.0%
부 31
 
2.5%
평 26
 
2.1%
한 24
 
1.9%
리 24
 
1.9%
온 16
 
1.3%
누 16
 
1.3%
동 13
 
1.0%
나 13
 
1.0%
Other values (182) 585
47.0%
Common
ValueCountFrequency (%)
3 3
23.1%
6 3
23.1%
5 3
23.1%
1 1
 
7.7%
2 1
 
7.7%
1
 
7.7%
4 1
 
7.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1246
99.0%
ASCII 13
 
1.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 249
20.0%
국 249
20.0%
부 31
 
2.5%
평 26
 
2.1%
한 24
 
1.9%
리 24
 
1.9%
온 16
 
1.3%
누 16
 
1.3%
동 13
 
1.0%
나 13
 
1.0%
Other values (182) 585
47.0%
ASCII
ValueCountFrequency (%)
3 3
23.1%
6 3
23.1%
5 3
23.1%
1 1
 
7.7%
2 1
 
7.7%
1
 
7.7%
4 1
 
7.7%

약국소재지(도로명)
Text

Distinct241
Distinct (%)96.8%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
2024-03-18T11:05:00.731906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length52
Median length41
Mean length30.253012
Min length20

Characters and Unicode

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

Unique

Unique233 ?
Unique (%)93.6%

Sample

1st row인천광역시 부평구 경인로1104번길 18, 1층 일부호 (부개동)
2nd row인천광역시 부평구 부일로 85, 1층 일부호 (부개동)
3rd row인천광역시 부평구 길주로494번길 25, 1층 일부호 (청천동)
4th row인천광역시 부평구 평천로 302, 102호 (갈산동)
5th row인천광역시 부평구 세월천로 42, 1층 (청천동)
ValueCountFrequency (%)
인천광역시 249
 
16.5%
부평구 249
 
16.5%
부평동 106
 
7.0%
1층 54
 
3.6%
산곡동 37
 
2.5%
부개동 28
 
1.9%
삼산동 23
 
1.5%
부평대로 22
 
1.5%
청천동 21
 
1.4%
십정동 20
 
1.3%
Other values (386) 700
46.4%
2024-03-18T11:05:01.166327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1260
 
16.7%
부 485
 
6.4%
평 408
 
5.4%
1 330
 
4.4%
동 282
 
3.7%
천 279
 
3.7%
인 265
 
3.5%
시 258
 
3.4%
광 257
 
3.4%
역 252
 
3.3%
Other values (196) 3457
45.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4402
58.4%
Space Separator 1260
 
16.7%
Decimal Number 1131
 
15.0%
Close Punctuation 250
 
3.3%
Open Punctuation 250
 
3.3%
Other Punctuation 200
 
2.7%
Dash Punctuation 26
 
0.3%
Uppercase Letter 9
 
0.1%
Lowercase Letter 4
 
0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
부 485
 
11.0%
평 408
 
9.3%
동 282
 
6.4%
천 279
 
6.3%
인 265
 
6.0%
시 258
 
5.9%
광 257
 
5.8%
역 252
 
5.7%
구 251
 
5.7%
로 249
 
5.7%
Other values (166) 1416
32.2%
Decimal Number
ValueCountFrequency (%)
1 330
29.2%
0 142
12.6%
2 130
 
11.5%
4 119
 
10.5%
3 119
 
10.5%
5 74
 
6.5%
6 63
 
5.6%
8 60
 
5.3%
7 52
 
4.6%
9 42
 
3.7%
Uppercase Letter
ValueCountFrequency (%)
D 1
11.1%
Y 1
11.1%
F 1
11.1%
K 1
11.1%
R 1
11.1%
A 1
11.1%
P 1
11.1%
I 1
11.1%
M 1
11.1%
Lowercase Letter
ValueCountFrequency (%)
y 1
25.0%
t 1
25.0%
i 1
25.0%
c 1
25.0%
Other Punctuation
ValueCountFrequency (%)
, 199
99.5%
· 1
 
0.5%
Space Separator
ValueCountFrequency (%)
1260
100.0%
Close Punctuation
ValueCountFrequency (%)
) 250
100.0%
Open Punctuation
ValueCountFrequency (%)
( 250
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 26
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4402
58.4%
Common 3118
41.4%
Latin 13
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
부 485
 
11.0%
평 408
 
9.3%
동 282
 
6.4%
천 279
 
6.3%
인 265
 
6.0%
시 258
 
5.9%
광 257
 
5.8%
역 252
 
5.7%
구 251
 
5.7%
로 249
 
5.7%
Other values (166) 1416
32.2%
Common
ValueCountFrequency (%)
1260
40.4%
1 330
 
10.6%
) 250
 
8.0%
( 250
 
8.0%
, 199
 
6.4%
0 142
 
4.6%
2 130
 
4.2%
4 119
 
3.8%
3 119
 
3.8%
5 74
 
2.4%
Other values (7) 245
 
7.9%
Latin
ValueCountFrequency (%)
D 1
 
7.7%
Y 1
 
7.7%
F 1
 
7.7%
y 1
 
7.7%
K 1
 
7.7%
R 1
 
7.7%
A 1
 
7.7%
P 1
 
7.7%
I 1
 
7.7%
t 1
 
7.7%
Other values (3) 3
23.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4402
58.4%
ASCII 3130
41.6%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1260
40.3%
1 330
 
10.5%
) 250
 
8.0%
( 250
 
8.0%
, 199
 
6.4%
0 142
 
4.5%
2 130
 
4.2%
4 119
 
3.8%
3 119
 
3.8%
5 74
 
2.4%
Other values (19) 257
 
8.2%
Hangul
ValueCountFrequency (%)
부 485
 
11.0%
평 408
 
9.3%
동 282
 
6.4%
천 279
 
6.3%
인 265
 
6.0%
시 258
 
5.9%
광 257
 
5.8%
역 252
 
5.7%
구 251
 
5.7%
로 249
 
5.7%
Other values (166) 1416
32.2%
None
ValueCountFrequency (%)
· 1
100.0%

약국전화번호
Text

MISSING 

Distinct227
Distinct (%)97.4%
Missing16
Missing (%)6.4%
Memory size2.1 KiB
2024-03-18T11:05:01.404230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique221 ?
Unique (%)94.8%

Sample

1st row032-523-3370
2nd row032-506-3334
3rd row032-362-1017
4th row032-426-1555
5th row032-501-0598
ValueCountFrequency (%)
032-330-7571 2
 
0.9%
032-517-1574 2
 
0.9%
032-511-3589 2
 
0.9%
032-523-2233 2
 
0.9%
032-503-5050 2
 
0.9%
032-518-5456 2
 
0.9%
032-511-1666 1
 
0.4%
032-506-1101 1
 
0.4%
032-524-5800 1
 
0.4%
032-330-2468 1
 
0.4%
Other values (217) 217
93.1%
2024-03-18T11:05:01.741074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 466
16.7%
0 455
16.3%
2 416
14.9%
3 405
14.5%
5 333
11.9%
1 168
 
6.0%
8 130
 
4.6%
7 128
 
4.6%
4 108
 
3.9%
6 107
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2330
83.3%
Dash Punctuation 466
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 455
19.5%
2 416
17.9%
3 405
17.4%
5 333
14.3%
1 168
 
7.2%
8 130
 
5.6%
7 128
 
5.5%
4 108
 
4.6%
6 107
 
4.6%
9 80
 
3.4%
Dash Punctuation
ValueCountFrequency (%)
- 466
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2796
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 466
16.7%
0 455
16.3%
2 416
14.9%
3 405
14.5%
5 333
11.9%
1 168
 
6.0%
8 130
 
4.6%
7 128
 
4.6%
4 108
 
3.9%
6 107
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2796
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 466
16.7%
0 455
16.3%
2 416
14.9%
3 405
14.5%
5 333
11.9%
1 168
 
6.0%
8 130
 
4.6%
7 128
 
4.6%
4 108
 
3.9%
6 107
 
3.8%

Interactions

2024-03-18T11:04:59.454206image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2024-03-18T11:04:59.543608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-18T11:04:59.609960image/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부개바른약국인천광역시 부평구 경인로1104번길 18, 1층 일부호 (부개동)032-523-3370
12부개하늘약국인천광역시 부평구 부일로 85, 1층 일부호 (부개동)032-506-3334
23휴베이스 가정약국인천광역시 부평구 길주로494번길 25, 1층 일부호 (청천동)032-362-1017
34갈산종로약국인천광역시 부평구 평천로 302, 102호 (갈산동)<NA>
45도담약국인천광역시 부평구 세월천로 42, 1층 (청천동)<NA>
56동암조은약국인천광역시 부평구 열우물로87번길 16, 1층 일부호 (십정동)032-426-1555
67하나온누리약국인천광역시 부평구 마장로 430, 102호 (청천동)032-501-0598
78부평평화약국인천광역시 부평구 시장로 32, 1층 102,103호 (부평동)032-710-9415
89스타약국인천광역시 부평구 부흥로 393, 1층 (부개동)032-330-9858
910우주약국인천광역시 부평구 시장로 7(부평동)032-503-8003
순번약국명칭약국소재지(도로명)약국전화번호
239240평화약국인천광역시 부평구 동수로120번길 11, 101호 (부개동, 한국상가)032-501-1239
240241십자메디칼약국인천광역시 부평구 청중로 65, 1층 105호 (청천동)032-525-3915
241242삼천당약국인천광역시 부평구 시장로 35-2 (부평동)032-503-6470
242243십정약국인천광역시 부평구 배곶남로9번길 22 (십정동)032-422-6087
243244부부약국인천광역시 부평구 경인로 943 (부평동)032-501-2034
244245동대약국인천광역시 부평구 부평대로 114 (부평동)032-527-1991
245246동민약국인천광역시 부평구 부흥로 408 (부개동)032-502-6418
246247대한약국인천광역시 부평구 부평대로 44 (부평동)032-503-4020
247248서울당약국인천광역시 부평구 부평북로 159 (청천동)032-502-0467
248249일광온누리약국인천광역시 부평구 부평문화로 99 (부평동)032-503-1768