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 #167: Grand Prix 2019

NatSnook
8 - Asteroid

thanks

SueDonim
8 - Asteroid

Not quite as clean as I would like it - I kept finding little "ooops, I forgot 'x'" bits, so there are certainly some tool redundancies here

 

 

Spoiler
Process (working left to right and top to bottom - mostly):
- Group races by year and date to find the most recent date (for calculating age of driver upon championship)
- Filtered race results data to capture top 10 for each race
- Joined race results and race details data
- Grouped by year and driver to take sum of points
- Sorted and sampled to determine top driver for each year
- Captured driver date of birth
- Combined first three strings discussed above
- Calculated age of driver (in both years and days) at championship
- Sorted by Age in days to serve as tie-breaker
- Joined with clean-up name of team
- Sorted by Age in Days
- Calculated Youngest and Oldest driver
- Joined and cleaned up for the win

MySolution.PNG

 

 

hanykowska
11 - Bolide

done

 

Spoiler
there were two who were 23 years old, so I needed to calculate the value in days
image.png
AbbieRoss-Carter
8 - Asteroid
 
wdelta
5 - Atom

boom!

bjkay30
8 - Asteroid

Done...

Spoiler
clipboard_image_0.png
blundebjerg
8 - Asteroid
 
JamesFo
8 - Asteroid
 
OllieClarke
15 - Aurora
15 - Aurora

Kept on getting the wrong answer, then realised I was reading months as minutes...

 

Spoiler
Challenge 167.png
gracec97
8 - Asteroid
Spoiler
Challenge 167.JPG