Analysed historical data about football teams which have participated in the the La Liga Cup and calculated various metrics which can be used as indicators of success for teams in the tournament.
Skills and Tools
Statistics, Python, eda
@@@@@@@@@@@@@@@@@@@@@@@@@@
Think of yourself, currently working as a Business analyst in one of the top sports company. The senior management team has asked you to come up with metrics with which they can gauge which team will win the upcoming La Liga cup (Football tournament).
The data set contains information on all the teams so far participated in all the past tournaments. It has data about how many goals each team scored, conceded, how many times they came within first 6 positions, how many seasons they have qualified, their best position in the past etc.
You are required to do the following:
Read the data set and replace dashes with 0 to make sure you can perform arithmetic operations on the data. (5 points) Print all the teams which have started playing between 1930-1980. (5 points) Print the list of teams which came Top 5 in terms of points (5 points) Write a function with name “Goal_diff_count” which should return all the teams with their Goal Differences. Using the same function, find the team which has maximum and minimum goal difference. (5 points) Goal_diff_count = GoalsFor - GoalsAgainst
Create a new column with name “Winning Percent” and append it to the data set (5 points) Percentage of Winning = (GamesWon / GamesPlayed)*100
If there are any numerical error, replace it with 0%
Print the top 5 teams which has the highest Winning percentage
Group teams based on their “Best position” and print the sum of their points for all positions (5 points) Eg: Best Position Points
1 25000
2 7000