Sort based on second column and list from highest to lowest Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) 2019 Community Moderator Election Results Why I closed the “Why is Kali so hard” questionLinux sort second last columnSort only on the second columnHow to print top five highest numbers from a column?sort based on columnSorting file by first and then second columnHow to get the second column from command output?Sort one column ascending and another column descendingSort based on different fields and valuesHow to sort the values in one column based on other column values?awk print most common string in second column

Java 8 stream max() function argument type Comparator vs Comparable

How does cp -a work

Letter Boxed validator

Doubts about chords

I am not a queen, who am I?

What LEGO pieces have "real-world" functionality?

Should I discuss the type of campaign with my players?

What happens to sewage if there is no river near by?

Why is "Captain Marvel" translated as male in Portugal?

If a contract sometimes uses the wrong name, is it still valid?

Did Kevin spill real chili?

Is a manifold-with-boundary with given interior and non-empty boundary essentially unique?

What do you call a plan that's an alternative plan in case your initial plan fails?

3 doors, three guards, one stone

Can a non-EU citizen traveling with me come with me through the EU passport line?

What's the purpose of writing one's academic bio in 3rd person?

List *all* the tuples!

Is the Standard Deduction better than Itemized when both are the same amount?

Why does Python start at index -1 when indexing a list from the end?

What is this single-engine low-wing propeller plane?

Using et al. for a last / senior author rather than for a first author

How does a Death Domain cleric's Touch of Death feature work with Touch-range spells delivered by familiars?

What is the correct way to use the pinch test for dehydration?

What is the musical term for a note that continously plays through a melody?



Sort based on second column and list from highest to lowest



Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
2019 Community Moderator Election Results
Why I closed the “Why is Kali so hard” questionLinux sort second last columnSort only on the second columnHow to print top five highest numbers from a column?sort based on columnSorting file by first and then second columnHow to get the second column from command output?Sort one column ascending and another column descendingSort based on different fields and valuesHow to sort the values in one column based on other column values?awk print most common string in second column



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








-1















TGAAACATGCCTTTCACCTCCTGCCATGATTGTGAGGCCT 2
GTGTTGCCCAGGTTGGTTTCAAACTCAGCTCAAGTGATCT 1
GAGACTCCTTCAGGAGACTGGTCCCCTGTCCTCGCCTCTC 3
CATGTTCTCCTGGAAGCCATGTGAGGAAGGCACATCATGG 8
AAGGACATAATCTCATTACTTTTATGGCCGCATAGTATTC 4
AGAGGCAGTGTAAGTGAGGTAGTTGAAAGTATGGACTCTG 2


I want to use second column to re-arrange the lines from highest number to lowest



Expected output



CATGTTCTCCTGGAAGCCATGTGAGGAAGGCACATCATGG 8
AAGGACATAATCTCATTACTTTTATGGCCGCATAGTATTC 4
GAGACTCCTTCAGGAGACTGGTCCCCTGTCCTCGCCTCTC 3
AGAGGCAGTGTAAGTGAGGTAGTTGAAAGTATGGACTCTG 2
TGAAACATGCCTTTCACCTCCTGCCATGATTGTGAGGCCT 2
GTGTTGCCCAGGTTGGTTTCAAACTCAGCTCAAGTGATCT 1









share|improve this question









New contributor




Ibk is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




















  • Welcome to U&L. You're getting downvoted because your question lacks own research. For your next question, make sure to include what you've tried and where you're stuck. If you had done that, I'm sure you would have found an answer on this site. Also, you should explain inside your question why you added 4 different language tags.

    – RoVo
    11 hours ago


















-1















TGAAACATGCCTTTCACCTCCTGCCATGATTGTGAGGCCT 2
GTGTTGCCCAGGTTGGTTTCAAACTCAGCTCAAGTGATCT 1
GAGACTCCTTCAGGAGACTGGTCCCCTGTCCTCGCCTCTC 3
CATGTTCTCCTGGAAGCCATGTGAGGAAGGCACATCATGG 8
AAGGACATAATCTCATTACTTTTATGGCCGCATAGTATTC 4
AGAGGCAGTGTAAGTGAGGTAGTTGAAAGTATGGACTCTG 2


I want to use second column to re-arrange the lines from highest number to lowest



Expected output



