Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://www.geeksforgeeks.org/python/python-pandas-series-str-rpartition/ below:

Python | Pandas Series.str.rpartition() - GeeksforGeeks

Last Updated : 11 Jul, 2025

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric Python packages.

is one of those packages and makes importing and analyzing data much easier. Pandas

works in a similar way like

and

. Instead of splitting string on every occurrence from left side,

splits string only once and that too reversely (From right side). Unlike

method, the

method stores the separator/delimiter too.

has to be prefixed every time before calling this method to differentiate it from the Python’s default function otherwise, it will throw an error.

This method is different from the str.partition() method, Instead of splitting at the first occurrence, the string is splitted at the last occurrence of separator/delimiter.

Syntax: Series.str.rpartition(pat=' ', expand=True) Parameters: pat: String value, separator or delimiter to separate string at. Default is ‘ ‘ (whitespace) expand: Boolean value, returns a data frame with different value in different columns if True. Else it returns a series with list of strings. Default is True. Return type: Series of list or Data frame depending on expand Parameter

To download the CSV used in code, click

In the following examples, the data frame used contains data on some NBA players. The image of data frame before any operations is attached below.

Splitting string into list In this example, the Team column is splitted into list on last occurrence of 'o'. Before doing any operations, null rows are removed using .dropna() method to avoid errors.

# importing pandas module 
import pandas as pd 
  
# making data frame 
data = pd.read_csv("https://media.geeksforgeeks.org/wp-content/uploads/nba.csv") 
  
# removing null values to avoid errors 
data.dropna(inplace = True) 

# splitting and overwriting column
data["Team"]= data["Team"].str.rpartition("o", False)

# display
data

As shown in the output image, the string 'Boston Celtics' was separated on last occurrence of 'o'. Also the returned list is having separator too.

Splitting string into data frame In this example, the Name column is splitted into data frame on last occurrence (First from right side) of 'a' by keeping expand Parameter True. Before doing any operations, null rows are removed using .dropna() method to avoid errors.

# importing pandas module 
import pandas as pd 
  
# making data frame 
data = pd.read_csv("https://media.geeksforgeeks.org/wp-content/uploads/nba.csv") 
  
# removing null values to avoid errors 
data.dropna(inplace = True) 

# splitting and overwriting column
df = data["Name"].str.rpartition("a", True)

# display
df

As shown in the output image, the string was splitted into data frame on the last occurrence of 'a' in string.

If there is no occurrence of separator in string, the whole string is stored in the last column of data frame/last index of list.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4