Pandas DataFrame to PostgreSQL using Psycopg2

Question

Is it possible to write a Pandas dataframe to PostgreSQL database using psycopg2?

Endgoal is to be able to write a Pandas dataframe to Amazon RDS PostgreSQL instance.

David Maust · Accepted Answer · 2015-11-29 08:59:41Z

2

If you use a SQLAlchemy engine around psycopg2, you could probably use df.to_sql. See: http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_sql.html

answered Nov 29, 2015 at 8:59

David Maust

8,3003 gold badges34 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

verkter Over a year ago

Thank you, I got SQLAlchemy to work. After using df.to_sql to write is commit necessary? If so, how would I commit in SQLAlchemy? It appears I need to create a session object then somehow add my query to it and then commit.

David Maust Over a year ago

I believe to_sql performs the commit.

Collectives™ on Stack Overflow

Pandas DataFrame to PostgreSQL using Psycopg2

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related