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

@kaggle.krishanthbarkav_english_premier_leagueepl_player_statistics.pl_16_17

91.02 KB
839 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	fouls Fouls	offsides Offsides	goals 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
	Almen Abdi	Midfielder					0%																	0%														0%
1	Abdul Rahman Baba	Defender					0%																	0%														nan
2	Tammy Abraham	Forward					nan																	nan														0%
3	Charlie Adam	Midfielder	24			19	79%	12	21	24	9	110	90	106	12	33	16	1	3	868	36.17	3	85	32%	7	97	7	41		1		1	4	0.04	1	40	11	28%	1
4	Adam Clayton	Midfielder	34			79	71%	3	66	40	15	215	158	156	19	20	17	1	2	1450	42.65	1	23	35%	2	113	10	52								11	2	18%
5	Emmanuel Adebayor	Forward					nan																	nan														0%
6	Albert Adomah	Midfielder	2			5	80%	2	1			6	9	18	2		5			32	16		9	22%		1		3								4		0%	1
7	Adrián	Goalkeeper	16	6	25		nan											1		417	26.06			nan		129	1											nan		53	5	16	2	13	56	130
8	Ibrahim Afellay	Midfielder	12			3	67%	2	4	1		35	20	24	9	1	4			189	15.75	1	15	13%	1	4		3	2							6	1	17%	1
9	Benik Afobe	Forward	31			9	nan	6	5	19	16								3	297	9.58	2	2	nan			1	21	14	6	3	3	2	0.19		39	18	46%	13


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