python处理csv文件

python处理csv文件

1、代码如下:

import csv import random with open('scores.csv', 'w') 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) with open('scores.csv', 'r') 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()

2、执行结果:

打印结果:

文件内容: