How to convert a table to a 2d array

Question

waleed khalid 2020-11-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/637570-how-to-convert-a-table-to-a-2d-array

编辑： dpb 2020-11-5

I have 25 csv files that I have I have taken and stored into a temp Table, which was then vertically concatenated into a large table, I want to convert this large table (rpll) into a 2d array so that I can access the row values with a for-loop, what would be the best way of doing this?

       rpll=cell(1,data.numberofselected); %Table of all selected csv's ordered by run number aescending
        x=cell(1, numel(dir(file_location))); %temp table to store each run which is then concatenated into one large table after this for-loop
        for i=1:data.numberofselected
           concatenated=strcat(strcat(strcat(file_location,'RUN'),string(data.selected_runs(i))),'.csv');
           x{i}=readtable(concatenated);
            
        end
        rpll=vertcat(x{:}); %convert into 2d array
      
        for lp = 1:data.numberofselected
            i = data.selected_runs(lp);  
                switch(rpll(3)) ......   %I want to check the 3rd value in every row

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

dpb 2020-11-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/637570-how-to-convert-a-table-to-a-2d-array#answer_535435

在 MATLAB Online 中打开

Don't make a cell array of tables to start with...

x=[];
for i=1:data.numberofselected
  concatenated=strcat(strcat(strcat(file_location,'RUN'),string(data.selected_runs(i))),'.csv');
  x=[x;readmatrix(concatenated)];
end

2 个评论
显示无隐藏无

waleed khalid 2020-11-5

This obfuscates my data to a mix of 0's and 0.0010's.

dpb 2020-11-5

编辑：dpb 2020-11-5

Well, that's what you asked for -- a 2D array. If data have disparate ranges, MATLAB displays scaled values at command line depending upon what you choose for the FORMAT specifier.

We don't have/can't see your data from here so: