Pandas - convert value as type string to float

Question

In my df I have some values set up as dtype(str)

And I would like to convert them to float, ending up with:

How do I do this?

I mean 1 minute = 60 seconds, so 47 seconds is about .76 minute, not .47 minute. — Quang Hoang
– Quang Hoang, Commented Oct 25, 2020 at 2:26

Quang Hoang · Accepted Answer · 2020-10-25 02:28:57Z

1

In your case, you can do:

df['x'] = df['x'].str.replace(':','.').astype(float)

Output:

answered Oct 25, 2020 at 2:28

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges

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

Comments

avarice · Accepted Answer · 2020-10-25 02:29:05Z

1

Try this:

df['x'] = df['x'].replace(to_replace=":",value=".").astype(float)

answered Oct 25, 2020 at 2:29

avarice

15.6k3 gold badges19 silver badges38 bronze badges

.str is needed.

Nope. Beacuse this is Pandas .replace() method

well, the solution below worked and the only difference is that one....

yes...I made sure to pass df.x.astype(str)...but somehow it only works with .str before replace

For earlier me it worked without .str, still can't figure out what's the cause