How to compile two different array type into one variable

1 次查看（过去 30 天）
Morin De Jesus
Morin De Jesus 2024-5-5
回答： Suman 2024-6-17
rootdir = 'C:\Users\acer\Desktop\abc';
filelist = dir(fullfile(rootdir,'**\*.xlsx'));
X = []; Y = [];
for ii = 1:length(filelist)
filelist(ii).data = importdata(fullfile(filelist(ii).folder,filelist(ii).name));
filelist(ii).data = (filelist(ii).data(:,:));
end
% combine all the data, one after the other, vertically:
all_data = vertcat(filelist.data); %this is where the error lies, since the data file were struct and cell
% How to convert all struct to cell assuming I have multiple struct file.
  1 个评论
Stephen23
Stephen23 2024-5-5
编辑：Stephen23 2024-5-5
"How to compile two different array type into one variable"
What makes you think that the data can be meaningfully combined? It might be simple to combine, or it might be very complex (consisting of exception handling and special cases). We don't know.
Note that you should replace awful IMPORTDATA with a much better file-data importing function, e.g. READTABLE, READCELL, READMATRIX, or the like. Avoid IMPORTDATA.

请先登录，再进行评论。

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

回答（1 个）

Suman
Suman 2024-6-17
Hi Morin,
You need to first convert the struct to cell array to be able to concatenate them. You can use the 'struct2cell' function to achieve that. https://in.mathworks.com/help/matlab/ref/struct2cell.html
Also note that, in order to concatenate cell arrays, they must be of equal dimensions. In your case, the cell arrays in the data column are of unequal dimensions, so you must either pad the cell array with zeros or NaN to make the dimensions equal before you can concatenate them. Please refer to these MATLAB Answers to see the examples,

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by