← 返回题库
初级

统计员工餐费账户余额分布

未完成
初级参考 完整示例代码供参考，建议自己理解后重新输入 
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    emp=pd.read_csv(StringIO(open_url("https://data.zuihe.com/dbd/ms-mealhub/state_00/employees.csv").read()))
    print("Meal balance stats:")
    print(f"  Total employees: {len(emp)}")
    print(f"  Avg balance: {round(emp['meal_balance'].mean(),2)}")
    print(f"  Zero balance: {len(emp[emp['meal_balance']==0])}")
    print(f"  High balance (>300): {len(emp[emp['meal_balance']>300])}")
    by_role=emp.groupby('role')['meal_balance'].mean().round(2)
    print("  Avg by role:")
    for role,avg in by_role.items(): print(f"    {role}: {avg}")

示例

输入
solve()
期望输出
Meal balance stats:
  Total employees: 80
  Avg balance: 279.42
  Zero balance: 0
  High balance (>300): 35
  Avg by role:
    director: 427.66
    intern: 303.69
    manager: 285.75
    staff: 269.88
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册