Highlight the nan values in Pandas Dataframe

In this article, we will discuss how to highlight the NaN (Not a number) values in Pandas Dataframe. NaN values used to represent NULL values and sometimes it is the result of the mathematical overflow.
Lets first make a dataframe:
 

Output: 
 

Now, come to the highlighting part. Our objective is to highlight those cells which have Nan values.
 

Method 1: Highlighting Cell with nan values

We can do this by using the highlight_null() method of DataFrame.style property.This is a property that returns a Styler object, which has useful methods for formatting and displaying DataFrames. highlight_null() method requires one string parameter (the name of the colour with which you want to highlight the cell). 

Example: 

Output: 
 

Method 2: Highlighting text with nan values instead of background

We can do this by using applymap() method of the style property. applymap() method requires a function that takes a scalar and returns a scalar.
Example:

Output: 
 

Method 3: Highlighting the text of the complete row with nan values

We can do this using the apply() method 
Example:

Output: 
 

Method 4: Highlighting the complete row with nan values

Output: 
 

Solution 5: Highlighting the whole column with nan values

Output: