The Wayback Machine - https://web.archive.org/web/20240619112411/https://www.geeksforgeeks.org/python-pandas-series-replace/
Open In App

Python | Pandas Series.replace()

Last Updated : 24 Aug, 2023
Improve
Improve
Like Article
Like
Save
Share
Report

Pandas series is a One-dimensional ndarray with axis labels. The labels need not be unique but must be a hashable type. The object supports both integer- and label-based indexing and provides a host of methods for performing operations involving the index. Pandas Series.replace() function is used to replace values given in to_replace with value. The values of the Series are replaced with other values dynamically.

Syntax:
Series.replace(to_replace=None, value=None, inplace=False, limit=None, regex=False, method=’pad’)

Parameters :
to_replace : How to find the values that will be replaced.
value : Value to replace any values matching to_replace with.
inplace : If True, in place.
limit : Maximum size gap to forward or backward fill.
regex : Whether to interpret to_replace and/or value as regular expressions
method : The method to use when for replacement, when to_replace is a scalar, list or tuple and value is None.

Returns : Object after replacement.

Example #1: Use Series.replace() function to replace some values from the given Series object.

Python3




# importing pandas as pd
import pandas as pd
 
# Creating the Series
sr = pd.Series([10, 25, 3, 11, 24, 6])
 
# Create the Index
index_ = ['Coca Cola', 'Sprite', 'Coke', 'Fanta', 'Dew', 'ThumbsUp']
 
# set the index
sr.index = index_
 
# Print the series
print(sr)


Output :

Coca Cola    10
Sprite 25
Coke 3
Fanta 11
Dew 24
ThumbsUp 6
dtype: int64

Now we will use Series.replace() function to replace the old values with the new ones.

Python3




# replace 3 by 1000
result = sr.replace(to_replace = 3, value = 1000)
 
# Print the result
print(result)


Output :

Coca Cola      10
Sprite 25
Coke 1000
Fanta 11
Dew 24
ThumbsUp 6
dtype: int64

As we can see in the output, the Series.replace() function has successfully replaced the old value with the new one.  

Example #2 : Use Series.replace() function to replace some values from the given Series object.

Python3




# importing pandas as pd
import pandas as pd
 
# Creating the Series
sr = pd.Series(['New York', 'Chicago', 'Toronto', 'Lisbon', 'Rio'])
 
# Create the Index
index_ = ['City 1', 'City 2', 'City 3', 'City 4', 'City 5']
 
# set the index
sr.index = index_
 
# Print the series
print(sr)


Output :

City 1    New York
City 2 Chicago
City 3 Toronto
City 4 Lisbon
City 5 Rio
dtype: object

Now we will use Series.replace() function to replace the old values with the new ones using a list.

Python3




# replace the old ones in the list with
# the new values
result = sr.replace(to_replace = ['New York', 'Rio'], value = ['London', 'Brisbane'])
 
# Print the result
print(result)


Output :

City 1      London
City 2 Chicago
City 3 Toronto
City 4 Lisbon
City 5 Brisbane
dtype: object

As we can see in the output, the Series.replace() function has successfully replaced the old value with the new one using the list.



Previous Article
Next Article

Similar Reads

Python | Pandas Series.str.replace() to replace text in a series
Python is a great language for data analysis, primarily because of the fantastic ecosystem of data-centric Python packages. Pandas is one of those packages that makes importing and analyzing data much easier. Pandas Series.str.replace() method works like Python .replace() method only, but it works on Series too. Before calling .replace() on a Panda
5 min read
Add a Pandas series to another Pandas series
Let us see how to add a Pandas series to another series in Python. This can be done using 2 ways: append()concat() Method 1: Using the append() function: It appends one series object at the end of another series object and returns an appended series. The attribute, ignore_index=True is used when we do not use index values on appending, i.e., the re
2 min read
Pandas Series dt.weekofyear Method | Get Week of Year in Pandas Series
The dt.weekofyear attribute returns a Series containing the week ordinal of the year in the underlying data of the given series object. Example C/C++ Code import pandas as pd sr = pd.Series(['2012-10-21 09:30', '2019-7-18 12:30', '2008-02-2 10:30', '2010-4-22 09:25', '2019-11-8 02:22']) idx = ['Day 1', 'Day 2', 'Day 3', 'Day 4', 'Day 5'] sr.index =
2 min read
Pandas Series dt.minute | Extract Minute from DateTime Series in Pandas
Pandas Series.dt.minute attribute returns a NumPy array containing the minutes of the DateTime in the underlying data of the given series object. Example C/C++ Code import pandas as pd sr = pd.Series(['2012-10-21 09:30', '2019-7-18 12:30', '2008-02-2 10:30', '2010-4-22 09:25', '2019-11-8 02:22']) idx = ['Day 1', 'Day 2', 'Day 3', 'Day 4', 'Day 5']
2 min read
Pandas Series dt.dayofweek | Get Day of Week from DateTime Series in Pandas
Pandas dt.dayofweek attribute returns the day of the week from the given DateTime Series Object. It is assumed the week starts on Monday, which is denoted by 0, and ends on Sunday which is denoted by 6. Example: C/C++ Code import pandas as pd sr = pd.Series(['2012-10-21 09:30', '2019-7-18 12:30', '2008-02-2 10:30', '2010-4-22 09:25', '2019-11-8 02:
2 min read
Pandas Series dt.freq | Retrieve Frequency of Pandas Time Series
Pandas dt.freq attribute returns the time series frequency applied on the given series object if any, else it returns None. Examples C/C++ Code import pandas as pd sr = pd.Series(['2012-12-31', '2019-1-1 12:30', '2008-02-2 10:30', '2010-1-1 09:25', '2019-12-31 00:00']) idx = ['Day 1', 'Day 2', 'Day 3', 'Day 4', 'Day 5'] sr.index = idx sr = pd.to_da
2 min read
Pandas Series dt.daysinmonth | Get Number of Days in Month in Pandas Series
The dt.daysinmonth attribute returns the number of days in the month for the given DateTime series object. Example C/C++ Code import pandas as pd sr = pd.Series(['2012-12-31', '2019-1-1 12:30', '2008-02-2 10:30', '2010-1-1 09:25', '2019-12-31 00:00']) idx = ['Day 1', 'Day 2', 'Day 3', 'Day 4', 'Day 5'] sr.index = idx sr = pd.to_datetime(sr) result
2 min read
Pandas Series dt.normalize() | Normalize Time in Pandas Series
The dt.normalize() method converts times to midnight. The time component of the date-time is converted to midnight i.e. 00:00:00. This is useful in cases when the time does not matter. Length is unaltered. The time zones are unaffected. Example: C/C++ Code import pandas as pd sr = pd.Series(pd.date_range('2012-12-31 09:45', periods = 5, freq = 'M',
2 min read
Python | Pandas series.cumprod() to find Cumulative product of a Series
Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric Python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas Series.cumprod() is used to find Cumulative product of a series. In cumulative product, the length of returned series is same as
3 min read
Python | Pandas Series.astype() to convert Data type of series
Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric Python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas astype() is the one of the most important methods. It is used to change data type of a series. When data frame is made from a csv
2 min read