Name: Fantasy Premier League - 2017/18
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

Fantasy Premier League - 2017/18

Context

The Fantasy Premier League has become more popular every year. In the FPL, people pick fantasy teams of real-life players, and every week, receive points based on their picks' real-life performance.

Within this dataset, we have some historical data for the player performance in previous seasons, as well as future match fixtures.

Content

The three main components currently in this dataset are:

The individual players' current performance stats.
The individual players' past performance stats (how much historical data depends on the player).
A list of future match fixtures.

All the data was taken from the Official Fantasy Premier League website.

N.B. A lot of the data was cobbled together from the output of publicly accessible JSON endpoints, therefore there are a lot of duplications (as fixture data was initially from the perspective of the individual players). Also, since a lot of this data is used to drive the UI of a Web Application, there are a lot of redundancies, all of which could do with being cleaned up.

Inspiration

A lot of my friends are massively into all aspects of the Premier League (fantasy or otherwise), so my main motivation in putting this dataset together was to see was it possible to gain a competitive advantage over my very domain knowledgeable friends, with little to no domain knowledge myself.

The obvious questions that could be answered with this data correspond to predicting the future performance of players based on historical metrics.

Tables

Fixtures

@kaggle.thomasd9_fantasy_premier_league_201718.fixtures

9.08 kB
390 rows
8 columns

CREATE TABLE fixtures (
  "game_week" BIGINT,
  "event_name" VARCHAR,
  "home_team_id" BIGINT,
  "home_team_name" VARCHAR,
  "home_team_short_name" VARCHAR,
  "away_team_id" BIGINT,
  "away_team_name" VARCHAR,
  "away_team_short_name" VARCHAR
);

Historical Performance

@kaggle.thomasd9_fantasy_premier_league_201718.historical_performance

79.3 kB
1,815 rows
26 columns

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
);

Player Info

@kaggle.thomasd9_fantasy_premier_league_201718.player_info

103.47 kB
501 rows
72 columns

CREATE TABLE player_info (
  "assists" BIGINT,
  "bonus" BIGINT,
  "bps" BIGINT,
  "chance_of_playing_next_round" DOUBLE,
  "chance_of_playing_this_round" DOUBLE,
  "clean_sheets" BIGINT,
  "code" BIGINT,
  "cost_change_event" BIGINT,
  "cost_change_event_fall" BIGINT,
  "cost_change_start" BIGINT,
  "cost_change_start_fall" BIGINT,
  "creativity" DOUBLE,
  "dreamteam_count" BIGINT,
  "ea_index" BIGINT,
  "elementstatus" DOUBLE,
  "element_type" BIGINT,
  "element_type_id" BIGINT,
  "element_type_singular_name" VARCHAR,
  "element_type_singular_name_short" VARCHAR,
  "ep_next" DOUBLE,
  "ep_this" DOUBLE,
  "event_points" BIGINT,
  "first_name" VARCHAR,
  "form" DOUBLE,
  "goals_conceded" BIGINT,
  "goals_scored" BIGINT,
  "iconinfo" VARCHAR,
  "ict_index" DOUBLE,
  "id" BIGINT,
  "in_dreamteam" BOOLEAN,
  "influence" DOUBLE,
  "infostub" VARCHAR,
  "iselement" BOOLEAN,
  "istransfer" BOOLEAN,
  "loaned_in" BIGINT,
  "loaned_out" BIGINT,
  "loans_in" BIGINT,
  "loans_out" BIGINT,
  "minutes" BIGINT,
  "news" VARCHAR,
  "next_event_fixture" VARCHAR,
  "now_cost" BIGINT,
  "own_goals" BIGINT,
  "penalties_missed" BIGINT,
  "penalties_saved" BIGINT,
  "photo" VARCHAR,
  "photo_url" VARCHAR,
  "points_per_game" DOUBLE,
  "red_cards" BIGINT,
  "saves" BIGINT,
  "search_name" VARCHAR,
  "second_name" VARCHAR,
  "selected_by_percent" DOUBLE,
  "shirt_id" VARCHAR,
  "shirt_image_url" VARCHAR,
  "special" BOOLEAN,
  "squad_number" DOUBLE,
  "status" VARCHAR,
  "team" BIGINT,
  "team_code" BIGINT,
  "team_name" VARCHAR,
  "team_short_name" VARCHAR,
  "threat" DOUBLE,
  "total_points" BIGINT,
  "transfers_in" BIGINT,
  "transfers_in_event" BIGINT,
  "transfers_out" BIGINT,
  "transfers_out_event" BIGINT,
  "value_form" DOUBLE,
  "value_season" DOUBLE,
  "web_name" VARCHAR,
  "yellow_cards" BIGINT
);