Create table of means from multiple tables

19 views (last 30 days)
I have 3 tables (204x32), each with the same column headers. I'd like to take the mean of each cell and create a new table with these means. For example, the first row and first column of output table T would be: T = (T1(1,1), T2(1,1), T3(1,1))/3. Thanks in advance for any help.

Accepted Answer

dpb
dpb on 8 Sep 2021
Edited: dpb on 8 Sep 2021
Simplest probably would be to convert to a 3D array and then use mean() along the third dimension....
tMeans=mean(cat(3,table2array(T1),table2array(T2),table2array(T3)),3);

More Answers (1)

David Hill
David Hill on 8 Sep 2021
temp=T1.Properties.VariableNames;
T=array2table((T1{:,:}+T2{:,:}+T3{:,:})/3);
T.Properties.VariableNames=temp;

Categories

Find more on Simulink in Help Center and File Exchange

Tags

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!