← 返回题库
初级

检查订餐数据必填字段完整性

未完成
初级参考 完整示例代码供参考，建议自己理解后重新输入 
def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd
    orders=pd.read_csv(StringIO(open_url("https://data.zuihe.com/dbd/ms-mealhub/state_02/meal_orders.csv").read()))
    REQUIRED=['order_id','employee_id','menu_item_id','meal_date','meal_type','status','price']
    print("Order data integrity:")
    for field in REQUIRED:
        nulls=orders[field].isna().sum() if field in orders.columns else len(orders)
        print(f"  {field}: {'OK' if nulls==0 else f'ISSUES:{nulls}'} ({len(orders)-nulls}/{len(orders)})")
    invalid_status=orders[~orders['status'].isin(['active','cancelled','served'])]
    print(f"  Invalid status: {len(invalid_status)}")

示例

输入
solve()
期望输出
Order data integrity:
  order_id: OK (2387/2387)
  employee_id: OK (2387/2387)
  menu_item_id: OK (2387/2387)
  meal_date: OK (2387/2387)
  meal_type: OK (2387/2387)
  status: OK (2387/2387)
  price: OK (2387/2387)
  Invalid status: 0
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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

登录 免费注册