/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

3 votes293 views2 answers
Resize numpy array image
Python
6 votes330 views3 answers
Pandas drop row by condition
Python
1 vote338 views1 answer
Jinja len is undefined
Python
0 vote320 views1 answer
Openpyxl read cell value
Python
2 votes299 views1 answer
How to check if a message includes a word discord.py
Python
3 votes308 views1 answer
Python how to find the highest number in a dictionary
Python
7 votes323 views2 answers
Log base in python
Python
0 vote298 views1 answer
Send command dynamo civid
Python
0 vote347 views1 answer
Str count python
Python
33 votes303 views6 answers
How to add element to list python
Python