/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 votes248 views3 answers
Django Change Password
Python
0 vote233 views1 answer
Fatal Python error: init_interp_main: can't initialize time
Python
2 votes221 views1 answer
Check if part of list is in another list python
Python
0 vote257 views1 answer
Gnome-terminal stopped executing after python 3.6 is installed
Python
4 votes233 views3 answers
Read dict txt python
Python
13 votes242 views5 answers
Pandas Set index
Python
0 vote242 views1 answer
Return maximum of three values in python
Python
0 vote239 views2 answers
Django get superuser password
Python
0 vote243 views1 answer
Python input for competitive programming
Python
15 votes311 views6 answers
List to text file python
Python