有道词典翻译保存到CSV

赵乾舟

1. import requests
   
2. import json
   
3. import pandas as pd
   
4. 输入 = input('请输入你要翻译的内容：')
   
5. 网址 = 'http://fanyi.youdao.com/translate?smartresult=dict&smartresult=rule'
   
6. 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'}
   
7. 响应数据 = requests.post(url=网址,headers=UA伪装).text
   
8. data = {}
   
9. data['i'] = 输入
   
10. data['doctype'] = 'json'
    
11. data['from'] = 'AUTO'
    
12. data['to'] = 'AUTO'
    
13. data['client'] = 'fanyideskweb'
    
14. 响应数据 = requests.post(url=网址,headers=UA伪装,data=data).text
    
15. 字典 = json.loads(响应数据)
    
16. 结果 = 字典['translateResult'][0][0]['tgt']
    
17. # print(字典['translateResult'][0][0]['tgt'])
    
18. 数据 = pd.DataFrame({'a':[输入],'b':[结果]})
    
19. 数据.to_csv('c:/翻译结果.csv',index=False,header=0,mode='a',encoding="ANSI")
    

复制代码

赵乾舟

循环列表翻译

1. import requests
   
2. import pandas as pd
   
3. import json
   
4. liebiao = ['华为','联想','长城']
   
5. url = 'http://fanyi.youdao.com/translate?smartresult=dict&smartresult=rule'
   
6. 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'}
   
7. respon = requests.post( url = url,headers=UA).text
   
8. for i in liebiao:
   
9.     data = {}
   
10.     data['i'] = i
    
11.     data['from'] = 'AUTO'
    
12.     data['to'] = 'AUTO'
    
13.     data['client'] = 'fanyideskweb'
    
14.     data['doctype'] = 'json'
    
15.     respon = requests.post( url = url,headers=UA,data=data).text
    
16.     zidian = json.loads(respon)
    
17.     zidian=zidian['translateResult'][0][0]['tgt']
    
18.     shuju = pd.DataFrame({'a':[i],'b':[zidian]})
    
19.     shuju.to_csv('d:/fanyi.csv',index=False,header=0,mode='a',encoding='ANSI')
    

复制代码

赵乾舟

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

1. import requests
   
2. import pandas as pd
   
3. import json
   
4. pd1 = pd.read_csv('d:/fanyi.csv',encoding='gbk')
   
5. neirong = ','.join(pd1['翻译'])
   
6. liebiao = list(neirong.split(','))
   
7. url = 'http://fanyi.youdao.com/translate?smartresult=dict&smartresult=rule'
   
8. 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'}
   
9. respon = requests.post( url = url,headers=UA).text
   
10. for i in liebiao:
    
11.     data = {}
    
12.     data['i'] = i
    
13.     data['from'] = 'AUTO'
    
14.     data['to'] = 'AUTO'
    
15.     data['client'] = 'fanyideskweb'
    
16.     data['doctype'] = 'json'
    
17.     respon = requests.post( url = url,headers=UA,data=data).text
    
18.     zidian = json.loads(respon)
    
19.     zidian=zidian['translateResult'][0][0]['tgt']
    
20.     shuju = pd.DataFrame({'a':[i],'b':[zidian]})
    
21.     shuju.to_csv('d:/fanyi31.csv',index=False,header=0,mode='a',encoding='ANSI')

复制代码