/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

9 votes264 views3 answers
Can you compile python to an exe
Python
0 vote278 views1 answer
Python convert images to pdf
Python
0 vote290 views1 answer
A = [ int(i) for i in range(100, 104)] list python
Python
0 vote294 views1 answer
Programme phyton pour realiser un programme qui transforme une image en niveau de gris
Python
66 votes280 views6 answers
Wait function python
Python
0 vote315 views1 answer
Animal quiz game in python
Python
0 vote313 views2 answers
Bar plot group by pandas
Python
3 votes288 views1 answer
Pandas merge all csv in a folder
Python
21 votes293 views1 answer
Python remove last characters from string
Python
3 votes326 views3 answers
Python thread with parameters
Python