Classifying Departments in an Org Chart

Problem

A company stores its department hierarchy in the `orgunits` DataFrame. Each row has a department id `unit_id` and the id of the department it reports to, `reports_to`. The single top department reports to nobody, so its `reports_to` is NaN.

Classify every department into one column `position`:

- `Top` if the department reports to nobody.
- `Middle` if at least one other department reports to it (and it itself reports to someone).
- `Frontline` if no department reports to it.

Return `unit_id` and `position`, ordered by `unit_id` ascending.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 7 rows with the columns unit_id, position.

Starter code (Pandas (Python))

import pandas as pd

def classify_units(orgunits) -> pd.DataFrame:
    # Your code here
    return orgunits

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