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 pd import pandas as pd # creating a dataframe df = pd.DataFrame({ 'A' : [ 'John' , 'Boby' , 'Mina' ], 'B' : [ 'Masters' , 'Graduate' , 'Graduate' ], 'C' : [ 27 , 23 , 21 ]}) df |
# values can be an object or a list df.pivot( 'A' , 'B' , 'C' ) |
# value is a list df.pivot(index = 'A' , columns = 'B' , values = [ 'C' , 'A' ]) |
Raise ValueError when there are any index, columns combinations with multiple values.
# importing pandas as pd import pandas as pd # creating a dataframe df = 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.