问 谷歌翻译API -检测语言+翻译文档(xlsx，csv)

EN

遗憾的是，不能使用 batchTranslateText 将值的数组传递给字段 source_language_code 。我建议对每个文件执行 detectLanguage 和 translateText 。

下面的代码做的是：

1. 它提取要翻译的内容。出于测试目的，所使用的csv文件只有1列，并且sample1.csv的内容为 tl (塔加洛克语)，sample2.csv为 es (Spanish).
2. Pass格式。将提取的内容转换为 detect_language() 以获取检测到的语言代码。
3. 将所有必需的参数传递给 translate_text() 以转换

注意:下面的代码仅使用具有一列的csv文件进行测试。编辑 main() 中的代码，以根据您希望提取数据的列进行填充。

from google.cloud import translate
import csv
def listToString(s):
    """ Transform list to string"""
    str1 = " "
    return (str1.join(s))
def detect_language(project_id,content):
    """Detecting the language of a text string."""
    client = translate.TranslationServiceClient()
    location = "global"
    parent = f"projects/{project_id}/locations/{location}"
    response = client.detect_language(
        content=content,
        parent=parent,
        mime_type="text/plain",  # mime types: text/plain, text/html
    for language in response.languages:
        return language.language_code
def translate_text(text, project_id,source_lang):
    """Translating Text."""
    client = translate.TranslationServiceClient()
    location = "global"
    parent = f"projects/{project_id}/locations/{location}"
    # Detail on supported types can be found here:
    # https://cloud.google.com/translate/docs/supported-formats
    response = client.translate_text(
        request={
            "parent": parent,
            "contents": [text],
            "mime_type": "text/plain",  # mime types: text/plain, text/html
            "source_language_code": source_lang,
            "target_language_code": "en-US",
    # Display the translation for each input text provided
    for translation in response.translations:
        print("Translated text: {}".format(translation.translated_text))
def main():
    project_id="your-project-id"
    csv_files = ["sample1.csv","sample2.csv"]
    # Perform your content extraction here if you have a different file format #
    for csv_file in csv_files:
        csv_file = open(csv_file)
        read_csv = csv.reader(csv_file)
        content_csv = []
        for row in read_csv:
            content_csv.extend(row)
        content = listToString(content_csv) # convert list to string
        detect = detect_language(project_id=project_id,content=content)
        translate_text(text=content,project_id=project_id,source_lang=detect)