I have a column with addresses, and sometimes it has these characters I want to remove => ' - " - ,(apostrophe, double quotes, commas)

I would like to replace these characters with space in one shot. I'm using pandas and this is the code I have so far to replace one of them.

test['Address 1'].map(lambda x: x.replace(',', ''))

Is there a way to modify these code so I can replace these characters in one shot? Sorry for being a noob, but I would like to learn more about pandas and regex.

Your help will be appreciated!

You can use str.replace:

test['Address 1'] = test['Address 1'].str.replace(r"[\"\',]", '')

Sample:

import pandas as pdtest = pd.DataFrame({'Address 1': ["'aaa",'sa,ss"']})
print (test)Address 1
0      'aaa
1    sa,ss"test['Address 1'] = test['Address 1'].str.replace(r"[\"\',]", '')
print (test)Address 1
0       aaa
1      sass