Icon

05 Dealing with Missing Values

Handle remaining missing values (Missing Value node) -Set the numeric missing values to the column mean and the string to the most frequent value
Handle remaining missing values (Missing Value node) -Set the numeric missing values to the column mean and the string to the most frequent value
Optional: -Handle the NAs missing values (Column Auto Type Cast node) -Remove columns with more than 30% missing values (Missing Value Column Filter node)
Category Count
Value Counter
XXX as missing
Column Auto Type Cast
Most Frequent Value
Missing Value
PostalCode Missing
Value Counter
Summary Statistics
Statistics
Missing Value
10% missing
Missing Value Column Filter
PostalCode XXX
Value Counter
Invalid values to empty
Rule Engine
Empty to Null
String Manipulation
Missing Date value filter
Row Filter
OrderDetails.xlsx
Excel Reader
Table Writer

Nodes

Extensions

Links