0 个投票

Hello to all,
I'm quite new in Matlab. How can I open multiple *.tsv files stored in one folder? I have several files ordered by date and I want to open some or all of them to create a chat with the data evolution with time. Right now I'm openning one by one but I guess this can be done automatically.
Thanks

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

 采纳的回答

Kojiro Saito
Kojiro Saito 2021-3-26

1 个投票

datastore might fit your case.
If your PC has enought memory (RAM) to store all tsv files in workspace at once, you can use readall function.
For example, suppose tsv files are located in data directory and each tsv has column name col1, you can calculate the mean by the following.
ds = datastore('data/*.tsv', 'Type', 'tabulartext', 'FileExtensions', '.tsv');
t = readall(ds);
m = mean(t.col1);
Or, if the RAM is not sufficient, you can read by a chunk.
ds = datastore('data/*.tsv', 'Type', 'tabulartext', 'FileExtensions', '.tsv');
sums = [];
counts = [];
while hasdata(ds)
t = read(ds);
sums(end+1) = sum(t.col1);
counts(end+1) = length(t.col1);
end
m = sum(sums)/sum(counts);
alternatively, you can also use tall array.
ds = datastore('data/*.tsv', 'Type', 'tabulartext', 'FileExtensions', '.tsv');
tt = tall(ds);
m = gather(mean(tt.col1));

更多回答（1 个）

Mário Sobrinho
Mário Sobrinho 2021-3-26

0 个投票

Hi Kojiro,
Thank you for your answer.

类别

在 帮助中心 和 File Exchange 中查找有关 MATLAB Report Generator 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by