The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

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

MPB_MPB_ Member Posts: 45 Guru
in Help
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, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 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

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