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