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

Question

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

Achraf Ben Salah · Accepted Answer · 2022-04-13 08:12:06Z

4

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

answered Apr 13, 2022 at 8:12

Achraf Ben Salah

3762 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user18627525 · Accepted Answer · 2022-04-13 08:05:19Z

0

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

answered Apr 13, 2022 at 8:05

user18627525

1 Comment

alan ocallaghan Over a year ago

It would be good to provide a correct version of the OP's code that will run without the error they encountered.

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related