Excel Conditional Formatting with Python

Use pandas to apply a color scale conditional formatting rule to a DataFrame. Save to an Excel file and then add a data filter with openpyxl.

Conditional formatting can also be applied using openpyxl instead of using Styler objects, but I prefer to use pandas.