How to name rows with same names?
1 view (last 30 days)
Show older comments
I have data with 336*5 size.I would like to name the first 122 rows with one name and 113 to 224 with different name and 225 to 336 with another name .Also each column (5 columns) with 5 different name.Can we do this ? The data is of double type.Finally i need save this with excel type data.
0 Comments
Answers (2)
KSSV
on 6 Jul 2022
a = rand(336,5) ; % random data for demo
[r,c] = size(a);
nlay = 3;
b = permute(reshape(a',[c,r/nlay,nlay]),[2,1,3]);
for i = 1:nlay
T = array2table(b(:,:,i)) ;
writetable(T,'myData.xls','Sheet',i)
end
0 Comments
Rohit Kulkarni
on 6 Jul 2022
Edited: Rohit Kulkarni
on 6 Jul 2022
Hi,
A similar question has been answered earlier.
For assiging different names to columns, you can do this: if you already have a matrix and want to convert it to table:
array2table(matrix, 'VariableNames', {'Name1', 'Name2', 'Name3', 'Name4', 'Name5'})
or you can do the following if you already have the table
Table.Properties.VariableNames = ["Name1", "Name2", "Name3", "Name4", "Name5"]
"Finally i need save this with excel type data", do you want to write data to excel spreadsheet?
Use
writetable()
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!