Project 2: Crowdfunding_ETL

Group 3 Members: Juhi, Kesha, Austin, Hima, and Lora

Executive Summary

In this project, an ETL pipeline was created. We used Python, Pandas and regular expressions while working with the data. We first cleaned the data to improve the readability and later transformed the data into four dataframes (i.e., category/subcategory, campaign, contacts, and crowdfunding). These dataframes were then converted into CSV files. A Postgres database and an entity relationship diagram was created, and the CSV files were uploaded.

Tasks:

1. Create Repo in GitHub and Maintain READ.me (Juhi & Lora)
2. Create Category DataFrame and Subcategory DataFrame (Juhi & Hima)
3. Create Campaign DataFrame (Hima & Kesha)
4. Create Contacts DataFrame (Kesha & Austin)
5. Create Crowdfunding Database (Lora & Austin)