With gurobi-logtools, you can extract information from Gurobi log files and generate pandas DataFrames or Excel worksheets for further processing. We also include a plot method which combines the power of interactive dashboards through ipywidgets and plotting functions from plotly.express, making it easy to explore your data and results!

Note

We have renamed the project to gurobi-logtools, so please also adapt the import statement accordingly:

import gurobi_logtools as glt

Installation

python -m pip install gurobi-logtools

It is recommended to prepend the pip install command with python -m to ensure that the package is installed using the correct Python version currently active in your environment.

See CHANGELOG for added, removed, or fixed functionality.

Usage and tutorial

First, you need a set of Gurobi log files to compare, e.g.,

• results from several model instances
• comparisons of different parameter settings
• performance variability experiments involving multiple random seed runs
• ...

For a description of the plotting dashboard, please see the following link: Gurobi-logtools plotting dashboard

We provide a TUTORIAL in the form of a gurobi-logtools.ipynb notebook with the example data set to get started. Additionally, there is a Gurobi TechTalk demonstrating how to use it (YouTube), but please note it presents a version of gurobi-logtools that is several years old (but the big ideas remain the same):

Pandas/Plotly

1. Parse log files:

   import gurobi_logtools as glt
   
   results = glt.parse(["run1/*.log", "run2/*.log"])
   summary = results.summary()
   nodelog_progress = results.progress("nodelog")

   Depending on your requirements, you may need to filter or modify the resulting DataFrames.

2. Draw interactive charts, preferably in a Jupyter Notebook:

   • final results from the individual runs:

   glt.plot(summary)

   • progress charts for the individual runs:

   glt.plot(nodelog_progress, x="Time", y="Gap", color="Log", type="line")

   • progress of the norel heuristic (note, the time recorded here is since the start of norel, and does not include presolve + read time):

   glt.plot(results.progress("norel"), x="Time", y="Incumbent", color="Log", type="line")

   These are just examples using the Plotly Python library - of course, any other plotting library of your choice can be used to work with these DataFrames.

Other top-level functions

• glt.register_custom_palette(name, colors): Use this function to add custom palettes to the "Custom" group in the palette type field. The arguments should be a string and a list/tuple of hex strings, respectively.

• glt.reset_custom_palettes(): clears all custom palettes added

• glt.show_palettes(): displays a colorful guide to Plotly's built-in palettes

• glt.get_plotly_fig(): use this function to access the underlying Plotly figure. You can use this figure object to perform detailed customizations via the Figure.update_layout, Figure.update_traces, Figure.update_xaxes, and Figure.update_yaxes functions.

• glt.save_plot(filepath): use this function to save the plot to a range of formats, including PNG, SVG, PDF, and HTML. The filetype is inferred from the extension of the filepath. Note that additional packages may need to be installed depending on the filetype.

Excel

Convert your log files to Excel worksheets right on the command line:

python -m gurobi_logtools myrun.xlsx data/*.log

List all available options and how to use the command-line tool:

python -m gurobi_logtools --help

Rename log files

The command line tool can also rename log files according to the parameters set and model solved in a given run. This is useful if your log files do not have a consistent naming scheme, or if multiple runs are logged per file and you want to extract the individual runs.

For example:

python -m gurobi_logtools --write-to-dir nicenames summary.xlsx tests/assets/combined/*.log

Separates logs for individual runs in the input files and writes copies to the 'nicenames' folder with a consistent naming scheme.