translate dataframe column with python

Question

i want to translate column of my dataframe from french to english.

 from googletrans import Translator 
 translator = Translator()         
 df = pd.DataFrame({'French':['ma voiture','Il fait beau aujourdhui']})
 df['English'] = df['French'].apply(translator.translate,src='fr',dest='en').apply(getattr, args=('text',))

I did these lines but i found an error.. How can i solve it please.?

Note that in line 1 you miss a comma after `aujourd'` and a quote before `hui`.Moreover, what is the definition of `translator`? — sentence, Apr 22 '19 at 14:14
yepp .. `from googletrans import Translator translator = Translator()` — anayisse2, Apr 22 '19 at 14:15
Unfortunately I do not use that package. As suggested by @chitown88, maybe you should try with other packages. — sentence, Apr 22 '19 at 17:57

score 0 · Answer 1 · answered Apr 22 '19 at 15:08

0

Well I was having an issue with googletrans. But then tried the solution here that suggests to do:

pip install googletrans-temp

And your code seemed to work just fine:

Output:

print (df)
                    French                         English
0               ma voiture                          my car
1  Il fait beau aujourdhui  Such a beautiful weather today

answered Apr 22 '19 at 15:08

chitown88

27,527
4
30
59

i have always the same problem of ** JSONDecodeError: Expecting value: line 1 column 1 (char 0)** – anayisse2 Apr 22 '19 at 15:15
same error do you see how to solve it .. I did all what you recommand – anayisse2 Apr 22 '19 at 15:28
you get the same error with just the rows in the dataframe? – chitown88 Apr 22 '19 at 15:38
yep with the same dataframe and the same rows – anayisse2 Apr 22 '19 at 15:47
From what I've been reading, it might be a restriction with google's end. you may need to try through a VPN. – chitown88 Apr 22 '19 at 15:49
i didn't understandwhat do you mean? – anayisse2 Apr 22 '19 at 15:51
the translator works off of googlies api. And Googles server may be blocking your specific request from your IP for whatever reason. – chitown88 Apr 22 '19 at 15:53
oh .. And how can i get the translate with other manner please – anayisse2 Apr 22 '19 at 15:56
1

not really sure. May just have to find another library or package. I'm not too familiar with other ones. You might just have to search around and see. – chitown88 Apr 22 '19 at 16:09
I just tried a different package and got the same error as you. So to be honest, don’t know what the issue is. – chitown88 Apr 22 '19 at 17:29

score 0 · Answer 2 · answered Oct 08 '22 at 22:32

0

Google Translate has limits on volume translated. EasyNMT is a scalable solution.

from easynmt import EasyNMT
model = EasyNMT("opus-mt")

df["English"] = df.apply(lambda row: model.translate(row["French"], target_lang="en"), axis=1)

answered Oct 08 '22 at 22:32

Saurabh Khanna

531
4
4

translate dataframe column with python

2 Answers2