[opendx-users] spreadsheet data and category statistics

[Susan A. Schwarz]

I am using ImportSpreadsheet to import 7 columns of data. One of the columns is string data and I am categorizing it. I need to find the max value of one of the variables at each value of the categorized string values. I have used the "CategoryStatistics" module to find the max but the output from it contains only the max values of the one variable but not the corresponding values for the other variables. Is there a way that I can do this?

For example:
The categorized data values are "gene1", "gene2", "gene3", etc and there are multiple entries for each gene. I want to find the maximum differential expression for each gene. However I also need to know the values of other variables that correspond to the max such as time, control and response.

Thanks in advance for any suggestions.

Susan Schwarz
Research Computing
Dartmouth College