How to calculate the average columns values for a table in matlab ?
1 回表示 (過去 30 日間)
古いコメントを表示
Dear Experiences
i have a data table include numeric values .. i need to calculate the average values of table columns and then eliminate columns their average less than certain values (such as 0.002) , then write new table to new excel file. i will thanks any one can give a help on this duty ..
attached my portion of data table (when its imported to matlab using read table function)
0 件のコメント
採用された回答
Andrei Bobrov
2017 年 3 月 31 日
編集済み: Andrei Bobrov
2017 年 3 月 31 日
EDIT
x = readtable('test.xls');
k = .002;
t = varfun(@isnumeric, x,'OutputFormat','uniform');
x1 = x(:,t);
out = [x(:,~t), x1(:,varfun(@mean, x1,'OutputFormat','uniform') > k)];
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!