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

@kaggle.krishanthbarkav_english_premier_leagueepl_player_statistics.pl_18_19

92.8 KB
884 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 %	last_man_tackles Last Man Tackles	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	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	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
	Rolando Aarons	Midfielder					0%																		0%															0%
1	Abdul Rahman Baba	Defender					0%																		0%															nan
2	Tammy Abraham	Forward					nan																		nan															0%
3	Adrián	Goalkeeper					nan																		nan															nan
4	Adrien Silva	Midfielder	2			2	100%			1	1	1		5	5	7	1		2		79	39.5			0%		7													0%
5	Benik Afobe	Forward					nan																		nan															0%
6	Sergio Agüero	Forward	33			17	nan		31	9	3									8	771	23.36	6	13	nan			3	21	26	21	2	10	8	8	0.64	2	118	43	36%	10
7	Daniel Agyei	Forward					nan																		nan															0%
8	Soufyan Ahannach	Midfielder					0%																		0%															0%
9	Nathan Aké	Defender	38	10	70	66	53%	1	7	32	230	127	2	182	176	114	3	88	73		1696	44.63	2	6	83%	1	71	3	28	2	4	3		1	1					nan


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