ISSS608 2016-17 T3 Anuthama Data Prep
The Missing Case of the Rose-Crested Blue Pipit
|
|
|
|
|
|
|
|
Tools And Techniques Used
1. JMP
2. Tableau
3. Power BI
4. Microsoft Excel
Data Cleaning
Check for Missing Values:
I did a missing Value check using JMP and found that there were no missing values
Check for Duplicates:
1) Sort the data according to the car ID. Now all the car IDs will be sorted in ascending.
2) Use the formula below to check for duplicates
If you see 1 there are duplicates if u see 0 there are no duplicates.
Data Transformation
Annotating Points X and Y:
1)In Jmp create 2 new columns X and Y with values only in the first row. Since the map is 200*200 in dimension we need to use 200 as the X and Y coordinate values.
2)Load the Map as background image in Tableau. Click on Map --> Background Images.
3)Browse for the map and set the parameters as above.
4)Next Annotate the points for each gate and fill the coordinates for the gate in JMP.
Calculating Time Spent:
Create an new column and enter the following formula:
