/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 votes239 views2 answers
Interpreter in python
Python
0 vote218 views1 answer
Accuracy for each class
Python
42 votes216 views6 answers
Python regex
Python
0 vote207 views2 answers
Pandas groupby percentile
Python
1 vote218 views1 answer
Os.system return value
Python
1 vote207 views2 answers
Python line break inside string
Python
0 vote204 views1 answer
Get raster corners python
Python
1 vote215 views1 answer
Evaluate how much a python program memory
Python
0 vote210 views1 answer
Pandas index between time
Python
1 vote197 views1 answer
Euclidean division in python
Python