Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows729
Duplicate rows (%)7.3%
Total size in memory468.8 KiB
Average record size in memory48.0 B

Variable types

Categorical2
Text3

Dataset

Description21년 부터 22년까지 동물등록 정보와 관련하여 등록동물의 정보(축종, 품종, 성별, 이름, 색상 항목)를 제공합니다
Author공공데이터포털
URLhttps://www.data.go.kr/data/15114356/fileData.do

Alerts

Dataset has 729 (7.3%) duplicate rowsDuplicates
축종 is highly imbalanced (81.1%)Imbalance

Reproduction

Analysis started2024-04-18 00:45:34.229046
Analysis finished2024-04-18 00:45:35.878267
Duration1.65 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

축종
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
개
9710 
고양이
 
290

Length

Max length3
Median length1
Mean length1.058
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row개
2nd row개
3rd row개
4th row개
5th row개

Common Values

ValueCountFrequency (%)
개 9710
97.1%
고양이 290
 
2.9%

Length

2024-04-18T09:45:35.954788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T09:45:36.051258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
개 9710
97.1%
고양이 290
 
2.9%

이름
Text

Distinct3599
Distinct (%)36.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-04-18T09:45:36.353647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length2
Mean length2.1889
Min length1

Characters and Unicode

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

Unique

Unique2539 ?
Unique (%)25.4%

Sample

1st row설
2nd row짱아
3rd row쿠꾸
4th row배찌
5th row짱아
ValueCountFrequency (%)
보리 163
 
1.6%
콩이 131
 
1.3%
코코 125
 
1.2%
두부 110
 
1.1%
호두 100
 
1.0%
초코 90
 
0.9%
구름 86
 
0.9%
망고 80
 
0.8%
뭉치 76
 
0.8%
토리 74
 
0.7%
Other values (3563) 8973
89.7%
2024-04-18T09:45:36.825656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
이 2199
 
10.0%
리 836
 
3.8%
코 432
 
2.0%
미 394
 
1.8%
두 391
 
1.8%
구 358
 
1.6%
루 334
 
1.5%
콩 300
 
1.4%
보 248
 
1.1%
아 246
 
1.1%
Other values (776) 16151
73.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 21058
96.2%
Decimal Number 286
 
1.3%
Lowercase Letter 238
 
1.1%
Uppercase Letter 181
 
0.8%
Space Separator 63
 
0.3%
Dash Punctuation 32
 
0.1%
Close Punctuation 11
 
0.1%
Open Punctuation 10
 
< 0.1%
Other Punctuation 9
 
< 0.1%
Modifier Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
이 2199
 
10.4%
리 836
 
4.0%
코 432
 
2.1%
미 394
 
1.9%
두 391
 
1.9%
구 358
 
1.7%
루 334
 
1.6%
콩 300
 
1.4%
보 248
 
1.2%
아 246
 
1.2%
Other values (711) 15320
72.8%
Uppercase Letter
ValueCountFrequency (%)
A 18
 
9.9%
I 15
 
8.3%
L 15
 
8.3%
B 14
 
7.7%
S 11
 
6.1%
T 9
 
5.0%
O 9
 
5.0%
C 9
 
5.0%
N 8
 
4.4%
K 7
 
3.9%
Other values (15) 66
36.5%
Lowercase Letter
ValueCountFrequency (%)
a 32
13.4%
i 28
11.8%
e 26
10.9%
n 24
10.1%
o 20
 
8.4%
l 14
 
5.9%
y 14
 
5.9%
r 11
 
4.6%
u 10
 
4.2%
p 8
 
3.4%
Other values (12) 51
21.4%
Decimal Number
ValueCountFrequency (%)
0 73
25.5%
2 60
21.0%
1 41
14.3%
9 22
 
7.7%
4 22
 
7.7%
5 19
 
6.6%
3 17
 
5.9%
8 13
 
4.5%
6 10
 
3.5%
7 9
 
3.1%
Other Punctuation
ValueCountFrequency (%)
& 3
33.3%
; 3
33.3%
# 3
33.3%
Space Separator
ValueCountFrequency (%)
63
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 32
100.0%
Close Punctuation
ValueCountFrequency (%)
) 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 21058
96.2%
Latin 419
 
1.9%
Common 412
 
1.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
이 2199
 
10.4%
리 836
 
4.0%
코 432
 
2.1%
미 394
 
1.9%
두 391
 
1.9%
구 358
 
1.7%
루 334
 
1.6%
콩 300
 
1.4%
보 248
 
1.2%
아 246
 
1.2%
Other values (711) 15320
72.8%
Latin
ValueCountFrequency (%)
a 32
 
7.6%
i 28
 
6.7%
e 26
 
6.2%
n 24
 
5.7%
o 20
 
4.8%
A 18
 
4.3%
I 15
 
3.6%
L 15
 
3.6%
B 14
 
3.3%
l 14
 
3.3%
Other values (37) 213
50.8%
Common
ValueCountFrequency (%)
0 73
17.7%
63
15.3%
2 60
14.6%
1 41
10.0%
- 32
7.8%
9 22
 
5.3%
4 22
 
