Resolve Sensor Threshold Checks

Problem

A monitoring system stores named numeric readings and a list of comparison checks between two of those readings.

DataFrame `gauges` (from `gauges.csv`) has columns `tag` (a short label) and `reading` (the gauge's current numeric value).

DataFrame `checks` (from `checks.csv`) has columns `lhs`, `comparator`, `rhs`. `lhs` and `rhs` are gauge tags; `comparator` is one of `'>'`, `'<'`, or `'='`. Each row asks whether the comparison `lhs comparator rhs` holds.

For every check, return its three columns plus a `verdict` column equal to the string `pass` when the comparison is true and `fail` otherwise.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 6 rows with the columns lhs, comparator, rhs, verdict.

Starter code (Pandas (Python))

import pandas as pd

def resolve_checks(gauges, checks) -> pd.DataFrame:
    # Your code here
    return gauges

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