python 用pandas库来从csv 文件读取数据，保存数据到 csv 文件 excel文件 DataFrame 分组 df.groupby()

python 用pandas库来从csv 文件读取数据，保存数据到 csv 文件 excel文件 DataFrame 分组 df.groupby()

import pandas as pd
import os

path  = './'
read_csv_filename = 'data.csv'
data = pd.read_csv(os.path.join(path,read_csv_filename),encoding='gb2312')
print(type(data))
print(data)
writer_excel=pd.ExcelWriter(f"{path}all_class.xlsx")  
for classname,subdata in data.groupby('班级'):
    print(classname)
    print(subdata)
    subdata.to_csv(f"{path}{classname}.csv")
    subdata.to_excel(writer_excel,sheet_name=classname,index=True)
writer_excel.save()