Using regex to replace certain keyword in a dataframe value in python

Question

I have a dataframe to store cars related information and I am trying to replace certain key "[Pink & Blue]" to "[Pink&Blue]" to remove the space in between using regex but my code fails to do so :

Cars = {'Brand': ['Honda Civic','Toyota Corolla','Ford Focus'],
        'Price': [22000,np.nan,35000] ,
        'Product Summary' : ['color is [Pink & Blue] size is 14' ,'color is [Pink & Yellow] size is 10','color is [Red & Black] size is 11']
    }
df = DataFrame(Cars,columns= ['Brand', 'Price', 'Product Summary'])
df['Product Summary'] = df['Product Summary'].replace(r'\b & ',"&")

Vishnudev Krishnadas · Accepted Answer · 2019-11-12 06:29:10Z

1

Use Series.str.replace accessor

df['Product Summary'] = df['Product Summary'].str.replace(' & ', '&')

OR In your code, use regex=True

df['Product Summary'] = df['Product Summary'].replace(r'\b & ', '&', regex=True)

answered Nov 12, 2019 at 6:29

Vishnudev Krishnadas

11k2 gold badges29 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using regex to replace certain keyword in a dataframe value in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related