English Premier League Data Compilation
Budget: $30 – $250 USD
I need an Excel file.
Each row = 1 match (game) in the English Premier League.
Seasons: from 2016–2017 to 2021–2022.
Columns I need (exact names):
season
Example values: 2016-2017, 2017-2018, 2018-2019, 2019-2020, 2020-2021, 2021-2022
date
Date of the match (for example: 2018-09-15)
weekend
Put 1 if the match is played on Friday, Saturday, or Sunday.
Put 0 if the match is played on Monday, Tuesday, Wednesday, or Thursday.
home_team
Name of the team that is playing at home (please use the same spelling for each team every time).
away_team
Name of the team that is playing away (same spelling always).
home_goals
Number of goals scored by the home team in the match.
away_goals
Number of goals scored by the away team in the match.
home_penalties_awarded
Number of penalty kicks given to the home team during the match.
This means a special kick from the penalty spot after a foul in the penalty area.
away_penalties_awarded
Number of penalty kicks given to the away team during the match.
home_yellow_cards
Number of yellow cards given to the home team in the match.
away_yellow_cards
Number of yellow cards given to the away team in the match.
home_red_cards
Number of red cards given to the home team in the match.
away_red_cards
Number of red cards given to the away team in the match.
Important conditions:
Only use matches from the English Premier League (the main league in England).
Do not include cup matches like FA Cup, League Cup, Champions League, Europa League, etc.
Include all seasons from 2016–2017 to 2021–2022.
Each season should have 380 matches.
So the final file should have 2,280 rows (6 seasons × 380 matches).
Penalties = normal penalty kicks inside the match (fouls in the penalty area).
Please also tell me which website you used to get the data
(for example: FBref, Understat, Premier League official website, etc.).
Final file should be .xlsx.
Each row = 1 match (game) in the English Premier League.
Seasons: from 2016–2017 to 2021–2022.
Columns I need (exact names):
season
Example values: 2016-2017, 2017-2018, 2018-2019, 2019-2020, 2020-2021, 2021-2022
date
Date of the match (for example: 2018-09-15)
weekend
Put 1 if the match is played on Friday, Saturday, or Sunday.
Put 0 if the match is played on Monday, Tuesday, Wednesday, or Thursday.
home_team
Name of the team that is playing at home (please use the same spelling for each team every time).
away_team
Name of the team that is playing away (same spelling always).
home_goals
Number of goals scored by the home team in the match.
away_goals
Number of goals scored by the away team in the match.
home_penalties_awarded
Number of penalty kicks given to the home team during the match.
This means a special kick from the penalty spot after a foul in the penalty area.
away_penalties_awarded
Number of penalty kicks given to the away team during the match.
home_yellow_cards
Number of yellow cards given to the home team in the match.
away_yellow_cards
Number of yellow cards given to the away team in the match.
home_red_cards
Number of red cards given to the home team in the match.
away_red_cards
Number of red cards given to the away team in the match.
Important conditions:
Only use matches from the English Premier League (the main league in England).
Do not include cup matches like FA Cup, League Cup, Champions League, Europa League, etc.
Include all seasons from 2016–2017 to 2021–2022.
Each season should have 380 matches.
So the final file should have 2,280 rows (6 seasons × 380 matches).
Penalties = normal penalty kicks inside the match (fouls in the penalty area).
Please also tell me which website you used to get the data
(for example: FBref, Understat, Premier League official website, etc.).
Final file should be .xlsx.