Pivot Table with Multiple Columns using Pandas

A pivot table in pandas is a way of summarizing and aggregating data in a DataFrame, especially when you have multiple dimensions or categorical variables. It allows you to reshape and transform your data, making it easier to analyze and gain insights. In a pivot table, you can specify which columns of the original DataFrame should become the new index, which columns should become new columns, and which columns should be used for aggregating data.

Syntax:

pandas.pivot_table(data, values=None, index=None, columns=None, aggfunc=’mean’, fill_value=None, margins=False, dropna=True, margins_name=’All’, observed=_NoDefault.no_default, sort=True)

Parameters:

• data: The DataFrame to be used for creating the pivot table.
• values: Column(s) to aggregate. This can be a list, a single column name, or a scalar. It specifies the values that will be aggregated in the resulting pivot table.
• index: Column, Grouper, array, or list of the previous. The column or columns whose unique values will become the index of the pivot table.
• columns: Column, Grouper, array, or list of the previous. The column or columns whose unique values will become the columns of the pivot table.
• aggfunc: Function, list of functions, or a dictionary. Specifies how to aggregate the values. Common options include ‘mean’, ‘sum’, ‘count’, ‘min’, ‘max’, etc. It can be a single function, a list of functions, or a dictionary where keys are column names, and values are aggregation functions.
• fill_value: Scalar, default None. The value to use for filling missing values in the resulting pivot table.
• margins: Bool, default False. If True, it adds row/column margins (subtotals) to the pivot table.
• dropna: Bool, default True. If True, it excludes NA/null values from the result.
• margins_name: Str, default 'All'. Name to be used for the row/column that will contain the totals when margins=True.
• observed: Bool, default False (Deprecated since version 2.2.0). This parameter is deprecated and no longer used.
• sort: Bool, default True. Sort the result DataFrame by the names of the index and column levels if True.

PythonPandas make data manipulation, representation and analysis easier. Pandas Pivot Tables are used to create spreadsheet-style pivot tables as a DataFrame. The levels in the pivot table will be stored in MultiIndex objects (hierarchical indexes) on the index and columns of the result DataFrame.