how to remove multiple characters from dataframe

Question

I'm trying to understand how to make my code more concise. I have the following statement which works fine:

cleaned = dc_listings['price'].str.replace(',', '').str.replace('$', '')

However, when I try using a regex, as in the below, it does not work:

cleaned = dc_listings['price'].str.replace(',|$', '')

The cleaned variable still contains some '$' entries... What am I doing wrong?

Thanks!

jezrael · Accepted Answer · 2017-10-29 17:03:44Z

3

Need escape $ by \, because special regex character - end of string:

dc_listings = pd.DataFrame({'price':[',ll','j$,']})
cleaned = dc_listings['price'].str.replace(',|\$', '')
print (cleaned)
0    ll
1     j
Name: price, dtype: object

answered Oct 29, 2017 at 17:03

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

how to remove multiple characters from dataframe

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