Grabbing Years of table data to Create New Tables

I have a table with two collumns. The first collumn is dates. The second collumn is the data. Is there an easy way to grab all the data from each year and create new tables?

[Josh Morell]

Answer 1

[Peter O]

A fast solution might be to use the Timestamp to extract the date for each row and then use the group capabilities of tables.

    [G, yrs] = findgroups(year(T.date))

Then you can iterate through each group, to get new tables. I'll place them into cells here, for simplicity and extnesibility. If you have a large number of years you may want to preallocate the cell.

    newTablesByYear = cell(numel(yrs),1)
    for ix=1:numel(yrs)
        newTablesByYear{ix} = T(G==ix,:)
    end

[Peter O]

• This solution assumes the first column is formatted as a datetime. If it's a date string then you may have to do a little extra formatting on the input before the YEAR() function knows what to do with it. See the help on datetime and datestr for some guidance.