How to get the indices based on month and year?

8 views (last 30 days)
I have an array of data, "B", with a corresponding datetime array. The data spans between 2018-2022 but its not uniformly distanced so some months have more data than others. My plan is to loop through the data, get the data that corresponds to a month and year (ex. Jan 2020) and run some functions, and then get the data that corresponds to the next month and year, and repeat.
Is there any way I can do it more efficiently? Any functions where I can categorize the data by month and year?

Answers (1)

Walter Roberson
Walter Roberson on 3 Apr 2023
You can use timerange
But if you want to group by month, then typically it is easier to do something like take
[y, m] = ymd(DATETIMES);
G = findgroups(y, m);
Now you can use G together with splitapply

Categories

Find more on Matrices and Arrays in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!