python 3 sql into with pandas and sqlalchemy [duplicate]

Question

I have a pandas DataFrame,df, that I want to append to a remote table TabB on a postgres db. Both tables shares the same columns. How can I perform this using pandas and sql alchemy?

My sqlalchemy engine is defined as this:

myengine=create_engine('postgresql://postgres:[email protected]:5433/mydb')

I would like to know if I can apply a method like df.read_sql() to pass a proper INSERT TO. Any example would be greatly appreciated. Thanks in advance!

nicor88 · Accepted Answer · 2017-10-30 13:16:24Z

1

In pandas=0.20.3 I generally use something like that:

db_engine=create_engine('postgresql://postgres:[email protected]:5433/mydb')
df_to_save.to_sql(con=db_engine, name='yourTable', if_exists='append', index=False)

df_to_save and yourTable needs to have the same columns

answered Oct 30, 2017 at 13:16

nicor88

1,58313 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

python 3 sql into with pandas and sqlalchemy [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related