PSL Overall Other Records (2016-2021)
All Important Overall Records Cracked in PSL
@kaggle.affanamin_psl_overall_other_records_20162021
All Important Overall Records Cracked in PSL
@kaggle.affanamin_psl_overall_other_records_20162021
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.
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
The data was pulled from @ESPNcricinfo
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 ?
CREATE TABLE highestpartnershipsbyruns (
"partners" VARCHAR,
"runs" VARCHAR,
"wkts" VARCHAR,
"team" VARCHAR,
"opposition" VARCHAR,
"ground" VARCHAR,
"matchdate" VARCHAR
);CREATE TABLE highestpartnershipsonwickets (
"wkts" VARCHAR,
"runs" VARCHAR,
"partners" VARCHAR,
"team" VARCHAR,
"opposition" VARCHAR,
"ground" VARCHAR,
"matchdate" VARCHAR
);CREATE TABLE most_catchesbyfielder (
"playername" VARCHAR,
"span" VARCHAR,
"mat" BIGINT,
"inns" BIGINT,
"ct" BIGINT,
"max" BIGINT,
"ct_inn" DOUBLE
);CREATE TABLE most_catchesbyfielderin_oneinns (
"playername" VARCHAR,
"ct" BIGINT,
"inns" BIGINT,
"team" VARCHAR,
"opposition" VARCHAR,
"ground" VARCHAR,
"matchdate" VARCHAR
);CREATE TABLE most_catchesbyfielderin_onepsledi (
"playername" VARCHAR,
"mat" BIGINT,
"inns" BIGINT,
"ct" BIGINT,
"max" BIGINT,
"ct_inn" DOUBLE
);CREATE TABLE mostdismissalsaswk (
"playername" VARCHAR,
"span" VARCHAR,
"mat" BIGINT,
"inns" BIGINT,
"dismissal" BIGINT,
"ct" BIGINT,
"st" BIGINT,
"max_dis_inns" VARCHAR,
"dis_inn" DOUBLE
);CREATE TABLE most_dismissals_in_inningsaswk (
"playername" VARCHAR,
"dis" BIGINT,
"ct" BIGINT,
"st" BIGINT,
"inns" BIGINT,
"team" VARCHAR,
"opposition" VARCHAR,
"venue" VARCHAR,
"matchdate" VARCHAR
);CREATE TABLE most_dismissals_in_one_editionaswk (
"playername" VARCHAR,
"mat" BIGINT,
"inns" BIGINT,
"dis" BIGINT,
"ct" BIGINT,
"st" BIGINT,
"maxdismisalperinns" VARCHAR,
"dis_inn" DOUBLE
);CREATE TABLE mostmatchesplayedascaptaininpsl (
"playername" VARCHAR,
"span" VARCHAR,
"mat" BIGINT,
"won" BIGINT,
"lost" BIGINT,
"tied" BIGINT,
"nr" BIGINT,
"winnig_age" DOUBLE
);CREATE TABLE mostmatchesplayedinpsl (
"players" VARCHAR,
"span" VARCHAR,
"mat" BIGINT,
"runs" BIGINT,
"hs" VARCHAR,
"avebat" DOUBLE,
"n_100" BIGINT -- 100,
"wkts" VARCHAR,
"bbi" VARCHAR,
"avebowl" VARCHAR
);Anyone who has the link will be able to view this.