统计服务失败率

def solve():
    from pyodide.http import open_url
    from io import StringIO
    request_logs_csv = open_url("https://data.zuihe.com/dbd/ms-shop/state_03/request_logs.csv").read()
    import pandas as pd
    from io import StringIO
    logs = pd.read_csv(StringIO(request_logs_csv))
    def calc_failure_rate(data, path=None):
        if path: data = data[data['path']==path]
        if len(data) == 0: return 0.0, 0, 0
        total = len(data)
        failed = (data['status_code'] >= 400).sum()
        return round(failed/total, 4), int(failed), total
    for path in logs['path'].unique():
        rate, failed, total = calc_failure_rate(logs, path)
        alert = ' [ALERT]' if rate > 0.1 else ''
        print(f"{path}: {failed}/{total} = {rate:.1%}{alert}")
    overall_rate, _, _ = calc_failure_rate(logs)
    print(f"Overall: {overall_rate:.1%}")