Clear Filters
Clear Filters

Problem with array and save file?

2 views (last 30 days)
Anh
Anh on 4 Apr 2023
Commented: Anh on 5 Apr 2023
%% 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

Accepted Answer

MarKf
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'})
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);

More Answers (0)

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!