# Style

`Styler` objects are returned by `pandas.DataFrame.style`.

## Styler constructor

`Styler`(data[, precision, table_styles, …]) | Helps style a DataFrame or Series according to the data with HTML and CSS.
`Styler.from_custom_template`(searchpath, name) | Factory function for creating a subclass of `Styler` with a custom template and Jinja environment.

## Styler properties

`Styler.env` |
`Styler.template` |
`Styler.loader` |

## Style application

`Styler.apply`(func[, axis, subset]) | Apply a function column-wise, row-wise, or table-wise, updating the HTML representation with the result.
`Styler.applymap`(func[, subset]) | Apply a function elementwise, updating the HTML representation with the result.
`Styler.where`(cond, value[, other, subset]) | Apply a function elementwise, updating the HTML representation with a style which is selected in accordance with the return value of a function.
`Styler.format`(formatter[, subset]) | Format the text display value of cells.
`Styler.set_precision`(precision) | Set the precision used to render.
`Styler.set_table_styles`(table_styles) | Set the table styles on a Styler.
`Styler.set_table_attributes`(attributes) | Set the table attributes.
`Styler.set_caption`(caption) | Set the caption on a Styler
`Styler.set_properties`([subset]) | Convenience method for setting one or more non-data dependent properties or each cell.
`Styler.set_uuid`(uuid) | Set the uuid for a Styler.
`Styler.clear`() | Reset the styler, removing any previously applied styles.
`Styler.pipe`(func, *args, **kwargs) | Apply `func(self, *args, **kwargs)`, and return the result.

## Builtin styles

`Styler.highlight_max`([subset, color, axis]) | Highlight the maximum by shading the background.
`Styler.highlight_min`([subset, color, axis]) | Highlight the minimum by shading the background.
`Styler.highlight_null`([null_color]) | Shade the background `null_color` for missing values.
`Styler.background_gradient`([cmap, low, …]) | Color the background in a gradient according to the data in each column (optionally row).
`Styler.bar`([subset, axis, color, width, …]) | Draw bar chart in the cell backgrounds.

## Style export and import

`Styler.render`(**kwargs) | Render the built up styles to HTML.
`Styler.export`() | Export the styles to applied to the current Styler.
`Styler.use`(styles) | Set the styles on the current Styler, possibly using styles from `Styler.export`.
`Styler.to_excel`(excel_writer[, sheet_name, …]) | Write Styler to an Excel sheet.

Scroll To Top