Search Results

Never mind, the following AWK code works:


awk -F '\t' '{ for(i=1;i<=NF;i++) total[i]+=$i ; } END { for(i=1;i<=NF;i++) printf "%f ",total[i]/NR ;}'


Header can easily be added with:

...

Hi all,


Does anyone know of an efficient unix script to average each numeric column of a multi-column tab delimited file (with header) with some character columns.



Here is an example...

Thanks Don, I liked your 1st code, just learned something!

I am trying to initialize a file name in bash but not having much luck. For example, one of my bash scripts outputs a file named "FILE_1000G.vcf". I would like to rename FILE to match with the user's...

Nothing wrong with the END block. I edited my post above to outline the problem. Sorry for the trouble.

Works great! Initially it was outputting 40 million rows, but that was my bad because a "." had made its way into the column of data in file2 and file1 had many rows for which $3 was a "."

Works great! Initially it was outputting 80 million rows, but that was my bad because a ".' had made its way into the column of data in file2

Hi


Does anyone know of an efficient way to index a column of data in file2 to print the coresponding row in file1 which corresponds to the data in file2 AND 30 rows preceding and after the row...

That did the trick. One of the text files sent to me must have been processed with a windows machine...

Thanks Rudi, but that didn't produce the desired output RESULT2. BTW, is there a quick way to clean up a file that may have hidden spaces and other sorts of things to make it a clean tab delimited...

Sorry, I forgot to add a step. I have edited my post to reflect this....

I was wondering whether anyone has any idea what is happening here. I'm using simple code to compare 2 tab delimited files based on column 1 values. If the column1 value of file1 exists in file2,...

Sorry vgersh99, my bad. My file3 had some leading spaces which after cleaning up produced the correct output.


Thanks for the code!

------ Post updated at 11:21 AM ------




Do you mind...

Sorry vgersh99, but your code doesn't produce the desired output. Only 2 rows were printed (https://www.unix.com/members/37898.html)

I use conditional operators alot in AWK to print rows from large text files based on values in a certain column. For example:


awk -F '\t' '{ if ($1 == "A" || $1 == "C" ) print $0}' OFS="\t"...

Awesome Rudy, you're a genius :)

Hi everyone,

I need to replace values of column 2 array1 with values of column 2 array2 based on a lookup of column 4 value, but only return a value IF the values in column 1 of BOTH array1 and...

Looks like it works.

RudyC,


Would the following modification to your script be adequate if the input file IN1 was like this instead:

awk 'NR == FNR {REP[$1] = $4; next} $1 in REP && FNR > 1 { $4 = REP[$1];...

Scrutinizer,

Could you please post explanation for the commands.

---------- Post updated at 03:36 PM ---------- Previous update was at 03:28 PM ----------

Scrutinizer or RudiC,

Is there a...

Thanks Scrutinizer, works beautifully !

Hey everyone,

I am trying to extract column values from a column in a tab-delimited text file and overlay them in a 2nd tab-delimited text file using a V-lookup type script in Unix bash.

These...

Awesome drl !Great work, I appreciate all the effort :)

Hey RudiC,

Could you explain the various steps of your code whenever you have time.

Thanks Ravinder, works good!

What if instead of 2 arrays one needs to sum 3 arrays; array1 array2 array3.