Problem with array and save file?

1 次查看（过去 30 天）
Anh
Anh 2023-4-4
评论： Anh 2023-4-5
%% create
a = cell(10,5,3);
for participant = 1:10
for video = 1:5
a{participant,video,1} = participant ;
a{participant,video,2} = video ;
a{participant,video,3} = [
"Searching for Bobby Fischer",...
"D.O.A.",...
"The Hangover",...
"The Ring",...
"300",...
];
end
end
b = cell2table(num2cell(reshape( a, [10*5, 3])),...
'VariableNames', {'participant'; 'video'; 'video_name'});
writetable(b, 'load.xlsx', 'Sheet', 1);
I have some problem with my code above. I want to write a table like each video contain with each video_name like this
but my code for a table like this
How can i do to solve this problem? Can someone edit with my code? thank you

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

采纳的回答

MarKf
MarKf 2023-4-4
Ran in:
Do you need a 3D cell and then rehsape it or can you create it like the 2D table you want already?
videosn = ["Searching for Bobby Fischer",...
"D.O.A.",...
"The Hangover",...
"The Ring",...
"300"];
Nparticipants = 10; Nvideos = numel(videosn);
a = cell(Nparticipants*Nvideos,3);
for video = 1:Nvideos
for participant = 1:Nparticipants
idx = Nparticipants*(video-1)+participant;
a{idx,1} = participant;
a{idx,2} = video;
a{idx,3} = videosn(video);
end
end
b = cell2table(a,'VariableNames', {'participant'; 'video'; 'video_name'})
b = 50×3 table
participant video video_name ___________ _____ _____________________________ 1 1 "Searching for Bobby Fischer" 2 1 "Searching for Bobby Fischer" 3 1 "Searching for Bobby Fischer" 4 1 "Searching for Bobby Fischer" 5 1 "Searching for Bobby Fischer" 6 1 "Searching for Bobby Fischer" 7 1 "Searching for Bobby Fischer" 8 1 "Searching for Bobby Fischer" 9 1 "Searching for Bobby Fischer" 10 1 "Searching for Bobby Fischer" 1 2 "D.O.A." 2 2 "D.O.A." 3 2 "D.O.A." 4 2 "D.O.A." 5 2 "D.O.A." 6 2 "D.O.A."
% writetable(b, 'load.xlsx', 'Sheet', 1);

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Geometric Transformation and Image Registration 的更多信息

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by