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

@kaggle.kevwesophia_fifa23_official_datasetclean_data.clean_fifa21_official_data

1.46 MB
17108 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	33	https://cdn.sofifa.com/players/176/580/20_60.png	Uruguay	https://cdn.sofifa.com/flags/uy.png	87	87	Atlético Madrid	https://cdn.sofifa.com/teams/240/light_30.png	31500000	115000	2316	Right	5	4	3	High/ Medium	PLAYER_BODY_TYPE_374	Yes	RS	9	Fri Sep 25 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2022	182.88	190	80	92	84	83	90	84	86	82	77	84	72	68	76	92	78	89	69	78	85	88	87	41	91	84	83	85	45	38	27	25	31	33	37	ST	87	64599999.99999999	57	2020
1	192985	K. De Bruyne	29	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	87000000	370000	2304	Right	4	5	4	High/ High	PLAYER_BODY_TYPE_321	Yes	RCM	17	Sun Aug 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2023	180.34	154	94	82	55	94	82	88	85	83	93	92	77	76	78	91	76	91	63	89	74	91	76	66	88	94	84	91	65	53	15	13	5	10	13	CAM	91	161000000	68	2015
2	212198	Bruno Fernandes	25	https://cdn.sofifa.com/players/212/198/20_60.png	Portugal	https://cdn.sofifa.com/flags/pt.png	87	90	Manchester United	https://cdn.sofifa.com/teams/11/light_30.png	63000000	195000	2303	Right	2	4	4	High/ High	Lean (170-185)	Yes	CAM	18	Thu Jan 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2025	177.8	152	87	77	58	88	86	85	86	87	87	88	78	76	79	86	79	89	72	94	67	89	70	74	83	90	91	86	67	55	12	14	15	8	14	CAM	88	124400000	72	2020
3	194765	A. Griezmann	29	https://cdn.sofifa.com/players/194/765/20_60.png	France	https://cdn.sofifa.com/flags/fr.png	87	87	FC Barcelona	https://cdn.sofifa.com/teams/241/light_30.png	50500000	290000	2288	Left	4	3	4	Medium/ Medium	PLAYER_BODY_TYPE_266	Yes	RW	7	Fri Jul 12 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2024	175.26	161	83	88	83	84	87	87	86	85	82	89	80	79	91	92	83	81	90	86	63	82	73	49	89	85	86	89	54	49	14	8	14	13	14	ST	87	103500000	59	2019
4	224334	M. Acuña	28	https://cdn.sofifa.com/players/224/334/20_60.png	Argentina	https://cdn.sofifa.com/flags/ar.png	83	83	Sevilla FC	https://cdn.sofifa.com/teams/481/light_30.png	22000000	41000	2280	Left	2	3	4	High/ High	Stocky (170-185)	No	LB	19	Mon Sep 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2024	172.72	152	87	66	57	81	68	87	88	75	78	87	77	75	82	83	90	82	63	90	80	81	84	78	81	82	76	87	82	79	8	14	13	13	14	LB	83	46200000	79	2020
5	212462	Alex Telles	27	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	31000000	23000	2280	Left	3	2	3	High/ High	PLAYER_BODY_TYPE_286	Yes	LB	13	Wed Jul 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	180.34	157	89	65	67	83	67	82	87	79	87	82	84	85	73	83	70	87	80	91	68	83	78	80	75	76	81	78	81	79	13	8	12	11	14	LB	84	64300000	80	2016
6	187961	Paulinho	31	https://cdn.sofifa.com/players/187/961/20_60.png	Brazil	https://cdn.sofifa.com/flags/br.png	83	83	Guangzhou Evergrande Taobao FC	https://cdn.sofifa.com/teams/111839/light_30.png	22000000	39000	2279	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	84	85	82	75	82	66	75	76	83	74	71	73	82	85	83	92	92	82	80	81	80	84	83	71	81	79	75	16	16	11	6	8	CM	83	35200000	80	2019
7	178518	R. Nainggolan	32	https://cdn.sofifa.com/players/178/518/20_60.png	Belgium	https://cdn.sofifa.com/flags/be.png	83	83	Inter	https://cdn.sofifa.com/teams/44/light_30.png	20000000	125000	2270	Right	3	3	3	High/ High	PLAYER_BODY_TYPE_282	Yes	SUB	44	Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2022	175.26	143	73	75	59	85	75	83	73	68	82	84	71	71	75	85	83	86	74	89	75	89	88	86	84	80	63	84	86	90	11	11	14	8	11	CDM	85	33000000	83	2018
8	212622	J. Kimmich	25	https://cdn.sofifa.com/players/212/622/20_60.png	Germany	https://cdn.sofifa.com/flags/de.png	88	90	FC Bayern München	https://cdn.sofifa.com/teams/21/light_30.png	65000000	145000	2269	Right	3	4	3	High/ Medium	Lean (170-185)	Yes	RDM	6	Wed Jul 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2023	175.26	161	91	66	72	87	67	83	85	61	86	85	77	66	84	88	84	78	79	95	67	84	89	82	80	84	44	85	84	79	8	15	7	15	15	CDM	88	112100000	82	2015
9	181291	G. Wijnaldum	29	https://cdn.sofifa.com/players/181/291/20_60.png	Netherlands	https://cdn.sofifa.com/flags/nl.png	85	85	Liverpool	https://cdn.sofifa.com/teams/9/light_30.png	37000000	150000	2267	Right	3	4	4	High/ High	PLAYER_BODY_TYPE_308	Yes	LCM	5	Fri Jul 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	175.26	152	72	75	78	88	73	85	78	73	81	88	77	76	84	86	88	78	81	93	74	73	75	79	79	79	74	86	79	69	16	6	14	12	6	CM	85	68500000	78	2016


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