/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 vote127 views1 answer
Fakultät python
Python
0 vote123 views1 answer
Selenium how to handle element not found python
Python
8 votes109 views1 answer
Count the duplicates in a list in python
Python
0 vote138 views1 answer
Activate inherit function django
Python Django
2 votes102 views2 answers
Timestamp e datetime python
Python
0 vote125 views3 answers
Move window with overrideredirect
Python
7 votes111 views2 answers
Python encode comment
Python
0 vote115 views1 answer
Korozif
Python
0 vote108 views1 answer
How to acces textedit fields pyqt
Python
1 vote114 views1 answer
Groupby as_index=false
Python