How do change a data type of all columns in python

Question

I am using pandas data frames. The data contains 3032 columns. All the columns are 'object' datatype. How do I convert all the columns to 'float' datatype?

jezrael · Accepted Answer · 2020-12-01 11:39:33Z

3

If need convert integers and floats columns use to_numeric with DataFrame.apply for apply for all columns:

df = df.apply(pd.to_numeric)

working same like:

df = df.apply(lambda x: pd.to_numeric(x))

If some columns contains strings (so converting failed) is possible add errors='coerce' for repalce it to missing values NaN:

df = df.apply(pd.to_numeric, errors='coerce')

answered Dec 1, 2020 at 11:39

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Comments

Ivan Calderon · Accepted Answer · 2020-12-01 16:03:23Z

0

If you are reading the df from a file you can do the same when reading using converters in case you want to apply a customized function, or using dtype to specify the data type you want.

answered Dec 1, 2020 at 16:03

Ivan Calderon

6281 gold badge7 silver badges14 bronze badges

Collectives™ on Stack Overflow

How do change a data type of all columns in python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related