Skip to main content

Python package to translate between gdx (GAMS data) and pandas.

Project description

gdx-pandas: Python package to translate between gdx (GAMS data) and pandas.

There are two main ways to use gdxpds. The first use case is the one that was initially supported: direct conversion between GDX files on disk and pandas DataFrames or a csv version thereof. Starting with the Version 1.0.0 rewrite, there is now a second style of use which involves interfacing with GDX files and symbols via the gdxpds.gdx.GdxFile and gdxpds.gdx.GdxSymbol classes.

Please visit https://nrel.github.io/gdx-pandas for the latest documentation.

DEPENDENCIES

  • Python 3.4 or 3.6 (gdx-pandas support for Python 2.X has been discontinued; GAMS does not yet support Python 3.7)

  • pandas (In general you will want the SciPy stack. Anaconda comes with it, or see [my notes for Windows](https://elainethale.wordpress.com/programming-notes/python-environment-set-up/).)

  • For Python versions < 3.4, enum34. Also uninstall the enum package if it is installed.

  • Install [GAMS](https://www.gams.com/download/)

  • Put the GAMS directory in your PATH and/or assign it to the GAMS_DIR environment variable

  • GAMS Python bindings
    • See GAMS/win64/XX.X/apifiles/readme.txt on Windows, GAMS/gamsXX.X_osx_x64_64_sfx/apifiles/readme.txt on Mac, or /opt/gams/gamsXX.X_linux_x64_64_sfx/apifiles/readme.txt on Linux

    • Run the following for the correct version of the Python bindings

      `bash python setup.py install `

      or

      `bash python setup.py build --build-base=/path/to/somwhere/you/have/write/access install `

      with the latter being for the case when you can install packages into Python but don’t have GAMS directory write access.

    • For Python 3.X, use …/apifiles/Python/api_XX/setup.py. For Python 3.X in particular you will need GAMS version >= 24.5.1 (Python 3.4, Windows and Linux), 24.7.4 (Python 3.4, Mac OS X), or >= 24.8.4 (Python 3.6)

TESTING

After installation, you can test the package using pytest:

pytest –pyargs gdxpds

If the tests fail due to permission IOErrors, apply chmod g+x and chmod a+x to the gdx-pandas/gdxpds/test folder.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for gdxpds, version 1.2.0
Filename, size File type Python version Upload date Hashes
Filename, size gdxpds-1.2.0.tar.gz (642.7 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page