【VERY URGENT】BIG PROJECT - pivot_table enhancement

[soluentre]

refer to comments below

[soluentre]

• first - add subtotal, using a dictionary to pass argument: subtotal = {'country': 'top'}, if key is not in index argument, then return error
• second - add_percentages, including percentage of row, percentage of column and percentage of total
• third - use_percentage/use_style (ask sw)

result, rename_mapper = ... pivot_table() result = result[keeplist] result = result.rename(rename_dict)

note: when using the add_percentage para, it will return a tuple (df, rename_dict)

pivot_table(index=['country', 'var'], columns='us_nonus', subtotal={'country': 'Top', 'var': 'Bottom'}, add_percentage={'US':'column', 'Non-US': 'column'}, add_column_percentage=['US', 'Non-US'])