pandas.io.formats.style.Styler

class pandas.io.formats.style.Styler(data, precision=None, table_styles=None, uuid=None, caption=None, table_attributes=None, cell_ids=True, na_rep=None, uuid_len=5, decimal='.', thousands=None, escape=None)[source]

Helps style a DataFrame or Series according to the data with HTML and CSS.

Parameters

data:Series or DataFrame

Data to be styled - either a Series or DataFrame.

precision:int

Precision to round floats to, defaults to pd.options.display.precision.

table_styles:list-like, default None

List of {selector: (attr, value)} dicts; see Notes.

uuid:str, default None

A unique identifier to avoid CSS collisions; generated automatically.

caption:str, tuple, default None

String caption to attach to the table. Tuple only used for LaTeX dual captions.

table_attributes:str, default None

Items that show up in the opening <table> tag in addition to automatic (by default) id.

cell_ids:bool, default True

If True, each cell will have an id attribute in their HTML tag. The id takes the form T_<uuid>_row<num_row>_col<num_col> where <uuid> is the unique identifier, <num_row> is the row number and <num_col> is the column number.

na_rep:str, optional

Representation for missing values. If na_rep is None, no special formatting is applied.

New in version 1.0.0.

uuid_len:int, default 5

If uuid is not specified, the length of the uuid to randomly generate expressed in hex characters, in range [0, 32].

New in version 1.2.0.

decimal:str, default “.”

Character used as decimal separator for floats, complex and integers

New in version 1.3.0.

thousands:str, optional, default None

Character used as thousands separator for floats, complex and integers

New in version 1.3.0.

escape:str, optional

Use ‘html’ to replace the characters &, <, >, ', and " in cell display string with HTML-safe sequences. Use ‘latex’ to replace the characters &, %, $, #, _, {, }, ~, ^, and \ in the cell display string with LaTeX-safe sequences.

New in version 1.3.0.

See also

DataFrame.style

Return a Styler object containing methods for building a styled HTML representation for the DataFrame.

Notes

Most styling will be done by passing style functions into Styler.apply or Styler.applymap. Style functions should return values with strings containing CSS 'attr: value' that will be applied to the indicated cells.

If using in the Jupyter notebook, Styler has defined a _repr_html_ to automatically render itself. Otherwise call Styler.render to get the generated HTML.

CSS classes are attached to the generated HTML

• Index and Column names include index_name and level<k> where k is its level in a MultiIndex

• Index label cells include

  • row_heading

  • row<n> where n is the numeric position of the row

  • level<k> where k is the level in a MultiIndex

• Column label cells include * col_heading * col<n> where n is the numeric position of the column * level<k> where k is the level in a MultiIndex

• Blank cells include blank

• Data cells include data

Attributes

env	(Jinja2 jinja2.Environment)
template	(Jinja2 Template)
loader	(Jinja2 Loader)

Methods

apply(func[, axis, subset])	Apply a CSS-styling function column-wise, row-wise, or table-wise.
applymap(func[, subset])	Apply a CSS-styling function elementwise.
background_gradient([cmap, low, high, axis, ...])	Color the background in a gradient style.
bar([subset, axis, color, width, align, ...])	Draw bar chart in the cell backgrounds.
clear()	Reset the Styler, removing any previously applied styles.
export()	Export the styles applied to the current Styler.
format([formatter, subset, na_rep, ...])	Format the text display value of cells.
from_custom_template(searchpath[, ...])	Factory function for creating a subclass of Styler.
hide_columns([subset])	Hide the column headers or specific keys in the columns from rendering.
hide_index([subset])	Hide the entire index, or specific keys in the index from rendering.
highlight_between([subset, color, axis, ...])	Highlight a defined range with a style.
highlight_max([subset, color, axis, props])	Highlight the maximum with a style.
highlight_min([subset, color, axis, props])	Highlight the minimum with a style.
highlight_null([null_color, subset, props])	Highlight missing values with a style.
highlight_quantile([subset, color, axis, ...])	Highlight values defined by a quantile with a style.
pipe(func, *args, **kwargs)	Apply func(self, *args, **kwargs), and return the result.
render([sparse_index, sparse_columns])	Render the Styler including all applied styles to HTML.
set_caption(caption)	Set the text added to a <caption> HTML element.
set_na_rep(na_rep)	(DEPRECATED) Set the missing data representation on a Styler.
set_precision(precision)	(DEPRECATED) Set the precision used to display values.
set_properties([subset])	Set defined CSS-properties to each <td> HTML element within the given subset.
set_sticky([axis, pixel_size, levels])	Add CSS to permanently display the index or column headers in a scrolling frame.
set_table_attributes(attributes)	Set the table attributes added to the <table> HTML element.
set_table_styles(table_styles[, axis, overwrite])	Set the table styles included within the <style> HTML element.
set_td_classes(classes)	Set the DataFrame of strings added to the class attribute of <td> HTML elements.
set_tooltips(ttips[, props, css_class])	Set the DataFrame of strings on Styler generating :hover tooltips.
set_uuid(uuid)	Set the uuid applied to id attributes of HTML elements.
text_gradient([cmap, low, high, axis, ...])	Color the text in a gradient style.
to_excel(excel_writer[, sheet_name, na_rep, ...])	Write Styler to an Excel sheet.
to_html([buf, table_uuid, table_attributes, ...])	Write Styler to a file, buffer or string in HTML-CSS format.
to_latex([buf, column_format, position, ...])	Write Styler to a file, buffer or string in LaTeX format.
use(styles)	Set the styles on the current Styler.
where(cond, value[, other, subset])	(DEPRECATED) Apply CSS-styles based on a conditional function elementwise.