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
Finally, I have the data to figure out what movies to watch on the weekends!
The solution file actually has two mistakes.
Task 2 Peter O'Toole and Glenn Close were both 8 time nominees with no wins (sorry guys)
Task 3: Daniel Day Lewis should not be on the always wins list. His name was also spelled as Daniel Day-Lewis (so he won 3 times in 6 nominations)
In my solution, I added a detour tool to toggle the name fix.
Also included the fuzzy match analysis on actor/actress names (there are some funny similarities).
Task 2 list
Daniel Day Lewis typo
Really funny challenge, thanks!
Running time 0,3 sec
Two names received 8 nominations and 0 wins making them eligible for the Task 2 answer. I've called them out in the yellow container and were excluded from the inner join to match the answer key.
I've answered Task 3 and 4 by filtering a cross-tabbed grid of T/F counts of the 'winner' column. This is different than the intended solution, so I masked the results to match the answer key. A couple checks are included in the 'Test Cross Tab" containers to verify the name population.
