How to calculate the average columns values for a table in matlab ?

1 次查看（过去 30 天）
ahmed obaid
ahmed obaid 2017-3-31
评论： ahmed obaid 2017-3-31
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)

请先登录，再回答此问题。

采纳的回答

Andrei Bobrov
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!

Translated by