Overview

Dataset statistics

Number of variables4
Number of observations396
Missing cells275
Missing cells (%)17.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.9 KiB
Average record size in memory33.3 B

Variable types

Numeric1
Text3

Dataset

Description인천광역시 부평구 안전상비의약품 판매업 현황데이터는 판매점포명, 판매점포 전화번호, 판매점포 소재지(도로명)데이터를 제공합니다.
Author인천광역시 부평구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15102593&srcSe=7661IVAWM27C61E190

Alerts

전화번호 has 275 (69.4%) missing valuesMissing
순번 has unique valuesUnique
소재지(도로명) has unique valuesUnique

Reproduction

Analysis started2024-03-18 05:09:16.066325
Analysis finished2024-03-18 05:09:17.073394
Duration1.01 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct396
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean198.5
Minimum1
Maximum396
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.6 KiB
2024-03-18T14:09:17.173390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile20.75
Q199.75
median198.5
Q3297.25
95-th percentile376.25
Maximum396
Range395
Interquartile range (IQR)197.5

Descriptive statistics

Standard deviation114.4596
Coefficient of variation (CV)0.57662267
Kurtosis-1.2
Mean198.5
Median Absolute Deviation (MAD)99
Skewness0
Sum78606
Variance13101
MonotonicityStrictly increasing
2024-03-18T14:09:17.354070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
274 1
 
0.3%
272 1
 
0.3%
271 1
 
0.3%
270 1
 
0.3%
269 1
 
0.3%
268 1
 
0.3%
267 1
 
0.3%
266 1
 
0.3%
265 1
 
0.3%
Other values (386) 386
97.5%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
396 1
0.3%
395 1
0.3%
394 1
0.3%
393 1
0.3%
392 1
0.3%
391 1
0.3%
390 1
0.3%
389 1
0.3%
388 1
0.3%
387 1
0.3%
Distinct394
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Memory size3.2 KiB
2024-03-18T14:09:17.630601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length17
Mean length10.823232
Min length4

Characters and Unicode

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

Unique

Unique392 ?
Unique (%)99.0%

Sample

1st row지에스25 부평항동로점
2nd row(주)코리아세븐 부평남부점
3rd row세븐일레븐 부평신일점
4th row씨유 부평힐스테이트점
5th row지에스25 부평힘찬점
ValueCountFrequency (%)
씨유 95
 
13.4%
지에스25 64
 
9.1%
세븐일레븐 60
 
8.5%
주)코리아세븐 27
 
3.8%
gs25 22
 
3.1%
이마트24 19
 
2.7%
지에스(gs)25 15
 
2.1%
부평힘찬점 3
 
0.4%
부평공원점 3
 
0.4%
부평현대점 2
 
0.3%
Other values (383) 397
56.2%
2024-03-18T14:09:18.013262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
357
 
8.3%
313
 
7.3%
283
 
6.6%
225
 
5.2%
174
 
4.1%
2 159
 
3.7%
134
 
3.1%
5 131
 
3.1%
129
 
3.0%
117
 
2.7%
Other values (228) 2264
52.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3408
79.5%
Decimal Number 329
 
7.7%
Space Separator 313
 
7.3%
Uppercase Letter 128
 
3.0%
Close Punctuation 54
 
1.3%
Open Punctuation 54
 
1.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
357
 
10.5%
283
 
8.3%
225
 
6.6%
174
 
5.1%
134
 
3.9%
129
 
3.8%
117
 
3.4%
108
 
3.2%
105
 
3.1%
100
 
2.9%
Other values (210) 1676
49.2%
Uppercase Letter
ValueCountFrequency (%)
S 55
43.0%
G 52
40.6%
R 6
 
4.7%
U 6
 
4.7%
C 4
 
3.1%
K 3
 
2.3%
J 1
 
0.8%
Y 1
 
