Fifa Players' Ratings

Ratings of Tens of Thousands of Footballers

@kaggle.rishidamarla_fifa_players_ratings

Table List

1 table(2.01 MB)

Fifa Cleaned

@kaggle.rishidamarla_fifa_players_ratings.fifa_cleaned

2.01 MB
17954 rows
92 columns

id Id	name Name	full_name Full Name	birth_date Birth Date	age Age	height_cm Height Cm	weight_kgs Weight Kgs	positions Positions	nationality Nationality	overall_rating Overall Rating	potential Potential	value_euro Value Euro	wage_euro Wage Euro	preferred_foot Preferred Foot	international_reputation_1_5 International Reputation(1-5)	weak_foot_1_5 Weak Foot(1-5)	skill_moves_1_5 Skill Moves(1-5)	work_rate Work Rate	body_type Body Type	release_clause_euro Release Clause Euro	club_team Club Team	club_rating Club Rating	club_position Club Position	club_jersey_number Club Jersey Number	club_join_date Club Join Date	contract_end_year Contract End Year	national_team National Team	national_rating National Rating	national_team_position National Team Position	national_jersey_number National Jersey Number	crossing Crossing	finishing Finishing	heading_accuracy Heading Accuracy	short_passing Short Passing	volleys Volleys	dribbling Dribbling	curve Curve	freekick_accuracy Freekick Accuracy	long_passing Long Passing	ball_control Ball Control	acceleration Acceleration	sprint_speed Sprint Speed	agility Agility	reactions Reactions	balance Balance	shot_power Shot Power	jumping Jumping	stamina Stamina	strength Strength	long_shots Long Shots	aggression Aggression	interceptions Interceptions	positioning Positioning	vision Vision	penalties Penalties	composure Composure	marking Marking	standing_tackle Standing Tackle	sliding_tackle Sliding Tackle	gk_diving GK Diving	gk_handling GK Handling	gk_kicking GK Kicking	gk_positioning GK Positioning	gk_reflexes GK Reflexes	tags Tags	traits Traits	ls LS	st ST	rs RS	lw LW	lf LF	cf CF	rf RF	rw RW	lam LAM	cam CAM	ram RAM	lm LM	lcm LCM	cm CM	rcm RCM	rm RM	lwb LWB	ldm LDM	cdm CDM	rdm RDM	rwb RWB	lb LB	lcb LCB	cb CB	rcb RCB	rb RB
158023	L. Messi	Lionel Andrés Messi Cuccittini	Wed Jun 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	31	170.18	72.1	CF,RW,ST	Argentina	94	94	110500000	565000	Left	5	4	4	Medium/ Low	Messi	226500000	FC Barcelona	86	RW	10	Thu Jul 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	Argentina	82	RF	10	86	95	70	92	86	97	93	94	89	96	91	86	93	95	95	85	68	72	66	94	48	22	94	94	75	96	33	28	26	6	11	15	14	8	#Dribbler,#Distance Shooter,#Crosser,#FK Specialist,#Acrobat,#Clinical Finisher,#Complete Forward	Finesse Shot,Long Shot Taker (CPU AI Only),Speed Dribbler (CPU AI Only),Playmaker (CPU AI Only),One Club Player,Team Player,Chip Shot (CPU AI Only)	89+2	89+2	89+2	93+2	93+2	93+2	93+2	93+2	93+2	93+2	93+2	91+2	85+2	85+2	85+2	91+2	64+2	61+2	61+2	61+2	64+2	59+2	48+2	48+2	48+2	59+2
190460	C. Eriksen	Christian Dannemann Eriksen	Fri Feb 14 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	27	154.94	76.2	CAM,RM,CM	Denmark	88	89	69500000	205000	Right	3	5	4	High/ Medium	Lean	133800000	Tottenham Hotspur	83	LCM	23	Fri Aug 30 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	2020	Denmark	78	CAM	10	88	81	52	91	80	84	86	87	89	91	76	73	80	88	81	84	50	92	58	89	46	56	84	91	67	88	59	57	22	9	14	7	7	6	#Playmaker ,#Crosser,#FK Specialist,#Complete Midfielder	Flair,Long Shot Taker (CPU AI Only),Playmaker (CPU AI Only),Technical Dribbler (CPU AI Only),Takes Finesse Free Kicks	79+3	79+3	79+3	85+3	84+3	84+3	84+3	85+3	86+3	86+3	86+3	86+3	85+3	85+3	85+3	86+3	71+3	71+3	71+3	71+3	71+3	66+3	57+3	57+3	57+3	66+3
195864	P. Pogba	Paul Pogba	Mon Mar 15 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	25	190.5	83.9	CM,CAM	France	88	91	73000000	255000	Right	4	4	5	High/ Medium	Normal	144200000	Manchester United	82	LCM	6	Tue Aug 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	France	84	RDM	6	80	75	75	86	85	87	85	82	90	90	71	79	76	82	66	90	83	88	87	82	78	64	82	88	82	87	63	67	67	5	6	2	4	3	#Dribbler,#Playmaker ,#Strength,#Complete Midfielder	Flair,Long Passer (CPU AI Only),Long Shot Taker (CPU AI Only),Playmaker (CPU AI Only),Technical Dribbler (CPU AI Only)	81+3	81+3	81+3	82+3	83+3	83+3	83+3	82+3	84+3	84+3	84+3	83+3	84+3	84+3	84+3	83+3	76+3	77+3	77+3	77+3	76+3	74+3	72+3	72+3	72+3	74+3
198219	L. Insigne	Lorenzo Insigne	Tue Jun 04 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	27	162.56	59	LW,ST	Italy	88	88	62000000	165000	Right	3	4	4	High/ Medium	Normal	105400000	Napoli	82	LS	24	Thu Jul 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	Italy	83	LW	10	86	77	56	85	74	90	87	77	78	93	94	86	94	83	93	75	53	75	44	84	34	26	83	87	61	83	51	24	22	8	4	14	9	10	#Speedster,#Dribbler,#Crosser,#Acrobat	Finesse Shot,Long Shot Taker (CPU AI Only),Speed Dribbler (CPU AI Only),Takes Finesse Free Kicks	78+3	78+3	78+3	86+3	85+3	85+3	85+3	86+3	86+3	86+3	86+3	86+3	78+3	78+3	78+3	86+3	63+3	58+3	58+3	58+3	63+3	58+3	44+3	44+3	44+3	58+3
201024	K. Koulibaly	Kalidou Koulibaly	Thu Jun 20 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	27	187.96	88.9	CB	Senegal	88	91	60000000	135000	Right	3	3	2	High/ High	Normal	106500000	Napoli	82	LCB	26	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	nan		nan		30	22	83	68	14	69	28	28	60	63	70	75	50	82	40	55	81	75	94	15	87	88	24	49	33	80	91	88	87	7	11	7	13	5	#Tackling ,#Tactician ,#Strength,#Complete Defender	Power Header	53+3	53+3	53+3	53+3	54+3	54+3	54+3	53+3	55+3	55+3	55+3	57+3	61+3	61+3	61+3	57+3	73+3	77+3	77+3	77+3	73+3	76+3	85+3	85+3	85+3	76+3
203376	V. van Dijk	Virgil van Dijk	Mon Jul 08 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	27	193.04	92.1	CB	Netherlands	88	90	59500000	215000	Right	3	3	2	Medium/ Medium	Normal	114500000	Liverpool	83	LCB	4	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	Netherlands	81	LCB	4	53	52	83	79	45	70	60	70	81	76	74	77	61	87	49	81	88	75	92	64	82	88	41	60	62	87	90	89	84	13	10	13	11	11	#Tactician ,#Strength	Injury Free,Leadership,Power Header	68+3	68+3	68+3	66+3	67+3	67+3	67+3	66+3	68+3	68+3	68+3	68+3	73+3	73+3	73+3	68+3	78+3	82+3	82+3	82+3	78+3	80+3	86+3	86+3	86+3	80+3
231747	K. Mbappé	Kylian Mbappé	Sun Dec 20 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	20	152.4	73	RW,ST,RM	France	88	95	81000000	100000	Right	3	4	5	High/ Medium	Lean	166100000	Paris Saint-Germain	84	LS	7	Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	France	84	RM	10	77	88	77	82	78	90	77	63	73	91	96	96	92	87	83	79	75	83	71	78	62	38	88	82	70	86	34	34	32	13	5	7	11	6	#Speedster,#Dribbler,#Acrobat	Finesse Shot,Flair,Speed Dribbler (CPU AI Only),Technical Dribbler (CPU AI Only)	85+3	85+3	85+3	87+3	87+3	87+3	87+3	87+3	86+3	86+3	86+3	86+3	78+3	78+3	78+3	86+3	66+3	62+3	62+3	62+3	66+3	62+3	54+3	54+3	54+3	62+3
153079	S. Agüero	Sergio Leonel Agüero del Castillo	Thu Jun 02 1988 00:00:00 GMT+0000 (Coordinated Universal Time)	30	172.72	69.9	ST	Argentina	89	89	64500000	300000	Right	4	4	4	High/ Medium	Stocky	119300000	Manchester City	85	ST	10	Thu Jul 28 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	Argentina	82	SUB	11	70	93	77	81	85	89	82	73	64	89	88	80	86	90	91	88	81	76	73	83	65	24	92	83	83	90	30	20	12	13	15	6	11	14	#Dribbler,#Acrobat,#Clinical Finisher,#Complete Forward	Beat Offside Trap,Leadership,Chip Shot (CPU AI Only),Technical Dribbler (CPU AI Only)	86+3	86+3	86+3	86+3	87+3	87+3	87+3	86+3	85+3	85+3	85+3	83+3	76+3	76+3	76+3	83+3	58+3	56+3	56+3	56+3	58+3	53+3	47+3	47+3	47+3	53+3
167495	M. Neuer	Manuel Neuer	Thu Mar 27 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	32	193.04	92.1	GK	Germany	89	89	38000000	130000	Right	5	4	1	Medium/ Medium	Normal	62700000	FC Bayern München	85	GK	1	Fri Jul 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	Germany	85	GK	1	15	13	25	55	11	30	14	11	59	46	54	60	51	84	35	25	77	43	80	16	29	30	12	70	47	70	17	10	11	90	86	91	87	87	nan	GK Long Throw,1-on-1 Rush,Rushes Out Of Goal,Comes For Crosses	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
179813	E. Cavani	Edinson Roberto Cavani Gómez	Sat Feb 14 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	32	185.42	77.1	ST	Uruguay	89	89	60000000	200000	Right	4	4	3	High/ High	Lean	111000000	Paris Saint-Germain	84	RS	9	Tue Jul 16 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	2020	Uruguay	81	LS	21	70	89	89	78	90	80	77	76	52	82	75	76	77	91	59	87	88	92	78	79	84	48	93	77	85	82	52	45	39	12	5	13	13	10	#Engine	Beat Offside Trap,Power Header	85+3	85+3	85+3	81+3	83+3	83+3	83+3	81+3	80+3	80+3	80+3	79+3	75+3	75+3	75+3	79+3	67+3	65+3	65+3	65+3	67+3	65+3	63+3	63+3	63+3	65+3


