/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 vote164 views1 answer
Access host database django docker
Python Django
-1 vote200 views3 answers
ValueError: If using all scalar values, you must pass an index
Python
0 vote123 views1 answer
Python read vcf file line by line
Python
0 vote88 views1 answer
Driver code in python
Python
2 votes133 views1 answer
Slice columns from dataframe
Python
0 vote127 views1 answer
Matlab end of array
Python
0 vote140 views1 answer
Python pandas convert comma separated number string to integer list
Python
1 vote130 views1 answer
Python pandas dataframe column date to string
Python
33 votes169 views3 answers
How to convert a byte array to string in python
Python
0 vote123 views1 answer
New paragraph python
Python