Overview

Dataset statistics

Number of variables5
Number of observations34
Missing cells7
Missing cells (%)4.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.5 KiB
Average record size in memory43.9 B

Variable types

Categorical2
Text3

Dataset

Description대구광역시 북구 관내에서 운영중인 동물병원(업종, 업소명, 전화번호, 사업장소재지주소 등) 현황 정보를 제공합니다
URLhttps://www.data.go.kr/data/15027997/fileData.do

Alerts

데이터기준일 has constant value ""Constant
업종 is highly imbalanced (80.9%)Imbalance
업소명 has 1 (2.9%) missing valuesMissing
전화번호 has 5 (14.7%) missing valuesMissing
사업장소재지(지번) has 1 (2.9%) missing valuesMissing

Reproduction

Analysis started2023-12-12 13:07:39.569577
Analysis finished2023-12-12 13:07:40.000037
Duration0.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종
Categorical

IMBALANCE 

Distinct2
Distinct (%)5.9%
Missing0
Missing (%)0.0%
Memory size404.0 B
동물병원
33 
<NA>
 
1

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique1 ?
Unique (%)2.9%

Sample

1st row동물병원
2nd row동물병원
3rd row동물병원
4th row동물병원
5th row동물병원

Common Values

ValueCountFrequency (%)
동물병원 33
97.1%
<NA> 1
 
2.9%

Length

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

Common Values (Plot)

2023-12-12T22:07:40.167265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동물병원 33
97.1%
na 1
 
2.9%

업소명
Text

MISSING 

Distinct33
Distinct (%)100.0%
Missing1
Missing (%)2.9%
Memory size404.0 B
2023-12-12T22:07:40.328339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length18
Mean length7.7575758
Min length5

Characters and Unicode

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

Unique

Unique33 ?
Unique (%)100.0%

Sample

1st row동명동물병원
2nd row경북대학교 수의과대학 부속동물병원
3rd row대구축협동물병원
4th row경북가축병원
5th row칠곡종합동물병원
ValueCountFrequency (%)
동물병원 6
 
13.6%
동명동물병원 1
 
2.3%
경북대학교 1
 
2.3%
플러스동물의료센터 1
 
2.3%
조아동물병원 1
 
2.3%
칠곡온동물의료센터 1
 
2.3%
이든동물병원 1
 
2.3%
우일축산 1
 
2.3%
ah 1
 
2.3%
해솔 1
 
2.3%
Other values (29) 29
65.9%
2023-12-12T22:07:40.622623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 33
 
12.9%
물 31
 
12.1%
병 30
 
11.7%
원 30
 
11.7%
11
 
4.3%
대 5
 
2.0%
구 3
 
1.2%
온 3
 
1.2%
북 3
 
1.2%
리 3
 
1.2%
Other values (78) 104
40.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 233
91.0%
Space Separator 11
 
4.3%
Lowercase Letter 3
 
1.2%
Uppercase Letter 3
 
1.2%
Close Punctuation 2
 
0.8%
Open Punctuation 2
 
0.8%
Decimal Number 2
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 33
 
14.2%
물 31
 
13.3%
병 30
 
12.9%
원 30
 
12.9%
대 5
 
2.1%
구 3
 
1.3%
온 3
 
1.3%
북 3
 
1.3%
리 3
 
1.3%
경 3
 
1.3%
Other values (68) 89
38.2%
Uppercase Letter
ValueCountFrequency (%)
A 1
33.3%
H 1
33.3%
L 1
33.3%
Lowercase Letter
ValueCountFrequency (%)
a 2
66.7%
r 1
33.3%
Decimal Number
ValueCountFrequency (%)
2 1
50.0%
4 1
50.0%
Space Separator
ValueCountFrequency (%)
11
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 233
91.0%
Common 17
 
6.6%
Latin 6
 
2.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 33
 
14.2%
물 31
 
13.3%
병 30
 
12.9%
원 30
 
12.9%
대 5
 
2.1%
구 3
 
1.3%
온 3
 
1.3%
북 3
 
1.3%
리 3
 
1.3%
경 3
 
1.3%
Other values (68) 89
38.2%
Common
ValueCountFrequency (%)
11
64.7%
) 2
 
11.8%
( 2
 
11.8%
2 1
 
5.9%
4 1
 
5.9%
Latin
ValueCountFrequency (%)
a 2
33.3%
A 1
16.7%
H 1
16.7%
L 1
16.7%
r 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 233
91.0%
ASCII 23
 
9.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 33
 
14.2%
물 31
 
13.3%
병 30
 
12.9%
원 30
 
12.9%
대 5
 
2.1%
구 3
 
1.3%
온 3
 
1.3%
북 3
 
1.3%
리 3
 
1.3%
경 3
 
1.3%
Other values (68) 89
38.2%
ASCII
ValueCountFrequency (%)
11
47.8%
a 2
 
8.7%
) 2
 
