The rise in accidents involving cyclists in Zurich over the past ten years has led to increased calls for the development of safer and more robust bicycle paths. The data showed a steady increase in the number of accidents involving cyclists, with the number of accidents more than doubling in the past decade. The goal of this research is to examine patterns in traffic accidents involving cyclists in Zurich. This analysis provides an in-depth understanding of the patterns and trends in accidents involving cyclists in Zurich and can inform policy decisions to improve the safety of cyclists on the road.
The ELT pipeline is based on a mixture of Python and NoSQL.
This project was conducted by Matthas De Paolis.
The data is extracted from one API.
To run this project a Mongo DB has to be configured and the connection setup in the chapter "Setting API and Database details" has to be adapted accordingly to your own MongoDB. In particular, the CNX_String must be replaced as defined in the script.
The script requires the user to have Jupyter Notebook installed on his / her computer. Another option is to open the .ipynb file on Google Colab.