Column sum group by uniq records

Nayanajith · #1 (**permalink**) 01-26-2008

Dear All,

I want to get help for below case.
I have a file like this.

saman 1
gihan 2
saman 4
ravi 1
ravi 2

so i want to get the result,

saman 5
gihan 2
ravi 3 like this.

Pls help me.

Thank you.

KevinADC · #2 (**permalink**) 01-27-2008

What have you tried so far?

jaduks · #3 (**permalink**) 01-27-2008

This can be done using associative array in awk.

Code:


$ cat nayan.out
saman 1
gihan 2
saman 4
ravi 1
ravi 2

$ awk '{arr[$1]+=$2} END {for (i in arr) {print i,arr[i]}}' nayan.out > nayan.out.tmp

$ cat nayan.out.tmp
ravi 3
saman 5
gihan 2

//Jadu

Nayanajith · #4 (**permalink**) 01-28-2008

Dear Jadu,

Thank u ! it is working.

Thanks you again,

Nayanajith.

sandeep13 · #5 (**permalink**) 02-16-2009

Hi Jadu,

I am new to unix and i have a similar requirement given below:

Input file:

Test.txt
PORT; ID; TOTAL
port1;p1;100000
port2;p2;5000
port1;p1;500

Output file:
PORT; ID; TOTAL
port1;p1; 100500
port2;p2; 5000

How can achive this? Any help on this regard is higly appreciated.
Thanks.

Regards,
Sandeep

ranjithpr · #6 (**permalink**) 02-16-2009

Try below script ( Not tested)

Code:

awk -F ";" '{ arr[$1 ";" $2] += $3 } END {for (i in arr) {print i ";" arr[i] } }' inputfile

sandeep13 · #7 (**permalink**) 02-16-2009

Hi Ranjith,
Thanks for the reply but this doesn't work....can we use like arr[$1 ";" $2]???

Regards,
Sandeep

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Monkcast #12: IBM HW group OEMs Solaris to chagrin of SW group & a ... - ZDNet.com bl	iBot	UNIX and Linux RSS News	0	08-17-2007 04:30 PM
Count No of Records in File without counting Header and Trailer Records	guiguy	Shell Programming and Scripting	2	06-07-2007 12:15 PM
find and group records in a file	thumsup9	UNIX for Advanced & Expert Users	20	04-19-2007 05:04 PM
Select records based on search criteria on first column	shashi_kiran_v	UNIX for Dummies Questions & Answers	2	12-02-2005 01:49 PM
entry in /etc/group too long - problem using sudo with %group	poli	SUN Solaris	4	12-21-2004 09:50 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: