统计AI生成结果审核状态

def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    results=pd.read_csv(StringIO(open_url("https://data.zuihe.com/dbd/ms-memcard/state_01/generation_results.csv").read()))
    print(f"Total results: {len(results)}")
    print(f"By status: {dict(results.groupby('status').size())}")
    approved=len(results[results['status']=='approved'])
    total_decided=len(results[results['status'].isin(['approved','rejected'])])
    print(f"Approval rate: {approved}/{total_decided} ({round(approved/total_decided*100,1) if total_decided>0 else 0}%)")
    print(f"Avg quality score: {round(results['quality_score'].mean(),3)}")
    for status,grp in results.groupby('status'):
        print(f"  {status}: count={len(grp)} avg_quality={round(grp['quality_score'].mean(),3)}")