The purpose of this project is to check if there is a correlation between increase in population of Amsterdam and increase in bikes in Amsterdam.
Programming part of the project is done on Python 3.
Data sources:
- https://data.amsterdam.nl/
- https://opendata.cbs.nl/statline/#/CBS/nl/navigatieScherm/thema
- https://www.verderfietsen.nl/
- https://www.timetomomo.com/nl/
- Meerjarenplan fiets 2017-2022
Project structure:
- main.ipynb
- confiscated.ipynb
- Population.ipynb
- Purchased.ipynb
- stolen.ipynb
Each source of data has been processed in a separate Jupyter notebook and then consolidated in one data frame in main.ipynb.
Calculations and assumptions:
- No data has been found regarding purchased bikes in Amsterdam so pro rata as per population ratio had been taken.
- No data has been found regarding stolen bikes destroyed so assumption that 100% of stolen bikes return to the market has been used, hence this data can be ignored for the purpose of this project.
- No exact data has been found regarding confiscating bikes been destroyed so average ratio of 1/3 had been used.
- No exact annual data has been found regarding bikes fished out of the canals so average amount of 6000 had been used.