8.7%
( 2
 
8.7%
2 1
 
4.3%
4 1
 
4.3%
A 1
 
4.3%
H 1
 
4.3%
L 1
 
4.3%
r 1
 
4.3%

전화번호
Text

MISSING 

Distinct29
Distinct (%)100.0%
Missing5
Missing (%)14.7%
Memory size404.0 B
2023-12-12T22:07:40.806372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique29 ?
Unique (%)100.0%

Sample

1st row053-322-0041
2nd row053-950-6898
3rd row053-957-9901
4th row053-352-5630
5th row053-311-8275
ValueCountFrequency (%)
053-322-0041 1
 
3.4%
053-312-7553 1
 
3.4%
053-324-8875 1
 
3.4%
053-939-1175 1
 
3.4%
053-959-7775 1
 
3.4%
053-985-7550 1
 
3.4%
053-383-1199 1
 
3.4%
053-322-1223 1
 
3.4%
053-323-8875 1
 
3.4%
053-352-1998 1
 
3.4%
Other values (19) 19
65.5%
2023-12-12T22:07:41.147782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 67
19.3%
3 58
16.7%
- 58
16.7%
0 46
13.2%
7 25
 
7.2%
2 23
 
6.6%
9 22
 
6.3%
1 19
 
5.5%
8 15
 
4.3%
4 11
 
3.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 290
83.3%
Dash Punctuation 58
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 67
23.1%
3 58
20.0%
0 46
15.9%
7 25
 
8.6%
2 23
 
7.9%
9 22
 
7.6%
1 19
 
6.6%
8 15
 
5.2%
4 11
 
3.8%
6 4
 
1.4%
Dash Punctuation
ValueCountFrequency (%)
- 58
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 348
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 67
19.3%
3 58
16.7%
- 58
16.7%
0 46
13.2%
7 25
 
7.2%
2 23
 
6.6%
9 22
 
6.3%
1 19
 
5.5%
8 15
 
4.3%
4 11
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 348
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 67
19.3%
3 58
16.7%
- 58
16.7%
0 46
13.2%
7 25
 
7.2%
2 23
 
6.6%
9 22
 
6.3%
1 19
 
5.5%
8 15
 
4.3%
4 11
 
3.2%

사업장소재지(지번)
Text

MISSING 

Distinct33
Distinct (%)100.0%
Missing1
Missing (%)2.9%
Memory size404.0 B
2023-12-12T22:07:41.390644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length39
Mean length23.848485
Min length18

Characters and Unicode

Total characters787
Distinct characters68
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

Unique33 ?
Unique (%)100.0%

Sample

1st row대구광역시 북구 읍내동 781번지 1호
2nd row대구광역시 북구 산격동 1370번지 1호 경북대학교 수의과대학
3rd row대구광역시 북구 검단동 700번지 2호
4th row대구광역시 북구 노원동2가 290번지 3호
5th row대구광역시 북구 태전동 415번지 1호 102호
ValueCountFrequency (%)
대구광역시 33
19.3%
북구 33
19.3%
1호 7
 
4.1%
2호 5
 
2.9%
동천동 4
 
2.3%
산격동 4
 
2.3%
복현동 4
 
2.3%
태전동 4
 
2.3%
4호 3
 
1.8%
9호 2
 
1.2%
Other values (66) 72
42.1%
2023-12-12T22:07:41.785182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
171
21.7%
구 67
 
8.5%
1 41
 
5.2%
동 39
 
5.0%
대 37
 
4.7%
북 34
 
4.3%
지 34
 
4.3%
번 33
 
4.2%
광 33
 
4.2%
역 33
 
4.2%
Other values (58) 265
33.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 460
58.4%
Space Separator 171
 
21.7%
Decimal Number 155
 
19.7%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 67
14.6%
동 39
8.5%
대 37
8.0%
북 34
 
7.4%
지 34
 
7.4%
번 33
 
7.2%
광 33
 
7.2%
역 33
 
7.2%
시 33
 
7.2%
호 30
 
6.5%
Other values (46) 87
18.9%
Decimal Number
ValueCountFrequency (%)
1 41
26.5%
2 21
13.5%
9 17
11.0%
0 16
 
10.3%
3 13
 
8.4%
7 11
 
7.1%
6 10
 
6.5%
4 10
 
6.5%
8 9
 
5.8%
5 7
 
4.5%
Space Separator
ValueCountFrequency (%)
171
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 460
58.4%
Common 326
41.4%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 67
14.6%
동 39
8.5%
대 37
8.0%
북 34
 
7.4%
지 34
 
7.4%
번 33
 
7.2%
광 33
 
7.2%
역 33
 
7.2%
시 33
 
7.2%
호 30
 
6.5%
Other values (46) 87
18.9%
Common
ValueCountFrequency (%)
171
52.5%
1 41
 
12.6%
2 21
 
6.4%
9 17
 
5.2%
0 16
 
4.9%
3 13
 
4.0%
7 11
 
3.4%
6 10
 
3.1%
4 10
 
3.1%
8 9
 
2.8%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 460
58.4%
ASCII 327
41.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
171
52.3%
1 41
 
12.5%
2 21
 
6.4%
9 17
 
5.2%
0 16
 
4.9%
3 13
 
4.0%
7 11
 
3.4%
6 10
 
3.1%
4 10
 
3.1%
8 9
 
2.8%
Other values (2) 8
 
2.4%
Hangul
ValueCountFrequency (%)
구 67
14.6%
동 39
8.5%
대 37
8.0%
북 34
 
7.4%
지 34
 
7.4%
번 33
 
7.2%
광 33
 
7.2%
역 33
 
7.2%
시 33
 
7.2%
호 30
 
6.5%
Other values (46) 87
18.9%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size404.0 B
2023-07-28
34 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-07-28
2nd row2023-07-28
3rd row2023-07-28
4th row2023-07-28
5th row2023-07-28

Common Values

ValueCountFrequency (%)
2023-07-28 34
100.0%

Length

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

Common Values (Plot)

2023-12-12T22:07:41.999977image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-07-28 34
100.0%

Correlations

2023-12-12T22:07:42.049311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명전화번호사업장소재지(지번)
업소명1.0001.0001.000
전화번호1.0001.0001.000
사업장소재지(지번)1.0001.0001.000

Missing values

2023-12-12T22:07:39.763662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:07:39.859741image/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-12T22:07:39.946791image/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동물병원동명동물병원053-322-0041대구광역시 북구 읍내동 781번지 1호2023-07-28
1동물병원경북대학교 수의과대학 부속동물병원053-950-6898대구광역시 북구 산격동 1370번지 1호 경북대학교 수의과대학2023-07-28
2동물병원대구축협동물병원053-957-9901대구광역시 북구 검단동 700번지 2호2023-07-28
3동물병원경북가축병원053-352-5630대구광역시 북구 노원동2가 290번지 3호2023-07-28
4동물병원칠곡종합동물병원053-311-8275대구광역시 북구 태전동 415번지 1호 102호2023-07-28
5동물병원강동물병원053-325-7579대구광역시 북구 관음동 1383번지 14호2023-07-28
6동물병원굿모닝동물병원053-324-0116대구광역시 북구 동천동 932번지 4호2023-07-28
7동물병원가나동물병원053-954-3395대구광역시 북구 산격동 1216번지 4호2023-07-28
8동물병원늘푸른종합동물병원053-322-9075대구광역시 북구 관음동 1386번지 7호2023-07-28
9동물병원도그플러스 동물병원(미유펫 대구점)053-314-0075대구광역시 북구 동천동 668번지 1호 13통 5반 칠곡홈플러스 301호2023-07-28
업종업소명전화번호사업장소재지(지번)데이터기준일
24동물병원더문 동물병원053-322-1223대구광역시 북구 사수동 799번지2023-07-28
25동물병원비타민동물병원053-383-1199대구광역시 북구 복현동 73번지2023-07-28
26동물병원연경동물병원053-985-7550대구광역시 북구 연경동 960번지 1호2023-07-28
27동물병원해솔 동물병원053-959-7775대구광역시 북구 대현동 340번지 15호2023-07-28
28동물병원우일축산 AH<NA>대구광역시 북구 산격동 1816번지2023-07-28
29동물병원이든동물병원053-939-1175대구광역시 북구 복현동 427번지 5호 1층2023-07-28
30동물병원칠곡온동물의료센터<NA>대구광역시 북구 학정동 942번지 7호2023-07-28
31동물병원조아동물병원<NA>대구광역시 북구 복현동 209번지 9호2023-07-28
32동물병원플러스동물의료센터053-424-2455대구광역시 북구 칠성동2가 371번지 2호2023-07-28
33<NA><NA><NA><NA>2023-07-28