How to change dtype of multiple specific columns

Question

How do i change multiple columns to a float when i also need to change , to.

DF looks like this except i dropped all the NAN values as i dont need those rows.

This is the dtypes

And this is the way im doing it now, but it takes hella long time. I know you can do a loop but i don't understand how.

Mayank Porwal · Accepted Answer · 2021-03-05T08:01:02.267

1

Use df.iloc:

df.iloc[:, 2:] = df.iloc[:, 2:].replace(',', '.', regex=True).astype(float)

edited Mar 05 '21 at 08:01

answered Mar 05 '21 at 07:52

Mayank Porwal

it says "could not convert string to float: '22,1'" – Darshanath Munasinghe Mar 05 '21 at 07:55
1

Edited my answer. Please try now. – Mayank Porwal Mar 05 '21 at 07:55
Yes!!! Thank you, can i contact you for some further questions ? Im trying to go pro at EDA and ML @MayankPorwal – Darshanath Munasinghe Mar 05 '21 at 08:12

1 Answers1