Monika Rathor shows the various ways you can join DataFrames with PySpark:
PySpark provides multiple ways to combine dataframes i.e. join, merge, union, SQL interface, etc. In this article, we will take a look at how the PySpark join function is similar to SQL join, where two or more tables or dataframes can be combined based on conditions.
One join type you don’t directly get in SQL Server is the left anti join. We can build something quite similar with NOT EXISTS, though.