Fantasy Premier League Dataset 2023-2024

Fantasy Premier League 2023-2024 Players Dataset

@kaggle.meraxes10_fantasy_premier_league_dataset_2023_2024

Table List

1 table(201.46 KB)

Players

@kaggle.meraxes10_fantasy_premier_league_dataset_2023_2024.players

201.46 KB
769 rows
79 columns

id Id	name Name	now_cost Now Cost	position Position	team Team	web_name Web Name	transfers_in_event Transfers In Event	influence_rank_type Influence Rank Type	news_added News Added	ict_index_rank_type Ict Index Rank Type	assists Assists	selected_rank Selected Rank	starts_per_90 Starts Per 90	goals_conceded Goals Conceded	threat_rank_type Threat Rank Type	status Status	ep_this Ep This	news News	selected_rank_type Selected Rank Type	goals_scored Goals Scored	influence_rank Influence Rank	goals_conceded_per_90 Goals Conceded Per 90	selected_by_percent Selected By Percent	points_per_game_rank Points Per Game Rank	expected_goal_involvements_per_90 Expected Goal Involvements Per 90	influence Influence	form_rank_type Form Rank Type	expected_goals_conceded_per_90 Expected Goals Conceded Per 90	chance_of_playing_this_round Chance Of Playing This Round	ep_next Ep Next	expected_assists Expected Assists	expected_goals_conceded Expected Goals Conceded	points_per_game Points Per Game	cost_change_start Cost Change Start	transfers_in Transfers In	starts Starts	cost_change_start_fall Cost Change Start Fall	creativity Creativity	threat_rank Threat Rank	points_per_game_rank_type Points Per Game Rank Type	bonus Bonus	expected_goals Expected Goals	chance_of_playing_next_round Chance Of Playing Next Round	event_points Event Points	clean_sheets Clean Sheets	clean_sheets_per_90 Clean Sheets Per 90	transfers_out Transfers Out	penalties_order Penalties Order	expected_goals_per_90 Expected Goals Per 90	creativity_rank_type Creativity Rank Type	expected_assists_per_90 Expected Assists Per 90	value_season Value Season	transfers_out_event Transfers Out Event	form Form	bps Bps	expected_goal_involvements Expected Goal Involvements	form_rank Form Rank	creativity_rank Creativity Rank	corners_and_indirect_freekicks_order Corners And Indirect Freekicks Order	threat Threat	dreamteam_count Dreamteam Count	now_cost_rank_type Now Cost Rank Type	ict_index Ict Index	now_cost_rank Now Cost Rank	minutes Minutes	yellow_cards Yellow Cards	red_cards Red Cards	value_form Value Form	ict_index_rank Ict Index Rank	total_points Total Points
1	Folarin Balogun	44	FWD	Arsenal	Balogun		61	2023-08-31T08:55:15.272751Z	63		325			60	u		Transferred to Monaco	50		623		0.2	635			55							-1	10024		1		596	66							61418			62			142				564	612				94		528					628
2	Cédric Alves Soares	39	DEF	Arsenal	Cédric	433	173	nan	172		253			158	a		nan	100		487		0.4	499			139			0.5				-1	33412		1		437	170							37554			172			614				404	467				231		729					493
3	Mohamed Elneny	44	MID	Arsenal	M.Elneny	54	215	2023-12-12T22:30:08.433665Z	214	1	438			207	a		nan	144		473		0.1	55		1.8	192		25	0.5			4	-1	12636		1	0.5	419	30			100				17767			217		0.9	185		12		548	443		2		290	0.4	498	1				470	4
4	Fábio Ferreira Vieira	54	MID	Arsenal	Fábio Vieira	5	134	2023-12-07T12:00:08.489004Z	139	3	430	0.76	2	109	i		Groin Injury - Expected back 20 Jan	141	1	318	0.76	0.1	209	0.59	79.4	319	0.56			0.35	1.48	2.6	-1	11445	2	1	63.6	199	92		1.2			1	0.38	18183	4	0.46	141	0.13	3.9	80		62	1.55	738	253	5	77		80	21.9	127	236		1		300	21
5	Gabriel dos Santos Magalhães	49	DEF	Arsenal	Gabriel	104278	42	2023-09-30T23:00:07.672676Z	47		21	0.98	13	24	a	4.5	nan	7	1	110	0.91	16.1	100	0.09	268.8	5	0.84	100	5	0.22	11.97	3.5	-1	1193629	14	1	59	156	24	4	0.93	100	10	5	0.35	2484607		0.07	87	0.02	11.4	5578	4.5	259	1.15	34	269		105	1	31	43.3	247	1284	1		0.9	172	56
6	Kai Havertz	71	MID	Arsenal	Havertz	1812	65	2023-12-23T20:00:08.458889Z	53	1	151	0.99	12	33	s	4.2	Suspended until 31 Dec	46	4	154	0.99	1.7	183	0.44	217	26	0.74			1.09	8.98	2.8	-4	81456	12	4	207.7	55	81		4.21		1	4	0.33	377765	3	0.35	63	0.09	7	8219	4.2	146	5.3	46	83		278		18	70.3	30	1092	5		0.6	77	50
8	Gabriel Fernando de Jesus	80	FWD	Arsenal	G.Jesus	45531	18	2023-10-24T23:30:07.618920Z	10	2	75	1.1	9	8	a	4.7	nan	15	3	171	0.99	5.3	103	0.6	199.4	4	0.81	100	5.2	1.16	7.36	3.5		852181	10		181.5	15	14	8	4.25	100	2	5	0.55	630209		0.47	11	0.13	5.8	19035	4.7	144	5.41	29	101		453	1	4	83.3	12	821	3		0.6	48	46
9	Jorge Luiz Frello Filho	53	MID	Arsenal	Jorginho	74	157	2023-12-18T00:00:09.353001Z	161		344	0.94	6	197	a	0.2	nan	105		362	1.41	0.2	367	0.09	50.6	164	1.1	75	0.8	0.3	4.68	1.4	-2	8760	4	2	64.7	390	165		0.09	100		1	0.23	18070		0.02	139	0.07	2.8	238	0.3	66	0.39	365	250		9		83	12.4	134	383	1		0.1	359	15
10	Jakub Kiwior	43	DEF	Arsenal	Kiwior	54	141	nan	142		432	1.09	5	122	a	0.5	nan	167		374	1.82	0.1	325	0.16	43.4	112	0.5		1	0.07	1.37	1.7	-2	4591	3	2	11.2	347	114		0.37			1	0.36	8837		0.13	143	0.03	2.8	120	0.5	58	0.44	329	392		18		151	7.4	603	247			0.1	398	12
11	Marcus Oliveira Alencar	45	MID	Arsenal	Marquinhos		267	2023-08-14T03:57:12.475590Z	270		528			267	u		Season long loan to FC Nantes	187		673			682			233								819				660	273							11679			268			17				623	669				246		424					678


