Options

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

MPB_MPB_ Member Posts: 45 Guru
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 :)

Best Answer

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,517 RM 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

Answers

  • Options
    MPB_MPB_ Member Posts: 45 Guru
    Works perfectly fine. Thank you very much
Sign In or Register to comment.