sorting rows of a data file with Linux

Question

I would like to sort the lines of a data file (each line idependent from each other) from the first character. For example, if I have a data file

1   0.1     0.6     0.4
2   0.5     0.2     0.3
3   1.0     0.2     0.8

I would like to end with something like

1   0.6     0.4     0.1
2   0.5     0.3     0.2
3   1.0     0.8     0.2

I have tried to do it using the sort command, but it sorts the columns (not the line). Transposing the data file +sort could be also a good solution (I don't know any easy way for transposing datafiles).

Thanks for the help!

stackoverflow.com/questions/25062169/… maybe?

FirebladeDan
– FirebladeDan

2016-04-20 15:05:28 +00:00
Commented Apr 20, 2016 at 15:05 — FirebladeDan
– FirebladeDan, Commented Apr 20, 2016 at 15:05

choroba · Accepted Answer · 2016-04-20 15:10:30Z

2

Perl to the rescue!

perl -lawne '
    print join "\t", $F[0], sort { $b <=> $a } @F[1..$#F]
' < input > output

-n reads the input line by line
-a splits the line on whitespace into the @F array
-l adds newlines to print

See sort, join .

answered Apr 20, 2016 at 15:10

choroba

245k27 gold badges221 silver badges304 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3209698 Over a year ago

So useful and powerful command. Thank you for your answer, it definitively solved my problem!

Quinn · Accepted Answer · 2016-04-20 15:52:44Z

1

Or to read input line by line, use tr and sort like this:

#! /bin/sh
while read -r line; do
    echo $line | tr ' ' '\n' | sort -k1,1nr -k2 | tr '\n' '\t' >> output
    echo >> output
done < input

tr ' ' '\n' is to convert row to column.

edited Apr 20, 2016 at 15:52

answered Apr 20, 2016 at 15:45

Quinn

4,5142 gold badges24 silver badges19 bronze badges

Collectives™ on Stack Overflow

sorting rows of a data file with Linux

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related