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. |
© 2008–2012, AQR Capital Management, LLC, Lambda Foundry, Inc. and PyData Development Team
Licensed under the 3-clause BSD License.
https://pandas.pydata.org/pandas-docs/version/0.24.2/reference/style.html