London Underground usage statistics

Question P9.2.4

Transport for London (TfL) is the UK local government body responsible for the public transport system of Greater London; they make available an Excel document, which provides statistics about the usage of the underground network (the Tube) in the form of entry and exit passenger numbers for a "typical" day at each station over the years 2007–2017.

Read in this document with pandas, and analyze it to determine:

(a) the busiest station on a typical weekday in 2017;

(b) the station with the greatest percentage increase in passengers over the period 2007–2017;

(c) the station with the largest relative difference in passenger numbers between the working week and a typical Sunday in 2017.


To access solutions, please obtain an access code from Cambridge University Press at the Lecturer Resources page for my book (registration required) and then sign up to providing this code.