How do I sort values into quarters?

1 次查看（过去 30 天）

matla6123 2017-4-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/336895-how-do-i-sort-values-into-quarters

编辑： Andrew Newell 2017-4-24

I have a matrix that lists dates and values as below. It goes through days with each value, then repeats for the next person. It is thousands of values long (length=n).

731521 1

731522 1

731523 1

731524 2

731525 2

I have date values that correspond to the starting dates of 27 quarters... 733408

733499

733590

733682

733774

733864

733955

I want to create a matrix that is n x 27 where (1,1) will be the value for the first person at date 733499 (Q1), (2,1) will be the second quarter value of the first person. (1,2) will be the first quarter value for the second person.... and so on.

I have some code that I used previously to do a similar command, summing the values for each person within each period. But this time I just want the value on the first day of each quarter. That code was...

for j=1:1:length(quarter_start_days)-1
        quarter_initialvalue(l,j) = quarter_initialvalue(l,j) + ...
             new_data(logical((new_data(:,1)>=...
        quarter_start_days(j))...
        .*(new_data(:,1)<...
        quarter_start_days(j+1))),2);
  format short g
end

Where 'new_data' was the matrix consisting of each day a value was held for. All the new_data values make up the matrix that is n x 2 listing all days and values for each person.