How to Create a Pivot table with multiple indexes from an excel sheet using Pandas in Python?
Syntax: pandas.pivot_table(data, index=None)
data : DataFrame
index: column, Grouper, array, or list of the previous
index: It is the feature that allows you to group your data.
Note: We can filter the table further by adding the optional parameters.
Example 1: Link to the CSV File: CSV FILE
We can have a look at the data by running the following program:
We know that the index is the feature that allows us to group our data and specifying multiple columns as the indices in pivot function increases the level of details and grouping the data.
Keeping a single index in the table:
As we can see that the grouping is done country wise and the numerical data is printed as the average of all the values with regard to the specified index.
Now, Keeping multiple indices in the table:
Example 2: Link to the CSV File: CSV FILE
Keeping the number of centuries scored by players and their names as indices, we get:
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