Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #217: A Fast Blast From The Past

Highlighted
8 - Asteroid
Spoiler
jonathangonzales_1-1590529129367.png

 

Highlighted
6 - Meteoroid

Points are off

Highlighted
8 - Asteroid

Piece of cake. This was a fun challenge!

 

My results matched the provided answer:

Driver Sum_Value
S. VETTEL 281
F. ALONSO 191
J. BUTTON 187

 

This challenge probably underscores for me the importance of DOMAIN KNOWLEDGE when solving a challenge. More in the spoilers below!

 

Spoiler
izamryan_0-1590532132856.png

 


This had 4 stages, and a couple of GOTCHAs!

Gotcha 1: Low laptime is != good. Sometimes low laptime = bad.
I originally did a bit of data exploration when I first got the dataset and I noticed that ranking the drivers by the "Sum of their total lap times in the races" showed some interesting outliers: one driver had a Zero laptime! And if you thought "low lap time = good" the you'd have assigned this 0 laptime driver the 1st place!

Gotcha 2: Not all drivers finished their races.
When doing my data exploration I noticed that not all drivers had the same number of "Max number of laps per race", meaning some bailed from the race partway through. And you can't assign those drivers who bailed a place at the podium ... cos you have to finish the race to qualify for podium!

1. Filter for drivers who actually finished

I used a Join tool and a Filter to split out which drivers participated and completed each of the races.

2. Rank the drivers in ascending order of race time

And then I listed the drivers from 1 to 10, in their finishing positions.

3. Grab the scores from the other file, and Join

I took the scores on the Right and Joined it to the rank of drivers in the Left.

4. Filter for the Top 3 podium winners

And voila, sum their scores and filer for the Top 3.

 

Highlighted
5 - Atom
Spoiler

Vince42_0-1590533462283.png

 

Highlighted
8 - Asteroid

I enjoyed the work. A little trick is there to get an exact answer. Very interesting.

Highlighted
7 - Meteor

Here's my solution to the problem.

 

Took me a while before I realize that racers with really low cumulative lap time didn't finish the race (duh! all those crash videos).

 

 

Spoiler
dkoenawan004_0-1590540749890.png

 

 

 

Highlighted
12 - Quasar
12 - Quasar

Not a bad way to start the week!

 

Spoiler
ggruccio_1-1590540928497.png

 

 

Highlighted
8 - Asteroid
Spoiler
2020-05-26 20_54_26-Greenshot.png
Highlighted
8 - Asteroid

Got stuck for a minute on the DNF requirement. 

 

Spoiler
Capture.PNG
Highlighted
Inactive User
Not applicable

Not sure about how the 2 hours constraints should play here.

Spoiler
En-217.PNG