Fantasy Premier League - 2017/18

Data for the 2017/18 season of the Fantasy Premier League

@kaggle.thomasd9_fantasy_premier_league_201718

Table List

3 tables(187.36 KB)

Fixtures

Historical Performance

Player Info

Historical Performance

@kaggle.thomasd9_fantasy_premier_league_201718.historical_performance

77.44 KB
1815 rows
26 columns

player_id Player Id	assists Assists	bonus Bonus	bps Bps	clean_sheets Clean Sheets	ea_index Ea Index	element_code Element Code	end_cost End Cost	goals_conceded Goals Conceded	ict_index Ict Index	id Id	influence Influence	minutes Minutes	own_goals Own Goals	penalties_saved Penalties Saved	red_cards Red Cards	saves Saves	season Season	season_name Season Name	start_cost Start Cost	total_points Total Points	yellow_cards Yellow Cards
1			301	8	241	48844	50	11		5424		1620				47	9	2014/15	50	76
1		2	98	2	56	48844	47	5		6096		360				17	10	2015/16	50	20
1			18			48844	47	4	2.9	6818	28.8	143				4	11	2016/17	50	2
2		1				11334	64	9		115		1714				58	1	2006/07	65	98	1
2		2				11334	65	17		807		2313				60	2	2007/08	65	120
2		7				11334	60	24		1426		3150		1		87	3	2008/09	60	171
2	1					11334	62	26		2156		3020	1	1	1	66	4	2009/10	65	144
2	1	2		15		11334	67	33		2829		3420		1		98	5	2010/11	65	158
2		7		10	399	11334	68	39		3319		3060				94	6	2011/12	70	127
2		2		14	502	11334	64	36		3991		3195				126	7	2012/13	65	144	2


CREATE TABLE historical_performance (
  "player_id" BIGINT,
  "assists" BIGINT,
  "bonus" BIGINT,
  "bps" BIGINT,
  "clean_sheets" BIGINT,
  "creativity" DOUBLE,
  "ea_index" BIGINT,
  "element_code" BIGINT,
  "end_cost" BIGINT,
  "goals_conceded" BIGINT,
  "goals_scored" BIGINT,
  "ict_index" DOUBLE,
  "id" BIGINT,
  "influence" DOUBLE,
  "minutes" BIGINT,
  "own_goals" BIGINT,
  "penalties_missed" BIGINT,
  "penalties_saved" BIGINT,
  "red_cards" BIGINT,
  "saves" BIGINT,
  "season" BIGINT,
  "season_name" VARCHAR,
  "start_cost" BIGINT,
  "threat" DOUBLE,
  "total_points" BIGINT,
  "yellow_cards" BIGINT
);