Overview

Dataset statistics

Number of variables4
Number of observations87
Missing cells22
Missing cells (%)6.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.8 KiB
Average record size in memory33.5 B

Variable types

Text3
Categorical1

Dataset

Description제주특별자치도 제주시 소재 동물병원 (동물진료업을 하는 장소) 현황 데이터입니다.
Author제주특별자치도 제주시
URLhttps://www.data.go.kr/data/15056250/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 22 (25.3%) missing valuesMissing
업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 18:12:36.943342
Analysis finished2023-12-12 18:12:37.455993
Duration0.51 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업소명
Text

UNIQUE 

Distinct87
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size828.0 B
2023-12-13T03:12:37.631230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length20
Mean length8.0804598
Min length5

Characters and Unicode

Total characters703
Distinct characters166
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

Unique87 ?
Unique (%)100.0%

Sample

1st row24시동물병원
2nd row24시똑똑똑 동물메디컬센터
3rd rowKRA 렛츠런파크제주 동물병원
4th row강남동물병원
5th row교래 말 전문병원
ValueCountFrequency (%)
동물병원 20
 
16.1%
제주대학교 3
 
2.4%
제주 2
 
1.6%
삼화 2
 
1.6%
24시동물병원 1
 
0.8%
태흥동물병원 1
 
0.8%
중앙동물병원 1
 
0.8%
준마동물병원 1
 
0.8%
제주피그클리닉 1
 
0.8%
동물보호센터 1
 
0.8%
Other values (91) 91
73.4%
2023-12-13T03:12:38.063038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 86
 
12.2%
물 84
 
11.9%
원 82
 
11.7%
병 80
 
11.4%
37
 
5.3%
제 16
 
2.3%
주 15
 
2.1%
한 11
 
1.6%
이 10
 
1.4%
라 7
 
1.0%
Other values (156) 275
39.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 653
92.9%
Space Separator 37
 
5.3%
Decimal Number 4
 
0.6%
Uppercase Letter 3
 
0.4%
Open Punctuation 2
 
0.3%
Close Punctuation 2
 
0.3%
Modifier Symbol 1
 
0.1%
Lowercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 86
 
13.2%
물 84
 
12.9%
원 82
 
12.6%
병 80
 
12.3%
제 16
 
2.5%
주 15
 
2.3%
한 11
 
1.7%
이 10
 
1.5%
라 7
 
1.1%
터 6
 
0.9%
Other values (146) 256
39.2%
Uppercase Letter
ValueCountFrequency (%)
K 1
33.3%
R 1
33.3%
A 1
33.3%
Decimal Number
ValueCountFrequency (%)
4 2
50.0%
2 2
50.0%
Space Separator
ValueCountFrequency (%)
37
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%
Lowercase Letter
ValueCountFrequency (%)
s 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 653
92.9%
Common 46
 
6.5%
Latin 4
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 86
 
13.2%
물 84
 
12.9%
원 82
 
12.6%
병 80
 
12.3%
제 16
 
2.5%
주 15
 
2.3%
한 11
 
1.7%
이 10
 
1.5%
라 7
 
1.1%
터 6
 
0.9%
Other values (146) 256
39.2%
Common
ValueCountFrequency (%)
37
80.4%
4 2
 
4.3%
( 2
 
4.3%
) 2
 
4.3%
2 2
 
4.3%
` 1
 
2.2%
Latin
ValueCountFrequency (%)
s 1
25.0%
K 1
25.0%
R 1
25.0%
A 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 653
92.9%
ASCII 50
 
7.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 86
 
13.2%
물 84
 
12.9%
원 82
 
12.6%
병 80
 
12.3%
제 16
 
2.5%
주 15
 
2.3%
한 11
 
1.7%
이 10
 
1.5%
라 7
 
1.1%
터 6
 
0.9%
Other values (146) 256
39.2%
ASCII
ValueCountFrequency (%)
37
74.0%
4 2
 
4.0%
( 2
 
4.0%
) 2
 
4.0%
2 2
 
4.0%
` 1
 
2.0%
s 1
 
2.0%
K 1
 
