我有一个专栏"City_trad_chinese"在 pandas 数据框中"df"其中包含繁体中文的值。我需要创建另一个专栏"City_English"其中必须包含英文翻译值。
我怎样才能用Python做到这一点？我尝试了以下方法：
#importing required libraries
import pandas as pd
from os import path
from googletrans import Translator
#setting path to data
path2data = 'C:/Users/data'
# data import
df = pd.read_excel(path.join(path2data, 'data.xlsx'), converters={'City_trad_chinese':str})
translator = Translator()
df['City_English'] = df['City_trad_chinese'].map(lambda x: translator.translate(x, src="zh-TW", dest="en").text)
但它给了我一个错误：
raise JSONDecodeError("Expecting value", s, err.value) from None
JSONDecodeError: Expecting value
您可以使用图书馆googletrans
import pandas as pd
from googletrans import Translator
d = {"City_trad_chinese":["香港特别行政区",
"澳门特别行政区",
"北京市",
"上海市"]}
df = pd.DataFrame(data=d)
translator = Translator()
df["City_English"] = df["City_trad_chinese"].map(lambda x: translator.translate(x, src="zh-TW", dest="en").text)
print(df["City_English"])
0 Hong Kong Special Administrative Region
1 Macao Special Administrative Region
2 Beijing City
3 Shanghai City
Note:谷歌翻译 API 有一个15k 字符限制。您可以通过单独翻译每一行来绕过这个问题：
df["City_English"] = ""
for index, row in df.iterrows():
translator = Translator()
eng_text = translator.translate(row["City_trad_chinese"], src="zh-TW", dest="en").text
row["City_English"] = eng_text
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
