generating an array from the same element across several tables

2 次查看(过去 30 天)
Hi,
I have n similar tables (same structure, different data).
I have collected all tables in a cell array, so that Tarray{1} gives the first table, Tarray{2} gives the 2nd table and so on.
Tarray{i}{2,3} gives the content (a scalar value) of the element of table i, row 2, column 3.
I would like to create an array from the scalar values contained in position (2,3) across all tables. This can be done with the following code:
array = zeros(length(Tarray),1);
for ii = 1:length(Tarray)
array(ii) = Tarray{ii}{2,3};
end
Is there a better/faster way to do that?
Thanks!

采纳的回答

Sanskar
Sanskar 2023-6-14
编辑:Sanskar 2023-6-15
Hi Matteo!
What I understood from your question is that you want to extract elements from all tables of the given position.
The method which you are using is fast one only. Also you can look through the below code, which may also work.
% initialize cell array
Tarray = cell(1, n);
% populate cell array with tables
for i = 1:n
Tarray{i} = readtable("table_" + i + ".csv");
end
% use cellfun to extract scalar value from each table
arr = cellfun(@(table) table{2, 3}, Tarray);
cell(n) returns an n-by-n cell array of empty matrices.
cellfun(func,C) applies the function func to the contents of each cell of cell array C, one cell at a time. cellfun then concatenates the outputs from func into the output array A, so that for the ith element of C, A(i) = func(C{i}). The input argument func is a function handle to a function that takes one input argument and returns a scalar. The output from func can have any data type, so long as objects of that type can be concatenated. The array A and cell array C have the same size.
Please refer to these documentation for more information on 'cell' and 'cellfun':
Hope this answer your query.
  2 个评论
Matteo Tomasini
Matteo Tomasini 2023-6-14
Hi Sanskar,
thanks, that works!
My attempt to use cellfun was unsuccessful because I put {2, 3} at the end, after Tarray, instead of after table, as you correctly did!
Dyuman Joshi
Dyuman Joshi 2023-6-14
Note that cellfun is slower than a for loop with pre-allocation
%Sample data
x = (1:5)';
y = (x.^2);
z = -x;
%Table
T = table(x,y,z)
T = 5×3 table
x y z _ __ __ 1 1 -1 2 4 -2 3 9 -3 4 16 -4 5 25 -5
%Cell array defined by repeating the same table array
C = repmat({T},1,1e2);
%cellfun
tic
for k=1:1e3
out = cellfun(@(x) x{2,3}, C);
end
timecellfun=toc
timecellfun = 2.8915
%loop with preallocation
tic
for k=1:1e3
array = zeros(length(C),1);
for ii = 1:length(C)
array(ii) = C{ii}{2,3};
end
end
timelooppre=toc
timelooppre = 2.3432
%Comparing outputs
isequal(out,array')
ans = logical
1

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Matrices and Arrays 的更多信息

标签

产品


版本

R2022b

Community Treasure Hunt

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

Start Hunting!

Translated by