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.

Style application

Styler.apply(func[, axis, subset])

Apply a function column-wise, row-wise, or table-wise.

Styler.applymap(func[, subset])

Apply a function elementwise.

Styler.where(cond, value[, other, subset])

Apply a function elementwise.

Styler.format(formatter[, subset, na_rep])

Format the text display value of cells.

Styler.set_precision(precision)

Set the precision used to render.

Styler.set_td_classes(classes)

Add string based CSS class names to data cells that will appear within the Styler HTML result.

Styler.set_table_styles(table_styles[, …])

Set the table styles on a Styler.

Styler.set_table_attributes(attributes)

Set the table attributes.

Styler.set_tooltips(ttips)

Add string based tooltips that will appear in the Styler HTML result.

Styler.set_tooltips_class([name, properties])

Manually configure the name and/or properties of the class for creating tooltips on hover.

Styler.set_caption(caption)

Set the caption on a Styler.

Styler.set_properties([subset])

Method to set one or more non-data dependent properties or each cell.

Styler.set_uuid(uuid)

Set the uuid for a Styler.

Styler.set_na_rep(na_rep)

Set the missing data representation on 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, subset])

Shade the background null_color for missing values.

Styler.background_gradient([cmap, low, …])

Color the background in a gradient style.

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.

Styler.to_excel(excel_writer[, sheet_name, …])

Write Styler to an Excel sheet.