Mastering pandas - Second Edition

pivot table

The pandas pivot_table function is more advanced than the pivot function in several ways. Let's discuss some interesting parameters of the pivot_table function:

• data: The DataFrame object that is to be reshaped
• values: A column or a list of columns that are to be aggregated
• index: The key across which grouping of pivot index occurs
• columns: The key with respect to which grouping of the pivot column occurs
• aggfunc: The function to use for aggregation, such as np.mean

Let's pivot the sample sales data to slice and dice Sales across Category and ShipMode. Note that when aggfunc is empty, the mean is calculated:

pd.pivot_table(sales_data, values = "Sales", index = "Category", columns = "ShipMode")

The following will be the output: ...