theidari/Crowdfunding_ETL

This repository contains an ETL project for crowdfunding data, utilizing Python and SQL technologies. The data is extracted and transformed with Pandas and Python, and loaded into a PostgreSQL database using pgAdmin, providing clean and organized data for analysis.

Crowdfunding platforms like Kickstarter and Indiegogo have been growing in success and popularity since the late 2000s. From independent content creators to famous celebrities, more and more people are using crowdfunding to launch new products and generate buzz, but not every project has found success. To receive funding, the project must meet or exceed an initial goal, so many organizations dedicate considerable resources looking through old projects in an attempt to discover “the trick” to finding success.

Project Overview

• Objective:The instructions for this project are divided into the following subsections:

  • Create the Category and Subcategory DataFrames
  • Create the Campaign DataFrame
  • Create the Contacts DataFrame
  • Create the Crowdfunding Database

• Methods, Software and Attribution:

  • following programming languages, software, and libraries were used in this project:
    

    •  
    •   
    •    

  • The project header GIF has been designed by powerpoint and photopea.com using assets from Freepik.com.

ETL Results

• Create the Category and Subcategory DataFrames

Fig[1]: Category and Subcategory DataFrames

 

• Create the Campaign DataFrame

Fig[2]: Campaign DataFrame

• Create the Contacts DataFrame

Fig[3]: Contacts DataFrame

• Create the Crowdfunding Database
  
  • In this project, Entity-Relationship Diagrams (ERDs) were utilized as the primary modeling method, implemented using the QUICK DBD application. The ERD revealed four entities in the crowdfunding database, namely categories, subcategories, campaigns, and contacts. The modeling results were depicted in Figure 4. Additionally, the Crowdfunding ERD Documentation offers a comprehensive overview of the diagram.
  • Create a Table and Import Data

Fig[4]: Crowdfunding ERD

References
^[1] Trilogy Education Services, a 2U, Inc. brand.