2022-05-30

Is there any way to export pandas dataframe into database with existing tables?

Dear Stackoverflow Community, i'm trying to export my dataframe into postgresql database, i used SQLAlchemy but it doesnt give me the opportunity to map the dataframe with the existing tables in the database, for exemple this mt dataframe:

ClientNumber ClientName Amout
        1000     Albert   5000     
        2000       John   4000
        1200   Cristian   1000

and the database have this table :

id_client  client_name   client_amount
     1000       Albert            5000     
     2000         John            4000
     1200     Cristian            1000

The question is how to link my dataframe to postgresql without forcing to change the name columns of the dataframe ? Thanks in advance



No comments:

Post a Comment