Members With a Quick Repeat Borrow

Problem

You are given a DataFrame `borrow_log` with columns `member_id`, `title`, `borrowed_on` (a date string), and `fee_cents`. There is no unique key; a member may borrow several titles, and the same member can appear on many dates. Each row records a single borrow event.

A member is *engaged* if they have two consecutive (in time) borrow events whose dates are 7 days apart or less. Report the `member_id` of every engaged member, each id once. The result may be returned in any order.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns member_id.

Starter code (Pandas (Python))

import pandas as pd

def members_with_a_quick_repeat_borrow(borrow_log) -> pd.DataFrame:
    # Your code here
    return borrow_log

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