remove rows if they contain ?
1 view (last 30 days)
Show older comments
I want to remove all rows that contain ?
The issue is that ? could be in any of my 14 columns
I tried this code ("data" is the name of my table here)
data(ismember(data,'?'),:)=[];
but i get the error
Error using tabular/ismember (line 37)
A and B must both be tables, or both be timetables.
Answers (1)
Image Analyst
on 23 Feb 2019
Edited: Image Analyst
on 23 Feb 2019
This works:
column1 = {'a'; 'b'; '?'; 'c'; 'd'}
column2 = {'a'; '?'; 'x'; 'c'; 'd'}
data = table(column1, column2)
% Now that we have sample data, delete any column with a '?' in it.
rowsToDelete = any(contains(data{:, :} , '?'), 2)
data(rowsToDelete, :) = []
0 Comments
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!