How to filter tables in the cell?

Hey all, I have a 1x2 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

Answer 1

[Akira Agata]

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.

[BN]

Really thank you both answers are perfect.

Answer 2

[Walter Roberson]

cellfun(@(T) splitapply(@(varargin) {table(varargin{:}, 'VariableNames', T.Properties.VariableNames)}, T, findgroups(T.season)), C, 'uniform', 0)

The result will be a cell array the same size of C, each entry of which is a cell array containing 4x1 tables, one table for each season.