Football (FIFA - 2019) Dataset

Football (FIFA-2019) World Cup Dataset of Players' Statistics with Notebook

@kaggle.devansodariya_football_fifa_2019_dataset

Table List

2 tables(3.87 MB)

Fifa 2019

Fifa 2019

@kaggle.devansodariya_football_fifa_2019_dataset.fifa_2019

1.91 MB
18207 rows
89 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 Height	weight Weight	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	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	release_clause Release Clause
	158023	L. Messi	31	https://cdn.sofifa.org/players/4/19/158023.png	Argentina	https://cdn.sofifa.org/flags/52.png	94	94	FC Barcelona	https://cdn.sofifa.org/teams/2/light/241.png	€110.5M	€565K	2202	Left	5	4	4	Medium/ Medium	Messi	Yes	RF	10	Thu Jul 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	5'7	159lbs	88+2	88+2	88+2	92+2	93+2	93+2	93+2	92+2	93+2	93+2	93+2	91+2	84+2	84+2	84+2	91+2	64+2	61+2	61+2	61+2	64+2	59+2	47+2	47+2	47+2	59+2	84	95	70	90	86	97	93	94	87	96	91	86	91	95	95	85	68	72	59	94	48	22	94	94	75	96	33	28	26	6	11	15	14	8	€226.5M
