IPL Auction

New IPL is going to soon start off and I have been assigned as the data analyst to perform analysis with different analytics tool to provide the names of players to build a strong and balanced squad. The team's management would likely need to strike a balance between all of these factors and come up with a well-thought-out auction strategy. This could involve targeting a few key players they consider to be game-changers, while also filling out the rest of the squad with more affordable players who can add value to the team. It could also involve making use of the various player retention and right-to-match options available to them.

I have used SQL mainly in order to provide the analysis and can be considered SQL-centric project. I have used PostgreSQL as the software to perform different operations.

How to use the project

You have to run the queries first which are necessary

  create table balls(
	id int,
	inning int,
	over int,
	ball int,
	batsman varchar,
	non_striker varchar,
	bowler varchar,
	batsman_runs int,
	extra_runs int,
	total_runs int,
	is_wicket int,
	dismissal_kind varchar,
	player_dismissed varchar,
	fielder varchar,
	extras_type varchar,
	batting_team varchar,
	bowling_team varchar
);

create table matches(
	id int,
	city varchar,
	date date,
	player_of_match varchar,
	venue varchar,
	neutral_venue int,
	team1 varchar,
	team2 varchar,
	toss_winner varchar,
	toss_decision varchar,
	winner varchar,
	result varchar,
	result_margin int,
	eliminator varchar,
	method varchar,
	umpire1 varchar,
	umpire2 varchar
);

Importing the Data

Copy balls from '"Your Location"\IPL_Ball.csv' DELIMITER ',' CSV HEADER;
select * from balls;


Copy matches from '"Your Location"\IPL Dataset\IPL Dataset\IPL_matches.csv' DELIMITER ',' CSV HEADER;
select * from matches;

You are good to go to run other queries or even modify them according to your needs!

Project Highlights

Badges

Feedback

If you have any feedback, please reach out to me at [email protected]