Convert object column to int column in python

Question

I somehow have a strange conversion problem in python. I have an object column which I want to convert to an int column to save some memory space.

I run the following command:

df['Number'] = df['IntC'].astype(int)

and somehow for some rows it ends up like this:

IntC               Number
233004885002       -188830000475
233048850003       -195883838200

What is happening here? I would expect this output:

IntC               Number
233004885002       233004885002 
233048850003       233048850003

BENY · Accepted Answer · 2020-05-07 14:43:05Z

1

If convert object to int , why not do factor

df['Number'] = df.IntC.factorize()[0]

answered May 7, 2020 at 14:43

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Comment

somehow it gives the same error, `astype('int64') works

somesh kovi · Accepted Answer · 2021-04-02 06:31:33Z

0

Using Lambda function is a much-generalized option

df['Number'] = df.IntC.apply(lambda c: int(c))

answered Apr 2, 2021 at 6:31

somesh kovi

244 bronze badges