/Crowdfunding_ETL

Built an ETL pipeline using Python, Pandas. Extracted and transformed the data. Created four CSV files and used the CSV file data to create an ERD and a table schema. File uploaded the CSV file data into a Postgres database.

Primary LanguageJupyter Notebook

Crowdfunding_ETL

Authors

Sarah Stegall-Rodriguez, Savannah Serrano, & Michaela Dobbs.

Summary of the project

Contents

  • ETL_Mini_Project... .ipynb - Jupyter Notebook to create four databases.
  • Resources folder - contains the two Excel files used in the project.
  • ERD - contains entity relationship diagram (ERD) and code used in QuickDB.
  • PgAdmin - contains schema used for PgAdmin and screenshots of imported tables.
  • Support_Docs - contains guides for the project.

Collaboration with GitHub