Value error in converting a column from object to float

Question

I am trying to convert a column "value $" from datatype "Object" to "float" as this column would be involved in a numeric computation.

I initially replaced "$" in this column using:

 df['Value $'] = df['Value $'].replace({'\$': ''},regex=True)

Then convert it into numeric using:

 df['Value $'] = df['Value $'].astype(dtype=np.float64)

Cainã Max Couto da Silva · Accepted Answer · 2020-11-11 03:00:28Z

2

Probably it's because you should to replace the commas as well:

df['Value $'] = df['Value $'].replace({'\$|,': ''}, regex=True)
df['Value $'] = df['Value $'].astype(dtype=np.float64)

answered Nov 11, 2020 at 3:00

4,9691 gold badge15 silver badges39 bronze badges

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

Comments

Joe Ferndz · Accepted Answer · 2020-11-11 03:07:59Z

1

You can just use this to replace.

df['Value $'] = df['Value $'].fillna(0.0).str.replace('[$,]', '').astype('float')

answered Nov 11, 2020 at 3:07

Joe Ferndz

8,5282 gold badges15 silver badges37 bronze badges