# 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)

  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.