查询催收员的待催收账户列表

def solve():
    from pyodide.http import open_url
    clients_csv = open_url("https://data.zuihe.com/dbd/credit/state_04/clients.csv").read()
    loans_csv = open_url("https://data.zuihe.com/dbd/credit/state_04/loans.csv").read()
    loan_repayment_schedule_csv = open_url("https://data.zuihe.com/dbd/credit/state_04/loan_repayment_schedule.csv").read()
    loan_charges_csv = open_url("https://data.zuihe.com/dbd/credit/state_04/loan_charges.csv").read()
    import sqlite3, pandas as pd
    from io import StringIO
    conn = sqlite3.connect(':memory:')
    pd.read_csv(StringIO(loans_csv)).to_sql('loans', conn, index=False, if_exists='replace')
    overdue = pd.read_sql_query("SELECT outstanding_balance FROM loans WHERE days_in_arrears > 0", conn)
    def assign(bal):
        if bal >= 1000000: return 'collector_A'
        elif bal >= 100000: return 'collector_B'
        else: return 'collector_C'
    overdue['collector'] = overdue['outstanding_balance'].apply(assign)
    summary = overdue.groupby('collector').agg(account_count=('outstanding_balance','count'), total_balance=('outstanding_balance','sum')).reset_index()
    print(summary.to_string(index=False))
    conn.close()