Options

Delete Attribute with Specified Number of Zero Value

yeopputrayeopputra Member Posts: 9 Learner I
in Help
Hi All

I need a guide on how to delete an attribute which have specified number of zero value. Let say I have an example set as below and I want to delete attribute that have three zero value (in this case I want to delete column A and B while retain column C)

A
0.0		 B
0.01848		 C
0.00308
0.0 0.0 0.0
0.00793 0.0 0.0
0.0 0.0 0.00648

Appreciate if anyone can guide me which operator that can do the job.

Thank you.

Best Answer

  • Options
    lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn
    Solution Accepted
    Hi @yeopputra,

    I have an approximative solution.
    You can find a process where the attribute(s) with strictly more than 2 "0" values are removed.
    You can adapt this process to your use case by setting the value of the macro (in the Set Macros operator).

    hope this helps,

    Regards,

    Lionel


Answers

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,507 RM Data Scientist
    Hi,
    check the operator Filter examples with Missings, which is part of operator toolbox.

    BR,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    yeopputrayeopputra Member Posts: 9 Learner I

    Thanks for the reply. Yes. The process works for me. Thanks again.

  • Options
    yeopputrayeopputra Member Posts: 9 Learner I

    Thanks for the reply. I will try this step too later. Thanks.

Sign In or Register to comment.