Pre-process Data

Freelancer Project: Preprocessing Historical Soccer Dataset

Project Overview:

The objective of this freelancer project is to preprocess the historical soccer dataset, dfdat.csv, and extract relevant features to create a dataset suitable for machine learning training. The dataset contains information about soccer matches, including the teams playing (HomeTeam and AwayTeam), match results (FTR - Full Time Result), and other performance-related metrics such as team positions, goals scored, goals conceded, and recent match history.

Project Tasks:

Create a function to generate a league table:

The function will take the historical dataset, dfdat.csv, as input.
It will calculate the team positions based on points (PTS), matches played (MP), wins (W), draws (D), losses (L), goals for (GF), goals against (GA), and goal difference (GD).

Create a function to calculate team-specific performance metrics:
The function will take the historical dataset, dfdat.csv, and a team name as input.
It will calculate the following statistics for the given team:
homeLast1, homeLast2, homeLast3, homeLast4, homeLast5, homeScore
awayLast1, awayLast2, awayLast3, awayLast4, awayLast5, awayScore
Loop through the dataset to calculate team-specific performance metrics for each match:

Please refer to the attached code, sample output, and detailed description or chat me for more clarification.