AWK get value of second column only if the value in first is less
than in previous line+last line:
awk '{ if(prev>$1) {print prev,prev13;}; prev=$1; prev13=$13; } END
{print $1,$13;}' res-140--400-.dat-sort.dat
AWK get value of second column only if the value in first is less
than in previous line: awk '{ if(prev>$1) {print prev,prev13;};
prev=$1; prev13=$13;}' res-140--400-.dat-sort.dat
Using bash variables in AWK: for i in
{0.6,0.62,0.64,0.66,0.68,0.7,0.72,0.74,0.76,0.78,0.80,0.82,0.84,0.86,0.88,0.90,0.92,0.94,0.96,0.98,1.0};
do awk -v i="$i" '{if ($1 == i) {sum+=$2; N+=1} } END { print
i,sum/N}' res.csv; done
Simple average: awk '{sum+=$2; N+=1} END { print N, sum/N}' file.dat