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

Question

COD_CUST  
 10025.0   
 10761.0  
 10869.0    
 12361.0

trying to convert the above column into integer as below:

mser_offus['COD_CUST']=mser_offus['COD_CUST'].astype(int)

but getting the following error:

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

jezrael · Accepted Answer · 2018-04-06 10:41:17Z

0

IIUC if need remove all values after . and convert to int:

df['COD_CUST'] = df['COD_CUST'].astype(float).astype(int)
print (df)
   COD_CUST
0     10025
1     10761
2     10869
3     12361

answered Apr 6, 2018 at 10:35

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Comments

SKan · Accepted Answer · 2018-08-19 20:48:32Z

0

you may use, print (int(float(COD_CUST)))

answered Aug 19, 2018 at 20:48

SKan

1