Hello there,

I found an elegant solution to computing average values from multiple text files

Code:

awk '{for (i=1;i<=NF;i++){if ($i!~"n/a"){a[FNR""i]+=$i}else{b[FNR""i]++}}}END{for (i=1;i<=FNR;i++){for (j=1;j<=NF;j++){printf (a[i""j]/(3-b[i""j]))((b[i""j]>0)?"~"b[i""j]" ":" ")};printf "\n"}}' file1 file2 file3

I tried to modify the code to get the standard deviations along with the averages, but without success.

I have 3 files with two columns and 10 rows each. I'd like to calculate averages and standard deviations and write them into the new file with 4 columns and 10 rows, where first two columns are the averages calculated from 3 files and the last two columns are the corresponding standard deviations.

Here is an example of the input/output files:

input1.txt

Code:

8.5607309334335007 9
8.8632036168606803 112
.
.
.

input2.txt

Code:

8.3999948195361487 15
8.6903391660951304 166
.
.
.

input3.txt

Code:

8.649238358457044 46
9.0008044868119814 365
.
.
.

---

output.txt

Code:

8.5  23    0.1  20      
8.8  198  0.1  145  
.
.
.

Could you please help me modifying the code? I am new to awk and to this forum as well. Thanks a lot in advance!

Moderator's Comments:

Please use code tags next time for your code and data.