Issue converting Data frame datatype from object to float64

Question

I need to convert the datatype of y_test from object to float64. I first converted into an array of strings ( In[54] ) and then to an array of floating point numbers (Inputs [83] & [85]) but it is not added to the y_test data frame.

y_test feature CO(ppm) is still displayed as object datatype ( Out[90] ).

Can someone please help me understand how to accomplish this? Thank you.

A few changes here would be helpful: 1) please post code as text rather than as an image; 2) for this question you could post a dataset of just a couple of entries which would illustrate your problem, and then we could run that ourselves which would help in understanding what's going on. It's definitely best to aim for a MRE whenever possible. — tom10
– tom10, Commented Oct 16, 2020 at 1:03
All those Out lines just show a new array generated by the action. Nothing is being changed in-place. y_test remains unchanged. — hpaulj
– hpaulj, Commented Oct 16, 2020 at 1:39
That makes sense. I will post better framed questions next time. Thank you for your comments everyone. — Warrior
– Warrior, Commented Oct 16, 2020 at 14:28

Ehsan · Accepted Answer · 2020-10-16 01:15:34Z

1

Try:

y_test['CO'] = y_test.CO.apply(lambda x: x.replace(',','')).astype(float)

answered Oct 16, 2020 at 1:15

Ehsan

12.5k2 gold badges24 silver badges36 bronze badges

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

1 Comment

Warrior Over a year ago

Got it. String to float conversion also replaces the comma values. Thanks.

Collectives™ on Stack Overflow

Issue converting Data frame datatype from object to float64

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related