I need to write sheets to excel file(some of them are existing, but others no)
I use df.groupby('mail').apply(lambda g: g.to_excel(str(g.name) + '.xlsx'), 'sheet1')
I group data from exel file and want to divide it to a lot of little with different mail. I still have 3 df and I want to group it with mail and also add to others sheet to files.
How can I do it to 50 mail at the same time without overwriting?
Asked
Active
Viewed 71 times
2
Arseniy Krupenin
- 3,800
- 3
- 13
- 18
-
you may want to check [this question and answer](http://stackoverflow.com/questions/36447758/writing-pandas-data-frame-to-existing-workbook/36450435#36450435) – MaxU - stand with Ukraine Jun 22 '16 at 09:55
-
@MaxU, but if I have a lot of file? how can i do this? – Arseniy Krupenin Jun 22 '16 at 10:04