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

@kaggle.kevwesophia_fifa23_official_datasetclean_data.clean_fifa18_official_data

1.5 MB
17927 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	30	https://cdn.sofifa.com/players/176/580/18_60.png	Uruguay	https://cdn.sofifa.com/flags/uy.png	92	92	FC Barcelona	https://cdn.sofifa.com/teams/241/light_30.png	97000000	500000	2321	Right	5	4	4	High/ Medium	Normal (170-185)	Yes	LS	9	Fri Jul 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	182.88	190	77	94	77	83	88	86	86	84	64	91	88	77	86	93	78	87	69	89	83	86	87	41	92	84	85	85	30	45	38	27	25	31	33	37	CF	88	198900000	2014
1	178518	R. Nainggolan	29	https://cdn.sofifa.com/players/178/518/18_60.png	Belgium	https://cdn.sofifa.com/flags/be.png	86	86	Roma	https://cdn.sofifa.com/teams/52/light_30.png	42500000	130000	2286	Right	3	3	3	High/ High	Stocky (170-185)	Yes	RCM	4	Tue Jan 07 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	175.26	170	73	76	59	84	75	80	73	68	81	85	80	76	81	87	84	84	76	94	76	86	88	86	88	76	63	84	78	86	88	11	11	14	8	11	CDM	84	72300000	2014
2	203551	A. Florenzi	26	https://cdn.sofifa.com/players/203/551/18_60.png	Italy	https://cdn.sofifa.com/flags/it.png	82	83	Roma	https://cdn.sofifa.com/teams/52/light_30.png	21000000	70000	2267	Right	3	3	3	High/ Medium	Lean (170-185)	Yes	RB	24	Thu Jul 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2023	172.72	148	77	76	70	82	87	79	73	79	75	84	86	84	87	79	84	82	74	90	68	82	79	77	82	76	76	80	74	79	78	9	8	10	11	10	CF	81	37300000	2010
3	197445	D. Alaba	25	https://cdn.sofifa.com/players/197/445/18_60.png	Austria	https://cdn.sofifa.com/flags/at.png	85	87	FC Bayern München	https://cdn.sofifa.com/teams/21/light_30.png	38500000	130000	2263	Left	4	4	3	High/ Medium	Lean (170-185)	Yes	LB	27	Wed Feb 10 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	180.34	168	81	63	75	82	68	79	78	85	80	83	86	81	79	84	77	83	82	87	69	83	69	84	77	78	80	79	78	82	80	5	7	14	15	9	LB	82	66400000.00000001	2010
4	195864	P. Pogba	24	https://cdn.sofifa.com/players/195/864/18_60.png	France	https://cdn.sofifa.com/flags/fr.png	88	92	Manchester United	https://cdn.sofifa.com/teams/11/light_30.png	76000000	250000	2262	Right	4	4	5	High/ Low	Lean (185+)	Yes	LCM	6	Tue Aug 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	190.5	185	80	73	75	87	85	87	84	82	88	89	75	78	76	84	63	90	85	91	91	82	78	70	83	88	76	87	64	70	68	5	6	2	4	3	CM	85	146300000	2016
5	173731	G. Bale	27	https://cdn.sofifa.com/players/173/731/18_60.png	Wales	https://cdn.sofifa.com/flags/gb-wls.png	88	88	Real Madrid	https://cdn.sofifa.com/teams/243/light_30.png	62000000	375000	2260	Left	4	3	4	High/ Medium	Lean (170-185)	Yes	RW	11	Mon Sep 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2022	185.42	179	86	87	86	85	80	87	86	85	80	85	93	95	78	85	65	91	85	76	80	90	65	59	86	79	76	85	51	55	52	15	15	11	5	6	ST	87	127100000	2013
6	181872	A. Vidal	30	https://cdn.sofifa.com/players/181/872/18_60.png	Chile	https://cdn.sofifa.com/flags/cl.png	86	86	FC Bayern München	https://cdn.sofifa.com/teams/21/light_30.png	33000000	160000	2253	Right	4	4	3	High/ High	Normal (170-185)	Yes	SUB	23	Tue Jul 28 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2019	180.34	165	76	77	82	84	78	76	76	68	81	83	65	60	75	87	77	86	85	88	77	85	93	85	81	80	81	86	76	89	86	4	2	4	2	4	CDM	84	54500000	2015
7	192985	K. De Bruyne	26	https://cdn.sofifa.com/players/192/985/18_60.png	Belgium	https://cdn.sofifa.com/flags/be.png	91	92	Manchester City	https://cdn.sofifa.com/teams/10/light_30.png	104500000	400000	2234	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	150	92	83	54	91	82	86	85	83	87	90	78	76	82	90	79	89	65	88	73	88	73	60	86	92	77	86	40	58	51	15	13	5	10	13	CAM	88	201200000	2015
8	189332	Jordi Alba	28	https://cdn.sofifa.com/players/189/332/18_60.png	Spain	https://cdn.sofifa.com/flags/es.png	87	87	FC Barcelona	https://cdn.sofifa.com/teams/241/light_30.png	40000000	250000	2231	Left	3	3	3	High/ Medium	Normal (170-)	Yes	LB	18	Sun Jul 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2020	170.18	150	85	73	69	83	60	80	77	64	74	83	93	93	90	82	86	64	81	90	60	66	75	85	78	70	59	76	83	84	84	13	15	13	6	13	LWB	85	82000000	2012
9	185103	A. Kolarov	31	https://cdn.sofifa.com/players/185/103/18_60.png	Serbia	https://cdn.sofifa.com/flags/rs.png	81	81	Roma	https://cdn.sofifa.com/teams/52/light_30.png	11500000	70000	2231	Left	2	3	2	High/ Medium	Normal (185+)	Yes	LB	11	Sat Jul 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2020	187.96	183	90	55	80	77	64	79	85	86	77	76	74	73	63	84	58	91	81	85	78	83	85	80	75	77	74	87	77	82	81	16	15	8	16	6	LB	81	19600000	2017


CREATE TABLE clean_fifa18_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
);