Fantasy Premier League Dataset 2022-2023

Fantasy Premier League 2022-2023 Players Dataset

@kaggle.meraxes10_fantasy_premier_league_dataset_2022_2023

Table List

1 table(200.3 KB)

Players

@kaggle.meraxes10_fantasy_premier_league_dataset_2022_2023.players

200.3 KB
778 rows
75 columns

id Id	name Name	now_cost Now Cost	position Position	team Team	clean_sheets_per_90 Clean Sheets Per 90	threat_rank_type Threat Rank Type	expected_assists_per_90 Expected Assists Per 90	expected_assists Expected Assists	points_per_game_rank Points Per Game Rank	goals_scored Goals Scored	creativity_rank_type Creativity Rank Type	transfers_out Transfers Out	value_form Value Form	direct_freekicks_order Direct Freekicks Order	value_season Value Season	bonus Bonus	starts_per_90 Starts Per 90	cost_change_start Cost Change Start	news_added News Added	expected_goals_conceded Expected Goals Conceded	cost_change_start_fall Cost Change Start Fall	expected_goals_conceded_per_90 Expected Goals Conceded Per 90	threat Threat	selected_rank_type Selected Rank Type	influence Influence	corners_and_indirect_freekicks_order Corners And Indirect Freekicks Order	ep_next Ep Next	event_points Event Points	web_name Web Name	creativity Creativity	ict_index_rank Ict Index Rank	creativity_rank Creativity Rank	expected_goals Expected Goals	status Status	now_cost_rank_type Now Cost Rank Type	yellow_cards Yellow Cards	goals_conceded Goals Conceded	news News	expected_goal_involvements_per_90 Expected Goal Involvements Per 90	assists Assists	form_rank_type Form Rank Type	ict_index_rank_type Ict Index Rank Type	chance_of_playing_next_round Chance Of Playing Next Round	influence_rank Influence Rank	ict_index Ict Index	form Form	dreamteam_count Dreamteam Count	expected_goal_involvements Expected Goal Involvements	chance_of_playing_this_round Chance Of Playing This Round	starts Starts	points_per_game Points Per Game	minutes Minutes	total_points Total Points	in_dreamteam In Dreamteam	form_rank Form Rank	selected_rank Selected Rank	expected_goals_per_90 Expected Goals Per 90	threat_rank Threat Rank	ep_this Ep This	transfers_in Transfers In	bps Bps	goals_conceded_per_90 Goals Conceded Per 90	selected_by_percent Selected By Percent	influence_rank_type Influence Rank Type	points_per_game_rank_type Points Per Game Rank Type	clean_sheets Clean Sheets	now_cost_rank Now Cost Rank
3	Granit Xhaka	48	MID	Arsenal	0.39	38	0.12	3.89	47	7	25	832169	1.4	2	31.9	15	1.08	-2	2023-04-22T08:30:07.774962Z	36.52	2	1.1	498	41	647		5.3	15	Xhaka	673.3	41	32	4.65	a	157	4	35	nan	0.26	8	2	28	100	60	182	6.8	2	8.54	100	36	4.1	2992	153		5	118	0.14	62	7.3	942505	634	1.05	2.7	23	23	13	265
4	Mohamed Elneny	41	MID	Arsenal		233	0.03	0.04	457		221	279536			1.5		0.81	-4	2023-01-26T10:00:07.778526Z	1.29	4	1.05		81	4.6				Elneny	5.4	505	460		i	335		2	Knee injury - Unknown return date	0.03		194	227		505	1.1		1	0.04		1	1.2	111	6		528	249		593		202760	27	1.62	0.6	226	201		634
5	Rob Holding	42	DEF	Arsenal		118	0.02	0.15	405	1	159	27980			5		0.96	-3	nan	11.14	3	1.78	54	143	152		0.7		Holding	10.3	399	448	0.32	a	160		13	nan	0.07		121	146		339	21.6	0.2		0.47		6	1.5	562	21		376	377	0.05	341	0.7	23338	120	2.08	0.2	137	144		598
6	Thomas Partey	47	MID	Arsenal	0.4	90	0.08	2.17	210	3	59	141958	0.3		18.3	6	1.02	-3	2023-03-31T15:30:08.770925Z	32.27	3	1.17	240	95	513.2		1.5	3	Partey	439.6	97	70	2.59	a	186	5	28	nan	0.17		108	68	100	110	119.5	1.4		4.76	100	28	2.6	2480	86		233	284	0.09	152	1.9	110171	468	1.02	0.4	47	80	11	311
7	Martin Ødegaard	69	MID	Arsenal	0.37	8	0.23	8.02	7	15	5	5015435	0.9	1	30.7	30	1.06	4	2023-03-09T22:30:08.763464Z	37.94	-4	1.09	920	3	960	3	7.7	3	Ødegaard	1100.4	6	7	9.75	a	22	4	38	nan	0.51	8	3	4	100	10	298.3	6.4	5	17.77	100	37	5.7	3132	212	true	8	5	0.28	18	6.9	7014051	813	1.09	33.3	3	3	13	44
8	Kieran Tierney	46	DEF	Arsenal	0.12	108	0.05	0.43	432		101	158213	0.2		8		0.7	-4	2023-03-29T08:30:08.049621Z	10.9	4	1.27	67	75	144		1.5	1	Tierney	85.5	366	313	0.38	a	57		10	nan	0.09	1	92	129	100	350	29.9	1		0.81	100	6	1.4	774	37		280	208	0.04	323	1.5	98909	164	1.16	0.8	144	154	1	332
9	Nicolas Pépé	53	MID	Arsenal		334			769		334	36735						-2	2022-08-26T07:24:29.541862Z		2			162					Pépé		769	767		u	78			Season-long loan to Nice			327	334		768											753	445		765		5198			0.1	334	334		146
10	Benjamin White	50	DEF	Arsenal	0.44	38	0.11	3.6	49	2	8	2217969	0.7		31.2	12	1.06	5	nan	37.23	-5	1.1	159	6	649		3.3	6	White	491.2	84	61	1.25	a	24	5	35	nan	0.15	5	19	9		59	130	3.4	1	4.85		36	4.1	3054	156	true	69	21	0.04	208	3.9	3320417	734	1.03	16.1	17	6	15	197
11	Eddie Nketiah	63	FWD	Arsenal	0.17	17	0.11	1.26	303	4	38	1865358	0.1		10	5	0.76	-7	2023-03-02T00:00:07.606120Z	14.65	7	1.23	598	24	213.4		1	1	Nketiah	128.2	143	247	7.89	a	27	3	16	nan	0.77	2	48	24	100	294	93.1	0.6	1	9.15	100	9	2.1	1071	63		332	145	0.66	43	1.1	1928295	161	1.34	1.8	33	42	2	61
12	Emile Smith Rowe	56	MID	Arsenal		186	0.31	0.55	421		180	151276	0.2		3.2			-4	2023-02-03T10:30:09.166437Z	2.71	4	1.51	39	101	36.6		0.7	4	Smith Rowe	64.3	427	348	0.25	a	50		5	nan	0.45	2	137	192	100	455	13.8	1		0.8	100		1.5	161	18		290	301	0.14	383	1.5	29334	60	2.8	0.4	200	183		95


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