Problem with array and save file?
2 views (last 30 days)
Show older comments
%% 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
0 Comments
Accepted Answer
MarKf
on 4 Apr 2023
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'})
% writetable(b, 'load.xlsx', 'Sheet', 1);
More Answers (0)
See Also
Categories
Find more on Geometric Transformation and Image Registration 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!