MATLAB: Filter by category for categorical array in variable editor

bycategoryfilterMATLABtable

I am using MATLAB R2020a and I am following a tutorial online for Data Analysis within MATLAB. In the tutorial, it shows how to filter the columns by category via a dropdown. However, I am not seeing the same options available to me when I open the table in the variable editor. See example code and screenshot below:

%create random table
t1 = [1,2,3,4]';
t2 = {'Foo','Bar','Foo','Bar'}';
tbl = table();
tbl.t1 = t1;
tbl.t2 = t2;
% Convert to categorical
tbl.t2 = categorical(tbl.t2)

Best Answer

As of R2020a, the filter option via the dropdown can be viewed within the Live Editor. If you run the same code in the Live Editor, you should be able to see the filters. Our development team is aware of this limitation in Variable Editor and are actively looking into this for a future release.

Related Solutions

MATLAB: Filter table by character string entry

Hi Dan,

try this method out.


%create random table
t1 = [1,2,3,4]';
t2 = {'Hei','boo','Hei','boo'}';
tbl = table();
tbl.t1 = t1;
tbl.t2 = t2;
% Convert to categorical, as i presume this is reoccuring values
tbl.t2 = categorical(tbl.t2)
% index rows with the correct variables in column
idx = tbl.t2 == 'boo';
% create table based on index
newtbl = tbl(idx,:);

MATLAB: How to define categorical within factors in fitrm

When you create within_fact, you are defining a matrix with categories from 1 up to max(nr_cond, nr_sessions). So both columns of within_tbl1 are defined to have that many categories. It may be, say, that the first column has the notion of category 5 but doesn't actually have any data on that category.

When you create the variables in within_tbl2, each categorical variable is defined separately so it only has as many categories as actually appear in that column. This is what you almost certainly want.

Perhaps the way fitrm deals with this condition could be improved. I'll look into it.

Best Answer

Related Solutions

MATLAB: Filter table by character string entry

MATLAB: How to define categorical within factors in fitrm

Related Question