Munge scores for DEF CON 25 CTF

scoremunge.py

import csv
import json

with open('scores.csv') as f:
    rows = [(int(row['id']), json.loads(row['payload'])) for row in csv.DictReader(f)]
    rows.sort()

with open('scores_clean.csv', 'w') as outf:
    csvf = csv.writer(outf)
    team_names = [s['display_name'].encode('utf8') for s in sorted(rows[0][1], key=lambda s: s['id'])]

    csvf.writerow(['round_no'] + team_names)
    for roundno, payload in rows:
        csvf.writerow([str(roundno)] + [s['score'] for s in sorted(payload, key=lambda s: s['id'])])