Pandas pivot table

pivotpandas.py

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

%matplotlib inline

# Create DataFrame from Excel
df = pd.read_excel('/home/ecarreras/Desktop/l.xls')

# Create pivot table from DataFrame
table = pd.pivot_table(
    df, index=['empresa', 'producto'], values=['price_subtotal'], aggfunc=[np.sum], fill_value=0
)

# Group pivot table by column specified
table_tots = table.groupby(level='empresa').sum()

# ?
table_tots.index = [table_tots.index, ['Total'] * len(table_tots)]

# Add total to the last row
result = pd.concat([table, table_tots]).sort_index().append(table.sum().rename(('Total empresas', '')))
result