How mateussilvams056-gif/f1-data-extraction-and-data-analysis works
This repository analyzes Formula 1 session data, focused on the 2023 Japan GP, and supports follow-up SQL analysis. The documented workflow is to launch the containerized processor, retrieve session data with FastF1, clean and derive lap and tyre metrics, then produce a CSV and positions graph; the README also says assets are pushed to MinIO. Separate SQL files support focused analysis, with MySQL described as the relational database. No source excerpts were provided, so relationships below rely on README statements; individual notebook operations and SQL-to-output mappings are not inferred.
Main entry points: f1.ipynb Session processing · docker-compose.yml Pipeline launcher · f1_avgdeg.sql Average degradation · f1_set.sql Set analysis
Components 16
Data pipeline
- Pipeline launcher
docker-compose.yml - Session processing
f1.ipynb - Positions graph
f1.ipynb
Data storage
- Clean session CSV
Japan2023.csv - MinIO object storage
- MySQL database
- Degradation results
f1_avgdeg.csv - Pitstop results
f1_fastestpitstop.csv - Stint results
f1_maxstint.csv
SQL analysis
- Average degradation
f1_avgdeg.sql - Fastest pitstops
- Longest stints
- Set analysis
f1_set.sql - Stint analysis
f1_stint.sql
Other components
- Analyst
- FastF1
Connections 16
- Analyst → Pipeline launcher: launches
README.md - Pipeline launcher → Session processing: runs processor
README.md - Session processing → FastF1: retrieves session data
README.md - Session processing → Clean session CSV: generates CSV
README.md - Session processing → Positions graph: generates graph
README.md - Session processing → MinIO object storage: pushes assets
README.md - Analyst → Average degradation: analyzes data
README.md - Analyst → Fastest pitstops: analyzes data
README.md - Analyst → Longest stints: analyzes data
README.md - Analyst → Set analysis: analyzes data
README.md - Analyst → Stint analysis: analyzes data
README.md - Average degradation → MySQL database: queries
README.md - Fastest pitstops → MySQL database: queries
README.md - Longest stints → MySQL database: queries
README.md - Set analysis → MySQL database: queries
README.md - Stint analysis → MySQL database: queries
README.md