Difference between revisions of "ISSS608 2016-17 T3 Assign SANDHYA VASUDEVA RAO"
| Line 30: | Line 30: | ||
<font size = 4; color="Black"><b>''Data Prep''</b></font> | <font size = 4; color="Black"><b>''Data Prep''</b></font> | ||
</div> | </div> | ||
| + | <div> | ||
| + | == Tools Used== | ||
| + | * JMP for Data cleaning, and transformation. | ||
| + | <br/> | ||
| + | * Tableau for visualization | ||
| + | <br/> | ||
| + | * Microsoft Excel for Data cleaning, and transformation. | ||
| + | |||
| + | 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 date were the same were categorized as Single day visitors. The rest as Multiple day visitors. | ||
Revision as of 10:16, 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.
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 date were the same were categorized as Single day visitors. The rest as Multiple day visitors.
