E-commerce ETL Pipeline using Python & PostgreSQL

Built a complete ETL pipeline using Python and PostgreSQL.

Project Overview:

This project demonstrates how to extract raw data from CSV files, transform it using Pandas, and load it into a PostgreSQL database.

Project Steps:

Extracted data from CSV files (customers, products, orders)

Performed data transformation (merging datasets & calculating total_price)

Loaded processed data into PostgreSQL

Validated results using SQL queries

Tools & Technologies:

Python

Pandas

PostgreSQL

SQL

Linux