MATLAB: Insert first value in vector into next 11 lines using an If loop

fill downif loopinsert rows

I have a vector 8754×1 with hourly temperature data in it for a whole year. I have created a new vector and inserted 11 rows of zeros between each temperature point in order to create a time series of 5 minutes data with 105048 rows. This means the 1st, 13th, 25th etc. rows have temperature data in them and the 2-12, 14-24, 26-36 etc. rows have zeros in them.

I would like to copy the temperature data from row 1 into rows 2-12 and then go onto copy the temperature data from row 13 into rows 14-24 for the whole data set. I think I need to use an ‘if’ loop to do this, but I am new to Matlab and I am not sure where to start. Any help would be gratefully received.

Best Answer

This follows your specified pattern using the repmat function:

T = your 8754x1 temp data vector
Tresult = reshape(repmat(T',12,1),[],1);

Related Solutions

MATLAB: Leaping loop with constant rows for each identity

A - your array (n x 1)

out = conv2(A,ones(12,1)/12,'valid');

MATLAB: Putting columns from an array into evenly spaced columns in excel

You could always write it in a loop, e.g. using the char-int conversion.

As an alternative: instead of writing a matrix, you can write a cell array. This allows you to leave certain cells and columns empty. Here is an example:

Tresult = randn(5,10);
% write settings
filename1 = 'hProfile';
start_cell = 'C1';  % starting cell
Sheet = 1;          % sheet number
skip_col = 1;       % number of empty columns between entries
% transform into cell and insert empty columns
Nrows = size(Tresult,1);
Ncols = size(Tresult,2);
Tresult_cell = cell(Nrows,(1+skip_col)*Ncols);
Tresult_cell(:,1:(1+skip_col):end) = num2cell(Tresult);
% write file
xlswrite(filename1,Tresult_cell,Sheet,start_cell);

! Note that this will overwrite whatever was in your excel file before, i.e. the "empty" cells will also be written, but they will just be empty.

Cheers

Best Answer

Related Solutions

MATLAB: Leaping loop with constant rows for each identity

MATLAB: Putting columns from an array into evenly spaced columns in excel

Related Question