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 30: | Line 30: | ||
! Dataset Description !! Screenshot and Metadata | ! Dataset Description !! Screenshot and Metadata | ||
|- | |- | ||
− | | Calls and songs from known birds in the Boonsong Lekagul Wildlife Preserve. They are in MP3 format with varying lengths. The file name contains the species name and an integer that can be referenced with AllBirdsv4.csv for its metadata. || [[Image:AllBirdsFileNames.PNG|center|frame|'''Screenshot of file names provided by Mistford College''']] | + | | 1. Calls and songs from known birds in the Boonsong Lekagul Wildlife Preserve. They are in MP3 format with varying lengths. The file name contains the species name and an integer that can be referenced with AllBirdsv4.csv for its metadata. || [[Image:AllBirdsFileNames.PNG|center|frame|'''Screenshot of file names provided by Mistford College''']] |
|- | |- | ||
− | | “AllBirdsv4.csv” contains metadata for the calls and songs from known birds in eight variables. | + | | 2. “AllBirdsv4.csv” contains metadata for the calls and songs from known birds in eight variables. |
|| | || | ||
{| class="wikitable" style="margin: auto;" | {| class="wikitable" style="margin: auto;" | ||
Line 56: | Line 56: | ||
|} <br> [[Image:AllBirdsMetadata.PNG|800px|border]] | |} <br> [[Image:AllBirdsMetadata.PNG|800px|border]] | ||
|- | |- | ||
− | | Fifteen bird sound files provided by Kasios to support their claim that Rose-crested Blue Pipits are still plentiful across the Preserve. They were recorded over the past few months and are in MP3 format. The file names are integers between 1 and 15, and its metadata can be referenced with Test Bird Locations.csv. || [[Image:TestBirdsFileNames.PNG|center|frame|'''Screenshot of file names provided by Kasios''']] | + | | 3. Fifteen bird sound files provided by Kasios to support their claim that Rose-crested Blue Pipits are still plentiful across the Preserve. They were recorded over the past few months and are in MP3 format. The file names are integers between 1 and 15, and its metadata can be referenced with Test Bird Locations.csv. || [[Image:TestBirdsFileNames.PNG|center|frame|'''Screenshot of file names provided by Kasios''']] |
|- | |- | ||
− | | “Test Bird Locations.csv” contains metadata for the Kasios files in three variables. | + | | 4. “Test Bird Locations.csv” contains metadata for the Kasios files in three variables. |
|| | || | ||
{| class="wikitable" style="margin: auto;" | {| class="wikitable" style="margin: auto;" | ||
Line 72: | Line 72: | ||
|} <br> [[Image:TestBirdsMetadata.PNG|center|frame|'''Screenshot of Test Birds Locations.csv''']] | |} <br> [[Image:TestBirdsMetadata.PNG|center|frame|'''Screenshot of Test Birds Locations.csv''']] | ||
|- | |- | ||
− | | “Lekagul Roadways 2018.bmp” is a 200 by 200 pixel map of the Preserve which outlines the roadways through the site. The bottom left of the map has coordinate (0,0) and the top right of the map has coordinate (199,199). Note that the alleged dumping site was centered around coordinate (148, 159) and its extent has not been thoroughly studied. || [[Image:Roadways.jpg|center|frame|'''Map of Lekagul Preserve with roadways''']] | + | | 5. “Lekagul Roadways 2018.bmp” is a 200 by 200 pixel map of the Preserve which outlines the roadways through the site. The bottom left of the map has coordinate (0,0) and the top right of the map has coordinate (199,199). Note that the alleged dumping site was centered around coordinate (148, 159) and its extent has not been thoroughly studied. || [[Image:Roadways.jpg|center|frame|'''Map of Lekagul Preserve with roadways''']] |
|} | |} | ||
<br> | <br> |
Revision as of 21:06, 6 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
Banner image credit to: Marshal Hedin