Pandas DataFrame replace() Method
Example
Replace the value 50 with the value 60, for the entire DataFrame:
import pandas as pd
data = {
"name": ["Bill", "Bob",
"Betty"],
"age": [50, 50, 30],
"qualified": [True,
False, False]
}
df =
pd.DataFrame(data)
newdf = df.replace(50, 60)
Try it Yourself »
Definition and Usage
The replace()
method replaces the specified
value with another specified value.
The replace()
method searches the entire
DataFrame and replaces every case of the specified value.
Syntax
dataframe.replace(to_replace, value, inplace,
limit, regex, method)
Parameters
The inplace
, limit
,
regex
,
method
parameters are
keyword arguments.
Parameter | Value | Description |
---|---|---|
to_replace | Required, a String, List, Dictionary, Series, Number, or a Regular Expression describing what to search for | |
value | Optional, A String, Number, Dictionary, List or Regular Expression that specifies a value to replace with. | |
inplace | True |
Optional, default False. If True: the replacing is done on the current DataFrame. If False: returns a copy where the replacing is done. |
limit | NumberNone |
Optional, default None. Specifies the max limit of the size gap to fill |
regex | True |
Optional, default False. Specifies whether to replace using a regular expression or not. |
method | 'bfill' |
Optional, Specifies the how to replace if the
value parameter is not present. |
Return Value
A DataFrame with the result, or None if the inplace parameter is set to True.