5.3%
5 19
 
4.6%
3 17
 
4.1%
8 13
 
3.2%
Other values (8) 50
12.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 21058
96.2%
ASCII 831
 
3.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
이 2199
 
10.4%
리 836
 
4.0%
코 432
 
2.1%
미 394
 
1.9%
두 391
 
1.9%
구 358
 
1.7%
루 334
 
1.6%
콩 300
 
1.4%
보 248
 
1.2%
아 246
 
1.2%
Other values (711) 15320
72.8%
ASCII
ValueCountFrequency (%)
0 73
 
8.8%
63
 
7.6%
2 60
 
7.2%
1 41
 
4.9%
- 32
 
3.9%
a 32
 
3.9%
i 28
 
3.4%
e 26
 
3.1%
n 24
 
2.9%
9 22
 
2.6%
Other values (55) 430
51.7%

성별
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
수컷
5311 
암컷
4689 

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 (%)
수컷 5311
53.1%
암컷 4689
46.9%

Length

2024-04-18T09:45:36.978566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T09:45:37.070208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수컷 5311
53.1%
암컷 4689
46.9%

품종
Text

Distinct133
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-04-18T09:45:37.323180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length14
Mean length4.0795
Min length1

Characters and Unicode

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

Unique

Unique31 ?
Unique (%)0.3%

Sample

1st row사모예드
2nd row말티즈
3rd row비숑 프리제
4th row믹스견
5th row믹스견
ValueCountFrequency (%)
믹스견 1989
15.5%
푸들 1407
 
11.0%
말티즈 1255
 
9.8%
포메라니안 1198
 
9.4%
비숑 903
 
7.1%
프리제 903
 
7.1%
치와와 301
 
2.4%
진도견 287
 
2.2%
리트리버 230
 
1.8%
라이카 202
 
1.6%
Other values (149) 4116
32.2%
2024-04-18T09:45:37.752345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2791
 
6.8%
스 2392
 
5.9%
견 2321
 
5.7%
믹 1996
 
4.9%
리 1907
 
4.7%
라 1666
 
4.1%
들 1427
 
3.5%
푸 1408
 
3.5%
니 1388
 
3.4%
안 1345
 
3.3%
Other values (185) 22154
54.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 37994
93.1%
Space Separator 2791
 
6.8%
Dash Punctuation 10
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
스 2392
 
6.3%
견 2321
 
6.1%
믹 1996
 
5.3%
리 1907
 
5.0%
라 1666
 
4.4%
들 1427
 
3.8%
푸 1408
 
3.7%
니 1388
 
3.7%
안 1345
 
3.5%
티 1293
 
3.4%
Other values (183) 20851
54.9%
Space Separator
ValueCountFrequency (%)
2791
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 37994
93.1%
Common 2801
 
6.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
스 2392
 
6.3%
견 2321
 
6.1%
믹 1996
 
5.3%
리 1907
 
5.0%
라 1666
 
4.4%
들 1427
 
3.8%
푸 1408
 
3.7%
니 1388
 
3.7%
안 1345
 
3.5%
티 1293
 
3.4%
Other values (183) 20851
54.9%
Common
ValueCountFrequency (%)
2791
99.6%
- 10
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 37994
93.1%
ASCII 2801
 
6.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2791
99.6%
- 10
 
0.4%
Hangul
ValueCountFrequency (%)
스 2392
 
6.3%
견 2321
 
6.1%
믹 1996
 
5.3%
리 1907
 
5.0%
라 1666
 
4.4%
들 1427
 
3.8%
푸 1408
 
3.7%
니 1388
 
3.7%
안 1345
 
3.5%
티 1293
 
3.4%
Other values (183) 20851
54.9%

색상
Text

Distinct315
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-04-18T09:45:38.003663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length2
Mean length2.9775
Min length2

Characters and Unicode

Total characters29775
Distinct characters208
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique189 ?
Unique (%)1.9%

Sample

1st row흰색
2nd row흰색
3rd row흰색
4th row크림색
5th row바둑이
ValueCountFrequency (%)
흰색 3619
35.6%
갈색 1144
 
11.3%
크림색 946
 
9.3%
검정색 623
 
6.1%
갈색&흰색 533
 
5.2%
검정&흰색 443
 
4.4%
회색 285
 
2.8%
기타 248
 
2.4%
황색 215
 
2.1%
황갈색 155
 
1.5%
Other values (295) 1944
19.1%
2024-04-18T09:45:38.406643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
색 9864
33.1%
흰 4844
16.3%
갈 2295
 
7.7%
검 1498
 
5.0%
& 1373
 
4.6%
정 1186
 
4.0%
크 983
 
3.3%
림 982
 
3.3%
황 529
 
1.8%
회 339
 
1.1%
Other values (198) 5882
19.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 26448
88.8%
Uppercase Letter 1581
 
5.3%
Other Punctuation 1510
 
5.1%
Space Separator 156
 
0.5%
Lowercase Letter 39
 
0.1%
Math Symbol 17
 
0.1%
Close Punctuation 12
 
< 0.1%
Open Punctuation 12
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
색 9864
37.3%
흰 4844
18.3%
갈 2295
 
