Revision history [back]

1. First, import the necessary libraries:

import pandas as pd
import psycopg2
from sqlalchemy import create_engine

1. Load the dataframe into a variable using pandas:

df = pd.read_csv('your_file.csv')

1. Create a connection to your PostgreSQL database using psycopg2:

conn = psycopg2.connect(
    database="your_database_name",
    user="your_username",
    password="your_password",
    host="your_host",
    port="your_port"
)

1. Create a SQLAlchemy engine using the connection:

engine = create_engine('postgresql+psycopg2://{0}:{1}@{2}/{3}'.format(
    "your_username",
    "your_password",
    "your_host",
    "your_database_name")
)

1. Load the data into the database using the to_sql method and specifying the engine, the table name, and the if_exists parameter set to append or replace, depending on your needs:

df.to_sql('your_table_name', engine, if_exists='append', index=False)

Note that you may also want to specify the data types for each column in the to_sql call, using the dtype parameter. This is particularly useful when dealing with timestamp data, in order to maintain the correct timezone information in the database.