title: converting exponent or scientific number into integer in pandas python
body: <p>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. </p>
  
  <pre><code>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)
  </code></pre>
  
  <p>i get this output</p>
  
  <pre><code>  gross_total                  2.83415e+07
    movie          The Shawshank Redemption 
    rating                               9.3
    Name: 742, dtype: object
  </code></pre>
  
  <p>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.</p>