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

1 次查看（过去 30 天）
Mark Rodger
Mark Rodger 2018-2-1
评论： Guillaume 2018-2-7
I want to separate months of the year from a table into another table for each season.
  3 个评论
显示 1更早的评论
Mark Rodger
Mark Rodger 2018-2-1
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
Mark Rodger 2018-2-7
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

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Peter Perkins
Peter Perkins 2018-2-1
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 个评论
显示 1更早的评论
Fraser McMurray
Fraser McMurray 2018-2-7
编辑：Fraser McMurray 2018-2-7
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
Guillaume 2018-2-7
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)

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by