Clubs And National Teams Stats From FIFA 16 To 23
Statistics of clubs and national teams extracted from the editions of FIFA games
@kaggle.ernestonlm_clubs_and_national_teams_stats_from_fifa_16_to_23
Statistics of clubs and national teams extracted from the editions of FIFA games
@kaggle.ernestonlm_clubs_and_national_teams_stats_from_fifa_16_to_23
The dataset is built from the information of the players published by the game FIFA from EA sports. The editions from 2016 to 2023 were processed to unify the attributes of each player in the game.
After this processing, the players were grouped by team and the average of each attribute of the best players of the team by attribute was calculated.
For example: To calculate the value of the Marking attribute, the top 8 players in Marking are taken and the average of that attribute is calculated. 8 are chosen because on average, those are the players who have a defensive role in the starting team. Therefore, the number of players used to average each attribute varies.
To obtain the attributes for the national teams, players were grouped by nationality instead of team.
CREATE TABLE nations_stats_ds (
"year" BIGINT,
"country" VARCHAR,
"overall" DOUBLE,
"potential" DOUBLE,
"intreputation" DOUBLE,
"age" DOUBLE,
"skillmoves" DOUBLE,
"crossing" DOUBLE,
"finishing" DOUBLE,
"headingaccuracy" DOUBLE,
"shortpassing" DOUBLE,
"volleys" DOUBLE,
"dribbling" DOUBLE,
"curve" DOUBLE,
"fkaccuracy" DOUBLE,
"longpassing" DOUBLE,
"ballcontrol" DOUBLE,
"acceleration" DOUBLE,
"sprintspeed" DOUBLE,
"agility" DOUBLE,
"reactions" DOUBLE,
"balance" DOUBLE,
"shotpower" DOUBLE,
"jumping" DOUBLE,
"stamina" DOUBLE,
"strength" DOUBLE,
"longshots" DOUBLE,
"aggression" DOUBLE,
"interceptions" DOUBLE,
"positioning" DOUBLE,
"vision" DOUBLE,
"penalties" DOUBLE,
"composure" DOUBLE,
"standingtackle" DOUBLE,
"slidingtackle" DOUBLE,
"defoverall" DOUBLE,
"midoverall" DOUBLE,
"attoverall" DOUBLE
);CREATE TABLE teams_stats_ds (
"year" BIGINT,
"club" VARCHAR,
"overall" DOUBLE,
"potential" DOUBLE,
"intreputation" DOUBLE,
"age" DOUBLE,
"skillmoves" DOUBLE,
"crossing" DOUBLE,
"finishing" DOUBLE,
"headingaccuracy" DOUBLE,
"shortpassing" DOUBLE,
"volleys" DOUBLE,
"dribbling" DOUBLE,
"curve" DOUBLE,
"fkaccuracy" DOUBLE,
"longpassing" DOUBLE,
"ballcontrol" DOUBLE,
"acceleration" DOUBLE,
"sprintspeed" DOUBLE,
"agility" DOUBLE,
"reactions" DOUBLE,
"balance" DOUBLE,
"shotpower" DOUBLE,
"jumping" DOUBLE,
"stamina" DOUBLE,
"strength" DOUBLE,
"longshots" DOUBLE,
"aggression" DOUBLE,
"interceptions" DOUBLE,
"positioning" DOUBLE,
"vision" DOUBLE,
"penalties" DOUBLE,
"composure" DOUBLE,
"standingtackle" DOUBLE,
"slidingtackle" DOUBLE,
"defoverall" DOUBLE,
"midoverall" DOUBLE,
"attoverall" DOUBLE
);Anyone who has the link will be able to view this.