How to convert a field of dataframe into int in python?

Question

In my dataset, i have a feature (called Size) like this one:

import pandas as pd


dit={"Size" : ["0","0","5","15","10"] }
dt = pd.DataFrame(data=dit)

when i run dt.info() it gives me the below result:

Size                                     140 non-null object

However, i expect it to be int. When i try the below code:

dt.loc[:,"Size"] = dt.loc[:,"Size"].astype(int)

it complains with:

ValueError: invalid literal for int() with base 10: ' '

How can i convert Size to int?

Which pandas version do you use? I used your code exactly and got Size 5 non-null int64 — Tom Ron
– Tom Ron, Commented Jul 21, 2019 at 8:18
I perhaps got this when I ran dt.info() : <class 'pandas.core.frame.DataFrame'> RangeIndex: 5 entries, 0 to 4 Data columns (total 1 columns): Size 5 non-null int64 dtypes: int64(1) memory usage: 120.0 bytes — Roshan
– Roshan, Commented Jul 21, 2019 at 8:29

Rahul charan · Accepted Answer · 2019-07-21 08:32:59Z

2

Use pd.to_numeric() :-

dit={"Size" : ['0','0','5','15','10'] }
dt = pd.DataFrame(data=dit)
dt['Size'] = pd.to_numeric(dt['Size'])
dt.info()

Output

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 5 entries, 0 to 4
Data columns (total 1 columns):
Size    5 non-null int64
dtypes: int64(1)
memory usage: 120.0 bytes

answered Jul 21, 2019 at 8:32

Rahul charan

8559 silver badges17 bronze badges

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

Comments

terance98 · Accepted Answer · 2019-07-21 08:34:48Z

1

Here you have to select the column to be converted, use the .values to get the array containing all values and then use astype(dtype) to convert it to integer format.

dt['Size'].values.astype(int)

answered Jul 21, 2019 at 8:34

terance98

1096 bronze badges

Collectives™ on Stack Overflow

How to convert a field of dataframe into int in python?

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related