Dataset Information
Data Source
The data used in this project comes from the Fantasy Premier League (FPL) API, which provides comprehensive statistics about players, teams, and matches in the English Premier League.
Database Schema
Players Table
Contains current season statistics for all Premier League players:
- Basic Information: player_id, first_name, second_name, web_name, position
- Team Information: team_id, team_name
- Performance Metrics: goals_scored, assists, clean_sheets, etc.
- Advanced Statistics: expected_goals, expected_assists, ict_index, etc.
Teams Table
Contains information about Premier League teams:
- Basic Information: team_id, team_name, short_name
- Performance Metrics: position, played, win, draw, loss, points
- Team Strength: strength rating
Player History Table
Contains historical statistics for players across previous seasons:
- Season Information: season_name
- Performance Metrics: total_points, minutes, goals_scored, etc.
- Advanced Statistics: influence, creativity, threat, etc.
Player Past Table
Contains match-by-match statistics for the current season:
- Match Information: event, was_home, opponent_team
- Performance Metrics: minutes, goals_scored, assists, etc.
- Advanced Statistics: expected_goals, expected_assists, etc.
Fixtures Table
Contains information about all matches in the current season:
- Match Information: game_id, gw, finished
- Team Information: team_h, team_a, team_h_name, team_a_name
- Match Results: team_h_score, team_a_score
- Additional Information: kickoff_time, difficulty ratings
Data Update Process
You can update the database with the latest Premier League data by clicking the Update Database button, which fetches the latest data from the Fantasy Premier League API and updates the MariaDB database.