Promotion-Track Baristas

Problem

A coffee chain records its weekly top-three baristas. `weeklyvote` has columns `week_no`, `top_pick`, `second_pick`, `third_pick`; each pick column holds the `barista_id` placed in that rank that week. `barista` has columns `barista_id`, `email`, `name`.

A barista is on the **promotion track** if EITHER:
- they placed in the top three (any rank) in **three or more consecutive weeks**, OR
- they were the `top_pick` in **three or more** different weeks.

Report the `name` and `email` of every promotion-track barista, in any order.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns name, email.

Starter code (Pandas (Python))

import pandas as pd

def promotion_track_baristas(weeklyvote, barista) -> pd.DataFrame:
    # Your code here
    return barista

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