Branches With Above-Average Water Flow

Problem

A municipal water utility records every metered flow between water meters. Each meter belongs to one branch office.

`branch` columns: `branch_id`, `city`, `area_code`.
`meter` columns: `meter_id`, `branch_id`.
`flow_log` columns: `source_meter`, `target_meter`, `litres` - one logged transfer per row.

Return the branches whose **average flow per logged transfer is strictly greater than the global average flow per transfer** across the whole network. A meter participates in a transfer whether it is the source or the target of the flow.

Return one column named `region` (the branch city). Order does not matter.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns region.

Starter code (Pandas (Python))

import pandas as pd

def branches_with_above_average_water_flow(branch, meter, flow_log) -> pd.DataFrame:
    # Your code here
    return branch

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