统计证书发放数量与课程分布

def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    csv_data = open_url('https://data.zuihe.com/dbd/ms-edulive/state_04/certificates.csv').read()
    df = pd.read_csv(StringIO(csv_data))
    print(f'证书总数: {len(df)}')
    result = df.groupby('course_id').size().sort_values(ascending=False)
    for course, count in result.head(5).items():
        print(f'{course}: {count}张')