counting the data in column

anjas · #1 (**permalink**) 07-02-2009

Hi power user,

I have data as follows

aa bb
bb aa
aa bb
bb aa
bb cc
cc bb
bb cc
zz ll
ll zz
zz ll

and I want the output to be like this:

aa bb 4
cc bb 3
zz ll 3

So, althrough the data in the column are arranged in a different order, they will be considered the same data. Is there any awk script which could do that? Tx

vgersh99 · #2 (**permalink**) 07-02-2009

What have you tried so far?

anjas · #3 (**permalink**) 07-03-2009

sort file |uniq -c doesn't seems to give that output, since it considered aa bb and bb aa as a different kind of data. I need a script to consider them as the same kind of data.

vgersh99 · #4 (**permalink**) 07-03-2009

ok, how far have you gotten with the script implementation?

anjas · #5 (**permalink**) 07-03-2009

So, this what I do. The content of the file is as follow:

try.txt

aa bb
bb aa
aa bb
bb aa
bb cc
cc bb
bb cc
zz ll
ll zz
zz ll

I did the usual sort command:

sort try.txt |uniq -c > try.sort

The content of try.sort is:
2 aa bb
2 bb aa
2 bb cc
1 cc bb
1 ll zz
2 zz ll

What I need is the output to be like this
aa bb 4
cc bb 3
zz ll 3
I think, the script should included, how to switch the data in the same order. For example:

zz ll
ll zz
zz ll

should be changed to
zz ii
zz ii
zz ii

Is there any clue for it? Tx

vgersh99 · #6 (**permalink**) 07-03-2009

nawk -f an.awk myFile

an.awk:

Code:

{idx1=$1 OFS $2; idx2=$2 OFS $1}
{a[(idx2 in a)?idx2:idx1]++}
END { for (i in a) print i, a[i] }

anjas · #7 (**permalink**) 07-03-2009

Tx..It works as expected..

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Append the data to first column	ravi_rn	Shell Programming and Scripting	2	06-02-2009 01:08 PM
alter data in column	tintin72	UNIX for Dummies Questions & Answers	2	04-02-2009 07:40 AM
remove a column of data	jdhahbi	Shell Programming and Scripting	1	01-22-2009 09:29 PM
Need to get the first column of data	bobk544	Shell Programming and Scripting	3	08-04-2007 04:35 PM
Column data reading	FarhanNaseer	Shell Programming and Scripting	1	09-19-2005 12:02 AM

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