save each array of a cell as sequence xls files

Hello Every one,

In the code bellow, I have tried to read .csv files which were named as "Book1, Book2, Book3,..." (I have 5000 .csv as mentioned tempelate from experiments)

I just wanted to keep 4 columns and also rows which positive values.

after that I need to save each of them again as new files like "new1, new2, new3, ...."

I've got stucked on saving them cause I prepare cell to do that calculation and now I need to write each array of cell as a seperate file.

here is my code:

files = dir ('E:.......\Book*.csv')

N = length(files);

data = cell (1,N);

for i=1:N

data {i} = csvread(files(i).name);

modified {i} = data{i} (: , [1 2 4 5]);

new {i} = modified {i} (modified {i} (:,1)>0, :);

end

I will be so thankful if you can help me to now save the new{i} as seperated files with sequence.

Best Regards,

Answer 1

[Ameer Hamza]

There are several functions to save data in MATLAB

https://www.mathworks.com/help/matlab/ref/writematrix.html

https://www.mathworks.com/help/matlab/ref/writecell.html

https://www.mathworks.com/help/matlab/ref/writetable.html

The variable new {i} is probably a numeric matrix, so you can write

writematrix(new{i}, ['new' num2str(i) '.csv'])

[Shabnam M]

It works

many thanks!!

[Ameer Hamza]

Glad to be of help.

[Shabnam M]

May I ask another question,

If I want to add a header as {'x', 'y', 'u', 'v'} for each of new files, can you help me please,

thanks again

[Ameer Hamza]

Are you saving as csv?

[Shabnam M]

yes as .csv files with that sequence, however for each files I also need a header.

[Ameer Hamza]

try something like this

new{i} = array2table(new{i}, 'VariableNames', {'column1', 'column2', 'column3', 'column4'}); % write name of the columns
writetable(t, ['new' num2str(i) '.csv'], 'WriteVariableNames', 1)

[Shabnam M]

I really appreciate your help, Thank you so much