/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

6 votes159 views2 answers
Update jupyter notebook
Python
0 vote167 views1 answer
Custom_settings in scrpay
Python
1 vote145 views1 answer
Python display text in label on new line
Python
0 vote116 views1 answer
Unique id on duplicate ids values pandas
Python
8 votes168 views2 answers
Show image jupyter notebook
Python
4 votes164 views6 answers
Function in function python
Python
1 vote138 views1 answer
Run streamlit from python
Python
1 vote149 views1 answer
Pdf to csv conversion
Python
12 votes148 views4 answers
Get index of all element in list python
Python
8 votes170 views2 answers
How to clear the list in python
Python