IPL 2020 Points Table Prediction

Predict the points table of IPL 2020 season using the IPL 2008 to 2019 data

@kaggle.kaushiksuresh147_ipl_2020_data

Table List

1 table(26.12 KB)

Ipl2020 Match Data

@kaggle.kaushiksuresh147_ipl_2020_data.ipl2020_match_data

26.12 KB
16 rows
36 columns

match_id Match Id	match_date Match Date	match_day Match Day	match_stadium Match Stadium	location_id Location Id	match_location Match Location	season Season	team1 Team1	team2 Team2	toss_won Toss Won	toss_decision Toss Decision	result Result	winner Winner	team1_score Team1 Score	team2_score Team2 Score	team1_wickets Team1 Wickets	team2_wickets Team2 Wickets	win_by_super_over_run Win By Super Over Run	win_by_super_over_wicket Win By Super Over Wicket	win_by_runs Win By Runs	win_by_wickets Win By Wickets	player_of_the_match Player Of The Match	total_overs Total Overs	team1_bat_overs Team1 Bat Overs	team2_bat_overs Team2 Bat Overs	total_sixes Total Sixes	team1_sixes Team1 Sixes	team2_sixes Team2 Sixes	total_fours Total Fours	team1_fours Team1 Fours	team2_fours Team2 Fours	total_extras_given Total Extras Given	team1_extras_runs Team1 Extras Runs	team2_extras_runs Team2 Extras Runs	umpires Umpires	match_refereee Match Refereee
1	19-09-2020	Saturday	SHEIKH ZAYED STADIUM	Abu	ABU DHABI	2020	Mumbai Indians	Chennai Super Kings	Chennai Super Kings	Field	normal	Chennai Super Kings	162	166	9	5	No	No		5	Ambati Rayudu	39.2	20	19.2	9	4	5	31	15	16	9	5	4	Virender Sharma (IND), Chris Gaffaney (NZ) and Sundaram Ravi (IND)	Manu Nayyar (IND)
2	20-09-2020	Sunday	DUBAI INTERNATIONAL CRICKET STADIUM	Du	DUBAI	2020	Delhi Capitals	Kings XI Punjab	Kings XI Punjab	Field	Tie	Delhi Capitals	157	157	8	8	0	2			Marcus Stoinis	40	20	20	12	6	6	25	13	12	17	9	8	Nitin Menon (IND), Anil Chaudhary (IND) and Paul Reiffel (AUS)	Javagal Srinath (IND)
3	21-09-2020	Monday	DUBAI INTERNATIONAL CRICKET STADIUM	Du	DUBAI	2020	Royal Challengers Bangalore	Sunrisers Hyderabad	Sunrisers Hyderabad	Field	normal	Royal Challengers Bangalore	163	153	5	10	No	No	10		Yuzvendra Chahal	39.4	20	19.4	7	4	3	27	13	14	20	5	15	Nitin Menon (IND), Anil Dandekar (IND) and Anil Chaudhary (IND)	Prakash Bhatt (IND)
4	22-09-2020	Tuesday	SHARJAH CRICKET STADIUM,	sha	SHARJAH	2020	Rajasthan Royals	Chennai Super Kings	Chennai Super Kings	Field	normal	Rajasthan Royals	216	200	7	6	No	No	16		Sanju Samson	40	20	20	33	17	16	18	9	9	14	9	5	Chettithody Shamshuddin (IND), Vineet Kulkarni (IND) and KN Ananthapadmanabhan (IND)	Vengalil Narayanan Kutty (IND)
5	23-09-2020	Wednesday	SHEIKH ZAYED STADIUM	Abu	ABU DHABI	2020	Mumbai Indians	Kolkata Knight Riders	Kolkata Knight Riders	Field	normal	Mumbai Indians	195	146	5	9	No	No	49		Rohit Sharma	40	20	20	16	9	7	26	13	13	19	5	14	Chris Gaffaney (NZ), Sundaram Ravi (IND) and Virender Sharma (IND)	Manu Nayyar (IND)
6	24-09-2020	Thursday	DUBAI INTERNATIONAL CRICKET STADIUM	Du	DUBAI	2020	Kings XI Punjab	Royal Challengers Bangalore	Royal Challengers Bangalore	Field	normal	Kings XI Punjab	206	109	3	10	No	No	97		KL Rahul	37	20	17	10	7	3	31	21	10	20	11	9	Paul Reiffel (AUS), Anil Chaudhary (IND) and Nitin Menon (IND)	Javagal Srinath (IND)
7	25-09-2020	Friday	DUBAI INTERNATIONAL CRICKET STADIUM	Du	DUBAI	2020	Delhi Capitals	Chennai Super Kings	Chennai Super Kings	Field	normal	Delhi Capitals	175	131	3	7	No	No	44		Prithvi Shaw	40	20	20	14	2	12	20	19	1	13	8	5	Richard Illingworth (ENG), KN Ananthapadmanabhan (IND) and Krishnamachari Srinivasan (IND)	Vengalil Narayanan Kutty (IND)
	nan	nan	nan	nan	nan		nan	nan	nan	nan	nan	nan					nan	nan			nan													nan	nan
	nan	nan	nan	nan	nan		nan	nan	nan	nan	nan	nan					nan	nan			nan													nan	nan
	nan	nan	nan	nan	nan		nan	nan	nan	nan	nan	nan					nan	nan			nan													nan	nan


CREATE TABLE ipl2020_match_data (
  "match_id" DOUBLE,
  "match_date" VARCHAR,
  "match_day" VARCHAR,
  "match_stadium" VARCHAR,
  "location_id" VARCHAR,
  "match_location" VARCHAR,
  "season" DOUBLE,
  "team1" VARCHAR,
  "team2" VARCHAR,
  "toss_won" VARCHAR,
  "toss_decision" VARCHAR,
  "result" VARCHAR,
  "winner" VARCHAR,
  "team1_score" DOUBLE,
  "team2_score" DOUBLE,
  "team1_wickets" DOUBLE,
  "team2_wickets" DOUBLE,
  "win_by_super_over_run" VARCHAR,
  "win_by_super_over_wicket" VARCHAR,
  "win_by_runs" DOUBLE,
  "win_by_wickets" DOUBLE,
  "player_of_the_match" VARCHAR,
  "total_overs" DOUBLE,
  "team1_bat_overs" DOUBLE,
  "team2_bat_overs" DOUBLE,
  "total_sixes" DOUBLE,
  "team1_sixes" DOUBLE,
  "team2_sixes" DOUBLE,
  "total_fours" DOUBLE,
  "team1_fours" DOUBLE,
  "team2_fours" DOUBLE,
  "total_extras_given" DOUBLE,
  "team1_extras_runs" DOUBLE,
  "team2_extras_runs" DOUBLE,
  "umpires" VARCHAR,
  "match_refereee" VARCHAR
);