PySpark Joins

10 interview problems on inner, left, anti and semi joins across DataFrames, from easy to hard.

• Customers Without Orders · Medium · Joins
• Employees and Their Departments · Medium · Joins
• Year-over-Year Growth · Medium · Joins
• Employees Earning More than Their Manager · Medium · Joins
• Joining on Nullable Keys · Medium · Joins
• Price Valid at Order Time (Range Join) · Hard · Joins
• Reconcile Two Sources (Full Outer Join) · Hard · Joins
• Fill Missing Dates (Calendar Spine) · Hard · Joins
• Customers Who Bought Every Product · Hard · Joins
• Monthly Retention by Cohort · Hard · Joins

Browse

Topics: Window Functions · Joins · Aggregations · Pivot, Unpivot & Rollup · Arrays · Null Handling · Conditional Logic · Dates · Filtering & Selection · Strings

Difficulty: Easy · Medium · Hard · PySpark interview roadmap · All problems