UNIX for Dummies Questions & Answers

I have a tab delimited text file that looks like the following:

Code:

ERBB3	0.00097
IL31RA	0.000972
SETD5	0.000972
MCART1	0.000973
CENPJ	0.000973
FNDC6	0.000974

I want to assign a number to each row based on the value in the last column (in the order of increasing value so that the first row will be 1, the second 2, and so on) If two rows have the same value in their last column, then they will be assigned the same number. The resulting output should look like this:

Code:

ERBB3	0.00097           1
IL31RA	0.000972          2 
SETD5	0.000972          2 
MCART1	0.000973          3  
CENPJ	0.000973          3
FNDC6	0.000974          4

How do I go about doing that? Thanks!

Try...

Code:

awk '$2>p{c++} {$3=c; print; p=$2}' OFS='\t' file1

Thanks but this code does not assign numbers to rows where the value in the 2nd column is 0. For example, if the input looks like this:

Code:

abc 0
cde 1
ghi  2

The output will look like this:

Code:

abc 0 
cde 1 1
ghi 2 2

How can the code be modified to achieve that? Thanks!

Try...

Code:

awk '$2>p{c++} {$3=c; print; p=$2}' OFS='\t' p='-1' file1