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