/projects

CSV 2 SQL Pipeline

This project demonstrates a simple ETL pipeline that reads CSV files, cleans and transforms data using Python and pandas, and loads it into Microsoft SQL Server using pyodbc.

CSV 2 SQL Pipeline

Highlights

  • Extracts data from CSV files (customers.csv and sales.csv)
  • Transforms data by cleaning null values and normalizing email addresses
  • Loads data into SQL Server tables (customers and sales) using Windows Authentication
  • Provides Docker option to run SQL Server for local testing

Technologies

PythonSQL Serverpandaspyodbc
View on GitHub