Analyzing T20 World Cup Data for Earth

Sep 20, 2024

T20 Cricket World Cup Data Analytics Series

Overview

  • England claimed victory over Pakistan in recent T20 World Cup.
  • Project aims to analyze T20 World Cup data through data scraping, cleaning, transformation using Pandas, and dashboard building in Power BI.

Project Steps

  1. Data Scraping
    • Scraping data from ESPN Cricinfo website.
    • Using BrightData for web scraping with proxy networks.
  2. Data Cleaning and Transformation
    • Utilizing Pandas for data manipulation.
    • Transforming JSON data into a CSV format for Power BI.
  3. Dashboard Creation
    • Building interactive dashboards in Power BI.

Problem Statement

  • Planet Spota challenges Earth to a cricket match.
  • Objective: Select the best 11 players based on T20 World Cup data to save Earth.

Special Stakeholders

  • Tony Sharma: Senior data analyst and cricket expert leading the project.
  • Nick Puri: Assembled special agents to work on data analytics project.

Player Selection Strategy

  • Openers:
    • Focus on power hitters.
    • Parameters: batting average, strike rate, boundary percentage.
  • Middle Order:
    • Anchors who can shift gears.
    • Parameters: batting average, balls faced.
  • Finishers:
    • Players who can stabilize innings and hit aggressively.
  • All-rounders:
    • Balance between batting and bowling capabilities.
  • Fast Bowlers:
    • Focus on wicket-taking ability and economy rates.

Key Data Collection Points

  • Detailed match results.
  • Batting and bowling scorecards.
  • Player-specific information.

Technical Tools

  • BrightData: For web scraping.
  • Pandas: For data cleaning and transformation.
  • Power BI: For data visualization and dashboard building.

Dashboard Features

  • Filters for player categories: power hitters, anchors, fast bowlers.
  • Statistics: runs, strike rate, batting average, and trends.
  • Final selection of best players based on statistical analysis.

Exercise Challenge

  • Update tooltip information for players.
  • Revise dashboard design and visual appeal.
  • Add additional insights and statistics.
  • Share project on LinkedIn for potential rewards.

Conclusion

  • Participants gain practical experience in data analytics, web scraping, and dashboarding through real-world cricket data analysis.