Overview

Dataset statistics

Number of variables10
Number of observations1072
Missing cells0
Missing cells (%)0.0%
Duplicate rows5
Duplicate rows (%)0.5%
Total size in memory86.0 KiB
Average record size in memory82.1 B

Variable types

Categorical6
DateTime3
Numeric1

Dataset

Description경기도 시흥시 길고양이중성화관리내역에는 관리번호, 포획일시, 축종, 품종, 색상, 성별, 체중, 나이, TNR수술일시가 포함되어 있습니다.
URLhttps://www.data.go.kr/data/15117507/fileData.do

Alerts

관리번호 has constant value ""Constant
축종 has constant value ""Constant
데이터기준일 has constant value ""Constant
Dataset has 5 (0.5%) duplicate rowsDuplicates
품종 is highly imbalanced (72.5%)Imbalance

Reproduction

Analysis started2023-12-12 21:58:21.626715
Analysis finished2023-12-12 21:58:22.426381
Duration0.8 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.5 KiB
441000000000000
1072 

Length

Max length15
Median length15
Mean length15
Min length15

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row441000000000000
2nd row441000000000000
3rd row441000000000000
4th row441000000000000
5th row441000000000000

Common Values

ValueCountFrequency (%)
441000000000000 1072
100.0%

Length

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

Common Values (Plot)

2023-12-13T06:58:22.605394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
441000000000000 1072
100.0%

포획일시
Date

Distinct573
Distinct (%)53.5%
Missing0
Missing (%)0.0%
Memory size8.5 KiB
Minimum2022-03-10 09:00:00
Maximum2022-12-14 12:00:00
2023-12-13T06:58:22.750515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:58:22.902108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

축종
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.5 KiB
길고양이
1072 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row길고양이
2nd row길고양이
3rd row길고양이
4th row길고양이
5th row길고양이

Common Values

ValueCountFrequency (%)
길고양이 1072
100.0%

Length

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

Common Values (Plot)

2023-12-13T06:58:23.144844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
길고양이 1072
100.0%

품종
Categorical

IMBALANCE 

Distinct14
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size8.5 KiB
한국길고양이
711 
코숏
347 
코숏
 
2
러시안블루
 
2
한국길고양이+터키쉬앙고라
 
1
Other values (9)
 
9

Length

Max length14
Median length6
Mean length4.693097
Min length2

Unique

Unique10 ?
Unique (%)0.9%

Sample

1st row한국길고양이
2nd row한국길고양이
3rd row한국길고양이
4th row한국길고양이
5th row한국길고양이

Common Values

ValueCountFrequency (%)
한국길고양이 711
66.3%
코숏 347
32.4%
코숏 2
 
0.2%
러시안블루 2
 
0.2%
한국길고양이+터키쉬앙고라 1
 
0.1%
한국ㄱ고양이 1
 
0.1%
고등어 1
 
0.1%
코쇼 1
 
0.1%
스노우슈 1
 
0.1%
믹스 1
 
0.1%
Other values (4) 4
 
0.4%

Length

2023-12-13T06:58:23.287859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
한국길고양이 711
66.3%
코숏 349
32.5%
러시안블루 2
 
0.2%
한국길고양이+터키쉬앙고라 1
 
0.1%
한국ㄱ고양이 1
 
0.1%
고등어 1
 
0.1%
코쇼 1
 
0.1%
스노우슈 1
 
0.1%
믹스 1
 
0.1%
삼색이 1
 
0.1%
Other values (4) 4
 
0.4%

색상
Categorical

Distinct47
Distinct (%)4.4%
Missing0
Missing (%)0.0%
Memory size8.5 KiB
고등어
281 
치즈
227 
턱시도
86 
삼색이
66 
카오스
57 
Other values (42)
355 

Length

Max length12
Median length11
Mean length2.8470149
Min length2

Unique

Unique20 ?
Unique (%)1.9%

Sample

1st row삼색
2nd row치즈
3rd row블랙
4th row고등어
5th row고등어

Common Values

ValueCountFrequency (%)
고등어 281
26.2%
치즈 227
21.2%
턱시도 86
 
8.0%
삼색이 66
 
6.2%
카오스 57
 
5.3%
젖소 53
 
4.9%
검정 47
 
4.4%
삼색 46
 
4.3%
흰+고등어 28
 
2.6%
흰치즈 23
 
