All geek questions in one place

Pandas DataFrame for PostgreSQL using Psycopg2

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

Endgoal should be able to write the Pandas framework to an Amazon RDS PostgreSQL instance.

+4
source share
1 answer

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

+2
source

Source: https://habr.com/ru/post/1617880/

More articles: