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, Jul 21 '19 at 08:18
I perhaps got this when I ran `dt.info()` : ` 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, Jul 21 '19 at 08:29
Could you try running this in `Jupyter Notebooks` or datalore.io? — Roshan, Jul 21 '19 at 08:30
I got this (*After your edit*) : ` RangeIndex: 5 entries, 0 to 4 Data columns (total 1 columns): Size 5 non-null object dtypes: object(1) memory usage: 120.0+ bytes` — Roshan, Jul 21 '19 at 08:32
Possible duplicate of [Change data type of columns in Pandas](https://stackoverflow.com/questions/15891038/change-data-type-of-columns-in-pandas) — M_S_N, Jul 21 '19 at 08:37

score 2 · Answer 1 · answered Jul 21 '19 at 08:32

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

score 1 · Answer 2 · answered Jul 21 '19 at 08:34

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 '19 at 08:34

terance98

109
5

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

2 Answers2