MATLAB: Re-arrange vectors from rows to columns

re-arrange vectors

I have 3 vector in rows as follows:

A = 1 1 1 1 1 1 1 1 1 1

B= 2 2 2 2 2 2 2 2 2 2

C= 3 3 3 3 3 3 3 3 3 3

I need only one vector with A, B and C as columns as follows:

1 2 3

Thank you!

Best Answer

A = [1 1 1 1 1 1 1 1 1 1];

B= [2 2 2 2 2 2 2 2 2 2 ] ;

C= [3 3 3 3 3 3 3 3 3 3];

A=A';

B=B';

C=C';

D=[A B C]

Related Solutions

MATLAB: Re-arrange CRSP Data

I would elect to do this using a table. However, column headers in a table are variable names, and MATLAB variables cannot be numbers. That means a little modification will be needed. You can set the codes as the rownames and the modified dates as the variableNames (column headers).

This is a bit of a hack, and can likely be improved. Still, this should get you started

file = 'US_500_Book_SRT.xlsx';
opts = detectImportOptions(file);
% Your dates are in a numeric 'yyyymmdd' format that can't be recognized by readtable.
% I import them as numbers here and convert them later.
opts = setvartype(opts,1,'categorical');
% load data
data = readtable(file,opts);
% convert dates from numeric 'yyyymmdd' to datetime 'yyyyMM'
datetimeYY = @(D)datetime(D,'ConvertFrom','yyyymmdd','Format','yyyyMM');
data = convertvars(data,2,datetimeYY);
% I want to use dates as a grouping mechanism, so convert to categorical as well.
data = convertvars(data,2,'categorical')
% extract the unique stock codes and yyyyMM dates
stocks = categories(data.Var1);
dates = categories(data.Var2);
% Find groups, using indeces to assign to row, column of matrix
Gs = findgroups(data.Var1);
Gd = findgroups(data.Var2);
mat2 = zeros(length(stocks),length(dates));
% Didn't find a more elegant way to do this. Loop through each row of data
% Assign to table using stocks group for the row number and dates group for the column
for loop = 1:length(Gs)
    mat2(Gs(loop),Gd(loop)) = data.Var3(loop);
end
% Convert mat2 to a table
tbl2 = table(mat2);
tbl2 = splitvars(tbl2);
% assign stock codes as rownames
tbl2.Properties.RowNames = stocks;
% make column names dates (prepend with 'd_' so it is a valid MATLAB variable name)
tbl2.Properties.VariableNames = 'd_' + string(dates);

MATLAB: How to multiply a vector 3 times to get a 3 dimentional matrix

B * B' .* reshape( B, [1 1 3] );

if B starts as a column matrix. In your case above B * B' would in itself result in a scalar as B is a row matrix.

Obviously if you start with a row vector you can just do

B' * B .* reshape( B, [1 1 3] )

Best Answer

Related Solutions

MATLAB: Re-arrange CRSP Data

MATLAB: How to multiply a vector 3 times to get a 3 dimentional matrix

Related Question