How to name rows with same names?

1 次查看（过去 30 天）
C PRASAD
C PRASAD 2022-7-6
编辑： Rohit Kulkarni 2022-7-6
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.

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

回答（2 个）

KSSV
KSSV 2022-7-6
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 2022-7-6
编辑：Rohit Kulkarni 2022-7-6
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.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by