gdx-pandas icon indicating copy to clipboard operation
gdx-pandas copied to clipboard

gdxpds.to_gdx changing dataframe order

Open DIUANA opened this issue 5 years ago • 1 comments

Hi all I hope you are all fine and sage.

I am facing an issue when generating a gdx file with gdxpds.to_gdx function.

I am passing a dictionary with 198 keys and when generating the gdx it is modifyig the order of some sets.

For instance I am providing a dataframe such as this one:

2008 True 2010 True 2015 True 2020 True

And the gdx output is:

2010 Y 2015 Y 2020 Y 2008 Y

It makes difference for the current model I am working on.

Is there any way to keep the passed order when generating the gdx file with gdxpds.to_gdx?

Thanks in advance

Version info: Python 3.7 GAMS 24.7.4 GAMS 29.1 gdxpds 1.1.0

Edit: I have also tried to implement the backend conversion but it provided me the same output issues.

DIUANA avatar Jul 28 '20 03:07 DIUANA

Can you provide a minimum example?

EDIT: I am guessing that this is due to the UEL being constructed from sets in a particular order.

jebob avatar Oct 30 '20 16:10 jebob