Pandas Excel Writer on macOS
Posted: Mon Oct 31, 2022 10:59 pm
Hi everyone
I would like to export data from my GAMS-Model to excel. In the forum I have found the following solution viewtopic.php?f=3&t=11719. But the problem with the mentioned solution is, that it creates an excel file with way too much content. In fact it exports basically everything which in my case is an excel file with around 100 MB and unfortunately my computer can not handle this excel file, I guess its just too big.
So i found another solution which is the Pandas Excel Writer. This seems to be the perfect solution. I managed to export the the different variables to various excel files. But now i have a new problem with the way the data is displayed in excel. As i would like to evaluate the data with pivot tables i need the index of the multidementional variables to be in every single cell - but the Panda Excel Writer combines the cells of the multidimentional variables. And when I disconnect the cells in excel, the value of the cell remains in just one cell which is also not optimal (espacially because the whole excel sheet contains several 100k rows).
I guess the solution could be the option "toExcelArguments" but I'm just not able to get it run. I'm sorry, I'm still a total beginner in programming but i would greatly appreciate any help. It takes me hours and sometimes even days to get the stuff done.
Thanks in advanced
Best regards, Marco
I would like to export data from my GAMS-Model to excel. In the forum I have found the following solution viewtopic.php?f=3&t=11719. But the problem with the mentioned solution is, that it creates an excel file with way too much content. In fact it exports basically everything which in my case is an excel file with around 100 MB and unfortunately my computer can not handle this excel file, I guess its just too big.
So i found another solution which is the Pandas Excel Writer. This seems to be the perfect solution. I managed to export the the different variables to various excel files. But now i have a new problem with the way the data is displayed in excel. As i would like to evaluate the data with pivot tables i need the index of the multidementional variables to be in every single cell - but the Panda Excel Writer combines the cells of the multidimentional variables. And when I disconnect the cells in excel, the value of the cell remains in just one cell which is also not optimal (espacially because the whole excel sheet contains several 100k rows).
I guess the solution could be the option "toExcelArguments" but I'm just not able to get it run. I'm sorry, I'm still a total beginner in programming but i would greatly appreciate any help. It takes me hours and sometimes even days to get the stuff done.
Thanks in advanced
Best regards, Marco