CODEWITHSUNDEEP
pythonstr-replace
Demi
Demi

Reputation: 234

replace multiple string values with different values in a column (python)

Here is a sample dataset:

ID Description
1 he wants some epples
2 she bought 2kgs of bakana
3 he got nothing
4 she took potato and tomat

I wanted to replace it this way:

df['Description']= df['Description'].str.replace({'epples':'apples','bakana':'banana','tomat':'tomato'})

It returned error:

TypeError: replace() missing 1 required positional argument: 'repl'

What can I do to reach this result:

ID Description
1 he wants some apples
2 she bought 2kgs of banana
3 he got nothing
4 she took potato and tomato

Upvotes: 0

Views: 231

Answers (2)

Achraf Ben Salah
Achraf Ben Salah

Reputation: 276

Try like this :

import pandas as pd

df = pd.DataFrame({'ID':[1,2,3,4], 'Description':['he wants some epples', 'she bought 2kgs of bakana', 'he got nothing', 'she took potato and tomat']})
replacement = {
    "epples": "apples",
    "bakana": "banana",
    "tomat": "tomato"
}
print(df['Description'].replace(replacement, regex=True))

Output :

0          he wants some apples
1     she bought 2kgs of banana
2                he got nothing
3    she took potato and tomato

Upvotes: 4

user18627525
user18627525

Reputation:

yes, in str.replace(something, toReplaceWith), you missed toReplaceWith so that it errors

Upvotes: 0

Related Questions