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.
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.
this looks like a very old question, but I run into a similar problem,
I have a large table, with many columns, in these columns many fields are empty, but if there is at least one real value, I would like to keep such a column.
I only want to remove columns that are entirely empty … is there a solution by now?
transposing etc did not work in my described case, as I then also would remove columns that I still want to keep.
Hi @j_wollenhaupt , I don’t know if there are other shorter variants of this, or whether this will work ok with a large data set, but it may be of assistance
Hi @j_wollenhaupt, I was thinking the same thing about how I missed that node… But it was fun. There’s another node that might be worth a look too for similar use cases… I’ve not tried it out but it’s the Constant Value Column Filter
very nice @elsamuel
keep it simple. I was thinking about column loop so way to complex. That’s exactly why it is so interesting to see other solutions here
br