← 返回题库
初级

统计菜品价格分布与热销排行

未完成
初级参考 完整示例代码供参考,建议自己理解后重新输入
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    dishes=pd.read_csv(StringIO(open_url("https://data.zuihe.com/dbd/ms-takeaway/state_00/dishes.csv").read()))
    print(f"Total dishes: {len(dishes)}")
    print(f"By status: {dict(dishes.groupby('status').size())}")
    print(f"Avg price: {round(dishes['price'].mean(),2)}")
    print("Top 5 dishes by monthly sales:")
    for _,r in dishes.nlargest(5,'monthly_sold')[['name','monthly_sold']].iterrows():
        print(f"  {r['name']}: {r['monthly_sold']}")

示例

输入
solve()
期望输出
Total dishes: 75
By status: {'off': np.int64(3), 'on': np.int64(72)}
Avg price: 27.11
Top 5 dishes by monthly sales:
  羊肉片: 778
  口水鸡: 777
  番茄鸡蛋盖饭: 769
  牛肉面: 744
  卤肉饭: 723
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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