On 10/25/2017 12:41 PM, Mark Haney 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] + num
>> else:
>> D[email] = num
>> f.close()
>> for key in D:
>> print key, D[key]
>> _______________________________________________
> That gets me closer, I think. It's concatenating the number of
> messages, but it's a start. Thanks.
>
I do this kind of thing on a fairly regular basis with a Perl one-liner:
perl -ne '($email, $num) = split; $tot{$email} += $num; END { for $email
(keys %tot) { print "$email $tot{$email}\n" } }' < yourfile
--
Bowie