This is an old revision of the document!
Groups data by a column and perform operations on other columns.
This tool allows to group an input dataset by a user indicated column and perform the following functions on any columns: Mean, Median, Mode, Sum, Max, Min, Count, Concatenate, and Randomly pick.
If your data is not TAB delimited, use Text Manipulation→Convert.
The output is a grouped tab-delimited dataset.
Usage Example: localizing the beginning position on chromosomes.
Select data: file_group.txt
Group by column: c1
Ignore case while grouping?: YES
On column: c2
Round result to nearest integer?: YES
July 23rd, 2014