IPL Auction Dataset 2020

Dataset of the IPL Auction 2020

@kaggle.thegreatcoder_ipl_auction_dataset

Table List

1 table(11.63 KB)

Ipl Data

@kaggle.thegreatcoder_ipl_auction_dataset.ipl_data

11.63 KB
62 rows
13 columns

s_no S.No	set_no Set No	set Set	name Name	playing_role Playing Role	ipl_matches IPL Matches	capped_uncapped_associate Capped / Uncapped /Associate	reserve_price_in_lacs Reserve Price(in ₹ Lacs)	ipl_2020_team IPL 2020 Team	auctioned_price_in_lacs Auctioned Price(in ₹ Lacs)	ipl_2019_team IPL 2019 Team	ipl_team_s IPL Team(s)
1	1	BA1	Chris Lynn	Batsman	41	Capped	200	Mumbai Indians	200	KKR	Deccan Chargers,SRH,KKR
2	1	BA1	Eoin Morgan	Batsman	52	Capped	200	Kolkata Knight Riders	525	nan	RCB, KKR, SRH, KXIP
3	1	BA1	Robin Uthappa	Batsman	177	Capped	150	Rajasthan Royals	300	KKR	MI, RCB, PWI, KKR
4	1	BA1	Jason Roy	Batsman	8	Capped	150	Delhi Capitals	150	nan	GL,DD
5	1	BA1	Aaron Finch	Batsman	75	Capped	100	Royal Challengers Bangalore	440	nan	RR, DD, PWI, SRH, MI, GL, KXIP
6	2	AL1	Glenn Maxwell	All Rounder	69	Capped	200	Kings XI Punjab	1075	nan	MI,KXIP,DD
7	2	AL1	Chris Woakes	All Rounder	18	Capped	150	Delhi Capitals	150	nan	KKR,RCB
8	2	AL1	Pat Cummins	All Rounder	16	Capped	200	Kolkata Knight Riders	1550	nan	MI,KKR,DD
9	2	AL1	Sam Curran	All Rounder	16	Capped	100	Chennai Super Kings	550	KXIP	KXIP
10	2	AL1	Chris Morris	All Rounder	61	Capped	150	Royal Challengers Bangalore	1000	DC	CSK,RR,DC


CREATE TABLE ipl_data (
  "s_no" BIGINT,
  "set_no" VARCHAR,
  "set" VARCHAR,
  "name" VARCHAR,
  "country" VARCHAR,
  "playing_role" VARCHAR,
  "ipl_matches" DOUBLE,
  "capped_uncapped_associate" VARCHAR,
  "reserve_price_in_lacs" BIGINT,
  "ipl_2020_team" VARCHAR,
  "auctioned_price_in_lacs" BIGINT,
  "ipl_2019_team" VARCHAR,
  "ipl_team_s" VARCHAR
);