pandas.io.formats.style.Styler.highlight_null — pandas 3.0.0rc0+33.g1fd184de2a 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

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