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
EPL Player Performance of each season 15-16 to 23-24
@kaggle.krishanthbarkav_english_premier_leagueepl_player_statistics
So, I was trying to predict the rating of players in the FIFA21 game which is going to be released in the coming weeks by using their individual performance in the previous season and the rating in the previous edition of the game FIFA20. But, I couldn't find a dataset for this. So I had no option other than to scrape data from the PL website itself.
Each row in the datasets represents each player's performance in that particular season. It starts with Name, Position, Appearances, and the statistics of his performance throughout the season. Some entries are null because those attributes don't correspond to the position in which the player actually plays, for instance, a Forward will not have Number of saves; it doesn't make sense.
To all those football freaks like me, Feel free to use this dataset
Let me know if there's an error
CREATE TABLE pl_15_16 (
"unnamed_0" BIGINT -- Unnamed: 0,
"name" VARCHAR,
"position" VARCHAR,
"appearances" BIGINT,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"tackles" DOUBLE,
"tackle_success" VARCHAR -- Tackle Success %,
"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 -- Cross Accuracy %,
"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 -- Shooting Accuracy %,
"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
);CREATE TABLE pl_16_17 (
"unnamed_0" BIGINT -- Unnamed: 0,
"name" VARCHAR,
"position" VARCHAR,
"appearances" BIGINT,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"tackles" DOUBLE,
"tackle_success" VARCHAR -- Tackle Success %,
"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 -- Cross Accuracy %,
"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 -- Shooting Accuracy %,
"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
);CREATE TABLE pl_17_18 (
"unnamed_0" BIGINT -- Unnamed: 0,
"name" VARCHAR,
"position" VARCHAR,
"appearances" BIGINT,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"tackles" DOUBLE,
"tackle_success" VARCHAR -- Tackle Success %,
"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 -- Cross Accuracy %,
"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 -- Shooting Accuracy %,
"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
);CREATE TABLE pl_18_19 (
"unnamed_0" BIGINT -- Unnamed: 0,
"name" VARCHAR,
"position" VARCHAR,
"appearances" BIGINT,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"tackles" DOUBLE,
"tackle_success" VARCHAR -- Tackle Success %,
"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 -- Cross Accuracy %,
"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 -- Shooting Accuracy %,
"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
);CREATE TABLE pl_19_20 (
"unnamed_0" BIGINT -- Unnamed: 0,
"name" VARCHAR,
"position" VARCHAR,
"appearances" BIGINT,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"tackles" DOUBLE,
"tackle_success" VARCHAR -- Tackle Success %,
"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 -- Cross Accuracy %,
"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 -- Shooting Accuracy %,
"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
);CREATE TABLE pl_20_21 (
"unnamed_0" BIGINT -- Unnamed: 0,
"name" VARCHAR,
"position" VARCHAR,
"appearances" BIGINT,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"tackles" DOUBLE,
"tackle_success" VARCHAR -- Tackle Success %,
"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 -- Cross Accuracy %,
"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 -- Shooting Accuracy %,
"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
);CREATE TABLE pl_21_22 (
"name" VARCHAR,
"position" VARCHAR,
"appearances" BIGINT,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"tackles" DOUBLE,
"tackle_success" VARCHAR -- Tackle Success %,
"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 -- Cross Accuracy %,
"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 -- Shooting Accuracy %,
"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
);CREATE TABLE pl_22_23 (
"name" VARCHAR,
"position" VARCHAR,
"appearances" BIGINT,
"goals" BIGINT,
"goals_per_match" DOUBLE,
"headed_goals" DOUBLE,
"goals_with_right_foot" DOUBLE,
"goals_with_left_foot" DOUBLE,
"penalties_scored" DOUBLE,
"freekicks_scored" DOUBLE,
"shots" DOUBLE,
"shots_on_target" DOUBLE,
"shooting_accuracy" VARCHAR -- Shooting Accuracy %,
"hit_woodwork" DOUBLE,
"big_chances_missed" DOUBLE,
"assists" BIGINT,
"passes" BIGINT,
"passes_per_match" DOUBLE,
"big_chances_created" DOUBLE,
"crosses" DOUBLE,
"cross_accuracy" VARCHAR -- Cross Accuracy %,
"through_balls" DOUBLE,
"accurate_long_balls" DOUBLE,
"yellow_cards" BIGINT,
"red_cards" BIGINT,
"fouls" BIGINT,
"offsides" DOUBLE,
"tackles" DOUBLE,
"tackle_success" VARCHAR -- Tackle Success %,
"blocked_shots" DOUBLE,
"interceptions" DOUBLE,
"clearances" DOUBLE,
"headed_clearance" DOUBLE,
"recoveries" DOUBLE,
"duels_won" DOUBLE,
"duels_lost" DOUBLE,
"successful_50_50s" DOUBLE,
"aerial_battles_won" DOUBLE,
"aerial_battles_lost" DOUBLE,
"errors_leading_to_goal" DOUBLE,
"saves" DOUBLE,
"penalties_saved" DOUBLE,
"punches" DOUBLE,
"high_claims" DOUBLE,
"catches" DOUBLE,
"sweeper_clearances" DOUBLE,
"throw_outs" DOUBLE,
"goal_kicks" DOUBLE,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"own_goals" DOUBLE,
"last_man_tackles" DOUBLE,
"clearances_off_line" DOUBLE
);CREATE TABLE pl_23_24 (
"name" VARCHAR,
"position" VARCHAR,
"appearances" BIGINT,
"clean_sheets" DOUBLE,
"goals_conceded" DOUBLE,
"tackles" DOUBLE,
"tackle_success" VARCHAR -- Tackle Success %,
"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 -- Cross Accuracy %,
"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 -- Shooting Accuracy %,
"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
);Anyone who has the link will be able to view this.