配合有道翻译自动译文

import requests
import pandas as pd

def main(query):
    url = 'http://fanyi.youdao.com/translate'
    data = {
        "i": query,  # 待翻译的字符串
        "from": "AUTO",
        "to": "AUTO",
        "smartresult": "dict",
        "client": "fanyideskweb",
        "salt": "16081210430989",
        "doctype": "json",
        "version": "2.1",
        "keyfrom": "fanyi.web",
        "action": "FY_BY_CLICKBUTTION"
    }
    res = requests.post(url, data=data).json()
    # print(res)
    return res
    # print(res['translateResult'][0][0]['tgt'])  # 打印翻译后的结果

main('我')
main('In vitro studies inhibiting ATP1A1 expression in HT-144, G-361, C-32 and SKMEL-28 melanoma cell lines demonstrated ATP1A1 overexpression is activating as measured by reduced tumor growth upon ATP1A1 inhibition. Tumor cells expressing amplified ATP1A1 demonstrated sensitivity when treated with ATP1A1 inhibitor UNBS1450 and antioxidant N-acetyl cysteine (PMID: 26334094, 19243476).')

# {'type': 'EN2ZH_CN', 'errorCode': 0, 'elapsedTime': 4, 'translateResult': [[{'src': 'In vitro studies inhibiting ATP1A1 expression in HT-144, G-361, C-32 and SKMEL-28 melanoma cell lines demonstrated ATP1A1 overexpression is activating as measured by reduced tumor growth upon ATP1A1 inhibition. ', 'tgt': '体外研究抑制ATP1A1表达ht - 144 c - 32 g - 361和SKMEL-28黑色素瘤细胞系证明ATP1A1过度激活以减少对ATP1A1抑制肿瘤的生长。'}, {'src': 'Tumor cells expressing amplified ATP1A1 demonstrated sensitivity when treated with ATP1A1 inhibitor UNBS1450 and antioxidant N-acetyl cysteine (PMID: 26334094, 19243476).', 'tgt': '肿瘤细胞表达放大ATP1A1证明灵敏度时接受UNBS1450 ATP1A1抑制剂和抗氧化剂n -乙酰半胱氨酸(PMID: 26334094、19243476)。'}]]}

df1=pd.read_excel(r'C:\Users\Administrator\Desktop\search\CNV数据库(1).xlsx',sheet_name='oncokb')
df2=pd.read_excel(r'C:\Users\Administrator\Desktop\search\CNV数据库(1).xlsx',sheet_name='ckb')

for i in range(len(df1)):
    if pd.isnull(df1.loc[i,'Interpretation']) == False:
        list_all = main(df1.loc[i, 'Interpretation'])['translateResult'][0]
        text_last=''
        for j in list_all:
            text_add=j['tgt']
            text_last += text_add

        df1.loc[i,'chinese']=text_last
    else:
        pass

new_wb=pd.ExcelWriter(r'C:\Users\Administrator\Desktop\search\CNV数据库_update.xlsx')
df1.to_excel(new_wb,sheet_name='oncokb',index=None)
df2.to_excel(new_wb,sheet_name='ckb',index=None)

#new_wb.save()
new_wb.close()