User login

Removing columns where every value is empty

Fri, 04/01/2011 - 10:10 — greglandrum

The RDKit R-group decomposition node generates a lot of empty columns (empty = every cell contains a missing value). I would like to be able to filter these columns out so that the results are easier to work with.

I'm pretty sure I have already seen a node to do this, but I cannot find it.

Any suggestions?

-greg

‹ Interactive Table Enhancement Request Statistics node bug ›
Fri, 04/01/2011 - 10:45 — richards99

You should be able to

You should be able to transpose the table, then use Row Filter, then Choose Missing Value Match, and then on the left panel choose Exclude by Attribute. Then transpose back.

I hope this is what you are looking for.

Fri, 04/01/2011 - 15:48 — greglandrum

That's rather a lot of work

That's rather a lot of work for what is fundamentally a fairly simple operation. Would be nice to have something more straightforward.

-greg