in reply to average a column in tab-delimited file

What have you tried? How would you do it on paper? When you do it on paper what are the steps you actually follow?

Are the rows sorted by column 3, or at least are all the matching rows adjacent? What value does column 1 get for the combined rows? Are the contents of the remaining columns really invariant?

True laziness is hard work
  • Comment on Re: average a column in tab-delimited file