Pandas Pivot Table Explained code example
Example 1: pd.pivot_table
>>> table = pd.pivot_table(df, values=['D', 'E'], index=['A', 'C'],
... aggfunc={'D': np.mean,
... 'E': [min, max, np.mean]})
>>> table
D E
mean max mean min
A C
bar large 5.500000 9.0 7.500000 6.0
small 5.500000 9.0 8.500000 8.0
foo large 2.000000 5.0 4.500000 4.0
small 2.333333 6.0 4.333333 2.0
Example 2: pivot table pandas
# Tips is the Dataframe:
# Suppose we want to compute a table of group means, we can
# use the Pivot_Table Method:
# The Pivot Table automatically computes the mean
tips.pivot_table(index=['day', 'smoker'])
# The index represents the column names that you want to form groups