MATLAB Answers

How to import to Matlab many text files as table type

12 views (last 30 days)
José Fonseca
José Fonseca on 30 May 2020
Commented: Walter Roberson on 1 Jun 2020
I have about 30 .txt files and I need to plot the data of each files using Matlab. I don't know how to import each of them as a table type (using the readtable function, maybe), solving this problem would help me for creating a loop that allows me to plot each imported file (I also don't have idea how to create this loop, in order to select each imported table).

  5 Comments

Show 2 older comments
Sindar
Sindar on 31 May 2020
Beyond the file extension, do they all store the data in the same way? Number and order of columns, data types, delimeters
José Fonseca
José Fonseca on 31 May 2020
Sindar No, all of them are numeric values, but they can have different numer of rows and columns

Sign in to comment.

Answers (1)

Walter Roberson
Walter Roberson on 1 Jun 2020
projectdir = 'directory the files are in';
dinfo = dir(fullfile(projectdir, '*.txt')); %use appropriate extension
filenames = fullfile(projectdir, {dinfo.name});
nfiles = length(filenames);
tables = cell(nfiles,1);
for K = 1 : nfiles
tables{K} = readtable(filenames{K});
%you could plot tables{K} here
end
%or you could plot elements of tables here
for K = 1 : nfiles
thisfile = filenames{K};
[~, basename, ~] = fileparts(thisfile);
plot(tables{K}.Time, tables{K}.Resistance, 'Displayname', basename);
hold on
end
hold off
legend show

  2 Comments

Sindar
Sindar on 1 Jun 2020
Since the number of columns might vary, the only thing I'd add is that this will plot all later columns against the first:
plot(tables{K}{:,1}, tables{K}{:,2:end}), 'Displayname', basename);
Walter Roberson
Walter Roberson on 1 Jun 2020
True. Unfortunately the legend will not be all that useful in that situation.

Sign in to comment.

Products


Release

R2019b

Translated by