MultiIndex DataFrame to Excel export problems

user_13014274 0
Viewed 33

After exporting MultiIndex DataFrame to an Excel file, an additional row between the header and the rows is created. How can I avoid that? enter image description here

writer = pd.ExcelWriter(out_xlsx, engine='xlsxwriter')
df1.to_excel(writer, sheet_name='All Instances', merge_cells=True)

Did anyone experience similar behaviour?

xlsxwriter pandas python
1 Answers

That is a known issue/feature in Pandas. See this GitHub Issue for an explanation.

This Stack Overflow answer is probably the best workaround I’ve seen.

user_102380
Related