Overview

Dataset statistics

Number of variables4
Number of observations60
Missing cells15
Missing cells (%)6.2%
Duplicate rows3
Duplicate rows (%)5.0%
Total size in memory2.0 KiB
Average record size in memory34.2 B

Variable types

Text3
Categorical1

Dataset

Description이 데이터는 서울특별시 동작구의 동물을 진료하거나 동물의 질병을 예방하는 기관정보를 포함하고 있습니다. 이 데이터에는 업소명, 영업상태, 사업장소재지, 전화번호 등이 있습니다.
Author서울특별시 동작구
URLhttps://www.data.go.kr/data/15094590/fileData.do

Alerts

Dataset has 3 (5.0%) duplicate rowsDuplicates
사업장소재지 has 15 (25.0%) missing valuesMissing

Reproduction

Analysis started2024-04-21 02:04:31.667876
Analysis finished2024-04-21 02:04:33.431855
Duration1.76 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업소명
Text

Distinct52
Distinct (%)86.7%
Missing0
Missing (%)0.0%
Memory size612.0 B
2024-04-21T11:04:33.588258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length18
Mean length7.3833333
Min length5

Characters and Unicode

Total characters443
Distinct characters120
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

Unique44 ?
Unique (%)73.3%

Sample

1st row이승배수의과병원
2nd row중앙동물병원
3rd row야셀동물병원
4th row상도동물병원
5th row모범동물병원
ValueCountFrequency (%)
야셀동물병원 2
 
2.9%
원동물병원 2
 
2.9%
쿠키동물병원 2
 
2.9%
인동물병원 2
 
2.9%
굿모닝동물병원 2
 
2.9%
디아크동물종합병원 2
 
2.9%
피닉스동물병원 2
 
2.9%
종합동물병원 2
 
2.9%
유케어종합동물병원 2
 
2.9%
동물병원 2
 
2.9%
Other values (48) 48
70.6%
2024-04-21T11:04:33.940213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 60
 
13.5%
물 59
 
13.3%
원 59
 
13.3%
병 57
 
12.9%
종 8
 
1.8%
합 8
 
1.8%
8
 
1.8%
나 7
 
1.6%
다 6
 
1.4%
스 5
 
1.1%
Other values (110) 166
37.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 418
94.4%
Lowercase Letter 9
 
2.0%
Space Separator 8
 
1.8%
Decimal Number 4
 
0.9%
Uppercase Letter 3
 
0.7%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 60
14.4%
물 59
14.1%
원 59
14.1%
병 57
 
13.6%
종 8
 
1.9%
합 8
 
1.9%
나 7
 
1.7%
다 6
 
1.4%
스 5
 
1.2%
석 4
 
1.0%
Other values (97) 145
34.7%
Lowercase Letter
ValueCountFrequency (%)
e 3
33.3%
t 2
22.2%
o 1
 
11.1%
g 1
 
11.1%
h 1
 
11.1%
r 1
 
11.1%
Uppercase Letter
ValueCountFrequency (%)
S 1
33.3%
P 1
33.3%
T 1
33.3%
Decimal Number
ValueCountFrequency (%)
4 2
50.0%
2 2
50.0%
Space Separator
ValueCountFrequency (%)
8
100.0%
Other Punctuation
ValueCountFrequency (%)
' 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 418
94.4%
Common 13
 
2.9%
Latin 12
 
2.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 60
14.4%
물 59
14.1%
원 59
14.1%
병 57
 
13.6%
종 8
 
1.9%
합 8
 
1.9%
나 7
 
1.7%
다 6
 
1.4%
스 5
 
1.2%
석 4
 
1.0%
Other values (97) 145
34.7%
Latin
ValueCountFrequency (%)
e 3
25.0%
t 2
16.7%
S 1
 
8.3%
P 1
 
8.3%
T 1
 
8.3%
o 1
 
8.3%
g 1
 
8.3%
h 1
 
8.3%
r 1
 
8.3%
Common
ValueCountFrequency (%)
8
61.5%
4 2
 
15.4%
2 2
 
15.4%
' 1
 
7.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 418
94.4%
ASCII 25
 
5.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 60
14.4%
물 59
14.1%
원 59
14.1%
병 57
 
13.6%
종 8
 
1.9%
합 8
 
1.9%
나 7
 
1.7%
다 6
 
1.4%
스 5
 
1.2%
석 4
 
1.0%
Other values (97) 145
34.7%
ASCII
ValueCountFrequency (%)
8
32.0%
e 3
 
12.0%
4 2
 
8.0%
t 2
 
8.0%
2 2
 
8.0%
S 1
 
4.0%
' 1
 
4.0%
P 1
 
