IPL2021 Auction

Data of 292 Players Under the hammer

@kaggle.psrajput_ipl2021_auction

Table List

1 table(16.54 KB)

Ipl2021 Auction V2

@kaggle.psrajput_ipl2021_auction.ipl2021_auction_v2

16.54 KB
293 rows
13 columns

set Set	name Name	playing_role Playing Role	country Country	age Age	ipl IPL	n_2020_ipl 2020 IPL	c_u_a C U A	reservepriceinlakh ReservePriceInLakh	bought_by Bought By	buy_price Buy Price	previous_ipl_teams Previous IPL Teams	n_2020_team 2020 Team
1	Aaron Finch	Batsman	Australia	34	87	12	Capped	100	Unsold		RR, DD, PWI, SRH, MI, GL, KXIP,RCB	RCB
1	Alex Hales	Batsman	England	32	6		Capped	150	Unsold		MI,SRH	nan
1	Evin Lewis	Batsman	West Indies	29	16		Capped	100	Unsold		MI	nan
1	Karun Nair	TopOrder Batsman	India	29	73	4	Capped	50	KKR	5000000	RCB,RR,DD,KXIP	KXIP
1	Jason Roy	nan	England	30	8		Capped	200	Unsold		GL,DD,DC	DC
1	Steve Smith	MiddleOrder Batsman	Australia	31	95	14	Capped	200	DC	22000000	PWI,RPS,RR	RR
1	Hanuma Vihari	Batsman	India	27	24		Capped	100	Unsold		SRH,DC	nan
2	Shakib Al Hasan	Allrounder	Bangladesh	34	63		Capped	200	KKR	32000000	KKR,SRH	nan
2	Moeen Ali	Batting Allrounder	England	33	19	3	Capped	200	CSK	70000000	RCB	RCB
2	Shivam Dube	Allrounder	India	27	15	11	Capped	50	RR	44000000	RCB	RCB


CREATE TABLE ipl2021_auction_v2 (
  "set" DOUBLE,
  "name" VARCHAR,
  "playing_role" VARCHAR,
  "country" VARCHAR,
  "age" BIGINT,
  "ipl" BIGINT,
  "n_2020_ipl" DOUBLE,
  "c_u_a" VARCHAR,
  "reservepriceinlakh" BIGINT,
  "bought_by" VARCHAR,
  "buy_price" DOUBLE,
  "previous_ipl_teams" VARCHAR,
  "n_2020_team" VARCHAR
);