Sum cumulative value from all files that is summoned in a loop

1 view (last 30 days)
I want to add the row length of the variable 'time' in a file (length(dataset.time)) from multiple datasets that are summoned in a loop. My setup is a follows:
datafolder = ' Z:\Projects\data';
file = dir(datafolder);
for i = 3:105
patient = load(strcat(datafolder,'\',file(i).name));
dataset = patient.table
row_length = length(dataset.time)
sum_length = ?
For now, ' row_length' only outputs the number of rows from the last dataset.
How do I add the total number of rows from dataset 3:105?
Hope you can help
  2 Comments
Stephen23
Stephen23 on 20 Apr 2022
Edited: Stephen23 on 20 Apr 2022
SRRellum
SRRellum on 20 Apr 2022
Thanks, good point. This was indeed the easy way out. I will change it

Sign in to comment.

Accepted Answer

Davide Masiello
Davide Masiello on 20 Apr 2022
Inside the loop write
row_length(i) = length(dataset.time);
After the loop, you can calculate the summ of all lengths with
sum_length = sum(row_length);
  1 Comment
SRRellum
SRRellum on 20 Apr 2022
Thanks for yout help. It works, however it gives the message to consider preallocating. Will look into that.

Sign in to comment.

More Answers (1)

David Hill
David Hill on 20 Apr 2022
datafolder = ' Z:\Projects\data';
file = dir(datafolder);
row_length = 0;
for i = 3:105
patient = load(strcat(datafolder,'\',file(i).name));
dataset = patient.table
row_length = row_length+length(dataset.time)
end
  1 Comment
Stephen23
Stephen23 on 20 Apr 2022
Edited: Stephen23 on 20 Apr 2022
Fragile/buggy code:
for i = 3:105
Lets try it with some simple, perfectly valid filenames:
csvwrite('+new.txt',1)
csvwrite('-old.txt',1)
csvwrite('test.txt',1)
dir()
+new.txt -old.txt . .. test.txt
Fragile at best, buggy at worst.

Sign in to comment.

Categories

Find more on Downloads in Help Center and File Exchange

Products


Release

R2018b

Community Treasure Hunt

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

Start Hunting!