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

Went through alot of REGEX attempts before settling on a two step approach to clean teams

My Solution:

Challenge 138 2019-12-06.jpg

Can definitely be simplified, but gets the job done!

Hi! This is my solution.

Here is my solution

Here is my solution !

Filter out the Nulls, regex replace parentheses and brackets to that each team name is clean, separate losing team columns and winning team columns and then union them to get appearances, summarize tools to get appearances and also winning years, formula to calculate winning percentage

Filter out the Nulls, regex replace parentheses and brackets to that each team name is clean, separate losing team columns and winning team columns and then union them to get appearances, summarize tools to get appearances and also winning years, formula to calculate winning percentage

curated machine learning resources