import csv
header = None #存储标题行
data_list = []#每个学生的信息
with open('选课名单.csv', 'rt',newline='') as fo:
csv_reader = csv.reader(fo)
header=next(csv_reader)
for row in csv_reader:
data_list.append(row)
dept_all = set()
for row in data_list:
dept_all.add(row[4])
for dept in dept_all:
file_path = ".\系所\{}.csv".format(dept)
count = 1
with open(file_path,'wt',newline='')as fw:
csv_writer=csv.writer(fw)
csv_writer.writerow(header)
for row in data_list:
if row[4] == dept:
row[0] = count
count += 1
csv_writer.writerow(row)