Hello !I have a big file containing a number of spots, a positition and a set of coordinates.
no pos/neg cordinates
1 + 1 3
2 + 5 8
3 - 10 12
What I want to do is first to convert the length of intervals to point ( 1-3 -> to 1 2 3 )
next in a new column for each time that I have (+) to add 1, -1 when I have (-) and zero 0 when I am outside of the coordinate and in another column to have the sum of the second column as the table below
> 1 1 1
> 2 1 2
> 3 1 3
> 4 0 3
> 5 1 4
> 6 1 5
> 7 1 6
> 8 1 7
> 9 0 7
> 10 -1 -6
> 11 -1 -5
> 12 -1 -4
Is it any package to do this or any idea how can I generate this table?
Thanks in advance