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

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

[Guillaume]

This is easy to do (with splitapply) but also most likely pointless. Whichever processing you want to do on your four (?) season tables you most likely could do on the whole table and get a result per season.

Can you clarify why you want to do that?

[Mark Rodger]

It's part of my project where I need to show the wind speed for each season. The table has 2 years of wind speed with two variables: Time and WindSpeed. Could you help me with this?

[Mark Rodger]

I forgot to mention that the table has 2 years worth of data (2013-2014). Is there a way to extract one season of one year

Answer 1

[Peter Perkins]

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.

[Mark Rodger]

I forgot to mention that the table has 2 years worth of data (2013-2014). Is there a way to extract one season of one year. Also is there a way to extract weekends and weekdays.

[Fraser McMurray]

If you want to view a specific year you can try this:

april = x(ismember(month(x.time),4),:);

april2013 = april(ismember(year(april.time),2013),:);

[Guillaume]

Again, it is very likely that you don't need to separate the table at all and that it may be more efficient to work on the whole table at once.

For example, if you wanted to calculate the mean wind speed per season per year:

[group, season, year] = findgroups(discretize(month(yourtable.time), [1 4 10 12]), year(yourtable.time));
meanwindspeed = splitapply(@mean, yourtable.windspeed, group);

result = table(season, year, meanwindspeed)