pyspark.sql.DataFrame.crossJoin

DataFrame.crossJoin(other)[source]

Returns the cartesian product with another DataFrame.

New in version 2.1.0.

Parameters
otherDataFrame

Right side of the cartesian product.

Examples

>>> df.select("age", "name").collect()
[Row(age=2, name='Alice'), Row(age=5, name='Bob')]
>>> df2.select("name", "height").collect()
[Row(name='Tom', height=80), Row(name='Bob', height=85)]
>>> df.crossJoin(df2.select("height")).select("age", "name", "height").collect()
[Row(age=2, name='Alice', height=80), Row(age=2, name='Alice', height=85),
 Row(age=5, name='Bob', height=80), Row(age=5, name='Bob', height=85)]