Overview

Dataset statistics

Number of variables7
Number of observations71
Missing cells17
Missing cells (%)3.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.1 KiB
Average record size in memory58.9 B

Variable types

Numeric1
DateTime1
Categorical4
Text1

Dataset

Description광주광역시 광산구 야생동물 구조치료 현황 정보(구조일자, 동물명, 구조지역, 위치, 부상내용 등)를 제공합니다.
Author광주광역시 광산구
URLhttps://www.data.go.kr/data/15086992/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
동물명 is highly overall correlated with 구조지역High correlation
구조지역 is highly overall correlated with 동물명 and 1 other fieldsHigh correlation
부상내용 is highly overall correlated with 구조지역High correlation
구조지역 is highly imbalanced (89.3%)Imbalance
주소 has 17 (23.9%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 01:16:22.431094
Analysis finished2023-12-12 01:16:23.337925
Duration0.91 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct71
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36
Minimum1
Maximum71
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size771.0 B
2023-12-12T10:16:23.454324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.5
Q118.5
median36
Q353.5
95-th percentile67.5
Maximum71
Range70
Interquartile range (IQR)35

Descriptive statistics

Standard deviation20.639767
Coefficient of variation (CV)0.57332687
Kurtosis-1.2
Mean36
Median Absolute Deviation (MAD)18
Skewness0
Sum2556
Variance426
MonotonicityStrictly increasing
2023-12-12T10:16:23.667089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.4%
2 1
 
1.4%
53 1
 
1.4%
52 1
 
1.4%
51 1
 
1.4%
50 1
 
1.4%
49 1
 
1.4%
48 1
 
1.4%
47 1
 
1.4%
46 1
 
1.4%
Other values (61) 61
85.9%
ValueCountFrequency (%)
1 1
1.4%
2 1
1.4%
3 1
1.4%
4 1
1.4%
5 1
1.4%
6 1
1.4%
7 1
1.4%
8 1
1.4%
9 1
1.4%
10 1
1.4%
ValueCountFrequency (%)
71 1
1.4%
70 1
1.4%
69 1
1.4%
68 1
1.4%
67 1
1.4%
66 1
1.4%
65 1
1.4%
64 1
1.4%
63 1
1.4%
62 1
1.4%

구조일자
Date

Distinct63
Distinct (%)88.7%
Missing0
Missing (%)0.0%
Memory size700.0 B
Minimum2015-01-05 00:00:00
Maximum2016-12-17 00:00:00
2023-12-12T10:16:23.836644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:16:23.977067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

동물명
Categorical

HIGH CORRELATION 

Distinct31
Distinct (%)43.7%
Missing0
Missing (%)0.0%
Memory size700.0 B
너구리
11 
직박구리
9 
고라니
9 
비둘기
5 
백로
 
3
Other values (26)
34 

Length

Max length7
Median length6
Mean length3.2535211
Min length2

Unique

Unique20 ?
Unique (%)28.2%

Sample

1st row밀화부리
2nd row지빠귀
3rd row논병아리
4th row논뿔병아리
5th row고라니

Common Values

ValueCountFrequency (%)
너구리 11
15.5%
직박구리 9
12.7%
고라니 9
12.7%
비둘기 5
 
7.0%
백로 3
 
4.2%
박새 3
 
4.2%
까치 3
 
4.2%
딱새 2
 
2.8%
논뿔병아리 2
 
2.8%
오색딱다구리 2
 
2.8%
Other values (21) 22
31.0%

Length

2023-12-12T10:16:24.148165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
너구리 11
15.3%
고라니 10
13.9%
직박구리 9
12.5%
비둘기 5
 
6.9%
백로 3
 
4.2%
박새 3
 
4.2%
까치 3
 
4.2%
오색딱다구리 2
 
2.8%
도요새 2
 
2.8%
논뿔병아리 2
 
2.8%
Other values (21) 22
30.6%

구조지역
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size700.0 B
광산구
70 
영광
 
1

Length

Max length3
Median length3
Mean length2.9859155
Min length2

Unique

Unique1 ?
Unique (%)1.4%

Sample

1st row광산구
2nd row광산구
3rd row광산구
4th row광산구
5th row광산구

Common Values

ValueCountFrequency (%)
광산구 70
98.6%
영광 1
 
1.4%

Length

2023-12-12T10:16:24.297172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T10:16:24.444065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광산구 70
98.6%
영광 1
 
1.4%

주소
Text

MISSING 

Distinct53
Distinct (%)98.1%
Missing17
Missing (%)23.9%
Memory size700.0 B
2023-12-12T10:16:24.750924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length23
Mean length18.944444
Min length14

Characters and Unicode

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

Unique

Unique52 ?
Unique (%)96.3%

Sample

1st row광주광역시 광산구 우산로 17
2nd row광주광역시 광산구 풍영로 63 905동
3rd row광주광역시 광산구 장덕동 산124-1
4th row광주광역시 광산구 장덕동 1037 709동
5th row광주광역시 광산구 용진로 639
ValueCountFrequency (%)
광주광역시 54
24.7%
광산구 53
24.2%
쌍암동 4
 
1.8%
운남동 3
 
1.4%
상무대로 3
 
1.4%
하남동 3
 
1.4%
장덕동 3
 
1.4%
수완동 3
 
1.4%
신가동 2
 
0.9%
송정동 2
 
0.9%
Other values (84) 89
40.6%
2023-12-12T10:16:25.247849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
165
16.1%
광 161
15.7%
산 63
 
6.2%
1 56
 
5.5%
역 54
 
5.3%
시 54
 
5.3%
구 54
 
5.3%
주 54
 
5.3%
동 45
 
4.4%
- 31
 
3.0%
Other values (55) 286
28.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 614
60.0%
Decimal Number 213
 
20.8%
Space Separator 165
 
16.1%
Dash Punctuation 31
 
3.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 161
26.2%
산 63
 
10.3%
역 54
 
8.8%
시 54
 
8.8%
구 54
 
8.8%
주 54
 
8.8%
동 45
 
7.3%
로 13
 
2.1%
남 9
 
1.5%
수 7
 
1.1%
Other values (43) 100
16.3%
Decimal Number
ValueCountFrequency (%)
1 56
26.3%
2 23
10.8%
8 20
 
9.4%
4 20
 
9.4%
7 18
 
8.5%
5 16
 
7.5%
6 16
 
7.5%
0 16
 
7.5%
3 14
 
6.6%
9 14
 
6.6%
Space Separator
ValueCountFrequency (%)
165
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 31
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 614
60.0%
Common 409
40.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 161
26.2%
산 63
 
10.3%
역 54
 
8.8%
시 54
 
8.8%
구 54
 
8.8%
주 54
 
8.8%
동 45
 
7.3%
로 13
 
2.1%
남 9
 
1.5%
수 7
 
1.1%
Other values (43) 100
16.3%
Common
ValueCountFrequency (%)
165
40.3%
1 56
 
13.7%
- 31
 
7.6%
2 23
 
5.6%
8 20
 
4.9%
4 20
 
4.9%
7 18
 
4.4%
5 16
 
3.9%
6 16
 
3.9%
0 16
 
3.9%
Other values (2) 28
 
6.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 614
60.0%
ASCII 409
40.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
165
40.3%
1 56
 
13.7%
- 31
 
7.6%
2 23
 
5.6%
8 20
 
4.9%
4 20
 
4.9%
7 18
 
4.4%
5 16
 
3.9%
6 16
 
3.9%
0 16
 
3.9%
Other values (2) 28
 
6.8%
Hangul
ValueCountFrequency (%)
광 161
26.2%
산 63
 
10.3%
역 54
 
8.8%
시 54
 
8.8%
구 54
 
8.8%
주 54
 
8.8%
동 45
 
7.3%
로 13
 
2.1%
남 9
 
1.5%
수 7
 
1.1%
Other values (43) 100
16.3%

부상내용
Categorical

HIGH CORRELATION 

Distinct25
Distinct (%)35.2%
Missing0
Missing (%)0.0%
Memory size700.0 B
충돌
14 
미아
13 
교통사고
6 
골절
5 
기립불능
5 
Other values (20)
28 

Length

Max length6
Median length2
Mean length3.0422535
Min length2

Unique

Unique14 ?
Unique (%)19.7%

Sample

1st row맹금류공격
2nd row영양실조
3rd row허약
4th row감전
5th row교통사고

Common Values

ValueCountFrequency (%)
충돌 14
19.7%
미아 13
18.3%
교통사고 6
 
8.5%
골절 5
 
7.0%
기립불능 5
 
7.0%
허약 4
 
5.6%
둥지추락 2
 
2.8%
외상 2
 
2.8%
날지 못함 2
 
2.8%
전신피부병 2
 
2.8%
Other values (15) 16
22.5%

Length

2023-12-12T10:16:25.461886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
충돌 14
18.2%
미아 13
16.9%
교통사고 6
 
7.8%
골절 6
 
7.8%
기립불능 5
 
6.5%
허약 4
 
5.2%
못함 2
 
2.6%
진드기감염 2
 
2.6%
전신피부병 2
 
2.6%
날지 2
 
2.6%
Other values (19) 21
27.3%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size700.0 B
2016-12-31
71 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2016-12-31
2nd row2016-12-31
3rd row2016-12-31
4th row2016-12-31
5th row2016-12-31

Common Values

ValueCountFrequency (%)
2016-12-31 71
100.0%

Length

2023-12-12T10:16:25.645270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T10:16:25.779823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2016-12-31 71
100.0%

Interactions

2023-12-12T10:16:22.953178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T10:16:25.880745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구조일자동물명구조지역주소부상내용
연번1.0000.9860.6740.0870.9470.332
구조일자0.9861.0000.8391.0000.9930.979
동물명0.6740.8391.0001.0000.9520.660
구조지역0.0871.0001.0001.000NaN1.000
주소0.9470.9930.952NaN1.0000.987
부상내용0.3320.9790.6601.0000.9871.000
2023-12-12T10:16:26.054643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
동물명부상내용구조지역
동물명1.0000.1730.761
부상내용0.1731.0000.816
구조지역0.7610.8161.000
2023-12-12T10:16:26.181817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번동물명구조지역부상내용
연번1.0000.2250.0460.094
동물명0.2251.0000.7610.173
구조지역0.0460.7611.0000.816
부상내용0.0940.1730.8161.000

Missing values

2023-12-12T10:16:23.127767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T10:16:23.281714image/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

연번구조일자동물명구조지역주소부상내용데이터기준일자
012016-01-12밀화부리광산구광주광역시 광산구 우산로 17맹금류공격2016-12-31
122016-01-20지빠귀광산구광주광역시 광산구 풍영로 63 905동영양실조2016-12-31
232016-01-25논병아리광산구광주광역시 광산구 장덕동 산124-1허약2016-12-31
342016-02-05논뿔병아리광산구광주광역시 광산구 장덕동 1037 709동감전2016-12-31
452016-02-17고라니광산구광주광역시 광산구 용진로 639교통사고2016-12-31
562016-02-26논뿔병아리광산구광주광역시 광산구 신가동 870미아2016-12-31
672016-02-26직박구리광산구광주광역시 광산구 수완동 1369골절2016-12-31
782016-02-27딱새광산구광주광역시 광산구 하남동 662기립불능2016-12-31
892016-03-29고라니광산구광주광역시 광산구 장수동 산29교통사고2016-12-31
9102016-04-07까치광산구광주광역시 광산구 옥동 881-12둥지추락2016-12-31
연번구조일자동물명구조지역주소부상내용데이터기준일자
61622015-09-10오색딱다구리광산구광주광역시 광산구 수등로 253충돌2016-12-31
62632015-09-10직박구리광산구광주광역시 광산구 선운중앙로 45미아2016-12-31
63642015-09-15붉은배지빠귀광산구광주광역시 광산구 신창로48번길 21-14충돌2016-12-31
64652015-10-03고라니광산구<NA>기립불능2016-12-31
65662015-10-13너구리광산구광주광역시 광산구 하남산단9번로 195-11허약피부열상2016-12-31
66672015-10-31도요새광산구<NA>미아2016-12-31
67682015-11-23머스코비덕광산구광주광역시 광산구 안청동 740-1미아2016-12-31
68692015-12-03고라니광산구<NA>충돌2016-12-31
69702015-12-23직박구리광산구광주광역시 광산구 평동로 790-16날지 못함2016-12-31
70712015-12-29고라니광산구<NA>기립불능2016-12-31