Awk Notes: Difference between revisions

From Federal Burro of Information
Jump to navigationJump to search
No edit summary
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
I love you awk
I love you awk


standard deviation with awk:
== standard deviation with awk ==


<pre>
<pre>
Line 10: Line 10:
</pre>
</pre>


 
where file.dat is one column of numbers.
```
    awk '{for(i=1;i<=NF;i++) {sum[i] += $i; sumsq[i] += ($i)^2}}
          END {for (i=1;i<=NF;i++) {
          printf "%f %f \n", sum[i]/NR, sqrt((sumsq[i]-sum[i]^2/NR)/NR)}
        }' file.dat >> aver-std.dat
```
 


[[Category:Computers]]
[[Category:Computers]]

Latest revision as of 15:40, 2 November 2022

I love you awk

standard deviation with awk

    awk '{for(i=1;i<=NF;i++) {sum[i] += $i; sumsq[i] += ($i)^2}} 
          END {for (i=1;i<=NF;i++) {
          printf "%f %f \n", sum[i]/NR, sqrt((sumsq[i]-sum[i]^2/NR)/NR)}
         }' file.dat >> aver-std.dat

where file.dat is one column of numbers.