CSV_to_PostgreSQL

This project demonstrates a simple data transformation and loading process, focusing on importing data from a CSV file into a PostgreSQL database. The key technologies used in this project are Python, pandas, and PostgreSQL.

Script Functionality

1. CSV Transformation: The script utilizes the pandas library to read data from a CSV file and perform any necessary transformations.
2. PostgreSQL Loading: It establishes a connection to a PostgreSQL database and loads the transformed data into an appropriate table

Dependencies:

• Python 3.11
• pandas
• psycopg2
• PostgreSQL