Attach first column with names to matrix with coordinates
5 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Jon
le 12 Avr 2023
Modifié(e) : Jon
le 12 Avr 2023
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)
Then to put the table into Excel
writetable(T,'mydata.xlsx','WriteRowNames',1)
2 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Type Conversion dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!