Icon

04_​Binning_​in_​Databases

Database Binning

This workflow demonstrates the different database binner nodes that allow you to create new binning columns for numerical columns.

An example would be to convert a numerical column, which contains the age in years, into a categorical column with values such as children and adults. The demonstrated nodes are the DB Auto-Binner node, which automatically creates the bin boundaries e.g. by specifying the number of bins to create, the DB Numeric-Binner, which allows you to manually specify the bin boundaries, and the DB Apply-Binner node, which applies an existing binning to new data.

Notice, that the red connection ports of the database nodes only contain the SQL statement and connection information but not the data itself. The statement is processed within the database e.g. Oracle, MySQL, Postgres, DB2, SQL Server, Hive, Impala, etc. and the result is read into the KNIME Analytics Platform via the DB Reader node.



This workflow demonstrates the different database binner nodes that allow you to create new binning columns for numerical columns. For more information see the workflow metadata. Find it here: View -> Description. Have a look at the result once a Binner node is executed, byopening the "Binned DB Data" view via the nodes contextmenu and clicking the "Cache no. of rows" button You can also bin several cloumns at the same time if the database supports CASE e.g. MySQL, Postgres, Oracle, etc.Define the boundaries of the bins yourselfDefine the number of binsand let KNIME find the rightbin boundariesDefine the boundaries of the bins yourselfApply an existing binning schema to new data Create ExampleTable DB Numeric-Binner DB Numeric-Binner DB Auto-Binner DB Numeric-Binner DB Apply-Binner This workflow demonstrates the different database binner nodes that allow you to create new binning columns for numerical columns. For more information see the workflow metadata. Find it here: View -> Description. Have a look at the result once a Binner node is executed, byopening the "Binned DB Data" view via the nodes contextmenu and clicking the "Cache no. of rows" button You can also bin several cloumns at the same time if the database supports CASE e.g. MySQL, Postgres, Oracle, etc.Define the boundaries of the bins yourselfDefine the number of binsand let KNIME find the rightbin boundariesDefine the boundaries of the bins yourselfApply an existing binning schema to new dataCreate ExampleTable DB Numeric-Binner DB Numeric-Binner DB Auto-Binner DB Numeric-Binner DB Apply-Binner

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Berthold
Created at: 2015-12-08
On NodePit since: 2024-01-14
Last update: 2024-04-30
Created with KNIME version: v4.3.0
Tags: databasesqlitebinning

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!