Pandas pivot table

pivotpandas.py

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt

%matplotlib inline
df = pd.read_excel('/home/ecarreras/Desktop/l.xls')
table = pd.pivot_table(
    df, index=['empresa', 'producto'], values=['price_subtotal'], aggfunc=[np.sum], fill_value=0
)
table_tots = table.groupby(level='empresa').sum()
table_tots.index = [table_tots.index, ['Total'] * len(table_tots)]
result = pd.concat([table, table_tots]).sort_index().append(table.sum().rename(('Total empresas', '')))
result