1 import pandas as pd 2 import os 3 4 path = './' 5 read_csv_filename = 'data.csv' 6 data = pd.read_csv(os.path.join(path,read_csv_filename),encoding='gb2312') 7 print(type(data)) 8 print(data) 9 writer_excel=pd.ExcelWriter(f"{path}all_class.xlsx") 10 for classname,subdata in data.groupby('班级'): 11 print(classname) 12 print(subdata) 13 subdata.to_csv(f"{path}{classname}.csv") 14 subdata.to_excel(writer_excel,sheet_name=classname,index=True) 15 writer_excel.save()