Overview

Dataset statistics

Number of variables6
Number of observations234
Missing cells7
Missing cells (%)0.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.1 KiB
Average record size in memory48.6 B

Variable types

Categorical3
Text3

Dataset

Description제주특별자치도 제주시 동물관련업 (판매, 미용, 위탁관리, 운송 등) 현황 데이터입니다.
Author제주특별자치도 제주시
URLhttps://www.data.go.kr/data/15056248/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
도로명주소 has 4 (1.7%) missing valuesMissing
지번주소 has 3 (1.3%) missing valuesMissing

Reproduction

Analysis started2023-12-12 18:00:47.562033
Analysis finished2023-12-12 18:00:48.083483
Duration0.52 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

영업의내용
Categorical

Distinct6
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
동물 (미용)
100 
동물 (위탁관리)
62 
동물 (판매)
41 
동물 (전시)
18 
동물 (운송)
12 

Length

Max length10
Median length7
Mean length7.542735
Min length7

Unique

Unique1 ?
Unique (%)0.4%

Sample

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

Common Values

ValueCountFrequency (%)
동물 (미용) 100
42.7%
동물 (위탁관리) 62
26.5%
동물 (판매) 41
17.5%
동물 (전시) 18
 
7.7%
동물 (운송) 12
 
5.1%
동물 (수입 판매) 1
 
0.4%

Length

2023-12-13T03:00:48.155025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:00:48.261064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동물 234
49.9%
미용 100
21.3%
위탁관리 62
 
13.2%
판매 42
 
9.0%
전시 18
 
3.8%
운송 12
 
2.6%
수입 1
 
0.2%
Distinct156
Distinct (%)66.7%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2023-12-13T03:00:48.575608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length15
Mean length6.1837607
Min length2

Characters and Unicode

Total characters1447
Distinct characters250
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

Unique98 ?
Unique (%)41.9%

Sample

1st row홍독
2nd row애견사랑
3rd row국제애견센타
4th row도그랑 캐츠랑
5th row퍼피아이애견
ValueCountFrequency (%)
동물병원 15
 
4.5%
퍼스트독 5
 
1.5%
애견카페 5
 
1.5%
애견 5
 
1.5%
애견샵 4
 
1.2%
똘이장군 4
 
1.2%
개좋아 4
 
1.2%
제주 4
 
1.2%
제주점 4
 
1.2%
곱닥한개 4
 
1.2%
Other values (185) 278
83.7%
2023-12-13T03:00:49.135544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
98
 
6.8%
56
 
3.9%
47
 
3.2%
46
 
3.2%
45
 
3.1%
43
 
3.0%
43
 
3.0%
37
 
2.6%
36
 
2.5%
32
 
2.2%
Other values (240) 964
66.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1293
89.4%
Space Separator 98
 
6.8%
Uppercase Letter 32
 
2.2%
Lowercase Letter 9
 
0.6%
Decimal Number 6
 
0.4%
Other Punctuation 5
 
0.3%
Close Punctuation 2
 
0.1%
Open Punctuation 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
56
 
4.3%
47
 
3.6%
46
 
3.6%
45
 
3.5%
43
 
3.3%
43
 
3.3%
37
 
2.9%
36
 
2.8%
32
 
2.5%
23
 
1.8%
Other values (212) 885
68.4%
Uppercase Letter
ValueCountFrequency (%)
I 9
28.1%
N 4
12.5%
A 3
 
9.4%
B 2
 
6.2%
R 2
 
6.2%
G 2
 
6.2%
Y 2
 
6.2%
M 2
 
6.2%
S 1
 
3.1%
P 1
 
3.1%
Other values (4) 4
12.5%
Lowercase Letter
ValueCountFrequency (%)
e 3
33.3%
u 1
 
11.1%
p 1
 
11.1%
o 1
 
11.1%
h 1
 
11.1%
t 1
 
11.1%
n 1
 
11.1%
Decimal Number
ValueCountFrequency (%)
4 3
50.0%
2 3
50.0%
Other Punctuation
ValueCountFrequency (%)
& 3
60.0%
: 2
40.0%
Space Separator
ValueCountFrequency (%)
98
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1293
89.4%
Common 113
 
7.8%
Latin 41
 
