Attach first column with names to matrix with coordinates

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!

Answer 1

[Jon]

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

Then to put the table into Excel

writetable(T,'mydata.xlsx','WriteRowNames',1)

[Panos Kerezoudis]

it worked, thank you!

[Jon]

You're welcome