PostgreSQL to DataFrame

postgres_to_df.py

import pandas as pd
from sqlalchemy import create_engine
from sqlalchemy.engine.url import URL

# db settings to make url (could be in external file) 
db_settings = {'drivername': <database driver>, # 'postgres', 'mysql' etc.
                'host': <host address>, # 'localhost' etc.
                'username': <username>,
                'password': <password>,
                'database': <database name>
                }
# create connection url
url = URL(**db_settings)

# or provide url directly
# url = <database driver>://<user>:<password>@<host>/<databse name>'

def sql_table_to_df(table_name, url):
    engine = create_engine(url)     
    conn = engine.connect()  
    with engine.connect() as conn, conn.begin():
        df = pd.read_sql_table(table_name, con=conn)    
    return df