0 ×

Binning Apply

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

The incoming data is grouped based on the node settings for grouping. Within each group and for each column of the incoming binning model, data points are counted for each bin. Further, data points with values below the lowest bin get counted as well as data points with values above the highest bin. Missing values will no be counted.
The first output table contains these counts and the corresponding percentage within the group. The counts of the lowest interval will include (!) the counts below; and the counts of the highest interval will include the counts above. So the sum reflects the number of data points of the group and percentages sum up to 100%.
The second output table only contains counts of data points with values below the lowest or above the highest interval. The percentage is based on the data point count.

Options

General settings

Group columns
Included columns will be used to group the data.
Exclude incomplete binning models

Models with less than n bins will be excluded. Number of expected bins is part of the binning model.
default: checked

Ignore missing columns

If checked only a warning will be shown if incoming data table does miss columns which are contained in the binning model. If unchecked, the node will not be executable if any column is missing.
default: checked

Input is already sorted by group column(s)

If checked, the data will not be sorted during execution (faster). The node will fail if the pre-sorting is not correct.
default: unchecked

Sampling options

Enable sampling

If checked, each group will be reduced (randomly) to a fixed number of rows, which can be set. If the group does contain less rows, all will be used.
default: 100

Use random seed

If checked, the random selection of rows for the sampling will be based on a fixed seed to make it reproducible.

Input Ports

Icon
Data to apply the binning model to
Icon
Binning model

Output Ports

Icon
Row counts per group, parameter and interval
(including outlier count within the lowest/highest interval)
Icon
Row counts per group, parameter and interval of datapoints below lowest or above highest interval

Best Friends (Incoming)

Best Friends (Outgoing)

Installation

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

KNIME 4.3

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.