count the number of repetitions of an attribute

acurielacuriel Member Posts: 13 Contributor I
edited November 2018 in Help
Hi!!

I need to count the number of repetitions of an attribute. This is real.

my attribute:

row      ITEM (Count)
1            1
2            1
3            1
4            2
5            3
6            3
...          ...

I like this

row  Item    count
1        1          3
2        2          1
3        3          2
...      ...        ...



thanks :)




Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,453 RM Data Scientist
    simply use aggregate with count on ITEM and Group by ITEM.
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • acurielacuriel Member Posts: 13 Contributor I
    thanks :)
Sign In or Register to comment.