Creating a vector of tables

Question

Calum Henderson 2020-10-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/607506-creating-a-vector-of-tables

评论： madhan ravi 2020-10-8

I currently have a script that loops through a number of '.csv' files in a directory and creates a table with the data from each file:

    directory = dir(dirname);
    filenames = {directory(:).name}';
    csvfiles = filenames(endsWith(filenames,'.csv'));
    for i = 1:length(csvfiles)
        file = [char(dirname) '/' char(csvfiles(i))];
        CTLdata = readmatrix(file);
        table = array2table(CTLdata,...
            'VariableNames',{'Current','Voltage','Resistance'});
    end

It reads the files correclty, but my issue is that only the final table is saved for use. I would like to produce a "vector of tables" of sorts, and I have tried:

tables(i) = table

among other things but I have had no luck.

What is the best way for me to save the info from each file in a separate table?

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

Stephen23 2020-10-7

编辑：Stephen23 2020-10-7

在 MATLAB Online 中打开

Rather than getting all directory contents and filtering them afterwards, it is simpler to just get the required files in the first place:

S = dir(fullfile(dirname,'*.csv'));
csvfiles = {S.name};

You should be using fullfile instead of concatenating strings together (I fixed the cell indexing too):

file = fullfile(dirname,csvfiles{i});

https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-cell-array.html

And the answer to your qusetion is to use a cell array, just the the documentation recommends:

https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

请先登录，再进行评论。

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

Answer 1

Ameer Hamza 2020-10-7

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/607506-creating-a-vector-of-tables#answer_507861

在 MATLAB Online 中打开

Tables cannot be combined in a simple array. You need a cell array

    directory = dir(dirname);
    filenames = {directory(:).name}';
    csvfiles = filenames(endsWith(filenames,'.csv'));
    tables = cell(size(csvfiles))
    for i = 1:length(csvfiles)
        file = [char(dirname) '/' char(csvfiles(i))];
        CTLdata = readmatrix(file);
        table = array2table(CTLdata,...
            'VariableNames',{'Current','Voltage','Resistance'});
        tables{i} = table;
    end