import openpyxl, sys, io, collections
sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8', errors='replace')
wb = openpyxl.load_workbook(r"D:\workbbbbbb\workb\杭州机构表.xlsx", data_only=True)
ws = wb.worksheets[0]
rows = list(ws.iter_rows(min_row=2, values_only=True))
print("total rows:", len(rows))
by = collections.defaultdict(list)
for code, name, lvl1, lvl2, note in rows:
    by[(lvl1, lvl2)].append((code, name))
for k, v in by.items():
    print(f"### {k[0]} / {k[1]}  ({len(v)}个)")
    print("   " + " | ".join(f"{c}:{n}" for c, n in v))