Difference between revisions of "ISSS608 2017-18 T3 Assign Tan Yong Ying Data Overview and Cleaning"
Jump to navigation
Jump to search
Yy.tan.2017 (talk | contribs) |
Yy.tan.2017 (talk | contribs) |
||
Line 77: | Line 77: | ||
<div style="border-style: solid; border-width:0; background: #c8bdb9; padding: 7px; font-weight: bold; text-align:left; line-height: wrap_content; text-indent: 20px; font-size:20px; font-family:Century Gothic;border-bottom:5px solid white; border-top:5px solid black"><font color= #000000>Data Cleaning</font></div> | <div style="border-style: solid; border-width:0; background: #c8bdb9; padding: 7px; font-weight: bold; text-align:left; line-height: wrap_content; text-indent: 20px; font-size:20px; font-family:Century Gothic;border-bottom:5px solid white; border-top:5px solid black"><font color= #000000>Data Cleaning</font></div> | ||
Out of the 5 pieces of data listed above, only AllBirdsv4.csv requires data cleaning to remove values that cannot be imputed or replaced manually through guessing or inference. The data cleaning outcome for each variable in AllBirdsv4.csv is as follows: | Out of the 5 pieces of data listed above, only AllBirdsv4.csv requires data cleaning to remove values that cannot be imputed or replaced manually through guessing or inference. The data cleaning outcome for each variable in AllBirdsv4.csv is as follows: | ||
− | # '''File ID'''<br>This variable has no invalid values, meaning all File IDs are valid integer values.<br>[[File:FileIDSummary.png|400px|none]] | + | # '''File ID'''<br>This variable has no invalid values, meaning all File IDs are valid integer values.<br>[[File:FileIDSummary.png|400px|none]]<br> |
− | # '''English_name''' | + | # '''English_name'''<br>This variable has no invalid values. The summary shows we have recordings from 19 unique known species in the Preserve provided to us.<br>[[File:English_nameSummary.png|1000px|none]]<br> |
− | This variable has no invalid values. The summary shows we have recordings from 19 unique known species in the Preserve provided to us. | + | # '''Vocalization_Type'''<br>There is an invalid value of “?” for some rows. In any analysis of bird sounds, it is important to differentiate between songs and calls because they play different roles in the communication of birds. Bird songs are usually used by male birds to establish their territories and attract female birds during the breeding season. On the other hand, bird calls are functional and used to coordinate behavior between pairs or birds in a flock. Thus, any records of unknown vocalization type are excluded from our analysis.<br>[[File:VocalizationSummary.png|800px|none]]<br> |
− | |||
− | |||
Banner image credit to: [https://www.flickr.com/photos/23660854@N07/24385545393 Marshal Hedin] | Banner image credit to: [https://www.flickr.com/photos/23660854@N07/24385545393 Marshal Hedin] |
Revision as of 14:05, 7 July 2018
|
|
|
|
|
Data Overview
For this challenge, we were provided with the following data:
Data Cleaning
Out of the 5 pieces of data listed above, only AllBirdsv4.csv requires data cleaning to remove values that cannot be imputed or replaced manually through guessing or inference. The data cleaning outcome for each variable in AllBirdsv4.csv is as follows:
- File ID
This variable has no invalid values, meaning all File IDs are valid integer values. - English_name
This variable has no invalid values. The summary shows we have recordings from 19 unique known species in the Preserve provided to us. - Vocalization_Type
There is an invalid value of “?” for some rows. In any analysis of bird sounds, it is important to differentiate between songs and calls because they play different roles in the communication of birds. Bird songs are usually used by male birds to establish their territories and attract female birds during the breeding season. On the other hand, bird calls are functional and used to coordinate behavior between pairs or birds in a flock. Thus, any records of unknown vocalization type are excluded from our analysis.
Banner image credit to: Marshal Hedin