INNER CODE UNIT · Python

summary

fzumstein/python-for-excel · sales_report_openpyxl.py:46

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
# openpxyl uses 1-based indices
startrow, startcol = 3, 2
nrows, ncols = summary.shape

with pd.ExcelWriter(
    this_dir / "sales_report_openpyxl.xlsx",
    engine="openpyxl",
) as writer:

View source record →