Attach first column with names to matrix with coordinates

Question

Panos Kerezoudis 2023-4-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1946114-attach-first-column-with-names-to-matrix-with-coordinates

评论： Jon 2023-4-12

Hi!

I have a matrix ('positions') with 3 columns (x,y,z coordinates) and 200 rows (intracranial electodes).

I also have a character variable ('name') that contains an abbreviated name for each electrode. Is there a way to attach this column to the matrix, other than creating essentially a cell array? The goal is to ultimately export this matrix/dataset as an excel file (ie it will contain 4 columns and 200 row entries).

Thank you!

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

请先登录，再进行评论。

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

Answer 1

Jon 2023-4-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1946114-attach-first-column-with-names-to-matrix-with-coordinates#answer_1214654

编辑：Jon 2023-4-12

在 MATLAB Online 中打开

You can put the data into a table, and assign row names

For example

x = rand(5,1);
y=rand(5,1);
z=rand(5,1);
names = {'cat','dog','fish','mouse','bird'};
T = table(x,y,z,'RowNames',names)
T = 5×3 table
                x          y           z    
             _______    ________    ________

    cat      0.13646     0.65798     0.57989
    dog      0.13375     0.44793     0.50756
    fish     0.12136     0.43526     0.22403
    mouse    0.26111    0.068975    0.063686
    bird     0.22265      0.1669     0.29217