pandas.io.formats.style.Styler.highlight_null#
- 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.
Added in version 1.5.0.
- subsetlabel, array-like, IndexSlice, optional
A valid 2d input to DataFrame.loc[<subset>], or, in the case of a 1d input or single key, to DataFrame.loc[:, <subset>] 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,color
is not used.Added in version 1.3.0.
- Returns:
- Styler
See also
Styler.highlight_max
Highlight the maximum with a style.
Styler.highlight_min
Highlight the minimum with a style.
Styler.highlight_between
Highlight a defined range with a style.
Styler.highlight_quantile
Highlight values defined by a quantile with a style.
Examples
>>> df = pd.DataFrame({'A': [1, 2], 'B': [3, np.nan]}) >>> df.style.highlight_null(color='yellow')
Please see: Table Visualization for more examples.