title: How to translate other languages to English in pandas dataframe
body: <p>I am having an excel file where the &quot;value&quot; column contains different language statements. I want to translate the entire value column into English.</p>
  <p><a href="https://i.stack.imgur.com/2NIxS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2NIxS.png" alt="enter image description here" /></a></p>
  <p>For testing purpose I'm using the below code, but it's throwing some exception</p>
  <pre><code>import pandas as pd
  from googletrans import Translator
  exl_file = 'ipfile1.xlsx'
  df = pd.read_excel(exl_file)
  print(df)
  
  translator = Translator()
  df1 = df['value'].apply(translator.translate, src='es', dest='en').apply(getattr, args=('text',))
  print(df1)
  </code></pre>
  <p>Can you please guide how to apply translator on each rows to convert into English?</p>