notna(self) -> 'DataFrame'

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.

Returns

DataFrame

Mask of bool values for each element in DataFrame that indicates whether an element is not an NA value.

Detect existing (non-missing) values.

See Also

DataFrame.dropna

Omit axes labels with missing values.

DataFrame.isna

Boolean inverse of notna.

DataFrame.notnull

Alias of notna.

notna

Top-level notna.

Examples

Show which entries in a DataFrame are not NA.

This example is valid syntax, but we were not able to check execution

>>> df = pd.DataFrame(dict(age=[5, 6, np.NaN],
...                    born=[pd.NaT, pd.Timestamp('1939-05-27'),
...                          pd.Timestamp('1940-04-25')],
...                    name=['Alfred', 'Batman', ''],
...                    toy=[None, 'Batmobile', 'Joker']))
... df
   age       born    name        toy
0  5.0        NaT  Alfred       None
1  6.0 1939-05-27  Batman  Batmobile
2  NaN 1940-04-25              Joker

This example is valid syntax, but we were not able to check execution

>>> df.notna()
     age   born  name    toy
0   True  False  True  False
1   True   True  True   True
2  False   True  True   True

Show which entries in a Series are not NA.

This example is valid syntax, but we were not able to check execution

>>> ser = pd.Series([5, 6, np.NaN])
... ser
0    5.0
1    6.0
2    NaN
dtype: float64

This example is valid syntax, but we were not able to check execution

>>> ser.notna()
0     True
1     True
2    False
dtype: bool

See :

Back References

The following pages refer to to this document either explicitly or contain code examples using this.

pandas.core.frame.DataFrame.notna pandas.core.frame.DataFrame.isna pandas.core.dtypes.missing.notna pandas.core.frame.DataFrame.isnull pandas.core.frame.DataFrame.notnull pandas.core.frame.DataFrame.dropna

Local connectivity graph

Hover to see nodes names; edges to Self not shown, Caped at 50 nodes.

Using a canvas is more power efficient and can get hundred of nodes ; but does not allow hyperlinks; , arrows or text (beyond on hover)

SVG is more flexible but power hungry; and does not scale well to 50 + nodes.

All aboves nodes referred to, (or are referred from) current nodes; Edges from Self to other have been omitted (or all nodes would be connected to the central node "self" which is not useful). Nodes are colored by the library they belong to, and scaled with the number of references pointing them

---

File: /pandas/core/frame.py#5862
type: <class 'function'>
Commit: