Challenge #390: Top US Cricket Players

AYXAcademy

Hi Maveryx,

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

Cricket Fanalytics-Social tile - 1200x628_OD (2).png

Are you fascinated by the interplay of strategy, skill, and statistics in sports?

Does the idea of discovering talent in the realm of cricket thrill you?

If you are nodding your head, then gear up!

Challenge Objective: Assemble Your Dream US Cricket Team

Your mission—should you choose to accept it—is to identify the crème de la crème of US run scorers in cricket. You will be handed a treasure trove of international cricket match data, and your goal is to sift through the numbers to pinpoint the Top 5 US run scorers who would be the perfect fit for your dream team.

Bonus: Watch an on-demand webinar featuring Shane Watson, Head Coach of the San Francisco Major League Cricket team, the Unicorns, as he talks about how analytics optimizes strategy and performance.

Source: https://www.kaggle.com/datasets/paritosh712/cricket-every-single-t20i-international-innings

Challenge 390_Start File.yxzp

Challenge 390_Solution File.yxzp

Data Preparation

Core

Basic

Accepted answers

All comments

philipmannering

Solution attached.

Spoiler

MilindG

Solution attached

Solution 390.yxmd

benjimoser

My Solution

Spoiler

Challenge 390_Benji.yxzp

binu_acs

Spoiler

Challenge 390_Solution_BV.yxmd

RolandSchubert

Spoiler

Challenge 390_solution_rsc.yxmd

nhardin

Spoiler

Challenge 390_Solution_NH.yxmd

AkimasaKajitani

My Solution!

Designer Desktop

Spoiler

Designer Cloud

Spoiler

Trifacta Classic

Spoiler

I don't know why are "*" added after number at Runs field ...

Challenge 390_Start File_AK.yxzp

Kenda

Spoiler

Challenge 390_Start File.yxmd

MilindG

@AkimasaKajitani I don't know why are "*" added after number at Runs field ...

- Its because the batter remained not out at the end of the game.

philipmannering

Solution in the Python Tool,

Spoiler

ggruccioAYX

Simple and Fun!!! Removing upload and re-positing from my legacy account that has all my progress.

ggruccio

Spoiler

Simple and Fun!!!

Challenge 390_gg_finish.yxzp

ravi061

My Solution for C#390

Spoiler

Challenge 390_ravi.yxmd

Sebastian_Chaieb2

My solution

Spoiler

Challenge 390_Solution_SC.yxzp

NicoJ

Spoiler

Challenge_390_NJ.yxzp

JamesCharnley

Spoiler

Good sport

Challenge 390 Zipped.yxzp

robbinrv

Great one for cloud again. Did find out that if you force string fields into numeric ones that contain special characters such as * behind the number it won't work (whereas it does in designer if it's as a prefix).