Attach first column with names to matrix with coordinates

2 次查看（过去 30 天）
Panos Kerezoudis
Panos Kerezoudis 2023-4-12
评论： 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!

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

采纳的回答

Jon
Jon 2023-4-12
编辑：Jon 2023-4-12
Ran in:
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)

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by