Challenge #437: International T20 Cricket Stats

[shiva_ganesh_18]

Hi William Davis,

Thank you for this interesting challenge! While working on the task to identify the "most successful team," I was curious about the criteria used for success. The task seems to focus on total wins, but wouldn’t considering win percentage give a more balanced view?

For instance, teams that have played fewer matches but have a high success rate might be overlooked if we only look at total wins. What are your thoughts on incorporating win percentage into the analysis?

Looking forward to your perspective!

Best regards,
K Shiva Ganesh

[shiva_ganesh_18]

My unique approach for Task 2 & 3:
Instead of just looking at total wins, I filtered teams with 100+ matches and calculated success ratio (Wins / Matches Played). This revealed India as the most successful team. Then, I analyzed their top six players by games played to complete the insights!

Excited to share this workflow and insights! How would you tackle it differently?

#Alteryx #CricketAnalytics #DataInsights #ProblemSolving

[PhilipMannering]

Solution attached.

Spoiler

[mgaronson]

Spoiler

 Really had to think through to make efficient.

[GGGDias]

Forced myself to figure out the regex replace to extract country name.  BIG shout out to  PhilipMannering, the REGEX wizard  who is my inspiration to becomre more proficient in RegEx!!  Thanks Phillip! 

By the way, I'm sorry Pakistan fans  but Isle of Man is the most successful team with a winning rate of 80%.  Pakistan just had more matches played - 205 against India's 183.  Easy to win more when you play more.

Spoiler

[Sebastian_Chaieb2]

Cool task with JSON file

Spoiler

 

[JBevan89]

solution attached

[shiva_ganesh_18]

Hi @GGGDias,

Great point about the Isle of Man! I’ve shared my thoughts on this in my response, particularly around considering win percentage for a more balanced view. Would love to hear your thoughts on it!

Best regards,
K Shiva Ganesh

 

[GGGDias]

Hey @shiva_ganesh_18 

Agreed, but at the same time 100 is an arbitrary number, and Afghanistan with 99 matches has a 65.7 Avg Win, beating India's 64.5 and Pakista's 61% win averages.

It really boils down to how you want to characterize success.  Win% is a great indicator but one could also use how much money a team makes. 

Suppose each team loses/earns 10$ depending whether it lost/won the match.  In such a case, India would be number 1 (most profitable), but Uganda would still have a higher Win%.

In the end, the correct parameter is Win% but if all teams didn't have the same number of opportunities, then the results are skewed.

Country TotalMatchesPlayed Right_Country TotalWins Win% Income Expenses Profit
India 183 India 118 64.5 1180 650 530
Pakistan 205 Pakistan 125 61.0 1250 800 450
Afghanistan 99 Afghanistan 65 65.7 650 340 310
South Africa 159 South Africa 91 57.2 910 680 230
Uganda 37 Uganda 26 70.3 260 110 150

[shiva_ganesh_18]

Hey GGGDias,

Thanks for the detailed breakdown! You're right that how we define success can vary based on the metric we choose. Win percentage is a great indicator of performance consistency, but incorporating financial metrics, as you suggested, adds another dimension to understanding success.

Your example of India being the most profitable while Uganda has a higher win percentage really highlights how different perspectives can lead to different rankings. It's true that unequal opportunities (total matches played) can skew results, making it tricky to directly compare teams solely based on Win%.

Ultimately, combining Win% with other factors like profitability might provide a more comprehensive view of a team's overall success. What do you think about integrating multiple metrics for a more holistic approach?

Best regards,
K Shiva Ganesh