CREATE TABLE fifa_cleaned (
  "id" BIGINT,
  "name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" BIGINT,
  "height_cm" DOUBLE,
  "weight_kgs" DOUBLE,
  "positions" VARCHAR,
  "nationality" VARCHAR,
  "overall_rating" BIGINT,
  "potential" BIGINT,
  "value_euro" DOUBLE,
  "wage_euro" DOUBLE,
  "preferred_foot" VARCHAR,
  "international_reputation_1_5" BIGINT,
  "weak_foot_1_5" BIGINT,
  "skill_moves_1_5" BIGINT,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "release_clause_euro" DOUBLE,
  "club_team" VARCHAR,
  "club_rating" DOUBLE,
  "club_position" VARCHAR,
  "club_jersey_number" DOUBLE,
  "club_join_date" TIMESTAMP,
  "contract_end_year" VARCHAR,
  "national_team" VARCHAR,
  "national_rating" DOUBLE,
  "national_team_position" VARCHAR,
  "national_jersey_number" DOUBLE,
  "crossing" BIGINT,
  "finishing" BIGINT,
  "heading_accuracy" BIGINT,
  "short_passing" BIGINT,
  "volleys" BIGINT,
  "dribbling" BIGINT,
  "curve" BIGINT,
  "freekick_accuracy" BIGINT,
  "long_passing" BIGINT,
  "ball_control" BIGINT,
  "acceleration" BIGINT,
  "sprint_speed" BIGINT,
  "agility" BIGINT,
  "reactions" BIGINT,
  "balance" BIGINT,
  "shot_power" BIGINT,
  "jumping" BIGINT,
  "stamina" BIGINT,
  "strength" BIGINT,
  "long_shots" BIGINT,
  "aggression" BIGINT,
  "interceptions" BIGINT,
  "positioning" BIGINT,
  "vision" BIGINT,
  "penalties" BIGINT,
  "composure" BIGINT,
  "marking" BIGINT,
  "standing_tackle" BIGINT,
  "sliding_tackle" BIGINT,
  "gk_diving" BIGINT,
  "gk_handling" BIGINT,
  "gk_kicking" BIGINT,
  "gk_positioning" BIGINT,
  "gk_reflexes" BIGINT,
  "tags" VARCHAR,
  "traits" VARCHAR,
  "ls" VARCHAR,
  "st" VARCHAR,
  "rs" VARCHAR,
  "lw" VARCHAR,
  "lf" VARCHAR,
  "cf" VARCHAR,
  "rf" VARCHAR,
  "rw" VARCHAR,
  "lam" VARCHAR,
  "cam" VARCHAR,
  "ram" VARCHAR,
  "lm" VARCHAR,
  "lcm" VARCHAR,
  "cm" VARCHAR,
  "rcm" VARCHAR,
  "rm" VARCHAR,
  "lwb" VARCHAR,
  "ldm" VARCHAR,
  "cdm" VARCHAR,
  "rdm" VARCHAR,
  "rwb" VARCHAR,
  "lb" VARCHAR,
  "lcb" VARCHAR,
  "cb" VARCHAR,
  "rcb" VARCHAR,
  "rb" VARCHAR
);