Wednesday, September 24, 2014

GAMS to Python

When we need to export data from GAMS to Python for further processing, I often use SQLite as intermediate storage. It is very easy to load data from SQLite into a Pandas dataframe:

 image

The text_factory thing may help with Unicode issues.

Compare this to reading the same data into R:

image

For more info about doing data stuff in Python see:

image