What are the reasons why are regex replacment doesn’t work? I have tried ensuring no excess spaces.
df.column 0 Test_With_Him 1 And_another option with him 2 and_another reason with her replacement = {'_':' ',Test With': 'test with', 'and another': 'And another& AND'} df['column'] = df.column.replace('s+',' ' , regex=True).str.strip().replace(replacement, regex=True)
When I do df.loc[df['column']=="and another reason with her"]
nothing has changed.
Advertisement
Answer
Please use df.replace(regex=dict)
df=pd.DataFrame({'test':["Test With Him","And Another option with him",'and another reason with her']}) replacement = {r'Test With': 'test with', r'And Another': 'And another& AND'} df=df.replace(regex=replacement) test 0 test with Him 1 And another& AND option with him 2 and another reason with her