Baselight
Sign In

FIFA23 OFFICIAL DATASET(CLEAN DATA)

CLEAN FIFA DATASET: From 2017-2023

@kaggle.kevwesophia_fifa23_official_datasetclean_data

Clean Fifa17 Official Data
@kaggle.kevwesophia_fifa23_official_datasetclean_data.clean_fifa17_official_data

  • 1.44 MB
  • 17560 rows
  • 65 columns
unnamed_0

Unnamed: 0

id

ID

name

Name

age

Age

photo

Photo

nationality

Nationality

flag

Flag

overall

Overall

potential

Potential

club

Club

club_logo

Club Logo

value

Value(£)

wage

Wage(£)

special

Special

preferred_foot

Preferred Foot

international_reputation

International Reputation

weak_foot

Weak Foot

skill_moves

Skill Moves

work_rate

Work Rate

body_type

Body Type

real_face

Real Face

position

Position

jersey_number

Jersey Number

joined

Joined

loaned_from

Loaned From

contract_valid_until

Contract Valid Until

height_cm

Height(cm.)

weight_lbs

Weight(lbs.)

crossing

Crossing

finishing

Finishing

headingaccuracy

HeadingAccuracy

shortpassing

ShortPassing

volleys

Volleys

dribbling

Dribbling

curve

Curve

fkaccuracy

FKAccuracy

longpassing

LongPassing

ballcontrol

BallControl

acceleration

Acceleration

sprintspeed

SprintSpeed

agility

Agility

reactions

Reactions

balance

Balance

shotpower

ShotPower

jumping

Jumping

stamina

Stamina

strength

Strength

longshots

LongShots

aggression

Aggression

interceptions

Interceptions

positioning

Positioning

vision

Vision

penalties

Penalties

composure

Composure

marking

Marking

standingtackle

StandingTackle

slidingtackle

SlidingTackle

gkdiving

GKDiving

gkhandling

GKHandling

gkkicking

GKKicking

gkpositioning

GKPositioning

gkreflexes

GKReflexes

best_position

Best Position

best_overall_rating

Best Overall Rating

year_joined

Year Joined

176580L. Suárez29https://cdn.sofifa.com/players/176/580/17_60.pngUruguayhttps://cdn.sofifa.com/flags/uy.png9292FC Barcelonahttps://cdn.sofifa.com/teams/241/light_30.png830000005250002291Right544High/ MediumNormal (170-185)YesST9Fri Jul 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)nan2021182.8819077947783888686846491887786936087698980867841928485833045382725313337ST882014
1178518R. Nainggolan28https://cdn.sofifa.com/players/178/518/17_60.pngBelgiumhttps://cdn.sofifa.com/flags/be.png8686Romahttps://cdn.sofifa.com/teams/52/light_30.png375000001300002290Right333High/ HighStocky (170-185)NoLF4Tue Jan 07 2014 00:00:00 GMT+0000 (Coordinated Universal Time)nan2021175.261437376598475807368818581788187848476947886888688766385788588111114811CDM842014
2181872A. Vidal29https://cdn.sofifa.com/players/181/872/17_60.pngChilehttps://cdn.sofifa.com/flags/cl.png8787FC Bayern Münchenhttps://cdn.sofifa.com/teams/21/light_30.png415000001800002285Right443High/ HighNormal (170-185)YesLDM23Tue Jul 28 2015 00:00:00 GMT+0000 (Coordinated Universal Time)nan2019180.34165767781847876766882837774758977848293798591898080848676898442424CDM852015
3197445D. Alaba24https://cdn.sofifa.com/players/197/445/17_60.pngAustriahttps://cdn.sofifa.com/flags/at.png8689FC Bayern Münchenhttps://cdn.sofifa.com/teams/21/light_30.png415000001400002279Left443High/ MediumLean (170-185)YesLB27Wed Feb 10 2010 00:00:00 GMT+0000 (Coordinated Universal Time)nan2021180.3416882637583687978838083868682847783828769836985777880798183835714159LB842010
4195864P. Pogba23https://cdn.sofifa.com/players/195/864/17_60.pngFrancehttps://cdn.sofifa.com/flags/fr.png8894Manchester Unitedhttps://cdn.sofifa.com/teams/11/light_30.png715000002250002271Right445High/ MediumLean (185+)YesLDM6Tue Aug 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)nan2021190.5185787173858489848288907579798661908591918772708487768368737356243CAM852016
5173731G. Bale26https://cdn.sofifa.com/players/173/731/17_60.pngWaleshttps://cdn.sofifa.com/flags/gb-wls.png9090Real Madridhttps://cdn.sofifa.com/teams/243/light_30.png720000003750002266Left434High/ MediumLean (170-185)YesRW11Mon Sep 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)nan2022182.88163878786867689868580889395778765918578809065598679768551555215151156ST882013
6203551A. Florenzi25https://cdn.sofifa.com/players/203/551/17_60.pngItalyhttps://cdn.sofifa.com/flags/it.png8285Romahttps://cdn.sofifa.com/teams/52/light_30.png20500000700002264Right333High/ MediumLean (170-185)NoSUB24Thu Jul 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)nan2019172.72148777670828779737975838684877984827492688279768275767973797798101110RB812010
7163631L. Baines31https://cdn.sofifa.com/players/163/631/17_60.pngEnglandhttps://cdn.sofifa.com/flags/gb-eng.png8383Evertonhttps://cdn.sofifa.com/teams/7/light_30.png145000001000002245Left333High/ MediumNormal (170-)YesLB3Tue Aug 07 2007 00:00:00 GMT+0000 (Coordinated Universal Time)nan2019170.181548870748163788182747976757580858472866975748075769081818282815101312LWB812007
8177003L. Modrić30https://cdn.sofifa.com/players/177/003/17_60.pngCroatiahttps://cdn.sofifa.com/flags/hr.png8989Real Madridhttps://cdn.sofifa.com/teams/243/light_30.png540000003250002231Right444High/ MediumLean (170-185)YesRCM19Wed Aug 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)nan2020175.2614378715592748679778392777193889473678358826276799080766680731397149CM862012
920801Cristiano Ronaldo31https://cdn.sofifa.com/players/020/801/17_60.pngPortugalhttps://cdn.sofifa.com/flags/pt.png9494Real Madridhttps://cdn.sofifa.com/teams/243/light_30.png870000005750002223Right545High/ LowC. RonaldoYesLW7Wed Jul 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)nan2021185.421768493858388928176779391929096639295928090632994858586223123711151411ST912009

CREATE TABLE clean_fifa17_official_data (
  "unnamed_0" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "age" BIGINT,
  "photo" VARCHAR,
  "nationality" VARCHAR,
  "flag" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "club" VARCHAR,
  "club_logo" VARCHAR,
  "value" DOUBLE,
  "wage" DOUBLE,
  "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" DOUBLE,
  "height_cm" DOUBLE,
  "weight_lbs" 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,
  "best_position" VARCHAR,
  "best_overall_rating" DOUBLE,
  "year_joined" BIGINT
);

Share link

Anyone who has the link will be able to view this.