How to manipulate a series of .csv files after reading it inside a for loop?

I am trying to read a series of.csv files and then trying to extract a particular row depending on a specific value of 1st 2 columns and then writing that particular row in another .csv file. That specific row has to be extracted from each of the input files and then the output file should contain all the extracted rows. But in my code , it is taking only the last file of the series. How can I get it for all the input files? I am attaching a pic of my code. Thank you.

[Benjamin Thompson]

Have you tried stepping through the code to see what is happening using the MATLAB editor? To get help you should post the code and some sample CSV files.

[JOYA GHOSH DASTIDER]

d=dir('*_rain.csv');
n=length(d);
data=cell(n,1);
for i = 1:n
    data{i}=csvread(d(i).name,1,0);
    file = data{i};
    ind1 = file(:,1) == 91.75 & file(:,2) == 26.25 ;
    a = file(ind1,:);
    fid = fopen('sorted.txt','a+');
    fprintf(fid, '%f\n',a);
    fclose(fid);
    
end

[JOYA GHOSH DASTIDER]

sample files:

[JOYA GHOSH DASTIDER]

I was checking at different steps inside the loop. The three iterations were going on but atlast the file variable takes only the last file from data cell and execute the operation.

I am new in MATLAB. So not sure if I am using proper syntex or there may be some problem with indexing.

first the data cell storing all the .csv files in it . then I am trying to get data{i} in file variable in each iteration and to extract that one row and write it in a separate output file.

so after completing the whole loop, the output file should contain all the extracted rows in it.(example:3 rows for three input files and column same as the no of columns in the input file.)

Answer 1

[DGM]

It seems to be picking up and writing all three lines to the file. The output formatting is messed up, but it's all there.

I edited the fprintf() call:

d = dir('*_rain.csv');

n = length(d);
data = cell(n,1);
for i = 1:n
    data{i} = csvread(d(i).name,1,0);
    file = data{i};
    
    ind1 = file(:,1) == 91.75 & file(:,2) == 26.25;
    a = file(ind1,:);
    
    fid = fopen('sorted.txt','a+');
    fprintf(fid, [repmat('%f, ',1,11) '%f\n'],a.');
    fclose(fid);
end

I attached the output file.

[JOYA GHOSH DASTIDER]

It's working . Thank you very much.