IPL Auction 2023

Analyzing Player Transactions

@kaggle.rishabhkarn_ipl_auction_2023

Table List

1 table(11.08 KB)

Iplauction2023

@kaggle.rishabhkarn_ipl_auction_2023.iplauction2023

11.08 KB
309 rows
7 columns

name Name	player_style Player Style	nationality Nationality	base_price_in_lacs Base Price (in Lacs)	final_price_in_lacs Final Price (in Lacs)	franchise Franchise	status Status
Harshit Rana	Bowler	India		20	KKR	RETAINED
Ekant Sen	Batter	India	20		nan	UNSOLD
Wayne Parnell	Allrounder	South Africa	75		nan	UNSOLD
Shakib Al Hasan	Allrounder	Bangladesh	150	150	KKR	SOLD
Joe Root	Batter	England	100	100	RR	SOLD
Abdul Basith	Allrounder	India	20	20	RR	SOLD
Prashant Chopra	Allrounder	India	20		nan	UNSOLD
Akeal Hosein	Bowler	West Indies	100	100	SRH	SOLD
Raghav Goyal	Bowler	India	20	20	MI	SOLD
Yudhvir Singh Charak	Allrounder	India	20	20	LSG	SOLD


CREATE TABLE iplauction2023 (
  "name" VARCHAR,
  "player_style" VARCHAR,
  "nationality" VARCHAR,
  "base_price_in_lacs" DOUBLE,
  "final_price_in_lacs" DOUBLE,
  "franchise" VARCHAR,
  "status" VARCHAR
);