Missing values based on ocurense frequency

There is some data I need to analyze. After binning it looks like this:

Time(Seconds) Value Label
1 1 A
2 3 B
3 5 C
4 7 ?
5 3 B
6 5 C
7 1 A
8 3 B
9 5 C

There is an unknown value at row 4. At first I make an assumption, that it is some measurement error. So it would be possible to say, that row 4 should get the label A, because A occurs every 3 Seconds and we have an unknown value in this row.

Any idea how this problem can be solved?

Regards

Hi ellboy,

I would suggest using a Java Snippet node with the following code snippet: 

if (c_Label == null & (c_Timesec - 1) % 3 == 0) {

 c_Label = "A";

}

or to use Math Formula -> Rule Engine -> Column Filter nodes to mimic the same behaviour.  

Please find both approaches in the attached workflow.

 

Best,

Anna