Python | Pandas.pivot()
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
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning – Basic Level Course
