🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

How can I take only the variables with at least 5.000 observations?

User: "ceci_ro"
New Altair Community Member
Updated by Jocelyn
Hello folks, 

I need a hand here...
How can I take only the variables with at least 5.000 observations?
I have too many variables, thank you in advance.


Cecilia 



Find more posts tagged with

Sort by:
1 - 3 of 31
    User: "BalazsBaranyRM"
    New Altair Community Member
    Accepted Answer
    Hi @ceci_ro

    one approach would be using the Quality Measures operator. It calculates measures like missing values for each attribute.
    Then "ExampleSet to Weights" from the Converters extension. Here you can select the attribute name and the measure you need (missing values). 
    Then "Select by Weights" with a copy of the original data and the weights you created. Weight relation = less equals, weight = e. g. 0.2 or whatever is appropriate for your data.

    Regards,
    Balázs 
    User: "ceci_ro"
    New Altair Community Member
    OP
    Hi @BalazsBarany

    Thank you very much. I think it is works!!

    Great explained :smile:

    Regards, 

    Cecilia


    User: "ceci_ro"
    New Altair Community Member
    OP
    Accepted Answer
    There is an operator that does this function: Toolbox extension, Filter Attributes with Missing Values ​​operator. Simple and beautiful.