/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 vote110 views1 answer
Set list start at 1 python
Python
0 vote126 views1 answer
Parsing a file and adding a number at starting of every line sentence python
Python
0 vote123 views1 answer
Is file a keywoard in python
Python
2 votes117 views6 answers
Pandas group by
Python
-1 vote113 views1 answer
Sudo apt-get install python2-pip
Python
27 votes118 views5 answers
Panda python install
Python
0 vote278 views1 answer
Python local date time
Python
1 vote110 views1 answer
Required validator python WTForms
Python
2 votes115 views3 answers
Python list unique in order
Python
0 vote102 views1 answer
Pandas columns case when equivalent
Python