Search Results

Hi,

I have 5 files with two columns. I need to merge all the 5 files based on column 1. If any of them are missing then corresponding 2nd column should be substituted by missing value.

I know...

thank you Srini and vgersh99. Both of your codes worked.

Thanks vgersh99. It was for Srini.

Your code worked. but I need the enriched and repressed results column to be tab delimited rather than space.

Thanks for the email. When I apply it to real data I see only one column with no. Also all the values are no. I should be seeing 2 columns one for enriched and one for repressed where it says(yes no)...

I tried it for a single file search and was not successful

awk 'NR==FNR{keys[$1]; next} {for (key in keys) if ($0 ~ key) {print FILENAME, $0; next} }' file1.txt file3.txt >output.txt

Hi

I have 3 files in total. file 1 is enriched.txt file2 is repressed.txt and file 3 is my content.txt

What i need is query the content file against both enriched and repressed and wherever...

Thanks Corona. It worked.

Ok. When I change it to !=NA then it performs the replace but where it has NA in specific columns it has to turn blank or should be NA only. but that not happening.

Thanks for the command. but when i use this my output file is same as input file. I does not perform the replace

Hi,

I have a file with 1st column to be gene symbols and rest of the columns its expression value. for each gene symbol if the value if other than NA replace it with the gene symbol

input file:...

Sorry I messed up something at my end. Thanks I check few rows and it worked perfectly fine.

Thanks,

I tried that

It gives the following error

TN_rpkm: line 919: linc-TMEM183B-1: command not found
TN_rpkm: line 920: linc-PRELP: command not found

Thanks,

The order does not matter. I tried with my data and it did not work. Here is my original data

Hi,

I have a file with 1M records


ABC 200 400 2.4 5.6
ABC 410 299 12 1.5
XYZ 4 5 6 7
MNO 22 40 30 70
MNO 47 55 80 150

What I want is for all the rows it should take the max value...

Thanks Chubler_XL. It worked as I wanted.(did not change the order and the output is tab delimited). thanks again.

Thanks Yoda. It worked but the output is not tab delimited and also it changed the columns order. Can I get it in tab delimited format?

---------- Post updated at 12:51 PM ---------- Previous...

Hi,

I want to write a script which will add the entries in all columns for the same column id. I can do it in excel, but I need to do this for 384 columns which will come down to 96 (384/4). How...

Thanks, It worked. I really don't mind about the colon.

Hi,

I have two files A (2190 rows) and file B (1100 rows). I want to merge the contents of two files based on common field, also I need the unmatched rows from file A

file A:

ABC
XYZ
PQR
...

Thanks,

But grep -f is pulling the whole file out and writing to output instead of just the matching one's. So I used the xargs. but xargs does not give me any output. Below is the code that I...

Hi,

I want to grep multiple patterns from multiple files and save to multiple outputs. As of now its outputting all to the same file when I use this command.

Input : 108 files to check for 390...

Thanks Carlo. It worked..

Thanks for the reply.

Nope I want to change the directory name and also the filename in the directory to the names I have in sample_info_file.txt

My sample_info_file.txt has two columns one...

Hi,

I have a directory with 100 subdirectories and each of these subdirectories has 1 file. Now I have to rename all these.

The structure is "files directory has 100 SRR191639-SRR191718...

Hi,

I have a file with 25 clusters and each cluster has multiple rows. I need to find the unique genes in each cluster and assign them

Annotation Cluster 2 Enrichment Score:...