CATGTTCTCCTGGAAGCCATGTGAGGAAGGCACATCATGG 8
AAGGACATAATCTCATTACTTTTATGGCCGCATAGTATTC 4
GAGACTCCTTCAGGAGACTGGTCCCCTGTCCTCGCCTCTC 3
AGAGGCAGTGTAAGTGAGGTAGTTGAAAGTATGGACTCTG 2
TGAAACATGCCTTTCACCTCCTGCCATGATTGTGAGGCCT 2
GTGTTGCCCAGGTTGGTTTCAAACTCAGCTCAAGTGATCT 1









share|improve this question









New contributor




Ibk is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




















  • Welcome to U&L. You're getting downvoted because your question lacks own research. For your next question, make sure to include what you've tried and where you're stuck. If you had done that, I'm sure you would have found an answer on this site. Also, you should explain inside your question why you added 4 different language tags.

    – RoVo
    11 hours ago














-1












-1








-1








TGAAACATGCCTTTCACCTCCTGCCATGATTGTGAGGCCT 2
GTGTTGCCCAGGTTGGTTTCAAACTCAGCTCAAGTGATCT 1
GAGACTCCTTCAGGAGACTGGTCCCCTGTCCTCGCCTCTC 3
CATGTTCTCCTGGAAGCCATGTGAGGAAGGCACATCATGG 8
AAGGACATAATCTCATTACTTTTATGGCCGCATAGTATTC 4
AGAGGCAGTGTAAGTGAGGTAGTTGAAAGTATGGACTCTG 2


I want to use second column to re-arrange the lines from highest number to lowest



Expected output



CATGTTCTCCTGGAAGCCATGTGAGGAAGGCACATCATGG 8
AAGGACATAATCTCATTACTTTTATGGCCGCATAGTATTC 4
GAGACTCCTTCAGGAGACTGGTCCCCTGTCCTCGCCTCTC 3
AGAGGCAGTGTAAGTGAGGTAGTTGAAAGTATGGACTCTG 2
TGAAACATGCCTTTCACCTCCTGCCATGATTGTGAGGCCT 2
GTGTTGCCCAGGTTGGTTTCAAACTCAGCTCAAGTGATCT 1









share|improve this question









New contributor




Ibk is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












TGAAACATGCCTTTCACCTCCTGCCATGATTGTGAGGCCT 2
GTGTTGCCCAGGTTGGTTTCAAACTCAGCTCAAGTGATCT 1
GAGACTCCTTCAGGAGACTGGTCCCCTGTCCTCGCCTCTC 3
CATGTTCTCCTGGAAGCCATGTGAGGAAGGCACATCATGG 8
AAGGACATAATCTCATTACTTTTATGGCCGCATAGTATTC 4
AGAGGCAGTGTAAGTGAGGTAGTTGAAAGTATGGACTCTG 2


I want to use second column to re-arrange the lines from highest number to lowest



Expected output



CATGTTCTCCTGGAAGCCATGTGAGGAAGGCACATCATGG 8
AAGGACATAATCTCATTACTTTTATGGCCGCATAGTATTC 4
GAGACTCCTTCAGGAGACTGGTCCCCTGTCCTCGCCTCTC 3
AGAGGCAGTGTAAGTGAGGTAGTTGAAAGTATGGACTCTG 2
TGAAACATGCCTTTCACCTCCTGCCATGATTGTGAGGCCT 2
GTGTTGCCCAGGTTGGTTTCAAACTCAGCTCAAGTGATCT 1






awk python sort bioinformatics r






share|improve this question









New contributor




Ibk is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




Ibk is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited 10 hours ago









Jeff Schaller

45k1164147




45k1164147






New contributor




Ibk is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 11 hours ago









IbkIbk

31




31




New contributor




Ibk is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





Ibk is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






Ibk is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












  • Welcome to U&L. You're getting downvoted because your question lacks own research. For your next question, make sure to include what you've tried and where you're stuck. If you had done that, I'm sure you would have found an answer on this site. Also, you should explain inside your question why you added 4 different language tags.

    – RoVo
    11 hours ago


















  • Welcome to U&L. You're getting downvoted because your question lacks own research. For your next question, make sure to include what you've tried and where you're stuck. If you had done that, I'm sure you would have found an answer on this site. Also, you should explain inside your question why you added 4 different language tags.

    – RoVo
    11 hours ago

















