Mid-Chain Mentors

Problem

A `Mentorship` DataFrame records direct mentor → mentee links as `mentor` and `mentee`. A *mid-chain mentor* is someone who mentors at least one person and is also themselves mentored by someone else (they sit in the middle of a chain, not at the top).

Report every mid-chain mentor and how many distinct mentees they have, in columns `mentor` and `mentee_count`, ordered by `mentor`.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns mentor, mentee_count.

Starter code (Pandas (Python))

import pandas as pd

def mid_chain_mentors(mentorship: pd.DataFrame) -> pd.DataFrame:
    # Your code here
    return mentorship

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