FIFA23 OFFICIAL DATASET(CLEAN DATA)

CLEAN FIFA DATASET: From 2017-2023

@kaggle.kevwesophia_fifa23_official_datasetclean_data

Table List

7 tables(9.77 MB)

Clean Fifa17 Official Data

Clean Fifa18 Official Data

Clean Fifa19 Official Data

Clean Fifa20 Official Data

Clean Fifa21 Official Data

Clean Fifa22 Official Data

Clean Fifa23 Official Data

Clean Fifa19 Official Data

@kaggle.kevwesophia_fifa23_official_datasetclean_data.clean_fifa19_official_data

1.5 MB
17943 rows
66 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	release_clause Release Clause(£)	year_joined Year Joined
	176580	L. Suárez	31	https://cdn.sofifa.com/players/176/580/19_60.png	Uruguay	https://cdn.sofifa.com/flags/uy.png	91	91	FC Barcelona	https://cdn.sofifa.com/teams/241/light_30.png	80000000	450000	2349	Right	5	4	3	High/ Medium	Normal (170-185)	Yes	ST	9	Fri Jul 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	182.88	190	77	92	82	82	90	86	86	84	69	88	83	73	82	92	83	86	69	90	83	85	87	41	92	84	85	85	62	45	38	27	25	31	33	37	ST	87	164000000	2014
1	194765	A. Griezmann	27	https://cdn.sofifa.com/players/194/765/19_60.png	France	https://cdn.sofifa.com/flags/fr.png	89	89	Atlético Madrid	https://cdn.sofifa.com/teams/240/light_30.png	71000000	140000	2293	Left	4	3	4	High/ High	Lean (170-185)	Yes	RS	7	Mon Jul 28 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2023	175.26	161	82	89	84	84	87	87	86	84	78	90	88	85	90	90	82	82	90	86	62	82	73	49	91	85	83	89	59	54	48	14	8	14	13	14	LW	87	145600000	2014
2	177003	L. Modrić	32	https://cdn.sofifa.com/players/177/003/19_60.png	Croatia	https://cdn.sofifa.com/flags/hr.png	91	91	Real Madrid	https://cdn.sofifa.com/teams/243/light_30.png	67000000	425000	2284	Right	4	4	4	High/ High	Lean (170-185)	Yes	RCM	10	Wed Aug 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2020	172.72	146	86	72	55	93	76	90	85	78	88	92	78	72	92	90	94	79	68	89	58	82	62	83	79	92	82	92	68	76	73	13	9	7	14	9	CM	88	137400000	2012
3	224334	M. Acuña	26	https://cdn.sofifa.com/players/224/334/19_60.png	Argentina	https://cdn.sofifa.com/flags/ar.png	81	81	Sporting CP	https://cdn.sofifa.com/teams/237/light_30.png	19000000	20000	2281	Left	2	3	4	High/ High	Stocky (170-185)	No	SUB	8	Mon Sep 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2026	172.72	152	87	66	63	78	68	87	87	78	76	85	79	75	84	80	86	83	69	90	84	84	88	76	77	82	74	88	78	80	75	8	14	13	13	14	LM	81	38000000	2019
4	192985	K. De Bruyne	27	https://cdn.sofifa.com/players/192/985/19_60.png	Belgium	https://cdn.sofifa.com/flags/be.png	91	91	Manchester City	https://cdn.sofifa.com/teams/10/light_30.png	93000000	350000	2279	Right	4	5	4	High/ High	Normal (170-185)	Yes	RCM	17	Sun Aug 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2023	180.34	154	93	82	55	92	82	86	85	83	91	91	78	76	79	91	77	91	63	89	75	90	76	61	87	94	79	90	68	58	51	15	13	5	10	13	CAM	89	172100000	2015
5	178518	R. Nainggolan	30	https://cdn.sofifa.com/players/178/518/19_60.png	Belgium	https://cdn.sofifa.com/flags/be.png	85	85	Inter	https://cdn.sofifa.com/teams/44/light_30.png	35500000	100000	2278	Right	3	3	3	High/ High	Stocky (170-185)	Yes	CAM	14	Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2022	175.26	170	73	75	59	84	75	80	73	68	81	85	78	73	76	87	82	84	76	93	77	86	88	86	86	76	63	84	83	86	90	11	11	14	8	11	CDM	85	60400000	2018
6	212198	Bruno Fernandes	23	https://cdn.sofifa.com/players/212/198/19_60.png	Portugal	https://cdn.sofifa.com/flags/pt.png	85	89	Sporting CP	https://cdn.sofifa.com/teams/237/light_30.png	50000000	20000	2277	Right	2	4	4	High/ High	Lean (170-185)	No	SUB	10	Mon Sep 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2026	177.8	152	85	78	58	85	86	85	86	87	86	87	79	76	78	84	79	89	72	91	67	88	70	74	81	88	86	86	68	64	57	12	14	15	8	14	CAM	84	103800000	2019
7	176676	Marcelo	30	https://cdn.sofifa.com/players/176/676/19_60.png	Brazil	https://cdn.sofifa.com/flags/br.png	86	86	Real Madrid	https://cdn.sofifa.com/teams/243/light_30.png	32000000	225000	2272	Left	4	4	5	High/ Low	Normal (170-185)	Yes	LB	12	Mon Jan 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2022	175.26	176	89	73	75	84	61	90	85	67	78	92	83	82	86	85	86	83	76	87	78	70	84	82	85	82	59	86	71	81	82	12	5	5	5	9	LM	85	65599999.99999999	2007
8	212462	Alex Telles	25	https://cdn.sofifa.com/players/212/462/19_60.png	Brazil	https://cdn.sofifa.com/flags/br.png	84	86	FC Porto	https://cdn.sofifa.com/teams/236/light_30.png	31000000	20000	2267	Left	3	2	3	High/ Medium	Lean (170-185)	Yes	LB	13	Wed Jul 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	180.34	157	89	65	74	83	67	82	87	79	86	82	84	85	73	83	70	80	81	92	68	75	78	80	76	74	76	80	80	81	79	13	8	12	11	14	LWB	83	64300000	2016
9	173731	G. Bale	28	https://cdn.sofifa.com/players/173/731/19_60.png	Wales	https://cdn.sofifa.com/flags/gb-wls.png	86	86	Real Madrid	https://cdn.sofifa.com/teams/243/light_30.png	45000000	275000	2266	Left	4	3	4	Medium/ Medium	Lean (170-185)	Yes	SUB	11	Mon Sep 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2022	185.42	181	87	85	84	82	85	84	90	87	80	85	92	94	80	85	65	92	87	75	80	90	65	59	85	79	76	86	54	55	52	15	15	11	5	6	ST	86	92300000	2013


CREATE TABLE clean_fifa19_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,
  "release_clause" DOUBLE,
  "year_joined" BIGINT
);