Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAlike many others, took a minute to understand the requirements
My Solution
It was faster to use Cross Tab but I decided to stay with filters and join to received same header names.
However I am attaching second version as well :)
I also thought that C-T worked more effectively than filter and join!
Solution in Alteryx, SQL and Python.
NOTE - Logic of finding the most suitable driver does not make sense though. Driver 1 was the fastest in Sunny as well as Rainy condition and his delta/spread between the fastest and slowest average is the second lowest right after Driver 9. In a real world, I would want to have Driver 1.
Missed the deadline while I was on vaction...