pyspark.sql.functions.bool_and

pyspark.sql.functions.bool_and(col: ColumnOrName) → pyspark.sql.column.Column

Aggregate function: returns true if all values of col are true.

New in version 3.5.0.

Parameters

colColumn or str

column to check if all values are true.

Returns

Column

true if all values of col are true, false otherwise.

Examples

>>> df = spark.createDataFrame([[True], [True], [True]], ["flag"])
>>> df.select(bool_and("flag")).show()
+--------------+
|bool_and(flag)|
+--------------+
|          true|
+--------------+
>>> df = spark.createDataFrame([[True], [False], [True]], ["flag"])
>>> df.select(bool_and("flag")).show()
+--------------+
|bool_and(flag)|
+--------------+
|         false|
+--------------+
>>> df = spark.createDataFrame([[False], [False], [False]], ["flag"])
>>> df.select(bool_and("flag")).show()
+--------------+
|bool_and(flag)|
+--------------+
|         false|
+--------------+

previous

pyspark.sql.functions.bit_xor

next

pyspark.sql.functions.bool_or