converting exponent or scientific number into integer in pandas python

Question

i am a beginner in python and trying to get the row from the data set which has highest idmb rating and highest gross total which i have manged to get but my value of gross_total isn't in integer. how i can convert it into integer? and how to get that specific value for performing statistical functions.

import pandas as pd

dataset=pd.read_excel('movies.xls')

name=dataset['Title']
idmb=dataset['IMDB Score']

networth=dataset['Gross Earnings']

test_df=pd.DataFrame({'movie':name,
                  'rating':idmb,
                  'gross_total':networth})


 nds=test_df.dropna(axis=0,how='any')

 a=nds['gross_total'].astype(int)

 highest_rating =nds.loc[nds['rating'].idxmax()]

 highiest_networth=nds.loc[ nds['gross_total'].idxmax()]

 print(highest_rating)

 print(highiest_networth)

i get this output

  gross_total                  2.83415e+07
  movie          The Shawshank Redemption 
  rating                               9.3
  Name: 742, dtype: object

i have searched and came to know about the "pd.to_numeric" and "astype" functions but i couldnt understand how to use this in this sitution.

score 9 · Answer 1 · answered May 17 '19 at 07:41

9

This worked for me, worth giving a try:

df['col_name'] = df['col_name'].astype('int64')

answered May 17 '19 at 07:41

Shalini Baranwal

2,780
4
24
34

Patrick Artner · Answer 2 · 2018-04-14T22:30:06.520

You format your output accordingly:

n =  2.83415e+07

print(f'{n:f}')
print(f'{n:e}')

Output:

28341500.000000
2.834150e+07

See string format mini language

Pandas works the same:

import pandas as pd

df = pd.DataFrame ( [{"tata": 2.325568e9}])

# print with default float settings
print (df) 

pd.options.display.float_format = '{:,.4f}'.format  # set other global format
# print with changed float settings
print(df)

# really convert the type:
df["tata"] = df["tata"].astype(int)
# print with default int settings
print(df)

Credit to: unutbu's answer here

Output:

           tata
0  2.325568e+09          # before format change

                tata
0 2.325.568.000,0000     # after format change


         tata            # after int conversion
0 -2147483648

There are other ways to do formatting - see How to display pandas DataFrame of floats using a format string for columns?

Useful! My issue: I had a decimal in percentage form (call it n), and formatted it as `n.2`. Changing this to `n.2f` rounded it to 2 decimal places, while removing the scientific notation. Thank you! — Gustavo Louis G. Montańo, Jan 21 '23 at 23:44

score 5 · Answer 3 · edited Apr 03 '19 at 20:44

5

I had the same problem. Use

df['Tata'].map(int)

edited Apr 03 '19 at 20:44

Zoe

27,060
21
118
148

answered Apr 03 '19 at 20:43

Li Wang

51
1
2

score 1 · Answer 4 · edited Jul 14 '21 at 11:45

1

pd.set_option('display.float_format', '{:.2f}'.format)
df = pd.DataFrame({'Traded Value':[67867869890077.96,78973434444543.44],
              'Deals':[789797, 789878]})
print(df)

	Traded Value	Deals
0	67867869890077.96	789797
1	78973434444543.44	789878

edited Jul 14 '21 at 11:45

elena.kim

930
4
12
22

answered Jul 14 '21 at 06:46

ALPHA Q

11
1
3

converting exponent or scientific number into integer in pandas python

4 Answers4

Linked