English Premier League Players Dataset, 2017/18

A unique dataset containing FPL data, popularity and market values

@kaggle.mauryashubham_english_premier_league_players_dataset

Table List

1 table(25.79 KB)

Epldata Final

@kaggle.mauryashubham_english_premier_league_players_dataset.epldata_final

25.79 KB
461 rows
17 columns

name Name	club Club	age Age	position Position	position_cat Position Cat	market_value Market Value	page_views Page Views	fpl_value Fpl Value	fpl_sel Fpl Sel	fpl_points Fpl Points	region Region	nationality Nationality	age_cat Age Cat	club_id Club Id	big_club Big Club	new_signing New Signing
Alexis Sanchez	Arsenal	28	LW	1	65	4329	12	17.10%	264	3	Chile	4	1	1
Mesut Ozil	Arsenal	28	AM	1	50	4395	9.5	5.60%	167	2	Germany	4	1	1
Petr Cech	Arsenal	35	GK	4	7	1529	5.5	5.90%	134	2	Czech Republic	6	1	1
Theo Walcott	Arsenal	28	RW	1	20	2393	7.5	1.50%	122	1	England	4	1	1
Laurent Koscielny	Arsenal	31	CB	3	22	912	6	0.70%	121	2	France	4	1	1
Hector Bellerin	Arsenal	22	RB	3	30	1675	6	13.70%	119	2	Spain	2	1	1
Olivier Giroud	Arsenal	30	CF	1	22	2230	8.5	2.50%	116	2	France	4	1	1
Nacho Monreal	Arsenal	31	LB	3	13	555	5.5	4.70%	115	2	Spain	4	1	1
Shkodran Mustafi	Arsenal	25	CB	3	30	1877	5.5	4.00%	90	2	Germany	3	1	1	1
Alex Iwobi	Arsenal	21	LW	1	10	1812	5.5	1.00%	89	4	Nigeria	1	1	1


CREATE TABLE epldata_final (
  "name" VARCHAR,
  "club" VARCHAR,
  "age" BIGINT,
  "position" VARCHAR,
  "position_cat" BIGINT,
  "market_value" DOUBLE,
  "page_views" BIGINT,
  "fpl_value" DOUBLE,
  "fpl_sel" VARCHAR,
  "fpl_points" BIGINT,
  "region" DOUBLE,
  "nationality" VARCHAR,
  "new_foreign" BIGINT,
  "age_cat" BIGINT,
  "club_id" BIGINT,
  "big_club" BIGINT,
  "new_signing" BIGINT
);