Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution
Not happy with my solution - too much hard-coding. It does work.
Task 3 was not clear enough as it was missing information what to do with 'NA' values and round values before average.
Very interesting challenge requiring quite a bit of data manipulation to get it in the right shape for analysis.