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 |
Advertisement
Answer
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