How to Remove Currency symbols from a column?

Jaya Prakash

I have a dataframe with 400+ rows and 8 cols

For the column avgprice the values are like

100₹

100$

10000Eu

etc

so my requirement is how to remove those symbols?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Accepted answer

Hi Jaya prakash,

Could you please specify in which format and language you want to extract the data,
You can do the following in Python,

df['avgprice'] = (
    df['avgprice']
        .astype(str)
        .str.replace(r'\D', '', regex=True)
        .astype(int)
)

if you want to store seperately,

df['currency'] = df['avgprice'].str.extract(r'([^\d.]+)')
df['avgprice'] = df['avgprice'].str.replace(r'[^0-9.]', '', regex=True).astype(float)