Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

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

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
22 - Nova
22 - Nova

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
16 - Nebula
16 - Nebula

My solution

Spoiler
279.jpg
Kenda
16 - Nebula
16 - Nebula
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
20 - Arcturus
Spoiler
binuacs_0-1627913300080.png

 

PhilipMannering
16 - Nebula
16 - Nebula

My Solution without using Trim attached,

 

Spoiler
PhilipMannering_0-1627913909857.png

 

 And in Python,

 

Spoiler
PhilipMannering_10-1627921390831.png

 

,