Extracting values out of a cell array with tables
17 次查看(过去 30 天)
显示 更早的评论
I have a 41x1 cell array with tables including stock returns (find the cell array attached). The tables dimensions vary in number of columns.
I would now like to exctract all the data except column 1:3 from every table into one 1xXXX matrix.
Does anyone have a suggestion for a loop working throug my cell array that returns the described matrix?
0 个评论
采纳的回答
per isakson
2021-4-20
编辑:per isakson
2021-4-20
This script puts all the numerical data into a row vector (column-wise). You didn't say anything about order.
%%
load('CA.mat')
%%
XXX = [];
for jj = 1 : numel( DL12_10T )
tbl = DL12_10T{jj}(:,4:end);
num = table2array( tbl );
XXX = horzcat( XXX, reshape(num,1,[]) );
end
whos XXX
displays
Name Size Bytes Class Attributes
XXX 1x301836 2414688 double
3 个评论
per isakson
2021-4-20
It's possible to preallocate, but if the script is fast enough, why bother? It's easy to suppress the warning, which shows that you made a decision. If nothing else, preallocation adds a bit to the complexity of the code.
In this case you could preallocate a large XXX, and at the end remove any excess elements:
sas = whos('DL12_10T');
large_length = sas.bytes/8; % assuming double
XXX = nan( 1, large_length ); % physical memory shouldn't be a problem
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!