bash - Calculating the sum of every third column from many files -
i have many files 3 columns in form of:
file1 | file2 1 0 1 | 1 0 2 2 3 3 | 2 3 7 3 6 2 | 3 6 0 4 1 0 | 4 1 3 5 2 4 | 5 2 1 first 2 columns same in each file. want calculate sum of 3 columns every file receive this:
1 0 3 2 3 10 3 6 2 4 1 3 5 2 5 for 2 files awk 'fnr==nr { _a[fnr]=$3;} nr!=fnr { $3 += _a[fnr]; print; }' file* work (i found solution via google). how change on many files?
since first 2 columns same in each file:
awk 'nr==fnr{b[fnr]=$1 fs $2;}{a[fnr]+=$3}end{for(i=1;i<=length(a);i++){print b[i] fs a[i];}}' file* array a used have cumulative sum of 3rd column of files. array b used 1st , 2nd column values in end, print contents of array a , b
Comments
Post a Comment