Overview

Dataset statistics

Number of variables5
Number of observations773
Missing cells477
Missing cells (%)12.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory30.3 KiB
Average record size in memory40.2 B

Variable types

Categorical1
Text3
DateTime1

Dataset

Description경기도 성남시 시내 안전상비의약품 판매업 현황에 대한 데이터로, 구별,판매점포명,소재지,전화번호 등의 항목을 제공하는 데이터입니다.
Author경기도 성남시
URLhttps://www.data.go.kr/data/3075928/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 477 (61.7%) missing valuesMissing

Reproduction

Analysis started2024-03-14 21:27:43.634293
Analysis finished2024-03-14 21:27:44.686064
Duration1.05 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구별
Categorical

Distinct3
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size6.2 KiB
분당구
347 
수정구
230 
중원구
196 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row수정구
2nd row수정구
3rd row수정구
4th row수정구
5th row수정구

Common Values

ValueCountFrequency (%)
분당구 347
44.9%
수정구 230
29.8%
중원구 196
25.4%

Length

2024-03-15T06:27:44.900499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:27:45.248952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
분당구 347
44.9%
수정구 230
29.8%
중원구 196
25.4%

판매점포명
Text

Distinct772
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Memory size6.2 KiB
2024-03-15T06:27:46.243242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length17
Mean length11.216041
Min length4

Characters and Unicode

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

Unique

Unique771 ?
Unique (%)99.7%

Sample

1st row(주)코리아세븐 성남모란수진점
2nd row지에스(GS)25 성남현대점
3rd row지에스25 신흥자이점
4th row씨유산성자이1단지점
5th row더디씨할인점 신흥역점
ValueCountFrequency (%)
씨유 173
 
13.0%
세븐일레븐 87
 
6.5%
gs25 75
 
5.6%
주)코리아세븐 66
 
5.0%
지에스25 46
 
3.5%
지에스(gs)25 38
 
