Home »
Python »
Python Programs
How to group a series by values in pandas?
Given a Pandas DataFrame, we have to group a series by values.
Submitted by Pranit Sharma, on July 21, 2022
Pandas is a special tool that allows us to perform complex manipulations of data effectively and efficiently. Inside pandas, we mostly deal with a dataset in the form of DataFrame. DataFrames are 2-dimensional data structures in pandas. DataFrames consist of rows, columns, and data.
A Series contains a single list that can store heterogeneous types of data, because of this, a series is also considered a 1-dimensional data structure. When we analyze a series, each value can be considered as a separate row of a single column.
To group a series by values in pandas, we will use first convert the series into a dataframe, and then we will use pandas.DataFrame.groupby() method.
To work with pandas, we need to import pandas package first, below is the syntax:
import pandas as pd
Let us understand with the help of an example,
Python code to group a series by values
# Importing pandas package
import pandas as pd
# Creating a series
ser = pd.Series(['Apple','Banana','Mango','Mango','Apple','Guava'])
# Converting series into dataframe
df=pd.DataFrame(ser,columns=['Fruits'])
# Dispaly DataFrame
print("Converted DataFrame:\n",df,"\n")
# Applying groupby
df = df.groupby(['Fruits'])
# Display result
print("Result:\n",df)
Output:
Python Pandas Programs »