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

            Word for a person who has no opinion about whether god existsWord for having a definite opinion while simultaneously withholding judgment?What's the opposite of “newcomer? Is ”veteran" OK?What do you call an “atheist” who might believe in an afterlife?What's a word for someone who wants to voice opinions but not have them challenged?Word for someone who dismisses contrary opinions as irrational?Somone who thinks they are overly special/out of the ordinaryIs there a word, phrase or idiom for “a person who is incapable of thinking about the future”?The belief that a god is human-likeA word for a non-famous person/thing you have heard a lot aboutAdjective for a person who enjoys taking care of their appearance

            Can I redirect output to a log file and background a process at the same time?2019 Community Moderator ElectionUnable to write to file in shell script when running command in backgroundredirect and log script outputhow to properly log the output of a console program that frequently updates “parts” of the screen, resulting in a messy log file?How can I redirect the output of a child process?grep script - output lines at the same time into echoHow to run process in background and get its pid to create log file nameHow to redirect output to a log from expect commandHow to clear a redirect log file content in shell?Log background jobs started in all the manually started shells?Why do `jobs` and `dirs` run in command subsitution, process substitution, pipeline, and background jobs output the same as in original shell?How to redirect output to file to STDOUT?