Shell Programming and Scripting

I have two files, "ranked.txt" and "sorted.txt". Sorted.txt is a smaller subset from ranked.txt that is sorted in alpha order. However ranked.txt preserves the ranking of words I would like to keep.

How do I check the rank of every word in sorted.txt when matched to the original ranked.txt? I want to output the rank (which is the line number) from ranked.txt into sorted.txt.

ranked.txt:
1 the
2 quick
3 brown
4 fox
5 jumped

sorted:
brown
fox
jumped
quick
the

output.txt:
3 brown
4 fox
5 jumped
2 quick
1 the

This is what I have so far in Python:

Code:

for word in sorted_list:
    for num, line in enumerate(ranked_list, 1):
        if word in line:
            print word, '\t', num

Not doing exactly what I want... is it easier to do with sed/grep/awk??

If your lists aren't huge, you can do it this way:

Code:

awk  'FNR == NR { rank[$1] = NR; next; } { print rank[$1], $1 }' rank.txt sorted.txt

I assumed the list in ranked.txt was just the words, and didn't contain line numbers. If it contains line numbers, a small tweak:

Code:

awk  'FNR == NR { rank[$2] = NR; next; } { print rank[$1], $1 }' rank.txt sorted.txt

Thanks agama! Works like a charm!

Do you know how to sort the output properly by the rank? I tried using "sort -k2 output.txt", but now it looks like:

output.txt
10002 the
10005 quick
10008 brown
10009 fox
1000 jumped
10001 over

When it should be sorted like:

1 the
2 quick
3 brown
4 fox

Have you tried using..

Code:

sort -nrk1 file

Code:

sort -nrk1 file

seems to sort the file from the end.. makes it look like:

Code:

997690 últmos
997689 óm
997688 ódicos
997687 ívoro
997686 éxitosos
997685 éara
997684 èrsonal
997683 çilek
997682 áutobuses
997680 zoccolini
997679 zmur

---------- Post updated at 09:03 PM ---------- Previous update was at 08:50 PM ----------

I used sort -nk1 and got the desired output, thanks!

this will sort from first to last..

Code:

sort -n file

Thank you pamu! One final question: when comparing two files, how can i output lines in a.txt but not in b.txt? (while ignoring the lines common in both files)

Code:

file: a.txt
facebook
youtube
yahoo
google
microsoft

Code:

file: b.txt
yahoo
google
pandora
facebook
yelp

Output would be:
pandora
yelp

I tried comm -23 but I still get "facebook" present in the output file