Top Solar Installer per Panel Technology

Problem

A solar company tracks installers, the arrays they own, and the jobs run on those arrays, across three DataFrames loaded from CSV: `installers` (`installer_id`, `full_name`, `years_active`, `safety_flags`), `arrays` (`array_id`, `installer_id`, `panel_tech`, `watt_rating`), and `jobs` (`job_id`, `array_id`, `kilowatts`, `minutes`, `score`). Each array uses one panel_tech; each job records the kilowatts delivered and a customer satisfaction score from 1 to 5.

For every panel_tech find the single best installer ranked by, in order: highest average satisfaction score (rounded to 2 decimals), then highest total kilowatts, then fewest safety_flags on the installer record. Return a DataFrame with columns `panel_tech`, `installer_id`, `score`, `kilowatts`, ordered by `panel_tech`.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns panel_tech, installer_id, score, kilowatts.

Starter code (Pandas (Python))

import pandas as pd

def top_installer(installers, arrays, jobs) -> pd.DataFrame:
    # Your code here
    return installers

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