How to replace missing values with the last given Value

Carlito
Carlito New Altair Community Member
edited November 5 in Community Q&A
Hello,
i have a Database with the following scheme:

+-----------+----------------+
| Field      | Type            |
+-----------+----------------+
| object    | varchar(50) |
| attribute | int(11)         |
| value     | float            |
| date       | datetime      |
+-----------+----------------+
Object = manufacturing plant
attribute = Sensor name
Value = sensor value
date = timestamp (datetime)

The Idea is to only save an attribute, when the value hase changed (triggered by change)...
In Rapidminder i am able to transform the scheme back to the traditional scheme, where every attribute/Sensor has a collumn. Only problem i have, are the missing values. If there are no values it means the haven`t changed, so i`d like to replace the missing values with the last given value. Is there a way to accomplish this ?

If it is not clear what exacty my problem is, i can try to be more precise in explaining it.

Thank you for your reply/ help

Tagged:

Best Answer

  • YYH
    YYH
    Altair Employee
    Answer ✓
    Hi @Carlito,
    You can use "replace missing values (series)" operator here with previous non-missing value.



    Best,
    YY

Answers

  • YYH
    YYH
    Altair Employee
    Answer ✓
    Hi @Carlito,
    You can use "replace missing values (series)" operator here with previous non-missing value.



    Best,
    YY
  • Carlito
    Carlito New Altair Community Member
    Thanks, thats the solution to my problem. I was just looking at Cleansing->Missing->Replace Missing Values...

Categories