INNER CODE UNIT · Python
summary
fzumstein/python-for-excel · sales_report_xlsxwriter.py:28
summary = summary.loc[:, summary.sum().sort_values().index]
# Add row and column totals
summary["Total"] = summary.sum(axis=1)
total_row = pd.DataFrame([summary.sum(axis=0)], index=["Total"])
summary = pd.concat([summary, total_row])
#### Write summary report to Excel file ####
# DataFrame position and number of rows/columns
# xlsxwriter uses 0-based indices
startrow, startcol = 2, 1
nrows, ncols = summary.shape
with pd.ExcelWriter(
this_dir / "sales_report_xlsxwriter.xlsx",
engine="xlsxwriter",
datetime_format="mmm yy",