2.9%
씨유(cu 11
 
0.8%
cu 10
 
0.8%
지에스25(gs25 7
 
0.5%
이마트24 7
 
0.5%
Other values (766) 811
60.9%
2024-03-15T06:27:47.622682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 706
 
8.1%
560
 
6.5%
2 331
 
3.8%
성 306
 
3.5%
5 305
 
3.5%
븐 286
 
3.3%
남 278
 
3.2%
씨 238
 
2.7%
유 234
 
2.7%
스 224
 
2.6%
Other values (334) 5202
60.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6550
75.5%
Decimal Number 675
 
7.8%
Space Separator 560
 
6.5%
Uppercase Letter 530
 
6.1%
Open Punctuation 176
 
2.0%
Close Punctuation 176
 
2.0%
Lowercase Letter 2
 
< 0.1%
Other Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 706
 
10.8%
성 306
 
4.7%
븐 286
 
4.4%
남 278
 
4.2%
씨 238
 
3.6%
유 234
 
3.6%
스 224
 
3.4%
지 212
 
3.2%
세 182
 
2.8%
당 169
 
2.6%
Other values (303) 3715
56.7%
Uppercase Letter
ValueCountFrequency (%)
S 210
39.6%
G 209
39.4%
C 40
 
7.5%
U 38
 
7.2%
H 6
 
1.1%
R 5
 
0.9%
K 4
 
0.8%
I 3
 
0.6%
V 2
 
0.4%
P 2
 
0.4%
Other values (7) 11
 
2.1%
Decimal Number
ValueCountFrequency (%)
2 331
49.0%
5 305
45.2%
4 20
 
3.0%
1 8
 
1.2%
3 6
 
0.9%
6 3
 
0.4%
8 1
 
0.1%
9 1
 
0.1%
Lowercase Letter
ValueCountFrequency (%)
s 1
50.0%
g 1
50.0%
Space Separator
ValueCountFrequency (%)
560
100.0%
Open Punctuation
ValueCountFrequency (%)
( 176
100.0%
Close Punctuation
ValueCountFrequency (%)
) 176
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6551
75.6%
Common 1587
 
18.3%
Latin 532
 
6.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 706
 
10.8%
성 306
 
4.7%
븐 286
 
4.4%
남 278
 
4.2%
씨 238
 
3.6%
유 234
 
3.6%
스 224
 
3.4%
지 212
 
3.2%
세 182
 
2.8%
당 169
 
2.6%
Other values (304) 3716
56.7%
Latin
ValueCountFrequency (%)
S 210
39.5%
G 209
39.3%
C 40
 
7.5%
U 38
 
7.1%
H 6
 
1.1%
R 5
 
0.9%
K 4
 
0.8%
I 3
 
0.6%
V 2
 
0.4%
P 2
 
0.4%
Other values (9) 13
 
2.4%
Common
ValueCountFrequency (%)
560
35.3%
2 331
20.9%
5 305
19.2%
( 176
 
11.1%
) 176
 
11.1%
4 20
 
1.3%
1 8
 
0.5%
3 6
 
0.4%
6 3
 
0.2%
8 1
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6550
75.5%
ASCII 2119
 
24.4%
None 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 706
 
10.8%
성 306
 
4.7%
븐 286
 
4.4%
남 278
 
4.2%
씨 238
 
3.6%
유 234
 
3.6%
스 224
 
3.4%
지 212
 
3.2%
세 182
 
2.8%
당 169
 
2.6%
Other values (303) 3715
56.7%
ASCII
ValueCountFrequency (%)
560
26.4%
2 331
15.6%
5 305
14.4%
S 210
 
9.9%
G 209
 
9.9%
( 176
 
8.3%
) 176
 
8.3%
C 40
 
1.9%
U 38
 
1.8%
4 20
 
0.9%
Other values (20) 54
 
2.5%
None
ValueCountFrequency (%)
㈜ 1
100.0%

전화번호
Text

MISSING 

Distinct283
Distinct (%)95.6%
Missing477
Missing (%)61.7%
Memory size6.2 KiB
2024-03-15T06:27:48.542103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.962838
Min length9

Characters and Unicode

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

Unique277 ?
Unique (%)93.6%

Sample

1st row1577-0711
2nd row031-746-0077
3rd row031-758-2617
4th row02-1577-8007
5th row031-747-4032
ValueCountFrequency (%)
1577-0711 9
 
3.0%
031-704-6133 2
 
0.7%
02-3284-8124 2
 
0.7%
031-705-2862 2
 
0.7%
031-755-3690 2
 
0.7%
02-1577-8007 2
 
0.7%
031-783-5520 1
 
0.3%
031-712-6230 1
 
0.3%
031-8017-5098 1
 
0.3%
031-703-5880 1
 
0.3%
Other values (273) 273
92.2%
2024-03-15T06:27:50.037765image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 582
16.4%
1 515
14.5%
0 504
14.2%
7 476
13.4%
3 436
12.3%
5 216
 
6.1%
2 213
 
6.0%
8 169
 
4.8%
4 163
 
4.6%
6 151
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2959
83.6%
Dash Punctuation 582
 
16.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 515
17.4%
0 504
17.0%
7 476
16.1%
3 436
14.7%
5 216
7.3%
2 213
7.2%
8 169
 
5.7%
4 163
 
5.5%
6 151
 
5.1%
9 116
 
3.9%
Dash Punctuation
ValueCountFrequency (%)
- 582
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3541
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 582
16.4%
1 515
14.5%
0 504
14.2%
7 476
13.4%
3 436
12.3%
5 216
 
6.1%
2 213
 
6.0%
8 169
 
4.8%
4 163
 
4.6%
6 151
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3541
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 582
16.4%
1 515
14.5%
0 504
14.2%
7 476
13.4%
3 436
12.3%
5 216
 
6.1%
2 213
 
6.0%
8 169
 
4.8%
4 163
 
4.6%
6 151
 
4.3%

소재지(도로명)
Text

Distinct768
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size6.2 KiB
2024-03-15T06:27:51.471880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length66
Median length53
Mean length35.912031
Min length23

Characters and Unicode

Total characters27760
Distinct characters355
Distinct categories11 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique763 ?
Unique (%)98.7%

Sample

1st row경기도 성남시 수정구 산성대로 95, 써미트빌딩 1층 (수진동)
2nd row경기도 성남시 수정구 제일로147번길 4, 상가동 113호 (수진동, 현대아파트)
3rd row경기도 성남시 수정구 수정남로 247, 102호 (신흥동, 수정빌라)
4th row경기도 성남시 수정구 수정로 260, A상가동 1층 3호 (신흥동, 산성역자이푸르지오 1단지)
5th row경기도 성남시 수정구 시민로 153, 1층 일부호 (신흥동)
ValueCountFrequency (%)
경기도 773
 
13.4%
성남시 773
 
13.4%
분당구 347
 
6.0%
1층 281
 
4.9%
수정구 230
 
4.0%
중원구 196
 
3.4%
정자동 61
 
1.1%
신흥동 50
 
0.9%
태평동 50
 
0.9%
성남동 49
 
0.9%
Other values (1247) 2941
51.1%
2024-03-15T06:27:53.060985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4979
 
17.9%
1 1450
 
5.2%
성 974
 
3.5%
남 938
 
3.4%
동 870
 
3.1%
구 824
 
3.0%
시 813
 
2.9%
, 802
 
2.9%
도 787
 
2.8%
경 782
 
2.8%
Other values (345) 14541
52.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 15937
57.4%
Space Separator 4979
 
17.9%
Decimal Number 4263
 
15.4%
Other Punctuation 809
 
2.9%
Close Punctuation 776
 
2.8%
Open Punctuation 776
 
2.8%
Dash Punctuation 111
 
0.4%
Uppercase Letter 91
 
0.3%
Lowercase Letter 12
 
< 0.1%
Math Symbol 5
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
성 974
 
6.1%
남 938
 
5.9%
동 870
 
5.5%
구 824
 
5.2%
시 813
 
5.1%
도 787
 
4.9%
경 782
 
4.9%
기 780
 
4.9%
로 776
 
4.9%
정 444
 
2.8%
Other values (297) 7949
49.9%
Uppercase Letter
ValueCountFrequency (%)
B 24
26.4%
A 12
13.2%
S 10
11.0%
K 7
 
7.7%
H 5
 
5.5%
E 5
 
5.5%
G 4
 
4.4%
L 4
 
4.4%
D 3
 
3.3%
I 3
 
3.3%
Other values (10) 14
15.4%
Decimal Number
ValueCountFrequency (%)
1 1450
34.0%
2 519
 
12.2%
0 507
 
11.9%
3 359
 
8.4%
4 292
 
6.8%
5 259
 
6.1%
6 247
 
5.8%
7 235
 
5.5%
9 199
 
4.7%
8 196
 
4.6%
Lowercase Letter
ValueCountFrequency (%)
e 5
41.7%
n 2
 
16.7%
r 1
 
8.3%
w 1
 
8.3%
o 1
 
8.3%
t 1
 
8.3%
b 1
 
8.3%
Other Punctuation
ValueCountFrequency (%)
, 802
99.1%
. 5
 
0.6%
' 1
 
0.1%
& 1
 
0.1%
Math Symbol
ValueCountFrequency (%)
~ 4
80.0%
∥ 1
 
20.0%
Space Separator
ValueCountFrequency (%)
4979
100.0%
Close Punctuation
ValueCountFrequency (%)
) 776
100.0%
Open Punctuation
ValueCountFrequency (%)
( 776
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 111
100.0%
Letter Number
ValueCountFrequency (%)
Ⅲ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 15937
57.4%
Common 11719
42.2%
Latin 104
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
성 974
 
6.1%
남 938
 
5.9%
동 870
 
5.5%
구 824
 
5.2%
시 813
 
5.1%
도 787
 
4.9%
경 782
 
4.9%
기 780
 
4.9%
로 776
 
4.9%
정 444
 
2.8%
Other values (297) 7949
49.9%
Latin
ValueCountFrequency (%)
B 24
23.1%
A 12
11.5%
S 10
 
9.6%
K 7
 
6.7%
e 5
 
4.8%
H 5
 
4.8%
E 5
 
4.8%
G 4
 
3.8%
L 4
 
3.8%
D 3
 
2.9%
Other values (18) 25
24.0%
Common
ValueCountFrequency (%)
4979
42.5%
1 1450
 
12.4%
, 802
 
6.8%
) 776
 
6.6%
( 776
 
6.6%
2 519
 
4.4%
0 507
 
4.3%
3 359
 
3.1%
4 292
 
2.5%
5 259
 
2.2%
Other values (10) 1000
 
8.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 15937
57.4%
ASCII 11821
42.6%
Math Operators 1
 
< 0.1%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4979
42.1%
1 1450
 
12.3%
, 802
 
6.8%
) 776
 
6.6%
( 776
 
6.6%
2 519
 
4.4%
0 507
 
4.3%
3 359
 
3.0%
4 292
 
2.5%
5 259
 
2.2%
Other values (36) 1102
 
9.3%
Hangul
ValueCountFrequency (%)
성 974
 
6.1%
남 938
 
5.9%
동 870
 
5.5%
구 824
 
5.2%
시 813
 
5.1%
도 787
 
4.9%
경 782
 
4.9%
기 780
 
4.9%
로 776
 
4.9%
정 444
 
2.8%
Other values (297) 7949
49.9%
Math Operators
ValueCountFrequency (%)
∥ 1
100.0%
Number Forms
ValueCountFrequency (%)
Ⅲ 1
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.2 KiB
Minimum2024-02-28 00:00:00
Maximum2024-02-28 00:00:00
2024-03-15T06:27:53.411222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:27:53.751179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2024-03-15T06:27:44.225677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T06:27:44.556024image/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수정구(주)코리아세븐 성남모란수진점1577-0711경기도 성남시 수정구 산성대로 95, 써미트빌딩 1층 (수진동)2024-02-28
1수정구지에스(GS)25 성남현대점<NA>경기도 성남시 수정구 제일로147번길 4, 상가동 113호 (수진동, 현대아파트)2024-02-28
2수정구지에스25 신흥자이점031-746-0077경기도 성남시 수정구 수정남로 247, 102호 (신흥동, 수정빌라)2024-02-28
3수정구씨유산성자이1단지점<NA>경기도 성남시 수정구 수정로 260, A상가동 1층 3호 (신흥동, 산성역자이푸르지오 1단지)2024-02-28
4수정구더디씨할인점 신흥역점031-758-2617경기도 성남시 수정구 시민로 153, 1층 일부호 (신흥동)2024-02-28
5수정구씨유태평플로렌스점02-1577-8007경기도 성남시 수정구 남문로7번길 15, 1층 일부호 (태평동)2024-02-28
6수정구지에스(GS)25 산성헤리스톤점<NA>경기도 성남시 수정구 수정남로324번길 4-1, 지1층 (산성동, 부흥하이츠3차)2024-02-28
7수정구씨유 성남논골빌리지점<NA>경기도 성남시 수정구 논골로53번길 20-1, 102호 (단대동, 서신빌라)2024-02-28
8수정구씨유(CU) 판교이노베이션랩점<NA>경기도 성남시 수정구 금토로80번길 11, 판교이노베이션랩 지식산업센터 107호 (금토동)2024-02-28
9수정구씨유고등호반써밋점<NA>경기도 성남시 수정구 청계산로1길 11, 1층 일부호 (고등동)2024-02-28
구별판매점포명전화번호소재지(도로명)데이터기준일자
763분당구씨유 분당목련점031-707-7171경기도 성남시 분당구 야탑로 243 (야탑동)2024-02-28
764분당구세븐일레븐 판교봇들마을점031-709-1244경기도 성남시 분당구 동판교로 156 (삼평동)2024-02-28
765분당구씨유 분당구미점031-711-7178경기도 성남시 분당구 금곡로23번길 9 (구미동)2024-02-28
766분당구세븐일레븐 분당한솔마을점031-711-0859경기도 성남시 분당구 내정로 52 (정자동)2024-02-28
767분당구세븐일레븐 이매촌점031-704-6133경기도 성남시 분당구 양현로166번길 15 (이매동)2024-02-28
768분당구씨유 수내트라팰리스점031-714-2774경기도 성남시 분당구 황새울로 234, 분당트라팰리스 102호 (수내동)2024-02-28
769분당구씨유 분당서현타운점031-701-3558경기도 성남시 분당구 불정로420번길 5 (서현동)2024-02-28
770분당구GS25 분당미켈란031-712-0250경기도 성남시 분당구 정자일로 100, 122호 (정자동, 상가동 )2024-02-28
771분당구지에스(GS)25 분당율동공원점031-781-3515경기도 성남시 분당구 문정로 156 (율동)2024-02-28
772분당구길사랑장학사업단(주) 서울하이패스센터031-714-7240경기도 성남시 분당구 대왕판교로 294 (궁내동)2024-02-28