convert float64 to int (excel to pandas)

Question

I have imported excel file into python pandas. but when I display customer numbers I get in float64 format i.e

7.500505e+09 , 7.503004e+09 how do convert the column containing these numbers

`df['col'] = df['col'].astype(int)` – luigigi Jan 10 '20 at 07:21 — luigigi, Jan 10 '20 at 07:21

score 0 · Answer 1 · answered Jan 10 '20 at 07:21

0

int(yourVariable) will cast your float64 to a integer number. Is this what you are looking for?

answered Jan 10 '20 at 07:21

CBM_89

39
3

@rahuldbz no – luigigi Jan 10 '20 at 07:23

score 0 · Answer 2 · answered Jan 10 '20 at 07:32

You can use pandas DataFrames style.format function to apply a formatting to a column like in https://towardsdatascience.com/style-pandas-dataframe-like-a-master-6b02bf6468b0. If you want to round the numbers to i.e. 2 decimal places follow the accepted answer in Python float to Decimal conversion. Conversion to an int reduces accuracy a bit too much i think

For the conecpt binary floats in general (what float64 is) see Python - round a float to 2 digits

score 0 · Answer 3 · answered Jan 10 '20 at 07:33

0

Please use pd.set_option to control the precision's to be viewed

>>> import pandas as pd
>>> a = pd.DataFrame({'sam':[7.500505e+09]})
>>> pd.set_option('float_format', '{:f}'.format)
>>> a
                sam
0 7500505000.000000
>>>

answered Jan 10 '20 at 07:33

Sam Stephen

3
2

i want it in 'int' – rahul dbz Feb 04 '20 at 19:26
this didnt work . it converted all those into float nd later i converted it into integer – rahul dbz Feb 04 '20 at 19:38

convert float64 to int (excel to pandas)

3 Answers3