Who asked: Ines Costa, operations manager at Tamarack Bike Share.
Why: bikes are due a service every 60 days, and the maintenance crew wants to know which districts to visit first.
The data: bikes, the fleet export: a packed bike_code (model, size, color), a station typed by hand, last_service written month first, and km ridden. stations maps each station to its district.
What done looks like: one script that cleans the export, flags bikes more than 60 days past their last service as of 31 March 2026, summarises by district and draws a labeled bar chart of overdue bikes.
This project strings the level together: text cleaning, dates, splitting codes, a join, a grouped summary and a chart. Each step adds to the same script, so the work you did in the last step is where the next one starts.