Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #217: A Fast Blast From The Past

jonathangonzales
8 - Asteroid
Spoiler
jonathangonzales_1-1590529129367.png

 

jigsp30
6 - Meteoroid

Points are off

izamryan
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.

 

vince
5 - Atom
Spoiler

Vince42_0-1590533462283.png

 

Sudha8990AI
8 - Asteroid

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

dkoenawan004
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

 

 

 

ggruccio
ACE Emeritus
ACE Emeritus

Not a bad way to start the week!

 

Spoiler
ggruccio_1-1590540928497.png

 

 

mbogusz
9 - Comet
Spoiler
2020-05-26 20_54_26-Greenshot.png
jmt214
8 - Asteroid

Got stuck for a minute on the DNF requirement. 

 

Spoiler
Capture.PNG
Inactive User
Not applicable

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

Spoiler
En-217.PNG