CONTEXT

The IPL 2023 Player auction will feature a total of 405 players who are set to go under the hammer in Kochi on 23d December. The initial list had over 991 cricketers who had registered for the auction. However, the final list was trimmed to 405. There will be a total of 87 slots spread across ten franchises up for grabs out of which 30 are slotted for overseas players. Among the 405 players, 273 are Indian players, 132 are overseas players

GUJARAT TITANSSQUAD 2023

The defending champions have retained the core team for the next season of IPL but they still have to do some smart business in the upcoming Auction. The likes of skipper Hardik Pandya, Shubman Gill, David Miller, Matthew Wade, Mohammad Shami and Rashid Khan will form the cornerstone of Gujarat Titans. The franchise has a considerable purse value of Rs 19.25 crore.

CHENNAI SUPER KINGSSQUAD 2023

Four-time IPL winners Chennai Super Kings will enter the auction with a purse of Rs 20.45 crore. The defending champions have released some veteran stars including Dwayne Bravo and Robin Uthappa. While they retained the likes of Ravindra Jadeja, Ruturaj Gaikwad, Deepak Chahar and Devon Conway to get things done. The upcoming season might be the last for MS Dhoni as he will look to end his career on a high with another IPL trophy.

DELHI CAPITALSSQUAD 2023

Delhi Capitals will enter the IPL 2023 auction with a purse amount of Rs 19.45 crore. Ahead of the mini-auction, DC released four players: KS Bharat, Tim Seifert, Ashwin Hebbar, and Mandeep Singh. They also traded Shardul Thakur to Kolkata Knight Riders and will look to enter the auction to sign some talented bowlers. Apart from that, the Capitals have not made any significant changes and have retained the majority of their roster. Pant will continue to lead the side for the next edition.

KOLKATA KNIGHT RIDERSSQUAD 2023
Two-time Indian Premier League (IPL) champions, Kolkata Knight Riders (KKR) have released a massive pool of 16 players from their roster ahead of the mine-auction. They made big moves in trading window to sign the likes of Shardul Thakur and Lockie Ferguson. Kolkata have kept their faith in their experienced campaigners Andre Russell and Sunil Narine as Shreyas Iyer will lead the side once again next season. It will be a tricky task for KKR to complete their squad as they have Rs 7.05 crore left in their purse.

PUNJAB KINGSSQUAD 2023
Punjab Kings management has decided to go for a major overhaul of their side as they will once again spend big bucks in the next auction. Punjab spent a lot of money in the IPL 2022 mega auction but failed to qualify for playoffs. They have released their last season's captain Mayank Agarwal. They have appointed Shikhar Dhawan as their captain for IPL 2023 but they have to sign big names to get the job done with Rs 32.2 crore left in their purse.

LUCKNOW SUPER GIANTSSQUAD 2023

The Lucknow Super Giants chose to release some key players ahead of the mini-auction on December 23 in Kochi. A total of seven players have been released including big names like Jason Holder, Dushmantha Chameera, Manish Pandey, and Evin Lewis. The franchise will have a healthy INR 23.35 crore in its coffers. At the auction, the team can also acquire the services of four overseas players.

MUMBAI INDIANSSQUAD 2023
Five-time IPL champions Mumbai Indians are desperate to make a comeback after an underwhelmiming last season as they have taken some bold steps to bolster their squad. They have released 13 players ahead of the IPL mini-auction. The team led by Rohit Sharma have retained some key players and have let go of those who seemed surplus. Mumbai have off-loaded stars like Tymal Mills and Fabian Allen along with other uncapped Indian players.

ROYAL CHALLENGERS BANGALORESQUAD 2023
Royal Challengers Bangalore chose to back their core group of players for the 2023 season of the Indian Premier League (IPL). The three-time runners-up will be led by Faf du Plessis as Virat Kohli, Glenn Maxwell, Dinesh Karthik, Josh Hazlewood, Mohammed Siraj, Wanindu Hasaranga and Harshal Patel will once again try to help RCB win their maiden title. RCB have a small purse - Rs 8.75 crore to complete their squad.

RAJASTHAN ROYALSSQUAD 2023
Rajasthan Royals finished as the runners-up of IPL 2022 after losing to a very strong Gujarat Giants team in the final. They have decided to stick with the same blueprint which brought them great success last season. The franchise has also released five overseas players James Neesham, Daryl Mitchell, Rassie van der Dussen, Corbin Bosch and Nathan Coulter-Nile. They have just Rs 13.2 crore left in the purse to complete their squad.

SUNRISERS HYDERABADSQUAD 2023
Sunrisers Hyderabad have released several players and have decided to build their team from scratch and invest in young talent. The most notable decision of SRH was to release their long-term captain Kane Williamson. It will be a tough task for Sunrisers Hyderbad to sign a big name in the upcoming auction who they can appoint as their next captain. SRH will go into the upcoming mini-auction with an enormous purse of Rs 42.25 crore.

Tables

Ipl 2023 Dataset

@kaggle.rajkumarpandey02_ipl_player_auction_dataset_2023.ipl_2023_dataset

19.74 KB
568 rows
10 columns


CREATE TABLE ipl_2023_dataset (
  "unnamed_0" BIGINT,
  "player" VARCHAR,
  "base_price" VARCHAR,
  "type" VARCHAR,
  "cost_in_cr" DOUBLE,
  "cost_in_000" DOUBLE,
  "n_2022_squad" VARCHAR,
  "team" VARCHAR,
  "base_price_in" DOUBLE,
  "base_price_in_2f32c6" DOUBLE
);