Dataset: IPL 2008 To 2019

About this Dataset

IPL 2008 To 2019

Context

This dataset has been inspired by the ongoing ICC World Cup Cricket tournament. I wondered about how much IPL has come to mean to the world of cricket and thought of analyzing it.

Content

IPL Data for 12 seasons from the inaugural 2008 season to the recent 2019 season have been downloaded from cricsheet.org and the YAML files have been wrangled to get 2 csv files. first file shows the summary of the matches - i.e. when was it played, who won etc. second file has ball-by-ball details providing a wealth of data.

Acknowledgements

Raw data has been obtained from cricsheet
The IPL wiki page is a treasure trove of info and cricinfo is the goto page for all things cricket

Inspiration

How would one measure contribution of players objectively?
Can one predict results of the game based on various underlying metrics?

Tables

Ball By Ball Details

@kaggle.ravijee_ipl_2008_to_2019.ball_by_ball_details

949.39 KB
178949 rows
41 columns


CREATE TABLE ball_by_ball_details (
  "unnamed_0" BIGINT,
  "batsman" VARCHAR,
  "batsman_runs" DOUBLE,
  "batting_team" VARCHAR,
  "bowler" VARCHAR,
  "byes" DOUBLE,
  "extras_runs" DOUBLE,
  "fielders" VARCHAR,
  "kind" VARCHAR,
  "legbyes" DOUBLE,
  "inning" VARCHAR,
  "delivery" DOUBLE,
  "match_id" BIGINT,
  "noballs" DOUBLE,
  "non_striker" VARCHAR,
  "player_out" VARCHAR,
  "total" DOUBLE,
  "wides" DOUBLE,
  "non_boundary" DOUBLE,
  "penalty" DOUBLE,
  "city" VARCHAR,
  "competition" VARCHAR,
  "decision" VARCHAR,
  "eliminator" VARCHAR,
  "gender" VARCHAR,
  "match_type" VARCHAR,
  "method" VARCHAR,
  "neutral_venue" DOUBLE,
  "n__of_overs" BIGINT,
  "player_of_match" VARCHAR,
  "result" VARCHAR,
  "teams" VARCHAR,
  "umpires" VARCHAR,
  "venue" VARCHAR,
  "winner" VARCHAR,
  "winner_toss" VARCHAR,
  "outcome_by_runs" DOUBLE,
  "outcome_by_wickets" DOUBLE,
  "match_date" TIMESTAMP,
  "season" BIGINT,
  "over" BIGINT
);

Ipl Summary

@kaggle.ravijee_ipl_2008_to_2019.ipl_summary

37.99 KB
756 rows
21 columns


CREATE TABLE ipl_summary (
  "match_id" BIGINT,
  "city" VARCHAR,
  "competition" VARCHAR,
  "decision" VARCHAR,
  "eliminator" VARCHAR,
  "gender" VARCHAR,
  "match_type" VARCHAR,
  "method" VARCHAR,
  "neutral_venue" DOUBLE,
  "n__of_overs" BIGINT,
  "player_of_match" VARCHAR,
  "result" VARCHAR,
  "teams" VARCHAR,
  "umpires" VARCHAR,
  "venue" VARCHAR,
  "winner" VARCHAR,
  "winner_toss" VARCHAR,
  "outcome_by_runs" DOUBLE,
  "outcome_by_wickets" DOUBLE,
  "match_date" TIMESTAMP,
  "season" BIGINT
);