验证土壤EC/pH读数量程合法性

def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd, json
    payloads_csv = open_url("https://data.zuihe.com/dbd/ms-greenfarm/state_01/raw_payloads.csv").read()
    st_csv = open_url("https://data.zuihe.com/dbd/ms-greenfarm/state_01/sensor_types.csv").read()
    payloads = pd.read_csv(StringIO(payloads_csv))
    st = pd.read_csv(StringIO(st_csv))
    ranges = {r['metric']:(r['min_value'],r['max_value']) for _,r in st.iterrows()}
    def validate_soil(payload_str):
        try: p = json.loads(payload_str)
        except: return ['invalid_json']
        readings = p.get('readings',{})
        errors = []
        for metric, val in readings.items():
            if metric in ranges and isinstance(val,(int,float)):
                lo, hi = ranges[metric]
                if not (lo <= val <= hi):
                    errors.append(metric+"="+str(val)+" out_of_range["+str(lo)+","+str(hi)+"]")
        return errors
    soil_payloads = payloads[payloads['report_type']=='soil'].head(8)
    for _, row in soil_payloads.iterrows():
        errs = validate_soil(row['payload'])
        status = "FAIL "+str(errs) if errs else "OK"
        print("id="+str(row['id'])+" "+row['device_id']+": "+status)