1X1500 cell array to matrix
2 次查看(过去 30 天)
显示 更早的评论
I have 1500 .txt files containing 5 columns and 71022 rows. I converted them into 1x1500 cell array using import tool. Now the new table data has 1500 tables, each having 5 columns and 71022 rows. I want to have a 3-D matrix. How do I do that?
0 个评论
回答(2 个)
Adam Danz
2019-1-24
Since each matrix is the same size, here's an easy solution: If your cell array is named 'ca', 'm' will be your 3D array.
m = reshape(cell2mat(ca), 71022, 5, 1500);
How this works:
cell2mat() converts your 1x1500 cell into a 71022x(1500*5) matrix.
reshape() converts that matrix into a 3D array with 71022 rows, 5 columns, and 1500 pages.
12 个评论
Image Analyst
2019-1-25
Maybe there is a better way, like csvread(), importdata(), readtable(), textscan(), etc. where you don't have to mess with the complication of cell arrays.
Someone could probably tell you if you attach your text file.
Adam Danz
2019-1-25
My solution works when your variable is a cell array and each element of the cell array is a matrix. I'll need to look at your variable to help further. You could save your variable to a mat file and upload it here.
Bob Thompson
2019-1-24
You can try using cell2mat(), but I'm not intimately familiar with it enough to know if it will work with arrays inside each cell, or if you need to just have doubles.
Alternatively, you can always just use a loop:
for i = 1:size(cellarray,2)
3dmatrix(:,:,i) = cellarray{i};
end
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!