Premier League Player's Stats

@kaggle.sophieg_premier_league_players_stats

Table List

5 tables(1.08 MB)

Events

Fixtures

Fixture Stats

Players

Teams

Players

@kaggle.sophieg_premier_league_players_stats.players

236.23 KB
865 rows
80 columns

unnamed_0 Unnamed: 0	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	id Id	in_dreamteam In Dreamteam	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_out Transfers Out	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	own_goals Own Goals	yellow_cards Yellow Cards	red_cards Red Cards	bonus Bonus	bps Bps	influence Influence	creativity Creativity	threat Threat	ict_index Ict Index	starts Starts	expected_goals Expected Goals	expected_assists Expected Assists	expected_goal_involvements Expected Goal Involvements	expected_goals_conceded Expected Goals Conceded	influence_rank Influence Rank	influence_rank_type Influence Rank Type	creativity_rank Creativity Rank	creativity_rank_type Creativity Rank Type	threat_rank Threat Rank	threat_rank_type Threat Rank Type	ict_index_rank Ict Index Rank	ict_index_rank_type Ict Index Rank Type	penalties_order Penalties Order	expected_goals_per_90 Expected Goals Per 90	expected_assists_per_90 Expected Assists Per 90	expected_goal_involvements_per_90 Expected Goal Involvements Per 90	expected_goals_conceded_per_90 Expected Goals Conceded Per 90	goals_conceded_per_90 Goals Conceded Per 90	now_cost_rank Now Cost Rank	now_cost_rank_type Now Cost Rank Type	form_rank Form Rank	form_rank_type Form Rank Type	points_per_game_rank Points Per Game Rank	points_per_game_rank_type Points Per Game Rank Type	selected_rank Selected Rank	selected_rank_type Selected Rank Type	starts_per_90 Starts Per 90	clean_sheets_per_90 Clean Sheets Per 90
			232223	-1	1		4				Folarin		1		Transferred to Monaco	2023-08-31T08:55:15.272751Z	44	232223.jpg		Balogun	0.2	u	1	3		10024	63680			Balogun																				706	73	701	73	672	72	709	75							560	104	618	56	720	78	354	52
1			58822	-2	2		2	1	1		Cédric		2		nan	nan	38	58822.jpg	1	Alves Soares	0.5	a	1	3	3	76023	71397		0.8	Cédric	59									15	2	4.3		0.6			0.02	0.02	0.39	531	191	473	175	491	180	525	185			0.03	0.03	0.59		854	271	419	143	454	156	242	96
2	100	100	153256	-1	1		3	1	1		Mohamed		3		nan	2023-12-30T22:30:09.113694Z	44	153256.jpg	2	Elneny	0.1	a	1	3	6	13751	20652		1.4	M.Elneny	25		1							16	4	2.1	10	1.6		0.08	0.01	0.09	0.13	517	231	486	233	447	221	512	232		0.29	0.04	0.33	0.47		532	319	605	211	305	127	473	154
3	100	100	438098	-1	1		3	1.2	1.2		Fábio	0.2	4		nan	2023-12-07T12:00:08.489004Z	54	438098.jpg	2.2	Ferreira Vieira	0.1	a	1	3	24	11816	19255		4.4	Fábio Vieira	290	1	3	1	2			1		67	82.8	88.8	85	25.5	2	1.25	0.64	1.89	1.83	414	177	323	177	304	152	392	178	4	0.39	0.2	0.59	0.57	0.62	121	73	409	191	277	116	449	144	0.62	0.31
4	100	100	226597	4	-4	3	2	6.4	5.7	1	Gabriel	4.7	5	true	nan	2024-03-18T22:00:08.938811Z	54	226597.jpg	4.1	dos Santos Magalhães	28.3	a	1	3	149	3607340	3574404	0.9	27.6	Gabriel	3042	3	1	16	26	1	4		8	676	674.6	121.9	379	117.8	34	4.48	0.65	5.13	26.18	65	21	276	82	103	4	121	22		0.13	0.02	0.15	0.77	0.77	116	13	40	13	45	6	9	2	1.01	0.47
5	100	100	219847	1	-1	5	3	9.2	8.8	6	Kai	7.8	6		nan	2023-12-23T20:00:08.458889Z	76	219847.jpg	4.9	Havertz	11.9	a	1	3	180	1629451	832407	1	23.7	Havertz	2627	13	10	16	22		11		15	515	763.2	613.4	1027	240.2	30	12.36	3.88	16.23	21.03	47	15	51	45	14	8	19	15	3	0.42	0.13	0.55	0.72	0.75	20	12	4	2	19	15	34	11	1.03	0.55
6	100	100	205651	-3	3	1	4	3.2	3	1	Gabriel	2	8		nan	2024-02-05T08:30:09.036230Z	77	205651.jpg	3.1	Fernando de Jesus	2.6	a	1	3	85	1145854	1236225	0.3	11	G.Jesus	1470	4	7	11	11		6		10	271	364.8	403	756	152.7	17	6.27	3.26	9.53	11.67	210	24	95	10	31	15	77	17		0.38	0.2	0.58	0.71	0.67	18	7	180	29	151	26	118	21	1.04	0.67
7	100	100	85955	-2	2		3	1.4	1.3		Jorge Luiz	0.3	9		nan	2023-12-18T00:00:09.353001Z	53	85955.jpg	1.8	Frello Filho	0.2	a	1	3	44	12306	22411	0.1	8.3	Jorginho	913		2	4	11		1		1	182	165.4	187.8	16	36.8	10	0.1	1.77	1.87	8.42	348	147	211	130	433	213	346	156		0.01	0.17	0.18	0.83	1.08	127	77	344	164	356	156	348	105	0.99	0.39
8			440854	-5	5	1	2	2.6	2.3		Jakub	1.3	10		nan	nan	40	440854.jpg	3.4	Kiwior	0.6	a	1	3	67	254158	204509	0.3	16.8	Kiwior	942	1	3	6	8		1		1	260	228.8	106.9	90	42.7	11	0.74	0.6	1.34	5.15	304	115	301	94	295	94	321	111		0.07	0.06	0.13	0.49	0.76	726	190	217	59	91	16	225	89	1.05	0.57
9			479683				3				Marcus		11		Season long loan to FC Nantes	2023-08-14T03:57:12.475590Z	45	479683.jpg		Oliveira Alencar		u	1	3		819	11967			Marquinhos																				759	299	753	298	738	290	763	300							427	251	688	255	765	303	557	194


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