4.0%
T 1
 
4.0%
o 1
 
4.0%
Other values (3) 3
 
12.0%

영업상태
Categorical

Distinct2
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size612.0 B
폐업
40 
정상
20 

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 (%)
폐업 40
66.7%
정상 20
33.3%

Length

2024-04-21T11:04:34.057635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T11:04:34.153411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 40
66.7%
정상 20
33.3%

사업장소재지
Text

MISSING 

Distinct42
Distinct (%)93.3%
Missing15
Missing (%)25.0%
Memory size612.0 B
2024-04-21T11:04:34.374948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length52
Median length40
Mean length28.222222
Min length22

Characters and Unicode

Total characters1270
Distinct characters91
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

Unique39 ?
Unique (%)86.7%

Sample

1st row서울특별시 동작구 현충로 100, 1층 (흑석동)
2nd row서울특별시 동작구 사당로 308 (사당동,화인빌딩 1층)
3rd row서울특별시 동작구 사당로 229 (사당동)
4th row서울특별시 동작구 상도로 71 (대방동)
5th row서울특별시 동작구 남부순환로 2051 (사당동)
ValueCountFrequency (%)
서울특별시 45
17.2%
동작구 45
17.2%
1층 14
 
5.3%
상도로 13
 
5.0%
사당동 12
 
4.6%
상도동 10
 
3.8%
사당로 8
 
3.1%
흑석동 7
 
2.7%
대방동 6
 
2.3%
상도1동 4
 
1.5%
Other values (78) 98
37.4%
2024-04-21T11:04:34.756779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
217
 
17.1%
동 96
 
7.6%
1 58
 
4.6%
작 49
 
3.9%
서 46
 
3.6%
특 45
 
3.5%
별 45
 
3.5%
시 45
 
3.5%
구 45
 
3.5%
울 45
 
3.5%
Other values (81) 579
45.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 745
58.7%
Space Separator 217
 
17.1%
Decimal Number 186
 
14.6%
Close Punctuation 45
 
3.5%
Open Punctuation 45
 
3.5%
Other Punctuation 26
 
2.0%
Dash Punctuation 3
 
0.2%
Uppercase Letter 3
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 96
 
12.9%
작 49
 
6.6%
서 46
 
6.2%
특 45
 
6.0%
별 45
 
6.0%
시 45
 
6.0%
구 45
 
6.0%
울 45
 
6.0%
로 45
 
6.0%
상 31
 
4.2%
Other values (65) 253
34.0%
Decimal Number
ValueCountFrequency (%)
1 58
31.2%
2 37
19.9%
0 20
 
10.8%
3 17
 
9.1%
8 12
 
6.5%
7 11
 
5.9%
4 10
 
5.4%
5 9
 
4.8%
6 6
 
3.2%
9 6
 
3.2%
Space Separator
ValueCountFrequency (%)
217
100.0%
Close Punctuation
ValueCountFrequency (%)
) 45
100.0%
Open Punctuation
ValueCountFrequency (%)
( 45
100.0%
Other Punctuation
ValueCountFrequency (%)
, 26
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 745
58.7%
Common 522
41.1%
Latin 3
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 96
 
12.9%
작 49
 
6.6%
서 46
 
6.2%
특 45
 
6.0%
별 45
 
6.0%
시 45
 
6.0%
구 45
 
6.0%
울 45
 
6.0%
로 45
 
6.0%
상 31
 
4.2%
Other values (65) 253
34.0%
Common
ValueCountFrequency (%)
217
41.6%
1 58
 
11.1%
) 45
 
8.6%
( 45
 
8.6%
2 37
 
7.1%
, 26
 
5.0%
0 20
 
3.8%
3 17
 
3.3%
8 12
 
2.3%
7 11
 
2.1%
Other values (5) 34
 
6.5%
Latin
ValueCountFrequency (%)
B 3
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 745
58.7%
ASCII 525
41.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
217
41.3%
1 58
 
11.0%
) 45
 
