Extracting values out of a cell array with tables
11 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Fabian Niederreiter
am 19 Apr. 2021
Kommentiert: Fabian Niederreiter
am 20 Apr. 2021
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 Kommentare
Akzeptierte Antwort
per isakson
am 20 Apr. 2021
Bearbeitet: per isakson
am 20 Apr. 2021
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 Kommentare
per isakson
am 20 Apr. 2021
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
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Characters and Strings finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!