MATLAB Answers

Filter contents of a table

3 views (last 30 days)
Deepa Maheshvare
Deepa Maheshvare on 7 Dec 2019
Answered: dpb on 7 Dec 2019
I've the following table
tbl = table(['1'; '2'; '3'; '4'; '5'; '6'],['1'; '3'; '2'; '2'; '4'; '1'],'VariableNames', {'name', 'value'})
I would like to filter rows that don't have 'value' 3 and 4.
Expected result:
tbl = table(['1'; '3'; '4'; '6'],['1'; '2'; '2';'1'],'VariableNames', {'name', 'value'})
Any suggestions on how this can be done?

  0 Comments

Sign in to comment.

Accepted Answer

dpb
dpb on 7 Dec 2019
Why are numeric values entered as text/characters?
ix=~ismember(str2num(tbl.value),[3 4]);
tbl=tbl(ix,:);
If the real question is for table that is using nonnumeric character data, then use one of the string search functions instead. For the actual question, I'd strongly suggest either build the table as numeric to begin with or immediately convert to double.

  0 Comments

Sign in to comment.

More Answers (0)

Sign in to answer this question.

Tags

Products


Release

R2019b