On Wed, Oct 25, 2017 at 12:08 PM, Robert Arkiletian <robark at gmail.com> wrote: > On Wed, Oct 25, 2017 at 9:59 AM, Robert Arkiletian <robark at gmail.com> wrote: >> On Wed, Oct 25, 2017 at 9:41 AM, Mark Haney <mark.haney at neonova.net> wrote: >>> On 10/25/2017 12:33 PM, Robert Arkiletian wrote: >>>> >>>> here is a python solution >>>> #!/usr/bin/python >>>> #python 2 (did not check if it works) >>>> f=open('yourfilename') >>>> D={} >>>> for line in f: >>>> email,num = line.split() >>>> if email in D: >> >>>> D[email] = D[email] + int(num) >> >>>> else: >> >>>> D[email] = int(num) >> >>>> f.close() > > not to be outdone, python can sort them based on the totals > > for k in sorted(D, key=d.get, reverse=True): oops. that's a capital D.get for k in sorted(D, key=D.get, reverse=True): > print k, D[k]