pandas.io.formats.style.Styler.set_sticky — pandas 2.2.3 documentation (original) (raw)

Styler.set_sticky(axis=0, pixel_size=None, levels=None)[source]#

Add CSS to permanently display the index or column headers in a scrolling frame.

Parameters:

axis{0 or ‘index’, 1 or ‘columns’}, default 0

Whether to make the index or column headers sticky.

pixel_sizeint, optional

Required to configure the width of index cells or the height of column header cells when sticking a MultiIndex (or with a named Index). Defaults to 75 and 25 respectively.

levelsint, str, list, optional

If axis is a MultiIndex the specific levels to stick. If None will stick all levels.

Returns:

Styler

Notes

This method uses the CSS ‘position: sticky;’ property to display. It is designed to work with visible axes, therefore both:

• styler.set_sticky(axis=”index”).hide(axis=”index”)
• styler.set_sticky(axis=”columns”).hide(axis=”columns”)

may produce strange behaviour due to CSS controls with missing elements.

Examples

df = pd.DataFrame({'A': [1, 2], 'B': [3, 4]}) df.style.set_sticky(axis="index")

Please see:Table Visualization for more examples.