The Pandas library provides a function called pivot_table that summarizes feature values in a well-ordered two-dimensional table.

Let’s create a Pivot Table in Python using Pandas

Consider a dataframe as shown below:

Code:

import pandas as pd
employees = {'Name of Employee': ['Liam','Noah','Oliver','Maria','William','Liam','Noah','Oliver','Maria','William','Liam','Mark','Tina','Maria','Bill','Liam','Mark','Tina','Maria','Bill'],
     'Sales': [1000,300,400,500,800,1000,500,700,50,60,1000,900,750,200,300,1000,900,250,750,50],
     'Quarter': [1,1,1,1,1,2,2,2,2,2,3,3,3,3,3,4,4,4,4,4],
     'Country': ['US','Japan','Brazil','UK','US','Brazil','Japan','Brazil','US','US','US','Japan','Brazil','UK','Brazil','Japan','Japan','Brazil','UK','US']
     }

df = pd.DataFrame(employees, columns= ['Name of Employee','Sales','Quarter','Country'])
print (df)

#technology