CREATE TABLE players (
  "id" BIGINT,
  "name" VARCHAR,
  "now_cost" BIGINT,
  "position" VARCHAR,
  "team" VARCHAR,
  "web_name" VARCHAR,
  "transfers_in_event" BIGINT,
  "influence_rank_type" BIGINT,
  "news_added" VARCHAR,
  "ict_index_rank_type" BIGINT,
  "assists" BIGINT,
  "selected_rank" BIGINT,
  "direct_freekicks_order" DOUBLE,
  "starts_per_90" DOUBLE,
  "goals_conceded" BIGINT,
  "threat_rank_type" BIGINT,
  "status" VARCHAR,
  "ep_this" DOUBLE,
  "news" VARCHAR,
  "selected_rank_type" BIGINT,
  "goals_scored" BIGINT,
  "influence_rank" BIGINT,
  "goals_conceded_per_90" DOUBLE,
  "selected_by_percent" DOUBLE,
  "in_dreamteam" BOOLEAN,
  "points_per_game_rank" BIGINT,
  "expected_goal_involvements_per_90" DOUBLE,
  "influence" DOUBLE,
  "form_rank_type" BIGINT,
  "expected_goals_conceded_per_90" DOUBLE,
  "chance_of_playing_this_round" DOUBLE,
  "ep_next" DOUBLE,
  "expected_assists" DOUBLE,
  "expected_goals_conceded" DOUBLE,
  "points_per_game" DOUBLE,
  "cost_change_start" BIGINT,
  "transfers_in" BIGINT,
  "starts" BIGINT,
  "cost_change_start_fall" BIGINT,
  "creativity" DOUBLE,
  "saves_per_90" DOUBLE,
  "threat_rank" BIGINT,
  "penalties_saved" BIGINT,
  "points_per_game_rank_type" BIGINT,
  "own_goals" BIGINT,
  "bonus" BIGINT,
  "penalties_missed" BIGINT,
  "expected_goals" DOUBLE,
  "chance_of_playing_next_round" DOUBLE,
  "event_points" BIGINT,
  "clean_sheets" BIGINT,
  "clean_sheets_per_90" DOUBLE,
  "transfers_out" BIGINT,
  "cost_change_event" BIGINT,
  "penalties_order" DOUBLE,
  "expected_goals_per_90" DOUBLE,
  "creativity_rank_type" BIGINT,
  "expected_assists_per_90" DOUBLE,
  "value_season" DOUBLE,
  "transfers_out_event" BIGINT,
  "form" DOUBLE,
  "bps" BIGINT,
  "saves" BIGINT,
  "expected_goal_involvements" DOUBLE,
  "form_rank" BIGINT,
  "creativity_rank" BIGINT,
  "corners_and_indirect_freekicks_order" DOUBLE,
  "threat" DOUBLE,
  "dreamteam_count" BIGINT,
  "now_cost_rank_type" BIGINT,
  "ict_index" DOUBLE,
  "now_cost_rank" BIGINT,
  "minutes" BIGINT,
  "yellow_cards" BIGINT,
  "cost_change_event_fall" BIGINT,
  "red_cards" BIGINT,
  "value_form" DOUBLE,
  "ict_index_rank" BIGINT,
  "total_points" BIGINT
);