Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • Binner (Dictionary)
NodeNode / Manipulator

Binner (Dictionary)

Manipulation Column Binning Streamable
Drag & drop
Like
Copy short link

Categorizes values in a column according to a dictionary table with min/max values. The table at the first input contains a column with values to be categorized. The second table contains a column with lower bound values, a column with upper bound values and a column with label values. The latter will be used as outcome in case a given value is between the corresponding lower and upper bound. Each row in the second table represents a rule, whereby the rules are evaluated top-down, i.e. rules with low row index have higher priority than rules in the subsequent rows.

Either the lower or upper bound test can be disabled by unsetting the corresponding checkbox in the dialog. Missing values in the columns containing upper and lower bounds will always evaluate the bound check to true. That is, a missing value in the lower bound column will always be smaller and a missing value in the upper bound column will always be larger than the value. Missing values in the value column (1st input) will result in a missing cell output (no categorization).

Note: The table containing bound and label information (2nd input) will be read into memory during execution; it must be a relatively small table!

Node details

Input ports
  1. Type: Table
    Input to be categorized
    Arbitrary input data with column to be binned.
  2. Type: Table
    Rule/Dictionary table
    Table containing categorization rules with lower and upper bound and the label column.
Output ports
  1. Type: Table
    Categorized data
    Input table amended by column with categorization values.

Extension

The Binner (Dictionary) node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Rango de Edades a partir de un diccionario
    Ejemplo de cómo asignar un rango a las edades de un dataset, a partir de un diccionario e…
    ovazquez > Public > Rango_Edades
    ovazquez
  2. Go to item
    20220309_filename_binner
    duristef > Public > solutions > 20220309_filename_binner
    duristef
  3. Go to item
    2017_01_23_WindGust
    iris > Public > 02_ForumExamples > 2017_01_23_WindGust
    iris
  4. Go to item
    Changing value after certain age
    lelloba > Forum > Changing value after certain age
    lelloba
  5. Go to item
    KNIME_challenge_5
    duristef > Public > justknimeit > KNIME_challenge_5
    duristef
  6. Go to item
    justknimeit - 19 - Raffaello Barri
    Justknimeit-19
    lelloba > Public > Just Knime it! > justknimeit - 19 - Raffaello Barri
    lelloba
  7. Go to item
    KNIME_challenge_5_b
    duristef > Public > justknimeit > KNIME_challenge_5_b
    duristef
  8. Go to item
    Window loop and years
    lelloba > Forum > Window loop and years
    lelloba
  9. Go to item
    GeoIP Open Street Map Visualization
    This workflow uses geop IP data on randomly generated IP addresses and maps them using Op…
    knime > Examples > 03_Visualization > 04_Geolocation > 03_GeoIP_Visualization_using_Open_Street_Map_(OSM)
    knime
  10. Go to item
    Geolocation IP static 2013
    This example demonstrates how to analyze a weblog and display the most prominent national…
    knime > Examples > 03_Visualization > 04_Geolocation > 01_Static_geolocation_of_IP_addresses
    knime
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits