What the difference between int32 and int64

Question

I changed the type of AGHIGH, AGELOW from float to integer but I found the output is int32 not int64 by using that code

df[['AGEHIGH', 'AGELOW']] = df[['AGEHIGH', 'AGELOW']].astype(int)

1   SCHNAME     13902 non-null  object
2   LOCALITY    13902 non-null  object
3   TOWN        13902 non-null  object
4   SCHSTATUS   13902 non-null  object
5   MINORGROUP  13902 non-null  object
6   AGELOW      13902 non-null  int32 
7   AGEHIGH     13902 non-null  int32 
8   GENDER      13902 non-null  object

score 2 · Accepted Answer · answered Mar 21 '21 at 18:42

2

This was answered very well over here.

The key difference is in terms of storage capacity. An integer is held in bits (1s and 0s). Very simply a 64-bit integer can store a much larger/smaller number by virtue of having more bits.

Type Capacity

Int16 -- (-32,768 to +32,767)

Int32 -- (-2,147,483,648 to +2,147,483,647)

Int64 -- (-9,223,372,036,854,775,808 to +9,223,372,036,854,775,807)

answered Mar 21 '21 at 18:42

Andy Thomas

81
2

So you want the output to be int64 and not int32 (the default)? – Andy Thomas Mar 21 '21 at 21:35
Try amending astype(int) to astype(int64) – Andy Thomas Mar 21 '21 at 21:36
name 'int64' is not defined – Nora Yassin Mar 21 '21 at 22:01
this is the output – Nora Yassin Mar 21 '21 at 22:01
You are using numpy with pandas dataframes is that right? Try the below (assuming you have defined numpy as np) df[['AGEHIGH', 'AGELOW']] = df[['AGEHIGH', 'AGELOW']].astype(np.int64) – Andy Thomas Mar 21 '21 at 23:04

What the difference between int32 and int64

1 Answers1