Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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

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

AI Studio

Feature Selection

Filtering

Accepted answers

BalazsBaranyRM

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

ceci_ro

There is an operator that does this function: Toolbox extension, Filter Attributes with Missing Values operator. Simple and beautiful.

All comments

BalazsBaranyRM

ceci_ro

Hi @BalazsBarany,

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

Great explained

Regards,

Cecilia

ceci_ro

There is an operator that does this function: Toolbox extension, Filter Attributes with Missing Values operator. Simple and beautiful.