MATLAB Answers

Create table of means from multiple tables

3 ビュー (過去 30 日間)
Moira Pryhoda
Moira Pryhoda 2021 年 9 月 8 日
回答済み: David Hill 2021 年 9 月 8 日
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.

採用された回答

dpb
dpb 2021 年 9 月 8 日
編集済み: dpb 2021 年 9 月 8 日
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);

その他の回答 (1 件)

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

タグ

製品


リリース

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by