How can I append dates and data to an array?

Question

I have the following code and wish to append the output to an array row by row. Each loop iteration should place the 1st date in Row 1, Column 1 and the first value of R should be placed in Row 1, Column 2. The next iteration will place additional information in the subsequent Row. The number of column entries will be predetermined but the number of Row entries will be indefinite. Please advise.

X = [41334:41340];
Y = [];
exceldate = X;
date = x2mdate(exceldate);

for i=1:1:7
    curDate  = datestr(date,26);
    %Write curDate value to Row i, column 1 of Y
    R(i) = i+1;
    %Write R(i) value to Row i, column 2 of Y
end

I'm trying to make Y look like:

2013/03/01 2
2013/03/02 3
2013/03/03 4
2013/03/04 5
2013/03/05 6
2013/03/06 7
2013/03/07 8

Bjoern H · Accepted Answer · 2013-03-27 14:24:37Z

1

You need to use a cell array for this.

Y = cell(7, 2);

In the loop you can then do:

Y{i, 1} = curDate;
Y{i, 2} = R(i);

Note that you need to use curly braces to assign to positions in the cell array.

answered Mar 27, 2013 at 14:24

Bjoern H

6004 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bjoern H Over a year ago

You're welcome. Please consider accepting the answer if it solved your problems.

Doresoom · Accepted Answer · 2013-03-27 14:27:26Z

0

You need to use a cell array to combine text (your date strings) and numeric values into a single array.

%# initialize sample date cell array
dates = cellfun(@datestr,{now,now+1,now+2},'UniformOutput',false)';
%# intialize sample data array
numVals = [1:3]';
%# combine
out = [dates,num2cell(numVals)];

answered Mar 27, 2013 at 14:27

Doresoom

7,45814 gold badges50 silver badges62 bronze badges

Collectives™ on Stack Overflow

How can I append dates and data to an array?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related