Welcome to U&L. You're getting downvoted because your question lacks own research. For your next question, make sure to include what you've tried and where you're stuck. If you had done that, I'm sure you would have found an answer on this site. Also, you should explain inside your question why you added 4 different language tags.

– RoVo
11 hours ago






Welcome to U&L. You're getting downvoted because your question lacks own research. For your next question, make sure to include what you've tried and where you're stuck. If you had done that, I'm sure you would have found an answer on this site. Also, you should explain inside your question why you added 4 different language tags.

– RoVo
11 hours ago











1 Answer
1






active

oldest

votes


















1














Use sort with -k switch:



sort -k2 -nr file



  • -k2 sort field.


  • -n numeric sort (not needed here, as in the example numeric and alphabetic would be the same).


  • -r reverse sorting.





share|improve this answer























    Your Answer








    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "106"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader:
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    ,
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );






    Ibk is a new contributor. Be nice, and check out our Code of Conduct.









    draft saved

    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f512602%2fsort-based-on-second-column-and-list-from-highest-to-lowest%23new-answer', 'question_page');

    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    1














    Use sort with -k switch:



    sort -k2 -nr file



    • -k2 sort field.


    • -n numeric sort (not needed here, as in the example numeric and alphabetic would be the same).


    • -r reverse sorting.





    share|improve this answer



























      1














      Use sort with -k switch:



      sort -k2 -nr file



      • -k2 sort field.


      • -n numeric sort (not needed here, as in the example numeric and alphabetic would be the same).


      • -r reverse sorting.





      share|improve this answer

























        1












        1








        1







        Use sort with -k switch:



        sort -k2 -nr file



        • -k2 sort field.


        • -n numeric sort (not needed here, as in the example numeric and alphabetic would be the same).


        • -r reverse sorting.





        share|improve this answer













        Use sort with -k switch:



        sort -k2 -nr file



        • -k2 sort field.


        • -n numeric sort (not needed here, as in the example numeric and alphabetic would be the same).


        • -r reverse sorting.






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered 11 hours ago









        RoVoRoVo

        3,876317




        3,876317




















            Ibk is a new contributor. Be nice, and check out our Code of Conduct.









            draft saved

            draft discarded


















            Ibk is a new contributor. Be nice, and check out our Code of Conduct.












            Ibk is a new contributor. Be nice, and check out our Code of Conduct.











            Ibk is a new contributor. Be nice, and check out our Code of Conduct.














            Thanks for contributing an answer to Unix & Linux Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f512602%2fsort-based-on-second-column-and-list-from-highest-to-lowest%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            -awk, bioinformatics, python, r, sort

            Popular posts from this blog

            Creating 100m^2 grid automatically using QGIS?Creating grid constrained within polygon in QGIS?Createing polygon layer from point data using QGIS?Creating vector grid using QGIS?Creating grid polygons from coordinates using R or PythonCreating grid from spatio temporal point data?Creating fields in attributes table using other layers using QGISCreate .shp vector grid in QGISQGIS Creating 4km point grid within polygonsCreate a vector grid over a raster layerVector Grid Creates just one grid

            What is this called? Old film camera viewer?What makes a good film camera?What to do with an old film camera?What should one look for when buying a used film camera?What is the value and age of this pre-1967 Ricoh 35 mm camera?DSLR recommendation, question about old Canon 35mm film Camera & lensesCan anyone identify the silver rangefinder-style camera in this advertisement?What kind of a Polaroid 600-camera is this?Will an old film camera still work even when not used in a very long time?What is this camera / Can I develop the film?How to fit an action camera into antique (bellows) housing?What to check when buying used and old film bodies?

            Why is this plane circling around the Lucknow airport every day?Why do aircraft on Flight Radar 24 jump around randomly sometimes?What airport has this walkway over a taxiway?How does Chicago O'Hare's tower sequence aircraft at peak capacity?Which airport is featured in this Delta commercial?After a crash, for how long is the airport closed?Can a passenger plane stand still in the air, or hover at a fixed location above a ground?What are those trucks towing around, and why?What is this airport outside of Cairo, Egypt?Which US airport has the lowest circling MDH?What is this airport video?