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

1 vue (au cours des 30 derniers jours)
ahmed obaid
ahmed obaid le 31 Mar 2017
Commenté : ahmed obaid le 31 Mar 2017
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)

Connectez-vous pour répondre à cette question.

Réponse acceptée

Andrei Bobrov
Andrei Bobrov le 31 Mar 2017
Modifié(e) : Andrei Bobrov le 31 Mar 2017
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)];

Plus de réponses (0)

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by