解决Python写入csv文件时出现空行问题 繁体 中文乱码 问题 encoding=‘utf_8_sig‘中文乱码 0x80 is valid in some characters sets. In

0x80 is valid in some characters sets. In windows-1252/cp1252 it’s €.

with io.open(file_name, 'r', encoding='windows-1252') as twitter_file:
    for line in twitter_file:
        # line is now a <type 'unicode'>
        tweet = json.loads(line)

参考
https://stackoverflow.com/questions/38518023/unicodedecodeerror-utf8-codec-cant-decode-byte-0x80-in-position-3131-invali

 with open("test.csv", "w", encoding='utf_8_sig', newline='') as fp:
                    writer = csv.writer(fp, delimiter=",")
                    # writer.writerow(["your", "header", "foo"])  # write header
                    writer.writerows(rsp_info)


    with open(r'E:\code\pypy3.9\gscm_pypy\test.csv', encoding='utf_8_sig') as f:
        f_csv = csv.reader(f)
        for row in f_csv:
            m += 1
            # print(row)
            rsp_info.append(row)
            # if m > 500:
            #     break

import csv

flow = open('./my csv file.csv, 'w',newline='')
csv_writer = csv.writer(flow)

for line in lines:
	csv_writer.writerow(line)

参考
https://blog.csdn.net/weixin_48397678/article/details/122436444