/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 vote212 views1 answer
Python program for grocery store
Python
1 vote179 views2 answers
Pandas count rows with value
Python
15 votes186 views3 answers
Inverse matrix python numpy
Python
0 vote218 views1 answer
Check even or odd in single line
Python
4 votes205 views2 answers
Doc strings python
Python
1 vote201 views1 answer
How to redefine a legend in pandas
Python
0 vote194 views1 answer
Subset data frame by date
Python
0 vote191 views1 answer
Change increment in for loop python
Python
0 vote199 views1 answer
Aiohttp specify app IP
Python
2 votes191 views3 answers
WARNING: pip is configured with locations that require TLS/SSL, however the ssl module in Python is not available.
Python