Replace missing data baed on mean of alternative column

KNIME Analytics Platform
2

hi there

I would use the group by node to group by "new.title" and getting the mean for "age".
having theses numbers, got to the main table and use the rule engine node and set it like:
$new.title$ LIKE "master"  AND MISSING $age$ => 888

$new.title$ LIKE "mrs"  AND MISSING $age$ => 888

$new.title$ LIKE "XYZ"  AND MISSING $age$ => 888

where 888 is your dedicated mean that you got from the group by node..
 

NOTE you have to set the rule engine node to replace column age

 

good luck!