Another script grabs the previous day’s data and stores it in the database. This script just uses some nested loops to grab the data and store it. The last step was to iterate over all the train numbers and days to pull the data. This makes it easy and efficient to access the data later. This script then creates objects for the trip data and stores them in a PostgreSQL database using SQLAlchemy. With the page data fetched as HTML, a script was hacked together using BeautifulSoup to extract all the values. With that information, we can easily calculate how delayed the trains are. For each trip, we get the scheduled and actual arrival and departure times for every station. After some testing, we found that Via’s data goes back to April 2015, which gives us over 6 months of data.
#Cross country canada 2 download full game code
This code allows us to fetch data for any train number on any date. With this in mind, it’s time to jump into Python and use the fantastic requests library to forge some requests. TrainInstanceDate also appears to be set to the date the train left. DepartureDate is the date the train left, and ArrivalDate is when it arrived. TsiTrainNumber is obviously the train number we’re looking at. Fortunately, we can fire up Chrome’s inspector and find this get request: This would let us build up a set of trip data, but only one day at a time. Via does provide schedule data for the previous, current, and next day on their status page.
#Cross country canada 2 download full game how to
Join me after the break as I discuss how this all works, and how to pick a winner when buying your next train ticket. The result is TrainStats.ca, a display of Via’s on time performance. Digging into the data available through any browser viewing the Via Rail site, it was possible to query for past scheduled/actual arrival data. However, they do provide some data about arrival and departure times. After noticing that some trains have very frequent delays, it seemed like it would be useful to know the average performance of each Via train. Unfortunately, passenger rail has to yield to commercial rail in Canada which often causes delays. Canada isn’t the best candidate for rail transit, given the rather large space between coasts, but Via Rail does operate regular train service in their corridor between Windsor and Quebec City. They’re a nice, albeit slow, way to get around the country.
0 kommentar(er)
