import csv
from collections import OrderedDict
groups = OrderedDict()
with open("topics.csv", encoding="utf-8-sig", newline="") as f:
reader = csv.DictReader(f)
required = {"topic", "question", "source"}
if not required.issubset(reader.fieldnames or []):
raise ValueError("缺少 topic、question 或 source 列")
for number, row in enumerate(reader, start=2):
values = {key: " ".join((row.get(key) or "").split())
for key in required}
if not all(values.values()):
raise ValueError(f"第 {number} 行存在空字段")
item = (values["question"], values["source"])
bucket = groups.setdefault(values["topic"], [])
if item not in bucket:
bucket.append(item)
if not groups:
raise ValueError("没有可整理的资料")
# x 模式避免覆盖已经存在的提纲文件
with open("briefs.md", "x", encoding="utf-8") as f:
for topic, items in groups.items():
f.write(f"# {topic}\n\n")
f.write("读者与页面任务:待人工确认\n\n")
for question, source in items:
f.write(f"- 问题:{question}\n 资料:{source}\n")
f.write("\n事实、适用条件与缺少资料:待人工核验\n\n")