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

About this Dataset

PSL Bowling Records (2016-2021)

Context

PSL 2021 resuming from today, 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 Bowlers in PSL

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

All Bowlers bowling averages in PSL (2016-2021)
All Bowlers economy rates in PSL (2016-2021)
Most 4plus wickets getters in PSL (2016-2021)
Most 5plus wickets getters in PSL (2016-2021)
Most runs conceded by bowlers in PSL (2016-2021)
Most wickets taken by bowlers in PSL (2016-2021)
Most wickets taken in one season of PSL (2016-2021)
Strike Rate of different bowlers in PSL (2016-2021)

Size: 21.83 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 bowler in whole PSL?
• Visualize wickets getting frequency
• Find a correlation between venue and wickets with toss winners
• Find a correlation between bowling averages, strike rate and consistency
• Find any hidden patterns that are counter-intuitive for a layman
• Can we predict after what no. of innings Wahab Riaz or Muhammad Amir can get 3+ wickets in PSL ?

Tables

Bowlingavg

@kaggle.affanamin_psl_bowling_records_20162021.bowlingavg

11.44 kB
48 rows
13 columns

CREATE TABLE bowlingavg (
  "playername" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "overs" DOUBLE,
  "maiden" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "ave" DOUBLE,
  "economy" DOUBLE,
  "sr" DOUBLE,
  "n_4s" BIGINT  -- 4s,
  "n_5s" BIGINT  -- 5S
);

Economyrareinbowling

@kaggle.affanamin_psl_bowling_records_20162021.economyrareinbowling

11.44 kB
48 rows
13 columns

CREATE TABLE economyrareinbowling (
  "playername" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "overs" DOUBLE,
  "maiden" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "ave" DOUBLE,
  "economy" DOUBLE,
  "sr" DOUBLE,
  "n_4s" BIGINT  -- 4s,
  "n_5s" BIGINT  -- 5S
);

Most4pluswicketsinpsl

@kaggle.affanamin_psl_bowling_records_20162021.most4pluswicketsinpsl

11.26 kB
29 rows
14 columns

CREATE TABLE most4pluswicketsinpsl (
  "playername" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "overs" DOUBLE,
  "maiden" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "ave" DOUBLE,
  "economy" DOUBLE,
  "sr" DOUBLE,
  "n_4s" BIGINT  -- 4s,
  "n_5s" BIGINT  -- 5S,
  "n_4" BIGINT  -- 4+
);

Most5pluswicketsinpsl

@kaggle.affanamin_psl_bowling_records_20162021.most5pluswicketsinpsl

10.63 kB
29 rows
13 columns

CREATE TABLE most5pluswicketsinpsl (
  "playername" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "overs" DOUBLE,
  "maiden" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "ave" DOUBLE,
  "economy" DOUBLE,
  "sr" DOUBLE,
  "n_4s" BIGINT  -- 4s,
  "n_5s" BIGINT  -- 5S
);

Mostrunsconceededinpsl

@kaggle.affanamin_psl_bowling_records_20162021.mostrunsconceededinpsl

8.19 kB
46 rows
10 columns

CREATE TABLE mostrunsconceededinpsl (
  "playername" VARCHAR,
  "overs" DOUBLE,
  "mdns" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "econ" DOUBLE,
  "team" VARCHAR,
  "opposition" VARCHAR,
  "venue" VARCHAR,
  "matchdate" VARCHAR
);

Mostwicketsinoneseason

@kaggle.affanamin_psl_bowling_records_20162021.mostwicketsinoneseason

10.01 kB
29 rows
12 columns

CREATE TABLE mostwicketsinoneseason (
  "playername" VARCHAR,
  "mat" VARCHAR,
  "overs" BIGINT,
  "maiden" DOUBLE,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" BIGINT,
  "ave" VARCHAR,
  "economy" DOUBLE,
  "sr" DOUBLE,
  "n_4s" DOUBLE  -- 4s,
  "n_5s" BIGINT  -- 5S
);

Mostwicketsinpsl

@kaggle.affanamin_psl_bowling_records_20162021.mostwicketsinpsl

12.44 kB
50 rows
14 columns

CREATE TABLE mostwicketsinpsl (
  "playername" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "oversbowled" DOUBLE,
  "maidens" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "avg" DOUBLE,
  "econ" DOUBLE,
  "sr" DOUBLE,
  "n_4s" BIGINT  -- 4s,
  "n_5s" BIGINT  -- 5s
);

Strikerateinbowling

@kaggle.affanamin_psl_bowling_records_20162021.strikerateinbowling

11.44 kB
48 rows
13 columns

CREATE TABLE strikerateinbowling (
  "playername" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "overs" DOUBLE,
  "maiden" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "ave" DOUBLE,
  "economy" DOUBLE,
  "sr" DOUBLE,
  "n_4s" BIGINT  -- 4s,
  "n_5s" BIGINT  -- 5S
);