Row Sampling

This node extracts a sample (a bunch of rows) from the input data. The dialog enables you to specify the sample size. The following options are available in the dialog:

Options

Absolute

Specify the absolute number of rows in the sample. If there are less rows than specified here, all rows are used.

Relative

The percentage of the number of rows in the sample. Must be between 0 and 100, inclusively.

Take from top

This mode selects the top most rows of the table.

Linear sampling

This mode always includes the first and the last row and selects the remaining rows linearly over the whole table (e.g. every third row). This is useful to downsample a sorted column while maintaining minimum and maximum value.

Draw randomly

Random sampling of all rows, you may optionally specify a fixed seed (see below).

Stratified sampling

Check this button if you want stratified sampling, i.e. the distribution of values in the selected column is (approximately) retained in the output table. You may optionally specify a fixed seed (see below).

Use random seed

If either random or stratified sampling is selected, you may enter a fixed seed here in order to get reproducible results upon re-execution. If you do not specify a seed, a new random seed is taken for each execution.

Input Ports

Table to sample from.

Output Ports

The sampled table.

Best Friends (Incoming)

• Row Filter (14 %) Streamable
• Sorter (8 %) 
• Column Filter (7 %) Streamable
• File Reader (6 %) Streamable
• GroupBy (5 %) 
• Show all 445 recommendations

Best Friends (Outgoing)

• Concatenate (9 %) Streamable
• Column Filter (6 %) Streamable
• Joiner (4 %) 
• GroupBy (4 %) 
• CSV Writer (4 %) Streamable
• Show all 783 recommendations

Workflows

• _​01_​ChemicalLibraryEnumeration (KNIME Hub) 
• _​01_​ChemicalLibraryEnumeration (KNIME Hub) 
• 00_​Guided_​Labeling_​for_​Document_​Classification_​(legacy) (KNIME Hub) 
• 00_​Guided_​Labeling_​for_​Document_​Classification_​(legacy) (KNIME Hub) 
• 00_​Keras_​Transfer_​Learning (KNIME Hub) 
• Show all 165 workflows

Installation

To use this node in KNIME, install KNIME Base nodes from the following update site:

A zipped version of the software site can be downloaded here. Read our FAQs to get instructions about how to install nodes from a zipped update site.

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.