Python | Pandas Index.notna()
Last Updated :
05 Jun, 2022
Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier.
Pandas Index.notna() function Detect existing (non-missing) values. Return a boolean same-sized object indicating if the values are not NA. Non-missing values get mapped to True. Characters such as empty strings ” or numpy.inf are not considered NA values (unless you set pandas.options.mode.use_inf_as_na = True). NA values, such as None or numpy.NaN, get mapped to False values.
Syntax: Index.notna()
Parameters : Doesn’t take any parameter.
Returns : numpy.ndarray: Boolean array to indicate which entries are not NA.
Example #1: Use Index.notna() function to find all non-missing values in Index.
Python3
import pandas as pd
idx = pd.Index([ 'Labrador' , None , 'Beagle' , 'Mastiff' ,
'Lhasa' , None , 'Husky' , 'Beagle' ])
idx
|
Output :
Now we check for the non-missing values in the Index.
Output :
The function returned an array object having the same size as that of the index. True value means the index label is not missing and False value means the index label are missing.
Example #2: Use Index.notna() function to check for the non-missing label in the Datetime Index.
Python3
import pandas as pd
idx = pd.DatetimeIndex([pd.Timestamp( '2015-02-11' ),
None , pd.Timestamp(''), pd.NaT])
idx
|
Output :
Now we will check if the labels in the Datetime Index are present or missing.
Output :
As we can see in the output, the function has returned an array object having the same size as that of the Datetime Index. True value means the index label are not missing and False value means the index label are missing.
Share your thoughts in the comments
Please Login to comment...