Overview

Dataset statistics

Number of variables3
Number of observations21
Missing cells11
Missing cells (%)17.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory636.0 B
Average record size in memory30.3 B

Variable types

Text3

Dataset

Description부산광역시 사상구 관내 반려동물 미용업체(업소명, 소재지, 전화번호)에 대한 안내 및 정보를 제공하고자 이자료를 공공데이터 시스템에 업로드 합니다
URLhttps://www.data.go.kr/data/15085832/fileData.do

Alerts

전화번호 has 11 (52.4%) missing valuesMissing
업소명 has unique valuesUnique
사업장소재지(도로명) has unique valuesUnique

Reproduction

Analysis started2023-12-12 18:22:20.697848
Analysis finished2023-12-12 18:22:21.110701
Duration0.41 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업소명
Text

UNIQUE 

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

Length

Max length13
Median length11
Mean length6.3333333
Min length3

Characters and Unicode

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

Unique

Unique21 ?
Unique (%)100.0%

Sample

1st row개금동물병원
2nd row쿨펫동물병원
3rd row엄궁종합동물병원
4th row고은동물병원
5th row학장동물병원
ValueCountFrequency (%)
애견미용실 2
 
6.5%
개금동물병원 1
 
3.2%
쿨펫동물병원 1
 
3.2%
몽스데이 1
 
3.2%
school 1
 
3.2%
486dog 1
 
3.2%
냥이 1
 
3.2%
멍이와 1
 
3.2%
미용실 1
 
3.2%
도로시펫 1
 
3.2%
Other values (20) 20
64.5%
2023-12-13T03:22:21.684931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
10
 
7.5%
5
 
3.8%
5
 
3.8%
5
 
3.8%
5
 
3.8%
5
 
3.8%
4
 
3.0%
3
 
2.3%
3
 
2.3%
3
 
2.3%
Other values (67) 85
63.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 105
78.9%
Uppercase Letter 15
 
11.3%
Space Separator 10
 
7.5%
Decimal Number 3
 
2.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
5
 
4.8%
5
 
4.8%
5
 
4.8%
5
 
4.8%
5
 
4.8%
4
 
3.8%
3
 
2.9%
3
 
2.9%
3
 
2.9%
3
 
2.9%
Other values (52) 64
61.0%
Uppercase Letter
ValueCountFrequency (%)
O 3
20.0%
C 2
13.3%
L 2
13.3%
M 1
 
6.7%
K 1
 
6.7%
H 1
 
6.7%
U 1
 
6.7%
S 1
 
6.7%
B 1
 
6.7%
G 1
 
6.7%
Decimal Number
ValueCountFrequency (%)
8 1
33.3%
6 1
33.3%
4 1
33.3%
Space Separator
ValueCountFrequency (%)
10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 105
78.9%
Latin 15
 
11.3%
Common 13
 
9.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
5
 
4.8%
5
 
4.8%
5
 
4.8%
5
 
4.8%
5
 
4.8%
4
 
3.8%
3
 
2.9%
3
 
2.9%
3
 
2.9%
3
 
2.9%
Other values (52) 64
61.0%
Latin
ValueCountFrequency (%)
O 3
20.0%
C 2
13.3%
L 2
13.3%
M 1
 
6.7%
K 1
 
6.7%
H 1
 
6.7%
U 1
 
6.7%
S 1
 
6.7%
B 1
 
6.7%
G 1
 
6.7%
Common
ValueCountFrequency (%)
10
76.9%
8 1
 
7.7%
6 1
 
7.7%
4 1
 
7.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 105
78.9%
ASCII 28
 
21.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
10
35.7%
O 3
 
10.7%
C 2
 
7.1%
L 2
 
7.1%
8 1
 
3.6%
M 1
 
3.6%
K 1
 
3.6%
H 1
 
3.6%
U 1
 
3.6%
S 1
 
3.6%
Other values (5) 5
17.9%
Hangul
ValueCountFrequency (%)
5
 
4.8%
5
 
4.8%
5
 
4.8%
5
 
4.8%
5
 
4.8%
4
 
3.8%
3
 
2.9%
3
 
2.9%
3
 
2.9%
3
 
