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(self, func[, axis, subset]) |
Apply a function column-wise, row-wise, or table-wise, updating the HTML representation with the result. |
Styler.applymap(self, func[, subset]) |
Apply a function elementwise, updating the HTML representation with the result. |
Styler.where(self, 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(self, formatter[, subset]) |
Format the text display value of cells. |
Styler.set_precision(self, precision) |
Set the precision used to render. |
Styler.set_table_styles(self, table_styles) |
Set the table styles on a Styler. |
Styler.set_table_attributes(self, attributes) |
Set the table attributes. |
Styler.set_caption(self, caption) |
Set the caption on a Styler |
Styler.set_properties(self[, subset]) |
Convenience method for setting one or more non-data dependent properties or each cell. |
Styler.set_uuid(self, uuid) |
Set the uuid for a Styler. |
Styler.clear(self) |
Reset the styler, removing any previously applied styles. |
Styler.pipe(self, func, \*args, \*\*kwargs) |
Apply func(self, *args, **kwargs), and return the result. |
Builtin styles¶
Styler.highlight_max(self[, subset, color, axis]) |
Highlight the maximum by shading the background. |
Styler.highlight_min(self[, subset, color, axis]) |
Highlight the minimum by shading the background. |
Styler.highlight_null(self[, null_color]) |
Shade the background null_color for missing values. |
Styler.background_gradient(self[, cmap, …]) |
Color the background in a gradient according to the data in each column (optionally row). |
Styler.bar(self[, subset, axis, color, …]) |
Draw bar chart in the cell backgrounds. |
Style export and import¶
Styler.render(self, \*\*kwargs) |
Render the built up styles to HTML. |
Styler.export(self) |
Export the styles to applied to the current Styler. |
Styler.use(self, styles) |
Set the styles on the current Styler, possibly using styles from Styler.export. |
Styler.to_excel(self, excel_writer[, …]) |
Write Styler to an Excel sheet. |