python 用pandas库来从csv 文件读取数据，保存数据到 csv 文件 excel文件 DataFrame 分组 df.groupby()
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()
原创文章，作者：ItWorker，如若转载，请注明出处：https://blog.ytso.com/tech/pnotes/280525.html