Dataset: FIFA 21 Players & Teams FULL Database / UPD 09.21

About this Dataset

FIFA 21 Players & Teams FULL Database / UPD 09.21

Story

I scrapy this dataset using pydantic. This dataset contains a minimum of "surprises". I hope you don’t spend a lot of time on preprocessing, as it was with me with the FIFA 20 datasets :)

Content

I have replaced positions that do not exist in fifa, for example ["LS", "RS"] with "ST".
And a few more brief introductory notes:

monetary values in Euro;
height in cm;
weight in kg;
players without clubs in the Clubs column - "Free agent"
players who are not include to national teams in the column "NationalTeam" - "Not in team"

Player table

       "ID": {
            "title": "Id",
            "type": "integer"
        },
        "Name": {
            "title": "Name",
            "minLength": 3,
            "maxLength": 30,
            "type": "string"
        },
        "FullName": {
            "title": "Fullname",
            "minLength": 3,
            "maxLength": 80,
            "type": "string"
        },
        "Age": {
            "title": "Age",
            "exclusiveMinimum": 14,
            "exclusiveMaximum": 60,
            "type": "integer"
        },
        "Height": {
            "title": "Height",
            "exclusiveMinimum": 140,
            "exclusiveMaximum": 220,
            "type": "integer"
        },
        "Weight": {
            "title": "Weight",
            "exclusiveMinimum": 40,
            "exclusiveMaximum": 120,
            "type": "integer"
        },
        "PhotoUrl": {
            "title": "Photourl",
            "minLength": 1,
            "maxLength": 2083,
            "format": "uri",
            "type": "string"
        },
        "Nationality": {
            "title": "Nationality",
            "minLength": 3,
            "maxLength": 50,
            "type": "string"
        },
        "Overall": {
            "title": "Overall",
            "exclusiveMinimum": 20,
            "exclusiveMaximum": 100,
            "type": "integer"
        },
        "Potential": {
            "title": "Potential",
            "exclusiveMinimum": 20,
            "exclusiveMaximum": 100,
            "type": "integer"
        },
        "Growth": {
            "title": "Growth",
            "exclusiveMinimum": -1,
            "exclusiveMaximum": 60,
            "type": "integer"
        },
        "TotalStats": {
            "title": "Totalstats",
            "exclusiveMinimum": 50,
            "exclusiveMaximum": 3000,
            "type": "integer"
        },
        "BaseStats": {
            "title": "Basestats",
            "exclusiveMinimum": 50,
            "exclusiveMaximum": 3000,
            "type": "integer"
        },
        "Positions": {
            "title": "Positions",
            "minLength": 2,
            "maxLength": 15,
            "type": "string"
        },
        "BestPosition": {
            "title": "Bestposition",
            "minLength": 2,
            "maxLength": 3,
            "type": "string"
        },
        "Club": {
            "title": "Club",
            "minLength": 3,
            "maxLength": 50,
            "type": "string"
        },
        "ValueEUR": {
            "title": "Valueeur",
            "exclusiveMinimum": -1,
            "type": "integer"
        },
        "WageEUR": {
            "title": "Wageeur",
            "exclusiveMinimum": -1,
            "type": "integer"
        },
        "ReleaseClause": {
            "title": "Releaseclause",
            "exclusiveMinimum": -1,
            "type": "integer"
        },
        "ClubPosition": {
            "title": "Clubposition",
            "maxLength": 3,
            "type": "string"
        },
        "ContractUntil": {
            "title": "Contractuntil",
            "exclusiveMinimum": 2018,
            "exclusiveMaximum": 2030,
            "type": "integer"
        },
        "ClubNumber": {
            "title": "Clubnumber",
            "exclusiveMinimum": 0,
            "exclusiveMaximum": 100,
            "type": "integer"
        },
        "ClubJoined": {
            "title": "Clubjoined",
            "exclusiveMinimum": 1990,
            "exclusiveMaximum": 2021,
            "type": "integer"
        },
        "OnLoad": {
            "title": "Onload",
            "type": "boolean"
        },
        "NationalTeam": {
            "title": "Nationalteam",
            "default": "Not in team",
            "minLength": 3,
            "maxLength": 50,
            "type": "string"
        },
        "NationalPosition": {
            "title": "Nationalposition",
            "maxLength": 3,
            "type": "string"
        },
        "NationalNumber": {
            "title": "Nationalnumber",
            "exclusiveMinimum": 0,
            "exclusiveMaximum": 100,
            "type": "integer"
        },
        "PreferredFoot": {
            "title": "Preferredfoot",
            "anyOf": [
                {
                    "type": "string",
                    "pattern": "^Right$"
                },
                {
                    "type": "string",
                    "pattern": "^Left$"
                }
            ]
        },
        "IntReputation": {
            "title": "Intreputation",
            "exclusiveMinimum": 0,
            "exclusiveMaximum": 6,
            "type": "integer"
        },
        "WeakFoot": {
            "title": "Weakfoot",
            "exclusiveMinimum": 0,
            "exclusiveMaximum": 6,
            "type": "integer"
        },
        "SkillMoves": {
            "title": "Skillmoves",
            "exclusiveMinimum": 0,
            "exclusiveMaximum": 6,
            "type": "integer"
        },
        "AttackingWorkRate": {
            "title": "Attackingworkrate",
            "minLength": 3,
            "maxLength": 10,
            "type": "string"
        },
        "DefensiveWorkRate": {
            "title": "Defensiveworkrate",
            "minLength": 3,
            "maxLength": 10,
            "type": "string"
        },
        "*": {
            "title": "Other columns from 'PaceTotal' to 'GKRating",
            "exclusiveMinimum": 0,
            "exclusiveMaximum": 100,
            "type": "integer"
        },

Teams table

       "ID": {
            "title": "Id",
            "type": "integer"
        },
       "Name": {
            "title": "Name",
            "type": "string"
        },
        "League": {
            "title": "League",
            "type": "string"
       },
       "LeagueId": {
            "title": "LeagueId",
            "type": "integer"
        },
        "Overall": {
            "title": "Overall",
            "exclusiveMinimum": 0,
            "exclusiveMaximum": 100,
            "type": "integer"
        },
        "Attack": {
            "title": "Attack",
            "exclusiveMinimum": 0,
            "exclusiveMaximum": 100,
            "type": "integer"
        },
        "Midfield": {
            "title": "Midfield",
            "exclusiveMinimum": 0,
            "exclusiveMaximum": 100,
            "type": "integer"
        },
        "Defence": {
            "title": "Defence",
            "exclusiveMinimum": 0,
            "exclusiveMaximum": 100,
            "type": "integer"
        },
        "TransferBudget": {
            "title": "Transferbudget",
            "exclusiveMinimum": -1,
            "type": "integer"
        },
        "DomesticPrestige": {
            "title": "Domesticprestige",
            "exclusiveMinimum": 0,
            "exclusiveMaximum": 11,
            "type": "integer"
        },
        "IntPrestige": {
            "title": "Intprestige",
            "exclusiveMinimum": 0,
            "exclusiveMaximum": 11,
            "type": "integer"
        },
        "Players": {
            "title": "Players",
            "exclusiveMinimum": 0,
            "exclusiveMaximum": 50,
            "type": "integer"
        },
        "StartingAverageAge": {
            "title": "Startingaverageage",
            "exclusiveMinimum": 15,
            "exclusiveMaximum": 40,
            "type": "number"
        },
        "AllTeamAverageAge": {
            "title": "Allteamaverageage",
            "exclusiveMinimum": 15,
            "exclusiveMaximum": 40,
            "type": "number"
        }

Acknowledgements

Thanks sofifa.com for the data

Inspiration

Who to buy in Career Mode? What features affect the price?

Tables

Players Fifa21

@kaggle.cashncarry_fifa_21_players_teams_full_database.players_fifa21

2.11 MB
19020 rows
90 columns


CREATE TABLE players_fifa21 (
  "id" BIGINT,
  "name" VARCHAR,
  "fullname" VARCHAR,
  "age" BIGINT,
  "height" BIGINT,
  "weight" BIGINT,
  "photourl" VARCHAR,
  "nationality" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "growth" BIGINT,
  "totalstats" BIGINT,
  "basestats" BIGINT,
  "positions" VARCHAR,
  "bestposition" VARCHAR,
  "club" VARCHAR,
  "valueeur" BIGINT,
  "wageeur" BIGINT,
  "releaseclause" BIGINT,
  "clubposition" VARCHAR,
  "contractuntil" DOUBLE,
  "clubnumber" DOUBLE,
  "clubjoined" BIGINT,
  "onload" BOOLEAN,
  "nationalteam" VARCHAR,
  "nationalposition" VARCHAR,
  "nationalnumber" DOUBLE,
  "preferredfoot" VARCHAR,
  "intreputation" BIGINT,
  "weakfoot" BIGINT,
  "skillmoves" BIGINT,
  "attackingworkrate" VARCHAR,
  "defensiveworkrate" VARCHAR,
  "pacetotal" BIGINT,
  "shootingtotal" BIGINT,
  "passingtotal" BIGINT,
  "dribblingtotal" BIGINT,
  "defendingtotal" BIGINT,
  "physicalitytotal" BIGINT,
  "crossing" BIGINT,
  "finishing" BIGINT,
  "headingaccuracy" BIGINT,
  "shortpassing" BIGINT,
  "volleys" BIGINT,
  "dribbling" BIGINT,
  "curve" BIGINT,
  "fkaccuracy" BIGINT,
  "longpassing" BIGINT,
  "ballcontrol" BIGINT,
  "acceleration" BIGINT,
  "sprintspeed" BIGINT,
  "agility" BIGINT,
  "reactions" BIGINT,
  "balance" BIGINT,
  "shotpower" BIGINT,
  "jumping" BIGINT,
  "stamina" BIGINT,
  "strength" BIGINT,
  "longshots" BIGINT,
  "aggression" BIGINT,
  "interceptions" BIGINT,
  "positioning" BIGINT,
  "vision" BIGINT,
  "penalties" BIGINT,
  "composure" BIGINT,
  "marking" BIGINT,
  "standingtackle" BIGINT,
  "slidingtackle" BIGINT,
  "gkdiving" BIGINT,
  "gkhandling" BIGINT,
  "gkkicking" BIGINT,
  "gkpositioning" BIGINT,
  "gkreflexes" BIGINT,
  "strating" BIGINT,
  "lwrating" BIGINT,
  "lfrating" BIGINT,
  "cfrating" BIGINT,
  "rfrating" BIGINT,
  "rwrating" BIGINT,
  "camrating" BIGINT,
  "lmrating" BIGINT,
  "cmrating" BIGINT,
  "rmrating" BIGINT,
  "lwbrating" BIGINT,
  "cdmrating" BIGINT,
  "rwbrating" BIGINT,
  "lbrating" BIGINT,
  "cbrating" BIGINT,
  "rbrating" BIGINT,
  "gkrating" BIGINT
);

Teams Fifa21

@kaggle.cashncarry_fifa_21_players_teams_full_database.teams_fifa21

33.47 KB
731 rows
14 columns


CREATE TABLE teams_fifa21 (
  "id" BIGINT,
  "name" VARCHAR,
  "league" VARCHAR,
  "leagueid" BIGINT,
  "overall" BIGINT,
  "attack" BIGINT,
  "midfield" BIGINT,
  "defence" BIGINT,
  "transferbudget" BIGINT,
  "domesticprestige" BIGINT,
  "intprestige" BIGINT,
  "players" BIGINT,
  "startingaverageage" DOUBLE,
  "allteamaverageage" DOUBLE
);