Football (FIFA - 2019) Dataset
Football (FIFA-2019) World Cup Dataset of Players' Statistics with Notebook
@kaggle.devansodariya_football_fifa_2019_dataset
Football (FIFA-2019) World Cup Dataset of Players' Statistics with Notebook
@kaggle.devansodariya_football_fifa_2019_dataset
This Dataset Contains all Information of players who participated in the FIFA-2019 League.
This Dataset consists of all the parameters, by which a Player's ability can be measured
some of the parameters included in the dataset are,
Age: Age of Player
Skill Moves: Describes various skill set of the player
Work Rate: Work rate of player
Body Type: Body type of player (like High, lean, Courtois, moderate)
joined year: Joining year of player
Agility: Agility of player (numerical values)
SprintSpeed: Sprinting Speed of player
Reactions: Reaction on the Numerical Scale
This Dataset can be used for Supervised as well as Unsupervised tasks.
Note: In Version-2 I've cleaned some of the Currency units and made them more readble.
CREATE TABLE fifa_2019 (
"unnamed_0" BIGINT -- Unnamed: 0,
"id" BIGINT,
"name" VARCHAR,
"age" BIGINT,
"photo" VARCHAR,
"nationality" VARCHAR,
"flag" VARCHAR,
"overall" BIGINT,
"potential" BIGINT,
"club" VARCHAR,
"club_logo" VARCHAR,
"value" VARCHAR,
"wage" VARCHAR,
"special" BIGINT,
"preferred_foot" VARCHAR,
"international_reputation" DOUBLE,
"weak_foot" DOUBLE,
"skill_moves" DOUBLE,
"work_rate" VARCHAR,
"body_type" VARCHAR,
"real_face" VARCHAR,
"position" VARCHAR,
"jersey_number" DOUBLE,
"joined" TIMESTAMP,
"loaned_from" VARCHAR,
"contract_valid_until" VARCHAR,
"height" VARCHAR,
"weight" VARCHAR,
"ls" VARCHAR,
"st" VARCHAR,
"rs" VARCHAR,
"lw" VARCHAR,
"lf" VARCHAR,
"cf" VARCHAR,
"rf" VARCHAR,
"rw" VARCHAR,
"lam" VARCHAR,
"cam" VARCHAR,
"ram" VARCHAR,
"lm" VARCHAR,
"lcm" VARCHAR,
"cm" VARCHAR,
"rcm" VARCHAR,
"rm" VARCHAR,
"lwb" VARCHAR,
"ldm" VARCHAR,
"cdm" VARCHAR,
"rdm" VARCHAR,
"rwb" VARCHAR,
"lb" VARCHAR,
"lcb" VARCHAR,
"cb" VARCHAR,
"rcb" VARCHAR,
"rb" VARCHAR,
"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,
"marking" DOUBLE,
"standingtackle" DOUBLE,
"slidingtackle" DOUBLE,
"gkdiving" DOUBLE,
"gkhandling" DOUBLE,
"gkkicking" DOUBLE,
"gkpositioning" DOUBLE,
"gkreflexes" DOUBLE,
"release_clause" VARCHAR
);CREATE TABLE fifa_processed_data (
"unnamed_0_1" BIGINT -- Unnamed: 0.1,
"unnamed_0" BIGINT -- Unnamed: 0,
"id" BIGINT,
"name" VARCHAR,
"age" BIGINT,
"photo" VARCHAR,
"nationality" VARCHAR,
"flag" VARCHAR,
"overall" BIGINT,
"potential" BIGINT,
"club" VARCHAR,
"club_logo" VARCHAR,
"value" BIGINT,
"wage" BIGINT,
"special" BIGINT,
"preferred_foot" VARCHAR,
"international_reputation" DOUBLE,
"weak_foot" DOUBLE,
"skill_moves" DOUBLE,
"work_rate" VARCHAR,
"body_type" VARCHAR,
"real_face" VARCHAR,
"position" VARCHAR,
"jersey_number" DOUBLE,
"joined" VARCHAR,
"loaned_from" VARCHAR,
"contract_valid_until" VARCHAR,
"height" BIGINT,
"weight" BIGINT,
"ls" BIGINT,
"st" BIGINT,
"rs" BIGINT,
"lw" BIGINT,
"lf" BIGINT,
"cf" BIGINT,
"rf" BIGINT,
"rw" BIGINT,
"lam" BIGINT,
"cam" BIGINT,
"ram" BIGINT,
"lm" BIGINT,
"lcm" BIGINT,
"cm" BIGINT,
"rcm" BIGINT,
"rm" BIGINT,
"lwb" BIGINT,
"ldm" BIGINT,
"cdm" BIGINT,
"rdm" BIGINT,
"rwb" BIGINT,
"lb" BIGINT,
"lcb" BIGINT,
"cb" BIGINT,
"rcb" BIGINT,
"rb" BIGINT,
"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,
"marking" DOUBLE,
"standingtackle" DOUBLE,
"slidingtackle" DOUBLE,
"gkdiving" DOUBLE,
"gkhandling" DOUBLE,
"gkkicking" DOUBLE,
"gkpositioning" DOUBLE,
"gkreflexes" DOUBLE,
"release_clause" VARCHAR
);Anyone who has the link will be able to view this.