python pandas: manually write to the same Excel after exporting a dataframe

Question

I export a dataframe to Excel this way:

import pandas as pd
df=pd.DataFrame( data= np.ones((4,2)), columns=['x','y'])

writer = pd.ExcelWriter('output.xlsx')
sheet='Test'
df.to_excel(writer,sheet)

writer.save()

How can I get python to write a few lines of description to the right of the dataframe? Something like: "this dataframe contains bla bla bla". Specifically:

Can I use pandas to write to the same sheet? Or do I have to use another module after writer.save()? Saving and reopening seems like a waste of time and resources
If I cannot use pandas, what module shall I use? xlsxwriter cannot modify existing file.

chrisb · Accepted Answer · 2015-08-21 11:46:11Z

2

You can access the XlsxWriter workbook/worksheet before saving and do any modifications you want there. E.g.

df.to_excel(writer, sheet)
wb = writer.book
ws = writer.sheets[sheet]
ws.write(1, 4, "DataFrame contains ...")
writer.save()

answered Aug 21, 2015 at 11:46

chrisb

52.7k8 gold badges73 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

python pandas: manually write to the same Excel after exporting a dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related