Difference between revisions of "ISSS608 2017-18 T3 Assign Zhang Yingdi Task1"
Ydzhang.2017 (talk | contribs) |
Ydzhang.2017 (talk | contribs) |
||
Line 37: | Line 37: | ||
Change the data type of Date column from “Character” to “Numeric”, Modelling type from “Nominal” to “Ordinary”, Format to “m/d/y”. | Change the data type of Date column from “Character” to “Numeric”, Modelling type from “Nominal” to “Ordinary”, Format to “m/d/y”. | ||
− | [[File:Task1-2-.png|center]] | + | [[File:Task1-2-.png|center|400px]] |
+ | |||
Check and make sure there are no missing values in the Date column. | Check and make sure there are no missing values in the Date column. | ||
− | [[File:Task1-3-.png|center| | + | [[File:Task1-3-.png|center|100px]] |
+ | |||
+ | Next, check values in X and Y columns, there are two rows with “?” in the Y column, delete these two rows from the data table. | ||
+ | |||
+ | [[File:Task1-4-.png|center|500px]] |
Revision as of 19:15, 8 July 2018
|
|
|
|
|
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.
Change the data type of Date column from “Character” to “Numeric”, Modelling type from “Nominal” to “Ordinary”, Format to “m/d/y”.
Check and make sure there are no missing values in the Date column.
Next, check values in X and Y columns, there are two rows with “?” in the Y column, delete these two rows from the data table.