Summarizing quantification results

Action

Description

Export

Exports the current table as *.csv or *.xlsx

Clone

Clones the current table into a new table document. This will open a new tab.

Undo

Undo the previous action. Please note that this function does not work for manually editing a table cell.

Add row

Adds an empty row or copies rows from another table.

Add column

Allows creation of a new empty column, copying the currently selected column or importing columns from another table.

The Combine selected columns function creates a new column that combines the values of the existing column in the format Column1=Value1, Column2=Value2. Use this function to quickly merge multiple conditions into a single one.

Remove rows

Removes the selected rows

Remove columns

Removes the selected columns

Rename column

Renames the selected column

Select whole row

Expands the selection to the whole row

Select whole column

Expands the selection to the whole column

Invert selection

Inverts the current selection

Filter select

Selects all rows that match with the selected values.

Example

The table has two columns “Valid” and “Sample”. You want to select all rows where “Valid” = True and “Sample” = “Kidney1”. Select those values and click the filter selection button.

Autosize columns

Resizes the columns, so they fit their contents.

Split columns

Splits the values of one column by a set of category columns.

Example

The column “Count” is split by “Sample” and “Valid”. Following table is generated:

Integrate columns

Creates column statistics such as sum, average, variance or median.

Convert selection

Converts the selected cells by the selected conversion function (e.g. to a number)

Create plot

Creates a plot from the table. See Plotting quantification results for more information.

Info: The plot gets a copy of the table, so changes to the table do not affect an existing plot.