How to check whether all values in a column satisfy a condition in Data Frame?

Question

How can I check if all values under col1 satisfy a condition such as > 2?

import pandas as pd

d = [
    {'col1': 3, 'col2': 'wasteful'},
    {'col1': 0, 'col2': 'hardly'},
    ]

df = pd.DataFrame(d)

I could go

if all(col1 > 2 for i, col1, col2 in df.itertuples()):
    #do stuff

but is there a more readable, faster and/or has less memory footprint way?

Answer 1

I think you need create boolean mask and then all for check if all Trues:

print (df['col1'] > 2)
0     True
1    False
Name: col1, dtype: bool

print ((df['col1'] > 2).all())
False

Answer 2

You can also use numpy.where to check if all column of a dataframe satisfies a condition

import numpy as np
import pandas as pd

d = [
  {'col1': 3, 'col2': 'wasteful'},
  {'col1': 0, 'col2': 'hardly'},
]

df = pd.DataFrame(d)
print(all(np.where(df['col1'] > 2, True, False)))
#False