3

I have a school project in which I am supposed to analyse how much trains are late at different rail stations. I can create an artificial database for this purpose. However I would really like to use a real data for this project. Where can I find the data in which train courses, timetables, arrival and departure times (and anything else that is involved) is present. The country is unimportant.

EDIT: I am not interested in a website or a system to which I will have to do web scraping. My question is about a database which can be used directly.

3

The Swiss Open Transport Data platform has "Ist" (actual) data as a big CSV file, split into individual days.

https://opentransportdata.swiss/en/dataset/istdaten

For one particular day

https://opentransportdata.swiss/en/dataset/istdaten/resource/72d1b1cc-349f-420b-a692-f12c72841607

each file is about 200 MB as uncompressed CSV.

You will probably need to use the fields

  • AN_PROGNOSE = to forecast (schedule)

  • ANKUNFTSZEIT = arrival time

  • AB_PROGNOSE = from forecast (schedule)

  • ABFAHRTZEIT = departure time


Here's a limited list of applications using the data, you might find some code on Github that saves you some time parsing the file

https://opentransportdata.swiss/en/showcase-2/

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.