awk '{array[$1]+=$3} END { for (i in array) {print i"," array[i]}}' datas.csv
This function aggregates the rows with similar [$1","$2] combinations
and output the sum
e.g Say-Tar DNA-FISH 35
Say-Tar C2C12 24
Say-Tar C2C12 3
Georgi Gro-seq 5
Georgi ChIP-seq 7
Brian iPSC 24
Then the output should be
Say-Tar, DNA-FISH, 35
Say-Tar, C2C12, 27
Georgi, Gro-seq, 5
Georgi, ChIP-seq, 7
Brian, iPSC, 24
No comments:
Post a Comment