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