Streaming Subscribers on a Hot Streak

Problem

A music app records the days on which each subscriber opened the app.

DataFrame `subscribers` (from `subscribers.csv`) has columns `sub_id` (primary key) and `handle` (display name).

DataFrame `opens` (from `opens.csv`) has columns `sub_id` and `open_day` (date). This DataFrame may contain duplicate rows — a subscriber can open the app many times on the same day.

A subscriber is on a hot streak if they opened the app on five or more consecutive calendar days. Report the `sub_id` and `handle` of every such subscriber, ordered by `sub_id`.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns sub_id, handle.

Starter code (Pandas (Python))

import pandas as pd

def hot_streak_subscribers(subscribers, opens) -> pd.DataFrame:
    # Your code here
    return subscribers

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