2.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
56
 
4.3%
47
 
3.6%
46
 
3.6%
45
 
3.5%
43
 
3.3%
43
 
3.3%
37
 
2.9%
36
 
2.8%
32
 
2.5%
23
 
1.8%
Other values (212) 885
68.4%
Latin
ValueCountFrequency (%)
I 9
22.0%
N 4
 
9.8%
e 3
 
7.3%
A 3
 
7.3%
B 2
 
4.9%
R 2
 
4.9%
G 2
 
4.9%
Y 2
 
4.9%
M 2
 
4.9%
u 1
 
2.4%
Other values (11) 11
26.8%
Common
ValueCountFrequency (%)
98
86.7%
4 3
 
2.7%
2 3
 
2.7%
& 3
 
2.7%
) 2
 
1.8%
: 2
 
1.8%
( 2
 
1.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1293
89.4%
ASCII 154
 
10.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
98
63.6%
I 9
 
5.8%
N 4
 
2.6%
e 3
 
1.9%
4 3
 
1.9%
2 3
 
1.9%
A 3
 
1.9%
& 3
 
1.9%
B 2
 
1.3%
R 2
 
1.3%
Other values (18) 24
 
15.6%
Hangul
ValueCountFrequency (%)
56
 
4.3%
47
 
3.6%
46
 
3.6%
45
 
3.5%
43
 
3.3%
43
 
3.3%
37
 
2.9%
36
 
2.8%
32
 
2.5%
23
 
1.8%
Other values (212) 885
68.4%

도로명주소
Text

MISSING 

Distinct144
Distinct (%)62.6%
Missing4
Missing (%)1.7%
Memory size2.0 KiB
2023-12-13T03:00:49.535764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length26
Mean length20.604348
Min length18

Characters and Unicode

Total characters4739
Distinct characters104
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique85 ?
Unique (%)37.0%

Sample

1st row제주특별자치도 제주시 중앙로 120
2nd row제주특별자치도 제주시 노연로 117
3rd row제주특별자치도 제주시 중앙로 189
4th row제주특별자치도 제주시 삼무로 80
5th row제주특별자치도 제주시 연동4길 22
ValueCountFrequency (%)
제주특별자치도 230
24.4%
제주시 230
24.4%
중앙로 21
 
2.2%
1100로 14
 
1.5%
12 12
 
1.3%
애월읍 11
 
1.2%
삼무로 9
 
1.0%
노연로 8
 
0.8%
서광로 7
 
0.7%
우정로15길 7
 
0.7%
Other values (195) 393
41.7%
2023-12-13T03:00:50.087027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
826
17.4%
465
 
9.8%
460
 
9.7%
237
 
5.0%
230
 
4.9%
230
 
4.9%
230
 
4.9%
230
 
4.9%
230
 
4.9%
1 207
 
4.4%
Other values (94) 1394
29.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3117
65.8%
Space Separator 826
 
17.4%
Decimal Number 757
 
16.0%
Dash Punctuation 39
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
465
14.9%
460
14.8%
237
7.6%
230
7.4%
230
7.4%
230
7.4%
230
7.4%
230
7.4%
188
 
6.0%
82
 
2.6%
Other values (82) 535
17.2%
Decimal Number
ValueCountFrequency (%)
1 207
27.3%
2 102
13.5%
3 88
11.6%
0 74
 
9.8%
5 70
 
9.2%
4 57
 
7.5%
8 55
 
7.3%
6 39
 
5.2%
9 37
 
4.9%
7 28
 
3.7%
Space Separator
ValueCountFrequency (%)
826
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 39
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3117
65.8%
Common 1622
34.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
465
14.9%
460
14.8%
237
7.6%
230
7.4%
230
7.4%
230
7.4%
230
7.4%
230
7.4%
188
 
6.0%
82
 
2.6%
Other values (82) 535
17.2%
Common
ValueCountFrequency (%)
826
50.9%
1 207
 
12.8%
2 102
 
6.3%
3 88
 
5.4%
0 74
 
4.6%
5 70
 
4.3%
4 57
 
3.5%
8 55
 
3.4%
- 39
 
2.4%
6 39
 
2.4%
Other values (2) 65
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3117
65.8%
ASCII 1622
34.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
826
50.9%
1 207
 
12.8%
2 102
 
6.3%
3 88
 
5.4%
0 74
 
4.6%
5 70
 
4.3%
4 57
 
3.5%
8 55
 
3.4%
- 39
 
2.4%
6 39
 
2.4%
Other values (2) 65
 
4.0%
Hangul
ValueCountFrequency (%)
465
14.9%
460
14.8%
237
7.6%
230
7.4%
230
7.4%
230
7.4%
230
7.4%
230
7.4%
188
 
6.0%
82
 
2.6%
Other values (82) 535
17.2%

지번주소
Text

MISSING 

Distinct139
Distinct (%)60.2%
Missing3
Missing (%)1.3%
Memory size2.0 KiB
2023-12-13T03:00:50.484860image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length27
Mean length23.242424
Min length19

Characters and Unicode

Total characters5369
Distinct characters76
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique78 ?
Unique (%)33.8%

Sample

1st row제주특별자치도 제주시 삼도이동 222-3
2nd row제주특별자치도 제주시 연동 283-24
3rd row제주특별자치도 제주시 이도일동 1260-4
4th row제주특별자치도 제주시 연동 292-31
5th row제주특별자치도 제주시 연동 255-4
ValueCountFrequency (%)
제주특별자치도 231
24.4%
제주시 231
24.4%
노형동 48
 
5.1%
연동 37
 
3.9%
이도일동 17
 
1.8%
이도이동 16
 
1.7%
삼도이동 12
 
1.3%
애월읍 11
 
1.2%
외도일동 9
 
1.0%
아라일동 9
 
1.0%
Other values (171) 325
34.4%
2023-12-13T03:00:51.028862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
941
17.5%
462
 
8.6%
462
 
8.6%
314
 
5.8%
231
 
4.3%
231
 
4.3%
231
 
4.3%
231
 
4.3%
231
 
4.3%
1 221
 
4.1%
Other values (66) 1814
33.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3150
58.7%
Decimal Number 1076
 
20.0%
Space Separator 941
 
17.5%
Dash Punctuation 202
 
3.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
462
14.7%
462
14.7%
314
10.0%
231
7.3%
231
7.3%
231
7.3%
231
7.3%
231
7.3%
210
6.7%
84
 
2.7%
Other values (54) 463
14.7%
Decimal Number
ValueCountFrequency (%)
1 221
20.5%
2 201
18.7%
9 100
9.3%
3 96
8.9%
5 92
8.6%
4 87
 
8.1%
8 72
 
6.7%
7 70
 
6.5%
0 69
 
6.4%
6 68
 
6.3%
Space Separator
ValueCountFrequency (%)
941
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 202
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3150
58.7%
Common 2219
41.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
462
14.7%
462
14.7%
314
10.0%
231
7.3%
231
7.3%
231
7.3%
231
7.3%
231
7.3%
210
6.7%
84
 
2.7%
Other values (54) 463
14.7%
Common
ValueCountFrequency (%)
941
42.4%
1 221
 
10.0%
- 202
 
9.1%
2 201
 
9.1%
9 100
 
4.5%
3 96
 
4.3%
5 92
 
4.1%
4 87
 
3.9%
8 72
 
3.2%
7 70
 
3.2%
Other values (2) 137
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3150
58.7%
ASCII 2219
41.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
941
42.4%
1 221
 
10.0%
- 202
 
9.1%
2 201
 
9.1%
9 100
 
4.5%
3 96
 
4.3%
5 92
 
4.1%
4 87
 
3.9%
8 72
 
3.2%
7 70
 
3.2%
Other values (2) 137
 
6.2%
Hangul
ValueCountFrequency (%)
462
14.7%
462
14.7%
314
10.0%
231
7.3%
231
7.3%
231
7.3%
231
7.3%
231
7.3%
210
6.7%
84
 
2.7%
Other values (54) 463
14.7%
Distinct3
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
정상
172 
폐업
58 
휴업
 
4

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row폐업
2nd row정상
3rd row폐업
4th row폐업
5th row정상

Common Values

ValueCountFrequency (%)
정상 172
73.5%
폐업 58
 
24.8%
휴업 4
 
1.7%

Length

2023-12-13T03:00:51.185688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:00:51.294769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상 172
73.5%
폐업 58
 
24.8%
휴업 4
 
1.7%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2021-03-08
234 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-03-08
2nd row2021-03-08
3rd row2021-03-08
4th row2021-03-08
5th row2021-03-08

Common Values

ValueCountFrequency (%)
2021-03-08 234
100.0%

Length

2023-12-13T03:00:51.410189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:00:51.502248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-03-08 234
100.0%

Correlations

2023-12-13T03:00:51.567974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
영업의내용영업상태구분
영업의내용1.0000.477
영업상태구분0.4771.000
2023-12-13T03:00:51.656898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
영업상태구분영업의내용
영업상태구분1.0000.223
영업의내용0.2231.000
2023-12-13T03:00:51.756504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
영업의내용영업상태구분
영업의내용1.0000.223
영업상태구분0.2231.000

Missing values

2023-12-13T03:00:47.866639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:00:47.955470image/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.
2023-12-13T03:00:48.041889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

영업의내용사업장명칭도로명주소지번주소영업상태구분데이터기준일자
0동물 (판매)홍독제주특별자치도 제주시 중앙로 120제주특별자치도 제주시 삼도이동 222-3폐업2021-03-08
1동물 (판매)애견사랑제주특별자치도 제주시 노연로 117제주특별자치도 제주시 연동 283-24정상2021-03-08
2동물 (판매)국제애견센타제주특별자치도 제주시 중앙로 189제주특별자치도 제주시 이도일동 1260-4폐업2021-03-08
3동물 (판매)도그랑 캐츠랑제주특별자치도 제주시 삼무로 80제주특별자치도 제주시 연동 292-31폐업2021-03-08
4동물 (판매)퍼피아이애견제주특별자치도 제주시 연동4길 22제주특별자치도 제주시 연동 255-4정상2021-03-08
5동물 (판매)애견프린스제주특별자치도 제주시 연신로 36<NA>폐업2021-03-08
6동물 (판매)개밥이 여기 있었네제주특별자치도 제주시 아봉로 9제주특별자치도 제주시 아라이동 1573-2폐업2021-03-08
7동물 (판매)굿독 애견미용클럽제주특별자치도 제주시 중앙로 99제주특별자치도 제주시 이도일동 1516-1폐업2021-03-08
8동물 (판매)도그파파제주특별자치도 제주시 정존3길 8제주특별자치도 제주시 노형동 2523-5정상2021-03-08
9동물 (판매)견궁<NA>제주특별자치도 제주시 이도이동 314-5폐업2021-03-08
영업의내용사업장명칭도로명주소지번주소영업상태구분데이터기준일자
224동물 (위탁관리)도그헤븐제주특별자치도 제주시 삼무로 74제주특별자치도 제주시 연동 292-10정상2021-03-08
225동물 (미용)도그헤븐제주특별자치도 제주시 삼무로 74제주특별자치도 제주시 연동 292-10정상2021-03-08
226동물 (판매)밤비 살롱제주특별자치도 제주시 우정로15길 21제주특별자치도 제주시 외도일동 559-4정상2021-03-08
227동물 (위탁관리)호동이네제주특별자치도 제주시 남광로 56제주특별자치도 제주시 이도이동 1970-13정상2021-03-08
228동물 (미용)브이동물메디컬센터제주특별자치도 제주시 노형14길 14제주특별자치도 제주시 노형동 3783정상2021-03-08
229동물 (미용)더펫츠제주특별자치도 제주시 1100로 3124제주특별자치도 제주시 노형동 156-8정상2021-03-08
230동물 (전시)코기절미제주특별자치도 제주시 1100로 3198-20제주특별자치도 제주시 노형동 82-2정상2021-03-08
231동물 (위탁관리)코기절미제주특별자치도 제주시 1100로 3198-20제주특별자치도 제주시 노형동 82-2정상2021-03-08
232동물 (위탁관리)브이동물메디컬센터제주특별자치도 제주시 노형14길 14제주특별자치도 제주시 노형동 3783정상2021-03-08
233동물 (미용)예쁘개제주특별자치도 제주시 월광로 51제주특별자치도 제주시 노형동 2838정상2021-03-08