IPL Auction 2023

Analyze the Player Transactions

@kaggle.shahmirkiani_ipl_auction_2023

Table List

1 table(13.33 KB)

Iplauction2023

@kaggle.shahmirkiani_ipl_auction_2023.iplauction2023

13.33 KB
309 rows
8 columns

unnamed_0 Unnamed: 0	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	20	KKR	RETAINED
1	Ekant Sen	Batter	India	20	150	CSK	UNSOLD
2	Wayne Parnell	Allrounder	South Africa	75	150	CSK	UNSOLD
3	Shakib Al Hasan	Allrounder	Bangladesh	150	150	KKR	SOLD
4	Joe Root	Batter	England	100	100	RR	SOLD
5	Abdul Basith	Allrounder	India	20	20	RR	SOLD
6	Prashant Chopra	Allrounder	India	20	150	CSK	UNSOLD
7	Akeal Hosein	Bowler	West Indies	100	100	SRH	SOLD
8	Raghav Goyal	Bowler	India	20	20	MI	SOLD
9	Yudhvir Singh Charak	Allrounder	India	20	20	LSG	SOLD


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