mukhran/ETL_project

This project implements an ETL pipeline to extract, transform, and load crowdfunding data. Data is extracted and transformed into CSV files, used to generate an ERD and table schema, and then loaded into a Postgres database.

Crowdfunding_ETL

Info / Credits

• Analysis by

  • Marina Mukhranski @mukhran
  • Bryan Tsan-Tang @bryan-tt

• REPO: https://github.com/bryan-tt/Crowdfunding_ETL

• Analysis Last Updated: May 25th, 2023

• Report Last Updated: May 25th, 2023

Description

Build an ETL pipeline using Python, Pandas, and either Python dictionary methods or regular expressions to extract and transform the data. After you transform the data, you'll create four CSV files and use the CSV file data to create an ERD and a table schema. Finally, you’ll upload the CSV file data into a Postgres database.

Crowdfunding Database PostgreSQL

• Each CSV file is imported into the appropriate table without errors
• The data from each table is displayed using a SELECT * statement

Category Table

Subcategory Table

Campaign Table

Contacts Table