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 Fifa20 Official Data

@kaggle.kevwesophia_fifa23_official_datasetclean_data.clean_fifa20_official_data

1.46 MB
17104 rows
67 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	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(£)	defensiveawareness DefensiveAwareness	year_joined Year Joined
	176580	L. Suárez	32	https://cdn.sofifa.com/players/176/580/20_60.png	Uruguay	https://cdn.sofifa.com/flags/uy.png	89	89	FC Barcelona	https://cdn.sofifa.com/teams/241/light_30.png	53000000	350000	2327	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	80	91	83	82	90	85	86	82	77	84	76	70	79	92	79	88	69	82	86	86	87	41	92	84	83	85	45	38	27	25	31	33	37	ST	89	108700000	57	2014
1	194765	A. Griezmann	28	https://cdn.sofifa.com/players/194/765/20_60.png	France	https://cdn.sofifa.com/flags/fr.png	89	89	FC Barcelona	https://cdn.sofifa.com/teams/241/light_30.png	69000000	370000	2299	Left	4	3	4	High/ High	Normal (170-185)	Yes	LW	17	Fri Jul 12 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2024	175.26	161	83	89	84	85	87	88	86	85	82	90	82	79	90	92	83	82	90	87	63	83	73	49	90	86	86	89	54	49	14	8	14	13	14	CF	89	141500000	59	2019
2	212198	Bruno Fernandes	24	https://cdn.sofifa.com/players/212/198/20_60.png	Portugal	https://cdn.sofifa.com/flags/pt.png	86	89	Manchester United	https://cdn.sofifa.com/teams/11/light_30.png	56500000	165000	2299	Right	2	4	4	High/ High	Lean (170-185)	No	CAM	18	Thu Jan 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2025	177.8	152	87	77	58	86	86	85	86	87	87	87	79	77	80	84	79	89	72	94	67	89	70	74	83	88	90	86	68	55	12	14	15	8	14	CAM	87	111600000	72	2020
3	192985	K. De Bruyne	28	https://cdn.sofifa.com/players/192/985/20_60.png	Belgium	https://cdn.sofifa.com/flags/be.png	91	91	Manchester City	https://cdn.sofifa.com/teams/10/light_30.png	90000000	370000	2289	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	94	82	55	92	82	87	85	83	91	91	77	76	78	91	76	91	63	89	74	90	76	63	88	94	82	91	62	53	15	13	5	10	13	CAM	91	166500000	68	2015
4	224334	M. Acuña	27	https://cdn.sofifa.com/players/224/334/20_60.png	Argentina	https://cdn.sofifa.com/flags/ar.png	82	82	Sporting CP	https://cdn.sofifa.com/teams/237/light_30.png	20000000	19000	2285	Left	2	3	4	High/ High	Stocky (170-185)	No	LCM	8	Tue May 05 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2028	172.72	152	87	66	57	81	68	87	88	78	78	87	78	75	83	83	90	82	63	90	80	81	84	78	81	82	76	87	82	79	8	14	13	13	14	LB	82	40000000	79	2020
5	212462	Alex Telles	26	https://cdn.sofifa.com/players/212/462/20_60.png	Brazil	https://cdn.sofifa.com/flags/br.png	84	85	FC Porto	https://cdn.sofifa.com/teams/236/light_30.png	31500000	23000	2283	Left	3	2	3	High/ High	Lean (170-185)	Yes	LB	13	Wed Jul 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	180.34	157	90	65	67	84	67	82	87	79	87	83	84	85	73	83	70	87	80	91	68	83	78	80	75	76	81	78	81	79	13	8	12	11	14	LWB	85	65400000.00000001	80	2016
6	187961	Paulinho	30	https://cdn.sofifa.com/players/187/961/20_60.png	Brazil	https://cdn.sofifa.com/flags/br.png	85	85	Guangzhou Evergrande Taobao FC	https://cdn.sofifa.com/teams/111839/light_30.png	35500000	47000	2278	Right	3	4	4	High/ High	Normal (170-185)	Yes	LDM	8	Tue Jan 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2023	182.88	176	67	85	85	83	75	83	66	75	77	84	74	71	70	82	81	83	92	92	82	80	81	80	84	84	71	81	79	75	16	16	11	6	8	CM	85	56800000	80	2019
7	178518	R. Nainggolan	31	https://cdn.sofifa.com/players/178/518/20_60.png	Belgium	https://cdn.sofifa.com/flags/be.png	84	84	Cagliari	https://cdn.sofifa.com/teams/1842/light_30.png	27500000	57000	2271	Right	3	3	3	High/ High	Stocky (170-185)	Yes	RF	4	Tue May 05 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Inter	2020	175.26	143	73	75	59	85	75	83	73	68	82	84	72	72	75	85	83	84	75	89	76	88	88	86	84	80	63	84	86	90	11	11	14	8	11	CDM	85	1400000	83	2020
8	197445	D. Alaba	27	https://cdn.sofifa.com/players/197/445/20_60.png	Austria	https://cdn.sofifa.com/flags/at.png	83	84	FC Bayern München	https://cdn.sofifa.com/teams/21/light_30.png	26000000	110000	2266	Left	4	4	3	Medium/ Medium	Lean (170-185)	Yes	LCB	27	Wed Feb 10 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	180.34	172	82	63	76	82	68	79	78	85	79	82	79	85	78	84	78	85	83	85	75	80	69	82	76	77	79	80	82	82	5	7	14	15	9	CB	83	44900000	83	2010
9	181872	A. Vidal	32	https://cdn.sofifa.com/players/181/872/20_60.png	Chile	https://cdn.sofifa.com/flags/cl.png	84	84	FC Barcelona	https://cdn.sofifa.com/teams/241/light_30.png	23500000	200000	2264	Right	4	4	3	High/ High	Normal (170-185)	Yes	SUB	22	Mon Aug 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	180.34	165	76	75	82	82	78	76	76	68	81	82	68	67	73	86	77	84	85	86	83	82	93	85	83	82	81	83	87	88	4	2	4	2	4	CB	85	48200000	82	2018


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