赵乾舟 发表于 2021-7-28 13:46:40

有道词典翻译保存到CSV

import requests
import json
import pandas as pd
输入 = input('请输入你要翻译的内容：')
网址 = 'http://fanyi.youdao.com/translate?smartresult=dict&smartresult=rule'
UA伪装 = {'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.92 Safari/537.36'}
响应数据 = requests.post(url=网址,headers=UA伪装).text
data = {}
data['i'] = 输入
data['doctype'] = 'json'
data['from'] = 'AUTO'
data['to'] = 'AUTO'
data['client'] = 'fanyideskweb'
响应数据 = requests.post(url=网址,headers=UA伪装,data=data).text
字典 = json.loads(响应数据)
结果 = 字典['translateResult']['tgt']
# print(字典['translateResult']['tgt'])
数据 = pd.DataFrame({'a':[输入],'b':[结果]})
数据.to_csv('c:/翻译结果.csv',index=False,header=0,mode='a',encoding="ANSI")


赵乾舟 发表于 2021-7-28 14:02:19

循环列表翻译
import requests
import pandas as pd
import json
liebiao = ['华为','联想','长城']
url = 'http://fanyi.youdao.com/translate?smartresult=dict&smartresult=rule'
UA = {'user-agent':'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36'}
respon = requests.post( url = url,headers=UA).text
for i in liebiao:
    data = {}
    data['i'] = i
    data['from'] = 'AUTO'
    data['to'] = 'AUTO'
    data['client'] = 'fanyideskweb'
    data['doctype'] = 'json'
    respon = requests.post( url = url,headers=UA,data=data).text
    zidian = json.loads(respon)
    zidian=zidian['translateResult']['tgt']
    shuju = pd.DataFrame({'a':,'b':})
    shuju.to_csv('d:/fanyi.csv',index=False,header=0,mode='a',encoding='ANSI')


赵乾舟 发表于 2021-7-28 14:32:32

读取CSV文件某一列，翻译到指定CSV文件

import requests
import pandas as pd
import json
pd1 = pd.read_csv('d:/fanyi.csv',encoding='gbk')
neirong = ','.join(pd1['翻译'])
liebiao = list(neirong.split(','))
url = 'http://fanyi.youdao.com/translate?smartresult=dict&smartresult=rule'
UA = {'user-agent':'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36'}
respon = requests.post( url = url,headers=UA).text
for i in liebiao:
    data = {}
    data['i'] = i
    data['from'] = 'AUTO'
    data['to'] = 'AUTO'
    data['client'] = 'fanyideskweb'
    data['doctype'] = 'json'
    respon = requests.post( url = url,headers=UA,data=data).text
    zidian = json.loads(respon)
    zidian=zidian['translateResult']['tgt']
    shuju = pd.DataFrame({'a':,'b':})
    shuju.to_csv('d:/fanyi31.csv',index=False,header=0,mode='a',encoding='ANSI')

页: [1]
查看完整版本: 有道词典翻译保存到CSV