Unix addition ( Row wise)

gauravgoel · #1 (**permalink**) 05-17-2007

Hi

I have a file like

a,1
b,2
d,3
a,2
b,3
c,7

Result Desired:
a,3
b,5
d,3
c,7

i.e on the bases of 1st field the addition is done of the 2nd field and result printed out.

Thanks

Unbeliever · #2 (**permalink**) 05-17-2007

If output order is not a problem this simple perl script will do:

Code:

while(<>)
{
  chomp;
  @a= split(/,/);
  $sum{$a[0]} += $a[1];
}

foreach $key (keys %sum)
{
  print "$key,$sum{$key}\n";
}

ghostdog74 · #3 (**permalink**) 05-17-2007

Code:

awk 'BEGIN{FS=","}
{ array[$1]+=$2 }
END{
for (i in array) print i,array[i] 
}' "file"

Unbeliever · #4 (**permalink**) 05-17-2007

If order is an issue

Code:

while(<>)
{
  chomp;
  @a= split(/,/);
  push (@order,$a[0]) if (!$sum{$a[0]});
  $sum{$a[0]} += $a[1];
}

foreach $key (@order)
{
  print "$key,$sum{$key}\n";
}

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
processing matrix column wise	Abhishek Ghose	Shell Programming and Scripting	5	08-21-2007 12:55 PM
Paste coulmn wise	er_aparna	Shell Programming and Scripting	3	06-26-2006 04:16 AM
Addition of numbers in unix	asinha63	Shell Programming and Scripting	3	03-14-2006 12:38 PM
An addition for UNIX books to read	kduffin	I'm new to Unix. Which books should I read?	0	11-17-2003 02:46 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by