pandas.io.formats.style.Styler.highlight_null — pandas 2.3.3 documentation (original) (raw)

Styler.highlight_null(color='red', subset=None, props=None)[source]#

Highlight missing values with a style.

Parameters:

colorstr, default ‘red’

Background color to use for highlighting.

subsetlabel, array-like, IndexSlice, optional

A valid 2d input to DataFrame.loc[], or, in the case of a 1d input or single key, to DataFrame.loc[:, ] where the columns are prioritised, to limit data to before applying the function.

propsstr, default None

CSS properties to use for highlighting. If props is given, coloris not used.

Returns:

Styler

Examples

df = pd.DataFrame({'A': [1, 2], 'B': [3, np.nan]}) df.style.highlight_null(color='yellow')

Please see:Table Visualization for more examples.