Name: Fifa 18 More Complete Player Dataset
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Fifa 18 More Complete Player Dataset

Context

This dataset is an extension of that found here. It contains several extra fields and is pre-cleaned to a much greater extent. After talking with the creator of the original dataset, he and I agreed that merging our work would require making breaking changes to the original, and that this should be published as a new dataset.

Content

185 fields for every player in FIFA 18.
Player info such as age, club, league, nationality, salary and physical attributes
All playing attributes, such as finishing and dribbling
Special attributes like skill moves and international reputation
Traits and specialities
Overall, potential, and ratings for each position

Differences

Here are the columns in this dataset that aren't in the original:

birth_date
eur_release_clause
height_cm
weight_kg
body_type
real_face
league
Headline attributes: pac, sho, pas, dri, def, and phy. These are what appear on Ultimate Team cards
international_reputation
skill_moves
weak_foot
work_rate_att
work_rate_def
preferred_foot
all traits and specialities as dummy variables
all position preferences as dummy variables

Acknowledgements

Credit goes to Aman Shrivastava for building the original dataset. And thanks of course to https://sofifa.com for not banning my IP when I scraped over 18000 pages to get this data.

Inspiration

What insights can this data give us, not only into FIFA 18 but into real-world football? The kernels on last year's dataset are a good place to find ideas.

Contributing

Contributions to the GitHub project are more than welcome. Do let me know if you think of ways to improve either the code or the dataset!

Tables

Complete

@kaggle.kevinmh_fifa_18_more_complete_player_dataset.complete

2.36 MB
17,994 rows
185 columns

CREATE TABLE complete (
  "id" BIGINT,
  "name" VARCHAR,
  "full_name" VARCHAR,
  "club" VARCHAR,
  "club_logo" VARCHAR,
  "special" BIGINT,
  "age" BIGINT,
  "league" VARCHAR,
  "birth_date" TIMESTAMP,
  "height_cm" DOUBLE,
  "weight_kg" DOUBLE,
  "body_type" VARCHAR,
  "real_face" BOOLEAN,
  "flag" VARCHAR,
  "nationality" VARCHAR,
  "photo" VARCHAR,
  "eur_value" DOUBLE,
  "eur_wage" DOUBLE,
  "eur_release_clause" DOUBLE,
  "overall" BIGINT,
  "potential" BIGINT,
  "pac" BIGINT,
  "sho" BIGINT,
  "pas" BIGINT,
  "dri" BIGINT,
  "def" BIGINT,
  "phy" BIGINT,
  "international_reputation" BIGINT,
  "skill_moves" BIGINT,
  "weak_foot" BIGINT,
  "work_rate_att" VARCHAR,
  "work_rate_def" VARCHAR,
  "preferred_foot" VARCHAR,
  "crossing" BIGINT,
  "finishing" BIGINT,
  "heading_accuracy" BIGINT,
  "short_passing" BIGINT,
  "volleys" BIGINT,
  "dribbling" BIGINT,
  "curve" BIGINT,
  "free_kick_accuracy" BIGINT,
  "long_passing" BIGINT,
  "ball_control" BIGINT,
  "acceleration" BIGINT,
  "sprint_speed" BIGINT,
  "agility" BIGINT,
  "reactions" BIGINT,
  "balance" BIGINT,
  "shot_power" BIGINT,
  "jumping" BIGINT,
  "stamina" BIGINT,
  "strength" BIGINT,
  "long_shots" BIGINT,
  "aggression" BIGINT,
  "interceptions" BIGINT,
  "positioning" BIGINT,
  "vision" BIGINT,
  "penalties" BIGINT,
  "composure" BIGINT,
  "marking" BIGINT,
  "standing_tackle" BIGINT,
  "sliding_tackle" BIGINT,
  "gk_diving" BIGINT,
  "gk_handling" BIGINT,
  "gk_kicking" BIGINT,
  "gk_positioning" BIGINT,
  "gk_reflexes" BIGINT,
  "rs" DOUBLE,
  "rw" DOUBLE,
  "rf" DOUBLE,
  "ram" DOUBLE,
  "rcm" DOUBLE,
  "rm" DOUBLE,
  "rdm" DOUBLE,
  "rcb" DOUBLE,
  "rb" DOUBLE,
  "rwb" DOUBLE,
  "st" DOUBLE,
  "lw" DOUBLE,
  "cf" DOUBLE,
  "cam" DOUBLE,
  "cm" DOUBLE,
  "lm" DOUBLE,
  "cdm" DOUBLE,
  "cb" DOUBLE,
  "lb" DOUBLE,
  "lwb" DOUBLE,
  "ls" DOUBLE,
  "lf" DOUBLE,
  "lam" DOUBLE,
  "lcm" DOUBLE,
  "ldm" DOUBLE,
  "lcb" DOUBLE,
  "gk" DOUBLE,
  "n_1_on_1_rush_trait" BOOLEAN  -- 1 On 1 Rush Trait,
  "acrobatic_clearance_trait" BOOLEAN,
  "argues_with_officials_trait" BOOLEAN,
  "avoids_using_weaker_foot_trait" BOOLEAN,
  "backs_into_player_trait" BOOLEAN,
  "bicycle_kicks_trait" BOOLEAN
);