Genres Whose Tracks Echo the Genre Initial

Problem

A streaming catalog arrives as a DataFrame `catalog` with one row per track, grouped by genre. Find every genre that contains at least 3 tracks AND has at least one track whose title starts with the same letter as the genre name. For each such genre, list all of its track titles joined into a single comma-separated string in alphabetical order, and count how many of its tracks start with the genre's initial letter. Return a DataFrame with columns genre, tracklist and initial_match_count, ordered by initial_match_count descending, then genre.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns genre, tracklist, initial_match_count.

Starter code (Pandas (Python))

import pandas as pd

def genres_whose_tracks_echo_the_genre_initial(catalog) -> pd.DataFrame:
    # Your code here
    return catalog

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