Formula 1 Data Analysis

-- Project Status: [ On-Hold ]

Project Intro/Objective

This project contains a dashboard analysing data of Formula 1 races from 1950 and up. A demo is available on Render here.

Data sources

• Kaggle dataset

Methods Used

• Data Analysis
• Data Visualization
• Predictive Modeling

Technologies

• Python
• SQL
• Plotly Dash
• Pandas

Project Description

The goals of this project were to analyze some dataset with strong relational links using SQL and present the results as a clear and interactive dashboard, built in Plotly. The dashboard summarizes the top race winners and qualifiers for a given year selected by the user. Once a year is chosen, the dashboard can be used to summarize a driver's grid and result positions as well as the overall lineup for any circuit.

All this analysis makes use of a Kaggle dataset with the following schema (source):

A demo is available on the hosting service Render here (this uses the free tier and is thus significantly slowed down).

Getting Started

1. Clone this repository.
2. Raw data is being kept here within this repo in .csv files. An sqlite database is located here.
3. A script to generate the sqlite database from the .csv files can be found in scripts/.

To run dashboard, use

python3 app.py