in reply to compare values while value on other column remains the same

What output do you expect from the given sample data? I do not understand the specification.

Note that eof returns 0 or 1 if used as a number, so $i < eof will not do what you think.

Replies are listed 'Best First'.
Re^2: compare values while value on other column remains the same
by linseyr (Acolyte) on Sep 21, 2012 at 19:47 UTC
    Actually, my output would be: 
    $chr $begin $end $id $average

    [download]
    But I just wanted to start with calculating. I would like to calculate the average difference between the 2 columns (5 and 6) for the same id. So for line 3,4,5 I would like to calculate the average difference between column 5 and 6. And for the lines for which only one line has that id, like line 1 I just want to calculate the difference between column 5 and 6, since there is no average to calculate. I only want to output the lines that have a average difference > 0.2
[reply]
[d/l]

In Section Seekers of Perl Wisdom