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

A solution to last week’s challenge can be found here.

This week's challenge is relatively straightforward, but sometimes data needs trimming.

The following dataset includes a list of city, country, year, continent, and season (winter or summer)

for each Olympic Games except those canceled.

Your challenge is to find:
- How many times has each continent hosted the Summer Olympics?
- How many times has each continent hosted the Olympic Winter Games?
- What is the total of the Olympic Games hosted for each continent, summer and winter combined?

Oh, easy, you may think. For this Challenge, you will have to propose 2 solutions and one that does not use the trim functions.

Let the games begin!

(edit 8/2 9:35 CT) video of solution overview, with discussion and build out of data 'trimming' options:

My take on the weekly challenge

Cheers and Happy analyzing 😀

Have a great week 🙂

I just can't believe they don't include Korfball and Tug of War as Olympic sports anymore. Such a shame.

My solution

Technically it says one solution should not use the trim function, therefore if neither of my solutions use it, I am still following the rules 😏

Technically it says one solution should not use the trim function, therefore if neither of my solutions use it, I am still following the rules

Add one for the summer count!

My 2 solutions :

My Solution without using Trim attached,

And in Python,

,