Cookie Settings
Open-Source Projects

Gurobipy Pandas


Efficiently build mathematical optimization models from data stored in DataFrames and Series.

 

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.