Built with Tutify.io

    AIStudyLabs

    Pandas DataFrame all() Method

    Pandas DataFrame all() Method

    In Pandas, the all() method is used to check if all values in a DataFrame or Series are True or meet a specified condition. It can be applied across a particular axis, either rows or columns. While commonly used with boolean values, it can also assess the truthiness of other data types. Non-zero or non-empty values are treated as True, whereas values like 0, NaN, or empty entries are considered False.

    In this article, I will explain the Pandas DataFrame all() method, including its syntax, parameters, and usage. We will look at how to determine if all elements in a DataFrame or Series meet a given condition, with the flexibility to apply it to either columns or rows, depending on the chosen axis.

    Key Points –

    <a id="h-pandas-all-method"></a>

    Pandas all() Method

    The Pandas all() method is used to evaluate whether all elements in a DataFrame or Series are True along a specific axis (rows or columns). This method is typically applied to boolean data but can also handle other data types where "truthiness" (e.g., non-zero or non-empty values) can be determined.

    <a id="h-syntax-of-pandas-dataframe-all-method"></a>

    Syntax of Pandas DataFrame all() Method

    Let’s know the syntax of the all() method.

    
# Syntax of DataFrame.all() method
DataFrame.all(axis=0, bool_only=None, skipna=True, level=None, **kwargs)

    <a id="h-parameters-of-the-nbsp-dataframe-all"></a>

    Parameters of the DataFrame.all()

    Following are the parameters of the all() method.

    <a id="h-return-value"></a>

    Return Value

    It returns a boolean Series or DataFrame (if a level is specified), with each value representing whether all elements along the specified axis are True.

    <a id="h-usage-of-pandas-dataframe-all-method"></a>

    Usage of Pandas DataFrame all() Method

    The Pandas DataFrame.all() method determines whether all elements in a DataFrame or along a specified axis are True. It is especially useful for verifying if every value in a row or column satisfies a condition, and is commonly used with boolean data.

    Now, let’s create a Pandas DataFrame using data from a dictionary.

    
import pandas as pd

df = pd.DataFrame({
    'A': [True, True, False],
    'B': [True, True, True]
})

print("Original DataFrame:\n",df)

    Yields below output.

    <a id="h-check-if-all-values-in-each-column-are-true-default-axis-0"></a>

    Check if all Values in Each Column are True (Default axis=0)

    You can use the all() method to determine if all values in each column of the DataFrame are True. By default, the method checks each column (with axis=0), so to verify if all values in every column are True, you simply use the all() method.

    
# Check if all values in each column are True
df2 = df.all()
print("All values in each column are True:\n", df2)

    Here, it shows that in column A, not all values are True, while in column B, all values are True.

    <a id="h-check-if-all-values-in-each-row-are-true-axis-1"></a>

    Check if all Values in Each Row are True (axis=1)

    Alternatively, to check if all values in each row are True, you can use the all() method with the parameter axis=1. This changes the behavior to check across rows instead of columns.

    
# Check if all values in each row are True
df2 = df.all(axis=1)
print("All values in each row are True:\n", df2)

# Output:
# All values in each row are True:
# 0     True
# 1     True
# 2    False
# dtype: bool

    Here,

    <a id="h-ignore-nan-values-while-checking-if-all-values-in-each-column-are-true-skipna-true"></a>

    Ignore NaN Values while Checking if all Values in Each Column are True (skipna=True)

    To ignore NaN values while checking if all values in each column are True, you can use the skipna=True parameter with the all() method. By default, skipna is set to True, which means NaN values are excluded from the check.

    
import pandas as pd
import numpy as np

# Creating a DataFrame with NaN values
df = pd.DataFrame({
    'A': [True, np.nan, False],
    'B': [True, True, np.nan]
})

# Check if all values in each column are True, ignoring NaN values
df2 = df.all(skipna=True)
print("All values in each column are True (ignoring NaN):\n", df2)

# Output:
# All values in each column are True (ignoring NaN):
# A    False
# B     True
# dtype: bool

    Here,

    Using skipna=True ensures that NaN values do not affect the result, and the method only considers the non-NaN values for the True check.

    <a id="h-apply-to-boolean-columns-only-bool-only-true"></a>

    Apply to Boolean Columns only (bool_only=True)

    Similarly, to apply the all() method exclusively to boolean columns in a DataFrame, use the bool_only=True parameter. This ensures that only columns with boolean data types are included in the evaluation while ignoring other data types.

    
import pandas as pd

# Creating a DataFrame with mixed data types
df = pd.DataFrame({
    'A': [True, False, True],
    'B': [2, 4, 6],          # Non-boolean column
    'C': [True, True, False]
})

# Check if all boolean values in each column are True
df2 = df.all(bool_only=True)
print("All boolean values in each column are True:\n", df2)

# Output:
# All boolean values in each column are True:
# A    False
# C    False
# dtype: bool

    Here,

    Using bool_only=True ensures that the check is performed solely on boolean columns, preventing other data types from influencing the result.

    <a id="h-check-if-all-values-along-a-specific-level-in-a-multiindex-dataframe-are-true"></a>

    Check if all Values Along a Specific Level in a MultiIndex DataFrame are True

    Finally, to check if all values along a specific level in a MultiIndex DataFrame are True, you'll need to use the all() method while specifying the level you want to check.

    
import pandas as pd

# Creating a MultiIndex DataFrame
arrays = [
    ['A', 'A', 'B', 'B'],
    [1, 2, 1, 2]
]
index = pd.MultiIndex.from_arrays(arrays, names=('Category', 'Subcategory'))

df = pd.DataFrame({
    'Values': [True, False, True, True]
}, index=index)

print("Original DataFrame:\n", df)

# Check if all values along a specific level
# (e.g., 'Category') are True
result = df.all(level='Category')
print("All values in each category are True:\n", result)

    Here,

    This example yields the below output.

    
Original DataFrame:
                       Values
Category Subcategory        
A        1              True
         2             False
B        1              True
         2              True
All values in each category are True:
           Values
Category        
A          False
B           True

    <a id="h-faq-on-pandas-dataframe-all-method"></a>

    FAQ on Pandas DataFrame all() Method

    The all() method checks if all elements along a specified axis in a DataFrame or Series are True. It returns True if all elements meet the condition and False otherwise.

    By default, all() checks along columns (axis=0). Simply call df.all() to check if all values in each column are True.

    Use the axis=1 parameter to check along rows. Call df.all(axis=1) to determine if all values in each row are True.

    When skipna=True, NaN values are ignored in the check. If skipna=False, any NaN values in the DataFrame will result in False being returned for that column or row.

    Use the bool_only=True parameter. This ensures that only boolean columns are considered in the check, ignoring other data types.

    <a id="h-conclusion"></a>

    Conclusion

    In summary, the all() method in Pandas is a useful tool for checking if all elements in a DataFrame or Series satisfy a True condition. It offers flexibility by enabling checks across different axes (rows or columns) and can be customized to ignore NaN values or limit the verification to boolean columns.

    Happy Learning!!

    <a id="h-related-articles"></a>

    Related Articles