Python - apply lambda with an if condition

Question

I want to transform a pandas column that contains Nan from string to float. This is the code I tried but it keeps returning me an invalid syntax error

data.VAL_DEAL=data.VAL_DEAL.apply(lambda x: float(x.replace(",","")) if math.isnan(x)!=True)

You can just do df['VAL_DEAL'] = pd.to_numeric(df['VAL_DEAL'], errors='coerce'), there is no need to use apply here — EdChum
– EdChum, Commented Jun 27, 2018 at 9:23

user2390182 · Accepted Answer · 2018-06-27 09:26:49Z

2

The following lambda expression should work:

lambda x: float(x.replace(",","") if not math.isnan(x) else x)

Note the mandatory else-part. This assumes that you want the nan's unchanged. See the docs on Conditional Expressions.

answered Jun 27, 2018 at 9:26

user2390182

73.7k6 gold badges71 silver badges95 bronze badges

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

Collectives™ on Stack Overflow

Python - apply lambda with an if condition

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