Data Filtering Help Needed?

Hi I have a data table that I loaded through the workspace.

I saved this table into a variable, let's say x.

Now in one specific column, it says Y for a yes and blank for a no.

How can I cut out the rows that have a blank space in that column?

Answer 1

[Image Analyst]

Try something like this:

col = 2; % Whatever it is...
theColumn = x{:, col}; % Extract column 2 as a cell array from the table.
rowsToDelete = contains(theColumn, ' ');
x(rowsToDelete, :) = []; % Delete all rows where a space was in col 2

If that doesn't work, attach x in a .mat array:

save('answers.mat', 'x');

and attach it with the paper clip icon.

[Minjun Seo]

Hi, I attached the data file above, maybe my wording was off but the method you provided did not work. I would also like to know how to delete the rows from the table and saving it to another place.