时间戳

首页 > 解决方案 > CSV Python 3中的特殊字符

python - CSV Python 3中的特殊字符

问题描述

Excel 在编码后未正确生成特殊字符。我尝试直接对excel文件进​​行编码，以及将文本输入到csv中。我还尝试将 excel 文件更改为 CSV UTF-8。我使用的是 python 3 和 mac os。

以下是终端和 excel 中的输出图片： https ://imgur.com/a/7KkhZUJ

from googletrans import Translator

translator = Translator()

with open('text.txt', 'r') as fin:

    text = fin.read()
    lst = text.split("\n")


with open('spreadsheet.csv', 'w', encoding= 'UTF-8', newline='') as fout:
    headers = "English, Arabic, Chinese(simplified), Chinese(traditional, Finnish, French, German, Greek, Hebrew, Hindi, Irish, Italian, Japanese, Korean, Polish, Portuguese, Russian, Spanish, Turkish\n"
    fout.write(headers)

    language_lst = ['en','ar','zh-CN', 'zh-TW', 'fi', 'fr', 'de','el', 'iw', 'hi', 'ga', 'it', 'ja', 'ko', 'pl', 'pt', 'ru', 'es', 'tr']
    new_lst = []
    for item in lst:
        for i in language_lst:
            translated_text = translator.translate(item, dest = i)


            new = str(translated_text).split(",")[2].replace("text=","").strip()

            new_lst.append(new)


    counter = 0

    for z in new_lst:
        z.encode('utf-8')
        fout.write(z+ ',')
        counter += 1
        print(z)

        if counter % 19 == 0:
            fout.write('\n')

标签： pythonexcelpython-3.xcsvencoding

解决方案

推荐阅读