We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #279: How many Olympic Games per Continent?

AYXAcademy
Alteryx
Alteryx

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)image279.PNG

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.

Aaron_Harter
11 - Bolide

Let the games begin!

Spoiler
0.PNG

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

Spoiler

atcodedog05
20 - Arcturus

My take on the weekly challenge

 

Spoiler
atcodedog05_0-1627908612038.png

 

Cheers and Happy analyzing 😀

Have a great week 🙂

Blake
12 - Quasar

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

 

Spoiler
279.png
RolandSchubert
15 - Aurora
15 - Aurora

My solution

Spoiler
279.jpg
Kenda
15 - Aurora
15 - Aurora
Spoiler
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 😏

Kenda_0-1627912293469.png

 

DeanWest
9 - Comet

Add one for the summer count!

Spoiler
challenge_279_solution_DeanWest-snippet.jpg
Toons
12 - Quasar

My 2 solutions :

 

Spoiler
Toons_0-1627912529355.png

 

Toons_0-1627914788647.png

 

 

binuacs
8 - Asteroid
Spoiler
binuacs_0-1627913300080.png

 

PhilipMannering
14 - Magnetar
14 - Magnetar

My Solution without using Trim attached,

 

Spoiler
PhilipMannering_0-1627913909857.png

 

 And in Python,

 

Spoiler
PhilipMannering_10-1627921390831.png

 

,