How to extract all the data for a fixed year
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
How to extract all the data for a fixed year and write a loop to get the annual data 1961, 1962...
2 commentaires
Réponses (1)
Cris LaPierre
le 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 commentaires
Voir également
Catégories
En savoir plus sur Dates and Time dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!