Overview

Dataset statistics

Number of variables4
Number of observations343
Missing cells307
Missing cells (%)22.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory10.8 KiB
Average record size in memory32.4 B

Variable types

Categorical1
Text3

Dataset

Description부천시 동물관련엽업 현황에 대한 데이터로 영업 유형(판매, 수입 판매, 미용), 업체명, 소재지(도로명), 전화번호 등의 정보를 제공합니다.
Author경기도 부천시
URLhttps://www.data.go.kr/data/15055291/fileData.do

Alerts

전화번호 has 307 (89.5%) missing valuesMissing

Reproduction

Analysis started2023-12-12 13:05:41.889576
Analysis finished2023-12-12 13:05:42.343896
Duration0.45 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

영업 유형
Categorical

Distinct5
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
동물미용업(일반)
163 
동물판매업(일반)
104 
동물위탁관리업
66 
동물전시업
 
8
동물수입업
 
2

Length

Max length9
Median length9
Mean length8.4985423
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row동물판매업(일반)
2nd row동물판매업(일반)
3rd row동물판매업(일반)
4th row동물판매업(일반)
5th row동물판매업(일반)

Common Values

ValueCountFrequency (%)
동물미용업(일반) 163
47.5%
동물판매업(일반) 104
30.3%
동물위탁관리업 66
19.2%
동물전시업 8
 
2.3%
동물수입업 2
 
0.6%

Length

