Extract a range of data acording to the date range from a table
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Mark Rodger
am 1 Feb. 2018
Kommentiert: Guillaume
am 7 Feb. 2018
I want to separate months of the year from a table into another table for each season.
3 Kommentare
Akzeptierte Antwort
Peter Perkins
am 1 Feb. 2018
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.
3 Kommentare
Fraser McMurray
am 7 Feb. 2018
Bearbeitet: Fraser McMurray
am 7 Feb. 2018
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
am 7 Feb. 2018
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)
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Loops and Conditional Statements finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!