MATLAB: Extract a range of data acording to the date range from a table

data acquisition

I want to separate months of the year from a table into another table for each season.

Best Answer

There's only four seasons, best to not overthink this.

spring = t(ismember(month(t.Time),1:3),:);

etc. But Guillaume's advice is worth thinking about.

Related Solutions

MATLAB: How to define a new variable in a table, Part 2

Try this

T = % you table
Months = {'January', 'February', 'March', 'April', 'May', 'June', ...
    'July', 'August', 'September', 'October', 'November', 'December'}.';
Mnth2Season = [1 1 1 2 2 2 3 3 3 4 4 4].'; % for example
Seasons = {'Winter', 'Spring', 'Summer', 'Autumn'}.';
[~, idx] = ismember(T.Months, Months);
T.Season = Seasons(Mnth2Season(idx));

MATLAB: How to modify this code for calculation seasonal values for each year (not all years)

Try this

data = load('CELL.mat');
CELL = data.CELL;
month_names = month(datetime(1,1,1):calmonths(1):datetime(1,12,1), 'name');
seasons = ["Spr", "Sum", "Aut", "Win"];
for i=1:numel(CELL)
    CELL{i}.grid_name = [];
    CELL{i}.month = month_names(month(CELL{i}.dates))';
    CELL{i}.seasons = seasons(floor((month(CELL{i}.dates)+2)/3))';
    grps = findgroups(findgroups(year(CELL{i}.dates), CELL{i}.seasons));
    avg_value = accumarray(grps, CELL{i}.rrr24, [], @mean);
    CELL{i}.Average = avg_value(grps);
end

Best Answer

Related Solutions

MATLAB: How to define a new variable in a table, Part 2

MATLAB: How to modify this code for calculation seasonal values for each year (not all years)

Related Question