Dataset: PSL Overall Other Records (2016-2021)

About this Dataset

PSL Overall Other Records (2016-2021)

Context

PSL 2021 has resumed , Lets showcase what overall 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 Overall Performances in PSL

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

Highest partnership records by runs in PSL (2016-2021)
Highest partnership records on a given wickets in PSL (2016-2021)
Most Dismissals as a wicket keeper in PSL (2016-2021)
Most Dismissals as a wicket keeper in one innings in PSL(2016-2021)
Most Dismissals as a wicket keeper in one PSL edition (2016-2021)
Most matches played by any individual in PSL (2016-2021)
Most matches played as a captain by any individual in PSL (2016-2021)
Most catches held by any individual fielder in PSL (2016-2021)
Most catches held by any individual fielder in one inns in PSL (2016-2021)
Most catches held by any individual fielder in one PSL edition (2016-2021)

Size: 13.1 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 wicket keeper batsman in whole PSL?
• Who is the best fielder batsman in whole PSL?
• Who frequently involved in highest partnerships in PSL?
• Find any hidden patterns that are counter-intuitive for a layman
• Can we predict after what no. of innings Mohammad Nawaz can get 3+ catches in PSL ?

Tables

Highestpartnershipsbyruns

@kaggle.affanamin_psl_overall_other_records_20162021.highestpartnershipsbyruns

5.87 KB
23 rows
7 columns


CREATE TABLE highestpartnershipsbyruns (
  "partners" VARCHAR,
  "runs" VARCHAR,
  "wkts" VARCHAR,
  "team" VARCHAR,
  "opposition" VARCHAR,
  "ground" VARCHAR,
  "matchdate" VARCHAR
);

Highestpartnershipsonwickets

@kaggle.affanamin_psl_overall_other_records_20162021.highestpartnershipsonwickets

5.29 KB
6 rows
7 columns


CREATE TABLE highestpartnershipsonwickets (
  "wkts" VARCHAR,
  "runs" VARCHAR,
  "partners" VARCHAR,
  "team" VARCHAR,
  "opposition" VARCHAR,
  "ground" VARCHAR,
  "matchdate" VARCHAR
);

Mostdismissalsaswk

@kaggle.affanamin_psl_overall_other_records_20162021.mostdismissalsaswk

7.37 KB
28 rows
9 columns


CREATE TABLE mostdismissalsaswk (
  "playername" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "dismissal" BIGINT,
  "ct" BIGINT,
  "st" BIGINT,
  "max_dis_inns" VARCHAR,
  "dis_inn" DOUBLE
);

Mostmatchesplayedascaptaininpsl

@kaggle.affanamin_psl_overall_other_records_20162021.mostmatchesplayedascaptaininpsl

6.52 KB
26 rows
8 columns


CREATE TABLE mostmatchesplayedascaptaininpsl (
  "playername" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "won" BIGINT,
  "lost" BIGINT,
  "tied" BIGINT,
  "nr" BIGINT,
  "winnig_age" DOUBLE
);

Mostmatchesplayedinpsl

@kaggle.affanamin_psl_overall_other_records_20162021.mostmatchesplayedinpsl

8.8 KB
50 rows
10 columns


CREATE TABLE mostmatchesplayedinpsl (
  "players" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "avebat" DOUBLE,
  "n_100" BIGINT,
  "wkts" VARCHAR,
  "bbi" VARCHAR,
  "avebowl" VARCHAR
);

Most Catchesbyfielder

@kaggle.affanamin_psl_overall_other_records_20162021.most_catchesbyfielder

6.46 KB
45 rows
7 columns


CREATE TABLE most_catchesbyfielder (
  "playername" VARCHAR,
  "span" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "ct" BIGINT,
  "max" BIGINT,
  "ct_inn" DOUBLE
);

Most Catchesbyfielderin Oneinns

@kaggle.affanamin_psl_overall_other_records_20162021.most_catchesbyfielderin_oneinns

5.39 KB
10 rows
7 columns


CREATE TABLE most_catchesbyfielderin_oneinns (
  "playername" VARCHAR,
  "ct" BIGINT,
  "inns" BIGINT,
  "team" VARCHAR,
  "opposition" VARCHAR,
  "ground" VARCHAR,
  "matchdate" VARCHAR
);

Most Catchesbyfielderin Onepsledi

@kaggle.affanamin_psl_overall_other_records_20162021.most_catchesbyfielderin_onepsledi

5.17 KB
36 rows
6 columns


CREATE TABLE most_catchesbyfielderin_onepsledi (
  "playername" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "ct" BIGINT,
  "max" BIGINT,
  "ct_inn" DOUBLE
);

Most Dismissals In Inningsaswk

@kaggle.affanamin_psl_overall_other_records_20162021.most_dismissals_in_inningsaswk

6.51 KB
7 rows
9 columns


CREATE TABLE most_dismissals_in_inningsaswk (
  "playername" VARCHAR,
  "dis" BIGINT,
  "ct" BIGINT,
  "st" BIGINT,
  "inns" BIGINT,
  "team" VARCHAR,
  "opposition" VARCHAR,
  "venue" VARCHAR,
  "matchdate" VARCHAR
);

Most Dismissals In One Editionaswk

@kaggle.affanamin_psl_overall_other_records_20162021.most_dismissals_in_one_editionaswk

6.73 KB
47 rows
8 columns


CREATE TABLE most_dismissals_in_one_editionaswk (
  "playername" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "dis" BIGINT,
  "ct" BIGINT,
  "st" BIGINT,
  "maxdismisalperinns" VARCHAR,
  "dis_inn" DOUBLE
);