Icon

Session 2.2 How to Repair Missing Values

Data Cleaning with KNIME:

How to Handle Missing Values

Different ways to repair — or deliberately keep — missing values with the Missing Value node.

Interpolation
Previous value
Fixed value (0)
Leave missing + flag
interpolatedrift fills honestly(60.65)
Missing Value
a setpoint that holds its value
CSV Reader
previous valuesetpoints stay put(60.0)
Missing Value
flow while the pump was OFF
CSV Reader
fixed 0off means zero flow
Missing Value
3 of 5 readings lost
CSV Reader
do nothingtoo broken to guess
Missing Value
CSV Reader

Nodes

Extensions

  • No modules found

Links