2.0%
R 1
 
2.0%
A 1
 
2.0%

소재지
Text

Distinct86
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Memory size828.0 B
2023-12-13T03:12:38.514465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length26
Mean length21.781609
Min length18

Characters and Unicode

Total characters1895
Distinct characters94
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 (%)97.7%

Sample

1st row제주특별자치도 제주시 연삼로 353
2nd row제주특별자치도 제주시 도령로 129
3rd row제주특별자치도 제주시 애월읍 평화로 2144
4th row제주특별자치도 제주시 중앙로 106
5th row제주특별자치도 제주시 구좌읍 세화경마루길 14-14
ValueCountFrequency (%)
제주특별자치도 87
23.0%
제주시 87
23.0%
한림읍 15
 
4.0%
중앙로 6
 
1.6%
조천읍 6
 
1.6%
애월읍 6
 
1.6%
연삼로 4
 
1.1%
금악로 3
 
0.8%
구좌읍 3
 
0.8%
비자림로 3
 
0.8%
Other values (144) 159
42.0%
2023-12-13T03:12:39.163964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
330
17.4%
주 181
 
9.6%
제 176
 
9.3%
자 90
 
4.7%
도 89
 
4.7%
특 87
 
4.6%
별 87
 
4.6%
치 87
 
4.6%
시 87
 
4.6%
1 70
 
3.7%
Other values (84) 611
32.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1271
67.1%
Space Separator 330
 
17.4%
Decimal Number 275
 
14.5%
Dash Punctuation 19
 
1.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 181
14.2%
제 176
13.8%
자 90
 
7.1%
도 89
 
7.0%
특 87
 
6.8%
별 87
 
6.8%
치 87
 
6.8%
시 87
 
6.8%
로 68
 
5.4%
읍 30
 
2.4%
Other values (72) 289
22.7%
Decimal Number
ValueCountFrequency (%)
1 70
25.5%
2 34
12.4%
3 28
 
10.2%
5 28
 
10.2%
4 22
 
8.0%
0 21
 
7.6%
7 20
 
7.3%
8 19
 
6.9%
9 17
 
6.2%
6 16
 
5.8%
Space Separator
ValueCountFrequency (%)
330
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 19
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1271
67.1%
Common 624
32.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 181
14.2%
제 176
13.8%
자 90
 
7.1%
도 89
 
7.0%
특 87
 
6.8%
별 87
 
6.8%
치 87
 
6.8%
시 87
 
6.8%
로 68
 
5.4%
읍 30
 
2.4%
Other values (72) 289
22.7%
Common
ValueCountFrequency (%)
330
52.9%
1 70
 
11.2%
2 34
 
5.4%
3 28
 
4.5%
5 28
 
4.5%
4 22
 
3.5%
0 21
 
3.4%
7 20
 
3.2%
- 19
 
3.0%
8 19
 
3.0%
Other values (2) 33
 
5.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1271
67.1%
ASCII 624
32.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
330
52.9%
1 70
 
11.2%
2 34
 
5.4%
3 28
 
4.5%
5 28
 
4.5%
4 22
 
3.5%
0 21
 
3.4%
7 20
 
3.2%
- 19
 
3.0%
8 19
 
3.0%
Other values (2) 33
 
5.3%
Hangul
ValueCountFrequency (%)
주 181
14.2%
제 176
13.8%
자 90
 
7.1%
도 89
 
7.0%
특 87
 
6.8%
별 87
 
6.8%
치 87
 
6.8%
시 87
 
6.8%
로 68
 
5.4%
읍 30
 
2.4%
Other values (72) 289
22.7%

전화번호
Text

MISSING 

Distinct64
Distinct (%)98.5%
Missing22
Missing (%)25.3%
Memory size828.0 B
2023-12-13T03:12:39.467704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.015385
Min length12

Characters and Unicode

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

Unique63 ?
Unique (%)96.9%

Sample

1st row064-702-2475
2nd row064-749-7585
3rd row064-786-8341
4th row064-723-2005
5th row064-754-5700
ValueCountFrequency (%)
064-796-4451 2
 
