Partitioning

The input table is split into two partitions (i.e. row-wise), e.g. train and test data. The two partitions are available at the two output ports. The following options are available in the dialog:

Options

Absolute

Specify the absolute number of rows in the first partition. If there are less rows than specified here, all rows are entered into the first table, while the second table contains no rows.

Relative

The percentage of the number of rows in the input table that are in the first partition. It must be between 0 and 100, inclusively.

Take from top

This mode puts the top-most rows into the first output table and the remainder in the second 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 tables. 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.

Views

This node has no views

Workflows

• !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
• [ISPRENL S11] Group 5 MCO2 WorkflowKNIME Hub
• [Latest] Consolidated 3 Mar 1210KNIME Hub
• 0_install_AI_extensionsKNIME Hub
• 0. Lubes_Sales_Pred-ModelNodePit Space
• Show all 3569 workflows

Links

• Splitting data into partsby mlauber71 on 2019-01-01

  forum.knime.com/p/52266
• How to do Data analysis with knimeby armingrudd on 2019-10-21

  forum.knime.com/p/72844
• Table random manipulationsby armingrudd on 2019-08-20

  forum.knime.com/p/68248
• Row-based filter, extract every X:th rowby aworker on 2023-02-06

  forum.knime.com/p/192385
• scorer does not shows the total number of instancesby qqilihq on 2022-02-17

  forum.knime.com/p/148230
• Show all 6 links

Developers