2023-12-12T22:05:42.414156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:05:42.532649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동물미용업(일반 163
47.5%
동물판매업(일반 104
30.3%
동물위탁관리업 66
19.2%
동물전시업 8
 
2.3%
동물수입업 2
 
0.6%

업체명
Text

Distinct265
Distinct (%)77.3%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
2023-12-12T22:05:42.794796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length18
Mean length6.5131195
Min length2

Characters and Unicode

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

Unique

Unique196 ?
Unique (%)57.1%

Sample

1st row도그피아
2nd row도당애견
3rd row제일애견
4th row쿨펫동물병원
5th row테오퍼피
ValueCountFrequency (%)
부천점 15
 
3.1%
강아지 11
 
2.3%
24시 6
 
1.2%
동물병원 5
 
1.0%
펫살롱 4
 
0.8%
커멍커멍 4
 
0.8%
쁘띠독 3
 
0.6%
분양 3
 
0.6%
망고&체리 3
 
0.6%
돌리샵 3
 
0.6%
Other values (316) 424
88.1%
2023-12-12T22:05:43.260774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
138
 
6.2%
동 68
 
3.0%
물 64
 
2.9%
펫 60
 
2.7%
이 57
 
2.6%
아 55
 
2.5%
원 54
 
2.4%
병 52
 
2.3%
멍 38
 
1.7%
스 37
 
1.7%
Other values (319) 1611
72.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1827
81.8%
Space Separator 138
 
6.2%
Lowercase Letter 137
 
6.1%
Uppercase Letter 59
 
2.6%
Decimal Number 21
 
0.9%
Open Punctuation 20
 
0.9%
Close Punctuation 20
 
0.9%
Other Punctuation 12
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 68
 
3.7%
물 64
 
3.5%
펫 60
 
3.3%
이 57
 
3.1%
아 55
 
3.0%
원 54
 
3.0%
병 52
 
2.8%
멍 38
 
2.1%
스 37
 
2.0%
지 36
 
2.0%
Other values (270) 1306
71.5%
Lowercase Letter
ValueCountFrequency (%)
o 22
16.1%
e 15
10.9%
g 13
9.5%
a 11
8.0%
i 11
8.0%
t 10
 
7.3%
n 9
 
6.6%
l 8
 
5.8%
p 8
 
5.8%
d 5
 
3.6%
Other values (9) 25
18.2%
Uppercase Letter
ValueCountFrequency (%)
S 10
16.9%
E 6
10.2%
M 5
 
8.5%
H 5
 
8.5%
R 5
 
8.5%
B 3
 
5.1%
Y 3
 
5.1%
K 3
 
5.1%
L 3
 
5.1%
C 2
 
3.4%
Other values (8) 14
23.7%
Decimal Number
ValueCountFrequency (%)
4 9
42.9%
2 8
38.1%
1 2
 
9.5%
0 1
 
4.8%
3 1
 
4.8%
Other Punctuation
ValueCountFrequency (%)
. 7
58.3%
& 3
25.0%
# 1
 
8.3%
' 1
 
8.3%
Space Separator
ValueCountFrequency (%)
138
100.0%
Open Punctuation
ValueCountFrequency (%)
( 20
100.0%
Close Punctuation
ValueCountFrequency (%)
) 20
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1827
81.8%
Common 211
 
9.4%
Latin 196
 
8.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 68
 
3.7%
물 64
 
3.5%
펫 60
 
3.3%
이 57
 
3.1%
아 55
 
3.0%
원 54
 
3.0%
병 52
 
2.8%
멍 38
 
2.1%
스 37
 
2.0%
지 36
 
2.0%
Other values (270) 1306
71.5%
Latin
ValueCountFrequency (%)
o 22
 
11.2%
e 15
 
7.7%
g 13
 
6.6%
a 11
 
5.6%
i 11
 
5.6%
S 10
 
5.1%
t 10
 
5.1%
n 9
 
4.6%
l 8
 
4.1%
p 8
 
4.1%
Other values (27) 79
40.3%
Common
ValueCountFrequency (%)
138
65.4%
( 20
 
9.5%
) 20
 
9.5%
4 9
 
4.3%
2 8
 
3.8%
. 7
 
3.3%
& 3
 
1.4%
1 2
 
0.9%
0 1
 
0.5%
3 1
 
0.5%
Other values (2) 2
 
0.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1827
81.8%
ASCII 407
 
18.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
138
33.9%
o 22
 
5.4%
( 20
 
4.9%
) 20
 
4.9%
e 15
 
3.7%
g 13
 
3.2%
a 11
 
2.7%
i 11
 
2.7%
S 10
 
2.5%
t 10
 
2.5%
Other values (39) 137
33.7%
Hangul
ValueCountFrequency (%)
동 68
 
3.7%
물 64
 
3.5%
펫 60
 
3.3%
이 57
 
3.1%
아 55
 
3.0%
원 54
 
3.0%
병 52
 
2.8%
멍 38
 
2.1%
스 37
 
2.0%
지 36
 
2.0%
Other values (270) 1306
71.5%

소재지(도로명)
Text

Distinct278
Distinct (%)81.0%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
2023-12-12T22:05:43.518780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length51
Median length42
Mean length29.655977
Min length15

Characters and Unicode

Total characters10172
Distinct characters234
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

Unique217 ?
Unique (%)63.3%

Sample

1st row경기도 부천시 송내동 609-10
2nd row경기도 부천시 도당동 49-20
3rd row경기도 부천시 원종동 238-1
4th row경기도 부천시 중동 1059 홈플러스중동점 1층
5th row경기도 부천시 심곡본동 730-15
ValueCountFrequency (%)
경기도 343
 
15.8%
부천시 342
 
15.8%
중동 81
 
3.7%
1층 74
 
3.4%
상동 71
 
3.3%
심곡동 29
 
1.3%
101호 27
 
1.2%
길주로 27
 
1.2%
원종동 26
 
1.2%
부일로 24
 
1.1%
Other values (520) 1127
51.9%
2023-12-12T22:05:43.900435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1872
 
18.4%
1 507
 
5.0%
부 416
 
4.1%
동 396
 
3.9%
천 377
 
3.7%
경 362
 
3.6%
도 353
 
3.5%
시 350
 
3.4%
기 344
 
3.4%
로 315
 
3.1%
Other values (224) 4880
48.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5410
53.2%
Space Separator 1872
 
18.4%
Decimal Number 1853
 
18.2%
Open Punctuation 314
 
3.1%
Close Punctuation 314
 
3.1%
Other Punctuation 300
 
2.9%
Dash Punctuation 72
 
0.7%
Uppercase Letter 32
 
0.3%
Math Symbol 4
 
< 0.1%
Letter Number 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
부 416
 
7.7%
동 396
 
7.3%
천 377
 
7.0%
경 362
 
6.7%
도 353
 
6.5%
시 350
 
6.5%
기 344
 
6.4%
로 315
 
5.8%
길 172
 
3.2%
호 151
 
2.8%
Other values (195) 2174
40.2%
Uppercase Letter
ValueCountFrequency (%)
A 7
21.9%
T 5
15.6%
B 4
12.5%
E 4
12.5%
O 3
9.4%
S 2
 
6.2%
L 2
 
6.2%
I 2
 
6.2%
P 1
 
3.1%
U 1
 
3.1%
Decimal Number
ValueCountFrequency (%)
1 507
27.4%
2 254
13.7%
0 209
11.3%
3 186
 
10.0%
4 166
 
9.0%
5 126
 
6.8%
7 118
 
6.4%
6 108
 
5.8%
9 97
 
5.2%
8 82
 
4.4%
Other Punctuation
ValueCountFrequency (%)
. 299
99.7%
& 1
 
0.3%
Space Separator
ValueCountFrequency (%)
1872
100.0%
Open Punctuation
ValueCountFrequency (%)
( 314
100.0%
Close Punctuation
ValueCountFrequency (%)
) 314
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 72
100.0%
Math Symbol
ValueCountFrequency (%)
~ 4
100.0%
Letter Number
ValueCountFrequency (%)
Ⅱ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5410
53.2%
Common 4729
46.5%
Latin 33
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
부 416
 
7.7%
동 396
 
7.3%
천 377
 
7.0%
경 362
 
6.7%
도 353
 
6.5%
시 350
 
6.5%
기 344
 
6.4%
로 315
 
5.8%
길 172
 
3.2%
호 151
 
2.8%
Other values (195) 2174
40.2%
Common
ValueCountFrequency (%)
1872
39.6%
1 507
 
10.7%
( 314
 
6.6%
) 314
 
6.6%
. 299
 
6.3%
2 254
 
5.4%
0 209
 
4.4%
3 186
 
3.9%
4 166
 
3.5%
5 126
 
2.7%
Other values (7) 482
 
10.2%
Latin
ValueCountFrequency (%)
A 7
21.2%
T 5
15.2%
B 4
12.1%
E 4
12.1%
O 3
9.1%
S 2
 
6.1%
L 2
 
6.1%
I 2
 
6.1%
P 1
 
3.0%
Ⅱ 1
 
3.0%
Other values (2) 2
 
6.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5410
53.2%
ASCII 4761
46.8%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1872
39.3%
1 507
 
10.6%
( 314
 
6.6%
) 314
 
6.6%
. 299
 
6.3%
2 254
 
5.3%
0 209
 
4.4%
3 186
 
3.9%
4 166
 
3.5%
5 126
 
2.6%
Other values (18) 514
 
10.8%
Hangul
ValueCountFrequency (%)
부 416
 
7.7%
동 396
 
7.3%
천 377
 
7.0%
경 362
 
6.7%
도 353
 
6.5%
시 350
 
6.5%
기 344
 
6.4%
로 315
 
5.8%
길 172
 
3.2%
호 151
 
2.8%
Other values (195) 2174
40.2%
Number Forms
ValueCountFrequency (%)
Ⅱ 1
100.0%

전화번호
Text

MISSING 

Distinct31
Distinct (%)86.1%
Missing307
Missing (%)89.5%
Memory size2.8 KiB
2023-12-12T22:05:44.128461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.944444
Min length11

Characters and Unicode

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

Unique26 ?
Unique (%)72.2%

Sample

1st row032-655-8729
2nd row032-684-0090
3rd row032-683-6510
4th row032-611-7909
5th row032-651-0079
ValueCountFrequency (%)
032-652-0075 2
 
5.6%
02-380-1234 2
 
5.6%
032-653-4456 2
 
5.6%
032-611-0528 2
 
5.6%
032-247-7575 2
 
5.6%
032-676-7533 1
 
2.8%
032-341-0855 1
 
2.8%
032-326-2239 1
 
2.8%
032-345-7559 1
 
2.8%
032-677-5262 1
 
2.8%
Other values (21) 21
58.3%
2023-12-12T22:05:44.457152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 72
16.7%
2 66
15.3%
0 57
13.3%
3 55
12.8%
5 41
9.5%
6 35
8.1%
7 27
 
6.3%
1 22
 
5.1%
9 21
 
4.9%
8 18
 
4.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 358
83.3%
Dash Punctuation 72
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 66
18.4%
0 57
15.9%
3 55
15.4%
5 41
11.5%
6 35
9.8%
7 27
7.5%
1 22
 
6.1%
9 21
 
5.9%
8 18
 
5.0%
4 16
 
4.5%
Dash Punctuation
ValueCountFrequency (%)
- 72
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 430
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 72
16.7%
2 66
15.3%
0 57
13.3%
3 55
12.8%
5 41
9.5%
6 35
8.1%
7 27
 
6.3%
1 22
 
5.1%
9 21
 
4.9%
8 18
 
4.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 430
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 72
16.7%
2 66
15.3%
0 57
13.3%
3 55
12.8%
5 41
9.5%
6 35
8.1%
7 27
 
6.3%
1 22
 
5.1%
9 21
 
4.9%
8 18
 
4.2%

Correlations

2023-12-12T22:05:44.543444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
영업 유형전화번호
영업 유형1.0000.000
전화번호0.0001.000

Missing values

2023-12-12T22:05:42.237928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:05:42.312281image/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동물판매업(일반)도그피아경기도 부천시 송내동 609-10032-655-8729
1동물판매업(일반)도당애견경기도 부천시 도당동 49-20032-684-0090
2동물판매업(일반)제일애견경기도 부천시 원종동 238-1032-683-6510
3동물판매업(일반)쿨펫동물병원경기도 부천시 중동 1059 홈플러스중동점 1층<NA>
4동물판매업(일반)테오퍼피경기도 부천시 심곡본동 730-15032-611-7909
5동물판매업(일반)행복한 강아지경기도 부천시 심곡본동 613-3032-651-0079
6동물판매업(일반)도그앤도그경기도 부천시 원미동 129-9032-668-8111
7동물판매업(일반)소풍쿨펫 동물병원경기도 부천시 상동 539-1 부천터미널 지하1층 26호032-329-7975
8동물판매업(일반)부천24시SKY동물병원경기도 부천시 중동 1149-2<NA>
9동물판매업(일반)이지동물올케어센터경기도 부천시 역곡동 49-5 조양시티프라자 103호<NA>
영업 유형업체명소재지(도로명)전화번호
333동물미용업(일반)스니스니경기도 부천시 양지로 205. 부천옥길 서영아너시티2 314호 (옥길동)<NA>
334동물미용업(일반)똘이 그루밍 샾경기도 부천시 길주로 115. 시그마타워 108호 (상동)<NA>
335동물미용업(일반)꼬맹이네 멍발소경기도 부천시 원종로24번길 17. 계룡팰리스 101호 (원종동)<NA>
336동물미용업(일반)케이디펫경기도 부천시 중동로248번길 33. 신풍프라자 204호 (중동)<NA>
337동물미용업(일반)네임드 살롱경기도 부천시 삼작로 258. 2층 (도당동. 미성하이츠아파트)<NA>
338동물미용업(일반)키몬리 그루밍경기도 부천시 길주로 234. 힐스테이트 101동 1097호 (중동)<NA>
339동물미용업(일반)땡스마미경기도 부천시 소사로78번길 70. 113동 1505호 (소사본동. 주공아파트)<NA>
340동물미용업(일반)슈나우펫경기도 부천시 신흥로276번길 15. 113동 1층 14호 (중동. 래미안 부천 중동)<NA>
341동물미용업(일반)씻고놀개경기도 부천시 원종로35번길 24. 3층 1호 (원종동. 한울아파트)<NA>
342동물미용업(일반)따숨경기도 부천시 범안로 133. 보람월드프라자 A동 103호 (범박동)<NA>