3.1%
064-725-5106 1
 
1.5%
064-799-3022 1
 
1.5%
064-702-2475 1
 
1.5%
064-752-9582 1
 
1.5%
064-796-1136 1
 
1.5%
064-710-4065 1
 
1.5%
064-756-4204 1
 
1.5%
064-796-8661 1
 
1.5%
064-747-5006 1
 
1.5%
Other values (54) 54
83.1%
2023-12-13T03:12:39.924149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 130
16.6%
7 117
15.0%
4 109
14.0%
0 108
13.8%
6 89
11.4%
5 63
8.1%
2 46
 
5.9%
1 33
 
4.2%
8 33
 
4.2%
9 30
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 651
83.4%
Dash Punctuation 130
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
7 117
18.0%
4 109
16.7%
0 108
16.6%
6 89
13.7%
5 63
9.7%
2 46
 
7.1%
1 33
 
5.1%
8 33
 
5.1%
9 30
 
4.6%
3 23
 
3.5%
Dash Punctuation
ValueCountFrequency (%)
- 130
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 781
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 130
16.6%
7 117
15.0%
4 109
14.0%
0 108
13.8%
6 89
11.4%
5 63
8.1%
2 46
 
5.9%
1 33
 
4.2%
8 33
 
4.2%
9 30
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 781
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 130
16.6%
7 117
15.0%
4 109
14.0%
0 108
13.8%
6 89
11.4%
5 63
8.1%
2 46
 
5.9%
1 33
 
4.2%
8 33
 
4.2%
9 30
 
3.8%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size828.0 B
2021-03-08
87 

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 87
100.0%

Length

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

Common Values (Plot)

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

Correlations

2023-12-13T03:12:40.324232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명소재지전화번호
업소명1.0001.0001.000
소재지1.0001.0001.000
전화번호1.0001.0001.000

Missing values

2023-12-13T03:12:37.316561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:12:37.412537image/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

업소명소재지전화번호데이터기준일자
024시동물병원제주특별자치도 제주시 연삼로 353064-702-24752021-03-08
124시똑똑똑 동물메디컬센터제주특별자치도 제주시 도령로 129064-749-75852021-03-08
2KRA 렛츠런파크제주 동물병원제주특별자치도 제주시 애월읍 평화로 2144064-786-83412021-03-08
3강남동물병원제주특별자치도 제주시 중앙로 106064-723-20052021-03-08
4교래 말 전문병원제주특별자치도 제주시 구좌읍 세화경마루길 14-14<NA>2021-03-08
5국립축산과학원 난지축산연구소 동물병원제주특별자치도 제주시 산록북로 593-40064-754-57002021-03-08
6굿데이 동물병원제주특별자치도 제주시 한림읍 금악동길 220-9<NA>2021-03-08
7금악동물병원제주특별자치도 제주시 한림읍 금악로 39064-796-82752021-03-08
8꿈동물병원제주특별자치도 제주시 월광로 32064-744-11282021-03-08
9나아라 동물병원제주특별자치도 제주시 중앙로 536064-799-75822021-03-08
업소명소재지전화번호데이터기준일자
77한빛동물병원제주특별자치도 제주시 한경면 용금로 740064-748-75722021-03-08
78한사랑 동물병원제주특별자치도 제주시 인다10길 31064-747-30002021-03-08
79한서동물병원제주특별자치도 제주시 아봉로 759064-784-06572021-03-08
80한수풀동물병원제주특별자치도 제주시 한림읍 한림로 655064-796-44512021-03-08
81해맑은동물병원제주특별자치도 제주시 한라대학로 75064-742-18682021-03-08
82해밀동물병원제주특별자치도 제주시 연신로 85064-744-75822021-03-08
83해올동물병원제주특별자치도 제주시 조천읍 비자림로 685-8<NA>2021-03-08
84행복한동물병원제주특별자치도 제주시 연삼로 128064-742-74252021-03-08
85현동물병원제주특별자치도 제주시 한림읍 금악로1길 2<NA>2021-03-08
86호크마 동물병원제주특별자치도 제주시 동제원길 80<NA>2021-03-08