0 ×

Normalize Plates (Z-Score)

HCS-Tools for KNIME version 4.0.0.v202007151505 by Max Planck Institute of Molecular Cell Biology and Genetics (MPI-CBG)

Groups of data (e.g. wells of a plates) are normalized relative to a subset (e.g. some wells within that plate, e.g. negative control). For each group mean and standard deviation (or median and mad) are calculated for the selected subset. Based on these estimates, all data points of a group are normalized by applying this formula:

x.zscore = (x – mean(x[subset]))/sd(x[subset])
or
x.zscore = (x – median(x[subset]))/mad(x[subset])

Literature: Malo et al., Nat. Biotechnol. 24, 167-179 (2006)
Wikipedia: Z-score / Standard score

Options

Group data by
Select the column to define the groups (e.g. "barcode" for plate-wise normalization). Select >none< for no grouping (e.g. normalization of the whole screen based on all negative controls available).
Normalize
Select the columns with data to be normalized.
Column with reference label
Select the column which contains the label defining the reference subset (e.g. treatment)
Subset / well annotation
Select a subset label that is used to calculate mean and sd (median and mad) for each group (e.g. "negative control").
Replace existing values
If checked the raw values will be replaced by the normalized values. Otherwise columns with the normalized values will be appended - ".zscore"
Use robust statistics
Median and mad will be calculated instead of mean and sd.
Column suffix
The default column suffix ".zscore" can be changed
Load a limited number of columns
If big data tables create memory problems, the number of columns read in memory (subset data) can be restricted. Then, statistic calculation will be done sequential for each set with the given number of columns.

Input Ports

Icon
Input table

Output Ports

Icon
Table with normalized values
Icon
Table with statistics used for normalization

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

To use this node in KNIME, install KNIME HCS Tools from the following update site:

KNIME 4.2

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.