Premier League Player Stats 23/24

Comprehensive statistics of Premier League players for the 2023/24 season

@kaggle.indrajuliansyahputra_premier_league_player_stats_2324

Table List

2 tables(140.17 KB)

Player Stats

@kaggle.indrajuliansyahputra_premier_league_player_stats_2324.player_stats

103.14 KB
1019 rows
57 columns

name Name	twitter Twitter	instagram Instagram	appearances Appearances	goals Goals	wins Wins	losses Losses	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	own_goals Own Goals	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	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	shots Shots	shots_on_target Shots On Target	shooting_accuracy Shooting Accuracy %	big_chances_missed Big Chances Missed	facebook Facebook
Max Aarons	https://twitter.com/maxaarons2	https://www.instagram.com/maxaarons2/	90		12	62	10	174	141	66%	1	13	73	165	63	4	407	404	383	96	41	111	1	4	2887	32.08	10	136	21%	7	94	16	68	6								nan		nan
Zach Abbott	nan	nan								0%																			0%													nan		nan
Terry Ablade	nan	nan								nan																			nan													0%		nan
Josh Acheampong	nan	nan	1		1					0%							1		1			1			1	1			0%													nan		nan
Tyler Adams	https://www.instagram.com/tyler.adams/	nan	3		2	1			4	75%			4	2	2		7	11	4	2	2	3			69	23		1	0%		4											0%		nan
Tosin Adarabioyo	nan	nan	20	2	8	8	6	25	21	52%		2	25	80	47		43	83	51	1	57	28			1211	60.55		1	0%	1	72	2	10		2			1				nan		nan
Tayo Adaramola	nan	nan								0%																			0%													nan		nan
Elijah Adebayo	nan	nan	27	10	5	16			4	nan		7	6	25	24										197	7.3		5	nan			1	27	13	4	5	1	2	0.37	31	14	45%	4	nan
Valintino Adedokun	nan	nan								0%																			0%													nan		nan
Simon Adingra	nan	nan	31	6	9	12			45	nan		7	19	22	9									1	747	24.1	6	76	nan			3	29	17	1	5		1	0.19	52	22	42%	4	nan


CREATE TABLE player_stats (
  "name" VARCHAR,
  "twitter" VARCHAR,
  "instagram" VARCHAR,
  "appearances" DOUBLE,
  "goals" DOUBLE,
  "wins" DOUBLE,
  "losses" DOUBLE,
  "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" DOUBLE,
  "passes" BIGINT,
  "passes_per_match" DOUBLE,
  "big_chances_created" DOUBLE,
  "crosses" DOUBLE,
  "cross_accuracy" VARCHAR,
  "through_balls" DOUBLE,
  "accurate_long_balls" DOUBLE,
  "yellow_cards" DOUBLE,
  "red_cards" DOUBLE,
  "fouls" DOUBLE,
  "offsides" DOUBLE,
  "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,
  "facebook" VARCHAR
);