TIP: If your data is not TAB delimited, use Text Manipulation->Convert

Syntax

This tool allows you to group the input dataset by a particular column and perform aggregate functions like Mean, Sum, Max, Min and Concatenate on other columns.

• All invalid, blank and comment lines are skipped when performing the aggregate functions. The number of skipped lines is displayed in the resulting history item.

Example

• For the following input:

  chr22  1000  NM_17
  chr22  2000  NM_18
  chr10  2200  NM_10
  chr10  1200  NM_11
  chr22  1600  NM_19
  

• running this tool with Group by column 1, Operations Mean on column 2 and Concatenate on column 3 will return:

  chr10        1700.00 ['NM_11', 'NM_10']
  chr22        1533.33 ['NM_17', 'NM_19', 'NM_18']