Practice

Real PySpark, graded in seconds. Pick a problem and hit Run.

DifficultyAll easy medium hard

TopicAll aggregations joins reshaping selecting and filtering strings dates nulls window functions

Chart-Toppershardwindow functionswindowrow_numbertop-npartitionBy
Latest Order Per Customerhardwindow functionswindowrow_numberjoinrecency
Running Revenuehardwindow functionswindowrunning-totalcumulative-sumrowsBetween
Sessionize the Streakshardwindow functionswindowlagcumulative-sumsessionization
Status Breakdown Gridhardreshapingpivotcountfillna
The Phantom Watchershardstrings dates nullsnullscoalescewhen-otherwisefilterchained-conditions
Three-Day Moving Averagehardwindow functionswindowmoving-averagerowsBetween
Top Two, Ties Includedhardwindow functionswindowrankties