in reply to Re: compare values while value on other column remains the same
in thread compare values while value on other column remains the same
So I have again the same id's on multiple lines and different values on columns 2-9. I want for one ID get the average of columns 2-9. So for that input file that would be:cg12045430 43 16 6 44 23 63 24 77 cg12045430 43 16 6 44 23 63 24 80 cg12045430 43 16 6 44 23 63 24 45 cg12045430 43 16 6 44 23 115 24 77 cg12045430 43 16 6 44 23 115 24 80 cg12045430 43 16 6 44 23 115 24 45 cg12045430 43 16 6 44 23 29 24 77 cg12045430 43 16 6 44 23 29 24 80 cg12045430 43 16 6 44 23 29 24 45
And afterwards I want to calculate the difference between column 2,3 and 4,5 and 6,7 and 8,9 like before. I tried to do it using your code and for every key calculate the average of the map, but it didn't work. Could you give me some advise? Thanks!cg12045430 43 16 6 44 23 69 24 67
|
|---|