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
I'm not saying CategoryStatistics is easy to understand, because it isn't, but I think it does what you want already.
Open the dxsamples program called Categorical.net. Add a Print("rd") right after ImportSpreadsheet to see the data structure and Execute. (state incomes for 4 states; state name is string>>categorized to 00..03).
Keep the Message Window contents open, move the Print down to the output of CategoryStatistics. Choose "max" from the Selector feeding CategoryStatistics and execute again.
It sure looks to me like CategoryStatistics is now reporting 4 values: the max i income for each state. Isn't that what you are asking for? You'll still need to use Lookup to reassociate each max value via its categorized index with the corresponding string, if you need to display a Legend for example.
Also, you can use 2 CategoryStatistics side by side (same input data), one for "min" and one for "max", then Compute the difference to get a field of n data values, the deltas.
Chris Pelkie
Vice President/Scientific Visualization Producer
Conceptual Reality Presentations, Inc.
30 West Meadow Drive
Ithaca, NY 14850
[EMAIL PROTECTED]
(607) 257-8335 or (607) 254-8794
