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
-
Tumors contain complex mixtures of cell populations that evolve in response to treatment and host-specific factors. Tissue biopsies provide only static snapshots of a tumor’s state. But what if we could follow that evolution over time using a minimally invasive technique?
Liquid biopsies can detect tumor-derived material circulating in the bloodstream, providing a way to study treatment response, detect emerging resistance, and discover new biomarkers. Circulating...10-14-2026, 09:55 AM
Comment