Grant Applicants Who Cleared Review

Problem

You are given two DataFrames. `applicants` has columns `applicant_id`, `panel_id`, and `tenure_years`; `applicant_id` uniquely identifies each applicant, `panel_id` is the review panel assigned to them, and `tenure_years` is how many years they have worked in the field. `reviews` has columns `panel_id` and `points`; a panel scores several criteria, so a `panel_id` may appear in multiple rows, each giving the points for one criterion.

Return the `applicant_id` of every applicant who has at least `3` years of tenure and whose combined review points across their panel sum to more than `20`. Return the result in any order, in one column `applicant_id`.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns applicant_id.

Starter code (Pandas (Python))

import pandas as pd

def grant_applicants_who_cleared_review(applicants, reviews) -> pd.DataFrame:
    # Your code here
    return applicants

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