replace exact word

[marfer]

Dear Python users,
I am trying to replace substrings in a pandas column with the respective exact substring. Imagine that I have the following text:
text = "I loves us. lovess"
and I would like to obtain
text = "I love usa. lovess"
I tried the following code:

1 2 3 4 5

import pandas as pd text="i loves us. lovess" df=pd.DataFrame([x.split(';') for x in text.split('\n')]) df['text'] = df[0].str.replace(r"loves","love", regex=True) df['text'] = df['text'].str.replace(r"us","usa", regex=True)

However, the result from this code is "I love usa. loves". My original text has hundreds of typos, and I will need to replace several words. Any suggestion about how to improve this code would be appreciated. Thank you!

[snippsat]

Make a dictionary over what you want to replace.
To replace exact word use word boundaries \bword\b,
see now that it replace loves but leave lovess alone.

1 2 3 4 5 6 7 8 9 10 11 12

import pandas as pd   text="i loves us. lovess test" df = pd.DataFrame([x.split(';') for x in text.split('\n')]) replace_dict = {     r"\bloves\b": "love",     "us": "usa",     "i": "I",     "test": '999', }   df_1 = df.replace({0: replace_dict}, regex=True)

Test.

1 2 3 4 5 6

>>> df                          0 0  i loves us. lovess test >>> df_1                         0 0  I love usa. lovess 999