JSL, delete a column if there's only 1 'group', labeled in another column?Curious about this.
I've got a dt with several thousand columns that I'm scripting some cleansing for further analysis. The data set is process data, where each row is a unique process run from a given machine. Some machines don't report out all the full list of sensors, so I'm stuck with a few hundred columns only coming from a single machine. I'd like to purge these, as I can't do any statistical comparisons with this data.
Any advice?
AnalyticsData TableScriptingRe: JSL, delete a column if there's only 1 'group', labeled in another column?The Missing Data Pattern platform
Tables=>Missing Data Pattern
can identify the rows that have specific patterns of missing values. From that, you can select the rows with the specified patterns, and then delete the rows.