0.8%
Decimal Number
ValueCountFrequency (%)
2 159
48.3%
5 131
39.8%
4 26
 
7.9%
1 7
 
2.1%
3 3
 
0.9%
7 2
 
0.6%
6 1
 
0.3%
Space Separator
ValueCountFrequency (%)
313
100.0%
Close Punctuation
ValueCountFrequency (%)
) 54
100.0%
Open Punctuation
ValueCountFrequency (%)
( 54
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3408
79.5%
Common 750
 
17.5%
Latin 128
 
3.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
357
 
10.5%
283
 
8.3%
225
 
6.6%
174
 
5.1%
134
 
3.9%
129
 
3.8%
117
 
3.4%
108
 
3.2%
105
 
3.1%
100
 
2.9%
Other values (210) 1676
49.2%
Common
ValueCountFrequency (%)
313
41.7%
2 159
21.2%
5 131
17.5%
) 54
 
7.2%
( 54
 
7.2%
4 26
 
3.5%
1 7
 
0.9%
3 3
 
0.4%
7 2
 
0.3%
6 1
 
0.1%
Latin
ValueCountFrequency (%)
S 55
43.0%
G 52
40.6%
R 6
 
4.7%
U 6
 
4.7%
C 4
 
3.1%
K 3
 
2.3%
J 1
 
0.8%
Y 1
 
0.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3408
79.5%
ASCII 878
 
20.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
357
 
10.5%
283
 
8.3%
225
 
6.6%
174
 
5.1%
134
 
3.9%
129
 
3.8%
117
 
3.4%
108
 
3.2%
105
 
3.1%
100
 
2.9%
Other values (210) 1676
49.2%
ASCII
ValueCountFrequency (%)
313
35.6%
2 159
18.1%
5 131
14.9%
S 55
 
6.3%
) 54
 
