Replace Single Quote to Double Quote Python Pandas Dataframe

replace single quote to double quote python pandas dataframe

If the problem is converting the single quote to double quotes without the restraint of doing it after you read it into a dataframe - you could change the .csv file before you read it into a dataframe:

$ sed -i "s/'/\"/g" file_name.csv

If you have to replace them after you read them into a dataframe, try the solution mentioned in this post:

df.replace({'\'': '"'}, regex=True)

replacing quotes, commas, apostrophes w/ regex - python/pandas

You can use str.replace:

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

Sample:

import pandas as pd

test = 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

Related Topics