The Pandas groupby method is used for grouping the DataFrame data according to the categories and applying a function to the categories. It also helps to aggregate data efficiently. The Pandas groupby() method is a very powerful function with a lot of variations. It makes the task of splitting the Dataframe over some criteria really easy and efficient.

Having an example to work with makes learning easier than just looking at code.

In Jupyter Notebook the output looks like this.

Let’s group the data by industry and sum the sales.

We’ll use a different syntax and calculate the mean instead of the sum. The two are not related here, as we could have easily just calculated the sum again with this different syntax. You don’t need the “by=” for this to work.

This last example returns a DataFrame instead of a Series.

Let’s format our DataFrame and reset the index with the code below. This may be an optional step in your own project, but it is here for illustration of resetting the index and renaming columns.

Bar Plot