I need to change the type of few columns in a pandas dataframe. Can't do so using iloc

python pandas dataframe types casting

I guess it is a bug in 1.0.5. I tested on my 1.0.5. I have the same issue as yours. The .loc also has the same issue, so I guess pandas devs break something in iloc/loc. You need to update to latest pandas or use a workaround. If you need a workaround, using assignment as follows

df1[df1.columns[0:27]] = df1.iloc[:, 0:27].astype('int')

I tested it. Above way overcomes this bug. It will turn first 27 columns to dtype int32

python pandas dataframe types casting

Just don't use iloc. You can just create a loop over the 27 columns and convert them into the data type that you want.

df.info()my_columns = df.columns.to_list()[0:27]for i in my_columns:   df[i] = df[i].astype('int32')df.info()

CodeHunter

I need to change the type of few columns in a pandas dataframe. Can't do so using iloc

Recent Posts

How can I color dots in a xy scatterplot according to column value?

How to update a claim in ASP.NET Identity?

What does {0} mean when initializing an object?

Accessing members of items in a JSONArray with Java

How to log SQL statements in Spring Boot?

Powershell Get-WebSite name parameter is ignored

How to detect scroll to bottom of html element

Java synchronized method

How to test controllers with CodeIgniter?

Detect Visual Composer

Matplotlib: Specify format of floats for tick labels

Rails join a list of strings with commas and "and" before the last