'Put multiple pandas dataframes into one excel sheet in grid format
So, I have one very large Dataframe that is composed of over 70 smaller dataframes, of ten rows each. I want to use xlsxwriter to write them into an excel sheet; however, I want the dataframes to be displayed in a grid format, so that they do not simply place going east to west or north to south. My desired output is shown below.
Solution 1:[1]
Just use the startcol and startrow from DataFrame.to_excel
Use df.shape to get the desired col/row position. Allocate space for the headers
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Zaero Divide |