2.1%
Other values (37) 158
14.7%

Length

2023-12-13T06:58:23.424696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
고등어 281
26.0%
치즈 229
21.2%
턱시도 86
 
8.0%
삼색이 66
 
6.1%
카오스 57
 
5.3%
젖소 53
 
4.9%
검정 51
 
4.7%
삼색 46
 
4.3%
흰+고등어 29
 
2.7%
흰+검정 23
 
2.1%
Other values (33) 160
14.8%

성별
Categorical

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size8.5 KiB
암컷
546 
수컷
526 

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 (%)
암컷 546
50.9%
수컷 526
49.1%

Length

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

Common Values (Plot)

2023-12-13T06:58:23.673850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
암컷 546
50.9%
수컷 526
49.1%

체중
Real number (ℝ)

Distinct305
Distinct (%)28.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.4030131
Minimum2
Maximum8.1
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size9.6 KiB
2023-12-13T06:58:23.791719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile2.05
Q12.58
median3.3
Q34.1
95-th percentile5.16
Maximum8.1
Range6.1
Interquartile range (IQR)1.52

Descriptive statistics

Standard deviation1.0039907
Coefficient of variation (CV)0.29502993
Kurtosis0.36221733
Mean3.4030131
Median Absolute Deviation (MAD)0.755
Skewness0.70628978
Sum3648.03
Variance1.0079974
MonotonicityNot monotonic
2023-12-13T06:58:23.944857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2.2 24
 
2.2%
2.0 22
 
2.1%
2.5 21
 
2.0%
2.1 21
 
2.0%
3.5 21
 
2.0%
3.6 16
 
1.5%
3.1 16
 
1.5%
2.4 16
 
1.5%
4.2 15
 
1.4%
2.3 15
 
1.4%
Other values (295) 885
82.6%
ValueCountFrequency (%)
2.0 22
2.1%
2.01 6
 
0.6%
2.02 5
 
0.5%
2.03 8
 
0.7%
2.04 10
0.9%
2.05 4
 
0.4%
2.06 4
 
0.4%
2.07 7
 
0.7%
2.08 4
 
0.4%
2.09 5
 
0.5%
ValueCountFrequency (%)
8.1 1
0.1%
7.4 1
0.1%
7.17 1
0.1%
6.6 1
0.1%
6.55 1
0.1%
6.51 1
0.1%
6.5 1
0.1%
6.37 1
0.1%
6.32 1
0.1%
6.28 1
0.1%

나이
Categorical

Distinct13
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size8.5 KiB
1살
350 
2세령
181 
1살추정
170 
1세령
170 
2살추정
144 
Other values (8)
57 

Length

Max length4
Median length3
Mean length3.0130597
Min length1

Unique

Unique5 ?
Unique (%)0.5%

Sample

1st row1살추정
2nd row2살추정
3rd row1살추정
4th row1살추정
5th row1살추정

Common Values

ValueCountFrequency (%)
1살 350
32.6%
2세령 181
16.9%
1살추정 170
15.9%
1세령 170
15.9%
2살추정 144
13.4%
6개월령 40
 
3.7%
3살추정 9
 
0.8%
2세추정 3
 
0.3%
3.85 1
 
0.1%
3 1
 
0.1%
Other values (3) 3
 
0.3%

Length

2023-12-13T06:58:24.105810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
1살 351
32.7%
2세령 181
16.9%
1살추정 170
15.9%
1세령 170
15.9%
2살추정 144
13.4%
6개월령 40
 
3.7%
3살추정 9
 
0.8%
2세추정 3
 
0.3%
3.85 1
 
0.1%
3 1
 
0.1%
Other values (2) 2
 
0.2%

중성화(TNR)일시
Date

