Python-Core-50-Courses
Python-Core-50-Courses copied to clipboard
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)
从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()
需要加上encoding='utf-8'