Difference between revisions of "ISSS608 2016-17 T3 Anuthama Data Prep"
| Line 86: | Line 86: | ||
<br/> | <br/> | ||
[[Image:DataPrep7.png|500px|Right|100%]] | [[Image:DataPrep7.png|500px|Right|100%]] | ||
| + | |||
| + | <br/> | ||
| + | Calculating Sequence: | ||
| + | The following formula is used for calculating the sequence that a car ID has made. Each time the car exits the preserve it starts its sequence from 0 again. This will help us to track car IDs who have made multiple visits. | ||
| + | |||
| + | [[Image:DataPrep8.png|500px|Right|100%]] | ||
Revision as of 22:32, 16 July 2017
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:
Calculating Sequence:
The following formula is used for calculating the sequence that a car ID has made. Each time the car exits the preserve it starts its sequence from 0 again. This will help us to track car IDs who have made multiple visits.