6.2%
( 54
 
6.2%
G 52
 
5.9%
4 26
 
3.0%
1 7
 
0.8%
R 6
 
0.7%
Other values (8) 21
 
2.4%

전화번호
Text

MISSING 

Distinct121
Distinct (%)100.0%
Missing275
Missing (%)69.4%
Memory size3.2 KiB
2024-03-18T14:09:18.302582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.991736
Min length11

Characters and Unicode

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

Unique121 ?
Unique (%)100.0%

Sample

1st row032-423-6871
2nd row032-528-9029
3rd row032-572-8752
4th row032-529-4560
5th row032-503-0941
ValueCountFrequency (%)
032-526-4434 1
 
0.8%
032-503-4314 1
 
0.8%
032-429-4977 1
 
0.8%
032-505-9164 1
 
0.8%
032-330-3835 1
 
0.8%
032-507-4939 1
 
0.8%
032-506-1199 1
 
0.8%
032-429-7755 1
 
0.8%
032-362-2555 1
 
0.8%
032-525-1727 1
 
0.8%
Other values (111) 111
91.7%
2024-03-18T14:09:18.661884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 241
16.6%
2 227
15.6%
0 224
15.4%
3 195
13.4%
5 169
11.6%
1 99
6.8%
7 66
 
4.5%
6 63
 
4.3%
4 60
 
4.1%
9 59
 
4.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1210
83.4%
Dash Punctuation 241
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 227
18.8%
0 224
18.5%
3 195
16.1%
5 169
14.0%
1 99
8.2%
7 66
 
5.5%
6 63
 
5.2%
4 60
 
5.0%
9 59
 
4.9%
8 48
 
4.0%
Dash Punctuation
ValueCountFrequency (%)
- 241
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1451
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 241
16.6%
2 227
15.6%
0 224
15.4%
3 195
13.4%
5 169
11.6%
1 99
6.8%
7 66
 
4.5%
6 63
 
4.3%
4 60
 
4.1%
9 59
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1451
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 241
16.6%
2 227
15.6%
0 224
15.4%
3 195
13.4%
5 169
11.6%
1 99
6.8%
7 66
 
4.5%
6 63
 
4.3%
4 60
 
4.1%
9 59
 
4.1%
Distinct396
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size3.2 KiB
2024-03-18T14:09:18.968154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length58
Median length46
Mean length33.924242
Min length21

Characters and Unicode

Total characters13434
Distinct characters265
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

Unique396 ?
Unique (%)100.0%

Sample

1st row인천광역시 부평구 항동로 133, 1층 일부호 (일신동)
2nd row인천광역시 부평구 남부역로20번길 27, 1층 (부평동)
3rd row인천광역시 부평구 부평대로 138, 부평 신일유스테이션 오피스텔 104호 (부평동)
4th row인천광역시 부평구 경원대로 1192, 0A01동 101,102호 (십정동, 힐스테이트 부평)
5th row인천광역시 부평구 장제로84번길 14, 1층 101호 (부평동, 건영아파트)
ValueCountFrequency (%)
인천광역시 396
 
15.1%
부평구 396
 
15.1%
1층 182
 
6.9%
부평동 164
 
6.3%
십정동 47
 
1.8%
101호 44
 
1.7%
부개동 42
 
1.6%
산곡동 40
 
1.5%
청천동 36
 
1.4%
삼산동 30
 
1.1%
Other values (688) 1244
47.5%
2024-03-18T14:09:19.369303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2227
 
16.6%
1 793
 
5.9%
787
 
5.9%
645
 
4.8%
482
 
3.6%
460
 
3.4%
, 442
 
3.3%
418
 
3.1%
409
 
3.0%
407
 
3.0%
Other values (255) 6364
47.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7654
57.0%
Decimal Number 2230
 
16.6%
Space Separator 2227
 
16.6%
Other Punctuation 451
 
3.4%
Open Punctuation 396
 
2.9%
Close Punctuation 396
 
2.9%
Uppercase Letter 43
 
0.3%
Dash Punctuation 34
 
0.3%
Math Symbol 2
 
< 0.1%
Letter Number 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
787
 
10.3%
645
 
8.4%
482
 
6.3%
460
 
6.0%
418
 
5.5%
409
 
5.3%
407
 
5.3%
403
 
5.3%
403
 
5.3%
398
 
5.2%
Other values (218) 2842
37.1%
Uppercase Letter
ValueCountFrequency (%)
A 11
25.6%
B 7
16.3%
I 4
 
9.3%
C 3
 
7.0%
H 2
 
4.7%
E 2
 
4.7%
S 2
 
4.7%
T 2
 
4.7%
Z 1
 
2.3%
Y 1
 
2.3%
Other values (8) 8
18.6%
Decimal Number
ValueCountFrequency (%)
1 793
35.6%
0 284
 
12.7%
2 230
 
10.3%
3 194
 
8.7%
4 161
 
7.2%
6 145
 
6.5%
5 135
 
6.1%
7 110
 
4.9%
8 90
 
4.0%
9 88
 
3.9%
Other Punctuation
ValueCountFrequency (%)
, 442
98.0%
. 7
 
1.6%
@ 2
 
0.4%
Space Separator
ValueCountFrequency (%)
2227
100.0%
Open Punctuation
ValueCountFrequency (%)
( 396
100.0%
Close Punctuation
ValueCountFrequency (%)
) 396
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 34
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%
Letter Number
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7654
57.0%
Common 5736
42.7%
Latin 44
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
787
 
10.3%
645
 
8.4%
482
 
6.3%
460
 
6.0%
418
 
5.5%
409
 
5.3%
407
 
5.3%
403
 
5.3%
403
 
5.3%
398
 
5.2%
Other values (218) 2842
37.1%
Latin
ValueCountFrequency (%)
A 11
25.0%
B 7
15.9%
I 4
 
9.1%
C 3
 
6.8%
H 2
 
4.5%
E 2
 
4.5%
S 2
 
4.5%
T 2
 
4.5%
Z 1
 
2.3%
Y 1
 
2.3%
Other values (9) 9
20.5%
Common
ValueCountFrequency (%)
2227
38.8%
1 793
 
13.8%
, 442
 
7.7%
( 396
 
6.9%
) 396
 
6.9%
0 284
 
5.0%
2 230
 
4.0%
3 194
 
3.4%
4 161
 
2.8%
6 145
 
2.5%
Other values (8) 468
 
8.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7654
57.0%
ASCII 5779
43.0%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2227
38.5%
1 793
 
13.7%
, 442
 
7.6%
( 396
 
6.9%
) 396
 
6.9%
0 284
 
4.9%
2 230
 
4.0%
3 194
 
3.4%
4 161
 
2.8%
6 145
 
2.5%
Other values (26) 511
 
8.8%
Hangul
ValueCountFrequency (%)
787
 
10.3%
645
 
8.4%
482
 
6.3%
460
 
6.0%
418
 
5.5%
409
 
5.3%
407
 
5.3%
403
 
5.3%
403
 
5.3%
398
 
5.2%
Other values (218) 2842
37.1%
Number Forms
ValueCountFrequency (%)
1
100.0%

Interactions

2024-03-18T14:09:16.702336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2024-03-18T14:09:16.899133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-18T14:09:17.011141image/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지에스25 부평항동로점<NA>인천광역시 부평구 항동로 133, 1층 일부호 (일신동)
12(주)코리아세븐 부평남부점<NA>인천광역시 부평구 남부역로20번길 27, 1층 (부평동)
23세븐일레븐 부평신일점<NA>인천광역시 부평구 부평대로 138, 부평 신일유스테이션 오피스텔 104호 (부평동)
34씨유 부평힐스테이트점<NA>인천광역시 부평구 경원대로 1192, 0A01동 101,102호 (십정동, 힐스테이트 부평)
45지에스25 부평힘찬점<NA>인천광역시 부평구 장제로84번길 14, 1층 101호 (부평동, 건영아파트)
56씨유 산곡유경점<NA>인천광역시 부평구 마곡로 14, 상가동 B09호 (산곡동)
67롯데씨브이에스711(주) 부평북부점<NA>인천광역시 부평구 경원대로 1417, 1층 (부평동)
78(주)코리아세븐 부평역남부점<NA>인천광역시 부평구 동수북로 172, 1층 (부평동)
89지에스25 부평플러스점<NA>인천광역시 부평구 부평문화로 141, 도경빌딩 1층 일부호 (부평동)
910(주)코리아세븐 인천금호이수점<NA>인천광역시 부평구 원적로 344, 상가동 101호 (산곡동, 금호 이수 마운트밸리)
순번판매점포명전화번호소재지(도로명)
386387세븐일레븐032-527-8981인천광역시 부평구 장제로228번길 20, 1층 (부개동)
387388지에스25 산곡믿음점032-501-3846인천광역시 부평구 마장로264번길 33, 101호 (산곡동, 뉴서울1차@)
388389세븐일레븐 부평백운점032-511-0406인천광역시 부평구 경원대로 1236 (산곡동)
389390지에스25 부평공원점032-525-4076인천광역시 부평구 안남로 62 (부평동)
390391세븐일레븐032-433-4555인천광역시 부평구 배곶로 67 (십정동)
391392GS25 부평중앙점032-522-1925인천광역시 부평구 시장로20번길 15 (부평동)
392393GS25 부평제일점032-522-2204인천광역시 부평구 부평대로12번길 15 (부평동)
393394CU 인천부개동032-511-7668인천광역시 부평구 동수로128번길 17-4 (부개동)
394395GS25 산곡현대점032-502-5096인천광역시 부평구 화랑남로 7 (산곡동)
395396GS25 부개역점032-526-5973인천광역시 부평구 수변로 17-1 (부개동)