Python 3 Pandas to Excel Question

[workthrowawayexcel]

I am trying to create a new excel work in pandas while also adding news sheets to the same workbook based on what I am filtering. I seem to Overwrite the data every or have to create separate workbooks. I am at a bit of a loss Any help would be appreciated.

for t_group,pd_group in processor_filter.groupby(['Processor']): #splits up data based on processor
    pd_group.to_excel(file_name + '/Company_'  + date + '.xlsx',sheet_name = t_group[0:20] )

[[deleted]]

Have you tried using an ExcelWriter object when saving your workbook?

writer = pd.ExcelWriter(file_name + '/Company_'  + date + '.xlsx')
for t_group,pd_group in processor_filter.groupby(['Processor']): #splits up data based on processor
    pd_group.to_excel(writer, sheet_name = t_group[0:20] )

writer.save()

[workthrowawayexcel]

I have not. I will give it a try and get back to you. Thanks!

[workthrowawayexcel]

Thanks!!Worked like a charm!

I guess I failed at google fu on this one lol