Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more 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 #355: Analyze the Olympic Games

AYXAcademy
Alteryx
Alteryx

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

Olympc.png

 

To solve this week’s challenge, use Designer Desktop or Designer Cloud.

This challenge comes to us from @randall_king 

 

Haven’t heard about Designer Cloud yet? Watch a demo.
https://www.alteryx.com/products/designer-cloud-trifacta

 

Do you often find that you have to clean data to get it in a readable and usable format?

In this weekly challenge, you need to clean data and organize it into a format that is more suitable for analysis.

The dataset contains information about the Olympic Games:
1. Participating Country
2. Country Code
3. Total Summer Games
4. Total Gold Medals Summer
5. Total Silver Medals Summer
6. Total Bronze Medals Summer
7. Total Medals Combined Summer
8. Total Winter Games
9. Total Gold Medals Winter
10. Total Silver Medals Winter
11. Total Bronze Medals Winter
12. Total Medals Combined Winter
13. Total Combined Games
14. Total Gold Medals Combined Games
15. Total Silver Medals Combined Games
16. Total Bronze Medals Combined Games
17. Total All Medals Combined Games

 

However, the data is all compiled in one field.

 

Your goal is to:
- Parse the data in columns.
- Clean out the special characters for the Country Code (for example, update “(AFG)” to “AFG”).
- Name the new columns (as shown above).


Data Source: www.kaggle.com/datasets/rushikeshlavate/olympic-games-medal-datasetfrom-1896-to-2018

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1674486875905.png

 

alexnajm
16 - Nebula
16 - Nebula

Some nice RegEx to solve this 😊

Spoiler
Challenge 355.PNG
Taylor_S
8 - Asteroid

Nice warm-up to start the week! 

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1674488334814.png

 

benjimoser
9 - Comet

My Solution (but I actually don't like that the column headers are manually renamed)

Spoiler
benjimoser_0-1674489134979.png

 

binuacs
20 - Arcturus
Spoiler
binuacs_0-1674489485212.png

 

Watermark
12 - Quasar
12 - Quasar

Little bit lazy with 3 text to columns instead of a Regex ... but it was quick

 

Spoiler
MT_Solution_355.jpg

Flo_P
8 - Asteroid
Spoiler
Another learning experience
Flo_P_0-1674491258165.png

 

RWvanLeeuwen
11 - Bolide

Here's my approach

Spoiler
the field name from the input was parsed and cleaned to yield unique field names that I leverage from the dynamic rename going forwardthe field name from the input was parsed and cleaned to yield unique field names that I leverage from the dynamic rename going forward