Awk Notes: Difference between revisions

From Federal Burro of Information
Jump to navigationJump to search
(New page: I love you awk Category:Computers)
 
No edit summary
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
I love you awk
I love you awk
== standard deviation with awk ==
<pre>
    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
</pre>
where file.dat is one column of numbers.


[[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.