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: Mean, Median, Mode, Sum, Max, Min, Count, Concatenate, and Randomly pick on any column(s).

The Concatenate function will take, for each group, each item in the specified column and build a comma delimited list. Concatenate Unique will do the same but will build a list of unique items with no repetition.

Count and Count Unique are equivalent to Concatenate and Concatenate Unique, but will only count the number of items and will return an integer.

• If multiple modes are present, all are reported.

Example

• For the following input:

  chr22  1000  1003  TTT
  chr22  2000  2003  aaa
  chr10  2200  2203  TTT
  chr10  1200  1203  ttt
  chr22  1600  1603  AAA
  

• Grouping on column 4 while ignoring case, and performing operation Count on column 1 will return:

  AAA    2
  TTT    3
  

• Grouping on column 4 while not ignoring case, and performing operation Count on column 1 will return:

  aaa    1
  AAA    1
  ttt    1
  TTT    2