How to sorting multiple columns from a CSV file

Question

I have a file in following format. I need to sort it by largest code first and then by largest values column.

 colour,letter,code,value
    red,r,016,949.8
    red,r,015,603.9
    red,r,014,348.4
    blue,b,016,362.29
    blue,b,015,460.2
    blue,b,014,9850.9

output:
    red,r,016,949.8
    blue,b,016,362.29
    red,r,015,603.9
    blue,b,015,460.2
    blue,b,014,9850.9
    red,r,014,348.4

my implementation

sort  -k3,3n -r  -k4,4n -t \t data.csv

When I try to do it it sorts the file but doesn't sort the first two columns.

Does this answer your question? Sort CSV file by column priority using the "sort" command — kvantour
– kvantour, Commented Nov 3, 2019 at 10:48

dash-o · Accepted Answer · 2019-11-02 00:42:14Z

2

It's not clear if the file is TSV (tab separated), or CSV (comma separated). Question indicate CSV, but answer using tab delimiter (-t \t). Try -t, for CSV. Also the reverse order need to be applied to each key ('r' suffix on each key).

sort -k3,3nr -k4,4nr -t, data.csv

answered Nov 2, 2019 at 0:42

dash-o

14.6k1 gold badge14 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

How to sorting multiple columns from a CSV file

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related