topic Select cols where null, based on other col's classification AvB? in Discussions

Select cols where null, based on other col's classification AvB?

TriangularLlama — Fri, 23 Aug 2024 15:28:32 GMT

Trying to brainstorm this. I have a big data set with a grouping col A vs B, then hundreds of data feature cols. One problem is that some of the cols only have data for one group or the other and thus aren't useful, so I want to select and exclude those cols.

How would I script: search group of cols when all rows = null for any of the groups

Re: Select cols where null, based on other col's classification AvB?

jthi — Fri, 23 Aug 2024 15:34:27 GMT

You might want to check out if Explore Missing Values is able to solve your problem

Re: Select cols where null, based on other col's classification AvB?

jthi — Fri, 23 Aug 2024 15:56:42 GMT

And maybe even more Missing Data Pattern (link for Explore missing values)