/Python/Returns the cartesian product with another DataFrame

Returns the cartesian product with another DataFrame

# Returns the cartesian product with another DataFrame

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=55, name='Bob', height=80), Row(age=5, name='Bob', height=85)]

Source: spark.apache.org

Similar codes

4 votes122 views2 answers
Python Program to count the number of lowercase letters and uppercase letters in a string.
Python
1 vote115 views1 answer
Negative cv2
Python
0 vote134 views1 answer
Pyplot set x range
Python
0 vote140 views1 answer
Read file from form input type filepython
Python
0 vote121 views1 answer
Pandas join two series on index
Python
0 vote153 views1 answer
Django queryset group by sum
Python Django
-1 vote123 views2 answers
Get tuple value python
Python
58 votes213 views6 answers
Python class
Python
2 votes115 views1 answer
Python convert any number in positive
Python
0 vote120 views1 answer
Random.choices without repetition
Python