Playing around with the Passenger Volume by Train Stations dataset on LTA DataMall. It’s a pretty cool dataset showing average number of tap ins and tap outs at each station by hour and day type (weekday or weekend). I’ve used the December 2018 data here and done some basic visualizations on Tableau. There’re a couple more interesting datasets, gonna try mix/add more stuff and see how it goes!
A shoutout to Hui Xiang Chua of Data Double Confirm for the awesome compilation of MRT station names and lat longs. Borrowed that for this viz, thanks! (Probably gonna borrow more stuff from that repo soon ;))
MRT Stations Average Daily/Hourly Passenger Volume in December 2018, Visualized
Map: Tap ins and tap outs at each MRT station for selected hour and day type (weekday/ weekend).
DailyMap: Similar to Map but summed across the day. I.e. tap ins and tap outs at each MRT station for selected day type.
DailyVol: Comparing total tap ins and tap outs across the day for each MRT station. Sort to find high volume/ low volume stations, and which stations are busier on weekdays or weekends.
DailyVolPiv: Similar to DailyVol but transposed to compare volume of tap ins, tap outs and day types at individual MRT stations. E.g. instead of which station is busier on weekday or weekend, find out whether a station is busier on weekday or weekend (spoiler alert, none are busier on weekends).
HourlyVol: Passenger volume patterns for each MRT station across the day (by day type).
Anything you’d like to see? Thoughts about these charts? Let me know in the comments!