save column values of different multiple .txt files without overwriting in a for loop.

Question

Angana Borah 2019-9-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/480865-save-column-values-of-different-multiple-txt-files-without-overwriting-in-a-for-loop

评论： Angana Borah 2019-9-19

采纳的回答： KALYAN ACHARJYA

yr = [1951:2018]';

for j = 1:size(A)

fil = importdata([folder, A(j).name]);

file = dlmread(fullfile(folder , A(j).name));

for i = 1:size(yr,1)

a = find(file(:,1)==yr(i));

M(i,1) = sum(file(a,4));

end

I imported all files using 'dir' ansd stored in A. The problem is that Only Last file is getting operated on.

2 个评论
显示无隐藏无

KALYAN ACHARJYA 2019-9-18

Are you want to write M(i,1) data in txt file?

Angana Borah 2019-9-18

No. I want to bring the 4th column of all the files in the sructure to one data_array,M. Did you get my question? In the for loop, only the file file is getting read and sum of the column of only that file is calculated. Whereas, I want 4th column from all the files.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

KALYAN ACHARJYA 2019-9-18

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/480865-save-column-values-of-different-multiple-txt-files-without-overwriting-in-a-for-loop#answer_392370

在 MATLAB Online 中打开

I want to bring the 4th column of all the files in the sructure to one data_array,

Read the txt file one by one (As you mentioned you have done it sucessfully)
iter i=1
Extract the 4th column from i file
Save the column data in cell array
Repeat, iter 2

Step 3:

col_data{i}=writetable(column_data,['file_test',num2str(i),'.txt'])

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Angana Borah 2019-9-19

Thanks a lot. But I do not want to store column data from various files in different .txt files but want to input in the different columns of the same matrix if that is possible.

请先登录，再进行评论。