2.9%
Other values (52) 64
61.0%
Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size300.0 B
2023-12-13T03:22:21.978045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length36
Mean length31.428571
Min length21

Characters and Unicode

Total characters660
Distinct characters93
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

Unique21 ?
Unique (%)100.0%

Sample

1st row부산광역시 사상구 가야대로 367 (주례동)
2nd row부산광역시 사상구 낙동대로 733, 롯데마트엄궁점 2층 (엄궁동)
3rd row부산광역시 사상구 대동로 18(엄궁동)
4th row부산광역시 사상구 모라로 107, 고은동물병원 (모라동)
5th row부산광역시 사상구 대동로 129 (학장동)
ValueCountFrequency (%)
부산광역시 21
 
16.3%
사상구 21
 
16.3%
2층 6
 
4.7%
주례동 5
 
3.9%
모라동 4
 
3.1%
사상로 4
 
3.1%
가야대로 4
 
3.1%
괘법동 3
 
2.3%
대동로 2
 
1.6%
감전동 2
 
1.6%
Other values (54) 57
44.2%
2023-12-13T03:22:22.430817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
108
 
16.4%
29
 
4.4%
28
 
4.2%
27
 
4.1%
22
 
3.3%
21
 
3.2%
( 21
 
3.2%
) 21
 
3.2%
21
 
3.2%
21
 
3.2%
Other values (83) 341
51.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 394
59.7%
Space Separator 108
 
16.4%
Decimal Number 93
 
14.1%
Open Punctuation 21
 
3.2%
Close Punctuation 21
 
3.2%
Other Punctuation 15
 
2.3%
Dash Punctuation 5
 
0.8%
Uppercase Letter 3
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
29
 
7.4%
28
 
7.1%
27
 
6.9%
22
 
5.6%
21
 
5.3%
21
 
5.3%
21
 
5.3%
21
 
5.3%
21
 
5.3%
21
 
5.3%
Other values (65) 162
41.1%
Decimal Number
ValueCountFrequency (%)
2 18
19.4%
1 17
18.3%
7 12
12.9%
3 11
11.8%
4 8
8.6%
0 7
 
7.5%
9 6
 
6.5%
6 5
 
5.4%
8 5
 
5.4%
5 4
 
4.3%
Uppercase Letter
ValueCountFrequency (%)
A 1
33.3%
S 1
33.3%
K 1
33.3%
Space Separator
ValueCountFrequency (%)
108
100.0%
Open Punctuation
ValueCountFrequency (%)
( 21
100.0%
Close Punctuation
ValueCountFrequency (%)
) 21
100.0%
Other Punctuation
ValueCountFrequency (%)
, 15
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 394
59.7%
Common 263
39.8%
Latin 3
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
29
 
7.4%
28
 
7.1%
27
 
6.9%
22
 
5.6%
21
 
5.3%
21
 
5.3%
21
 
5.3%
21
 
5.3%
21
 
5.3%
21
 
5.3%
Other values (65) 162
41.1%
Common
ValueCountFrequency (%)
108
41.1%
( 21
 
8.0%
) 21
 
8.0%
2 18
 
6.8%
1 17
 
6.5%
, 15
 
5.7%
7 12
 
4.6%
3 11
 
4.2%
4 8
 
3.0%
0 7
 
2.7%
Other values (5) 25
 
9.5%
Latin
ValueCountFrequency (%)
A 1
33.3%
S 1
33.3%
K 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 394
59.7%
ASCII 266
40.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
108
40.6%
( 21
 
7.9%
) 21
 
7.9%
2 18
 
6.8%
1 17
 
6.4%
, 15
 
5.6%
7 12
 
4.5%
3 11
 
4.1%
4 8
 
3.0%
0 7
 
2.6%
Other values (8) 28
 
10.5%
Hangul
ValueCountFrequency (%)
29
 
7.4%
28
 
7.1%
27
 
6.9%
22
 
5.6%
21
 
5.3%
21
 
5.3%
21
 
5.3%
21
 
5.3%
21
 
5.3%
21
 
5.3%
Other values (65) 162
41.1%

전화번호
Text

MISSING 

