IPL 2020 By Numbers

IPL 2020 Datasets For Game and Venue Analysis

@kaggle.rajatrc1705_ipl_2020_by_numbers

Table List

2 tables(40.39 KB)

Venue

@kaggle.rajatrc1705_ipl_2020_by_numbers.venue

25.4 KB
56 rows
34 columns

game Game	stadium Stadium	team_1 Team 1	team_2 Team 2	toss_winner_num Toss Winner Num	toss_winner Toss Winner	toss_decision Toss Decision	who_bat_first Who Bat First	winner_num Winner Num	winner Winner	loser Loser	spin_economy_1 Spin Economy 1	spin_economy_2 Spin Economy 2	spin_wickets_1 Spin Wickets 1	spin_wickets_2 Spin Wickets 2	fast_economy_1 Fast Economy 1	fast_economy_2 Fast Economy 2	fast_wickets_1 Fast Wickets 1	fast_wickets_2 Fast Wickets 2	first_innings First Innings	second_innings Second Innings	total_wickets Total Wickets	pps1 Pps1	ppf1 Ppf1	mos1 Mos1	mof1 Mof1	dos1 Dos1	dof1 Dof1	ppf2 Ppf2	mos2 Mos2	mof2 Mof2	dos2 Dos2	dof2 Dof2
	AbuDhabi	MI	CSK	2	CSK	Field	1	2	CSK	MI	9.125	7.875	2	3	8.206	8.167	3	6	162	166	14	1	1	2	1		4	2	3
1	Dubai	DC	KXIP	2	KXIP	Field	1	1	DC	KXIP	3.2	7.625	3	1	9	7.917	5	5	157	157	16	2	1	1	2		2	2	1	1		2
2	Dubai	SRH	RCB	1	SRH	Field	2	2	RCB	SRH	7.833	5	1	3	8.214	8.25	2	5	153	163	15			1	2				3			5
3	Sharjah	RR	CSK	2	CSK	Field	1	1	RR	CSK	9.375	11.875	4	1	9	10	2	5	216	200	13			4	1		1	1	1	1		3
4	AbuDhabi	KKR	MI	1	KKR	Field	2	2	MI	KKR	7.625	7.2	1	2	11	7.2	3	7	195	146	140		1	1			2	2	1	3	1	2
5	Dubai	KXIP	RCB	2	RCB	Field	1	1	KXIP	RCB	7	6.333	7	1	5.5	11.571	3	2	206	109	13		3	4	1	2			1	2
6	Dubai	CSK	DC	1	CSK	Field	2	2	DC	CSK	9.6	5.15	2	1	7.767	7.4	1	5	175	131	10	1	1		1		3		2			1
7	AbuDhabi	KKR	SRH	2	SRH	Bat	1	1	KKR	SRH	7.167	7.667	1	1	7.2	9.33	2	2	142	145	7		1	1			1	2	1
8	Sharjah	RR	KXIP	1	RR	Field	2	1	RR	KXIP	15	9.63		1	10.58	13.5	2	5	223	226	8						2	1		1	1	3
9	Dubai	RCB	MI	2	MI	Field	1	1	RCB	MI	9.417	7.714	3	1	11	10.769	2	2	201	201	8	1	1	2			1		1	1		1


CREATE TABLE venue (
  "game" BIGINT,
  "stadium" VARCHAR,
  "team_1" VARCHAR,
  "team_2" VARCHAR,
  "toss_winner_num" BIGINT,
  "toss_winner" VARCHAR,
  "toss_decision" VARCHAR,
  "who_bat_first" BIGINT,
  "winner_num" BIGINT,
  "winner" VARCHAR,
  "loser" VARCHAR,
  "spin_economy_1" DOUBLE,
  "spin_economy_2" DOUBLE,
  "spin_wickets_1" BIGINT,
  "spin_wickets_2" BIGINT,
  "fast_economy_1" DOUBLE,
  "fast_economy_2" DOUBLE,
  "fast_wickets_1" BIGINT,
  "fast_wickets_2" BIGINT,
  "first_innings" BIGINT,
  "second_innings" BIGINT,
  "total_wickets" BIGINT,
  "pps1" BIGINT,
  "ppf1" BIGINT,
  "mos1" BIGINT,
  "mof1" BIGINT,
  "dos1" BIGINT,
  "dof1" BIGINT,
  "pps2" BIGINT,
  "ppf2" BIGINT,
  "mos2" BIGINT,
  "mof2" BIGINT,
  "dos2" BIGINT,
  "dof2" BIGINT
);