8.6%
( 45
 
8.6%
2 37
 
7.0%
, 26
 
5.0%
0 20
 
3.8%
3 17
 
3.2%
8 12
 
2.3%
7 11
 
2.1%
Other values (6) 37
 
7.0%
Hangul
ValueCountFrequency (%)
동 96
 
12.9%
작 49
 
6.6%
서 46
 
6.2%
특 45
 
6.0%
별 45
 
6.0%
시 45
 
6.0%
구 45
 
6.0%
울 45
 
6.0%
로 45
 
6.0%
상 31
 
4.2%
Other values (65) 253
34.0%

전화번호
Text

Distinct48
Distinct (%)80.0%
Missing0
Missing (%)0.0%
Memory size612.0 B
2024-04-21T11:04:35.041649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length11.216667
Min length11

Characters and Unicode

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

Unique36 ?
Unique (%)60.0%

Sample

1st row02-815-8815
2nd row02-813-9952
3rd row02-3472-1188
4th row02-823-9680
5th row02-532-1740
ValueCountFrequency (%)
02-587-5618 2
 
3.3%
02-3280-8275 2
 
3.3%
02-823-7500 2
 
3.3%
02-816-7582 2
 
3.3%
02-816-7579 2
 
3.3%
02-821-3181 2
 
3.3%
02-817-0025 2
 
3.3%
02-592-8875 2
 
3.3%
02-813-5999 2
 
3.3%
02-813-7579 2
 
3.3%
Other values (38) 40
66.7%
2024-04-21T11:04:35.438003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 120
17.8%
2 114
16.9%
0 88
13.1%
8 78
11.6%
5 66
9.8%
7 57
8.5%
1 44
 
6.5%
3 35
 
5.2%
9 32
 
4.8%
6 24
 
3.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 553
82.2%
Dash Punctuation 120
 
17.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 114
20.6%
0 88
15.9%
8 78
14.1%
5 66
11.9%
7 57
10.3%
1 44
 
8.0%
3 35
 
6.3%
9 32
 
5.8%
6 24
 
4.3%
4 15
 
2.7%
Dash Punctuation
ValueCountFrequency (%)
- 120
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 673
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 120
17.8%
2 114
16.9%
0 88
13.1%
8 78
11.6%
5 66
9.8%
7 57
8.5%
1 44
 
6.5%
3 35
 
5.2%
9 32
 
4.8%
6 24
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 673
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 120
17.8%
2 114
16.9%
0 88
13.1%
8 78
11.6%
5 66
9.8%
7 57
8.5%
1 44
 
6.5%
3 35
 
5.2%
9 32
 
4.8%
6 24
 
3.6%

Correlations

2024-04-21T11:04:35.535581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명영업상태사업장소재지전화번호
업소명1.0000.0000.9951.000
영업상태0.0001.0000.8390.000
사업장소재지0.9950.8391.0001.000
전화번호1.0000.0001.0001.000

Missing values

2024-04-21T11:04:33.270914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T11:04:33.392135image/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이승배수의과병원폐업<NA>02-815-8815
1중앙동물병원폐업서울특별시 동작구 현충로 100, 1층 (흑석동)02-813-9952
2야셀동물병원폐업서울특별시 동작구 사당로 308 (사당동,화인빌딩 1층)02-3472-1188
3상도동물병원폐업<NA>02-823-9680
4모범동물병원폐업서울특별시 동작구 사당로 229 (사당동)02-532-1740
5대신동물병원폐업<NA>02-813-2187
6김확수동물병원폐업<NA>02-823-7500
7동작동물종합병원폐업서울특별시 동작구 상도로 71 (대방동)02-814-7582
8사당동물병원정상서울특별시 동작구 남부순환로 2051 (사당동)02-586-8275
9세진동물병원폐업<NA>02-583-7572
업소명영업상태사업장소재지전화번호
50상도힐링동물병원정상서울특별시 동작구 상도로 353, 1층 (상도동)02-812-7512
51보라매웰종합동물병원정상서울특별시 동작구 상도로 16, 1층 (대방동)02-3280-7975
52지엔동물병원정상서울특별시 동작구 상도로31길 87, 2층 (상도동)02-812-8275
53캐나다동물병원폐업서울특별시 동작구 상도로 111 (상도동)070-4300-3938
54나을동물병원정상서울특별시 동작구 사당로 196, 1층 102호 (사당동, 거묵프리미엄 상가)02-521-5775
55유케어종합동물병원정상서울특별시 동작구 상도로 214, 성은빌딩 1층 (상도동)02-3280-8275
56엘'S동물병원폐업서울특별시 동작구 동작대로39길 22, 209동 116호117호 (동작동, 이수힐스테이트)02-595-7582
57품 동물의료센터정상서울특별시 동작구 양녕로 277-1 (상도1동)02-812-7585
58다정다감동물병원폐업서울특별시 동작구 만양로 11, 대화빌딩 1층 (상도동)02-6959-0759
59스무해 동물병원정상서울특별시 동작구 서달로 150, 2층 222호 (흑석동, 이랜드해가든)02-6953-0475

Duplicate rows

Most frequently occurring

업소명영업상태사업장소재지전화번호# duplicates
0굿모닝동물병원폐업서울특별시 동작구 상도로 303 (상도1동)02-816-75792
1인동물병원폐업<NA>02-813-96192
2쿠키동물병원폐업<NA>02-821-31812