Longest Support Sessions per Channel

Problem

You are given two DataFrames. `agents` (CSV `agents.csv`) has columns agent_id, given_name, and surname; `sessions` (CSV `sessions.csv`) has columns agent_id, channel (either `chat` or `voice`), and seconds_long (the session length in seconds). For each channel, find the three longest sessions. If two sessions tie on length they share a rank and both are kept (so a channel may return more than three rows when there are ties at the cutoff). Output columns: the agent's `given_name`, the `channel`, and the duration as `clock` formatted HH:MM:SS. Order by `channel`, then by duration descending, then by `given_name` descending for ties.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 6 rows with the columns given_name, channel, clock.

Starter code (Pandas (Python))

import pandas as pd

def longest_support_sessions_per_channel(agents, sessions) -> pd.DataFrame:
    # Your code here
    return agents

Related Pandas questions

• 7-Day Rolling Signup AverageMedium
• Accounts Streaming From Two Devices at OnceMedium
• Agent Resolution RateMedium
• Agents With a Dominant Contact ChannelMedium
• Airbnb Popularity Bucket PricingMedium
• Amazon Unique Shipments per MonthMedium