#!/usr/bin/python3
import json
data = json.load(open('cmp-ed.json'))
datacols = range(2, len(data["fields"]))
# Index results by tool
results = { t:[] for t in range(0, len(data["tools"])) }
for l in data["results"]:
  results[l[1]].append(l)
# Sum columns for each tool, and display them as a table
print("%-18s &" % "tool", "count &",
      " & ".join(data["fields"][2:]), "\\\\")
for i in range(0, len(data["tools"])):
  sums = [("%6.2f" if j == 9 else "%6d") % (sum([x[j] for x in results[i]]))
          for j in datacols]
  print("%-18s & %3d & " % (data["tools"][i], len(results[i])),
        " & ".join(sums), "\\\\")