class pandas.io.formats.style.Styler(data, precision=None, table_styles=None, uuid=None, caption=None, table_attributes=None)
[source]
Helps style a DataFrame or Series according to the data with HTML and CSS.
New in version 0.17.1.
Warning
This is a new feature and is under active development. We’ll be adding features and possibly making breaking changes in future releases.
Parameters: |
data: 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 collisons; generated automatically caption: str, default None caption to attach to the table |
---|
See also
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 genterated HTML.
CSS classes are attached to the generated HTML
index_name
and level<k>
where k
is its level in a MultiIndexrow_heading
row<n>
where n
is the numeric position of the rowlevel<k>
where k
is the level in a MultiIndexcol_heading
* col<n>
where n
is the numeric position of the column * evel<k>
where k
is the level in a MultiIndexblank
data
env | |
template | |
loader |
apply (func[, axis, subset]) | Apply a function column-wise, row-wise, or table-wase, updating the HTML representation with the result. |
applymap (func[, subset]) | Apply a function elementwise, updating the HTML representation with the result. |
background_gradient ([cmap, low, high, axis, ...]) | Color the background in a gradient according to the data in each column (optionally row). |
bar ([subset, axis, color, width, align]) | Color the background color proptional to the values in each column. |
clear () | “Reset” the styler, removing any previously applied styles. |
export () | Export the styles to applied to the current Styler. |
format (formatter[, subset]) | Format the text display value of cells. |
from_custom_template (searchpath, name) | Factory function for creating a subclass of Styler with a custom template and Jinja environment. |
highlight_max ([subset, color, axis]) | Highlight the maximum by shading the background |
highlight_min ([subset, color, axis]) | Highlight the minimum by shading the background |
highlight_null ([null_color]) | Shade the background null_color for missing values. |
render (**kwargs) | Render the built up styles to HTML |
set_caption (caption) | Se the caption on a Styler |
set_precision (precision) | Set the precision used to render. |
set_properties ([subset]) | Convience method for setting one or more non-data dependent properties or each cell. |
set_table_attributes (attributes) | Set the table attributes. |
set_table_styles (table_styles) | Set the table styles on a Styler. |
set_uuid (uuid) | Set the uuid for a Styler. |
to_excel (excel_writer[, sheet_name, na_rep, ...]) | Write Styler to an excel sheet |
use (styles) | Set the styles on the current Styler, possibly using styles from Styler.export . |
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. |
© 2008–2012, AQR Capital Management, LLC, Lambda Foundry, Inc. and PyData Development Team
Licensed under the 3-clause BSD License.
http://pandas.pydata.org/pandas-docs/version/0.22.0/generated/pandas.io.formats.style.Styler.html