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?
采纳的回答
Image Analyst
2019-8-11
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.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
