Practice
Real PySpark, graded in seconds. Pick a problem and hit Run.
- Combine the RegionseasyreshapingunionByNameunion
- Daily Ride CounteasyaggregationsgroupBycount
- Distinct BuyerseasyaggregationscountDistinctgroupBy
- Everyone's Planeasyjoinsjoinleft
- Fill the Blankseasystrings dates nullscoalescenullslit
- Flag the Long Rideseasyselecting and filteringwithColumnbooleancolumn-expressions
- Has an Emaileasystrings dates nullsisNotNullfilter
- Large and In Chargeeasyselecting and filteringfilterselectcolumn-expressions
- Long Visitseasyselecting and filteringfilterselect
- Name That Producteasyjoinsjoininner
- Priciest Per CategoryeasyaggregationsgroupBymax
- Rename the Hitseasyselecting and filteringselectaliascolumn-expressions
- Revenue Per StoreeasyaggregationsgroupBysum
- Tidy the Nameseasystrings dates nullstrimupperwithColumn
- Unique Listenerseasyreshapingdistinctselect
- 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
- Barista AveragesmediumaggregationsgroupByavghavingfloat-tolerance
- Basket Contentsmediumaggregationscollect_setsort_arraygroupBy
- Best Seller Per Storemediumwindow functionswindowrow_numbertop-1
- Clean Phone Digitsmediumstrings dates nullsregexp_replace
- Count the Refundsmediumaggregationsconditional-aggregationwhensum
- Day Over Daymediumwindow functionswindowlag
- Dense Standingsmediumwindow functionswindowdense_rankties
- Ghosted Customersmediumjoinsjoinleft_anti
- Match on Two Keysmediumjoinsjoinmulti-key
- Membership Lengthmediumstrings dates nullsdatediffto_date
- Plays Per Monthmediumstrings dates nullsto_datemonthgroupBy
- Spend by NamemediumjoinsjoingroupBysum
- Store-Day RevenuemediumaggregationsgroupBymulti-keysum
- Tag Explosionmediumstrings dates nullssplitexplodegroupBy
- The Store-Month GridmediumreshapingpivotgroupBysum
- Tip-Top Baristasmediumselecting and filteringwithColumnfilteraliasfloat-math
- Who Ordered Whatmediumjoinsjoininner
- Who Reports to Whommediumjoinsjoinself-joinalias