Tweet
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.
-
-
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 -
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
-
Proteomics platforms are evolving rapidly, with advances in mass spectrometry and affinity-based approaches expanding what researchers can detect and at what scale. As the field moves toward deeper proteome coverage and clinical applications, scientists face an increasingly complex landscape of tools. This article will explore how researchers are navigating these choices to find the right platform for their work.
The systematic characterization of the human proteome has...07-20-2026, 11:48 AM -
Genomics studies in neuroscience face a special challenge due to the brain’s complexity and scarcity of samples. Mapping changes in cell type and state using conventional next-generation sequencing methods remains challenging. Advances in technologies like single-cell sequencing, spatial transcriptomics, and long-read sequencing have opened the door to deeper studies of the brain and diseases like Alzheimer’s, amyotrophic lateral sclerosis (ALS), and schizophrenia.
...07-09-2026, 11:10 AM -
Cancer survival rates have significantly increased in the last few decades in the United States, reaching a combined 70% 5-year survival rate by 2021. Behind this number, there are years of research to find new therapies, drug targets, and early detection methods. But there is one core challenge that keeps slowing down these advances, and it’s about drug resistance.
There is no single reason why many patients don’t respond to treatment as expected. Cancer is...07-08-2026, 05:17 AM
Comment