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 Processed Data

@kaggle.devansodariya_football_fifa_2019_dataset.fifa_processed_data

1.97 MB
18207 rows
90 columns

unnamed_0_1 Unnamed: 0.1	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	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	565000	565000	2202	Left	5	4	4	Medium/ Medium	Normal	Yes	RF	10	Jul 1, 2004	2021	67	159	90	90	90	94	95	95	95	94	95	95	95	93	86	86	86	93	66	63	63	63	66	61	49	49	49	61	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	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	405000	405000	2228	Right	5	4	5	High/ Low	Lean	Yes	ST	7	Jul 10, 2018	2022	74	183	94	94	94	92	93	93	93	92	91	91	91	91	84	84	84	91	68	64	64	64	68	64	56	56	56	64	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	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	290000	290000	2143	Right	5	5	5	High/ Medium	Lean	Yes	LW	10	Aug 3, 2017	2022	69	150	87	87	87	92	92	92	92	92	92	92	92	91	84	84	84	91	68	63	63	63	68	63	50	50	50	63	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	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	260000	260000	1471	Right	4	3	1	Medium/ Medium	Lean	Yes	GK	1	Jul 1, 2011	2020	76	168																											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	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	355000	355000	2281	Right	4	5	4	High/ High	Normal	Yes	RCM	7	Aug 30, 2015	2023	71	154	85	85	85	90	90	90	90	90	91	91	91	91	90	90	90	91	80	80	80	80	80	76	69	69	69	76	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	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	340000	340000	2142	Right	4	4	4	High/ Medium	Normal	Yes	LF	10	Jul 1, 2012	2020	68	163	86	86	86	92	91	91	91	92	92	92	92	92	85	85	85	92	69	66	66	66	69	63	52	52	52	63	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	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	420000	420000	2280	Right	4	4	4	High/ High	Lean	Yes	RCM	10	Aug 1, 2012	2020	68	146	80	80	80	88	87	87	87	88	90	90	90	89	91	91	91	89	85	84	84	84	85	82	74	74	74	82	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	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	455000	455000	2346	Right	5	4	3	High/ Medium	Normal	Yes	RS	9	Jul 11, 2014	2021	72	190	92	92	92	91	92	92	92	91	90	90	90	89	84	84	84	89	74	73	73	73	74	71	68	68	68	71	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	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	380000	380000	2201	Right	4	3	3	High/ Medium	Normal	Yes	RCB	15	Aug 1, 2005	2020	72	181	76	76	76	73	74	74	74	73	74	74	74	75	78	78	78	75	84	87	87	87	84	87	90	90	90	87	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	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	94000	94000	1331	Right	3	3	1	Medium/ Medium	Normal	Yes	GK	1	Jul 16, 2014	2021	74	192																											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_processed_data (
  "unnamed_0_1" BIGINT,
  "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" BIGINT,
  "wage" BIGINT,
  "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" VARCHAR,
  "loaned_from" VARCHAR,
  "contract_valid_until" VARCHAR,
  "height" BIGINT,
  "weight" BIGINT,
  "ls" BIGINT,
  "st" BIGINT,
  "rs" BIGINT,
  "lw" BIGINT,
  "lf" BIGINT,
  "cf" BIGINT,
  "rf" BIGINT,
  "rw" BIGINT,
  "lam" BIGINT,
  "cam" BIGINT,
  "ram" BIGINT,
  "lm" BIGINT,
  "lcm" BIGINT,
  "cm" BIGINT,
  "rcm" BIGINT,
  "rm" BIGINT,
  "lwb" BIGINT,
  "ldm" BIGINT,
  "cdm" BIGINT,
  "rdm" BIGINT,
  "rwb" BIGINT,
  "lb" BIGINT,
  "lcb" BIGINT,
  "cb" BIGINT,
  "rcb" BIGINT,
  "rb" 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,
  "release_clause" VARCHAR
);