MATLAB: Filter contents of a table

MATLABtable

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?

Best Answer

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.

Related Solutions

MATLAB: Remove rows of a table based on values in an array

disp('Original table');
var1=[1;1;1;1;4;1];
var2=[2;2;2;2;5;2];
var3=[0;3;3;8;8;9];
table_data=table(var1,var2,var3)
n=histc(var3(:),var3);
disp('Updated table');
table_data(find(n==1),:)=[]

Result Window:

Original table
table_data =
  6×3 table
    var1    var2    var3
    __    ____    ____
    1       2       0   
    1       2       3   
    1       2       3   
    1       2       8   
    4       5       8   
    1       2       9   
    
Updated table
table_data =
  4×3 table
    var1    var2    var3
    ____    ____    ____
    1       2       3   
    1       2       3   
    1       2       8   
    4       5       8

MATLAB: Splitvars for input arguments of type ‘cell’

As per my comment to your other question, it looks like Multico should be a matrix not a cell array.

Regardless of its type, what you want is simply:

newtable = splitvars(yourtable, 'Multico')

Best Answer

Related Solutions

MATLAB: Remove rows of a table based on values in an array

MATLAB: Splitvars for input arguments of type ‘cell’

Related Question