Fantasy Premier League 2019 -20

Predict total points of a player

@kaggle.aj3907_fantasy_premier_league_2019_20

Table List

4 tables(343.15 KB)

Gw History

@kaggle.aj3907_fantasy_premier_league_2019_20.gw_history

217.41 KB
11624 rows
29 columns

player_id Player Id	element_type Element Type	home_team Home Team	opponent_team Opponent Team	fdr_p Fdr P	fdr_o Fdr O	was_home Was Home	round Round	value Value	transfers_balance Transfers Balance	selected Selected
1	2	1	13	3	4		1	55		33117
1	2	1	5	2	4	true	2	55	-5280	36709
1	2	1	10	5	4		3	54	-6882	30975
1	2	1	17	4	4	true	4	54	-3872	28096
1	2	1	18	2	4		5	53	-2073	26902
1	2	1	2	2	4	true	6	53	-1041	26330
1	2	1	12	4	4		7	53	-1166	25642
1	2	1	3	2	4	true	8	53	-691	25277
1	2	1	15	3	4		9	53	-469	25175
1	2	1	7	3	4	true	10	52	-325	25037


CREATE TABLE gw_history (
  "player_id" BIGINT,
  "element_type" BIGINT,
  "home_team" BIGINT,
  "opponent_team" BIGINT,
  "fdr_p" BIGINT,
  "fdr_o" BIGINT,
  "total_points" BIGINT,
  "was_home" BOOLEAN,
  "round" BIGINT,
  "minutes" BIGINT,
  "goals_scored" BIGINT,
  "assists" BIGINT,
  "clean_sheets" BIGINT,
  "goals_conceded" BIGINT,
  "own_goals" BIGINT,
  "penalties_saved" BIGINT,
  "penalties_missed" BIGINT,
  "yellow_cards" BIGINT,
  "red_cards" BIGINT,
  "saves" BIGINT,
  "bonus" BIGINT,
  "bps" BIGINT,
  "influence" DOUBLE,
  "creativity" DOUBLE,
  "threat" BIGINT,
  "ict_index" DOUBLE,
  "value" BIGINT,
  "transfers_balance" BIGINT,
  "selected" BIGINT
);