Difference between revisions of "ISSS608 2017-18 T3 Assign Zhang Yingdi Task1"
Ydzhang.2017 (talk | contribs) |
Ydzhang.2017 (talk | contribs) |
||
| Line 32: | Line 32: | ||
Import file '''AllBirdsv4.csv''' into JMP, in column '''Date''', there are 13 records with values “0000-00-00”, these 13 records are considered as missing information and are removed from the dataset. | Import file '''AllBirdsv4.csv''' into JMP, in column '''Date''', there are 13 records with values “0000-00-00”, these 13 records are considered as missing information and are removed from the dataset. | ||
Next, the date format in column '''Date''' is not standardized, most of the rows are in format mm/dd/yy. However, there some rows with different date format yyyy-mm-dd, all these records are recoded to format mm/dd/yy. | Next, the date format in column '''Date''' is not standardized, most of the rows are in format mm/dd/yy. However, there some rows with different date format yyyy-mm-dd, all these records are recoded to format mm/dd/yy. | ||
| + | [[File:Task1-1-.png|thumbnail]] | ||
Revision as of 18:55, 8 July 2018
VAST Mini Challenge 1: "Cheep" Shots?
|
|
|
|
|
|
The objective of this question is to use the bird call collection and the included map of the Wildlife Preserve, characterize the patterns of all the bird species in the Preserve over the time of the collection and detect if there are any trends or anomalies in the patterns. The analysis of this question is conducted in Tableau.
Data Preparation
Import file AllBirdsv4.csv into JMP, in column Date, there are 13 records with values “0000-00-00”, these 13 records are considered as missing information and are removed from the dataset. Next, the date format in column Date is not standardized, most of the rows are in format mm/dd/yy. However, there some rows with different date format yyyy-mm-dd, all these records are recoded to format mm/dd/yy.
