Fantasy Premier League 2019 -20

Predict total points of a player

@kaggle.aj3907_fantasy_premier_league_2019_20

Table List

4 tables(343.15 KB)

Team Details

@kaggle.aj3907_fantasy_premier_league_2019_20.team_details

8.64 KB
20 rows
10 columns

id Id	name Name	short_name Short Name	strength Strength	strength_overall_home Strength Overall Home	strength_overall_away Strength Overall Away	strength_attack_home Strength Attack Home	strength_attack_away Strength Attack Away	strength_defence_home Strength Defence Home	strength_defence_away Strength Defence Away
1	Arsenal	ARS	4	1230	1270	1150	1190	1280	1330
2	Aston Villa	AVL	2	1040	1080	1030	1060	1030	1050
3	Bournemouth	BOU	3	1090	1120	1030	1070	1110	1180
4	Brighton	BHA	3	1050	1120	1040	1160	1030	1130
5	Burnley	BUR	3	1050	1110	1060	1130	1050	1050
6	Chelsea	CHE	4	1270	1300	1200	1320	1310	1350
7	Crystal Palace	CRY	3	1110	1100	1060	1130	1040	1020
8	Everton	EVE	3	1100	1160	1110	1190	1090	1160
9	Leicester	LEI	4	1230	1280	1180	1240	1110	1190
10	Liverpool	LIV	5	1340	1360	1300	1330	1340	1370


CREATE TABLE team_details (
  "id" BIGINT,
  "name" VARCHAR,
  "short_name" VARCHAR,
  "strength" BIGINT,
  "strength_overall_home" BIGINT,
  "strength_overall_away" BIGINT,
  "strength_attack_home" BIGINT,
  "strength_attack_away" BIGINT,
  "strength_defence_home" BIGINT,
  "strength_defence_away" BIGINT
);