My first weekly challenge - completed the first three parts in the session at Inspire (thanks guys!) and the bonus tonight afterwards.
Found the first three parts straightforward enough, but the bonus was a little odd. My interpretation of the question seems to be a lot different - there were 17 August Sundays between 2015-2018. For the answer to be "12" in hour 14, there'd need to be on average 12 lifts in that hour across the 17 August Sundays, and so 204 in total. I only find 12 in total across the dataset.
That said, my input dataset seems to be different to those others have used. I start off with 3,740 records, whereas I note that another from this thread I downloaded shows 3,948. Have I gone wrong somewhere?
Just back from Inspire, felt inspired to take a challenge, unfortunately didn't make that session but here is my submission!!
The Bonus got me, took me at least 30 min to figure out what was being asked doh!