1	20801	Cristiano Ronaldo	33	https://cdn.sofifa.org/players/4/19/20801.png	Portugal	https://cdn.sofifa.org/flags/38.png	94	94	Juventus	https://cdn.sofifa.org/teams/2/light/45.png	€77M	€405K	2228	Right	5	4	5	High/ Low	C. Ronaldo	Yes	ST	7	Tue Jul 10 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2022	6'2	183lbs	91+3	91+3	91+3	89+3	90+3	90+3	90+3	89+3	88+3	88+3	88+3	88+3	81+3	81+3	81+3	88+3	65+3	61+3	61+3	61+3	65+3	61+3	53+3	53+3	53+3	61+3	84	94	89	81	87	88	81	76	77	94	89	91	87	96	70	95	95	88	79	93	63	29	95	82	85	95	28	31	23	7	11	15	14	11	€127.1M
2	190871	Neymar Jr	26	https://cdn.sofifa.org/players/4/19/190871.png	Brazil	https://cdn.sofifa.org/flags/54.png	92	93	Paris Saint-Germain	https://cdn.sofifa.org/teams/2/light/73.png	€118.5M	€290K	2143	Right	5	5	5	High/ Medium	Neymar	Yes	LW	10	Thu Aug 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2022	5'9	150lbs	84+3	84+3	84+3	89+3	89+3	89+3	89+3	89+3	89+3	89+3	89+3	88+3	81+3	81+3	81+3	88+3	65+3	60+3	60+3	60+3	65+3	60+3	47+3	47+3	47+3	60+3	79	87	62	84	84	96	88	87	78	95	94	90	96	94	84	80	61	81	49	82	56	36	89	87	81	94	27	24	33	9	9	15	15	11	€228.1M
3	193080	De Gea	27	https://cdn.sofifa.org/players/4/19/193080.png	Spain	https://cdn.sofifa.org/flags/45.png	91	93	Manchester United	https://cdn.sofifa.org/teams/2/light/11.png	€72M	€260K	1471	Right	4	3	1	Medium/ Medium	Lean	Yes	GK	1	Fri Jul 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2020	6'4	168lbs	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	17	13	21	50	13	18	21	19	51	42	57	58	60	90	43	31	67	43	64	12	38	30	12	68	40	68	15	21	13	90	85	87	88	94	€138.6M
4	192985	K. De Bruyne	27	https://cdn.sofifa.org/players/4/19/192985.png	Belgium	https://cdn.sofifa.org/flags/7.png	91	92	Manchester City	https://cdn.sofifa.org/teams/2/light/10.png	€102M	€355K	2281	Right	4	5	4	High/ High	Normal	Yes	RCM	7	Sun Aug 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2023	5'11	154lbs	82+3	82+3	82+3	87+3	87+3	87+3	87+3	87+3	88+3	88+3	88+3	88+3	87+3	87+3	87+3	88+3	77+3	77+3	77+3	77+3	77+3	73+3	66+3	66+3	66+3	73+3	93	82	55	92	82	86	85	83	91	91	78	76	79	91	77	91	63	90	75	91	76	61	87	94	79	88	68	58	51	15	13	5	10	13	€196.4M
5	183277	E. Hazard	27	https://cdn.sofifa.org/players/4/19/183277.png	Belgium	https://cdn.sofifa.org/flags/7.png	91	91	Chelsea	https://cdn.sofifa.org/teams/2/light/5.png	€93M	€340K	2142	Right	4	4	4	High/ Medium	Normal	Yes	LF	10	Sun Jul 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2020	5'8	163lbs	83+3	83+3	83+3	89+3	88+3	88+3	88+3	89+3	89+3	89+3	89+3	89+3	82+3	82+3	82+3	89+3	66+3	63+3	63+3	63+3	66+3	60+3	49+3	49+3	49+3	60+3	81	84	61	89	80	95	83	79	83	94	94	88	95	90	94	82	56	83	66	80	54	41	87	89	86	91	34	27	22	11	12	6	8	8	€172.1M
6	177003	L. Modrić	32	https://cdn.sofifa.org/players/4/19/177003.png	Croatia	https://cdn.sofifa.org/flags/10.png	91	91	Real Madrid	https://cdn.sofifa.org/teams/2/light/243.png	€67M	€420K	2280	Right	4	4	4	High/ High	Lean	Yes	RCM	10	Wed Aug 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2020	5'8	146lbs	77+3	77+3	77+3	85+3	84+3	84+3	84+3	85+3	87+3	87+3	87+3	86+3	88+3	88+3	88+3	86+3	82+3	81+3	81+3	81+3	82+3	79+3	71+3	71+3	71+3	79+3	86	72	55	93	76	90	85	78	88	93	80	72	93	90	94	79	68	89	58	82	62	83	79	92	82	84	60	76	73	13	9	7	14	9	€137.4M
7	176580	L. Suárez	31	https://cdn.sofifa.org/players/4/19/176580.png	Uruguay	https://cdn.sofifa.org/flags/60.png	91	91	FC Barcelona	https://cdn.sofifa.org/teams/2/light/241.png	€80M	€455K	2346	Right	5	4	3	High/ Medium	Normal	Yes	RS	9	Fri Jul 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	6'0	190lbs	87+5	87+5	87+5	86+5	87+5	87+5	87+5	86+5	85+5	85+5	85+5	84+5	79+5	79+5	79+5	84+5	69+5	68+5	68+5	68+5	69+5	66+5	63+5	63+5	63+5	66+5	77	93	77	82	88	87	86	84	64	90	86	75	82	92	83	86	69	90	83	85	87	41	92	84	85	85	62	45	38	27	25	31	33	37	€164M
8	155862	Sergio Ramos	32	https://cdn.sofifa.org/players/4/19/155862.png	Spain	https://cdn.sofifa.org/flags/45.png	91	91	Real Madrid	https://cdn.sofifa.org/teams/2/light/243.png	€51M	€380K	2201	Right	4	3	3	High/ Medium	Normal	Yes	RCB	15	Mon Aug 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2020	6'0	181lbs	73+3	73+3	73+3	70+3	71+3	71+3	71+3	70+3	71+3	71+3	71+3	72+3	75+3	75+3	75+3	72+3	81+3	84+3	84+3	84+3	81+3	84+3	87+3	87+3	87+3	84+3	66	60	91	78	66	63	74	72	77	84	76	75	78	85	66	79	93	84	83	59	88	90	60	63	75	82	87	92	91	11	8	9	7	11	€104.6M
9	200389	J. Oblak	25	https://cdn.sofifa.org/players/4/19/200389.png	Slovenia	https://cdn.sofifa.org/flags/44.png	90	93	Atlético Madrid	https://cdn.sofifa.org/teams/2/light/240.png	€68M	€94K	1331	Right	3	3	1	Medium/ Medium	Normal	Yes	GK	1	Wed Jul 16 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	6'2	192lbs	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	13	11	15	29	13	12	13	14	26	16	43	60	67	86	49	22	76	41	78	12	34	19	11	70	11	70	27	12	18	86	92	78	88	89	€144.5M


CREATE TABLE fifa_2019 (
  "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" VARCHAR,
  "wage" VARCHAR,
  "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" VARCHAR,
  "height" VARCHAR,
  "weight" 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,
  "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,
  "release_clause" VARCHAR
);