Count lines

Question

Quoted from sf-forum:

Hi,

Which operator can I use to count lines after applying a filter ? 
Also, which operator can I use to filter for unique values in data ?

Thanks.

TobiasMalbrecht · Answer

Hi again,

I must add, that the process I gave in the last posting does only work with the newest CVS version of RapidMiner since we recently extended the [tt]Aggregation[/tt] operator to allow the aggregation of multiple attributes as well as grouping by several attributes.

http://rapid-i.com/content/view/25/48/lang,de/

explains how to access the CVS version easily via Eclipse.

Regards,
Tobias

TobiasMalbrecht · Answer

Hi, I am not quite sure, if I have understood what you want to do. So I try to sort out your intention. Correct me, if I get it wrong. First you want to count the distinct values of each attribute, then in a second step you want to scale the values of each attribute by the reciproke of this number, i.e. the number of distinct value the attribute has. Is that correct? Or does the attribute not necessarily have to be the same in the counting of the number of distinct values and the application when scaling the attribute values? Another question: if you want to scale the attribute values, I assume that your attributes are numerical? If this is the case, i.e. that all attributes are numerical, I would say that the task you want to perform is not possible at the moment. However I attached a process which shows how to count occurances of a attribute values (of att1) and how to attach the number of occurances to the corresponding attribute value. Check out the process and you will understand what I mean by that. However, I think this process only works with nominal attributes ... but maybe you get an inspiration for your process design. Otherwise maybe you can clarify a little bit what exactly you are intending to do and answer my questions from above. Here is the process I promised: Regards, Tobias

Legacy User · Answer

Thanks for the prompt answer.

I'm able to filter data but I would like to use the count result in a further operator as input. Is it possible ?
For instance, filter1 provides a set as 15 lines, then I would like to apply another filter to build another set with a new attribute att4 = att4/15.

About unique count, I would like to count lines by removing duplication value of a given attribute.

Thanks for your help.