Unconfigured Ad

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Giles
    Member
    • Feb 2010
    • 39

    #1

    groupBy to find max value

    Does anyone know how i can use groupBy to find the max value, but print not the max value, but the position within the feature that the max value is associated with. To wit, if the value for a given position within a feature is in column 8, the position is in column 7 and the name of the feature is column 4. I first sort and group by c4. Then I ask for the max value at c8. But instead of printing c8 I need the program to print c7. Seems easy, but I can't figure it out. Thanks.
  • bioBob
    Member
    • Mar 2011
    • 72

    #2
    Hi,

    it sounds like you are trying to do this in R??

    I will leave an R solution to someone with a bit more groupBy knowledge than me.

    How about awk?

    awk '{if($8>max8) max8=$8;max7=$7}END{ print max7}' data_file.tab

    Bob

    Comment

    • bioBob
      Member
      • Mar 2011
      • 72

      #3
      Hmm, I posted too quickly without having my first sip of coffee. It seems as though I need another check in there for feature. Which I now see is the reason you wanted to use groupBy.

      Can you post a small portion of your file?

      Comment

      Latest Articles

      Collapse

      • kinpict.com
        Reply to 16S/ITS Profiling vs. Shotgun Metagenomics: What Changes in Your Workflow?
        by kinpict.com
        The part about this topic feels surprisingly grounded, and the details on the page is the bit that made me slow down. I’d keep <a href="https://kinpict.com/">ai family photo generator</a> bookmarked for later.
        Today, 06:37 PM
      • SEQadmin2
        16S/ITS Profiling vs. Shotgun Metagenomics: What Changes in Your Workflow?
        by SEQadmin2





        NGS has revolutionized clinical microbiology by offering new ways to identify and surveil pathogens without prior knowledge of the target. One popular approach is 16S rRNA and ITS amplicon sequencing, which targets specific microbial markers. But studies are increasingly incorporating shotgun metagenomics, a technique that sequences all DNA from a sample without targeting specific microbial markers. This approach allows more detailed taxonomic classification,...
        10-30-2026, 06:46 AM

      ad_right_rmr

      Collapse

      News

      Collapse

      Topics Statistics Last Post
      Started by SEQadmin2, 11-12-2026, 07:59 AM
      0 responses
      27 views
      0 reactions
      Last Post SEQadmin2  
      Started by SEQadmin2, 11-05-2026, 09:25 AM
      0 responses
      35 views
      0 reactions
      Last Post SEQadmin2  
      Started by SEQadmin2, 11-03-2026, 11:54 AM
      2 responses
      56 views
      0 reactions
      Last Post kinpict.com  
      Started by SEQadmin2, 10-28-2026, 09:57 AM
      0 responses
      175 views
      0 reactions
      Last Post SEQadmin2  
      Working...