加载菜谱并分析发布状态

def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    menus=pd.read_csv(StringIO(open_url("https://data.zuihe.com/dbd/ms-mealhub/state_01/menus.csv").read()))
    print(f"Total menus: {len(menus)}")
    print(f"By status: {dict(menus.groupby('status').size())}")
    published=menus[menus['status']=='published']
    print(f"Published: {len(published)}")
    for _,m in published.iterrows():
        print(f"  {m['menu_id']}: {m['week_start']} ~ {m['week_end']} published_at={m['published_at']}")