MATLAB: How to filter tables in the cell

cell arraysMATLABtable

Hey all, I have a 1×2 cell array (C), containing tables. In each table, I have a column named season. rows in the season column include Winter, Spring, Summer, and Autumn. So I need to have 4 new cells that each one contains only one season data. Like this:

C_winter

C_Spring

C_Summer

C_Autumn

Where each one contains:

{30×3 table}    {30×3 table}    {30×3 table}

Please let me know how I can do that.

Thanks

Best Answer

How about the following?

C_Winter = cellfun(@(x) x(strcmp(x.season,'Winter'),:),C,'UniformOutput',false);

The same solution will be applicable to other seasons.

Related Solutions

MATLAB: Cells merging in table

varfun(@(c) {vertcat(c{:})}, table1, 'GroupingVariables', 'Var1', 'InputVariables', 5:width(table1))

varfun(@(c) {vertcat(c{:})}, table1, 'GroupingVariables', {'Var1', 'Var2'}, 'InputVariables', 5:width(table1))

varfun(@(c) {vertcat(c{:})}, table1, 'GroupingVariables', {'Var1', 'Var2', 'Var3'}, 'InputVariables', 5:width(table1))

MATLAB: Fast subsetting or indexing of data

Whenever you find yourself copy-pasting code in Matlab, you should consider an array.

seasons={'Spring','Summer','Autumn','Winter'};
boatsPresent_t=boatsPresent.Var1; %time variables

boatsAbsent_t=boatsAbsent.Var1; %time variables
BP=cell(1,4);BA=cell(1,4);
[BP{:}]=indexSeasons(boatsPresent_t); %index times into seasons

[BA{:}]=indexSeasons(boatsAbsent_t); %index times into seasons
for n=1:numel(seasons)
    S=withtol(BP{n},seconds(1));
    BP_part=boatsPresent(S,:);
    writetable(timetable2table(BP_part),...
        fullfile(folder,strcat(site,'_PSD_boatsPresent_',seasons{n},'.csv')));
    
    S=withtol(BA{n},seconds(1));
    BA_part=boatsAbsent(S,:);
    writetable(timetable2table(BA_part),...
        fullfile(folder,strcat(site,'_PSD_boatsAbsent_',seasons{n},'.csv')));
end

If you have more states than just present and absent you should consider putting those states in an array so you can use it to generate logical indices.

Best Answer

Related Solutions

MATLAB: Cells merging in table

MATLAB: Fast subsetting or indexing of data

Related Question