/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 vote144 views1 answer
Skills=request.POST['skills']
Python
0 vote157 views1 answer
Django listview
Python
0 vote154 views1 answer
Python django model range validation
Python
123 votes136 views6 answers
Rename column in dataframe
Python
2 votes203 views1 answer
Django rest framework viewset perform_update
Python Django
1 vote204 views1 answer
Replace none with empty string python
Python
13 votes164 views2 answers
Pip version command
Python
0 vote148 views1 answer
Santhal paragana
Python
1 vote177 views1 answer
Using regex validators in django models
Python Django
0 vote157 views1 answer
Networkx create graph from dataframe
Python