This project involves analyzing crowdfunding data from Excel files, creating dataframes, exporting the dataframes as CSV files, creating a PostgreSQL database schema based on an ERD and importing the CSV files into their corresponding tables.
-
Extracted and transformed data from the provided Excel files to create dataframes using Python and pandas.
-
Cleaned and formatted the data, handling missing values and inconsistencies.
-
Exported the dataframes as CSV files: category.csv, subcategory.csv, campaign.csv, and contacts.csv.
-
Designed the database schema based on the Entity Relationship Diagram (ERD) provided.
-
Created tables in PostgreSQL with appropriate data types, primary keys, foreign keys, and constraints.
-
Imported the CSV files into the respective database tables.
-
Ran SQL queries on the database to analyze the crowdfunding data.