Let's select the most interesting columns from loaded dataset:
Right away I can see that values in columns: 'Value' and 'Wage' aren't numeric but objects. Thus I'll preprocess the data to make it usable. I will use short supporting function to convert values in those two columns into numbers. I will end up with two new columns 'ValueNum' and 'WageNum' that will contain numeric values.
To make things simpler, I select the first position from list as preferred and save it in 'Position' column.
In case the plot.ly image doesn't show:
I can see that the players are very centralized in Europe. To be precise, England, Germany, Spain, and France.
Let's see the 20 players with highest value:
Let's make a scatter chart of the players' Value with respect to their Age and Overall:
Let's see the 20 players with highest wage:
Let's make a scatter chart of the players' Wage with respect to their Age and Overall:
For simplicity of this analysis, I only pull in data I am interested in:
What's the best squad according to FIFA 18 purely based on overall rating?
Alright, now let's move onto studying different squad's impact on Nationality teams. First let's modifiy above get_summary and get_best_squad functions for Nationality:
Also let's make our squad choices more strict:
Let's explore different squad possibility of France and how it affects the ratings:
So we can say that France has the best squard as 4-3-3 for the current squad; and 4-4-2, 4-3-3, and 4-2-3-1 for the future squad based on team ratings. Let's check out the best 11 squad line-up of France in 4-3-3 for current rating as well as 4-4-2 for potential rating:
The holding champion is certainly a heavy candidate for this year's 1st place:
As you can see, Germany's current ratings peak with either 3-4-3 or 4-3-3 formation; while those 2 plus 4-2-3-1 are their best options for the future. With that, I'll show Germany's best 11 squad with 4-3-3 for current ratings and 4-2-3-1 for potential ratings.
How about our 2010's winner?
Well, Spain does best with either 4-3-3 or 4-2-3-1 for both current and potential rating. I'll choose 4-2-3-1 for the current squad and 4-3-3 for the potential squad.
Although having the best soccer league in Europe, England did not seem to do that well at the national level. Let's figure out their options for the upcoming World Cup:
England should stick to 4-3-3 with their current squad and either 4-3-3 or 4-2-3-1 with their potential squad. Thus, I'll choose 4-3-3 and 4-2-3-1 respectively.
Having won the World Cup the most times in history, the Samba team will no doubt be one of the top candidates for this summer in Russia.
As you can see, Brazil has similar options like England. I'll go with 4-3-3 for the current rating and 4-2-3-1 for the potential rating.
Lionel Messi is still waiting for the only trophy he hasn't gotten yet in his career. Can he carry Argentina to the top after going short in the final 4 years ago?
Both 3-4-3 and 4-3-3 fare very well for the current and potential ratings of Argentine players. For the sake of diversity, I'll choose 3-4-3 for their current squad and 4-3-3 for their future squad.
The Red Devils has some of the best players in English Premier League, but can't never seem to make it far in the national level. Can Hazard and De Bruyne drive them far this time?
Again, 4-3-3 is the best formation for Belgium's both current and future squad.
Last but not least, the winner of Euro 2016 and the best player in the world 3 times in a row, Cristiano Ronaldo.
OK, I'll go with 4-2-3-1 for current rating and 4-3-3 for potential rating of Portugal.
Ok, let's make some comparison between these 8 line-ups with the current rating of players for these strongest contenders for World Cup 2018.
So based purely on the FIFA 18 Data:
My bet is for a Spain vs Germany in the final, and Brazil vs France for the 3rd place. Your turn?