Gurobipy Pandas is our convenient wrapper library to connect pandas with gurobipy. It enables users to efficiently build mathematical optimization models from data stored in DataFrames and Series and extract solutions as pandas objects.

This project 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 modeling, but does not require deep experience with gurobipy.

 

Learning Resources

Webinar: Building Gurobi Models from Pandas Dataframes

As the de-facto standard in Python for data manipulation and analysis, pandas is deeply integrated into many analytics projects and tools. Gurobi’s Python API, gurobipy, does not directly interact with standard pandas data structures, so incorporating decision optimization into data science applications is not as straightforward as it could be. For better interoperability between the two libraries, what is needed is a higher-level syntax to build optimization models directly from suitably structured pandas data.

Our solution is gurobipy-pandas, a convenient wrapper library to connect pandas with gurobipy. Watch this webinar to so how it enables users to efficiently build mathematical optimization models from data stored in DataFrames and Series, and to extract solutions as pandas objects. This webinar will walk through basic concepts and complete modeling examples to demonstrate best practices for using this library.

Watch the webinar, “Building Gurobi Models from Pandas Dataframes.”

 

 

Guidance for Your Journey

30 Day Free Trial for Commercial Users

Start solving your most complex challenges, with the world's fastest, most feature-rich solver.

Always Free for Academics

We make it easy for students, faculty, and researchers to work with mathematical optimization.

Try Gurobi for Free

Choose the evaluation license that fits you best, and start working with our Expert Team for technical guidance and support.

Evaluation License
Get a free, full-featured license of the Gurobi Optimizer to experience the performance, support, benchmarking and tuning services we provide as part of our product offering.
Academic License
Gurobi supports the teaching and use of optimization within academic institutions. We offer free, full-featured copies of Gurobi for use in class, and for research.
Cloud Trial

Request free trial hours, so you can see how quickly and easily a model can be solved on the cloud.

Search

Gurobi Optimization