Converting string to float - python

Question

How can I convert one string column to float considering that it contains N/A values? I've tried to use the to_numeric function, but I'm receiving an error: "Unable to parse string "N/A" at position.

Use an if condition. Check if the value is not NA then do the conversion. — Anurag
– Anurag, Commented Feb 4, 2022 at 15:16
if pandas, something like: np.where(df["your column"].isna() is False, df["your column"], df["your column"].astype(float)) — mechanical_meat
– mechanical_meat, Commented Feb 4, 2022 at 15:19
Yes, pandas. I've tried this code, but it also results in an error "could not convert string to float: 'N/A' — anla01
– anla01, Commented Feb 4, 2022 at 15:24
oh it's a string, then just: df["your column"].replace("N/A", np.nan).astype(float) — mechanical_meat
– mechanical_meat, Commented Feb 4, 2022 at 15:32

BrokenBenchmark · Accepted Answer · 2022-02-04 22:10:18Z

6

The solution that worked in my case was to add an argument errors='coerce' to the to_numeric function.

df["mycolumn"] = pd.to_numeric(df["mycolumn"], errors='coerce', downcast="float")

edited Feb 4, 2022 at 22:10

BrokenBenchmark

19.4k7 gold badges26 silver badges40 bronze badges

answered Feb 4, 2022 at 16:30

anla01

1332 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

Converting string to float - python

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