Skip to main content
  • EN

Hi There,

 

I'm having some trouble of figuring out an approach to detect features that have "regressed".

My data looks something like this:

<Fruit> <Batch>

Orange, 1

Apple, 1

Pear, 1

Orange, 2

Apple, 2

Pear, 2

Orange, 3

Pear, 3

 

So look at this as Batch 1 had all three fruit, batch 2 had all three fruit, but in batch 3, Apple is missing.

What I am interested in is knowing when a fruit went missing, specifically in a sequential view.

Meaning, I don't really care about the relationship between batch 1 and 3, but I want to know that between batch 2 and 3, Apple went missing. So even if I have 10 batches, I only really care if I have "pineapple" in batch 8, but missing in 9.

 

I hope my obscure example makes sense and please let me know in case any additional information is needed.

 

Thanks a lot!

 

One way to do this is to assign a BatchCombination to all rows and check Fruit and BatchCombination with a ChangeDetector. If you have batches 1,2 and 3, you want to check BatchCombination 1,2 and BatchCombination 2,3.

FruitBatchChangeDetectionProbably faster with Python and lists, but this is one way to do it.

Do you always know the number of batches? If so you should be able to sort then use adjacent attribute mapping in an AttributeCreator to get something like this (it also assumes your batch is always an integer)

CaptureCapture 

Do you know how many or max amount of items that are to be expected? Will the first batch always contain the max ingredients?

Do you always know the number of batches? If so you should be able to sort then use adjacent attribute mapping in an AttributeCreator to get something like this (it also assumes your batch is always an integer)

CaptureCapture 

you could run max & min on batch field using StatisticCalculator to determine batch count.

One way to do this is to assign a BatchCombination to all rows and check Fruit and BatchCombination with a ChangeDetector. If you have batches 1,2 and 3, you want to check BatchCombination 1,2 and BatchCombination 2,3.

FruitBatchChangeDetectionProbably faster with Python and lists, but this is one way to do it.

Thanks a million, this was indeed exactly what Iw as looking for.

Reply


Community Stats

30,161
Posts
114,492
Replies
37,813
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.