Search Results

This is not homework or assignment. I am doing some accounting work (many transaction) to report the highest balance on the banking account and the bank statement didn't provide the cumulative...

I have a file has thousands of rows and each row has a number and the number can be positive or negative. I want to do the cumulative sum from the first row. How can I find out the maximum cumulative...

Hi, I have two files A and B.
file_Agga-mir-181b-1
gga-mir-181b-2
gga-mir-199-1
gga-mir-203
gga-mir-204-1
gga-mir-205a
gga-mir-206
gga-mir-214
gga-mir-218-1
gga-mir-365-2
gga-mir-454...

Can anybody help me figure this out? Thank you in advance.
I have a input file. It shows like this:
Query= random content
random content
> random content
random content
> random content
>...

Thank you very much RudiC. Actually I am an embryology biologist and I don't have any computer science background and I am a totally rookie. I have to deal with some very large data set from the...

Sorry to bother you guys again. I have a file1 with multiple columns like this:gga_miR_100 gga_miR_300 gga_miR_3500 gga_miR_4600 gga_miR_5600 gga_miR_30 gga_miR_500
kj rwg ghhh jy jyu we vf...

Thank you very much. I just adjusted it to accommodate my column numbers and it works perfectly. I also tested n with various numbers and they are all good. Thank you RudiC.

Hi RudiC, since for each column has been sorted, I initially naively thought just using the head or sed command to extract the top lines with the top "n" lowest values. Then I realized that a value...

Sorry, I mean n=3, I just correct it in the original thread.

I have a file with multiple columns (in this case, the file has 3 columns)： NM_001006304 (-33.7) XM_418228 (-38.4) JN880447 (-33.7)
CR387600 (-33.7) CR524203 (-36.3) GALGA_6AKII_KRT75 (-33.7)...

Thanks RudiC, your script is perfectly matching but doesn't rank them, I just simply added the sort command after that. Thank you very much.
awk 'FNR==NR {T[$0];next}
...

I actually posted a similar question before but my expression probably lead the helper here frustrated. I also tried to figure it out by myself but failed. So I rephrase my question again and...

Thanks Aia, it works perfectly. Also thanks for point my mistake and I will be more careful when I post my question.

Hi I have a file like this
input_fileCR387793 -0.8
CR387793 -5.5
CR387794 -5.3
CR387795 -0.9
AR388755 -3.0
AR388755 3.8
AR388755 4.5
Each line has annotation name and its correlated value....

Akshay, I tried this one. It didn't rank based on the mfe value and some lines missing mfe value. Also, in the output file, the "GALGA25_FK1" value is "-158.8" which is the sum of the partially match...

Hi Singh,

I tried your code. It only ranks the lines start with "GALGA" in file2. Actually all lines in file2 can have the corresponding mfe value in file1. Could you also take a look again? Thank...

Hi Akshay, all keys in file2 should have the match mfe value in file1. your script only match the lines start with "GALGA"in file2.

Hi Akshay, thanks for your reply, I ran your code but some line result lack of the value and show "0.0" in the parenthesis. Could you take a look? thank you.

Hi guys, I am using Centos 6.3. Actually I posted similar question but I still have some minor problem need be fixed. I have two files,
file1:target: gi|57529786|ref|NM_001006513.1| mfe: -31.4...

Thank you guys, you saved my life.

I used to use this script to extract the same lines from two files:
grep -f file1 file2 > outputfile
now I have file1 AB029895
AF208401
AF309648
AF526378
AJ444445
AJ720950
AJ851546
AY568629...

Thank you so much, it works perfectly and no error.

I have a lot of files under a folder and each file has a different name. I want to add each file's name as the first line of each file. How can I do this? I was trying to use this script for file in...

Hi Don,

I feel very sorry make you frustrated. I just want to gave you guys simpler example files to deal with it and I thought it will apply to my own data, that's why I gave you the first...

Hi RudiC, I tried with my own file1 and file2, and the output file3 doesn't follow the mfe value order. Here is my own files.
file1:target: gi|45383869|ref|NM_204120.1| mfe: -30.0 kcal/mol p-value:...