Python-Core-50-Courses icon indicating copy to clipboard operation
Python-Core-50-Courses copied to clipboard

csv存入汉字内容乱码

Open 11003 opened this issue 1 year ago • 2 comments

将数据写入CSV文件

csv存入汉字内容乱码

import csv
import random

with open('scores.csv', 'w',encoding='utf-8') as file:
    writer = csv.writer(file, delimiter='|', quoting=csv.QUOTE_ALL)
    writer.writerow(['姓名', '语文', '数学', '英语'])
    names = ['关羽', '张飞', '赵云', '马超', '黄忠']
    for name in names:
        scores = [random.randrange(50, 101) for _ in range(3)]
        scores.insert(0, name)
        writer.writerow(scores)

11003 avatar Apr 21 '23 10:04 11003

从CSV文件读取数据 同理:

with open('scores.csv', 'r',encoding='utf-8') as file:
    reader = csv.reader(file, delimiter='|')
    for data_list in reader:
        print(reader.line_num, end='\t')
        for elem in data_list:
            print(elem, end='\t')
        print()

11003 avatar Apr 21 '23 10:04 11003

需要加上encoding='utf-8'

11003 avatar Apr 21 '23 10:04 11003