gakas14 / Formula1_Data_Modeling Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

This project involves getting different datasets, creating a data model, creating tables, creating relationships between tables, and then loading the data into Snowflake.

0 stars 0 forks Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 8 Commits
F1_Entity_Relation.drawio.png		F1_Entity_Relation.drawio.png
README.md		README.md
credentials.py		credentials.py
f1.ipynb		f1.ipynb

Repository files navigation

Formula1_Data_Modeling

In this project, we have a Formula 1 dataset covering races, drivers, constructors, qualifying, circuits, lap times, pit stops, and championships from 1950 to the 2023 season. The data needs to be loaded into a Snowflake database.

1. We first load the different datasets into Python and then process some transformations.

2. We create a connection between Python and Snowflake and create a database.

Screen Shot 2024-03-08 at 12 15 39 PM

3. We create a Snowflake table using Python.

Screen Shot 2024-03-08 at 12 16 06 PM

4. We Build a data model.

5. We load the different data frames into a Snowflake.

Screen Shot 2024-03-08 at 1 52 48 PM

About

This project involves getting different datasets, creating a data model, creating tables, creating relationships between tables, and then loading the data into Snowflake.

python sql pandas-dataframe snowflake data-engineering data-modeling entity-relationship-diagram

Report repository

Releases

No releases published

Packages

Languages