34 lines
861 B
Python
34 lines
861 B
Python
import pandas as pd
|
||
from googletrans import Translator
|
||
|
||
# 输入输出路径
|
||
input_file = "de.csv" # 你上传的德语语言文件
|
||
output_file = "zh.csv" # 翻译后的中文语言文件
|
||
|
||
# 读取 csv（逗号分隔）
|
||
df = pd.read_csv(input_file, header=None)
|
||
|
||
# 初始化翻译器
|
||
translator = Translator()
|
||
|
||
# 翻译第三列
|
||
translated = []
|
||
for text in df[2]:
|
||
if pd.isna(text): # 跳过空值
|
||
translated.append("")
|
||
else:
|
||
try:
|
||
result = translator.translate(str(text), src="de", dest="zh-cn")
|
||
translated.append(result.text)
|
||
except Exception as e:
|
||
print(f"翻译失败: {text} -> {e}")
|
||
translated.append(text)
|
||
|
||
# 替换第三列
|
||
df[2] = translated
|
||
|
||
# 保存
|
||
df.to_csv(output_file, index=False, header=False, encoding="utf-8")
|
||
|
||
print(f"翻译完成，保存为 {output_file}")
|