/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

5 votes178 views1 answer
Matplotlib change thickness of line
Python
1 vote237 views1 answer
Flask set cookie
Python Flask
6 votes233 views2 answers
Show all columns pandas jupyter notebook
Python
1 vote192 views1 answer
Python hide input
Python
0 vote176 views2 answers
Python write column csv
Python
0 vote171 views1 answer
Make a bot that spams space bar python
Python
0 vote181 views1 answer
Import one file into another python
Python
51 votes177 views5 answers
Mr robot
Python
9 votes175 views6 answers
How to use print in python
Python
1 vote187 views1 answer
How to read zip csv file in python
Python