Challenge #396: Analyze the Ultimate Motorsport - Formula 1

[ARussell34]

It took me a minute to recognize we wanted a difference between best conditions and rainy conditions, but looks like Driver 9 would be the one to consider!

[dkungu]

like many others, took a minute to understand the requirements

[Sebastian_Chaieb2]

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 :)

Spoiler

 

 

[peterr_h]

Used a slightly different method (Cross-Tab rather than filter and join) but ended up with the same result. Not sure how the delta showed the 'best' driver, however, rather  the most consistent.

[peterr_h]

I also thought that C-T worked more effectively than filter and join!

[Ray_Pospisil]

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.

[Hannah_Bartholomew]

SPOILER

[myastarling]

Here's my solution :-)

[JosephSerpis]

Challenge Completed

Spoiler

[Yoshiro_Fujimori]

Missed the deadline while I was on vaction...

Spoiler

Workflow

The output does not match with the expected value.
I checked the solution file but do not understand why it changes the lap value to "Float" type from "Double".