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 17–18

@kaggle.krishanthbarkav_english_premier_leagueepl_player_statistics.pl_17_18

88.93 KB
793 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	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	penalties_scored Penalties Scored	shots Shots	shots_on_target Shots On Target	shooting_accuracy Shooting Accuracy %	big_chances_missed Big Chances Missed	saves Saves	punches Punches	high_claims High Claims	catches Catches	sweeper_clearances Sweeper Clearances	throw_outs Throw Outs	goal_kicks Goal Kicks
	Rolando Aarons	Midfielder	4			4	100%		1			9	12	14	4	1	3			41	10.25		2	50%		1			1	1								2	1	50%
1	Abdul Rahman Baba	Defender					0%																	0%																nan
2	Tammy Abraham	Forward	31			10	nan	11	1	11	8								1	300	9.68	3	13	nan					15	9	5		4			0.16		42	15	36%	4
3	Charlie Adam	Midfielder	11			9	56%	3	9	9	5	40	36	29	12	7	5	1		246	22.36	3	30	27%	3	23	2	1	8						1			10	3	30%	1
4	Adrián	Goalkeeper	19	6	29		nan													520	27.37			nan		174	2		1											nan		69	6	9	2	15	47	184
5	Adrien Silva	Midfielder	12			22	59%	5	14			58	47	68	6	11	19		1	433	36.08	1	4	0%	3	19	3		9									11	2	18%
6	Ibrahim Afellay	Midfielder	6			3	100%		1	1	1	15	4	5	1					81	13.5			0%		4	1		1											0%
7	Benik Afobe	Forward	17			4	nan	4		6	5									152	8.94		2	nan					9	4								8	3	38%	2
8	Sergio Agüero	Forward	25			9	nan	20	6	3	1								6	628	25.12	10	16	nan			2		10	16	21	5	15	1	3	0.84	4	94	42	45%	13
9	Daniel Agyei	Forward					nan																	nan																0%


CREATE TABLE pl_17_18 (
  "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
);