Add rows without overwrite (Python)

Question

Colleagues, I have the following excel file. But, when I compile the program again, my data is overwritten. I'd like to put each results of the next compilations in a row. I've seen some examples with append, but I can not make it work. Could someone help me, please? !!

writer = pd.ExcelWriter('output.xlsx')

df = pd.DataFrame({'Function':[Output],'Circuit':[gates],'Cost':[cost]},)

df.to_excel(writer,'Sheet1')

writer.save()

Append to other columns or worksheets? E.g.: https://stackoverflow.com/questions/20219254/how-to-write-to-an-existing-excel-file-without-overwriting-data-using-pandas — albert, Aug 01 '17 at 08:29
Probably not the most efficient, but you can read the excel file into a df, append new data into the df, and write the df into a new excel. — Yeile, Aug 01 '17 at 09:17

score 3 · Answer 1 · answered Aug 01 '17 at 11:45

3

I guess there is no direct way to append rows to existing excel

Try this code, it may help

read your excel as dataframe

df1 = pd.read_excel('output.xlsx')

and your defined dataframe

df2 = pd.DataFrame({'Function':[Output],'Circuit':[gates],'Cost':[cost]})

then write both dataframe to excel

df1.to_excel(writer,startrow=0,index=False)
df2.to_excel(writer,startrow=len(df1)+1,header=False,index=False)

answered Aug 01 '17 at 11:45

Geetha Ponnusamy

497
3
15

Thank you!!! It's working!!! It's a little messy the columns, but no overwriting the data... – Caroline D.P.N. Barbieri Aug 01 '17 at 13:43
if my answer helped you, would you please accept this answer! – Geetha Ponnusamy Aug 02 '17 at 03:15
How I do that? I'm new here! – Caroline D.P.N. Barbieri Aug 02 '17 at 12:54

Add rows without overwrite (Python)

1 Answers1