实现核销后司法追偿状态跟踪

def solve():
    from pyodide.http import open_url
    clients_csv = open_url("https://data.zuihe.com/dbd/credit/state_10/clients.csv").read()
    loans_csv = open_url("https://data.zuihe.com/dbd/credit/state_10/loans.csv").read()
    loan_classifications_csv = open_url("https://data.zuihe.com/dbd/credit/state_10/loan_classifications.csv").read()
    write_offs_csv = open_url("https://data.zuihe.com/dbd/credit/state_10/write_offs.csv").read()
    recovery_records_csv = open_url("https://data.zuihe.com/dbd/credit/state_10/recovery_records.csv").read()
    import sqlite3, pandas as pd
    from io import StringIO
    conn = sqlite3.connect(':memory:')
    pd.read_csv(StringIO(write_offs_csv)).to_sql('write_offs', conn, index=False, if_exists='replace')
    STATUS_DESC = {'FILED': '已立案', 'JUDGEMENT': '已判决', 'EXECUTED': '已执行', 'CLOSED': '已结案', 'NONE': '未启动'}
    result = pd.read_sql_query("SELECT loan_id, write_off_date, write_off_amount, legal_action FROM write_offs", conn)
    for _, r in result.iterrows():
        desc = STATUS_DESC.get(str(r['legal_action']), '未知')
        print(f"loan_id={r['loan_id']}  核销日:{r['write_off_date']}  金额:{float(r['write_off_amount']):.2f}  法律追偿:{r['legal_action']}({desc})")
    conn.close()