patito.duckdb.Relation.all
- Relation.all(*filters, **equalities)
Return
True
if the given predicate(s) are true for all rows in the relation.See
Relation.filter()
for additional information regarding the parameters.- Parameters:
filters (
str
) – SQL predicates to satisfy.equalities (
Union
[int
,float
,str
]) – SQL equality predicates to satisfy.
- Return type:
bool
Examples
>>> import patito as pt >>> df = pt.DataFrame( ... { ... "even_number": [2, 4, 6], ... "odd_number": [1, 3, 5], ... "zero": [0, 0, 0], ... } ... ) >>> relation = pt.duckdb.Relation(df) >>> relation.all(zero=0) True >>> relation.all( ... "even_number % 2 = 0", ... "odd_number % 2 = 1", ... zero=0, ... ) True >>> relation.all(zero=1) False >>> relation.all("odd_number % 2 = 0") False