Name: PSL Batting Records (2016-2021)
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

PSL Batting Records (2016-2021)

Context

PSL 2021 resuming shortly, Lets showcase what old records were made during the recent seasons of IPL and predict (through the data) more records to crack in this second leg of PSL 2021.

Content

Geography: Pakistan

Time period: 2016 – 2021

Unit of analysis: Performance of Batsman in PSL

This dataset consists of six separate CSV files (having data from 2016-2021), which are as follows:

Overall Highest Batting average of different batsman in PSL (2016-2021)
Batsman having highest Strike Rate in PSL (2016-2021)
List of all batsman pull a century in PSL (2016-2021)
Most half centuries by a batsman in PSL (2016-2021)
Most runs scored by a batsman in PSL (2016-2021)
Most runs scored in an innings in PSL (2016-2021)

Size: 17 KB

File Type: CSVs

Acknowledgements

The data was pulled from @ESPNcricinfo

Inspiration

I’d like to call the attention of my fellow Kagglers to use Machine Learning and Data Sciences to help me explore these ideas:

• Who is the best-avg player in whole PSL?
• Visualize boundary hitting frequency
• Visualize Six hitting frequency
• Find a correlation between venue and runs with toss winners
• Find a correlation between batting averages, strike rate and consistency
• Find any hidden patterns that are counter-intuitive for a layman
• Can we predict after what no. of innings Baber Azam can hit 50 in PSL ?

Tables

Highestbattingavginpsl

@kaggle.affanamin_psl_batting_records_20162021.highestbattingavginpsl

13.25 kB
50 rows
15 columns

CREATE TABLE highestbattingavginpsl (
  "playername" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "not_outs" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "avg" DOUBLE,
  "balls_faced" BIGINT,
  "sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_0s" BIGINT  -- 0s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Higheststrikerateinpsl

@kaggle.affanamin_psl_batting_records_20162021.higheststrikerateinpsl

13.34 kB
50 rows
15 columns

CREATE TABLE higheststrikerateinpsl (
  "playername" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "not_outs" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "avg" DOUBLE,
  "balls_faced" BIGINT,
  "sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_0s" BIGINT  -- 0s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Listofhundredsinpsl

@kaggle.affanamin_psl_batting_records_20162021.listofhundredsinpsl

7.48 kB
9 rows
10 columns

CREATE TABLE listofhundredsinpsl (
  "playername" VARCHAR,
  "runs" VARCHAR,
  "ballsfaced" BIGINT,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s,
  "sr" DOUBLE,
  "team" VARCHAR,
  "opposition" VARCHAR,
  "venue" VARCHAR,
  "matchdate" VARCHAR
);

Most50runsinpsl

@kaggle.affanamin_psl_batting_records_20162021.most50runsinpsl

13.79 kB
48 rows
16 columns

CREATE TABLE most50runsinpsl (
  "playername" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "not_outs" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "avg" DOUBLE,
  "balls_faced" BIGINT,
  "sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_50" BIGINT  -- 50+,
  "n_0s" BIGINT  -- 0s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Mostrunsbybatsmaninpsl

@kaggle.affanamin_psl_batting_records_20162021.mostrunsbybatsmaninpsl

13.22 kB
50 rows
15 columns

CREATE TABLE mostrunsbybatsmaninpsl (
  "playername" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "not_outs" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "avg" DOUBLE,
  "balls_faced" BIGINT,
  "sr" DOUBLE,
  "n_100s" BIGINT  -- 100s,
  "n_50s" BIGINT  -- 50s,
  "n_0s" BIGINT  -- 0s,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s
);

Mostrunsininnsinpsl

@kaggle.affanamin_psl_batting_records_20162021.mostrunsininnsinpsl

8.67 kB
47 rows
10 columns

CREATE TABLE mostrunsininnsinpsl (
  "playername" VARCHAR,
  "runs" VARCHAR,
  "ballsfaced" BIGINT,
  "n_4s" BIGINT  -- 4s,
  "n_6s" BIGINT  -- 6s,
  "sr" DOUBLE,
  "team" VARCHAR,
  "opposition" VARCHAR,
  "venue" VARCHAR,
  "matchdate" VARCHAR
);