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)

Player Details

@kaggle.aj3907_fantasy_premier_league_2019_20.player_details

109.33 KB
587 rows
53 columns

id Id	chance_of_playing_next_round Chance Of Playing Next Round	chance_of_playing_this_round Chance Of Playing This Round	code Code	cost_change_start Cost Change Start	cost_change_start_fall Cost Change Start Fall	dreamteam_count Dreamteam Count	element_type Element Type	ep_next Ep Next	ep_this Ep This	event_points Event Points	first_name First Name	form Form	news News	news_added News Added	now_cost Now Cost	photo Photo	points_per_game Points Per Game	second_name Second Name	selected_by_percent Selected By Percent	status Status	team Team	team_code Team Code	total_points Total Points	transfers_in Transfers In	transfers_in_event Transfers In Event	transfers_out Transfers Out	transfers_out_event Transfers Out Event	value_form Value Form	value_season Value Season	web_name Web Name	minutes Minutes	goals_scored Goals Scored	assists Assists	clean_sheets Clean Sheets	goals_conceded Goals Conceded	yellow_cards Yellow Cards	red_cards Red Cards	bonus Bonus	bps Bps	influence Influence	creativity Creativity	threat Threat	ict_index Ict Index
1	100	100	69140	-3	3		2	0.8	0.3		Shkodran	0.3	nan	2019-11-28T23:00:21.541666Z	52	69140.jpg	2	Mustafi	0.3	a	1	3	6	8455	167	33199	247	0.1	1.2	Mustafi	170		1		4				35	32.2	1.2	54	8.8
2	75	75	98745	-1	1		2	0.4			Héctor		Hamstring injury - 75% chance of playing	2019-12-09T20:00:21.228098Z	54	98745.jpg	0.3	Bellerín	0.2	d	1	3	1	35004	72	36983	454		0.2	Bellerín	262				6	2			26	30.8	22.7	15	6.9
3	100		111457	-3	3		2	2.2		5	Sead	1.7	nan	2019-12-15T19:30:19.136195Z	52	111457.jpg	2.1	Kolasinac	0.5	a	1	3	32	49513	2525	116957	616	0.3	6.2	Kolasinac	996		2	2	17	3		1	211	176.2	152.7	61	38.9
4	100	100	154043	-4	4	1	2	2.8	2.3	6	Ainsley	2.3	nan	2019-09-22T18:00:10.824841Z	46	154043.jpg	2.8	Maitland-Niles	2.6	a	1	3	33	565612	9986	581945	2701	0.5	7.2	Maitland-Niles	1030		2	3	17	2	1	3	198	232	150.3	37	41.4
5	100		39476	-1	1	1	2	3.2		15	Sokratis	2.7	nan	2019-12-26T17:00:15.332949Z	49	39476.jpg	2.9	Papastathopoulos	1.4	a	1	3	50	120860	12701	158961	1969	0.6	10.2	Sokratis	1516	2		3	24	5		5	277	415.4	31.6	104	55.2
6			38411				2				Nacho		Joined Real Sociedad on a permanent deal on 31/8	2019-08-31T11:30:14.661839Z	50	38411.jpg	3.3	Monreal	0.3	u	1	3	10	28081	10	88321	91		2	Monreal	270			1	4			1	54	47.2	40.8	12	10
7			51507				2				Laurent		Joined Bordeaux on a permanent deal on 6/8.	2019-08-08T11:00:09.045030Z	50	51507.jpg		Koscielny	0.1	u	1	3		538	21	12565	42			Koscielny
8	100	100	233963	-1	1		2	0.5			Konstantinos		nan	2019-08-09T09:30:11.868345Z	44	233963.jpg		Mavropanos		a	1	3		1002	64	4386	57			Mavropanos
9			80254				2				Carl		Joined Nottingham Forest on a permanent deal on 7/8.	2019-08-07T17:00:10.875251Z	45	80254.jpg		Jenkinson		u	1	3		370	8	2505	13			Jenkinson
10	100	75	156074				2	0.5			Rob		nan	2019-12-09T10:00:19.335279Z	45	156074.jpg	1	Holding	0.1	a	1	3	1	10574	178	13127	147		0.2	Holding	76				2				9	8.4	0.4	2	1.1


CREATE TABLE player_details (
  "id" BIGINT,
  "chance_of_playing_next_round" DOUBLE,
  "chance_of_playing_this_round" DOUBLE,
  "code" BIGINT,
  "cost_change_event" BIGINT,
  "cost_change_event_fall" BIGINT,
  "cost_change_start" BIGINT,
  "cost_change_start_fall" BIGINT,
  "dreamteam_count" BIGINT,
  "element_type" BIGINT,
  "ep_next" DOUBLE,
  "ep_this" DOUBLE,
  "event_points" BIGINT,
  "first_name" VARCHAR,
  "form" DOUBLE,
  "in_dreamteam" BOOLEAN,
  "news" VARCHAR,
  "news_added" VARCHAR,
  "now_cost" BIGINT,
  "photo" VARCHAR,
  "points_per_game" DOUBLE,
  "second_name" VARCHAR,
  "selected_by_percent" DOUBLE,
  "special" BOOLEAN,
  "squad_number" VARCHAR,
  "status" VARCHAR,
  "team" BIGINT,
  "team_code" BIGINT,
  "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,
  "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" DOUBLE,
  "ict_index" DOUBLE
);