Counting Package Registries

Problem

A DataFrame `packages` lists software dependencies. Each row has a `pkg_id` and a `coordinate` string written as `name@registry` (for example `parser@npmjs.org`). The part before the `@` is the package name; the part after the `@` is the registry host.

Keep only coordinates whose registry host ends in `.org`. For those, extract the registry host and count how many packages come from each one. Return a DataFrame with columns `registry` (the host after the `@`) and `pkg_count` (the number of packages from that registry), ordered by `registry` ascending.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns registry, pkg_count.

Starter code (Pandas (Python))

import pandas as pd

def count_org_registries(packages) -> pd.DataFrame:
    # Your code here
    return packages

Related Pandas questions

• Above-Average CampusesEasy
• Adjacent Open Parking SpotsEasy
• Asset Labels With a Three-Digit CodeEasy
• Average Listening Sessions per ListenerEasy
• Average Nightly Rate Earned per RoomEasy
• Average Reviewer Tenure per GrantEasy