Hi all,
I am reading a file with >5M records and with about 15 fields (variables).
I am interested in two of the fields (ID and Flag) and then two fields look
like the following. The first field (ID) is alpha-numeric and the second field
is numeric 0 or 1. My goal is to count the number of 0's and 1's by unique ID
A123 0
A123 0
A123 0
A123 1
A123 1
A123 1
A123 0
A123 0
A123 0
A123 0
A123 1
A123 0
A123 0
A124 0
A124 0
A124 1
A124 1
A124 1
A124 1
A124 0
A124 1
A124 0
A124 0
A124 1
A124 0
A124 1
A124 0
A124 0
A125 0
A125 0
A125 1
A125 1
A125 1
A125 1
A125 0
A125 0
A125 0
A125 0
A125 0
A125 0
A125 1
A125 0
awk '{print $1, $2}' file1 |sort |uniq -c
and got this
9 A123 0
4 A123 1
8 A124 0
7 A124 1
9 A125 0
5 A125 1
Now I want the result to be transposed like this or the
desired output,
A123 9 4
A124 8 7
A125 9 5
I would appreciate if you help me out to get the desired result
thank you in advance