If not given uses Styler’s initially assigned value.
HTML element in the format:
<table .. <table_attributes> >
If not given defaults to Styler’s preexisting value.
sparse_indexbool, optional
Whether to sparsify the display of a hierarchical index. Setting to False will display each explicit level element in a hierarchical key for each row. Defaults to pandas.options.styler.sparse.index
value.
Added in version 1.4.0.
sparse_columnsbool, optional
Whether to sparsify the display of a hierarchical index. Setting to False will display each explicit level element in a hierarchical key for each column. Defaults to pandas.options.styler.sparse.columns
value.
Added in version 1.4.0.
bold_headersbool, optional
Adds “font-weight: bold;” as a CSS property to table style header cells.
Added in version 1.4.0.
captionstr, optional
Set, or overwrite, the caption on Styler before rendering.
Added in version 1.4.0.
max_rowsint, optional
The maximum number of rows that will be rendered. Defaults topandas.options.styler.render.max_rows/max_columns
.
Added in version 1.4.0.
max_columnsint, optional
The maximum number of columns that will be rendered. Defaults topandas.options.styler.render.max_columns
, which is None.
Rows and columns may be reduced if the number of total elements is large. This value is set to pandas.options.styler.render.max_elements
, which is 262144 (18 bit browser rendering).
Added in version 1.4.0.
encodingstr, optional
Character encoding setting for file output (and meta tags if available). Defaults to pandas.options.styler.render.encoding
value of “utf-8”.
doctype_htmlbool, default False
Whether to output a fully structured HTML file including all HTML elements, or just the core <style>
and <table>
elements.
exclude_stylesbool, default False
Whether to include the <style>
element and all associated elementclass
and id
identifiers, or solely the <table>
element without styling identifiers.
**kwargs
Any additional keyword arguments are passed through to the jinja2self.template.render
process. This is useful when you need to provide additional variables for a custom template.
Returns:
str or None
If buf is None, returns the result as a string. Otherwise returns None.
See also
DataFrame.to_html
Write a DataFrame to a file, buffer or string in HTML format.
Examples
df = pd.DataFrame({'A': [1, 2], 'B': [3, 4]})
print(df.style.to_html())