How to name rows with same names?

2 views (last 30 days)
C PRASAD
C PRASAD on 6 Jul 2022
Edited: Rohit Kulkarni on 6 Jul 2022
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.

Answers (2)

KSSV
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

Rohit Kulkarni
Rohit Kulkarni on 6 Jul 2022
Edited: Rohit Kulkarni on 6 Jul 2022
Hi,
A similar question has been answered earlier.
Please refer this MATLAB answer for assigning same row name for a range of rows.
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"]
Refer the documentation here.
"Finally i need save this with excel type data", do you want to write data to excel spreadsheet?
Use
writetable()
Refer the documentation here.

Community Treasure Hunt

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

Start Hunting!