Select all attributes having only missing value

zubairali_jzubairali_j MemberPosts:1Contributor I
edited November 2018 inHelp

Hi,

我如何选择所有的属性LY missing values in Rapidminer tool. I dont want to select other attributes which has both missing and non-missing values. If I put 'no_missing_values' in attribute_filter_type option in 'Select Attributes' operator and inverse selection, it select the rows which has both missing and non-missing values. But I need to select attributes which has all the values missing.

Thanks,

Zubair

Tagged:

Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University ProfessorPosts:3,404RM Data Scientist

    Dear Zubairali,

    interesting question. I did not find a one operator solution. Attached is a longer process doing the job. I would be curious if there is an easier way to do it.


    ~Martin
































    Get A data set
















































    <连接from_op = from_port =“提取宏(2)交货ample set" to_op="Branch" to_port="condition"/>

    < portSpacing端口= " source_exampleset" spacing="0"/>




















    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • IngoRMIngoRM Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University ProfessorPosts:1,751RM Founder

    Well, a shorter version (although not exactly the same) is to just use "Replace Missing Values" with a constant value NOT in the data. Then use "Remove Useless Attributes". Of course this one also removes other attributes which are constant (but how useful are those?). You can then turn the constant value you have used above back into a missing again with "Declare Missing Value".

    Here is the code:
































    Get A data set
























    Cheers,

    Ingo

Sign InorRegisterto comment.