IPL Cricket Analysis Dataset
Cleaned ESPN Cricket Dataset for Game Analysis
@kaggle.diishasiing_cricket_analysis_dataset
Cleaned ESPN Cricket Dataset for Game Analysis
@kaggle.diishasiing_cricket_analysis_dataset
CREATE TABLE df_batting (
"match" VARCHAR,
"teaminnings" VARCHAR,
"battingpos" BIGINT,
"batsmanname" VARCHAR,
"runs" BIGINT,
"balls" BIGINT,
"n_4s" BIGINT,
"n_6s" BIGINT,
"sr" VARCHAR,
"out_not_out" VARCHAR,
"match_id" VARCHAR
);
CREATE TABLE df_bowling (
"match" VARCHAR,
"bowlingteam" VARCHAR,
"bowlername" VARCHAR,
"overs" DOUBLE,
"maiden" BIGINT,
"runs" BIGINT,
"wickets" BIGINT,
"economy" DOUBLE,
"n_0s" BIGINT,
"n_4s" BIGINT,
"n_6s" BIGINT,
"wides" BIGINT,
"noballs" BIGINT,
"match_id" VARCHAR
);
CREATE TABLE df_match (
"team1" VARCHAR,
"team2" VARCHAR,
"winner" VARCHAR,
"margin" VARCHAR,
"ground" VARCHAR,
"matchdate" TIMESTAMP,
"match_id" VARCHAR
);
CREATE TABLE df_players (
"name" VARCHAR,
"team" VARCHAR,
"image" VARCHAR,
"battingstyle" VARCHAR,
"bowlingstyle" VARCHAR,
"playingrole" VARCHAR,
"description" VARCHAR
);
Anyone who has the link will be able to view this.