This code computes the average distance made by plane per Swiss residents (i.e., people living in Switzerland but traveling by plane all around the world) in 2015, in km, based on the data of the Transport and Mobility Microcensus (MTMC). On average, every Swiss resident traveled 5015 km by plane in 2015 for non-business trips.
This result has been published in the magazine of the Swiss Federal Office for Spatial Development (ARE), "Forum Raumentwicklung"/"Forum du développement territorial"/"Forum sviluppo territoriale" (Forum for Spatial Development, not available in English), 02.2018, entitled "Mobilität der Zukunft"/"La mobilité du futur"/"La mobilità del futuro" (Mobility of the future, not available in English) and on Twitter in French, German, Italian and English.
This code also presents the distance of trips by plane by age categories (6-17 / 18-24 / 25-44 / 45-64 / 65-79 / 80+). The results are available as figures (in French, German and English) and as CSV files. You can find them in /data/output/ in this repository. The figures have been published on Twitter (in French, German and English).
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, pandas and numpy.
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 files zielpersonen.csv and reisenmueb.csv that you receive from the Swiss Federal Statistical Office (FSO) in the folder "data/input". Then run run_distance_by_plane_in_switzerland_in_2015.py.
DO NOT commit or share in any way these two CSV-files! These are personal data.