UNIX for Dummies Questions & Answers

Dear all ...
I have a file which I want to change the structure based on the values in some columns and I would be grateful if you can help...
one of my files looks like ... they all have ten rows

Code:

1,0,0
10,0,0
2,0,0
3,0,0
4,1,1
4,1,1
4,1,1
5,0,0
6,0,0
7,0,0
8,0.5,2
9,0.33,3
9,0.33,3

what I was to get is

Code:

1,0
10,0
2,0
3,0
4,3
5,0
6,0
7,1.63 #(0.33*2)+0.5
8,1.63 #(0.33*2)+0.5
9,0.66 #(0.33*2)

So what is happening is if value is not 0 the value in $2 is being published in rows that are between [$1-$3+1, $1] which means for "9,0.33,3", 0.33 is published 3 times in rows 7,8 and 9... else the value stays 0

I have managed to combine the values to combine the multiple row of the same values

Code:

awk -F, '{a[$1]+=$2;} END {for(i in a )  print i","a[i]","}'

so my data now looks like

Code:

1,0,
10,0,
2,0,
3,0,
4,3,
5,0,
6,0,
7,0,
8,0.5,
9,0.666666,

so not sure how to implement get the final row and distribute the values correctly

Can you help

A for loop covers the range [$1-$3+1...$1].

Code:

awk -F, '{for (i=$1-$3+1; i<=$1; i++) {a[i]+=$2}} END {for(i=1; i<=10; i++)  print i","a[i]+0}'

In this implementation the rows with 0 are not defined in the array.
Knowing the number is always 10, one can loop thru 1...10 and cast a missing value to 0 by adding a 0.