Search Results

Search: Posts Made By: Diya123
1,649
Posted By Diya123
Get both common and missing values from multiple files
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...
1,796
Posted By Diya123
thank you Srini and vgersh99. Both of your codes...
thank you Srini and vgersh99. Both of your codes worked.
1,796
Posted By Diya123
Thanks vgersh99. It was for Srini. Your code...
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.
1,796
Posted By Diya123
Thanks for the email. When I apply it to real...
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)...
1,796
Posted By Diya123
I tried it for a single file search and was not...
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
1,796
Posted By Diya123
Grep for string and substitute if exits with a yes/no
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...
658
Posted By Diya123
Thanks Corona. It worked.
Thanks Corona. It worked.
658
Posted By Diya123
Ok. When I change it to !=NA then it performs the...
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.
658
Posted By Diya123
Thanks for the command. but when i use this my...
Thanks for the command. but when i use this my output file is same as input file. I does not perform the replace
658
Posted By Diya123
Replace only few string
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:...
647
Posted By Diya123
Sorry I messed up something at my end. Thanks I...
Sorry I messed up something at my end. Thanks I check few rows and it worked perfectly fine.

Thanks,
647
Posted By Diya123
I tried that It gives the following error ...
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
647
Posted By Diya123
Thanks, The order does not matter. I tried...
Thanks,

The order does not matter. I tried with my data and it did not work. Here is my original data
647
Posted By Diya123
Identify max value in diff columns for same row
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...
945
Posted By Diya123
Thanks Chubler_XL. It worked as I wanted.(did not...
Thanks Chubler_XL. It worked as I wanted.(did not change the order and the output is tab delimited). thanks again.
945
Posted By Diya123
Thanks Yoda. It worked but the output is not tab...
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...
945
Posted By Diya123
Add all 4 column entries for similar column ids
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...
704
Posted By Diya123
Thanks, It worked. I really don't mind about the...
Thanks, It worked. I really don't mind about the colon.
704
Posted By Diya123
Merge files based on both common and uncommon rows
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
...
11,399
Posted By Diya123
Thanks, But grep -f is pulling the whole...
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...
11,399
Posted By Diya123
Grep from multiple patterns multiple file multiple output
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...
894
Posted By Diya123
Thanks Carlo. It worked..
Thanks Carlo. It worked..
894
Posted By Diya123
Thanks for the reply. Nope I want to change...
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...
894
Posted By Diya123
Renaming bulk directories and subfiles
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...
773
Posted By Diya123
Getting unique based on clusters
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:...
Showing results 1 to 25 of 139

 

Featured Tech Videos

All times are GMT -4. The time now is 02:04 AM.
Unix & Linux Forums Content Copyright 1993-2019. All Rights Reserved.
Privacy Policy