Tutorials References Exercises Videos Menu
Free Website Get Certified Upgrade

Pandas DataFrame any() Method

❮ DataFrame Reference


Example

Check if any value in each row (index) is True:

import pandas as pd

data = [[True, False, True], [True, False, False]]
df = pd.DataFrame(data)

print(df.any())
Try it Yourself »

Definition and Usage

The any() method returns one value for each column, True if ANY value in that column is True, otherwise False.

By specifying the column axis (axis='columns'), the all() method returns True if ANY value in that axis is True.


Syntax

dataframe.any(axis, bool_only, skipna, level, kwargs)

Parameters

The axis, bool_only, skipna, level parameters are keyword arguments.

Parameter Value Description
axis 0
1
'index'
'columns'
Optional, Which axis to check, default 0.
bool_only None
True
False
Optional. Specify whether to only check Boolean columns or not. Default None
skip_na True
False
Optional, default True. Set to False if the result should NOT skip NULL values
level Number
level name
Optional, default None. Specifies which level ( in a hierarchical multi index) to count along
kwargs   Optional, keyword arguments. These arguments has no effect, but could be accepted by a NumPy function

 Return Value

A Series of True and False values.

If the level argument is specified, this method will return a DataFrame object.

This function does NOT make changes to the original DataFrame object.


❮ DataFrame Reference