join char/cell to double matrix

Question

fede 2015-9-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/244343-join-char-cell-to-double-matrix

编辑： Image Analyst 2015-9-21

I have

c=['IBM';'SPY';'IVV'];
celldata=cellstr(c);

and

price= hist_stock_data(celldata');

I want a matrix as the following:

IBM     SPY    IVV
price1 price2 price3

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Image Analyst 2015-9-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/244343-join-char-cell-to-double-matrix#answer_193227

在 MATLAB Online 中打开

How about constructing a cell array

for col = 1 : size(c, 1)
    % For each row in c
    % Extract row from character array and place into a cell.
    ca{col, 1} = c(col, :); % String goes into first row of cell array.
    % Stuff number into second row of this column:
    ca{col, 2} = price(col);
end

Or you could use a table variable instead of a cell array.

2 个评论
显示无隐藏无

fede 2015-9-21

yes but the size of prices is 840,3, and not 1,3

Image Analyst 2015-9-21

编辑：Image Analyst 2015-9-21

在 MATLAB Online 中打开

Looks like you forgot to mention that at first so there's no way I could have known. So just add a loop to add rows

for col = 1 : size(c, 1)
    % For each row in c
    % Extract row from character array and place into a cell.
    ca{col, 1} = c(col, :); % String goes into first row of cell array.
    % Stuff number into rows of this column:
    for row = 1 : size(price, 1)
        ca{col, row+1} = price(row, col);
    end
end

Since you're not yet familiar with for loops and the size function (or else you would not have asked me), you should probably look up information on the for loop and the size function in the help documentation, since it's pretty basic yet crucial to know.

Actually, you'd better study up on cell arrays in the FAQ also: http://matlab.wikia.com/wiki/FAQ#What_is_a_cell_array.3F because they're far trickier than for loops.

请先登录，再进行评论。