Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

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 #437: International T20 Cricket Stats

AYXAcademy
Alteryx
Alteryx

Maveryx_WC_Banner.png

Hi Maveryx,

 

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

 

This challenge was created by William Davis! Thanks, William, for submitting your idea for this Weekly Challenge.

 

You have been tasked with analyzing historical international cricket T20 results to provide the US with some insights.

 

The data available covers every men’s international T20 match from 2005–2022 and was extracted in JSON format. Use your parsing skills to obtain the specific information required to solve the tasks.

 

The data consists of three elements: innings, info, and meta. The field identified with the info element contains all the relevant information.

Hint: Assess the three elements after you parse the data.

 

Your tasks:

  1. How does the United States rank worldwide for total number of wins?
  2. Which team is the most successful?
  3. Who are the six players from the most successful team with the most games played?

 

Need a refresher? Review the following lessons in Academy to gear up:

 

Good luck!

 

AYXAcademy_0-1721836484055.png

 

 

Sources:

https://www.majorleaguecricket.com/

www.cricsheet.org

Kenda
16 - Nebula
16 - Nebula
Révélation
image.png
griffinwelsh
Quasar

My solution

aatalai
Aurore

C437

Tofel
Comète
Révélation
Challenge 437.JPG

patrick_digan
17 - Castor
17 - Castor
Révélation
image.png
danbostrom
Astéroïde

 

 

BKreutel
Atome

Here is my solution:

 

Révélation
Spoiler 437.png
ahsanaali
Bolide
Révélation
427.png

balajilolla2
Boule de feu
Révélation
Solution Attached

Screenshot 2024-08-12 084651.jpg