Following a suggestion from @tripleee, I’m posting another question for a coding issue I’m having trying to be more specific with sources and expected results. My source .txt file is quite over populated with lines and using AWK, I: extract only rows identified by a specific code. parse the content of the line in order to get only certain values.
Tag: sum
Find the average of multiple columns for each distinct variable in column 1
Hi I have a file with 6 columns and I wish to know the average of three of these (columns 2,3,4) and the sum of the last two (columns 5 and 6) for each unique variable in column one. I have come across code that will get the average for column 2 based on column one but is there anyway