How to count the number of values per column / How to simulate the excel function "COUNTA"

MPB_MPB_ MemberPosts:45Guru
inHelp
Hi there,

is there a way to simulate the excel function COUNTA in rapidminer?

This function counts the number of entries in a column or in other words, the total number of non empty-values in a column.

The count functions I tried in Rapidminer are mostly counting occurance of each value in a column, but not the absolute number of all entries in a column.

Have a nice day:)

Tagged:

Best Answer

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University ProfessorPosts:3,404RM Data Scientist
    Solution Accepted
    Hi,
    Aggregate with count and no group by statement should do it?

    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
    MPB_

Answers

  • MPB_MPB_ MemberPosts:45Guru
    Works perfectly fine. Thank you very much
Sign InorRegisterto comment.