Distinct611
Distinct (%)57.0%
Missing0
Missing (%)0.0%
Memory size8.5 KiB
Minimum2022-03-10 10:00:00
Maximum2022-12-14 14:00:00
2023-12-13T06:58:24.254841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:58:24.412359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.5 KiB
Minimum2023-08-02 00:00:00
Maximum2023-08-02 00:00:00
2023-12-13T06:58:24.532295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:58:24.636680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T06:58:22.004663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T06:58:24.706503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
품종색상성별체중나이
품종1.0000.8900.0320.0000.613
색상0.8901.0000.5840.0000.666
성별0.0320.5841.0000.5160.147
체중0.0000.0000.5161.0000.481
나이0.6130.6660.1470.4811.000
2023-12-13T06:58:24.800767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
색상품종나이성별
색상1.0000.4960.2600.481
품종0.4961.0000.2730.025
나이0.2600.2731.0000.136
성별0.4810.0250.1361.000
2023-12-13T06:58:24.905802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
체중품종색상성별나이
체중1.0000.0000.0000.3980.222
품종0.0001.0000.4960.0250.273
색상0.0000.4961.0000.4810.260
성별0.3980.0250.4811.0000.136
나이0.2220.2730.2600.1361.000

Missing values

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

관리번호포획일시축종품종색상성별체중나이중성화(TNR)일시데이터기준일
04410000000000002022/12/14 12:00길고양이한국길고양이삼색암컷3.671살추정2022/12/14 14:002023-08-02
14410000000000002022/12/13 12:00길고양이한국길고양이치즈수컷4.532살추정2022/12/13 12:002023-08-02
24410000000000002022/12/12 14:00길고양이한국길고양이블랙수컷3.991살추정2022/12/12 16:002023-08-02
34410000000000002022/12/12 14:00길고양이한국길고양이고등어암컷2.471살추정2022/12/12 16:002023-08-02
44410000000000002022/12/12 14:00길고양이한국길고양이고등어암컷2.571살추정2022/12/12 16:002023-08-02
54410000000000002022/12/12 11:00길고양이한국길고양이고등어무늬암컷2.531살추정2022/12/12 15:002023-08-02
64410000000000002022/12/12 11:00길고양이한국길고양이고등어암컷3.342살추정2022/12/12 15:002023-08-02
74410000000000002022/12/12 11:00길고양이한국길고양이고등어무늬암컷2.421살추정2022/12/12 12:002023-08-02
84410000000000002022/12/12 11:00길고양이한국길고양이삼색암컷3.612살추정2022/12/12 12:002023-08-02
94410000000000002022/12/10 11:00길고양이한국길고양이고등어수컷3.391살추정2022/12/10 12:002023-08-02
관리번호포획일시축종품종색상성별체중나이중성화(TNR)일시데이터기준일
10624410000000000002022/03/12 18:00길고양이한국길고양이치즈암컷2.41세령2022/03/13 12:002023-08-02
10634410000000000002022/03/12 18:00길고양이한국길고양이치즈수컷2.11세령2022/03/13 12:002023-08-02
10644410000000000002022/03/12 18:00길고양이한국길고양이턱시도수컷4.32세령2022/03/13 12:002023-08-02
10654410000000000002022/03/11 9:00길고양이한국길고양이고등어암컷2.01세령2022/03/11 12:002023-08-02
10664410000000000002022/03/10 22:00길고양이한국길고양이고등어수컷2.71세령2022/03/11 12:002023-08-02
10674410000000000002022/03/10 14:00길고양이한국길고양이젖소수컷3.71세령2022/03/11 12:002023-08-02
10684410000000000002022/03/10 16:00길고양이한국길고양이치즈수컷4.61세령2022/03/11 12:002023-08-02
10694410000000000002022/03/10 16:00길고양이한국길고양이치즈수컷4.02세령2022/03/11 12:002023-08-02
10704410000000000002022/03/10 22:00길고양이한국길고양이고등어암컷3.52세령2022/03/11 12:002023-08-02
10714410000000000002022/03/12 11:00길고양이한국길고양이치즈수컷3.582세추정2022/03/12 12:002023-08-02

Duplicate rows

Most frequently occurring

관리번호포획일시축종품종색상성별체중나이중성화(TNR)일시데이터기준일# duplicates
04410000000000002022/06/28 0:00길고양이한국길고양이고등어암컷3.51세령2022/06/29 0:002023-08-022
14410000000000002022/08/17 13:00길고양이한국길고양이고등어수컷2.21세령2022/08/17 17:002023-08-022
24410000000000002022/09/06 18:00길고양이한국길고양이삼색이암컷2.11세령2022/09/07 14:002023-08-022
34410000000000002022/10/13 10:00길고양이한국길고양이카오스암컷2.72세령2022/10/13 14:002023-08-022
44410000000000002022/10/25 17:00길고양이한국길고양이턱시도수컷2.01세령2022/10/26 14:002023-08-022