EPL Players Deep Stats 2019/2020

Premier League Players Statistics season 19/20

@kaggle.cashncarry_epl_players_deep_stats_20192020

Table List

1 table(60.04 KB)

Epl Players Stats

@kaggle.cashncarry_epl_players_deep_stats_20192020.epl_players_stats

60.04 KB
522 rows
41 columns

id Id	name Name	nationality Nationality	team Team	team_id Team Id	age Age	height Height	weight Weight	position Position	roles Roles	games Games	exit_on_sub Exit On Sub	minutes Minutes	rating_m Rating M	goals Goals	assists Assists	yel_cards Yel Cards	shots_m Shots M	aerials_won_m Aerials Won M	motm Motm	successful_passes_pt Successful Passes Pt	key_passes_m Key Passes M	dribbles_won_m Dribbles Won M	fouls_given_m Fouls Given M	offside_m Offside M	dispossessed_m Dispossessed M	passes_m Passes M	accurate_crosses_m Accurate Crosses M	accurate_long_passes_m Accurate Long Passes M	accurate_through_passes_m Accurate Through Passes M	tackles_m Tackles M	interceptions_m Interceptions M	fouls_m Fouls M	clearances_m Clearances M	dribbled_past_m Dribbled Past M
816	Kevin De Bruyne	be	Man City	875	29	181	68	Midfielder	M_C,M_L,M_R,FW	35	3	2800	7.97	13	20	3	2.8	0.5	10	81.5	3.9	1.4	0.8	0.1	0.9	54.5	2.1	3.5	0.4	1.3	0.5	0.7	0.7	1.4
622	Bruno Fernandes	pt	Man Utd	314	26	179	69	Midfielder	M_C,M_L,M_R	14		1223	7.73	8	7	2	3.1	0.2	3	75.7	2.1	1.1	1	0.1	0.9	55.5	1	3.3	0.3	1.6	0.8	0.6	1	2.4
812	Ricardo Pereira	pt	Leicester	652	26	175	70	Defender	D_L,D_R,M_R	28		2520	7.5	3	2	1	0.6	1.5	2	78.9	1	2.1	1.3		1.1	56.1	0.3	2.1	0.1	4.2	1.8	1.6	2.6	1.9
287	Adama Traoré	es	Wolves	518	24	178	72	Forward	M_L,M_R,FW	37	10	2608	7.49	4	9	1	1.2	1.2	6	74.4	1.3	5	2.1	0.2	1.8	19.2	1.2	0.2	0.1	0.9	0.4	1.1	0.4	0.4
158	Riyad Mahrez	dz	Man City	875	29	179	67	Forward	AM_C,AM_L,AM_R	33	12	1942	7.48	11	9		2.2	0.3	3	90.1	1.8	1.6	0.9	0.4	1	33.2	0.6	1.7	0.2	0.8	0.5	0.4	0.2	0.8
576	Sadio Mané	sn	Liverpool	339	28	175	69	Forward	AM_C,AM_L,AM_R,FW	35	4	2756	7.45	18	7	3	2.2	1.2	7	81.6	1.7	2	1.5	0.4	1.6	31.5	0.3	1	0.1	1.3	0.4	1.3	0.2	0.8
506	Mohamed Salah	eg	Liverpool	339	28	175	71	Forward	AM_C,AM_L,AM_R,FW	34	1	2888	7.4	19	10	1	3.9	0.4	6	76.5	1.8	1.5	0.5	0.6	2	28.8	0.3	0.4	0.1	0.5	0.2	0.5	0.1	0.5
491	Raheem Sterling	gb-eng	Man City	875	25	170	69	Forward	M_C,M_L,M_R,FW	33	3	2661	7.35	20	1	5	3	0.7	1	82.8	1.5	1.7	1.2	0.4	1.8	35.4	0.2	0.3	0.1	0.8	0.5	0.9	0.1	0.7
988	Marcus Rashford	gb-eng	Man Utd	314	22	180	70	Forward	AM_L,AM_R,FW	31		2655	7.35	17	7	3	3.1	0.7	7	77.3	1.1	1.9	1.5	0.4	1.1	30.4	0.3	1.2	0.2	0.4	0.3	0.7	0.5	0.5
177	James Maddison	gb-eng	Leicester	652	23	175	73	Midfielder	AM_C,AM_L,AM_R	31	2	2629	7.34	6	3	4	2.4	0.2	4	83	2.5	1.6	2.8	0.1	0.9	47.5	1.9	2.3	0.2	1.9	0.3	1.2	0.2	1.5


CREATE TABLE epl_players_stats (
  "id" BIGINT,
  "name" VARCHAR,
  "nationality" VARCHAR,
  "team" VARCHAR,
  "team_id" BIGINT,
  "age" BIGINT,
  "height" BIGINT,
  "weight" BIGINT,
  "position" VARCHAR,
  "roles" VARCHAR,
  "games" BIGINT,
  "exit_on_sub" BIGINT,
  "minutes" BIGINT,
  "rating_m" DOUBLE,
  "goals" BIGINT,
  "assists" BIGINT,
  "yel_cards" BIGINT,
  "red_cards" BIGINT,
  "shots_m" DOUBLE,
  "aerials_won_m" DOUBLE,
  "motm" BIGINT,
  "successful_passes_pt" DOUBLE,
  "key_passes_m" DOUBLE,
  "dribbles_won_m" DOUBLE,
  "fouls_given_m" DOUBLE,
  "offside_m" DOUBLE,
  "dispossessed_m" DOUBLE,
  "passes_m" DOUBLE,
  "accurate_crosses_m" DOUBLE,
  "accurate_long_passes_m" DOUBLE,
  "accurate_through_passes_m" DOUBLE,
  "tackles_m" DOUBLE,
  "interceptions_m" DOUBLE,
  "fouls_m" DOUBLE,
  "clearances_m" DOUBLE,
  "dribbled_past_m" DOUBLE,
  "owm_goals" BIGINT,
  "gk_in_goal_area_saves_m" DOUBLE,
  "gk_inside_box_saves_m" DOUBLE,
  "gk_outside_box_saves_m" DOUBLE,
  "gk_saves_m" DOUBLE
);