row sum on a pandas pivot table

Question

I am stuck on trying to figure out how to add a row sum to a pandas pivot table. Would somebody please help point me towards the right direction.

This is my code below.

x.pivot_table(index = ["am","spot_or_contract"],
              columns = "status",
              values = "shipment_id",
              aggfunc = "count").fillna('')

Thank you very much in advance

Answer 1

Look at margins parameter in pivot_table:

x.pivot_table(index = ["am","spot_or_contract"], 
              columns = "status" , 
              values = "shipment_id", 
              aggfunc = "count",
              margins = True,
              fill_value = "")