Distinct10
Distinct (%)100.0%
Missing11
Missing (%)52.4%
Memory size300.0 B
2023-12-13T03:22:22.657525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique10 ?
Unique (%)100.0%

Sample

1st row051-324-9954
2nd row051-314-7582
3rd row051-316-7597
4th row051-311-7578
5th row051-312-7555
ValueCountFrequency (%)
051-324-9954 1
10.0%
051-314-7582 1
10.0%
051-316-7597 1
10.0%
051-311-7578 1
10.0%
051-312-7555 1
10.0%
051-893-6532 1
10.0%
051-326-0049 1
10.0%
051-316-1526 1
10.0%
051-313-1216 1
10.0%
051-325-0067 1
10.0%
2023-12-13T03:22:22.995685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 20
16.7%
1 20
16.7%
- 20
16.7%
0 14
11.7%
3 12
10.0%
2 8
 
6.7%
7 7
 
5.8%
6 7
 
5.8%
9 5
 
4.2%
4 4
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 100
83.3%
Dash Punctuation 20
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 20
20.0%
1 20
20.0%
0 14
14.0%
3 12
12.0%
2 8
 
8.0%
7 7
 
7.0%
6 7
 
7.0%
9 5
 
5.0%
4 4
 
4.0%
8 3
 
3.0%
Dash Punctuation
ValueCountFrequency (%)
- 20
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 120
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 20
16.7%
1 20
16.7%
- 20
16.7%
0 14
11.7%
3 12
10.0%
2 8
 
6.7%
7 7
 
5.8%
6 7
 
5.8%
9 5
 
4.2%
4 4
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 120
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 20
16.7%
1 20
16.7%
- 20
16.7%
0 14
11.7%
3 12
10.0%
2 8
 
6.7%
7 7
 
5.8%
6 7
 
5.8%
9 5
 
4.2%
4 4
 
3.3%

Correlations

2023-12-13T03:22:23.102342image/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:22:20.960379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:22:21.070089image/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개금동물병원부산광역시 사상구 가야대로 367 (주례동)051-324-9954
1쿨펫동물병원부산광역시 사상구 낙동대로 733, 롯데마트엄궁점 2층 (엄궁동)051-314-7582
2엄궁종합동물병원부산광역시 사상구 대동로 18(엄궁동)051-316-7597
3고은동물병원부산광역시 사상구 모라로 107, 고은동물병원 (모라동)051-311-7578
4학장동물병원부산광역시 사상구 대동로 129 (학장동)051-312-7555
5핫독애견부산광역시 사상구 사상로250번길 41-7 (괘법동)051-893-6532
6야옹아 멍멍해봐부산광역시 사상구 사상로 162 (괘법동)051-326-0049
7개와 고양이부산광역시 사상구 새벽시장로56번가길 4, 효성스튜디오 (감전동)051-316-1526
8온나펫부산광역시 사상구 사상로277번길 42, 수타반점 2층 (삼락동)<NA>
9안녕하개부산광역시 사상구 가야대로 374, 신성빌딩 2층 (주례동)051-313-1216
업소명사업장소재지(도로명)전화번호
11우리집 첫째부산광역시 사상구 사상로 208-1, 804호 (괘법동)<NA>
12희야네 애견미용실부산광역시 사상구 사상로 497, 2층 (모라동)<NA>
13우한수 애견미용실부산광역시 사상구 백양대로950번나길 93, 1층 (모라동)<NA>
14파파뭉부산광역시 사상구 가야대로 268, 정훈아카데미빌딩 3층 (주례동)<NA>
15MK CLUB 부산점부산광역시 사상구 백양대로 712, 덕포남영아파트 상가 2동 2층 3호 (덕포동)<NA>
16도로시펫 미용실부산광역시 사상구 가야대로 336, A동 (주례동)<NA>
17멍이와 냥이부산광역시 사상구 백양대로 915-1(모라동)051-325-0067
18486DOG SCHOOL부산광역시 사상구 모라로110번길 43, 2층 (모라동)<NA>
19몽스데이부산광역시 사상구 사상로 277-1, SK텔레콤 대리점 1층 (덕포동)<NA>
20언니도그부산광역시 사상구 괘감로 98-1 (감전동)<NA>