MATLAB: Reshaping a vector of dates (2)

cell

Dear all, I have a cell column vector that contains the following elements

AAA={'AUGUST-SEPTEMBER 1999' ...
  'OCTOBER-NOVEMBER 1999'...
  'DECEMBER-JANUARY 2000'...
  'FEBRUARY-MARCH 2000'...
  'APRIL-MAY 2000'...
  'JUNE-JULY 2000'}

I want to change that vector so as to have

AAA={'AS  1999'...
'ON 1999'...
'DJ 2000'...
'FM 2000'...
'AM 2000'...
'JJ 2000'}

Where AS for example stands for 'AUGUST-SEPTEMBER’

thanks

[EDITED, code formatted, Jan]

Best Answer

g = regexp(AAA,'(^\w)|(-\w)|( \d*)','match');
AAA = strrep(cellstr(cell2mat(cat(1,g{:}))),'-','');

EDIT

Related Solutions

MATLAB: How to use datestr(now)

vec = datevec(now);
month_list = {'January' 'February' 'March' 'April' 'May' 'June' ...
    'July' 'August' 'September' 'October' 'November' 'December'};
your_string = sprintf('%i.%s year %i',vec(3),month_list{vec(2)}, vec(1))

Please accept the answer that best solves your problem.

MATLAB: Help using accumarray on a 3d-matrix

I think it's simpler to use mean directly and avoid accumarray. So to get all the rainfall for 1999, for example, you could do something like this:

days1999 = date(:,1) == 1999;
pp1999 = pp(:,:,days1999);

and then to get the mean for each location in 1999:

mean1999 = mean(pp1999, 3);    % 3 means average over time

or to get the overall mean for 1999:

overallMean1999 = mean(pp1999(:));

To select summer months (say June, July, August)

daysSummer = date(:,2) >= 6 & date(:,2) <= 8;
ppSummer = pp(:,:,daysSummer);

etc.

If you are doing several years you could replace the value 1999 by a variable and carry out the computation in a loop.

Best Answer

Related Solutions

MATLAB: How to use datestr(now)

MATLAB: Help using accumarray on a 3d-matrix

Related Question