如何在pandas dataframe中将其他语言翻译成英语

import pandas as pd

data = {'语言': ['你好', 'こんにちは', '안녕하세요']}
df = pd.DataFrame(data)

from googletrans import Translator

translator = Translator(service_urls=['translate.google.com'])

# 定义翻译函数
def translate_text(text):
    result = translator.translate(text, dest='en')
    return result.text

# 将翻译函数应用于DataFrame的每个单元格
df['翻译结果'] = df['语言'].apply(translate_text)

import requests
import json

# 定义腾讯云翻译 API 请求函数
def translate_text(text):
    # 替换为你自己的腾讯云 API 密钥
    secret_id = 'your_secret_id'
    secret_key = 'your_secret_key'
    
    # 替换为你自己的腾讯云翻译 API 地址
    api_url = 'https://tmt.tencentcloudapi.com/'
    
    # 构造请求参数
    params = {
        'Action': 'TextTranslate',
        'SourceText': text,
        'Source': 'auto',
        'Target': 'en',
        'ProjectId': 0,
        'Region': 'ap-guangzhou',
    }
    
    # 发送请求
    response = requests.get(api_url, params=params, auth=(secret_id, secret_key))
    result = json.loads(response.text)
    
    # 解析响应结果
    if 'Response' in result and 'TargetText' in result['Response']:
        return result['Response']['TargetText']
    else:
        return ''

# 将翻译函数应用于DataFrame的每个单元格
df['翻译结果'] = df['语言'].apply(translate_text)