How to extract all the data for a fixed year
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
How to extract all the data for a fixed year and write a loop to get the annual data 1961, 1962...
2 Kommentare
Antworten (1)
Cris LaPierre
am 19 Jan. 2022
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)
0 Kommentare
Siehe auch
Kategorien
Mehr zu Dates and Time 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!