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 #283: The Summer Paralympic Games 2020

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here.Image Source: https://commons.wikimedia.org/wiki/Category:Paralympic_GamesImage Source: https://commons.wikimedia.org/wiki/Category:Paralympic_Games

 

Let’s dig into the data for the Summer Paralympic Games 2020!

 

This dataset includes a column “RecordID” that corresponds to the names of the athletes, a column for “NOC” for the countries and a “Discipline” column.

 

For this challenge, your job is to:
- List the participating countries and how many athletes for each country
- List of the 5 countries with the most athletes
- List the first 5 countries (alphabetic order) with the least athletes (they are more than 5)
- List all the countries and disciplines by alphabetic order and, add the athlete count and athlete ID

 

Have a good week!

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1630330131313.png

 

Aaron_Harter
11 - Bolide

Have a great week!

Spoiler
0.PNG
PhilipMannering
16 - Nebula
16 - Nebula
Spoiler
PhilipMannering_0-1630330254735.png

 

 

Python Tool

Spoiler
PhilipMannering_0-1630332041424.png

 

 

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission

Blake
12 - Quasar

Love the Summarize Tool!

 

Spoiler
283.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1630330774874.png

 

DeanWest
9 - Comet

Fun and easy challenge to kick off the week! 

 

Spoiler
challenge_283_solution_DeanWest-snippet.png
Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1630331131480.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
283.jpg