Writing Output Of Describe() And A Text Label To Same Excel Sheet In Python

This is a continuation of a related question here: Creating a blank worksheet and adding text to that new worksheet using Python, ExcelWriter and openpyxl I am trying to write the

Solution 1:

I don't think your error is related to 0.

I will do something like this instead.

with pd.ExcelWriter(f"data validation for {FNum}_{FName}.xlsx",engine='openpyxl', mode='a') as writer:

    DWoldfiltered.to_excel(writer,sheet_name="Previous_DW_load") 
    DWfiltered.to_excel(writer,sheet_name="Latest_DW_load") 

    summary = pd.DataFrame({"Latest Load" : []})
    summary.to_excel(writer, sheet_name="Summary_Data")    
    describe.to_excel(writer, sheet_name ="Summary_Data", startrow=2, startcol=1)

writer.save()