MATLAB Answers

Create table of means from multiple tables

3 views (last 30 days)
Moira Pryhoda
Moira Pryhoda on 8 Sep 2021
Answered: David Hill on 8 Sep 2021
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;

Tags

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!