Solar Panels Generating More Per Sun-Hour

Problem

You are given two DataFrames. `panels` has columns `panel_id` and `site_label`. `generation_logs` has columns `log_id`, `panel_id`, `logged_on`, `energy_kwh`, and `sun_hours`; the yield for a log is `energy_kwh` divided by `sun_hours`.

Find every panel whose average yield improved from the first half of the year (January through June) to the second half (July through December). Only include panels that have at least one log in each half. Report the gain as the second-half average yield minus the first-half average yield, rounded to two decimals.

Return a DataFrame with columns `site_label` and `yield_gain`, ordered by `yield_gain` descending, then `site_label` ascending.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns site_label, yield_gain.

Starter code (Pandas (Python))

import pandas as pd

def solar_panels_generating_more_per_sun_hour(panels, generation_logs) -> pd.DataFrame:
    # Your code here
    return panels

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