ValueError: could not convert string to float: '' Pandas DataFrame

Question

I got an error in my code while converting string to character.

This is my dataframe image:

This how I remove the unit in the data:

and then while converting with:

for i in ['Power']:
    data[i] = data[i].astype(float)

I got the following error message:

Error message

Fun fact: if you google your title, you'll get a link to identical question with answers. — go2nirvana
– go2nirvana, Commented Apr 29, 2021 at 9:54
You left a space after every number. You should also remove space to convert sting into float. — Zalak Bhalani
– Zalak Bhalani, Commented Apr 29, 2021 at 10:00
i google it, and try the solution but still get that error message — MRSL
– MRSL, Commented Apr 29, 2021 at 10:49

vbhatt · Accepted Answer · 2021-04-29 10:19:30Z

0

import pandas as pd
data = {'Power': ['58.6 bhp', '126.2 bhp', '88.7 bhp']}
df = pd.DataFrame(data)


df=df.replace({'Power':'[a-z]'},'',regex=True)

you can use lambda for row wise operation and convert to "float" as below :

df['Power']=df['Power'].apply(lambda row: float(row))

answered Apr 29, 2021 at 10:04

vbhatt

484 bronze badges

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

1 Answer 1