writing pandas data into postgresql using sqlalchemy

sql-alchemy-example.py

import pandas as pd

data = pd.DataFrame(list(range(100)), columns=["data"])

pip install psycopg2

import sqlalchemy
from sqlalchemy import create_engine
import psycopg2

cxstr = 'postgresql://{user}:{passwd}@{host}:5432/{db}'.format( \
    user='xxx', \
    passwd='xxx', \
    host='postgresql', \
    db='demodb')

engine = create_engine(cxstr)

data.to_sql('demo', engine, if_exists='replace', index = False)