~/practice
Problem set
Real DataFrame wrangling: filtering, groupby, merges, reshaping.
problems53
solved here0
progress0%
Guest solve history stays on this device and doesn’t sync. Sign in to save future work to your account.
difficulty
progress
53 problems
legendsqlpythonpandaseasymediumhard
- pandasSelect and filter rowsfilteringeasy
- pandasCreate a revenue columnassigneasy
- pandasGroup by and aggregategroupbyeasy
- pandasHandle missing ratingsmissing dataeasy
- pandasMulti-column aggregationgroupbyaggmedium
- pandasMerge two DataFramesmergemedium
- pandasPivot tablepivot_tablemedium
- pandasRank within groupsgroupbyrankhard
- pandasReshape wide to longmelthard
- pandasShare of revenue per customertransformgroupbyhard
- pandasairbnbHost listing summarygroupbyaggmedium
- pandasuberFilter SF tripsfilteringeasy
- pandasuberDriver earnings sharegroupbytransformmedium
- pandasnetflixFilter drama watch eventsfilteringeasy
- pandasnetflixMonthly watch hoursgroupbydatetimesmedium
- pandasairbnbOccupancy revenue per hostgroupbyaggmedium
- pandasuberFare per mile by citygroupbyratiosmedium
- pandasuberBase fare without surgeassignrankhard
- pandasnetflixMinutes watched per genregroupbymedium
- pandasnetflixMonth-two retentionsetsdatetimehard
- pandasnetflixAverage session length per usergroupbyaggmedium
- pandasgoogleClick-through rate per querygroupbyratiosmedium
- pandasspotifyMonthly listening hours per artistdatetimepivot_tablemedium
- pandasspotifySkip rate per usertransformgroupbyhard
- pandasdoordashPeak dinner hour volumedatetimegroupbymedium
- pandasdoordashTip percentage by cuisinegroupbyaggmedium
- pandasrobinhoodRealized profit and lossgroupbyapplyhard
- pandasappleMinutes per appgroupbysorteasy
- pandasappleCrash rate per appgroupbyratiosmedium
- pandasappleTop spender per countrygroupbyidxmaxmedium
- pandasappleDaily engagement pivotpivot_tablereshapinghard
- pandasmicrosoftCost per tenantassigngroupbyeasy
- pandasmicrosoftService mix matrixpivot_tablefillnamedium
- pandasmicrosoftActive seats per tenantfilteringgroupbymedium
- pandastiktokAverage watch percentagegroupbyderived columnsmedium
- pandastiktokRolling 3-day coin totalrollingtime serieshard
- pandastiktokEngagement leaderboardaggmultiple metricsmedium
- pandasopenaiSpend by organisationmergegroupbymedium
- pandasopenaiLatency percentiles per modelquantileagghard
- pandasopenaiStatus breakdown sharecrosstabnormalizemedium
- pandassnowflakeScan efficiency per warehousegroupbyderived metricsmedium
- pandassnowflakeSpill rate by usergroupbymeanmedium
- pandassnowflakeCredits with cumulative sharecumsumrankinghard
- pandasdatabricksAverage runtime per jobgroupbymeaneasy
- pandasdatabricksRetry hotspotsfilteringgroupbymedium
- pandasdatabricksSmall file ratio per catalogmergederived metricsmedium
- pandasdatabricksDaily pipeline healthpivot_tablesuccess ratehard
- pandasgoogleAd auction eCPM by campaigngroupbyderived metricsmedium
- pandasmetaLast-click attribution windowmergefilteringhard
- pandasstripeMRR movement breakdownmergepivothard
- pandasamazonBuy Box win rate and price gapgroupbyderived metricsmedium
- pandasspotifyPro-rata royalty payoutsmergegroupbyhard
- pandasnetflixWatch time before cancellingmergedate filteringmedium