How to extract all the data for a fixed year

4 次查看（过去 30 天）
peter huang
peter huang 2022-1-19
评论： peter huang 2022-1-19
How to extract all the data for a fixed year and write a loop to get the annual data 1961, 1962...
  2 个评论
Rik
Rik 2022-1-19
That shouldn't be too hard. What have you tried?
peter huang
peter huang 2022-1-19
I tried to use the datenum command but I don't know how to get the whole year

请先登录，再进行评论。

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

回答（1 个）

Cris LaPierre
Cris LaPierre 2022-1-19
Ran in:
Load your data with readtable, with the dates imported as datetimes. Then you can use the isbetween function to identify the rows that are between two datetimes. If you want all the data within one year, you could also use logical indexing.
Your date format presented a small challenge that requried me to first load the date as a string and then convert it to a datetime.
opts = detectImportOptions("moving_windown_test.xlsx");
opts = setvartype(opts,1,"string");
data = readtable("moving_windown_test.xlsx",opts);
data.Var1 = datetime(data.Var1,"InputFormat","yyyyMMddHH");
data1964 = data.Var2(year(data.Var1)==1964)
data1964 = 8716×1
-226 -506 -766 -666 -456 -206 65 256 366 436

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by