All() and any():Check row or column values for True in a Pandas DataFrame

The all() and any() methods of Pandas DataFrame class check whether the values are True on a given axis. The pandas example programs use these functions to test DataFrame instances and print the output.

Dataframe Computations Updated 28 May 2019 1 min read

Overview

  • Pandas DataFrame has methods all() and any() to check whether all or any of the elements across an axis(i.e., row-wise or column-wise) is True.
  • all() does a logical AND operation on a row or column of a DataFrame and returns the resultant Boolean value.
  • any() does a logical OR operation on a row or column of a DataFrame and returns the resultant Boolean value.

Example – For DataFrame.all() method

python
import pandas as pd

dataDict = {"v1":[True, True],

            "v2":[True, False],

            "v3":[True, True]};

dataFrame = pd.DataFrame(data=dataDict);

results = dataFrame.all(axis=0);

print("DataFrame:")

print(dataFrame)

print("Results:Computed column-wise")

print(results)

results = dataFrame.all(axis=1);

print("Results:Computed row-wise")

print(results)

Output

Output
DataFrame:

     v1     v2    v3

0  True   True  True

1  True  False  True

Results:Computed column-wise

v1     True

v2    False

v3     True

dtype: bool

Results:Computed row-wise

0     True

1    False

dtype: bool

Example – For DataFrame.any() method

python
import pandas as pd

dataValues = {"Column1":[True, False, True],

              "Column2":[True, True, True],

              "Column3":[False, False, False]};

dataFrame = pd.DataFrame(data=dataValues);

resultData = dataFrame.any();

print("DataFrame");

print(dataFrame);

print("DataFrame:Computed column-wise");

print(resultData);

resultData = dataFrame.any(axis=1);

print("Result:Computed row-wise");

print(resultData);

Output

Output
DataFrame:

   Column1  Column2  Column3

0     True     True    False

1    False     True    False

2     True     True    False

DataFrame:Computed column-wise

Column1     True

Column2     True

Column3    False

dtype: bool

Result:Computed row-wise

0    True

1    True

2    True

dtype: bool