← 返回题库
初级

加载厨师信息并关联菜谱

未完成
初级参考 完整示例代码供参考,建议自己理解后重新输入
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    chefs=pd.read_csv(StringIO(open_url("https://data.zuihe.com/dbd/ms-mealhub/state_00/chefs.csv").read()))
    menus=pd.read_csv(StringIO(open_url("https://data.zuihe.com/dbd/ms-mealhub/state_01/menus.csv").read()))
    print(f"Chefs: {len(chefs)}")
    for _,c in chefs.iterrows():
        menu_count=len(menus[menus['published_by']==c['chef_id']])
        print(f"  {c['name']}({c['specialty']}): {menu_count} menus published")

示例

输入
solve()
期望输出
Chefs: 5
  张厨长(家常菜): 1 menus published
  王大厨(家常菜): 2 menus published
  李师傅(粤菜): 0 menus published
  刘主厨(川菜): 1 menus published
  陈料理长(家常菜): 0 menus published
Python 代码 🔒 登录后使用
🔒

登录后即可练习

注册免费账号,在浏览器中直接运行 Python 代码