Dataset: Pakistan Super League (PSL) Ultimate Ball-by-Ball

About this Dataset

Pakistan Super League (PSL) Ultimate Ball-by-Ball

This dataset was accessed from an online cricketing data website. Originally in JSON format, the author(me) had to undergo rigorous and exhaustive data transformation and cleaning to make it Pandas-usable. This is a highly de-normalized data set, deliberately left so, so that users can make and choose their own aggregations and make it suitable to their problems.

I'd love to see analysts, beginners and experts alike, dive into this data and make it a precursor for wonderful projects and dashboards. Additionally, this data could be subjected to ML model engineering (which I am up to currently). Define your problems, choose your algorithms, train your data, and finally show us your work here.

International, CPL, BPL, BBL, T20Blast datasets are in the pipeline. Give this dataset an upvote so that I can know if there is a need for more cricketing data. Goodluck!

Tables

Psl

@kaggle.ijazzia_pakistan_super_league_psl_ultimate_ball_by_ball.psl

721.37 KB
59560 rows
55 columns


CREATE TABLE psl (
  "unnamed_0" BIGINT,
  "team" VARCHAR,
  "over_number" BIGINT,
  "ball_number" BIGINT,
  "batter" VARCHAR,
  "bowler" VARCHAR,
  "non_striker" VARCHAR,
  "batter_runs" BIGINT,
  "runs_extras" BIGINT,
  "byes" BIGINT,
  "legbyes" BIGINT,
  "noballs" BIGINT,
  "penalty" BIGINT,
  "wides" BIGINT,
  "nonboundry_runs" VARCHAR,
  "total_runs" BIGINT,
  "wickets" BIGINT,
  "wicket_type" VARCHAR,
  "fielders_for_wicket" VARCHAR,
  "player_out" VARCHAR,
  "review_by" VARCHAR,
  "batter_review" VARCHAR,
  "review_decision" VARCHAR,
  "review_umpire" VARCHAR,
  "review_type" VARCHAR,
  "review_umpire_call" BIGINT,
  "target_runs" DOUBLE,
  "target_overs" DOUBLE,
  "dates" TIMESTAMP,
  "match_type" VARCHAR,
  "gender" VARCHAR,
  "overs" BIGINT,
  "venue" VARCHAR,
  "season" VARCHAR,
  "event_match_number" DOUBLE,
  "toss_decision" VARCHAR,
  "official_umpires" VARCHAR,
  "opposition" VARCHAR,
  "team_type" VARCHAR,
  "team_a_players" VARCHAR,
  "team_b_players" VARCHAR,
  "toss_winner" VARCHAR,
  "winner" VARCHAR,
  "motm" VARCHAR,
  "outcome_by_runs" BIGINT,
  "outcome_by_wickets" BIGINT,
  "replacement" BIGINT,
  "replacement_in" VARCHAR,
  "replacement_out" DOUBLE,
  "replacement_reason" VARCHAR,
  "replacement_role" VARCHAR,
  "sub_in" VARCHAR,
  "sub_out" VARCHAR,
  "sub_team" VARCHAR,
  "sub_reason" VARCHAR
);