Tuition Collected by Each Tutor

Problem

You are given three DataFrames. `Tutor` has columns `tutor_id` and `tutor_name`. `Student` has columns `student_id` and `tutor_id`. `Payment` has columns `payment_id`, `student_id`, and `amount`. Return a DataFrame with columns `tutor_id`, `tutor_name`, and `collected`, where `collected` is the sum of all payment amounts made by that tutor's students. A tutor with no students, or whose students made no payments, has a `collected` value of 0. Row order does not matter.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns tutor_id, tutor_name, collected.

Starter code (Pandas (Python))

import pandas as pd

def tuition_per_tutor(Tutor, Student, Payment) -> pd.DataFrame:
    # Your code here
    return Tutor

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