Difference between revisions of "ISSS608 2016-17 T3 Assign SANDHYA VASUDEVA RAO"
| Line 39: | Line 39: | ||
Create 2 columns on the dataset provided - X and Y. It is given that the grid size is 200*200. Therefore, X and Y will have a combination of 1 to 200 as values. | Create 2 columns on the dataset provided - X and Y. It is given that the grid size is 200*200. Therefore, X and Y will have a combination of 1 to 200 as values. | ||
The next step is to identify X and Y coordinates for gates on the map. The below picture shows the coordinates for each gate-name. | The next step is to identify X and Y coordinates for gates on the map. The below picture shows the coordinates for each gate-name. | ||
| − | [[File: | + | [[File:DataPrep.png]] |
== Data prep to Categorize visitors as Single Day and Multiple Days == | == Data prep to Categorize visitors as Single Day and Multiple Days == | ||
The entire data was divided into visitors that visited the Nature Preserve just for a day and those that visited over multiple days. | The entire data was divided into visitors that visited the Nature Preserve just for a day and those that visited over multiple days. | ||
Based on the Timestamp, all the visitors whose start date and end date were the same were categorized as Single day visitors. The rest as Multiple day visitors. | Based on the Timestamp, all the visitors whose start date and end date were the same were categorized as Single day visitors. The rest as Multiple day visitors. | ||
Revision as of 11:15, 17 July 2017
Boonsong Lekagul Nature Preserve - Mini Challenge 1
|
Overview & Data Preparation |
Background
Boonsong Lekagul Nature Preserve is currently seeing a decline in the nesting of Rose-crested Blue Pipit, which may be attributed to the traffic going through the preserve or perhaps related to the campers in the birds' habitat. A few patterns have been analyzed using the traffic data collected by the park rangers as a part of their annual report to the local government. The map of the Nature Preserve is as shown below.
Visualizations done with Tableau were used to solve the questions that are a part of the challenge. A repeating pattern recognition to describe the daily patterns of life by vehicles traveling through and within the park with descriptions about the vehicles and their spatial activities was one such question. Patterns of life over a long period of time were also analysed, which included the temporal activities of vehicles passing through and within the park over multiple days. In addition to this, unusual patterns were also studied and analysed in detail. Finally, a decision on the top 3 patterns that were primarily suspect to causing such an impact to bird life were listed down.
Data Prep
Tools Used
- JMP for Data cleaning, and transformation.
- Tableau for visualization
- Microsoft Excel for Data cleaning, and transformation.
Data prep to plot the coordinates on the Map
Create 2 columns on the dataset provided - X and Y. It is given that the grid size is 200*200. Therefore, X and Y will have a combination of 1 to 200 as values.
The next step is to identify X and Y coordinates for gates on the map. The below picture shows the coordinates for each gate-name.
Data prep to Categorize visitors as Single Day and Multiple Days
The entire data was divided into visitors that visited the Nature Preserve just for a day and those that visited over multiple days. Based on the Timestamp, all the visitors whose start date and end date were the same were categorized as Single day visitors. The rest as Multiple day visitors.
