Read and push a table again to sql:Pandas

Question

I am reading a table from my sql server with Pandas such as

df= pd.read_sql('table1', engine)

where engine is my pyodbc connection and then again I am pushing it to sql server

df.to_sql('table2', engine, if_exists='replace')

which gives me an error

ValueError: duplicate name in index/columns: cannot insert level_0, already exists

and when I try to drop the column, it gave me some another error, which is anyways not an efficient way. I tried this as well, which also didn't work

 df= df.reset_index(drop=True)

Every help will be important

try index=Flase while wrting to_sql because index values should be unique. — shivsn
– shivsn, Commented Aug 9, 2016 at 13:44
It def works, so silly of me, If you want to post an answer, I will accept it as the answer. Thank you so much! — Manu Sharma
– Manu Sharma, Commented Aug 9, 2016 at 13:50

shivsn · Accepted Answer · 2016-08-09 14:06:57Z

7

Set index=Flase while writing to_sql because index values should be unique.

answered Aug 9, 2016 at 14:06

shivsn

7,9161 gold badge28 silver badges34 bronze badges

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

1 Answer 1