Add pandas DataFrame to SQL

Question

I want to add data from a Pandas DataFrame to SQL. I have tried to use .tosql() but if I use if_exists='append', index = True it will add even if a row with same index already exists.

Does anyone know how to add the data if the index is not already there and replace the existing data if there is already a same index.

Here is my code:

mydb = sqlite3.connect("test.db")
mycursor = mydb.cursor()
data = # the dataframe
data.to_sql(table_name, mydb, if_exists='append', index = True)
mydb.commit()
mydb.close()

here is the sample data I'm trying to add: https://jpst.it/2nFvu

Thanks in advance.

Panda · Accepted Answer · 2021-01-02 20:34:22Z

1

Can we try the below code:

    data.to_sql(table_name, mydb, if_exists='replace', index = False)

answered Jan 2, 2021 at 20:34

Panda

238 bronze badges

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

3 Comments

Poorna Chandra R Over a year ago

I need the index as it the row title. So, I can't set it to False

Panda Over a year ago

Have you tried setting it to True instead?

Poorna Chandra R Over a year ago

Yes, but it is adding the duplicates instead of replacing the existing values.

Collectives™ on Stack Overflow

Add pandas DataFrame to SQL

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related