Distinguish split, apply, and combine steps in a pandas groupby workflow.
sort-buckets comparison-spectrum score-chips Sort each pandas task into split, apply, or combine. Split Apply Combine Choose plan and week as the grouping keys for the ticket question. Use nunique on customer_id so each customer counts once per group. Reset the index and name the result column customers_with_tickets. Decide whether reopened tickets should remain separate before grouping. Calculate a median resolution time inside each plan-week group. Pivot the plan-week result into a heatmap-ready table. Bucket timestamps into calendar weeks before the groupby call. Divide escalated tickets by total tickets inside each group to create a rate.
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in