← 返回题库
中级

实现数据迁移一致性验证

未完成
中级参考 代码结构已给出,请填写 ____ 处
def solve():
    from pyodide.http import open_url
    from io import StringIO
    orders_csv = open_url(____).read()
    order_items_csv = open_url(____).read()
    import pandas as pd, hashlib, json
    from io import StringIO
    orders = pd.read_csv(StringIO(____))
    items = pd.read_csv(StringIO(____))
    def compute_checksum(____):
        df_sorted = df.sort_values(____).reset_index(____)
        content = df_sorted.to_json(____)
        return hashlib.sha256(content.encode()).hexdigest()[:____]
    source_order_cksum = compute_checksum(____)
    source_items_cksum = compute_checksum(____)
    migrated_orders = orders.copy()
    migrated_items = items.copy()
    migrated_orders['____'] = ____
    target_order_cksum = compute_checksum(migrated_orders.drop(____))
    target_items_cksum = compute_checksum(____)
    print(____)
    print(____)
    print(____)
    print(____)
    print(____)
    print(____)
    print(____)

示例

输入
solve()
期望输出
数据迁移验证:
  orders: source=8600f4183781ee0d, target=8600f4183781ee0d
  orders checksum match: True
  items: source=7256733936067957, target=7256733936067957
  items checksum match: True
  row counts: orders 20==20: True
  row counts: items 40==40: True
Python 代码 🔒 登录后使用
🔒

登录后即可练习

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