This python script computes the modal split of trips going through Bern railway station. It selects the trips going through Bern railway station from the data of the Mobility and Transport Microcensus (MTMC) 2015, computes the main transport mode before and after going through the train station and saves the modal split before/after as CSV files in German and in French.
The results have been published as an infographic in the magazine of the Swiss Federal Office for Spatial Development (ARE) "Forum Raumentwicklung"/"Forum du développement territorial"/"Forum sviluppo territoriale" in its edition about combined mobility on page 9 in German and on page 43 in French. It has also been published on Twitter in German and the Mastodon instance datasci.social in French and in German.
According to our definition of Bern railway station, 1444 trips are going through the railway station. These trips have been made by 706 single persons.
These instructions will get you a copy of the project up and running on your local machine for reproducing the result and understanding how it has been generated.
To run the code itself, you need python 3 and pandas.
For it to produce the results, you also need the raw data of the Transport and Mobility Microcensus 2015, not included on GitHub. These data are individual data and therefore not open. You can however get them by filling in this form in German, French or Italian. The cost of the data is available in the document "Mikrozensus Mobilität und Verkehr 2015: Mögliche Zusatzauswertungen"/"Microrecensement mobilité et transports 2015: Analyses supplémentaires possibles".
Please copy the file etappen.csv that you receive from the Federal Statistical Office in the folder "data/input". Then run src/run_modal_split_in_train_stations.py.
DO NOT commit or share in any way the CSV-files etappen.csv! These are personal data.