Combining .txt files and averaging data

I have multiple .txt files with the same type of data that I would like to merge

The first column is the same for each .txt file so I need to add the second column of the second .txt to the first .txt

I would also like to average the data of column 3 and 4 in the merged file for each row

Thanks in advance :)

[Rik]

That seems easy to do. What have you tried?

[Sophia]

I've looked extensively online but haven't been able to find a solution

Answer 1

[Rik]

You can get my readfile function from the FEX. If you are using R2017a or later, you can also get it through the AddOn-manager.

With that function you can read your file to a cell array (1 line per element).

Then you need to determine where your data starts.

Then you concatenate the data you want to put on 1 line.

Lastly, you can write the new file with fprintf:

fid=fopen(filename,'w');
fprintf(fid,'%s\n',cellstr_with_data{:});
fclose(fid);