import pandas as pd
df = pd.read_table(read_file, header=0, dtype=str, sep='\t')
res_file = fileDir + r'\filename.xlsx'
writer = pd.ExcelWriter(res_file)
groupby_df = df.groupby(['colname'])
for i in groupby_df:
i[1].to_excel(writer, index=False, sheet_name=i[0])
writer.save()
pandas中利用groupby分组导入数据到excel中
最新推荐文章于 2024-07-15 20:03:26 发布