/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

0 vote299 views1 answer
Python how to turn a word into a list
Python
2 votes299 views3 answers
Solve equation python
Python
1 vote290 views1 answer
Python how to draw triangle
Python
-1 vote274 views1 answer
Python curses resize window
Python
0 vote283 views1 answer
Performance of extend vs append loop
Python
3 votes284 views3 answers
How to insert image in python
Python
3 votes286 views2 answers
Catch error python
Python
17 votes359 views3 answers
ModuleNotFoundError: No module named 'rest_api_framework'
Python
0 vote286 views1 answer
Pytest temp directory
Python
2 votes271 views1 answer
String module in python
Python