import csv, filecmp rows=list(csv.DictReader(open('output/action-plan.csv',encoding='utf-8'))) assert list(rows[0].keys())==['action_id','action','owner','due','status','dependencies','source'] ids=[r['action_id'] for r in rows]; assert len(ids)==len(set(ids)) for r in rows: assert None not in r and all(v is not None for v in r.values()), r for k in ['action','owner','due','status','source']: assert r[k].strip(), (r['action_id'],k) for d in filter(None,r['dependencies'].split(';')): assert d in ids,(r['action_id'],d) assert ids.index(d)