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: Instance of class where null values are highlighted with given style.

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.