pandas 1.4.2

ReturnsBackRef
notnull(self) -> 'DataFrame'

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.

Returns

DataFrame

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

DataFrame.notnull is an alias for DataFrame.notna.

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.notnull pandas.core.frame.DataFrame.notna

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#5866
type: <class 'function'>
Commit: