交付：五条验收条款一起过

👁️ 2 人浏览 💬 0 人评论 ❤️ 添加收藏

run(text, by) 已经给好：交回 (退出码, 结果文本, 报告)。补全五条验收：正常退出码 0、结果 4 行、报告说跳过第 7 行、打不开交回 4、缺列交回 6。输出五个 1/0。

提交你的答案

请登录后提交答案。

去登录

← 第四步：接上 main 一批文件和一个文件差在哪 →

更多题目

代码编辑器

语言： Ctrl + Enter 运行

import csv, io

SALES = ("date,store,item,qty,price\n2026-09-01,东门,包子,10,2\n2026-09-01,东门,豆浆, 8 ,3\n2026-09-01,西门,油条,,2.5\n2026-09-01,西门,包子,10,2\n2026-09-01,东门,包子,10,2\n2026-09-02,北门,豆浆,five,3\n2026-09-02,北门,油条,4,2.5\n2026-09-02,西门,豆浆,6,3\n")
NEED = {"date", "store", "item", "qty", "price"}

def clean(rows):
    good, bad, seen = [], [], set()
    for i, r in enumerate(rows, 2):
        r = {k: v.strip() for k, v in r.items()}
        r["qty"] = r["qty"] or "0"
        key = tuple(r.values())
        if key in seen:
            continue
        seen.add(key)
        try:
            r["qty"], r["price"] = int(r["qty"]), float(r["price"])
        except ValueError:
            bad.append(i)
            continue
        good.append(r)
    return good, bad

def run(text, by):
    if text is None:
        return 4, "", ""
    rows = list(csv.DictReader(io.StringIO(text)))
    if not rows or not NEED <= set(rows[0]):
        return 6, "", ""
    good, bad = clean(rows)
    t = {}
    for r in good:
        t[r[by]] = t.get(r[by], 0) + r["qty"] * r["price"]
    buf = io.StringIO()
    w = csv.DictWriter(buf, fieldnames=[by, "total"], lineterminator="\n")
    w.writeheader()
    w.writerows([{by: k, "total": v} for k, v in t.items()])
    rep = "处理" + str(len(good)) + "行，跳过" + str(len(bad)) + "行：" + ",".join(str(b) for b in bad)
    return 0, buf.getvalue(), rep

code, text, rep = run(SALES, "store")
# TODO: c1 code == 0
c1 = 0
# TODO: c2 结果 4 行（含表头）
c2 = 0
# TODO: c3 报告以 "：7" 结尾
c3 = 0
# TODO: c4 run(None, "store")[0] == 4
c4 = 0
# TODO: c5 run("date,store\na,b\n", "store")[0] == 6
c5 = 0
print("".join(str(int(c)) for c in (c1, c2, c3, c4, c5)))

本次输入：

输出：

👩‍🏫

💬 题目评论

交付：五条验收条款一起过

更多题目

全部评论