[](https://pypi.org/project/gurobipy-pandas)
[](https://pypi.org/project/gurobipy-pandas)
[](https://github.com/Gurobi/gurobipy-pandas/actions/workflows/main.yml?query=branch%3Amain++)
[](https://gurobipy-pandas.readthedocs.io/en/stable/)
# gurobipy-pandas: Convenience wrapper for building optimization models from pandas data
`gurobipy-pandas` is a convenient (optional) wrapper to connect pandas with gurobipy. It enables users to more easily and efficiently build mathematical optimization models from data stored in DataFrames and Series, and to read solutions back directly as pandas objects.
`gurobipy-pandas` is aimed at experienced pandas users who are familiar with methods to transform, group, and aggregate data stored in dataframes. It expects some familiarity with optimization modelling, but does not require deep experience with gurobipy.
## Features
`gurobipy-pandas` allows users to:
- create gurobipy variables tied to the index of a series or dataframe
- construct constraints row-wise using algebraic expressions
- read model solutions and constraint slacks natively as pandas series
## Installation
```console
pip install gurobipy-pandas
```
## Dependencies
- [gurobipy: Python modelling interface for the Gurobi Optimizer](https://pypi.org/project/gurobipy/)
- [pandas: powerful Python data analysis toolkit](https://pypi.org/project/pandas/)
## Documentation
Full documentation for `gurobipy-pandas` is hosted on [readthedocs](https://gurobipy-pandas.readthedocs.io/en/stable/).
## License
`gurobipy-pandas` is distributed under the terms of the [Apache License 2.0](https://spdx.org/licenses/Apache-2.0.html).
## Contact Us
For questions related to using gurobipy-pandas please use the [Gurobi Community Forum](https://support.gurobi.com/hc/en-us/community/topics/10373864542609-GitHub-Projects>).
For reporting bugs, issues and feature requests, specific to `gurobipy-pandas`, please [open an issue](https://github.com/Gurobi/gurobipy-pandas/issues).
If you encounter issues with Gurobi or `gurobipy` please contact [Gurobi Support](https://support.gurobi.com/hc/en-us).
## Contributors
- Simon Bowly (maintainer)
- Robert Luce (maintainer)
- [Irv Lustig](https://github.com/Dr-Irv) [Princeton Consultants](http://www.princetonoptimization.com)
- [Robert Randall](https://github.com/rrandall1471) [Princeton Consultants](http://www.princetonoptimization.com)
## Webinar
Slides for the 2023 webinars presenting this package can be found at [webinar/webinar.ipynb](https://github.com/Gurobi/gurobipy-pandas/blob/main/webinar/webinar.ipynb). The notebook will be presented as RISE slides, but can also be executed in Jupyter.
Raw data
{
"_id": null,
"home_page": null,
"name": "gurobipy-pandas",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.8",
"maintainer_email": null,
"keywords": "gurobipy, optimization, pandas",
"author": null,
"author_email": "Simon Bowly <bowly@gurobi.com>, Robert Luce <luce@gurobi.com>",
"download_url": "https://files.pythonhosted.org/packages/0b/24/fcdf0a7184deb73f284ece8ba9f3f199fc16c6424db394ca887d66c1b0b5/gurobipy_pandas-1.2.0.tar.gz",
"platform": null,
"description": "[](https://pypi.org/project/gurobipy-pandas)\n[](https://pypi.org/project/gurobipy-pandas)\n[](https://github.com/Gurobi/gurobipy-pandas/actions/workflows/main.yml?query=branch%3Amain++)\n[](https://gurobipy-pandas.readthedocs.io/en/stable/)\n\n# gurobipy-pandas: Convenience wrapper for building optimization models from pandas data\n\n`gurobipy-pandas` is a convenient (optional) wrapper to connect pandas with gurobipy. It enables users to more easily and efficiently build mathematical optimization models from data stored in DataFrames and Series, and to read solutions back directly as pandas objects.\n\n`gurobipy-pandas` is aimed at experienced pandas users who are familiar with methods to transform, group, and aggregate data stored in dataframes. It expects some familiarity with optimization modelling, but does not require deep experience with gurobipy.\n\n## Features\n\n`gurobipy-pandas` allows users to:\n\n- create gurobipy variables tied to the index of a series or dataframe\n- construct constraints row-wise using algebraic expressions\n- read model solutions and constraint slacks natively as pandas series\n\n## Installation\n\n```console\npip install gurobipy-pandas\n```\n\n## Dependencies\n\n- [gurobipy: Python modelling interface for the Gurobi Optimizer](https://pypi.org/project/gurobipy/)\n- [pandas: powerful Python data analysis toolkit](https://pypi.org/project/pandas/)\n\n## Documentation\n\nFull documentation for `gurobipy-pandas` is hosted on [readthedocs](https://gurobipy-pandas.readthedocs.io/en/stable/).\n\n## License\n\n`gurobipy-pandas` is distributed under the terms of the [Apache License 2.0](https://spdx.org/licenses/Apache-2.0.html).\n\n## Contact Us\n\nFor questions related to using gurobipy-pandas please use the [Gurobi Community Forum](https://support.gurobi.com/hc/en-us/community/topics/10373864542609-GitHub-Projects>).\n\nFor reporting bugs, issues and feature requests, specific to `gurobipy-pandas`, please [open an issue](https://github.com/Gurobi/gurobipy-pandas/issues).\n\nIf you encounter issues with Gurobi or `gurobipy` please contact [Gurobi Support](https://support.gurobi.com/hc/en-us).\n\n## Contributors\n\n- Simon Bowly (maintainer)\n- Robert Luce (maintainer)\n- [Irv Lustig](https://github.com/Dr-Irv) [Princeton Consultants](http://www.princetonoptimization.com)\n- [Robert Randall](https://github.com/rrandall1471) [Princeton Consultants](http://www.princetonoptimization.com)\n\n## Webinar\n\nSlides for the 2023 webinars presenting this package can be found at [webinar/webinar.ipynb](https://github.com/Gurobi/gurobipy-pandas/blob/main/webinar/webinar.ipynb). The notebook will be presented as RISE slides, but can also be executed in Jupyter.\n",
"bugtrack_url": null,
"license": "Apache-2.0",
"summary": "Pandas accessors for gurobipy interaction",
"version": "1.2.0",
"project_urls": {
"Documentation": "https://gurobi-optimization-gurobipy-pandas.readthedocs-hosted.com/en/latest",
"Issues": "https://github.com/Gurobi/gurobipy-pandas/issues",
"Source": "https://github.com/Gurobi/gurobipy-pandas"
},
"split_keywords": [
"gurobipy",
" optimization",
" pandas"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "efc0a02be9bfea9e76d48ef969002e61d47c1ce5dbe2870e1fdc448e77881f15",
"md5": "7853d4315c2a24096a99e4946e75d905",
"sha256": "deaae3605cd53ab4a7274693778cc49d35ed704fc469d81c20055a7a5b3448cc"
},
"downloads": -1,
"filename": "gurobipy_pandas-1.2.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "7853d4315c2a24096a99e4946e75d905",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.8",
"size": 19786,
"upload_time": "2024-11-15T03:38:53",
"upload_time_iso_8601": "2024-11-15T03:38:53.116834Z",
"url": "https://files.pythonhosted.org/packages/ef/c0/a02be9bfea9e76d48ef969002e61d47c1ce5dbe2870e1fdc448e77881f15/gurobipy_pandas-1.2.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "0b24fcdf0a7184deb73f284ece8ba9f3f199fc16c6424db394ca887d66c1b0b5",
"md5": "94942f86263abe6c4ec8373b0b611eaa",
"sha256": "3630986045b39bc6f7cc532dda1bbcc800e5bb19240640162890b38899b06dd3"
},
"downloads": -1,
"filename": "gurobipy_pandas-1.2.0.tar.gz",
"has_sig": false,
"md5_digest": "94942f86263abe6c4ec8373b0b611eaa",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8",
"size": 212934,
"upload_time": "2024-11-15T03:38:55",
"upload_time_iso_8601": "2024-11-15T03:38:55.105534Z",
"url": "https://files.pythonhosted.org/packages/0b/24/fcdf0a7184deb73f284ece8ba9f3f199fc16c6424db394ca887d66c1b0b5/gurobipy_pandas-1.2.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-11-15 03:38:55",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "Gurobi",
"github_project": "gurobipy-pandas",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"tox": true,
"lcname": "gurobipy-pandas"
}
JSON
