Create table of means from multiple tables

36 visualizzazioni (ultimi 30 giorni)
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.

Risposta accettata

dpb
dpb il 8 Set 2021
Modificato: dpb il 8 Set 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);

Più risposte (1)

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

Categorie

Scopri di più su Simulink in Help Center e File Exchange

Tag

Prodotti


Release

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by