pandas.pivot(index, columns, values) function produces pivot table based on 3 columns of the DataFrame. Uses unique values from index / columns and fills with values.
Parameters:
index[ndarray] : Labels to use to make new frame’s index
columns[ndarray] : Labels to use to make new frame’s columns
values[ndarray] : Values to use for populating new frame’s valuesReturns: Reshaped DataFrame
Exception: ValueError raised if there are any duplicates.
Code:
# Create a simple dataframe # importing pandas as pdimport pandas as pd # creating a dataframedf = pd.DataFrame({'A': ['John', 'Boby', 'Mina'], 'B': ['Masters', 'Graduate', 'Graduate'], 'C': [27, 23, 21]}) df |
# values can be an object or a listdf.pivot('A', 'B', 'C') |
# value is a listdf.pivot(index ='A', columns ='B', values =['C', 'A']) |
Raise ValueError when there are any index, columns combinations with multiple values.
# importing pandas as pdimport pandas as pd # creating a dataframedf = pd.DataFrame({'A': ['John', 'John', 'Mina'], 'B': ['Masters', 'Masters', 'Graduate'], 'C': [27, 23, 21]}) df.pivot('A', 'B', 'C') |
ValueError: Index contains duplicate entries, cannot reshape
