English Premier League EPL Player Stats(till23/24)

EPL Player Performance of each season 15-16 to 23-24

@kaggle.krishanthbarkav_english_premier_leagueepl_player_statistics

Table List

9 tables(823.74 KB)

Pl 15–16

@kaggle.krishanthbarkav_english_premier_leagueepl_player_statistics.pl_15_16

87.51 KB
757 rows
54 columns

unnamed_0 Unnamed: 0	name Name	position Position	appearances Appearances	clean_sheets Clean Sheets	goals_conceded Goals Conceded	tackles Tackles	tackle_success Tackle Success %	blocked_shots Blocked Shots	interceptions Interceptions	clearances Clearances	headed_clearance Headed Clearance	clearances_off_line Clearances Off Line	recoveries Recoveries	duels_won Duels Won	duels_lost Duels Lost	successful_50_50s Successful 50/50s	aerial_battles_won Aerial Battles Won	aerial_battles_lost Aerial Battles Lost	errors_leading_to_goal Errors Leading To Goal	assists Assists	passes Passes	passes_per_match Passes Per Match	big_chances_created Big Chances Created	crosses Crosses	cross_accuracy Cross Accuracy %	through_balls Through Balls	accurate_long_balls Accurate Long Balls	yellow_cards Yellow Cards	red_cards Red Cards	fouls Fouls	offsides Offsides	goals Goals	headed_goals Headed Goals	goals_with_right_foot Goals With Right Foot	goals_with_left_foot Goals With Left Foot	hit_woodwork Hit Woodwork	goals_per_match Goals Per Match	freekicks_scored Freekicks Scored	shots Shots	shots_on_target Shots On Target	shooting_accuracy Shooting Accuracy %	big_chances_missed Big Chances Missed	saves Saves	penalties_saved Penalties Saved	punches Punches	high_claims High Claims	catches Catches	sweeper_clearances Sweeper Clearances	throw_outs Throw Outs	goal_kicks Goal Kicks
	Rolando Aarons	Midfielder	10			13	77%		6	10	5		23	29	34	5	4	6	1	1	119	11.9	1	12	25%		7	1		9		1			1		0.1		2	1	50%
1	Almen Abdi	Midfielder	32			83	78%	10	32	24	9		137	140	153	12	22	31			938	29.31	4	55	31%	2	36	4		38	1	2		2		1	0.06	1	39	10	26%	1
2	Abdul Rahman Baba	Defender	15	2	13	47	83%	1	23	32	13	1	76	67	65	8	8	13	1	1	526	35.07		31	16%		18	1		14	2										nan
3	Mehdi Abeid	Midfielder					0%																		0%																0%
4	Tammy Abraham	Forward	2				nan	1													10	5		2	nan					2	3								2		0%
5	Charlie Adam	Midfielder	22			18	78%	9	12	14	10		73	68	76	10	17	10		1	546	24.82	1	40	30%	1	68	6	1	30		1		1			0.05		29	4	14%
6	Emmanuel Adebayor	Forward	12			2	nan	2	1	7	4									1	230	19.17		6	nan			1		10	11	1	1			1	0.08		12	4	33%	2
7	Adrián	Goalkeeper	32	9	39		nan												2		853	26.66			nan		275	1	1	1											nan		99	2	19	40	11	31	155	288
8	Ibrahim Afellay	Midfielder	31			27	81%	10	11	12	5		162	117	110	41	14	16		2	1274	41.1	3	68	16%	3	68	3	1	19	2	2	1	1			0.06		39	8	21%	1
9	Benik Afobe	Forward	15			5	nan	2	2	9	6										224	14.93		4	nan					15	9	4	3	1			0.27		14	5	36%	4


CREATE TABLE pl_15_16 (
  "unnamed_0" BIGINT,
  "name" VARCHAR,
  "position" VARCHAR,
  "appearances" BIGINT,
  "clean_sheets" DOUBLE,
  "goals_conceded" DOUBLE,
  "tackles" DOUBLE,
  "tackle_success" VARCHAR,
  "last_man_tackles" DOUBLE,
  "blocked_shots" DOUBLE,
  "interceptions" DOUBLE,
  "clearances" DOUBLE,
  "headed_clearance" DOUBLE,
  "clearances_off_line" DOUBLE,
  "recoveries" DOUBLE,
  "duels_won" DOUBLE,
  "duels_lost" DOUBLE,
  "successful_50_50s" DOUBLE,
  "aerial_battles_won" DOUBLE,
  "aerial_battles_lost" DOUBLE,
  "own_goals" DOUBLE,
  "errors_leading_to_goal" DOUBLE,
  "assists" BIGINT,
  "passes" BIGINT,
  "passes_per_match" DOUBLE,
  "big_chances_created" DOUBLE,
  "crosses" DOUBLE,
  "cross_accuracy" VARCHAR,
  "through_balls" DOUBLE,
  "accurate_long_balls" DOUBLE,
  "yellow_cards" BIGINT,
  "red_cards" BIGINT,
  "fouls" BIGINT,
  "offsides" DOUBLE,
  "goals" BIGINT,
  "headed_goals" DOUBLE,
  "goals_with_right_foot" DOUBLE,
  "goals_with_left_foot" DOUBLE,
  "hit_woodwork" DOUBLE,
  "goals_per_match" DOUBLE,
  "penalties_scored" DOUBLE,
  "freekicks_scored" DOUBLE,
  "shots" DOUBLE,
  "shots_on_target" DOUBLE,
  "shooting_accuracy" VARCHAR,
  "big_chances_missed" DOUBLE,
  "saves" DOUBLE,
  "penalties_saved" DOUBLE,
  "punches" DOUBLE,
  "high_claims" DOUBLE,
  "catches" DOUBLE,
  "sweeper_clearances" DOUBLE,
  "throw_outs" DOUBLE,
  "goal_kicks" DOUBLE
);