Create a gist now

Instantly share code, notes, and snippets.

anonymous /
Created Oct 10, 2012

What would you like to do?
#!/usr/bin/env python
import re
import fileinput
stats = {}
totals = {}
for line in fileinput.input():
line = line.strip()
m = re.match('^"(\d{4})-.+organizations/(.+)>$', line)
if not m:
print "uhoh: %s" % line
year, inst = m.groups()
s = stats.get(year, {})
s[inst] = s.get(inst, 0) + 1
stats[year] = s
totals[inst] = totals.get(inst, 0) + 1
years = stats.keys()
institutions = totals.keys()
institutions.sort(lambda a, b: cmp(totals[b], totals[a]))
print "year\t", "\t".join(institutions)
for year in years:
print year,
for inst in institutions:
print "\t", stats[year].get(inst, 0),
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment