Reading multiple txt files and placing numerical data in a matrix

3 次查看（过去 30 天）
Iacopo
Iacopo 2022-4-24
评论： Iacopo 2022-4-26
Hi all, I'm trying to read multiple file text without the header and pile up their numerical content. I have attached an example txt file.
Here is the basic code I use:
[filename,pathname,d]=uigetfile('*.txt','MultiSelect','on');
filepath=fullpath(pathname,filename);
a=readtable(filepath);
a=table2array(a);
It works for 1 fIle but gives an error for more files selected. And then once I imported correctly multiple files, how do I pile their numerical content? I guess have to insert that in a for cycle. Bear in mind that different files can have different number of columns and rows.
Thanks in advance to anyone who will help me
  4 个评论
显示 2更早的评论
Jan
Jan 2022-4-25
"but gives an error for more files selected" - whenever you mention an error in the forum, attach a copy of the complete error message instead of letting the readers guess, what you can see already.
Jeremy Hughes
Jeremy Hughes 2022-4-25
a = readtable(filepath);
a = table2array(a);
Should be equivalent to:
a = readmatrix(filepath)

请先登录，再进行评论。

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

回答（1 个）

Jan
Jan 2022-4-25
See: FAQ: How can I process a sequence of files?
[filename, pathname] = uigetfile('*.txt','MultiSelect','on');
filename = cellstr(filename);
data = [];
for k = 1:numel(filename)
filepath = fullpath(pathname,filename);
tab = readtable(filepath);
data = cat(1, data, table2array(tab));
end
  5 个评论
显示 3更早的评论
Jan
Jan 2022-4-26
@lacopo: I've copied "fullpath" from your example in the question. Maybe "fullfile" is meant.
Iacopo
Iacopo 2022-4-26
@Jan you're right, my bad. I modified the piece of code but it doesn't work for more than 1 file. I changed the class of filepath to string to make the readtable function work:
[filename, pathname] = uigetfile('*.txt','MultiSelect','on');
filename = cellstr(filename);
data = [];
for k = 1:numel(filename)
filepath = string(fullfile(pathname,filename));
tab = readtable(filepath);
data = cat(1, data, table2array(tab));
end
If I select 2 files (I just created a copy of my file and selected both the original and the copy) and it gives me the following error:
Error using readtable
"filename" must be a string scalar or character vector.
Error in..
tab = readtable(filepath);

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Workspace Variables and MAT Files 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by