Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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
Spoiler
image.png
griffinwelsh
12 - Quasar

My solution

aatalai
14 - Magnetar

C437

Tofel
8 - Asteroid
Spoiler
Challenge 437.JPG

patrick_digan
17 - Castor
17 - Castor
Spoiler
image.png
danbostrom
8 - Asteroid

 

 

BKreutel
5 - Atom

Here is my solution:

 

Spoiler
Spoiler 437.png
ahsanaali
11 - Bolide
Spoiler
427.png

balajilolla2
9 - Comet
Spoiler
Solution Attached

Screenshot 2024-08-12 084651.jpg