Data Filtering Help Needed?
1 次查看(过去 30 天)
显示 更早的评论
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?
0 个评论
采纳的回答
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 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!