8.7%
검 1498
 
5.7%
정 1186
 
4.5%
크 983
 
3.7%
림 982
 
3.7%
황 529
 
2.0%
회 339
 
1.3%
은 264
 
1.0%
Other values (152) 3664
 
13.9%
Uppercase Letter
ValueCountFrequency (%)
T 187
11.8%
E 173
10.9%
I 163
10.3%
A 134
 
8.5%
W 126
 
8.0%
H 121
 
7.7%
L 111
 
7.0%
O 79
 
5.0%
R 78
 
4.9%
G 65
 
4.1%
Other values (12) 344
21.8%
Lowercase Letter
ValueCountFrequency (%)
r 5
12.8%
w 4
10.3%
o 4
10.3%
n 4
10.3%
e 4
10.3%
c 3
7.7%
b 3
7.7%
a 3
7.7%
l 2
 
5.1%
m 2
 
5.1%
Other values (5) 5
12.8%
Other Punctuation
ValueCountFrequency (%)
& 1373
90.9%
/ 73
 
4.8%
, 44
 
2.9%
· 18
 
1.2%
. 2
 
0.1%
Space Separator
ValueCountFrequency (%)
156
100.0%
Math Symbol
ValueCountFrequency (%)
+ 17
100.0%
Close Punctuation
ValueCountFrequency (%)
) 12
100.0%
Open Punctuation
ValueCountFrequency (%)
( 12
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 26448
88.8%
Common 1707
 
5.7%
Latin 1620
 
5.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
색 9864
37.3%
흰 4844
18.3%
갈 2295
 
8.7%
검 1498
 
5.7%
정 1186
 
4.5%
크 983
 
3.7%
림 982
 
3.7%
황 529
 
2.0%
회 339
 
1.3%
은 264
 
1.0%
Other values (152) 3664
 
13.9%
Latin
ValueCountFrequency (%)
T 187
11.5%
E 173
10.7%
I 163
10.1%
A 134
 
8.3%
W 126
 
7.8%
H 121
 
7.5%
L 111
 
6.9%
O 79
 
4.9%
R 78
 
4.8%
G 65
 
4.0%
Other values (27) 383
23.6%
Common
ValueCountFrequency (%)
& 1373
80.4%
156
 
9.1%
/ 73
 
4.3%
, 44
 
2.6%
· 18
 
1.1%
+ 17
 
1.0%
) 12
 
0.7%
( 12
 
0.7%
. 2
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 26448
88.8%
ASCII 3309
 
11.1%
None 18
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
색 9864
37.3%
흰 4844
18.3%
갈 2295
 
8.7%
검 1498
 
5.7%
정 1186
 
4.5%
크 983
 
3.7%
림 982
 
3.7%
황 529
 
2.0%
회 339
 
1.3%
은 264
 
1.0%
Other values (152) 3664
 
13.9%
ASCII
ValueCountFrequency (%)
& 1373
41.5%
T 187
 
5.7%
E 173
 
5.2%
I 163
 
4.9%
156
 
4.7%
A 134
 
4.0%
W 126
 
3.8%
H 121
 
3.7%
L 111
 
3.4%
O 79
 
2.4%
Other values (35) 686
20.7%
None
ValueCountFrequency (%)
· 18
100.0%

Correlations

2024-04-18T09:45:38.525488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
축종성별
축종1.0000.022
성별0.0221.000
2024-04-18T09:45:38.613251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
성별축종
성별1.0000.014
축종0.0141.000
2024-04-18T09:45:38.711899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
축종성별
축종1.0000.014
성별0.0141.000

Missing values

2024-04-18T09:45:35.829214image/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

축종이름성별품종색상
39554개설암컷사모예드흰색
91992개짱아암컷말티즈흰색
52199개쿠꾸수컷비숑 프리제흰색
98300개배찌암컷믹스견크림색
69030개짱아수컷믹스견바둑이
96828개흑구수컷믹스견검정색
69452개가을암컷푸들크림색
1213개뽀삐수컷비숑 프리제흰색
14708개영웅수컷진도견흰색
34478개까무수컷푸들검정색
축종이름성별품종색상
90274개감자수컷믹스견검정&흰색
56070고양이비비안암컷페르시안기타
91898개강쇠수컷진도견검정색
59732개마루암컷골든 리트리버금색
15748개까미암컷토이 푸들회색
31598개티모수컷믹스견갈색&흰색
15342개효순이암컷진도견황색
97756개뽀미암컷푸들실버
45970개주디암컷이탈리안 그레이 하운드검정색
77291개쿠퍼수컷푸들갈색

Duplicate rows

Most frequently occurring

축종이름성별품종색상# duplicates
107개두부수컷비숑 프리제흰색20
22개구름수컷말티즈흰색18
24개구름수컷비숑 프리제흰색14
105개두부수컷말티즈흰색14
258개뭉치수컷비숑 프리제흰색14
389개사랑이암컷말티즈흰색14
550개코코수컷말티즈흰색14
110개두부암컷말티즈흰색12
261개뭉치수컷포메라니안흰색12
535개초코수컷푸들갈색11