UNIX for Dummies Questions & Answers

Hi all,

I have a problem hoping someone can help me.
I have this spreadsheet :

PC.333 PC.444 PC.555 PC.666 PC.777



0 0 1 0 0 Bacteria Bacteroidetes Bacteroidia Bacteroidales

8 4 1 0 6 Bacteria Bacteroidetes Bacteroidia Firmicutes


0 0 8 0 0 Bacteria Bacteroidetes Bacteroidia Bacteroidales

.......




These are all separate columns and rows. The first 5 (PC.333,PC.444...) are patients and under them every number represents the number of Bacteria that the patient presents referred to the row.

I need to merge togheter the fields regarding Bacteria but without loosing the count of them for every patients. In other words I need to delete duplicate but sum before for the patients the numbers. So do not miss anything. Is there any possibilities ?! The file is very big and I would like to avoid doing it manually.

Please help Me ! Thank you in advance

Code:

$ cat bacteria.awk

NR==1 { print ; next }

{
        B="";   for(N=6; N<=NF; N++) B=B" "$N;  B=substr(B,2);

        A[B]++;

        for(N=1; N<=5; N++) T[B,N]+=$N;
}

END {
        for(B in A)
        {
                L=""
                for(N=1; N<=5; N++)     L=L" "T[B,N];

                print substr(L, 2), B;
        }
}

$ awk -f bacteria.awk data

PC.333 PC.444 PC.555 PC.666 PC.777
0 0 9 0 0 Bacteria Bacteroidetes Bacteroidia Bacteroidales
8 4 1 0 6 Bacteria Bacteroidetes Bacteroidia Firmicutes

$

Thank you very much Corona !!!