This project aims to track and manage the accumulation of yellow and red cards by players and officials during a competition. Leveraging the FPL API, the system collects data and stores it in a PostgreSQL database. Airflow orchestrates the data pipeline, Docker ensures containerized deployment, and Metabase provides visualization.
- Extract card data from the FPL API and load it into a PostgreSQL database.
- Automate the pipeline with Airflow for periodic updates.
- Use Metabase for visualizing card metrics.
- Deploy the solution in a containerized environment with Docker.
- API: FPL API endpoint providing data for players, fixtures, players match stats, teams.
- Extraction: Use Python’s requests library to fetch data from the FPL API.
- Transformation: Clean and normalize the data to align with the PostgreSQL schema.
- Loading: Insert transformed data into PostgreSQL.
- Warning Alert: Triggered when a player accumulates 4 yellow cards.
- Suspension Alert: Triggered when a player accumulates 5 yellow cards or when player receives a red card in the most recent match.
- Reset Notification:
Triggered after the player has served the suspension by missing a match.
