How to extract all the data for a fixed year

How to extract all the data for a fixed year and write a loop to get the annual data 1961, 1962...

[Rik]

That shouldn't be too hard. What have you tried?

[peter huang]

I tried to use the datenum command but I don't know how to get the whole year

Answer 1

[Cris LaPierre]

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