European Soccer Dataset

Season 2017/18, 2018/19 and 2019/20

@kaggle.alessiasimone_european_soccer_dataset_season_20172020

Table List

1 table(323.22 KB)

Output

@kaggle.alessiasimone_european_soccer_dataset_season_20172020.output

323.22 KB
6824 rows
46 columns

player Player	age Age	height Height	nationality Nationality	position Position	value Value	games Games	minutes Minutes	goals Goals	assists Assists	crosses Crosses	tackles Tackles	pressures Pressures	blocks Blocks	touches Touches	fouls Fouls	fouled Fouled	offsides Offsides	own_goals Own Goals	ball_recoveries Ball Recoveries	saves Saves	squad Squad	season Season	league League	attendance Attendance	games_starts Games Starts	passes_completed Passes Completed	sca Sca	gca Gca	dribbles_completed Dribbles Completed	pens_won Pens Won	goals_against_gk Goals Against Gk	shots_on_target_against Shots On Target Against	clbestscorer CLBestScorer	cards_yellow Cards Yellow	shots_total Shots Total	lgrk LgRk	mp MP	w W	d D	l L	gf GF	ga GA	pts Pts	cl CL	wincl WinCL
Zouhair Feddal	30	192	Morocco	Defender	4000000	17	1431	1	2	1	17	124	19	1236	23	10			159		Betis	Tue Jan 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	La Liga	35969	16	917	15	4	4				No	10	9	15	38	10	11	17	48	60	41	No	No
Zlatan Ibrahimović	37	195	Sweden	Forward	3500000	18	1362	10	5	23	4	126	9	813	30	16	20		59		Milan	Tue Jan 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Serie A	34078	16	434	58	7	12				No	1	63	6	38	19	9	10	63	46	66	No	No
Zinedine Ferhat	26	180	Algeria	Forward	2000000	26	2246	3	4	85	27	263	24	1264	17	54	7		179		Nîmes	Tue Jan 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Ligue 1	12555	25	600	91	6	54				No	1	45	18	28	7	6	15	29	44	27	No	No
Zinédine Ould Khaled	19	195	France	Midfield	15000	1	59				1	24	3	38	2				5		Angers	Tue Jan 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Ligue 1	9825	1	22			1				No			11	28	11	6	11	28	33	39	No	No
Zeki Celik	22	180	Turkey	Defender	20000000	23	2070		2	47	65	391	37	1613	38	11	4	1	232		Lille	Tue Jan 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Ligue 1	36404	23	1094	30	5	19	1			No	4	5	4	28	15	4	9	35	27	49	No	No
Zaydou Youssouf	20	182	France	Midfield	7000000	16	1077			8	40	204	14	658	15	27			120		Saint-Étienne	Tue Jan 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Ligue 1	23205	9	425	22	2	29				No	4	8	17	28	8	6	14	29	45	30	No	No
Zack Steffen	24	191	United States	Goalkeeper	6000000	17	1530					4		674		2			108	61	Düsseldorf	Tue Jan 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Bundesliga	30581	17	441	5	1			36	95	No			17	34	6	12	16	36	67	30	No	No
Yvon Mvogo	25	186	Switzerland	Goalkeeper	2000000	2	180							82					15	2	RB Leipzig	Tue Jan 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Bundesliga	28819	2	68			1		3	5	No			3	34	18	12	4	81	37	66	Yes	No
Yves Bissouma	22	182	Mali	Midfield	9000000	22	1259	1		6	58	308	28	840	31	15			157		Brighton	Tue Jan 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Premier League	22369	15	525	11		26				No	4	16	15	38	9	14	15	39	54	41	No	No
Yuya Osako	29	182	Japan	Forward	3000000	28	1848	8	2	13	31	371	19	943	31	39	5		110		Werder Bremen	Tue Jan 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Bundesliga	26413	22	493	64	5	24	1			nan	2	46	16	34	8	7	19	42	69	31	No	No


CREATE TABLE output (
  "player" VARCHAR,
  "age" BIGINT,
  "height" DOUBLE,
  "nationality" VARCHAR,
  "position" VARCHAR,
  "value" BIGINT,
  "games" BIGINT,
  "minutes" BIGINT,
  "goals" BIGINT,
  "assists" BIGINT,
  "crosses" BIGINT,
  "tackles" BIGINT,
  "pressures" BIGINT,
  "blocks" BIGINT,
  "touches" BIGINT,
  "fouls" BIGINT,
  "fouled" BIGINT,
  "offsides" BIGINT,
  "own_goals" BIGINT,
  "ball_recoveries" BIGINT,
  "saves" BIGINT,
  "squad" VARCHAR,
  "season" TIMESTAMP,
  "league" VARCHAR,
  "attendance" BIGINT,
  "games_starts" BIGINT,
  "passes_completed" BIGINT,
  "sca" BIGINT,
  "gca" BIGINT,
  "dribbles_completed" BIGINT,
  "pens_won" BIGINT,
  "goals_against_gk" BIGINT,
  "shots_on_target_against" BIGINT,
  "clbestscorer" VARCHAR,
  "cards_yellow" BIGINT,
  "shots_total" BIGINT,
  "lgrk" BIGINT,
  "mp" BIGINT,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "gf" BIGINT,
  "ga" BIGINT,
  "pts" BIGINT,
  "cl" VARCHAR,
  "wincl" VARCHAR
);