How to save to a csv file?
20 views (last 30 days)
Show older comments
Hi all,
I have 20 folders with mutiple mat files which are 1 x 1 structures with a 1 x 54 table as in the image below (showing just first 10 columns)
I managed to list all folders and all the desired files.
I want to access each structure from all folders and save as one csv file which will be a 20x54 table. Below is what I got and saving to a csv file gives me issues. Can you help please?
for k = 1:numel(sq_dot_1) % for list of mat files
if isempty(sq_dot_1{k})
continue
end
disp(sq_dot_1{k}.name)
A = fullfile(topLevelFolder,subFolders(k).name,sq_dot_1{k}.name);
Dot1 = load(A); %load data
writetable(Dot1.Stats(k), 'sq_Dot1.csv'); % save to csv file
end
Subscripting into a table using one subscript (as in t(i)) or three or more subscripts (as in t(i,j,k)) is not supported.
Always specify a row subscript and a variable subscript, as in t(rows,vars).
0 Comments
Accepted Answer
Simon Chan
on 10 Mar 2022
Try the following:
writetable(Dot1.Stats, 'sq_Dot1.csv','WriteMode','Append');
More Answers (0)
See Also
Categories
Find more on Tables 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!