Delete Attribute with Specified Number of Zero Value

yeopputrayeopputra MemberPosts:9Learner I
inHelp
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

  • lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, MemberPosts:1,195Unicorn
    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 theSet Macrosoperator).

    hope this helps,

    Regards,

    Lionel


Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University ProfessorPosts:3,438RM 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
    yeopputra
  • yeopputrayeopputra MemberPosts:9Learner I

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

  • yeopputrayeopputra MemberPosts:9Learner I

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

Sign InorRegisterto comment.