INNER CODE UNIT · Python
summary
fzumstein/python-for-excel · sales_report_pandas.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 ####
summary.to_excel(this_dir / "sales_report_pandas.xlsx")