Excel sheet translation using python

Question

I have an excel sheet filled with English text, so now I wanted to convert each text to other languages (example:- french) and insert in the next column of the excel sheet using python.

So how to approach this?

I'm currently going through pandas of python.

Ian · Accepted Answer · 2019-10-12 03:07:55Z

1

This should work. Make sure you pip install googletrans-temp

import pandas as pd
from googletrans import Translator 

# read from an excel file
df = pd.read_excel('/Users/andrewgreatorex/Downloads/test_spreadsheet.xlsx')

# translate a column to French, and add back into the DataFrame
translator = Translator()         
df['French'] = df['text'].apply(translator.translate,src='en',dest='fr').apply(getattr, args=('text',))

# output new excel file
df.to_excel('name_of_your_output_file.xlsx')

answered Oct 12, 2019 at 3:07

Ian

3,9684 gold badges34 silver badges77 bronze badges

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

5 Comments

user11650863 Over a year ago

Thanks Andy!!! But sometimes it works fine and sometimes I'm getting "JSONDecodeError: Expecting value" can I know the reason for it. If I get this error then it is not working at all.

user11650863 Over a year ago

df['French'] = df['text'].apply(translator.translate,src='en',dest='fr').apply(getattr, args=('text',))..... If once it comes then the code doesn't run at all and throws same error

user11650863 Over a year ago

Came to know that this error is because of character limit that Google translate has 15k. How to overcome this? Should I change the code?

Ian Over a year ago

Try using a different translation package, pypi.org/project/translate looks like it might do the trick

user11650863 Over a year ago

Yes it works!! But even this has a limit for translation same as Google translate API.

Collectives™ on Stack Overflow

Excel sheet translation using python

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related